Pysqlx-engine

Latest version: v0.3.2

Safety actively analyzes 685838 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 5 of 5

0.2.9

Changes in this Release
deps/update (71)

* update pysqlx-core to the latest version
* change ci to use the poetry latest version

0.2.8

Changes in this Release
bugfix json dumps to sqlserver

* include json and string scape, change datetime to iso format
* include test coverage 100%
* change tag name to version number

refs/heads/main
Changes in this Release
deps: update and automatic tag and release

- add: automatic tag and release on GitHub
- change: the pysqlx-core dependencies to latest (0.1.28)
- update: pytest to latest version

0.2.3

Fixed bug: query without column or empty.

Generate column with prefix: `col_{index}`

**SQLite and MySQL**
If the name is a number, for example:

sql

0.2.2

1. Write a new core using `Rust` + `PyO3` + `PyO3-asyncio`.

2. Add new methods:

- `.is_healthy()` check if the connection is healthy.
- `.requires_isolation_first()` this is used to determine if the connection should be isolated before executing a sql.
- `.raw_cmd()` run a command in the database, for queries that can't be run using prepared statements.
- `.query_as_dict()` to return actual records (for example, using SELECT).
- `.query_first_as_dict()` to return actual records (for example, using SELECT).
- `.set_isolation_level()` the isolation level is set before the transaction is started. Is used to separate the transaction per level.
- `.begin()` starts a transaction.
- `.commit()` commits a transaction.
- `.rollback()` rollbacks a transaction.
- `.start_transaction()` starts a transaction with BEGIN/BEGIN TRANSACTION. By default, does not set the isolation level. But is possible to set the isolation level using the parameter isolation_level.

3. Remove the argument `as_dict` from the method `.query()` and `.query_first()`. Now, the method `.query_as_dict()` and `.query_first_as_dict()` should be used.

4. Add the argument `parameters` to the methods `.query*` and `.execute`. This is used to pass the parameters to the query.

5. Change documentation: add new examples.

7. Write tests for the new core and the new methods.

Page 5 of 5

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.