Revise server code + a few fixes in trnalsations and ComputerGame
[vchess.git] / server / models / News.js
1 const db = require("../utils/database");
2
3 /*
4 * Structure:
5 * id: integer
6 * added: datetime
7 * uid: user id (int)
8 * content: text
9 */
10
11 const NewsModel =
12 {
13 create: function(content, uid, cb)
14 {
15 db.serialize(function() {
16 const query =
17 "INSERT INTO News " +
18 "(added, uid, content) " +
19 "VALUES " +
20 "(" + Date.now() + "," + uid + ",?)";
21 db.run(query, content, function(err) {
22 cb(err, {nid: this.lastID});
23 });
24 });
25 },
26
27 getNext: function(cursor, cb)
28 {
29 db.serialize(function() {
30 const query =
31 "SELECT * " +
32 "FROM News " +
33 "WHERE id > " + cursor + " " +
34 "LIMIT 10"; //TODO: 10 currently hard-coded
35 db.all(query, (err,newsList) => {
36 cb(err, newsList);
37 });
38 });
39 },
40
41 update: function(news)
42 {
43 db.serialize(function() {
44 let query =
45 "UPDATE News " +
46 "SET content = ? " +
47 "WHERE id = " + news.id;
48 db.run(query, news.content);
49 });
50 },
51
52 remove: function(id)
53 {
54 db.serialize(function() {
55 const query =
56 "DELETE FROM News " +
57 "WHERE id = " + id;
58 db.run(query);
59 });
60 },
61 }
62
63 module.exports = NewsModel;