summaryrefslogtreecommitdiff
path: root/labs/1/run.sh
diff options
context:
space:
mode:
Diffstat (limited to 'labs/1/run.sh')
-rw-r--r--labs/1/run.sh6
1 files changed, 6 insertions, 0 deletions
diff --git a/labs/1/run.sh b/labs/1/run.sh
new file mode 100644
index 0000000..1cca564
--- /dev/null
+++ b/labs/1/run.sh
@@ -0,0 +1,6 @@
+#!/bin/sh
+
+./bin/console -c 'CREATE TABLE people (id integer, address varchar(20), phone_number varchar(15));'
+./bin/console -c "INSERT INTO people values (10, '123 sesame street', '7803333222');"
+./bin/console -c "INSERT INTO people values (11, '1 university drive', '7805555444');"
+./bin/console -c "SELECT * FROM people;"