17 Commits (master)
 

Author SHA1 Message Date
Peery 65cbdd6852 Added cascade deletion test for Tag
Implemented a unit test to check that tags are getting deleted when just their category gets deleted. See "cascade@category" in the result overview of the tests.
1 year ago
Peery 44ca03d7dc Changed references for Table "Tag"
The column "tag_id" was renamed "id" in the database schema. Code references have been updated to reflect this change where necessary and where helpful.
1 year ago
Peery f841643d5f Implemented Art Collection relation calls and tests
Implemented art collection relation calls and test script.
And some other minor sanity checks.
1 year ago
Peery a03549c635 Implemented Art Collection calls and tests
Implemented collection calls and test script. Does not include actual relations between collections and art.
2 years ago
Peery 81b069b0f4 Implemented Topic API and tests
Added (Artist) Topic POST and DELETE calls as well as tests for them. The tests do not include Artist-to-Topic assignment.
2 years ago
Peery 245c8737d1 Added Tag models and basic tests
Added SQLAlchemy models for tag alias and implication relations.
Added test scripts to test basic tag functionalities. This does not include implication and alias which will have their own test scripts.
2 years ago
Peery 2e233f994f Introduced art description
Added art description and corresponding tests. Each art entry can have their own description now and the models and tests have been altered to cover them too.
2 years ago
Peery 9fe017a6e3 Introduced TagCategory, bugfixes
Fixed several bugs from previous commits (Bad distribution of changes across multiple commits).
Introduced striping of string fields before send back as replies in main.py.
Implemented POST and DELETE calls for /artnet/metadata/category
Implemented tests for the new calls.
2 years ago
Peery 25c18651e4 Updated database.py
Renamed several DB tables to fit schema change.
Introduced DBCollection to fit schema change.
Added DBTagCategory.tags.
Changed return values to DB objects instead of single fields
2 years ago
Peery 458f48a8f7 Fixed rare bug in tests
Fixed a rare bug in create_delete_art.py when deleting entries. In some circumstances it would still report to be successful while failing to delete.
2 years ago
Peery b8e07eb528 Introduced URL encoding, Art2Presence relations
URL parameters are now URL decoded by the webservice
The tests now URL encode the parameters for every request.

Art2Presence relations are now creatable with POST requests to /artnet/metadata/art and listing the presences in the body.

Art2Presence tests have been introduced with relate_art.py

Also updated column name artist.description artist.name to fit a db schema update.
2 years ago
Peery bf120f2d8d Added requests to requirements.txt 2 years ago
Peery 5a8b88202e Added Unit Tests to test the WebService
Added scripts to test various API calls of the webservice by creating, modifying and deleting entries from a test database of ArtNet. Do NOT use those on production.
3 years ago
peery f2821c561e Added POST, DELETE API for presences, Fixed Cascade Issues, Added generic entry listings
Implemented a way to create, update and delete presences over the API.
Implemented code to list >ALL< artists similar to Art entries. Should be secured against requesting the entire database at some point.

Added debug prints to all API calls for clearer logging
3 years ago
Peery 442cefc834 Basic Webservice
Roughly working webservice API working with SQLAlchemy and FastAPI.
Currently only GET queries are implemented.
3 years ago
Peery 8fe2235c92 Added Requirements.txt
Added requirements with rough version pinning.
3 years ago
Peery af9005f2af Init / Added .gitignore 3 years ago