pysqlx-engine

Changes in this Release
Refactor query method to support optional model parameter (#147)

Co-authored-by: carlos.rian [email protected]

Changes in this Release
release-2024-10-17 (#145)

The new update brings several changes. Mainly in the core, all SQL and parameters are now rust-prepared using pysqlx-core.
The PySQLX Engine maintains almost all compatibility with version 0.2.*. This release brings an extra layer of security for your SQL parameters.

Note: You may need some revisions or small changes to your code.

• (Native SQL Params): Add native support to send the parameters separately to the database. Now, the PySQLX Engine supports sending the SQL and Parameters to the database.
• (New Pool): Add new Pool async and sync. This release includes a new pool class for the PySQLX Engine to support concurrency connections.
• (Dev Mode): Now the SQL built could be showing using the env var PYSQLX_DEV_MODE; this SQL is not sent to the database; it is just a help to dev identify possible bugs previously.
• (Remove): Remove support to Python3.7
• (Add): - Add support to Python3.13

Changes in this Release
Release/sql types (#141)

• chore: Update makefile for tests-coverage command with database support

• chore: Update pyproject.toml packages formatting

• chore: Update VSCode settings for Python linting and formatting

• feat: Add database types for various data types

• feat: Add PySQLXJsonEnconder class for JSON encoding

• chore: Refactor import statements in pysqlx_engine

• Refactor import statements in pysqlx_engine

• remove benchmark tests

• chore: Update PySQLXEngineSync test_query.py with type casting and tuple parameter

• feat: Add type casting to accept None value

• chore: Update test_query.py with type casting for None value

• Refactor param_converter.py to handle NULL values in type conversion

Co-authored-by: carlos.rian [email protected]

Changes in this Release
Release/sql types (#140)

• chore: Update makefile for tests-coverage command with database support

• chore: Update pyproject.toml packages formatting

• chore: Update VSCode settings for Python linting and formatting

• feat: Add database types for various data types

• feat: Add PySQLXJsonEnconder class for JSON encoding

• chore: Refactor import statements in pysqlx_engine

• Refactor import statements in pysqlx_engine

• remove benchmark tests

• chore: Update PySQLXEngineSync test_query.py with type casting and tuple parameter

Co-authored-by: carlos.rian [email protected]

Changes in this Release

• update readme badges

Changes in this Release
Release/pysqlx core 2023 10 30 (#130)

• 🐍 Add support to Python3.12
• 🐘 Add support to Array of Enum (PostgreSQL)
• 🔁Update pysqlx-core to the latest version
• 🏛️Update pyproject.toml classifiers.

Changes in this Release
Release/pydantic v2 model (#126)

• Update minor dependencies
• Change Log config to use the BaseModel and set the const variable PYDANTIC_IS_V1
• Create a new parse to use in the v1 and v2 model from Pydantic
• Change parse to use model_dump when use Pydantic v2
• Remove Config class from BaseRow.
• Add NoneType in Union for field types
• Update pyproject.toml version and classifiers

Changes in this Release
Deps/2023 09 30 (#125)

• Update Pydantic version
• Add support to use the Pydantic version between 1.0 and <3.0
• Add Python 3.12 to the ci.yml matrix
• Support and test for Python 3.12

Changes in this Release
update readme and deps (#121)

• update readme (download badge)
• update pytest (dev deps)

Changes in this Release
Release/pydantic v2 (#120)

• update the pydantic for v2

• update the ci yaml

• create a new pipe for poetry

• remove poetry self update from ci

Changes in this Release
update dependencies to the latest version (#115)

UPDATE

• Updating exceptiongroup (1.1.1 -> 1.1.2)
• Updating anyio (3.6.2 -> 3.7.1)
• Updating certifi (2023.5.7 -> 2023.7.22)
• Updating pluggy (1.0.0 -> 1.2.0)
• Updating click (8.1.3 -> 8.1.6)
• Updating coverage (7.2.5 -> 7.2.7)
• Updating execnet (1.9.0 -> 2.0.2)
• Updating httpcore (0.17.1 -> 0.17.3)
• Updating platformdirs (3.5.1 -> 3.9.1)
• Updating pytest (7.3.1 -> 7.4.0)
• Updating typing-extensions (4.5.0 -> 4.7.1)
• Updating pydantic (1.10.7 -> 1.10.11)
• Updating pysqlx-core (0.1.44 -> 0.1.45)
• Updating pytest-asyncio (0.21.0 -> 0.21.1)
• Updating pytest-cov (4.0.0 -> 4.1.0)

Changes in this Release
update deps (#100)

Update dependencies

Lib

• pysqlx-core

Tests

• httpx
• pytest-xdist

Changes in this Release
update pysqlx-core (#98)

• update dependency pysqlx-core to version 0.1.44
• change driver rusqlite(pysqlx-core) to the latest

Changes in this Release
include escape for single quotes (#95)

Bugfix: Include escape for single quotes when value is a string or JSON

Changes in this Release
deps/update-2023-04-24 (#94)

• update readme.md

• update dependencies to latest

• docs: create SECURITY.md

• change ci.yml

Changes in this Release
Release/update deps 2023 04 06 (#88)

• update deps and fix sql server datetime build

Changes in this Release
Release/update deps (#82)

update dependencies

• update the pysqlx-core

Changes in this Release
Fix/param build improvement (#78)

• param build improvement
• change sql type check

Changes in this Release
Fix/sqlserver datetime (#77)

• Fix SQL Server bug when datetime has a timezone, the PySQLX-Engine binding to use iso format.
• Update dev deps to the latest version.

Changes in this Release
Release/support enum param (#75)

• support to enum when the enum is enum.Enum

• unit test with coverage 100%