db.from('capcodes') .select('id', 'ignore') // TODO: test this doesn't break other DBs - there's a lot of quote changes here .modify(function (queryBuilder) { if (dbtype == 'oracledb') { queryBuilder.whereRaw(`'${address}' LIKE "address"`) queryBuilder.orderByRaw(`REPLACE("address", '_', '%') DESC`); } else { queryBuilder.whereRaw(`"${address}" LIKE address`) queryBuilder.orderByRaw(`REPLACE(address, '_', '%') DESC`) } })
router.route('/capcodeExport') .post(authHelper.isAdmin, function (req, res, next) { nconf.load(); var dbtype = nconf.get('database:type'); var filename = 'export.csv' db.from('capcodes') .select('*') .modify(function (queryBuilder) { if (dbtype == 'oracledb') queryBuilder.orderByRaw(`REPLACE("address", '_', '%')`); else queryBuilder.orderByRaw(`REPLACE(address, '_', '%')`) }) .then((rows) => { converter.json2csv(rows, function (err, data) { if (err) { res.status(500).send(err); } else { res.status(200).send({ 'status': 'ok', 'data': data }) } }) }) .catch((err) => { logger.main.error(err); return next(err); }) });
db.from('messages') .select('*') .modify(function (queryBuilder) { if ((dupeLimit != 0) && (dupeTime != 0)) { queryBuilder.where('id', 'in', function () {
db.from('capcodes') .returning('id') .where('id', '=', id) .modify(function (queryBuilder) { if (id == null) { queryBuilder.insert({ .from('capcodes') .where('messages.address', 'like', 'address') .modify(function (queryBuilder) { if (dbtype == 'oracledb') queryBuilder.orderByRaw(`REPLACE("address", '_', '%') DESC`);
db.from('messages') .select('messages.*', 'capcodes.alias', 'capcodes.agency', 'capcodes.icon', 'capcodes.color', 'capcodes.ignore', 'capcodes.pluginconf') .modify(function (queryBuilder) { queryBuilder.leftJoin('capcodes', 'capcodes.id', '=', 'messages.alias_id') })
.modify(function (queryBuilder) { if (pdwMode) { if (adminShow && req.isAuthenticated() && req.user.role == 'admin') {
db.select('messages.*', 'capcodes.alias', 'capcodes.agency', 'capcodes.icon', 'capcodes.color', 'capcodes.ignore') .modify(function (qb) { if (dbtype == 'sqlite3' && query != '') { qb.from('messages_search_index')
.returning('id') .where('id', '=', id) .modify(function (queryBuilder) { const userobj ={ id: id,