sqlx

sqlx copied to clipboard

Error compiling sqlx-macros v0.4.0-beta.1 in stable pc-windows-gnu

9

I'm using `rustc 1.45.2` and `gcc (Rev2, Built by MSYS2 project) 9.2.0` on windows 10. The error is related to linking `sql-macros` ``` C:/msys64/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/9.2.0/../../../../x86_64-w64-mingw32/bin/ld.exe: error: export ordinal too large: 70242...

yorodm

Improved detection of nullability for postgres

3

This query currently returns an `Option`. It would be nice to instead return `i64`, because `COUNT` is never nullable. ```rust async fn f() -> Result { sqlx::query!( "SELECT COUNT(*) FROM...

jyn514

sqlite: Nullability of column changes when order by is added to query

8

```rust let mut recs = sqlx::query!( r#" select id, path, title, album, artist from tags order by path ; "# ) .fetch(&pool); ``` in above query id ( defined as...

izderadicka

query_as! offline mode mismatched types expected struct X, found enum `std::option::Option`

10

I noticed there i a similar issue https://github.com/launchbadge/sqlx/issues/93 I am using the latest version of SQLx so I don't believe that issue was solved: ``` cargo sqlx --version cargo-sqlx 0.5.5...

Tarang

Postgres query with where in (subquery) wants to return every field as Option

2

When selecting rows using WHERE IN (SUBQUERY) sqlx erroneously(?) tries to return the rows with every field as nullable: https://github.com/regularfellow/todos-example/blob/c74f96319e15c2b181f140c0f7e497a5ccd8ac05/src/main.rs#L19-L22 ```rust struct Todo { id: i64, description: String, done: bool,...

regularfellow

0.6.0: RETURNING causes value to have an extra `Option` wrapped

20

I have defined a `NOT NULL` column: ``` CREATE TABLE IF NOT EXISTS foo( ip INTEGER NOT NULL, client_id BLOB, PRIMARY KEY(ip) ); ``` After the update to 0.6.0, wherever...

leshow

Postgres migrations: incomplete transaction handling

5

# Abstract For postgres, the migration script and the `_sqlx_migrations` state change run in two different transactions, which requires that the migration scripts are idempotent. This is quite hard to...

crepererum

sqlite: query! borrows Copy parameters

2

I've struck a strange issue with sqlite. This code ```rust fn query + 'a, limit: i64, offset: i64, ) -> BoxStream

NyxCode

How to create "repository" generic over the database?

1

I have a repository with a few create/read/update/get methods using transactions and pool. Nothing special. Now I'm trying to make it generic over the database to support both sqlite and...

gzp79

migration feature is not documented well enough

1

Readme: > `migrate`: Add support for the migration management and migrate! macro, which allow compile-time embedded migrations. `migrate!` macro documentation: > See MigrationSource for details on structure of the ./migrations...

e00E