PR: Implement Parser (getSchema() API)

[amilajack]

We need falcon-core to return a graph representation of the database. The implementation should work for SQLite initially. We need to agree on a JSON representation for the graph representation.

sqleton has code for getting the relationships for SQLite

See https://github.com/falcon-client/falcon/issues/22 for the UI implementation.

We'll need this AST parser for the SQL syntax to easily get the constraints and other data. See this website for an example of the AST

Proposed API:

getSchema: (tableName: string) => Promise<Array<{
  columnName: string,
  type: 'int' | 'string', // etc
  default: string,
  constraints: Array<{
    type: 'min' | 'autoIncrements' | 'foreignKey', // etc
    metadata: { [key: string]: any }
  }>
}>>

All sqlite constraints:

A set of SQL constraints for each table. SQLite supports UNIQUE, NOT NULL, CHECK and FOREIGN KEY constraints.

Tasks

• [ ] Implement parser
• [ ] Add unit tests

getTablePropertiesSql() dropTable()

• Use codeschool's parser to generate ASTs
• use AST to edit sql statements for schema manipulation
  • Because sqlite doesn't allow schema manipulation so it's necessary to create a new table, edit scehma, and import schema/table values to new table
• Handle syntax error
• for now just use the parser to parse out create statement to obtain schema

[amilajack]

@jooohhn what are your thoughts on the API?

[jooohhn]

Wouldn't this method be called with a table to return its schema? i.e. getSchema: (tableName: string)

[amilajack]

Agreed!