From c0888fab024cc9f7c99812bfabf9d7774312dbf7 Mon Sep 17 00:00:00 2001 From: Adam Soltys Date: Wed, 11 Mar 2020 15:10:40 -0700 Subject: refactor --- db/index.js | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 db/index.js (limited to 'db/index.js') diff --git a/db/index.js b/db/index.js new file mode 100644 index 00000000..dac6924e --- /dev/null +++ b/db/index.js @@ -0,0 +1,22 @@ +const Sequelize = require("sequelize"); +const conf = config.dbOptions; + +db = new Sequelize(conf.database, conf.username, conf.password, { + host: conf.host, + dialect: conf.dialect, + logging: false, + dialectOptions: { multipleStatements: true } +}); + +require("./models/users.js"); +require("./models/payments.js"); + +db["User"].hasMany(db["Payment"], { + as: "payments", + foreignKey: "user_id" +}); + +db["Payment"].belongsTo(db["User"], { + as: "user", + foreignKey: "user_id" +}); -- cgit v1.2.3