about summary refs log tree commit diff
path: root/README.md
diff options
context:
space:
mode:
authorWilliam Carroll <wpcarro@gmail.com>2020-07-28T17·42+0100
committerWilliam Carroll <wpcarro@gmail.com>2020-07-28T17·47+0100
commit191205acaca88a059a824a2e5e22ab559293a3f1 (patch)
treeded3e0c2d1ea2a7bfcc4261e8f2b9fc5fe05c887 /README.md
parent36a2fea6863e692d815a513d4b0f15b8c1fcb886 (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.md31
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;
 ```