21 Commits (dev)

Author SHA1 Message Date
Peery 8ede24740f
Fixed a bug when creating Alias tags
The method add_alias_by_name()'s parameters were incorrectly used by create_tag()
1 year ago
Peery 7e291c028d
Wrong Parameter when adding implications on a new tag
When creating a new tag (create_tag()) the new implications were passing a dict when a name (string) was expected. Replaced the call with the ID version saving one tag lookup.
1 year ago
Peery bcc39c5147
Fixed an Issue with implications and alias editing
Fixed a crash when implications or aliases were edited the new dict format of the database caused crashes.
1 year ago
Peery 24feb63e5e Fixed Crashes related to recent DB Changes
Fixed a few bugs/crashes that were caused by code still expecting tag name lists being returned by the DB API instead of the new dictionaries.

I should really automate tests or do something to catch these better in the future ...
1 year ago
Peery 1596faee7f Tag Tooltips in the Importer UI
Changed several DB methods to return dictionaries with description and similar tag data instead which allows the importer to also create the tooltip texts which gives more detailed info about a tag in EVERY tag frame without needing to query for each tag specifically.
1 year ago
Peery b37a21d785 Half-done collections and UI changes
Minor tweaks and refactors. A half-baked collection support and several UI tweaks.

Just committing these are they are "old" changes and the current state turns out to be pretty stable.
1 year ago
Peery 2b4cac949a Renamed tables in DB_adapter
Renamed the database tables to reflect the newest schema in the scripts. Changed the db_adapter calls to fit.
2 years ago
Peery 2bb9b06a8f Added Browser Window (WIP)
Added the first draft of the browser window and implemented switching between it and the importer window via menu action.
Also renamed window.py to importer_window and abstracted some features into a superclass from which the browser window can also inherit. This allows an equal interface for them.
Also fixed a bug in the db_adapter.py where an old column name was used for a query.
2 years ago
Peery 7a41c675ec Reworked logging
Re-implemented logging using python's logging module instead of simple print() calls.
2 years ago
Peery 756b95abc8 Changed printing logs for logging purposes
Changed some logs to better suit being logged instead of just debugging purposes.
2 years ago
Peery 95498c061d Added description field to UI
Added a QTextEdit for art descriptions.
Also added the ability to save and load them from the database. Changing of the description field also triggers a unsaved changes prompt.
2 years ago
Peery 2764fef612 Replaced fuzzy DB queries with parameterized queries
Removed cases where string formatting was used for preparing SQL queries (vulnerable to SQL Injection) and replaced them with parameterization.
2 years ago
Peery 4757789efc Changed Artist SQL statements to fit column renaming
Renamed the column Artist.description to Artist.name in the SQL schema and implemented the change in the DB adapter.
2 years ago
Peery 9733828897 Added DB connection timeout
Added a timeout of 3 seconds when trying to connect to the database.
2 years ago
peery 6eb55bb3dc Cleaned up import 3 years ago
peery 5a2d4b9b73 Fixed a bug concerning aliases 3 years ago
peery 6026e736ba Added Database Schema checks
The database schema is now checked if the correct (and only the correct) tables are present.
3 years ago
Peery 907f90ffdd Introduced None title Handling
Changed filename titles to be recognized as empty and replace empty titles with an unknown string.
3 years ago
Peery 2575f45421 Fixed alias editing bug & changed empty title handling
Fixed a bug where editing the alias or implication of a tag caused a crash.
Also changed titles that were left unedited from the file name to stay empty inside the database and not be filled with the filename
3 years ago
Peery b5e226bc3a Updated DB backend for new schemas
Update the DB backend to work with an updated schema.
Also fixed a few UI bugs caused by that.
3 years ago
Peery 99069ba77d ArtNet App
Moved ArtNet from another repo here
3 years ago