13 commits

Author	SHA1	Message	Date
Simon Bruder	6e4e8d3d93	Fix formatting of short ID on label ... PostgreSQL adds a space in front of the number if not specified otherwise, to account for a minus sign with negative numbers. As all short IDs are positive, it can be suppressed here.	2024-07-27 16:15:14 +02:00
Simon Bruder	61a49afaf7	Make item (class) delete fail on invalid ID	2024-07-25 23:22:59 +02:00
Simon Bruder	f33f3c8b9c	Move database operations to separate module ... This can be seen as partially reverting e83bc8316e, which moved everything to the place where it was used.	2024-07-25 23:22:56 +02:00
Simon Bruder	bcbb7dfc67	Add item state	2024-07-24 16:29:22 +02:00
Simon Bruder	e83bc8316e	Move away from models and manage subpackage ... This architecture was started when the project still used Diesel. Now that it uses SQLx, less things are done in Rust and more are done in SQL. This commit now moves more of the query logic into SQL, which should lead to more efficient queries and less moving data around.	2024-07-24 12:19:55 +02:00
Simon Bruder	b55c8373d3	Fix item order in get_parents_details	2024-07-19 00:06:31 +02:00
Simon Bruder	125627d7d2	Allow batch adding items	2024-07-19 00:06:30 +02:00
Simon Bruder	a528b9fe44	Add description to item and item class	2024-07-19 00:06:21 +02:00
Simon Bruder	c67e31fdc5	Add original packaging attribute to items	2024-07-19 00:06:17 +02:00
Simon Bruder	09dfac9104	Add quick jump feature	2024-07-19 00:06:05 +02:00
Simon Bruder	1427ed9bf4	Add short id to item for usage with labels	2024-07-19 00:05:36 +02:00
Simon Bruder	4f230af334	Add creation date to allow consistent ordering	2024-07-19 00:05:29 +02:00
Simon Bruder	00d7647187	Switch to sqlx ... While diesel has a native rust interface, writing more complex queries is easier when you can just pass a SQL query string.	2024-07-19 00:05:26 +02:00