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