diff options
| author | Ranabir Guin <[email protected]> | 2021-05-14 23:10:21 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2021-06-09 16:05:31 -0700 |
| commit | 2f18ab0b0fdf1923bda92723866cd9946c323786 (patch) | |
| tree | a2fd61552cc1ad2d6dfd7a65b23af477f965b7f9 | |
| parent | 4f39e4a10804347e89a30201bade1a42e9df0ef0 (diff) | |
| download | coinos-server-2f18ab0b0fdf1923bda92723866cd9946c323786.tar.gz coinos-server-2f18ab0b0fdf1923bda92723866cd9946c323786.zip | |
tweak admin route queries
| -rw-r--r-- | routes/admin.js | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/routes/admin.js b/routes/admin.js index b17e5aa4..b691dcbc 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -39,8 +39,9 @@ router.get( router.get( "/accounts", ah(async (req, res) => { - var accounts = await db.Accounts.findAll({ - include: [ db.User ] + var accounts = await db.Account.findAll({ + include: [ + { model: db.User, as: 'User' ] }) debug('accounts: ' + JSON.stringify(accounts)) @@ -65,7 +66,11 @@ router.get( "/user_transactions", ah(async (req, res) => { var transactions = await db.User.findAll({ - include: [ db.Invoice, db.Payment, db.Order ] + include: [ + { model: db.Invoice, as: 'Invoices' }, + { model: db.Payment, as: 'Payments' }, + { model: db.Order, as: 'Orders' + ] }) debug('transactions: ' + JSON.stringify(transactions)) |