X-Git-Url: https://git.auder.net/assets/rpsls.css?a=blobdiff_plain;f=models%2FVariant.js;h=8d7eba25ab350803824b0d830ff1280815b2df02;hb=00f2759e16ec73fa1ecd0254a9c9018530d71892;hp=9a19f18cc7f495b4fca89751c4d1d0045a8f1dab;hpb=8d7e2786f5a67a1b9a77c742d7951e0efbe8747d;p=vchess.git diff --git a/models/Variant.js b/models/Variant.js index 9a19f18c..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 */ @@ -10,17 +10,21 @@ var db = require("../utils/database"); 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); }); }