jobstoit / gqb Goto Github PK

• Comments in SQL need to be with "--" instead of "//"
• On creating a table the contents need to be in "(" instead of "{"
• PRIMARY must be "PRIMARY KEY". ref
• DEFAULT must have either string value or int value but not lose letters. ref.
• NULLABLE is not a thing! you must make the variables that are not nullable "NOT NULL". ref.
• Datetime is not a datatype, "timestamp" is in Postgres. ref.
• Enum doesn't work for each database. This should be noted as an error when the driver is set to a database that doesn't support that but enums are configured.

Create a package that automatically initialises the database in any given project.

This issue depends on #6

Restructure project in logical order for better view

Create a function that can set one configuration model against another and generate the (non breaking) migration SQL that will set the database to the newer model.

Create a function that when the database is given it creates a Model like the one form the configuration.

Make a database seeder in the model.
The configuration markdown will have to look like this:

seeds:
  user:
    fields: firstname, lastname, role
    values:
    - Job, Stoit, ADMIN
    - Dwane, Jonson, CUSTOMER