aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorAdam Soltys <[email protected]>2022-09-06 09:20:25 -0700
committerAdam Soltys <[email protected]>2022-09-06 09:20:25 -0700
commitc2464b2407ee23134732fd67586758dbfe18f9b5 (patch)
tree3e2d9f009bb325a9a7c4304ea02f6e64dda85bd1 /db
parent8a080ef9a198799e7ee31cf81f92afd5495e4074 (diff)
downloadcoinos-server-c2464b2407ee23134732fd67586758dbfe18f9b5.tar.gz
coinos-server-c2464b2407ee23134732fd67586758dbfe18f9b5.zip
prettier
Diffstat (limited to 'db')
-rw-r--r--db/db.js26
-rw-r--r--db/index.js66
2 files changed, 44 insertions, 48 deletions
diff --git a/db/db.js b/db/db.js
index 2d73723f..06fdac89 100644
--- a/db/db.js
+++ b/db/db.js
@@ -1,17 +1,13 @@
-import Sequelize from '@sequelize/core';
-import dbOptions from '../config/knexfile';
+import Sequelize from "@sequelize/core";
+import dbOptions from "../config/knexfile";
-let { database, user, password, host } = dbOptions[process.env.NODE_ENV].connection;
-
-export default new Sequelize(
- database,
- user,
- password,
- {
- host,
- dialect: "mariadb",
- logging: false,
- dialectOptions: { multipleStatements: true, timezone: "Etc/GMT+7" },
- }
-);
+let { database, user, password, host } = dbOptions[
+ process.env.NODE_ENV
+].connection;
+export default new Sequelize(database, user, password, {
+ host,
+ dialect: "mariadb",
+ logging: false,
+ dialectOptions: { multipleStatements: true, timezone: "Etc/GMT+7" }
+});
diff --git a/db/index.js b/db/index.js
index a7d7c25c..a98b6576 100644
--- a/db/index.js
+++ b/db/index.js
@@ -1,123 +1,123 @@
-import Sequelize from '@sequelize/core';
+import Sequelize from "@sequelize/core";
import db from "$db/db";
-db.authenticate().catch((err) => {
+db.authenticate().catch(err => {
console.debug("Error connecting to database: " + err.message);
console.log(dbOptions.connection.database + "." + dbOptions.connection.user);
});
-import './models/accounts';
-import './models/codes';
-import './models/deposits';
-import './models/invoices';
-import './models/keys';
-import './models/payments';
-import './models/orders';
-import './models/users';
-import './models/withdrawals';
+import "./models/accounts";
+import "./models/codes";
+import "./models/deposits";
+import "./models/invoices";
+import "./models/keys";
+import "./models/payments";
+import "./models/orders";
+import "./models/users";
+import "./models/withdrawals";
-import './models/referrals';
-import './models/waiting_list';
+import "./models/referrals";
+import "./models/waiting_list";
const { User, Account, Payment, Invoice, Key, Order, Referral } = db;
User.hasMany(Account, {
as: "accounts",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
User.hasMany(Invoice, {
as: "invoices",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
User.hasMany(Key, {
as: "keys",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
User.hasMany(Order, {
as: "orders",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
User.hasMany(Payment, {
as: "payments",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
User.belongsTo(Account, {
as: "account",
- foreignKey: "account_id",
+ foreignKey: "account_id"
});
Invoice.belongsTo(Account, {
as: "account",
- foreignKey: "account_id",
+ foreignKey: "account_id"
});
Account.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Invoice.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Key.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Payment.belongsTo(Account, {
as: "account",
- foreignKey: "account_id",
+ foreignKey: "account_id"
});
Payment.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Payment.belongsTo(Invoice, {
as: "invoice",
- foreignKey: "invoice_id",
+ foreignKey: "invoice_id"
});
Order.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Order.belongsTo(Account, {
as: "acc1",
- foreignKey: "a1_id",
+ foreignKey: "a1_id"
});
Order.belongsTo(Account, {
as: "acc2",
- foreignKey: "a2_id",
+ foreignKey: "a2_id"
});
User.hasMany(Referral, {
as: "referral_codes",
- foreignKey: "sponsor_id",
+ foreignKey: "sponsor_id"
});
User.hasMany(Referral, {
as: "sponsors",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Referral.belongsTo(User, {
as: "sponsor",
- foreignKey: "sponsor_id",
+ foreignKey: "sponsor_id"
});
Referral.belongsTo(User, {
as: "user",
- foreignKey: "user_id",
+ foreignKey: "user_id"
});
Payment.belongsTo(Payment, {