Version History

0.4.0 - Reworked Clause Validation

Expanded/reworked handling of clauses and validation, to hopefully be much more user-friendly.
- That is, creating clauses with py-dbcn should now feel much more natural, with most extraneous escape character requirements removed.
- Previously, this was a problem particularly with quotation characters, depending on the database engine. Now this should be handled much more uniformly regardless of engine.
- This will receive further refining in the future, but it’s a big step up from original handling.
If any validation gives issues, each clause type can have validation turned off via passing in the associated bool (value False) on constructing the connector class.
- Clauses validation turned off this way will be entered as raw string into the query.

MySQL and PostgreSQL are both implemented and thoroughly tested. Both databases implement the following query types (at each of the Database/Table/Record levels, where appropriate):
- CREATE
- SHOW
- DESCRIBE
- USE
- SELECT
- INSERT
- INSERT MANY
- UPDATE
- UPDATE MANY
- DELETE
- TRUNCATE
Basic aggregation functions have been confirmed to work in both database types.
Syntax to call either database from this package is the same. Aka, goal of being database-agnostic is currently being met.
Query validation logic is in a better state than version 0.2.0, but still not as robust as desired.
Documentation describes most relevant end-user functionality. But is still not 100% complete as of writing this.

MySQL connections have been more thoroughly tested, and project setup/syntax is considered generally stable.
- PostgreSQL connections have been started, but are incomplete.
Added basic output coloring and output show/hide args.
Query validation logic could still use work, but is partially implemented.
Has been tested in a live project and seems to have desired functionality, so long as queries are fairly basic (only basic SHOW/SELECT/UPDATE/DELETE). These queries have been implemented for each of Database/Table/Record level.