FormHandler full-text search support

[sanand0]

• ?_q=text filters rows that match "text" in any of the chosen query columns
• Query columns can be chosen via ?_qc. For example, ?_qc=firstname&_qc=lastname&_q=name searches for "name" in the "firstname" and "lastname" columns.
• In SQLAlchemy core, this would map to columns['firstname'].contains('name') or columns['lastname'].contains('name'). See contains
• _qc defaults to all string columns in the table
• If _qc contains non-string columns, these are added to metadata as meta['ignored'] as ('_qc', col), ...

Implementation notes in gramex/data.py:

• _pop_controls() must pop out _q and _qc as controls
• In _filter_db(), under the # Apply controls, add a if '_q' in controls: section
• In that section, get all text columns.
  • If _qc is in controls, pick only those columns.
  • If any _qc columns are not in controls, add them to meta['ignored'].append(('_qc', qc_ignored_cols))
• Using SQLAlchemy contains, add columns[col].contains(query) for each column, using an OR join.

Origin:

• Source: https://code.gramener.com/cto/gramex/issues/142
• Author: s.anand
• Created: Mon 25 Sep 2017 04:21

[ranjith-p15]

Can I take this up?

[sanand0]

Sure, @ranjith-p15