V1A0

Code blocks color-theme unreadable for Python syntax

30

Python code absolutely unreadable with any color theme, it's need more contrast color-theme like `Darkobot` or `Tomorrow Night Eighties`  

## Code ```python db = PostgreSQLx( engine=psycopg2, dbname='test_sqllex', user='test_sqllex', password='test_sqllex' ) db['employee'].select('id, firstName') db['employee'].select('id', 'firstName') ``` ```shell Error Traceback (most recent call last): File "some_postgresqlx.py", line 874, in test_select expected,...

### [PEP 440 – Version Identification and Dependency Specification. Public version identifiers](https://peps.python.org/pep-0440/#public-version-identifiers) > The canonical public version identifiers MUST comply with the following scheme: ```regex [N!]N(.N)*[{a|b|rc}N][.postN][.devN] ``` > Public version...

Some doc's examples ([like this](https://v1a0.dev/sqllex/about-searchcondition.html)) have implicit imports: ```python from sqllex import * db = SQLite3x(path=...) db.create_table( 'users', { 'id': [INTEGER, PRIMARY_KEY, UNIQUE], 'name': [TEXT, NOT_NULL, DEFAULT, 'Unknown'] } )...

ISSUE | SPEED TESTS | Open discussion

4

## Sqllex v0.1.10.3b Converting `(tuples)` to `[lists]` costs for select-like methods 55.8% of all time. This is an results for: ```python def select_where_1(db: SQLite3x): db.select( 'main', 'id', WHERE={ 'name': 'Alex'...

FEATURE | "With-as" statement

1

Add `__enter__` and `__exit__` methods for db, table and column classes to make possible nice temporary connection. ```python from sqllex import SQLite3x with SQLite3x('/path/database.db') as db: # creting connection db.insert(...)...

FEATURE | Add new constants

1

# In this issue you can leave your request for new constant. ## List of existing constants: ### SQLite3x ``` __all__ = [ 'ABORT', 'ALL', 'AS', 'AUTOINCREMENT', 'BLOB', 'CHECK', 'CONST_PRIORITY',...

Get size of SQLite3x database ```python db: SQLite3x = ... print(db.get_size()) print(db._size) print(db._file_size) ```

Rename/migrate SQLite database and don't destroy all existing connected objects. ```python db: SQLite3x = ... db.rename("new_name") db._migrate("new_path") ``` I guess it might be useful

### Add to [docs](https://github.com/v1a0/sqllex/tree/main/docs) few linked like this (shadow) examples with inline href right in code. I think it looks cool 🔥 ## Example ```python db: SQLite3x = ... db.select(...