Mercurial > libervia-backend

comparison sat/memory/sqlite.py @ 2843:a425c1ca51d0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
core (memory/sqlite): added a "timestamp_start" filter to retrieve history from a specific point in time
author Goffi <goffi@goffi.org>
date Sat, 09 Mar 2019 16:24:15 +0100
parents 298408833ec2
children 28fe69b87ba4
comparison
equal deleted inserted replaced
2842:dbfedde9bc61 2843:a425c1ca51d0
588 588
589 # set to True if "ORDER BY" is already added 589 # set to True if "ORDER BY" is already added
590 order = False 590 order = False
591 591
592 if filters: 592 if filters:
593 if u'timestamp_start' in filters:
594 query_parts.append(u"AND timestamp>= ?")
595 values.append(int(filters[u'timestamp_start']))
593 if u'body' in filters: 596 if u'body' in filters:
594 # TODO: use REGEXP (function to be defined) instead of GLOB: https://www.sqlite.org/lang_expr.html 597 # TODO: use REGEXP (function to be defined) instead of GLOB: https://www.sqlite.org/lang_expr.html
595 query_parts.append(u"AND message LIKE ?") 598 query_parts.append(u"AND message LIKE ?")
596 values.append(u"%{}%".format(filters['body'])) 599 values.append(u"%{}%".format(filters['body']))
597 if u'search' in filters: 600 if u'search' in filters: