Joe Ardent
97623afd8d
fix date handling.
2024-04-14 15:22:26 -07:00
Joe Ardent
4d8706d6bf
simplify search more and add more convenience views.
2024-04-14 11:00:12 -07:00
Joe Ardent
ba1f9119e8
make date-related columns "text".
2024-04-09 17:44:37 -07:00
Joe Ardent
def08b69b8
try to make imdb import more robust, add convenience views
2024-04-09 17:14:32 -07:00
Joe Ardent
a7104e54aa
Update the code to use new datetime in the DB.
2024-04-07 14:01:31 -07:00
Joe Ardent
51427ecdb5
update db schema to use real datetime
2024-04-07 12:11:55 -07:00
Joe Ardent
efec2e670f
fix fts table defs
2024-02-03 15:04:05 -08:00
Joe Ardent
24c67bc529
add full text search to db
2024-02-02 21:47:50 -08:00
Joe Ardent
d1e2e95248
reorder table drops to respect fk constraints
2024-01-27 17:20:47 -08:00
Joe Ardent
fab52203e5
redo migrations
2024-01-27 17:20:47 -08:00
Joe Ardent
3caefad767
update follows table, rename importer
2024-01-15 15:11:39 -08:00
Joe Ardent
a8efdac3dd
add invitation support to the db
2024-01-14 16:56:52 -08:00
Joe Ardent
1e0a71f275
tidy watches handler, fix quest trigger.
2024-01-02 22:31:38 -08:00
Joe Ardent
7aefedf993
Use Julids for DbId.
...
First phase just does a typedef of "DbId = Julid", and confirms the plugin will load into
sqlite. All tests pass. Next phase removes client-side generation of IDs.
2023-07-26 17:10:52 -07:00
Joe Ardent
c685dc1a6b
add unique constraint for quests
2023-07-18 10:26:16 -07:00
Joe Ardent
5aa7a64354
add triggers for follows table, lowercase username index
2023-07-15 12:36:06 -07:00
Joe Ardent
2c7990ff09
use implicit rowid primary key for quests
2023-07-14 17:17:50 -07:00
Joe Ardent
a9e3bcbfc3
close db connections on shutdown
2023-07-10 11:15:24 -07:00
Joe Ardent
840fba6e92
more inappropriation
2023-07-08 22:00:26 -07:00
Joe Ardent
4ea285abb5
no witches in src or db
2023-07-08 21:21:12 -07:00
Joe Ardent
0e016552ab
Clean up the import code.
...
Make things as batch-y as possible; add timers; tweak the db.
2023-07-08 13:16:05 -07:00
Joe Ardent
49d405fd10
Best results yet, just use (user, watch) for quest ID.
2023-07-06 13:56:55 -07:00
Joe Ardent
5782651aa6
remove 'created_at' fields, we have that in the id
2023-06-29 15:33:15 -07:00
Joe Ardent
b89d463e50
remove multi-column indexes
2023-06-25 11:00:33 -07:00
Joe Ardent
0fbcfb9c8c
remove useless route
2023-06-18 12:04:09 -07:00
Joe Ardent
1a4ffaa99d
adds Watches struct
2023-06-05 16:51:27 -07:00
Joe Ardent
95762f341b
checkpoint fucking with errors
2023-05-14 20:33:36 -07:00
Joe Ardent
d87ade7980
add user structs
2023-05-12 15:36:19 -07:00
Joe Ardent
d9aee1a87f
add lib crate
2023-05-12 12:08:18 -07:00
Joe Ardent
fdf2b1e910
update deps
2023-04-28 12:53:44 -07:00
Joe Ardent
3aa83dcbc3
add update triggers and default values for dates
2023-04-27 15:22:49 -07:00
Joe Ardent
3888ba4fc7
probably done with the db schema, next add triggers
2023-04-27 14:21:29 -07:00
Joe Ardent
394898aab2
add notes for witch_watches, secret for auth
2023-04-26 17:56:11 -07:00
Joe Ardent
65a32f1f20
create initial db migrations
2023-04-26 17:08:49 -07:00
