* description: varchar
*/
-exports.getByName = function(name, callback)
+const VariantModel =
{
- db.serialize(function() {
- const query =
- "SELECT * " +
- "FROM Variants " +
- "WHERE name='" + name + "'";
- db.get(query, callback);
- });
-}
+ getByName: function(name, callback)
+ {
+ db.serialize(function() {
+ const query =
+ "SELECT * " +
+ "FROM Variants " +
+ "WHERE name='" + name + "'";
+ db.get(query, callback);
+ });
+ },
-exports.getAll = function(callback)
-{
- db.serialize(function() {
- const query =
- "SELECT * " +
- "FROM Variants";
- db.all(query, callback);
- });
+ getAll: function(callback)
+ {
+ db.serialize(function() {
+ const query =
+ "SELECT * " +
+ "FROM Variants";
+ db.all(query, callback);
+ });
+ },
+
+ //create, update, delete: directly in DB
}
-//create, update, delete: directly in DB
+module.exports = VariantModel;