RPC front end implementation

[seancolsen]

Database page

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/schemas/	GET	schemas.list	✅	✅
/api/db/v0/schemas/	POST	schemas.add	✅	✅
/api/db/v0/schemas/{schemaId}/	PATCH	schemas.patch	✅	✅
/api/db/v0/schemas/{schemaId}/	DELETE	schemas.delete	✅	✅

Schema page

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/	GET	tables.list	✅	✅
/api/db/v0/tables/	POST	tables.add	✅	✅
/api/db/v0/tables/{tableId}/	PATCH	tables.patch	✅	✅
/api/db/v0/tables/{tableId}/	DELETE	tables.delete	✅	✅

Table page load

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/columns/	GET	columns.list	✅	✅
/api/db/v0/tables/{tableId}/constraints/	GET	constraints.list	✅	✅
/api/db/v0/tables/{tableId}/joinable_tables/	GET	tables.list_joinable	✅	✅

Records listing

Replacing GET /api/db/v0/tables/{tableId}/records/ with records.list

Feature	Backend	Frontend
Basic	✅	✅
Pagination	✅	✅
Sorting	✅	✅
Filtering	✅	✅
Grouping	✅	✅
Record summaries (non-configurable)	✅	✅

Record selector

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/records/	GET	records.search	✅	✅

Table page DML

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/records/	POST	records.add	✅	✅
/api/db/v0/tables/{tableId}/records/{recordPk}/	PATCH	records.patch	✅	✅
/api/ui/v0/tables/{tableId}/records/delete/	DELETE	records.delete	✅	✅

Table page DDL

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/columns/	POST	columns.add	✅	✅
/api/db/v0/tables/{tableId}/columns/{columnId}	PATCH	columns.patch	✅	✅
/api/db/v0/tables/{tableId}/columns/{columnId}	DELETE	columns.delete	✅	✅
/api/db/v0/tables/{tableId}/constraints/	POST	constraints.add	✅	✅
/api/db/v0/tables/{tableId}/constraints/{id}	DELETE	constraints.delete	✅	✅
/api/db/v0/links/	POST	data_modeling.add_foreign_key_column, data_modeling.add_mapping_table	✅	✅
/api/db/v0/tables/{tableId}/move_columns/	POST	data_modeling.move_columns	✅	✅
/api/db/v0/tables/{tableId}/split_table/	POST	data_modeling.split_table	✅	✅

Table page metadata

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/settings/{settingsId}/	PATCH	tables.metadata.set	✅	✅
/api/db/v0/tables/{tableId}/columns/{columnId}	PATCH	columns.metadata.set	✅	✅

Explorations

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/	GET	tables.get	✅	✅
/api/db/v0/queries/run/	POST	explorations.run	✅	✅
/api/db/v0/queries/	GET	explorations.list	✅	❌
/api/db/v0/queries/{queryId}/	GET	explorations.get	✅	❌
/api/db/v0/queries/{queryId}/results/	GET	explorations.run_saved	✅	❌
/api/db/v0/queries/	POST	explorations.add	✅	❌
/api/db/v0/queries/{queryId}/	PUT	explorations.replace	✅	❌
/api/db/v0/queries/{queryId}/	DELETE	explorations.delete	✅	❌

Record page

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/records/{recordPk}/	GET	records.get	✅	✅

Import pages

Endpoint	HTTP Method	Function	Backend	Frontend
/api/db/v0/tables/{tableId}/previews/	POST	tables.get_import_preview	✅	✅
/api/db/v0/tables/{tableId}/type_suggestions/	GET	data_modeling.suggest_types	✅	✅