X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fmodels%2FNews.js;h=3fa3caaea0ea68a5e50270a10add5416120e0f8b;hb=d9a7a1e40254bda6e545514596a7363048c084f9;hp=3f98fd677b01ffae050b517b2b787290c9139fc8;hpb=c5c47010b5b50edbdd6bfc40a61ce716c6114e5a;p=vchess.git diff --git a/server/models/News.js b/server/models/News.js index 3f98fd67..3fa3caae 100644 --- a/server/models/News.js +++ b/server/models/News.js @@ -19,7 +19,7 @@ const NewsModel = "VALUES " + "(" + Date.now() + "," + uid + ",?)"; db.run(query, content, function(err) { - return cb(err, {nid: this.lastID}); + cb(err, {nid: this.lastID}); }); }); }, @@ -33,29 +33,43 @@ const NewsModel = "WHERE id > " + cursor + " " + "LIMIT 10"; //TODO: 10 currently hard-coded db.all(query, (err,newsList) => { - return cb(err, newsList); + cb(err, newsList); }); }); }, - update: function(news, cb) + getTimestamp: function(cb) + { + db.serialize(function() { + const query = + "SELECT added " + + "FROM News " + + "ORDER BY added DESC " + + "LIMIT 1"; + db.get(query, (err,ts) => { + cb(err, ts); + }); + }); + }, + + update: function(news) { db.serialize(function() { let query = "UPDATE News " + "SET content = ? " + "WHERE id = " + news.id; - db.run(query, news.content, cb); + db.run(query, news.content); }); }, - remove: function(id, cb) + remove: function(id) { db.serialize(function() { const query = "DELETE FROM News " + "WHERE id = " + id; - db.run(query, cb); + db.run(query); }); }, }