carlos-rian / pysqlx-engine Goto Github PK

When HTTPX has a timeout is created a raise with a generic error.

Implement aenter and aexit to open and close the connection using the async with context.

Create benchmark tests using any driver vs pysqlx-engine

PostgreSQL.

• sync - psycopg2
• async - asyncpg

MySQL

• sync - mysql-connector-python
• async - aiomysql

SQLite

• sync - sqlite3
• async - aiosqlite

MS SQL Server

• sync - pyodbc

Test Topics

• pysqlx-engine VS psycopg2
• pysqlx-engine VS asyncpg
• pysqlx-engine VS mysql-connector-python
• pysqlx-engine VS aiomysql
• pysqlx-engine VS sqlite3
• pysqlx-engine VS aiosqlite
• pysqlx-engine VS pyodbc

Hey guys,

I try to use quaint in a simple benchmark where the database has a lag/delay in response.
So I'm using pg_sleep to simulate this delay.

But with this command returning a void, Quaint has an error.

In that case, would it be better to deserialize to null?

DB: PostgreSQL
Rust: 1.64.0
Quaint: https://github.com/prisma/quaint

Example:

// query
let sql = "SELECT pg_sleep(0.1);";

// quaint connection
let conn = Quaint::new("postgresql://postgres:postgrespw@localhost:49153").await.unwrap();

// run query
let result = conn.query_raw(sql, &[]).await.unwrap();

Error: Column type 'void' could not be deserialized from the database.

issue link: prisma/quaint#414

Description

Quaint returns a wrong type when the type is date in the database for MySQL, Quaint returns a datetime.

Example:

SQL

SELECT CURRENT_DATE();

SQLX result
2022-12-24

Quaint result
2022-12-24T00:00:00.000Z

issue link: prisma/quaint#427

Write the unitest to sync and async engine.

• unit test to sync
• unit test to async
• run coverage 100%

Description

I ran a query_raw where the PostgreSQL column is of type CIDR or MacAddr but I got this error.

This message is in the src/ast/values.rs file, line 788.

Value in column: 192.168.100.128/25 and 08:00:2b:01:02:03

Error

CIDR
Error querying the database: error deserializing column 24: cannot convert between the Rust type core::option::Option<std::net::ip::IpAddr> and the Postgres type cidr

MacAddr has the same problem
Column type 'macaddr' could not be deserialized from the database.

issue core link: prisma/quaint#416

Add a tutorial to open and close the connection using the async with context.

With pysqlx-core implemented, now let's expose the features and include documentation with example usage.

• expose methods
• implement pydantic parse
• include error mapping
• support sync and async
• include documentation function

Problem with arrays for PostgreSQL.

Remove double quotes when values are string.