Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- exports.fts_find_factory = function(that, tablename, def_fields, def_limit) {
- var fn = function() {
- db.connect(function(err, client) {
- if(err && callback) { callback(err); return; }
- var query, options, callback, fields, limit;
- query = arguments[0];
- callback = arguments[arguments.length - 1];
- if(arguments.length > 2) {
- options = arguments[1];
- }
- if(options) {
- fields = options.fields.join(',') || def_fields.join(',');
- limit = options.limit || def_limit;
- }
- client.query(
- "SELECT " + fields + " " +
- "FROM person " +
- "WHERE searchable_text @@ (plainto_tsquery('simple', $1) && to_tsquery('simple', $2)) " +
- "LIMIT " + limit,
- helpers.to_fts_query(query),
- function(err, resultSet) {
- if(err && callback) { callback(err); return; }
- callback(null, resultSet.rows);
- });
- });
- }
- return function() {
- fn.apply(that, arguments);
- }
- }
Add Comment
Please, Sign In to add comment