seapunk / grater Goto Github PK

database initialization:

1. /schema.sql or /schema/ directory (schema .sql files are executed in alphabetic order)
2. /seeds.sql or /seeds/ directory (alphabetic order)

migrations:

• /migrations/ folder, format is TIMESTAMP_NAME.sql
  • TIMESTAMP is the current UTC time, in YYYYMMDDHHMMSS, like Rails' ActiveMigration
  • TIMESTAMP is also essentially the id of the migration, so there cannot be multiple migrations with the same timestamp
  • NAME is the description of the migration (no format in particular)
• schema migrations are kept track of in schema_migrations table of the database
• grater migrate [TIMESTAMP] - migrates schemas. runs all migrations that have not been run (load schema_migrations folder). if timestamp is provided, then that specific migration is run (and error thrown if grater notices that the migration has been run before, saying you gotta run it with --force)

• schemas
• seeds
• migrations w/ grater migrate (no specific timestamp)
• config (how are we doing configuration???)
• grater init new, grater init fresh