diff options
| author | Zephyrrus <[email protected]> | 2021-01-08 00:41:43 +0200 |
|---|---|---|
| committer | Zephyrrus <[email protected]> | 2021-01-08 00:41:43 +0200 |
| commit | b58e12cad888389b8ae69b6d36357390f35a727d (patch) | |
| tree | b427becf78c51081e58f1b2af98b2662f7626a39 | |
| parent | fix: don't generate a stat every second on minute 0 of every hour (diff) | |
| download | host.fuwn.me-b58e12cad888389b8ae69b6d36357390f35a727d.tar.xz host.fuwn.me-b58e12cad888389b8ae69b6d36357390f35a727d.zip | |
fix: pg driver doesn't return anything without .returning()
feat: disable .returning() is not supported warning message, it's useless.
| -rw-r--r-- | src/api/routes/albums/albumPOST.js | 6 | ||||
| -rw-r--r-- | src/api/routes/tags/tagPOST.js | 5 | ||||
| -rw-r--r-- | src/api/structures/Database.js | 6 |
3 files changed, 15 insertions, 2 deletions
diff --git a/src/api/routes/albums/albumPOST.js b/src/api/routes/albums/albumPOST.js index ec94eb8..04cab1e 100644 --- a/src/api/routes/albums/albumPOST.js +++ b/src/api/routes/albums/albumPOST.js @@ -28,7 +28,11 @@ class albumPOST extends Route { editedAt: now }; - const dbRes = await db.table('albums').insert(insertObj).wasMutated(); + const dbRes = await db + .table('albums') + .insert(insertObj) + .returning('id') + .wasMutated(); insertObj.id = dbRes.pop(); diff --git a/src/api/routes/tags/tagPOST.js b/src/api/routes/tags/tagPOST.js index 5430de9..8177067 100644 --- a/src/api/routes/tags/tagPOST.js +++ b/src/api/routes/tags/tagPOST.js @@ -25,7 +25,10 @@ class tagPOST extends Route { editedAt: now }; - const dbRes = await db.table('tags').insert(insertObj).wasMutated(); + const dbRes = await db.table('tags') + .insert(insertObj) + .returning('id') + .wasMutated(); insertObj.id = dbRes.pop(); diff --git a/src/api/structures/Database.js b/src/api/structures/Database.js index 5818452..39632a1 100644 --- a/src/api/structures/Database.js +++ b/src/api/structures/Database.js @@ -40,6 +40,12 @@ const db = Knex({ return result; }, useNullAsDefault: process.env.DB_CLIENT === 'sqlite3', + log: { + warn: msg => { + if (typeof msg === 'string' && msg.startsWith('.returning()')) return; + console.warn(msg); + } + }, userParams: { lastMutationTime: null } |