- db.serialize(function() {
- db.all("SELECT * FROM Variants WHERE name='" + vname + "'", (err,variant) => {
- if (!!err)
- return next(err);
- if (!variant || variant.length==0)
- return next(createError(404));
- res.render('variant', {
- title: vname + ' Variant',
- variant: vname,
- lang: selectLanguage(req, res),
- });
+ VariantModel.getByName(vname, (err,variant) => {
+ if (!!err)
+ return next(err);
+ if (!variant)
+ return next(createError(404));
+ res.render('variant', {
+ title: vname + ' Variant',
+ variant: variant, //the variant ID might also be useful
+ lang: selectLanguage(req, res),