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