/*
* Structure:
- * _id: integer
+ * id: integer
* name: varchar
* description: varchar
*/
exports.getByName = function(name, callback)
{
db.serialize(function() {
- db.get(
- "SELECT * FROM Variants " +
- "WHERE name='" + name + "'",
- callback);
+ const query =
+ "SELECT * " +
+ "FROM Variants " +
+ "WHERE name='" + name + "'";
+ db.get(query, callback);
});
}
exports.getAll = function(callback)
{
db.serialize(function() {
- db.all("SELECT * FROM Variants", callback);
+ const query =
+ "SELECT * " +
+ "FROM Variants";
+ db.all(query, callback);
});
}