Snyk has a proof-of-concept or detailed explanation of how to exploit this vulnerability.
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applicationsThere is no fixed version for @azhou/basemodel
.
@azhou/basemodel is a package.
Affected versions of this package are vulnerable to SQL Injection. All table names and fields arguments of all methods are fed directly into query by string concatenation without escaping which may lead to sql injection. In addition, order by
fields of model.getAll(fields, orderby)
is not escaped and directly used in query which lead to blind sql injection.
model.getAll = function (fields, orderby) {
if (typeof fields == 'string') {
orderby = fields;
fields = allFields;
} else if (Array.isArray(fields) && (typeof orderby == 'string' || !orderby)) {
if (fields.length == 0)
fields = allFields;
} else {
fields = allFields;
orderby = "";
}
return db.query("SELECT id," + fields.join(",") + " FROM `" + table + "`"
+ (orderby ? " ORDER BY " + orderby : ""));
}