Sqllex Versions Save

Hotfix for sqllex v0.3.0

• Typing fix for __getattr__
• README and docs upd
• Time-tests fixed

What's new

• Removed psycopg2 requirement (dependency)
• Dependency calls were replaced by an abstract classes
• ABColumn replaced by child classes SQLite3xColumn PostgreSQLxColumn
• Fixing typing issues
• Docs update (issue https://github.com/v1a0/sqllex/issues/60)
• Tests structure changed, finished tests for postgresqlx
• Changed abstractions sructure for psql engine (v0.3.0b2)
• Minor bugfix

How to use Postgres now

Due to psycopg2 was removed from sqllex dependencies now you have to install it manually for postures support (or you can use any similar engine). After this just add one new parameter ("engine") into PostgreSQLx constructor:

import psycopg2

db = sx.PostgreSQLx(
    engine=psycopg2,        # Postgres engine
    ...
)

Read PostgreSQLx docs for more details.

Why psycopg2 is not "from-the-box" anymore

Many developers who use sqllex only to work with SQLite have complained about problems installing the package due to the psycopg2 dependency. I also had these difficulties. One and only decision was to install this dependency manually from binaries. Therefore, it was decided to rid the library of a problematic dependency, but leave the ability to connect it back as needed.

v0.2.3

• Release version (changed semantic versioning) (issue #61)

v0.2.2.3

• Added catching optional connection_kwargs for SQLite3x (with init) db = SQLite3x(path=..., ..., check_same_thread=False)
• Co-Authored-By: dannkunt [email protected]

v0.2.2.2

• Added Python versions (3.8, 3.10) supported mark in setup.py
• Auto detection of supported python versions for README
• Added workflow for Python 3.10 unit tests

v0.2.2.2a1

• Removed unnecessary deletion of local variable self in function del AbstractDatabase
• Unreachable statement in copy_docs
• Added '__all__' for constants/sqlite.py, constants/postgresql.py
• Updated '__all__' for constants/__init__.py

v0.2.2.1

• Issue fixed, added new classes from v0.2.2.0 into init files of next dirs sqllex.classes and sqllex.core.entities

• Added TRANSACTIONS support!
• • Added new classes SQLite3xTransaction, PostgreSQLxTransaction, TransactionStatus, AbstractTransaction
• • read more
• Docs upd

• Added GROUP BY (issue #54)
• Tests updated (added tests for GROUP BY, raw sql tablse selects moved to one func)
• Typing fixing
• Docs upd
• Minor bugfixes

• Fixed issue #59
• Fixed issue #52
• Complete remastering of unit tests
• Speed tests moved to tests_sqllex.py
• Typing mistakes fixed
• Docs update
• Other minor fixes

• CVE-2022-0329, Delgan/loguru#563
• Changed dependency version up to loguru v0.6.0
• Added feature to set optional sqlite3 connection parameters #57
• Added option to desable connetion with Database object init #56
• [IN PROGRESS] "With-as" statement #55
• Fixed BUG | Typing mistakes #51
• Docs update

• Issue #46 fixed
• LIKE (and all other pql const-s) added to sqllex.constants.sqlite
• WHERE type checking fixed
• docs update

• AbstractDatabase __getitem__ and get_table got safeness checking "is table exists"
• get_table got redirection to __getitem__
• v0.2 upd warrning changed a little

• setup/installation hotfix