56 Commits

Author SHA1 Message Date
104d42201d [main] Major changes for submit 2025-01-20 06:49:32 +01:00
e452822ffc [main] WIP category tab and showcase of phantom read 2025-01-17 15:03:50 +01:00
a129d88575 [main] Added another view with actual use 2025-01-17 15:03:28 +01:00
9c827a04f5 [main] (WIP) Work on member imports and all 3 exports 2025-01-16 23:11:46 +01:00
85382ee616 [main] Fixed a bug with editing existing books 2025-01-16 20:07:47 +01:00
d7ee79f7e9 [main] Fixed imports and exports after structure rework 2025-01-16 17:18:20 +01:00
153da38f89 [main] WIP rework structure 2025-01-16 15:11:50 +01:00
6a42e522f9 [main] Added the new table as a model 2025-01-15 23:05:34 +01:00
ec55394d79 [main] Added new table to showcase the phantom read problem 2025-01-15 23:05:20 +01:00
79ca9f2e6f [main] Fixed book editing not working 2025-01-15 17:16:31 +01:00
516639ef9d [main] Major rework of structure 2025-01-15 14:08:18 +01:00
3fa44ccaf3 [main] Outline for error handling of member creation 2025-01-14 20:16:18 +01:00
84df581763 [main] Updated models to reflect current constraints 2025-01-14 17:44:52 +01:00
b28bc97625 [main] Added unique constraints to member 2025-01-14 17:40:41 +01:00
85d313d45b [main] Started working on member list 2025-01-14 17:22:35 +01:00
8e6a6e8693 [main] Updated book_category_link on delete rules which prevented deletion of books 2025-01-14 16:34:17 +01:00
dffd140d1a [main] Finally fixed book importing and dynamic category and author creation 2025-01-14 15:23:32 +01:00
723be8ae16 [main] Improvements to the import 2025-01-13 18:48:56 +01:00
48163325d8 [main] Added imports as well a whole bunch of tweaks elsewhere 2025-01-12 20:08:25 +01:00
142b2d449d [main] Added book export to xml 2025-01-11 13:10:47 +01:00
50227b9a2b [main] Added import XML scheme for books 2025-01-10 14:50:19 +01:00
48d1a28783 [main] Updated book editor and menu entries 2025-01-10 14:49:08 +01:00
0b960cbae6 [main] Switched from DTD to XSD 2025-01-10 11:25:47 +01:00
2f6d2d51a3 [main] Added DTD tutorial to sources 2025-01-10 10:16:34 +01:00
12828b2688 [main] Tweaks to design and bringed back sqlalchemy 2025-01-09 21:43:15 +01:00
16ebca7767 [main] Updated example .env to reflect current code 2025-01-09 21:42:57 +01:00
a2ffd8aa3b [main] WIP major rework of current design, database management and other things 2025-01-09 14:14:27 +01:00
4bf43721e3 [main] Added some ease of life settings in .vscode 2025-01-09 14:13:42 +01:00
b67c03291e [main] Slight updates to views 2025-01-09 14:13:03 +01:00
277abe79d7 [main] Added model for a view 2025-01-07 21:24:49 +01:00
fb7aebd0d7 [main] Updated database view with book id 2025-01-07 21:24:23 +01:00
6a1c76798d [main] Updated design for tab view, prepared for other tabs and general tweaks to design 2025-01-07 21:23:55 +01:00
8db7eae1e4 [main] Preparation for config handler 2025-01-07 15:26:02 +01:00
75550c7f6f [main] Testing in app.py 2025-01-07 15:25:47 +01:00
427cd25853 [main] Changed from qml UI to QWidgets 2025-01-07 15:25:29 +01:00
1c860b70e8 [main] Slight changes to models to finally make them work 2025-01-07 15:25:01 +01:00
b22a0bb664 [main] Added sample .env for reference 2025-01-07 15:24:27 +01:00
b970320d80 [main] Added a few sources to README 2025-01-07 15:23:41 +01:00
c683b7070f [main] Added .vscode 2025-01-07 13:20:36 +01:00
15baa3a913 [main] Added sqlalchemy and mysql connector to dependencies 2025-01-07 10:03:58 +01:00
d242e4ff68 [main] Testing SqlAlchemy models 2025-01-07 00:18:18 +01:00
76465636ee [main] Updated models and their initialization 2025-01-07 00:18:02 +01:00
1e36c2d966 [main] Added autoincrement to primary keys 2025-01-07 00:17:33 +01:00
98d39bba2e [main] Updated models according to new database structure 2025-01-06 21:45:27 +01:00
5b2fe4460e [main] Added update timestamps and triggers that update them to db 2025-01-06 21:45:15 +01:00
b98eba2ddd [main] Added a procedure for updating overdue loans 2025-01-06 19:58:42 +01:00
5dde0468d0 [main] Updated .gitignore to include *.bak files (For MySQLWorkbench) 2025-01-05 19:31:29 +01:00
cd18b3ab46 [main] Initial code for SqlAlchemy and it's models 2025-01-05 19:30:42 +01:00
765b939998 [main] Updated database structure with new columns and views 2025-01-05 19:29:36 +01:00
8588eda3ce [main] Initial code 2025-01-05 00:26:46 +01:00