Skip to content

Latest commit

 

History

History
89 lines (75 loc) · 1.13 KB

DEVNOTES.md

File metadata and controls

89 lines (75 loc) · 1.13 KB

Development Notes

Endpoints

/
/redoc
/swagger
/openapi
/docs/*
/api/*
/api/db/{schema}/{table}

/api/meta/{schema}/{table}/columns
/api/meta/
=> schemas
/api/meta/{schama}/
=> tables
/api/db
/api
=> schemas []
/api/{schema}
=> table []
/api/{schema}?meta
/api/{schema}/{table}/
/api/{schema}/{table}/column

/list-tables
# [customer,setup,system]
/list-columns/{schema}/{table}
# [id,name,created]
/list-table-meta
# {"customer": [id,name,created]}
/select/{schema}/{table}?name=SSW&__resolved__=true&__max__=100
# []
/select/{schema}/{table}/{id}
# {}

172.20.13.183 / 184

Meta and Documentation

/status
/openapi
/redoc
/swagger

Background

SELECT * FROM pg_catalog.pg_tables;
SELECT *
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'

Body

{
  "resolve_depth": 0,
  "columns": ["string"],
  "filter": [
    [
      ["key", "op", "value"]
    ]
  ],
  "object": {
    "key": "any"
  },
  "affected": 1,  // 
}
filters=[["id", "==", "0"], "or", [[["id", "==", "0"], "and", [["id", "==", "0"]]]]]