aboutsummaryrefslogtreecommitdiff
path: root/src/api/utils
diff options
context:
space:
mode:
authorZephyrrus <[email protected]>2021-01-07 21:36:56 +0200
committerZephyrrus <[email protected]>2021-01-07 21:36:56 +0200
commitb3df1dd7a653909fb3f18ed7c0c91ffa347480fb (patch)
tree785a168e85aa6ebe7e8e7e8ea4a3f54dbe3c7efc /src/api/utils
parentchore: update knex, mdi/font, nuxtjs/axios, nuxt, systeminformation (diff)
downloadhost.fuwn.me-b3df1dd7a653909fb3f18ed7c0c91ffa347480fb.tar.xz
host.fuwn.me-b3df1dd7a653909fb3f18ed7c0c91ffa347480fb.zip
feat: change mutation timestamp on every database mutation
Diffstat (limited to 'src/api/utils')
-rw-r--r--src/api/utils/Util.js9
1 files changed, 5 insertions, 4 deletions
diff --git a/src/api/utils/Util.js b/src/api/utils/Util.js
index 8eafcff..658ac61 100644
--- a/src/api/utils/Util.js
+++ b/src/api/utils/Util.js
@@ -99,7 +99,8 @@ class Util {
await db
.table('files')
.where('name', filename)
- .delete();
+ .delete()
+ .wasMutated();
}
} catch (error) {
log.error(`There was an error removing the file < ${filename} >`);
@@ -257,9 +258,9 @@ class Util {
let fileId;
if (process.env.DB_CLIENT === 'sqlite3') {
- fileId = await db.table('files').insert(data);
+ fileId = await db.table('files').insert(data).wasMutated();
} else {
- fileId = await db.table('files').insert(data, 'id');
+ fileId = await db.table('files').insert(data, 'id').wasMutated();
}
return {
@@ -273,7 +274,7 @@ class Util {
const now = moment.utc().toDate();
try {
- await db.table('albumsFiles').insert({ albumId, fileId: insertedId[0] });
+ await db.table('albumsFiles').insert({ albumId, fileId: insertedId[0] }).wasMutated();
await db.table('albums').where('id', albumId).update('editedAt', now);
} catch (error) {
console.error(error);