aboutsummaryrefslogtreecommitdiff
path: root/db/bootstrap.js
blob: 009211f5616206ecfdc5d713e9a55794db644e13 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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();
    });
  });
});