about summary refs log tree commit diff
path: root/populate.sqlite3
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 /populate.sqlite3
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 'populate.sqlite3')
-rw-r--r--populate.sqlite37
1 files changed, 7 insertions, 0 deletions
diff --git a/populate.sqlite3 b/populate.sqlite3
new file mode 100644
index 000000000000..e200d2b49c02
--- /dev/null
+++ b/populate.sqlite3
@@ -0,0 +1,7 @@
+PRAGMA foreign_keys = on;
+.read src/init.sql
+.mode csv
+.import data/accounts.csv Accounts
+.import data/trips.csv Trips
+.mode column
+.headers on
\ No newline at end of file