X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=models%2FVariant.js;h=8d7eba25ab350803824b0d830ff1280815b2df02;hb=c018b304ba439ca92348dcb65715707f5cfcee05;hp=ce5329c788f3982a87dcf62a3a5fdc85aca99e04;hpb=8a477a7e1b781babc74d7935b80ac0b18ec04f86;p=vchess.git diff --git a/models/Variant.js b/models/Variant.js index ce5329c7..8d7eba25 100644 --- a/models/Variant.js +++ b/models/Variant.js @@ -2,7 +2,7 @@ var db = require("../utils/database"); /* * Structure: - * _id: integer + * id: integer * name: varchar * description: varchar */ @@ -11,7 +11,8 @@ exports.getByName = function(name, callback) { db.serialize(function() { const query = - "SELECT * FROM Variants " + + "SELECT * " + + "FROM Variants " + "WHERE name='" + name + "'"; db.get(query, callback); }); @@ -20,7 +21,9 @@ exports.getByName = function(name, callback) exports.getAll = function(callback) { db.serialize(function() { - const query = "SELECT * FROM Variants"; + const query = + "SELECT * " + + "FROM Variants"; db.all(query, callback); }); }