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`) } })
qb.whereRaw('messages_search_index MATCH ?', query) } else if (dbtype == 'mysql' && query != '') { qb.whereRaw(`MATCH(messages.message, messages.address, messages.source) AGAINST (? IN BOOLEAN MODE)`, query) } else if (dbtype == 'oracledb' && query != '') { qb.whereRaw(`CONTAINS("messages"."message", ?, 1) > 0`, query) } else { if (address != '')