anderbubble / coddex Goto Github PK

Select PK+{column}

/schemas/$SCHEMA/tables/$TABLE/rows/?key=value

• POST new tables to
  • /schemas/$schema/tables
• GET /schemas/$schema/tables/$table
  • handle GET of missing table (404)
• PUT
  • new/existing table at /schemas/$schema/tables/$table
• DELETE /schemas/$schema/tables/$table
  • handle DELETE missing table
  • warn for DELETE table with rows
• HTML
  • POST from root and schema views
  • DELETE from root and schema views
  • PUT from root and schema views
  • HTML for GET

e.g., information_schema is hidden by default.

Provide a visual autogen of the db uri as a user/password/hostname/db form is filled out.

Don't generate urls in JavaScript. Generate them in Python and pass the url to JavaScript.

Selects.

• handle adding a table that already exists
• handle deleting a table that doesn't exist
• unit tests for everything

/schemas/$SCHEMA/views/$VIEW

HTML access from / (CD) and /schemas/$SCHEMA (CD).

/queries?

/schemas/$schema/tables/$table/columns/$column

/schemas/$SCHEMA

Edge cases to consider:

• missing schema for GET, DELETE
• existing schema for PUT
• contained tables for DELETE

Inserts.