Commit Graph

47 Commits

Author SHA1 Message Date
Frederik Baerentsen
3adeef086b Added migration to get new bricklink data fields, fixed bricklink links, added set refresh based on missing bricklink data 2025-09-16 09:43:01 +02:00
Frederik Baerentsen
1cac17a420 Added filter/sort/search to /minifigures and /parts 2025-09-15 20:29:26 +02:00
Gregoo
e28ad8b32c Fix orphaned parts blocking database upgrade 2025-02-10 16:42:23 +01:00
Gregoo
a99669d9dc List of sets to be refreshed 2025-02-04 23:07:16 +01:00
Gregoo
64a9e063ec Wish requesters 2025-02-04 20:07:15 +01:00
Gregoo
ad24506ab7 Fix extra comma 2025-02-04 19:56:33 +01:00
Gregoo
9642853d8e Sort metadata lists by name for more consistency 2025-02-04 17:38:26 +01:00
Gregoo
f0cec23da9 Set purchase date and price 2025-02-04 17:03:39 +01:00
Gregoo
195f18f141 Set purchase location 2025-02-04 12:52:18 +01:00
Gregoo
7ce029029d Properly separate setting state and value for metadata 2025-02-04 10:37:43 +01:00
Gregoo
48e4b59344 Make sure COUNT() does not return NULL 2025-02-03 23:46:05 +01:00
Gregoo
4e3ae49187 Set storage details 2025-02-03 23:45:35 +01:00
Gregoo
8ad525926a Fix metadata storage deletion 2025-02-03 18:12:31 +01:00
Gregoo
9aff7e622d Set storage 2025-02-03 16:46:45 +01:00
Gregoo
d0d1e53acc Fix set storages and purchase locations to be normal metadata 2025-02-03 11:03:54 +01:00
Gregoo
4cf91a6edd Compute and display number of parts for minifigures 2025-02-03 10:48:19 +01:00
Gregoo
34408a1bff Display same parts using a different color 2025-02-03 10:10:06 +01:00
Gregoo
271effd5d2 Support for damaged parts 2025-01-31 20:57:07 +01:00
Gregoo
418a332f03 Add missing set owners SQL drop 2025-01-31 20:57:07 +01:00
Gregoo
f34bbe0602 Set tags 2025-01-31 20:57:07 +01:00
Gregoo
b8d4f23a84 Set owners 2025-01-31 20:57:07 +01:00
Gregoo
5fcd76febb Missing quotes around SQL identifier 2025-01-31 20:57:07 +01:00
Gregoo
7d16e491c8 Rename checkboxes (too generic) to status (and some bug fixes) 2025-01-31 20:57:06 +01:00
Gregoo
a832ff27f7 Create a Metadata object as a base for checkboxes 2025-01-31 20:57:06 +01:00
Gregoo
3893f2aa19 Theme override nobody cares actually 2025-01-31 20:57:06 +01:00
Gregoo
b2d2019bfd Set theme override 2025-01-31 20:57:06 +01:00
Gregoo
468cc7ede9 Display prints based on a part 2025-01-31 20:57:06 +01:00
Gregoo
d08b7bb063 Display RGB color, transparency and prints for parts 2025-01-31 20:57:06 +01:00
Gregoo
fc6ff5dd49 Add a refresh mode for sets 2025-01-31 20:57:06 +01:00
Gregoo
482817fd96 Add purchase location to the database 2025-01-31 20:57:06 +01:00
Gregoo
c4bb3c7607 Deduplicated parts and missing parts 2025-01-31 20:57:06 +01:00
Gregoo
d5f66151b9 Documentation touch up 2025-01-31 20:57:06 +01:00
Gregoo
711c020c27 Add extra fields to set for the future while we are refactoring it 2025-01-31 20:57:06 +01:00
Gregoo
270838a549 Simplify fields name in the database 2025-01-31 20:57:06 +01:00
Gregoo
a0fd62b9d2 Deduplicate minifigures 2025-01-31 20:57:05 +01:00
Gregoo
d063062780 Separate bricktracker sets from rebrickable sets (dedup), introduce custom checkboxes 2025-01-24 10:36:24 +01:00
Gregoo
da2746d2a0 More cleanup of unquoted or misquoted SQL identifiers 2025-01-24 10:25:40 +01:00
Gregoo
e2bcd61ace Take a more generic approach at counting all the tables in the database file 2025-01-24 10:03:53 +01:00
Gregoo
a3e50e9b3c Fix indent 2025-01-21 17:25:49 +01:00
Gregoo
132892ab0b Fix wrong set_version extraction 2025-01-21 11:27:50 +01:00
Gregoo
1b823b158b Remove unused count_none query 2025-01-20 19:39:30 +01:00
Gregoo
ebe0585a40 Quote SQL identifiers as best practice and to avoid any problem in the future 2025-01-20 19:39:12 +01:00
Gregoo
5e99371b39 Incremental forward upgrades of the database 2025-01-20 17:43:15 +01:00
Gregoo
0d9276f639 Built-in fix for 'None' entries in the missing table 2025-01-17 17:19:31 +01:00
Gregoo
7999572cf1 Fix missing 'missing' and 'quantity' badges for minifigure in a part card 2025-01-17 16:28:43 +01:00
Gregoo
463e00f3fe Fix part counts not taking into account the quantity of minifigures 2025-01-17 15:35:11 +01:00
Gregoo
6477be00b6 Massive rewrite 2025-01-17 11:03:00 +01:00