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 /populate.sqlite3 | |
| 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 'populate.sqlite3')
| -rw-r--r-- | populate.sqlite3 | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/populate.sqlite3 b/populate.sqlite3 new file mode 100644 index 0000000000..e200d2b49c --- /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 |