let's see if we can get Heroku to create the schema for us

2 files changed, 27 insertions, 1 deletions

diff --git a/app.json b/app.json
index 4d1b3f2..10cc28d 100644
--- a/app.json
+++ b/app.json
@@ -1,5 +1,8 @@
 {
   "addons": [
     "heroku-postgresql:hobby-dev"
-  ]
+  ],
+  "scripts": {
+    "postdeploy": "node db/bootstrap.js"
+  }
 }
diff --git a/db/bootstrap.js b/db/bootstrap.js
new file mode 100644
index 0000000..009211f
--- /dev/null
+++ b/db/bootstrap.js
@@ -0,0 +1,23 @@
+var pg = require('pg');
+var fs = require('fs');
+
+pg.connect(process.env.DATABASE_URL, function(err, client, done) {
+  if (err) {
+    return console.error('Unable to connect to datbase', err);
+  }
+
+  fs.readFile('schema.sql', function(err, sql) {
+    if (err) {
+      return console.error('Unable to read SQL file', err);
+    }
+
+    client.query(sql, function(err) {
+      if (err) {
+        return console.error('Error running SQL query', err);
+      }
+
+      console.log('Database created');
+      done();
+    });
+  });
+});