| Commit message (Collapse) | Author | Age | Files | Lines | |
|---|---|---|---|---|---|
| * | queryparse: fix NOT |  Peter McGoron
| 2021-07-27 | 1 | -7/+8 |
| | | | | | | NOT queries are now two-step: the list is queries and then all elements in the cards table that are also in the query are discarded. | ||||
| * | add command line option for search | Peter McGoron
| 2021-07-26 | 1 | -12/+19 |
| | | | | | | As of right now NOT queries do not work correctly for cards with more than one tag. | ||||
| * | queryparse: remove literal set | Peter McGoron
| 2021-07-26 | 1 | -15/+13 |
| | | |||||
| * | queryparse: add function to build SQL queries | Peter McGoron
| 2021-07-26 | 1 | -0/+42 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SQLite allows for UNIONs and INTERSECTIONs between SELECT statements, but it does not support grouping them. By recursively applying DeMorgan's laws, the parser can reduce the parse tree to only * Literals * NOT literals (i.e. "all items not belonging to this tag") * ANDs * ORs What SQLite /can/ do is have SELECT statements come from other SELECT statements. A query like (X & Y & Z) | (A & B & C) in pseudo-SQLite becomes SELECT * FROM ( SELECT * FROM tbl WHERE name IN X INTERSECTION SELECT * FROM tbl WHERE name IN Y INTERSECTION SELECT * FROM tbl WHERE name IN Z ) UNION SELECT * FROM ( SELECT * FROM tbl WHERE name IN A INTERSECTION SELECT * FROM tbl WHERE name IN B INTERSECTION SELECT * FROM tbl WHERE name IN C ) One future optimization would be to group all literals at a certain level with each other, so that there are less direct queries to the entire tag table. | ||||
| * | queryparse: use demorgan's laws to simplify parsed expression | Peter McGoron
| 2021-07-26 | 1 | -1/+16 |
| | | |||||
| * | queryparse: collect literals into set and return it | Peter McGoron
| 2021-07-26 | 1 | -13/+15 |
| | | |||||
| * | queryparse: fix tagglob and titleglob, fix encapsulating literals | Peter McGoron
| 2021-07-26 | 1 | -9/+10 |
| | | |||||
| * | queryparse: fix infinite recursion in '[' e1 ']' | Peter McGoron
| 2021-07-26 | 1 | -1/+1 |
| | | |||||
| * | queryparse: lift encapsulate() calls into loops to make cleaner parse trees | Peter McGoron
| 2021-07-26 | 1 | -2/+2 |
| | | |||||
| * | queryparse: fix error in returning from NOT | Peter McGoron
| 2021-07-26 | 1 | -2/+2 |
| | | |||||
| * | queryparse: fix mistaken command in AND | Peter McGoron
| 2021-07-26 | 1 | -1/+1 |
| | | |||||
| * | start query parser | Peter McGoron
| 2021-07-26 | 1 | -0/+121 |
 |
index : underwriter | |
| Document management system | Peter McGoron |
| aboutsummaryrefslogtreecommitdiffstats |