pysqlx-core

Expose the methods bellow using Rust + PyO3 + PyO3-asyncio

• .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.