sqllex
sqllex copied to clipboard
v1a0
The most pythonic ORM (for SQLite and PostgreSQL). Seriously, try it out!
**I love sqllex, but I need to use async and sqllex doesn't work properly with it.** How can I use sqllex asynchronously?
Not tested on Postgres, but the tests are prepared Old syntax  New syntax 
## 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'] } )...
## 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'...
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(...)...
# 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