about summary refs log tree commit diff
path: root/users/wpcarro/assessments/tt/populate.sqlite3
diff options
context:
space:
mode:
Diffstat (limited to 'users/wpcarro/assessments/tt/populate.sqlite3')
-rw-r--r--users/wpcarro/assessments/tt/populate.sqlite37
1 files changed, 7 insertions, 0 deletions
diff --git a/users/wpcarro/assessments/tt/populate.sqlite3 b/users/wpcarro/assessments/tt/populate.sqlite3
new file mode 100644
index 0000000000..e200d2b49c
--- /dev/null
+++ b/users/wpcarro/assessments/tt/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