From 7d40cba8ec335f95ce9bd3eaf9ff5c1a2770d704 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Wed, 1 Nov 2017 23:09:00 +0100 Subject: switch to sqlite --- server/db.js | 17 +++++++---------- 1 file changed, 7 insertions(+), 10 deletions(-) (limited to 'server') diff --git a/server/db.js b/server/db.js index d921243..abb61e7 100644 --- a/server/db.js +++ b/server/db.js @@ -1,17 +1,14 @@ var Sequelize = require("sequelize"), - config = require("../config.json"), - pg = require('pg'); + config = require("../config.json"); var db = module.exports = {} -var DATABASE_URL = process.env.DATABASE_URL || ('postgres://postgres:postgres@localhost:5432/' + config.name) +// var DATABASE_URL = process.env.DATABASE_URL || ('postgres://postgres:postgres@localhost:5432/' + config.name) -var match = DATABASE_URL.match(/postgres:\/\/([^:]+):([^@]+)@([^:]+):(\d+)\/(.+)/) +// var match = DATABASE_URL.match(/postgres:\/\/([^:]+):([^@]+)@([^:]+):(\d+)\/(.+)/) -db.sequelize = new Sequelize(match[5], match[1], match[2], { - dialect: 'postgres', - protocol: 'postgres', - port: match[4], - host: match[3], - logging: true //false +db.sequelize = new Sequelize('mainDB', null, null, { + dialect: 'sqlite', + logging: false, + storage: 'protocols.sqlite', }) -- cgit v1.2.3-70-g09d2