search

jlu-ilr-hydro / odmf

Observatory Data Management Framework
MIT License
4 stars 5 forks source link

New filters for sites on map #82

Closed philippkraft closed 3 years ago

philippkraft commented 3 years ago

With a growing number of sites, we need more filters for sites

philippkraft commented 3 years ago
  1. select by symbol (multiple symbols ok)
  2. full text search in name and comment
  3. any installation
  4. logger sites / manual sites
philippkraft commented 3 years ago

about 2: full text search in name and comment

https://docs.sqlalchemy.org/en/13/orm/tutorial.html#common-filter-operators https://docs.sqlalchemy.org/en/14/core/sqlelement.html?highlight=ilike#sqlalchemy.sql.expression.ColumnOperators.ilike

def filter_comment(searchstring):
    return session.query(db.Site).filter(db.Site.ilike('%' + searchstring + '%')