Database

Last updated 9 months ago
amber db
The database or db command is one of the most common command that you will be operating. This command allows you to work with the database engine of choice when the Amber application was generated.
Here is a list of the commands available:
create Creates the database for the environment specified in your configuration file.
drop   Drops the database for the environment specified in your configuration file.
migrate or m Migrates up or down the database version
rollback Rolls back your database to a specific version or to previous version
redo Repeats the database version specified or lasted version
status Prints the current database migration status
seed Adds initial data after a database is created
version Prints the database current version.
amber database [COMMANDS1 COMMANDS2...]
​
Arguments:
  COMMANDS (Accepts multiple)  drop create migrate rollback redo status version seed
Example Usages
Create
$ amber db create
Created database blog_development
Starting with version 0.3.5 - Amber made two changes regarding databases:
Amber will substitute hyphens - for underscores _ in database names  to keep it PostgreSQL friendly.
The default user for pg databases is postgres rather than rootin your configuration file.
postgres://postgres:@localhost:5432/microsecond_blog_development
$ amber new microsecond-blog
$ cd microsecond-blog
$ amber db create
Created database microsecond_blog_development
Drop
$ amber db drop
Dropped database blog_development
Migrate
$ amber db migrate
Migrating db, current version: 0, target: 20170928204246
OK   20170928204246_create_post.sql
Rollback
$ amber db rollback
Migrating db, current version: 20170928204246, target: 0
OK   20170928204246_create_post.sql
Redo
$ amber db redo
Migrating db, current version: 20170928204246, target: 0
OK   20170928204246_create_post.sql
Migrating db, current version: 0, target: 20170928204246
OK   20170928204246_create_post.sql
Status
$ amber db status
Applied At                  Migration
=======================================
2017-09-28 20:44:22 UTC  -- 20170928204246_create_post.sql
Seed
$ amber db seed
Seeded database
Version
$ amber db version
20170928204246
Generate
Watch