refactor

1 files changed, 22 insertions, 0 deletions

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"
+});