diff options
author | William Carroll <wpcarro@gmail.com> | 2020-07-28T17·42+0100 |
---|---|---|
committer | William Carroll <wpcarro@gmail.com> | 2020-07-28T17·47+0100 |
commit | 191205acaca88a059a824a2e5e22ab559293a3f1 (patch) | |
tree | ded3e0c2d1ea2a7bfcc4261e8f2b9fc5fe05c887 /README.md | |
parent | 36a2fea6863e692d815a513d4b0f15b8c1fcb886 (diff) |
Create populate.sqlite3 to simplify README
To make my life easier, I created a small sqlite3 script to populate our database.
Diffstat (limited to 'README.md')
-rw-r--r-- | README.md | 31 |
1 files changed, 7 insertions, 24 deletions
diff --git a/README.md b/README.md index 2e5f2f18de0e..bf81a772b2ea 100644 --- a/README.md +++ b/README.md @@ -34,34 +34,17 @@ Create a new database named `db.sqlite3` with: $ sqlite3 db.sqlite3 ``` -Initialize the schema with: +Populate the database with: ``` -sqlite> .read src/init.sql +sqlite3> .read populate.sqlite3 ``` -You can verify that you successfully initialized the database by running: +You can verify that everything is setup with: ``` -sqlite> .tables -sqlite> .schema Accounts -sqlite> .schema Trips -``` - -Populate the database with some dummy values using the following: - -``` -sqlite> PRAGMA foreign_keys = on; -sqlite> .mode csv -sqlite> .import data/accounts.csv Accounts -sqlite> .import data/trips.csv Trips -``` - -You can verify you successfully populated the tables with: - -``` -sqlite> .mode columns -sqlite> .headers on -sqlite> SELECT * FROM Accounts; -sqlite> SELECT * FROM Trips; +sqlite3> .tables +sqlite3> .schema +sqlite3> SELECT * FROM Accounts; +sqlite3> SELECT * FROM Trips; ``` |