[vchess.git] / models / Variant.js

var db = require("../utils/database");

/*
 * Structure:
 *   id: integer
 *   name: varchar
 *   description: varchar
 */

exports.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);
	});
}

//create, update, delete: directly in DB
Commit	Line	Data
8d7e2786 BA	1	var db = require("../utils/database");
	2
	3	/*
	4	* Structure:
c018b304	5	* id: integer
8d7e2786 BA	6	* name: varchar
	7	* description: varchar
	8	*/
	9
	10	exports.getByName = function(name, callback)
	11	{
	12	db.serialize(function() {
8a477a7e	13	const query =
c018b304 BA	14	"SELECT * " +
c018b304 BA	15	"FROM Variants " +
8a477a7e BA	16	"WHERE name='" + name + "'";
8a477a7e BA	17	db.get(query, callback);
8d7e2786 BA	18	});
	19	}
	20
	21	exports.getAll = function(callback)
	22	{
	23	db.serialize(function() {
c018b304 BA	24	const query =
	25	"SELECT * " +
	26	"FROM Variants";
8a477a7e	27	db.all(query, callback);
8d7e2786 BA	28	});
	29	}
	30
	31	//create, update, delete: directly in DB