Database
amber db
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
ordown
the database versionrollback 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 ispostgres
rather thanroot
in 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
Last updated