diff options
| author | Adam Soltys <[email protected]> | 2022-09-06 09:20:25 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2022-09-06 09:20:25 -0700 |
| commit | c2464b2407ee23134732fd67586758dbfe18f9b5 (patch) | |
| tree | 3e2d9f009bb325a9a7c4304ea02f6e64dda85bd1 /db | |
| parent | 8a080ef9a198799e7ee31cf81f92afd5495e4074 (diff) | |
| download | coinos-server-c2464b2407ee23134732fd67586758dbfe18f9b5.tar.gz coinos-server-c2464b2407ee23134732fd67586758dbfe18f9b5.zip | |
prettier
Diffstat (limited to 'db')
| -rw-r--r-- | db/db.js | 26 | ||||
| -rw-r--r-- | db/index.js | 66 |
2 files changed, 44 insertions, 48 deletions
@@ -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, { |
