Commit | Line | Data |
---|---|---|
8d7e2786 BA |
1 | var db = require("../utils/database"); |
2 | ||
3 | /* | |
4 | * Structure: | |
5 | * _id: integer | |
6 | * name: varchar | |
7 | * description: varchar | |
8 | */ | |
9 | ||
10 | exports.getByName = function(name, callback) | |
11 | { | |
12 | db.serialize(function() { | |
8a477a7e | 13 | const query = |
8d7e2786 | 14 | "SELECT * FROM Variants " + |
8a477a7e BA |
15 | "WHERE name='" + name + "'"; |
16 | db.get(query, callback); | |
8d7e2786 BA |
17 | }); |
18 | } | |
19 | ||
20 | exports.getAll = function(callback) | |
21 | { | |
22 | db.serialize(function() { | |
8a477a7e BA |
23 | const query = "SELECT * FROM Variants"; |
24 | db.all(query, callback); | |
8d7e2786 BA |
25 | }); |
26 | } | |
27 | ||
28 | //create, update, delete: directly in DB |