| Commit message (Collapse) | Author | Age | Files | Lines | |
|---|---|---|---|---|---|
| * | add reportHEADmaster |  Peter McGoron
| 2021-08-05 | 1 | -0/+22 |
| | | |||||
| * | retrieve blobs and files | Peter McGoron
| 2021-08-05 | 2 | -3/+22 |
| | | |||||
| * | modify schema (again) | Peter McGoron
| 2021-08-05 | 3 | -27/+38 |
| | | | | | | | | | | | | | | This bundles the data and filename into the cards table, with a CHECK enforcing that both cannot be set. They are unset when they are NULL. Cards can have both data and filename be NULL, meaning that there is nothing associated with the title. These cards can still be tagged like normal. When inserting a new blob (or filename), the program checks if there is currently a filename (or blob, when you insert a filename) associated with the card. The program will then prompt you if you want to overwrite the blob or filename. | ||||
| * | redo schema | Peter McGoron
| 2021-07-27 | 2 | -4/+55 |
| | | | | | | | | | | The new schema can now store blobs and file strings (which can be URLs or other names). These are different tables. In the future the cards table can have two columns, where one and only one must be NULL, with a CHECK to confirm that. Then coalesce() can be used to retrieve data from the table. | ||||
| * | natargs: return None when no function handles an argument | Peter McGoron
| 2021-07-27 | 1 | -0/+2 |
| | | |||||
| * | remove unused functions | Peter McGoron
| 2021-07-27 | 1 | -15/+1 |
| | | |||||
| * | 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 | 2 | -12/+28 |
| | | | | | | As of right now NOT queries do not work correctly for cards with more than one tag. | ||||
| * | natargs: add missing import | Peter McGoron
| 2021-07-26 | 1 | -0/+2 |
| | | |||||
| * | queryparse: remove literal set | Peter McGoron
| 2021-07-26 | 2 | -17/+14 |
| | | |||||
| * | queryparse: add function to build SQL queries | Peter McGoron
| 2021-07-26 | 2 | -1/+73 |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 | 2 | -1/+17 |
| | | |||||
| * | update README.md | Peter McGoron
| 2021-07-26 | 1 | -0/+10 |
| | | |||||
| * | queryparse: collect literals into set and return it | Peter McGoron
| 2021-07-26 | 2 | -16/+22 |
| | | |||||
| * | gitea wants .md suffixes for web rendering | Peter McGoron
| 2021-07-26 | 2 | -0/+0 |
| | | |||||
| * | example/query.md: change to what the code actually implements | Peter McGoron
| 2021-07-26 | 1 | -3/+3 |
| | | |||||
| * | add COPYING | Peter McGoron
| 2021-07-26 | 1 | -0/+124 |
| | | |||||
| * | add README | Peter McGoron
| 2021-07-26 | 1 | -0/+4 |
| | | |||||
| * | queryparse: fix tagglob and titleglob, fix encapsulating literals | Peter McGoron
| 2021-07-26 | 2 | -9/+12 |
| | | |||||
| * | queryparse: fix infinite recursion in '[' e1 ']' | Peter McGoron
| 2021-07-26 | 2 | -1/+2 |
| | | |||||
| * | 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 | 2 | -2/+4 |
| | | |||||
| * | queryparse: fix mistaken command in AND | Peter McGoron
| 2021-07-26 | 2 | -1/+2 |
| | | |||||
| * | start query parser | Peter McGoron
| 2021-07-26 | 3 | -0/+145 |
| | | |||||
| * | move SQL schema setup to variable | Peter McGoron
| 2021-07-26 | 1 | -9/+9 |
| | | |||||
| * | add list tags and list cards | Peter McGoron
| 2021-07-26 | 3 | -57/+24 |
| | | |||||
| * | underwriter: start new argument parser | Peter McGoron
| 2021-07-26 | 4 | -32/+110 |
| | | |||||
| * | add inspect_tagmap.md | Peter McGoron
| 2021-07-26 | 1 | -0/+12 |
| | | |||||
| * | add renaming | Peter McGoron
| 2021-07-26 | 3 | -1/+17 |
| | | |||||
| * | add more documentation cards | Peter McGoron
| 2021-07-26 | 1 | -0/+0 |
| | | |||||
| * | add 'list tags' and 'list cards' | Peter McGoron
| 2021-07-26 | 1 | -0/+56 |
| | | |||||
| * | use an actual schema for storing tag data | Peter McGoron
| 2021-07-26 | 4 | -77/+78 |
| | | |||||
| * | untag: actually remove note from tag lists | Peter McGoron
| 2021-07-26 | 1 | -0/+4 |
| | | |||||
| * | modify examples and add tag_idempotent.md | Peter McGoron
| 2021-07-26 | 3 | -2/+7 |
| | | |||||
| * | fix removing tags from a card | Peter McGoron
| 2021-07-26 | 1 | -10/+8 |
| | | |||||
| * | make sure tagging does not add a tag more than once | Peter McGoron
| 2021-07-26 | 4 | -6/+12 |
| | | |||||
| * | add ability to add cards to database | Peter McGoron
| 2021-07-26 | 3 | -0/+154 |
 |
index : underwriter | |
| Document management system | Peter McGoron |
| aboutsummaryrefslogtreecommitdiffstats |