fix(deps): update rust crate sqlx to 0.7

renovate[bot] commented 1 year ago

This PR contains the following updates:

Package	Type	Update	Change
sqlx	dependencies	minor	`0.6` -> `0.7`

Release Notes

launchbadge/sqlx (sqlx)

### [`v0.7.2`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#072---2023-09-25) 23 pull requests were merged this release cycle. ##### Added - \[[#2121]]: Add JSON support to `FromRow` derive \[\[[@95ulisse](https://togithub.com/95ulisse)]] - \[[#2533]]: Implement mysql_clear_password \[\[[@ldanilek](https://togithub.com/ldanilek)]] - \[[#2538]]: cli: add --target-version CLI flags for migrate run/revert \[\[[@inahga](https://togithub.com/inahga)]] - \[[#2577]]: supplement Postgres listen example with a small chat example \[\[[@JockeM](https://togithub.com/JockeM)]] - \[[#2602]]: Support naming migrations sequentially \[\[[@vmax](https://togithub.com/vmax)]] - \[[#2634]]: Adding PgHasArrayType for &\[u8;N] \[\[[@snf](https://togithub.com/snf)]] - \[[#2646]]: Support for setting client certificate and key from bytes \[\[[@wyhaya](https://togithub.com/wyhaya)]] - \[[#2664]]: Automatically infer migration type \[\[[@vmax](https://togithub.com/vmax)]] - \[[#2712]]: Add impl for `Type`, `Decode`, and `Encode` for `Box` and `Box<[u8]>` \[\[[@grant0417](https://togithub.com/grant0417)]] ##### Changed - \[[#2650]]: Cleanup format arguments \[\[[@nyurik](https://togithub.com/nyurik)]] - \[[#2695]]: remove \&mut PoolConnection from Executor docs \[\[[@olback](https://togithub.com/olback)]] - This impl was removed in 0.7.0 because of coherence issues. - \[[#2706]]: Clarify where optional features should be enabled \[\[[@kryptan](https://togithub.com/kryptan)]] - \[[#2717]]: Update README.md \[\[[@fermanjj](https://togithub.com/fermanjj)]] - \[[#2739]]: Bump mariadb CI images + mysql unpin \[\[[@grooverdan](https://togithub.com/grooverdan)]] - \[[#2742]]: Implemented poll_flush for Box\ \[\[[@bobozaur](https://togithub.com/bobozaur)]] - \[[#2740]]: Remove sealed trait comments from documentation \[\[[@bobozaur](https://togithub.com/bobozaur)]] - \[[#2750]]: Fix [#2384](https://togithub.com/launchbadge/sqlx/issues/2384), bump flume to v0.11.0 \[\[[@madadam](https://togithub.com/madadam)]] - \[[#2757]]: Remove unused `remove_dir_all` crate from `sqlx-cli`, fixes RUSTSEC-2023-0018 \[\[[@aldur](https://togithub.com/aldur)]] ##### Fixed - \[[#2624]]: Documentation typo: BYTE -> BINARY \[\[[@sebastianv89](https://togithub.com/sebastianv89)]] - \[[#2628]]: docs: 0.7 is stable in the entire README \[\[[@marcusirgens](https://togithub.com/marcusirgens)]] - \[[#2630]]: fix(postgres): fix buffer management in PgCopyIn::read_from \[\[[@tsing](https://togithub.com/tsing)]] - \[[#2651]]: Chore: Fix few build warnings, and make CI fail on warn \[\[[@nyurik](https://togithub.com/nyurik)]] - \[[#2670]]: fix: ignore extra fields in Postgres describe parsing \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2687]]: docs: Fix description of `min_connections` \[\[[@hakoerber](https://togithub.com/hakoerber)]] [#2121]: https://togithub.com/launchbadge/sqlx/pull/2121 [#2533]: https://togithub.com/launchbadge/sqlx/pull/2533 [#2538]: https://togithub.com/launchbadge/sqlx/pull/2538 [#2577]: https://togithub.com/launchbadge/sqlx/pull/2577 [#2602]: https://togithub.com/launchbadge/sqlx/pull/2602 [#2624]: https://togithub.com/launchbadge/sqlx/pull/2624 [#2628]: https://togithub.com/launchbadge/sqlx/pull/2628 [#2630]: https://togithub.com/launchbadge/sqlx/pull/2630 [#2634]: https://togithub.com/launchbadge/sqlx/pull/2634 [#2646]: https://togithub.com/launchbadge/sqlx/pull/2646 [#2650]: https://togithub.com/launchbadge/sqlx/pull/2650 [#2651]: https://togithub.com/launchbadge/sqlx/pull/2651 [#2664]: https://togithub.com/launchbadge/sqlx/pull/2664 [#2670]: https://togithub.com/launchbadge/sqlx/pull/2670 [#2687]: https://togithub.com/launchbadge/sqlx/pull/2687 [#2695]: https://togithub.com/launchbadge/sqlx/pull/2695 [#2706]: https://togithub.com/launchbadge/sqlx/pull/2706 [#2712]: https://togithub.com/launchbadge/sqlx/pull/2712 [#2717]: https://togithub.com/launchbadge/sqlx/pull/2717 [#2739]: https://togithub.com/launchbadge/sqlx/pull/2739 [#2740]: https://togithub.com/launchbadge/sqlx/pull/2740 [#2742]: https://togithub.com/launchbadge/sqlx/pull/2742 [#2750]: https://togithub.com/launchbadge/sqlx/pull/2750 [#2757]: https://togithub.com/launchbadge/sqlx/pull/2757 ### [`v0.7.1`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#071---2023-07-14) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.7.0...v0.7.1) This release mainly addresses issues reported with the 0.7.0 release. 16 pull requests were merged this release cycle. ##### Added - \[[#2551]]: Introduce build_query_scalar for QueryBuilder \[\[[@iamquang95](https://togithub.com/iamquang95)]] - \[[#2605]]: Implement Default for QueryBuilder \[\[[@Xydez](https://togithub.com/Xydez)]] - \[[#2616]]: feat(sqlx-core): add table function to database error \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]] - \[[#2619]]: feat: allow opt-out of `PgHasArrayType` with `#[derive(sqlx::Type)]` \[\[[@abonander](https://togithub.com/abonander)]] - TL;DR: if you're getting errors from `#[derive(sqlx::Type)]` with `#[sqlx(transparent)]` regarding `PgHasArrayType` not being implemented, add `#[sqlx(no_pg_array)]` to fix. ##### Changed - \[[#2566]]: improve docs about migration files \[\[[@jnnnnn](https://togithub.com/jnnnnn)]] - \[[#2576]]: Major Version Update clap to 4.0 \[\[[@titaniumtraveler](https://togithub.com/titaniumtraveler)]] - \[[#2597]]: Bump webpki-roots to v0.24 \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2603]]: docs(changelog): be more verbose about offline mode breaking change \[\[[@mrl5](https://togithub.com/mrl5)]] ##### Fixed - \[[#2553]]: Implement `Clone` for `PoolOptions` manually ([#2548](https://togithub.com/launchbadge/sqlx/issues/2548)) \[\[[@alilleybrinker](https://togithub.com/alilleybrinker)]] - \[[#2580]]: Update README.md now that 0.7.0 is no longer in alpha \[\[[@saolof](https://togithub.com/saolof)]] - \[[#2585]]: Fix for Issue [#2549](https://togithub.com/launchbadge/sqlx/issues/2549) - cannot use feature "rust_decimal" without also using "bigdecimal" \[\[[@deneut](https://togithub.com/deneut)]] - \[[#2586]]: Fix optional dependency on sqlx-macros \[\[[@kitterion](https://togithub.com/kitterion)]] - \[[#2593]]: Correct mention of the `tls-native-tls` in the documentation. \[\[[@denschub](https://togithub.com/denschub)]] - \[[#2599]]: Remove incorrect CAST in test database cleanup for MySQL. \[\[[@fd](https://togithub.com/fd)]] - \[[#2613]]: Fix readme.md to reduce confusion about optional features (decimal->rust_decimal) \[\[[@vabka](https://togithub.com/vabka)]] - \[[#2620]]: fix(sqlite/any): encode bool as integer \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]] [#2551]: https://togithub.com/launchbadge/sqlx/pull/2551 [#2553]: https://togithub.com/launchbadge/sqlx/pull/2553 [#2566]: https://togithub.com/launchbadge/sqlx/pull/2566 [#2576]: https://togithub.com/launchbadge/sqlx/pull/2576 [#2580]: https://togithub.com/launchbadge/sqlx/pull/2580 [#2585]: https://togithub.com/launchbadge/sqlx/pull/2585 [#2586]: https://togithub.com/launchbadge/sqlx/pull/2586 [#2593]: https://togithub.com/launchbadge/sqlx/pull/2593 [#2597]: https://togithub.com/launchbadge/sqlx/pull/2597 [#2599]: https://togithub.com/launchbadge/sqlx/pull/2599 [#2603]: https://togithub.com/launchbadge/sqlx/pull/2603 [#2605]: https://togithub.com/launchbadge/sqlx/pull/2605 [#2613]: https://togithub.com/launchbadge/sqlx/pull/2613 [#2616]: https://togithub.com/launchbadge/sqlx/pull/2616 [#2619]: https://togithub.com/launchbadge/sqlx/pull/2619 [#2620]: https://togithub.com/launchbadge/sqlx/pull/2620 ### [`v0.7.0`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#070---2023-06-30) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.6.3...v0.7.0) At least **70 pull requests** were merged this release cycle! (The exact count is muddied with pull requests for alpha releases and such.) And we gained 43 new contributors! Thank you to everyone who helped make this release a reality. ##### Breaking Many revisions were made to query analysis in the SQLite driver; these are all potentially breaking changes as they can change the output of `sqlx::query!()` *et al*. We'd like to thank \[\[[@tyrelr](https://togithub.com/tyrelr)]] for their numerous PRs to this area. The MSSQL driver has been removed as it was not nearly at the same maturity level as the other drivers. [As previously announced][sqlx-pro], we have plans to introduce a fully featured replacement as a premium offering, alongside drivers for other proprietary databases, with the goal to support full-time development on SQLx. If interested, please email your inquiry to sqlx@launchbadge.com. The offline mode for the queries has been changed to use a separate file per `query!()` invocation, which is intended to reduce the number of conflicts when merging branches in a project that both modified queries. This means that CLI flag `--merged` is no longer supported. See \[[#2363]] for details and make sure that your `sqlx-cli` version is in sync with the `sqlx` version in your project. The type ascription override syntax for the query macros has been deprecated, as parse support for it has been removed in `syn 2.0`, which we'll be upgrading to in the next breaking release. This can be replaced with type overrides using casting syntax (`as`). See \[[#2483]] for details. - \[[#1946]]: Fix compile time verification performance regression for sqlite \[\[[@liningpan](https://togithub.com/liningpan)]] - \[[#1960]]: Fix sqlite update return and order by type inference \[\[[@tyrelr](https://togithub.com/tyrelr)]] - \[[#1984]]: Sqlite EXPLAIN type inference improvements \[\[[@rongcuid](https://togithub.com/rongcuid)]] - \[[#2039]]: Break drivers out into separate crates, clean up some technical debt \[\[[@abonander](https://togithub.com/abonander)]] - All deprecated items have been removed. - The `mssql` feature and associated database driver has been deleted from the source tree. It will return as part of our planned SQLx Pro offering as a from-scratch rewrite with extra features (such as TLS) and type integrations that were previously missing. - The `runtime-actix-*` features have been deleted. They were previously changed to be aliases of their `runtime-tokio-*` counterparts for backwards compatibility reasons, but their continued existence is misleading as SQLx has no special knowledge of Actix anymore. - To fix, simply replace the `runtime-actix-*` feature with its `runtime-tokio-*` equivalent. - The `git2` feature has been removed. This was a requested integration from a while ago that over time made less and less sense to be part of SQLx itself. We have to be careful with the crates we add to our public API as each one introduces yet another semver hazard. The expected replacement is to make `#[derive(sqlx::Type)]` useful enough that users can write wrapper types for whatever they want to use without SQLx needing to be specifically aware of it. - The `Executor` impls for `Transaction` and `PoolConnection` have been deleted because they cannot exist in the new crate architecture without rewriting the `Executor` trait entirely. - To fix this breakage, simply add a dereference where an `impl Executor` is expected, as they both dereference to the inner connection type which will still implement it: - `&mut transaction` -> `&mut *transaction` - `&mut connection` -> `&mut *connection` - These cannot be blanket impls as it triggers an overflow in the compiler due to the lack of lazy normalization, and the driver crates cannot provide their own impls due to the orphan rule. - We're expecting to do another major refactor of traits to incorporate generic associated types (GAT). This will mean another major release of SQLx but ideally most API usage will not need to change significantly, if at all. - The fields of `Migrator` are now `#[doc(hidden)]` and semver-exempt; they weren't meant to be public. - The `offline` feature has been removed from the `sqlx` facade crate and is enabled unconditionally as most users are expected to have enabled it anyway and disabling it doesn't seem to appreciably affect compile times. - The `decimal` feature has been renamed to `rust_decimal` to match the crate it actually provides integrations for. - `AnyDriver` and `AnyConnection` now require either `sqlx::any::install_drivers()` or `sqlx::any::install_default_drivers()` to be called at some point during the process' lifetime before the first connection is made, as the set of possible drivers is now determined at runtime. This was determined to be the least painful way to provide knowledge of database drivers to `Any` without them being hardcoded. - The `AnyEncode` trait has been removed. - \[[#2109]]: feat: better database errors \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]] - \[[#2094]]: Update libsqlite3-sys to 0.25.1 \[\[[@penberg](https://togithub.com/penberg)]] - Alongside this upgrade, we are now considering the linkage to `libsqlite3-sys` to be **semver-exempt**, and we reserve the right to upgrade it as necessary. If you are using `libsqlite3-sys` directly or a crate that links it such as `rusqlite`, you should pin the versions of both crates to avoid breakages from `cargo update`: ```toml [dependencies] sqlx = { version = "=0.7.0", features = ["sqlite"] } rusqlite = "=0.29.0" ``` - \[[#2132]]: fix: use owned Builder pattern for ConnectOptions \[\[[@ar3s3ru](https://togithub.com/ar3s3ru)]] - \[[#2253]]: Sqlite describe fixes \[\[[@tyrelr](https://togithub.com/tyrelr)]] - \[[#2285]]: `time`: Assume UTC when decoding a DATETIME column in sqlite \[\[[@nstinus](https://togithub.com/nstinus)]] - \[[#2363]]: \[offline] Change prepare to one-file-per-query \[\[[@cycraig](https://togithub.com/cycraig)]] - \[[#2387]]: PATCH: bump libsqlite3-sys to patched version \[\[[@grantkee](https://togithub.com/grantkee)]] - \[[#2409]]: fix([#2407](https://togithub.com/launchbadge/sqlx/issues/2407)): respect the HaltIfNull opcode when determining nullability \[\[[@arlyon](https://togithub.com/arlyon)]] - \[[#2459]]: limit the number of instructions that can be evaluated \[\[[@tyrelr](https://togithub.com/tyrelr)]] - \[[#2467]]: Add and improve sqlite describe performance benchmarks \[\[[@tyrelr](https://togithub.com/tyrelr)]] - \[[#2491]]: sqlite date macro support \[\[[@Arcayr](https://togithub.com/Arcayr)]] - Changes `OffsetDateTime` to be the first type used when deserializing a `timestamp` type. - \[[#2496]]: Bump to libsqlite3-sys 0.26 \[\[[@mdecimus](https://togithub.com/mdecimus)]] - \[[#2508]]: Sqlite analytical \[\[[@tyrelr](https://togithub.com/tyrelr)]] ##### Added - \[[#1850]]: Add client SSL authentication using key-file for Postgres, MySQL and MariaDB \[\[[@ThibsG](https://togithub.com/ThibsG)]] - \[[#2088]]: feat: Add set_connect_options method to Pool \[\[[@moatra](https://togithub.com/moatra)]] - \[[#2113]]: Expose PoolOptions for reading \[\[[@FSMaxB](https://togithub.com/FSMaxB)]] - \[[#2115]]: Allow using complex types in `try_from` when deriving `FromRow` \[\[[@95ulisse](https://togithub.com/95ulisse)]] - \[[#2116]]: \[SQLite] Add option to execute `PRAGMA optimize;` on close of a connection \[\[[@miles170](https://togithub.com/miles170)]] - \[[#2189]]: Added regexp support in sqlite \[\[[@VictorKoenders](https://togithub.com/VictorKoenders)]] - \[[#2224]]: Add From impls for Json \[\[[@dbeckwith](https://togithub.com/dbeckwith)]] - \[[#2256]]: add progress handler support to sqlite \[\[[@nbaztec](https://togithub.com/nbaztec)]] - \[[#2366]]: Allow ignoring attributes for deriving FromRow \[\[[@grgi](https://togithub.com/grgi)]] - \[[#2369]]: new type support in query_as \[\[[@0xdeafbeef](https://togithub.com/0xdeafbeef)]] - \[[#2379]]: feat: add `Connection::shrink_buffers`, `PoolConnection::close` \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2400]]: fix(docs): example of `sqlx_macros_unstable` in config.toml \[\[[@df51d](https://togithub.com/df51d)]] - \[[#2469]]: Add Simple format for Uuid for MySQL & SQLite. \[\[[@MidasLamb](https://togithub.com/MidasLamb)]] - \[[#2483]]: chore: add deprecation notice for type ascription use \[\[[@saiintbrisson](https://togithub.com/saiintbrisson)]] - \[[#2506]]: add args to query builder ([#2494](https://togithub.com/launchbadge/sqlx/issues/2494)) \[\[[@cemoktra](https://togithub.com/cemoktra)]] - \[[#2554]]: Impl `AsMut` for advisory lock types ([#2520](https://togithub.com/launchbadge/sqlx/issues/2520)) \[\[[@alilleybrinker](https://togithub.com/alilleybrinker)]] - \[[#2559]]: Add CLI autocompletion using clap_complete \[\[[@titaniumtraveler](https://togithub.com/titaniumtraveler)]] ##### Changed - \[[#2185]]: Initial work to switch to `tracing` \[\[[@CosmicHorrorDev](https://togithub.com/CosmicHorrorDev)]] - \[[#2193]]: Start testing on Postgres 15 and drop Postgres 10 \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - We reserve the right to drop support for end-of-lifed database versions [as discussed in our FAQ][faq-db-version]. - \[[#2213]]: Use `let else` statements in favor of macro \[\[[@OverHash](https://togithub.com/OverHash)]] - \[[#2365]]: Update dependencies \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2371]]: Disable rustls crate logging feature by default up to date \[\[[@sergeiivankov](https://togithub.com/sergeiivankov)]] - \[[#2373]]: chore: Use tracing's fields to get structured logs \[\[[@jaysonsantos](https://togithub.com/jaysonsantos)]] - \[[#2393]]: Lower default logging level for statements to Debug \[\[[@bnoctis](https://togithub.com/bnoctis)]] - \[[#2445]]: Traverse symlinks when resolving migrations \[\[[@tgeoghegan](https://togithub.com/tgeoghegan)]] - \[[#2485]]: chore(sqlx-postgres): replace `dirs` with `home` & `etcetera` \[\[[@utkarshgupta137](https://togithub.com/utkarshgupta137)]] - \[[#2515]]: Bump mac_address to 1.1.5 \[\[[@repnop](https://togithub.com/repnop)]] - \[[#2440]]: Update rustls to 0.21, webpki-roots to 0.23 \[\[[@SergioBenitez](https://togithub.com/SergioBenitez)]] - \[[#2563]]: Update rsa to 0.9 \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2564]]: Update bitflags to v2 \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2565]]: Bump indexmap and ahash \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2574]]: doc: make it clear that `ConnectOptions` types impl `FromStr` \[\[[@abonander](https://togithub.com/abonander)]] ##### Fixed - \[[#2098]]: Fix sqlite compilation \[\[[@cycraig](https://togithub.com/cycraig)]] - \[[#2120]]: fix logical merge conflict \[\[[@tyrelr](https://togithub.com/tyrelr)]] - \[[#2133]]: Postgres OID resolution query does not take into account current `search_path` \[\[[@95ulisse](https://togithub.com/95ulisse)]] - \[[#2156]]: Fixed typo. \[\[[@cdbfoster](https://togithub.com/cdbfoster)]] - \[[#2179]]: fix: ensures recover from fail with PgCopyIn \[\[[@andyquinterom](https://togithub.com/andyquinterom)]] - \[[#2200]]: Run CI on \*-dev branch \[\[[@joehillen](https://togithub.com/joehillen)]] - \[[#2222]]: Add context to confusing sqlx prepare parse error \[\[[@laundmo](https://togithub.com/laundmo)]] - \[[#2271]]: feat: support calling Postgres procedures with the macros \[\[[@bgeron](https://togithub.com/bgeron)]] - \[[#2282]]: Don't run EXPLAIN nullability analysis on Materialize \[\[[@benesch](https://togithub.com/benesch)]] - \[[#2319]]: Set whoami default-features to false \[\[[@thedodd](https://togithub.com/thedodd)]] - \[[#2352]]: Preparing 0.7.0-alpha.1 release \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2355]]: Fixed the example code for `sqlx::test` \[\[[@kenkoooo](https://togithub.com/kenkoooo)]] - \[[#2367]]: Fix sqlx-cli create, drop, migrate \[\[[@cycraig](https://togithub.com/cycraig)]] - \[[#2376]]: fix(pool): close when last handle is dropped, extra check in `try_acquire` \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2378]]: Fix README build badge \[\[[@dbrgn](https://togithub.com/dbrgn)]] - \[[#2398]]: fix(prepare): store temporary query files inside the workspace \[\[[@aschey](https://togithub.com/aschey)]] - \[[#2402]]: fix: drop old time 0.1.44 dep \[\[[@codahale](https://togithub.com/codahale)]] - \[[#2413]]: fix(macros-core): use of undeclared `tracked_path` \[\[[@df51d](https://togithub.com/df51d)]] - \[[#2420]]: Enable runtime-tokio feature of sqlx when building sqlx-cli \[\[[@paolobarbolini](https://togithub.com/paolobarbolini)]] - \[[#2453]]: in README.md, correct spelling and grammar \[\[[@vizvasrj](https://togithub.com/vizvasrj)]] - \[[#2454]]: fix: ensure fresh test db's aren't accidentally deleted by do_cleanup \[\[[@phlip9](https://togithub.com/phlip9)]] - \[[#2507]]: Exposing the Oid of PostgreSQL types \[\[[@Razican](https://togithub.com/Razican)]] - \[[#2519]]: Use ::std::result::Result::Ok in output.rs \[\[[@southball](https://togithub.com/southball)]] - \[[#2569]]: Fix broken links to mysql error documentation \[\[[@titaniumtraveler](https://togithub.com/titaniumtraveler)]] - \[[#2570]]: Add a newline to the generated JSON files \[\[[@nyurik](https://togithub.com/nyurik)]] - \[[#2572]]: Do not panic when `PrepareOk` fails to decode \[\[[@stepantubanov](https://togithub.com/stepantubanov)]] - \[[#2573]]: fix(sqlite) Do not drop notify mutex guard until after condvar is triggered \[\[[@andrewwhitehead](https://togithub.com/andrewwhitehead)]] [sqlx-pro]: https://togithub.com/launchbadge/sqlx/discussions/1616 [faq-db-version]: https://togithub.com/launchbadge/sqlx/blob/main/FAQ.md#what-database-versions-does-sqlx-support [#1850]: https://togithub.com/launchbadge/sqlx/pull/1850 [#1946]: https://togithub.com/launchbadge/sqlx/pull/1946 [#1960]: https://togithub.com/launchbadge/sqlx/pull/1960 [#1984]: https://togithub.com/launchbadge/sqlx/pull/1984 [#2039]: https://togithub.com/launchbadge/sqlx/pull/2039 [#2088]: https://togithub.com/launchbadge/sqlx/pull/2088 [#2092]: https://togithub.com/launchbadge/sqlx/pull/2092 [#2094]: https://togithub.com/launchbadge/sqlx/pull/2094 [#2098]: https://togithub.com/launchbadge/sqlx/pull/2098 [#2109]: https://togithub.com/launchbadge/sqlx/pull/2109 [#2113]: https://togithub.com/launchbadge/sqlx/pull/2113 [#2115]: https://togithub.com/launchbadge/sqlx/pull/2115 [#2116]: https://togithub.com/launchbadge/sqlx/pull/2116 [#2120]: https://togithub.com/launchbadge/sqlx/pull/2120 [#2132]: https://togithub.com/launchbadge/sqlx/pull/2132 [#2133]: https://togithub.com/launchbadge/sqlx/pull/2133 [#2156]: https://togithub.com/launchbadge/sqlx/pull/2156 [#2179]: https://togithub.com/launchbadge/sqlx/pull/2179 [#2185]: https://togithub.com/launchbadge/sqlx/pull/2185 [#2189]: https://togithub.com/launchbadge/sqlx/pull/2189 [#2193]: https://togithub.com/launchbadge/sqlx/pull/2193 [#2200]: https://togithub.com/launchbadge/sqlx/pull/2200 [#2213]: https://togithub.com/launchbadge/sqlx/pull/2213 [#2222]: https://togithub.com/launchbadge/sqlx/pull/2222 [#2224]: https://togithub.com/launchbadge/sqlx/pull/2224 [#2253]: https://togithub.com/launchbadge/sqlx/pull/2253 [#2256]: https://togithub.com/launchbadge/sqlx/pull/2256 [#2271]: https://togithub.com/launchbadge/sqlx/pull/2271 [#2282]: https://togithub.com/launchbadge/sqlx/pull/2282 [#2285]: https://togithub.com/launchbadge/sqlx/pull/2285 [#2319]: https://togithub.com/launchbadge/sqlx/pull/2319 [#2352]: https://togithub.com/launchbadge/sqlx/pull/2352 [#2355]: https://togithub.com/launchbadge/sqlx/pull/2355 [#2363]: https://togithub.com/launchbadge/sqlx/pull/2363 [#2365]: https://togithub.com/launchbadge/sqlx/pull/2365 [#2366]: https://togithub.com/launchbadge/sqlx/pull/2366 [#2367]: https://togithub.com/launchbadge/sqlx/pull/2367 [#2369]: https://togithub.com/launchbadge/sqlx/pull/2369 [#2371]: https://togithub.com/launchbadge/sqlx/pull/2371 [#2373]: https://togithub.com/launchbadge/sqlx/pull/2373 [#2376]: https://togithub.com/launchbadge/sqlx/pull/2376 [#2378]: https://togithub.com/launchbadge/sqlx/pull/2378 [#2379]: https://togithub.com/launchbadge/sqlx/pull/2379 [#2387]: https://togithub.com/launchbadge/sqlx/pull/2387 [#2393]: https://togithub.com/launchbadge/sqlx/pull/2393 [#2398]: https://togithub.com/launchbadge/sqlx/pull/2398 [#2400]: https://togithub.com/launchbadge/sqlx/pull/2400 [#2402]: https://togithub.com/launchbadge/sqlx/pull/2402 [#2408]: https://togithub.com/launchbadge/sqlx/pull/2408 [#2409]: https://togithub.com/launchbadge/sqlx/pull/2409 [#2413]: https://togithub.com/launchbadge/sqlx/pull/2413 [#2420]: https://togithub.com/launchbadge/sqlx/pull/2420 [#2440]: https://togithub.com/launchbadge/sqlx/pull/2440 [#2445]: https://togithub.com/launchbadge/sqlx/pull/2445 [#2453]: https://togithub.com/launchbadge/sqlx/pull/2453 [#2454]: https://togithub.com/launchbadge/sqlx/pull/2454 [#2459]: https://togithub.com/launchbadge/sqlx/pull/2459 [#2467]: https://togithub.com/launchbadge/sqlx/pull/2467 [#2469]: https://togithub.com/launchbadge/sqlx/pull/2469 [#2483]: https://togithub.com/launchbadge/sqlx/pull/2483 [#2485]: https://togithub.com/launchbadge/sqlx/pull/2485 [#2491]: https://togithub.com/launchbadge/sqlx/pull/2491 [#2496]: https://togithub.com/launchbadge/sqlx/pull/2496 [#2506]: https://togithub.com/launchbadge/sqlx/pull/2506 [#2507]: https://togithub.com/launchbadge/sqlx/pull/2507 [#2508]: https://togithub.com/launchbadge/sqlx/pull/2508 [#2515]: https://togithub.com/launchbadge/sqlx/pull/2515 [#2519]: https://togithub.com/launchbadge/sqlx/pull/2519 [#2554]: https://togithub.com/launchbadge/sqlx/pull/2554 [#2559]: https://togithub.com/launchbadge/sqlx/pull/2559 [#2563]: https://togithub.com/launchbadge/sqlx/pull/2563 [#2564]: https://togithub.com/launchbadge/sqlx/pull/2564 [#2565]: https://togithub.com/launchbadge/sqlx/pull/2565 [#2569]: https://togithub.com/launchbadge/sqlx/pull/2569 [#2570]: https://togithub.com/launchbadge/sqlx/pull/2570 [#2572]: https://togithub.com/launchbadge/sqlx/pull/2572 [#2573]: https://togithub.com/launchbadge/sqlx/pull/2573 [#2574]: https://togithub.com/launchbadge/sqlx/pull/2574 ##### 0.6.3 - 2023-03-21 This is a hotfix to address the breakage caused by transitive dependencies upgrading to `syn = "2"`. We set `default-features = false` for our dependency on `syn = "1"` to be good crates.io citizens, but failed to enable the features we actually used, which went undetected because we transitively depended on `syn` with the default features enabled through other crates, and so they were also on for us because features are additive. When those other dependencies upgraded to `syn = "2"` it was no longer enabling those features for us, and so compilation broke for projects that don't also depend on `syn = "1"`, transitively or otherwise. There is no PR for this fix as there was no longer a dedicated development branch for `0.6`, but discussion can be found in [issue #2418]. As of this release, the `0.7` release is in alpha and so development is no longer occurring against `0.6`. This fix will be forward-ported to `0.7`. [issue #2418]: https://togithub.com/launchbadge/sqlx/issues/2418 ### [`v0.6.3`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#063---2023-03-21) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.6.2...v0.6.3) This is a hotfix to address the breakage caused by transitive dependencies upgrading to `syn = "2"`. We set `default-features = false` for our dependency on `syn = "1"` to be good crates.io citizens, but failed to enable the features we actually used, which went undetected because we transitively depended on `syn` with the default features enabled through other crates, and so they were also on for us because features are additive. When those other dependencies upgraded to `syn = "2"` it was no longer enabling those features for us, and so compilation broke for projects that don't also depend on `syn = "1"`, transitively or otherwise. There is no PR for this fix as there was no longer a dedicated development branch for `0.6`, but discussion can be found in [issue #2418]. As of this release, the `0.7` release is in alpha and so development is no longer occurring against `0.6`. This fix will be forward-ported to `0.7`. [issue #2418]: https://togithub.com/launchbadge/sqlx/issues/2418 ### [`v0.6.2`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#062---2022-09-14) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.6.1...v0.6.2) [25 pull requests][0.6.2-prs] were merged this release cycle. ##### Added - \[[#1081]]: Add `try_from` attribute for `FromRow` derive \[\[[@zzhengzhuo](https://togithub.com/zzhengzhuo)]] - Exemplifies "out of sight, out of mind." It's surprisingly easy to forget about PRs when they get pushed onto the second page. We'll be sure to clean out the backlog for 0.7.0. - \[[#2014]]: Support additional SQLCipher options in SQLite driver. \[\[[@szymek156](https://togithub.com/szymek156)]] - \[[#2052]]: Add issue templates \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2053]]: Add documentation for `IpAddr` support in Postgres \[\[[@rakshith-ravi](https://togithub.com/rakshith-ravi)]] - \[[#2062]]: Add extension support for SQLite \[\[[@bradfier](https://togithub.com/bradfier)]] - \[[#2063]]: customizable db locking during migration \[\[[@fuzzbuck](https://togithub.com/fuzzbuck)]] ##### Changed - \[[#2025]]: Bump sqlformat to 2.0 \[\[[@NSMustache](https://togithub.com/NSMustache)]] - \[[#2056]]: chore: Switch to sha1 crate \[\[[@stoically](https://togithub.com/stoically)]] - \[[#2071]]: Use cargo check consistently in `prepare` \[\[[@cycraig](https://togithub.com/cycraig)]] ##### Fixed - \[[#1991]]: Ensure migration progress is not lost for Postgres, MySQL and SQLite. \[\[[@crepererum](https://togithub.com/crepererum)]] - \[[#2023]]: Fix expansion of `#[sqlx(flatten)]` for `FromRow` derive \[\[[@RustyYato](https://togithub.com/RustyYato)]] - \[[#2028]]: Use fully qualified path when forwarding to `#[test]` from `#[sqlx::test]` \[\[[@alexander-jackson](https://togithub.com/alexander-jackson)]] - \[[#2040]]: Fix typo in `FromRow` docs \[\[[@zlidner](https://togithub.com/zlidner)]] - \[[#2046]]: added flag for PIPES_AS_CONCAT connection setting for MySQL to fix [#2034](https://togithub.com/launchbadge/sqlx/issues/2034) \[\[[@marcustut](https://togithub.com/marcustut)]] - \[[#2055]]: Use unlock notify also on `sqlite3_exec` \[\[[@madadam](https://togithub.com/madadam)]] - \[[#2057]]: Make begin,commit,rollback cancel-safe in sqlite \[\[[@madadam](https://togithub.com/madadam)]] - \[[#2058]]: fix typo in documentation \[\[[@lovasoa](https://togithub.com/lovasoa)]] - \[[#2067]]: fix(docs): close code block in query_builder.rs \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2069]]: Fix `prepare` race condition in workspaces \[\[[@cycraig](https://togithub.com/cycraig)]]\\ - NOTE: this changes the directory structure under `target/` that `cargo sqlx prepare` depends on. If you use offline mode in your workflow, please rerun `cargo install sqlx-cli` to upgrade. - \[[#2072]]: SqliteConnectOptions typo \[\[[@fasterthanlime](https://togithub.com/fasterthanlime)]] - \[[#2074]]: fix: mssql uses unsigned for tinyint instead of signed \[\[[@he4d](https://togithub.com/he4d)]] - \[[#2081]]: close unnamed portal after each executed extended query \[\[[@DXist](https://togithub.com/DXist)]] - \[[#2086]]: PgHasArrayType for transparent types fix. \[\[[@Wopple](https://togithub.com/Wopple)]] - NOTE: this is a breaking change and has been postponed to 0.7.0. - \[[#2089]]: fix: Remove default chrono dep on time for sqlx-cli \[\[[@TravisWhitehead](https://togithub.com/TravisWhitehead)]] - \[[#2091]]: Sqlite explain plan log efficiency \[\[[@tyrelr](https://togithub.com/tyrelr)]] [0.6.2-prs]: https://togithub.com/launchbadge/sqlx/pulls?q=is%3Apr+is%3Aclosed+merged%3A2022-08-04..2022-09-14+ [#1081]: https://togithub.com/launchbadge/sqlx/pull/1081 [#1991]: https://togithub.com/launchbadge/sqlx/pull/1991 [#2014]: https://togithub.com/launchbadge/sqlx/pull/2014 [#2023]: https://togithub.com/launchbadge/sqlx/pull/2023 [#2025]: https://togithub.com/launchbadge/sqlx/pull/2025 [#2028]: https://togithub.com/launchbadge/sqlx/pull/2028 [#2040]: https://togithub.com/launchbadge/sqlx/pull/2040 [#2046]: https://togithub.com/launchbadge/sqlx/pull/2046 [#2052]: https://togithub.com/launchbadge/sqlx/pull/2052 [#2053]: https://togithub.com/launchbadge/sqlx/pull/2053 [#2055]: https://togithub.com/launchbadge/sqlx/pull/2055 [#2056]: https://togithub.com/launchbadge/sqlx/pull/2056 [#2057]: https://togithub.com/launchbadge/sqlx/pull/2057 [#2058]: https://togithub.com/launchbadge/sqlx/pull/2058 [#2062]: https://togithub.com/launchbadge/sqlx/pull/2062 [#2063]: https://togithub.com/launchbadge/sqlx/pull/2063 [#2067]: https://togithub.com/launchbadge/sqlx/pull/2067 [#2069]: https://togithub.com/launchbadge/sqlx/pull/2069 [#2071]: https://togithub.com/launchbadge/sqlx/pull/2071 [#2072]: https://togithub.com/launchbadge/sqlx/pull/2072 [#2074]: https://togithub.com/launchbadge/sqlx/pull/2074 [#2081]: https://togithub.com/launchbadge/sqlx/pull/2081 [#2086]: https://togithub.com/launchbadge/sqlx/pull/2086 [#2089]: https://togithub.com/launchbadge/sqlx/pull/2089 [#2091]: https://togithub.com/launchbadge/sqlx/pull/2091 ### [`v0.6.1`](https://togithub.com/launchbadge/sqlx/blob/HEAD/CHANGELOG.md#061---2022-08-02) [Compare Source](https://togithub.com/launchbadge/sqlx/compare/v0.6.0...v0.6.1) [33 pull requests][0.6.1-prs] were merged this release cycle. ##### Added - \[[#1495]]: Add example for manual implementation of the `FromRow` trait \[\[[@Erik1000](https://togithub.com/Erik1000)]] - \[[#1822]]: (Postgres) Add support for `std::net::IpAddr` \[\[[@meh](https://togithub.com/meh)]] - Decoding returns an error if the `INET` value in Postgres is a prefix and not a full address (`/32` for IPv4, `/128` for IPv6). - \[[#1865]]: Add SQLite support for the `time` crate \[\[[@johnbcodes](https://togithub.com/johnbcodes)]] - \[[#1902]]: Add an example of how to use `QueryBuilder::separated()` \[\[[@sbeckeriv](https://togithub.com/sbeckeriv)]] - \[[#1917]]: Added docs for `sqlx::types::Json` \[\[[@jayy-lmao](https://togithub.com/jayy-lmao)]] - \[[#1919]]: Implement `Clone` for `PoolOptions` \[\[[@Thomasdezeeuw](https://togithub.com/Thomasdezeeuw)]] - \[[#1953]]: Support Rust arrays in Postgres \[\[[@e00E](https://togithub.com/e00E)]] - \[[#1954]]: Add `push_tuples` for `QueryBuilder` \[\[[@0xdeafbeef](https://togithub.com/0xdeafbeef)]] - \[[#1959]]: Support `#[sqlx(flatten)]` attribute in `FromRow` \[\[[@TheoOiry](https://togithub.com/TheoOiry)]] - \[[#1967]]: Add example with external query files \[\[[@JoeyMckenzie](https://togithub.com/JoeyMckenzie)]] - \[[#1985]]: Add `query_builder::Separated::push_bind_unseparated()` \[\[[@0xdeafbeef](https://togithub.com/0xdeafbeef)]] - \[[#2001]]: Implement `#[sqlx::test]` for general use - Includes automatic database management, migration and fixture application. - Drops support for end-of-lifed database versions, see PR for details. - \[[#2005]]: `QueryBuilder` improvements \[\[[@abonander](https://togithub.com/abonander)]] - Raw SQL getters, new method to build `QueryAs` instead of `Query`. - \[[#2013]]: (SQLite) Allow VFS to be set as URL query parameter \[\[[@liningpan](https://togithub.com/liningpan)]] ##### Changed - \[[#1679]]: refactor: alias actix-\* features to their equivalent tokio-\* features \[\[[@robjtede](https://togithub.com/robjtede)]] - \[[#1906]]: replaced all uses of "uri" to "url" \[\[[@RomainStorai](https://togithub.com/RomainStorai)]] - \[[#1965]]: SQLite improvements \[\[[@abonander](https://togithub.com/abonander)]] - \[[#1977]]: Docs: clarify relationship between `query_as!()` and `FromRow` \[\[[@abonander](https://togithub.com/abonander)]] - \[[#2003]]: Replace `dotenv` with `dotenvy` \[\[[@abonander](https://togithub.com/abonander)]] ##### Fixed - \[[#1802]]: Try avoiding a full clean in `cargo sqlx prepare --merged` \[\[[@LovecraftianHorror](https://togithub.com/LovecraftianHorror)]] - \[[#1848]]: Fix type info access in `Any` database driver \[\[[@raviqqe](https://togithub.com/raviqqe)]] - \[[#1910]]: Set `CARGO_TARGET_DIR` when compiling queries \[\[[@sedrik](https://togithub.com/sedrik)]] - \[[#1915]]: Pool: fix panic when using callbacks \[\[[@abonander](https://togithub.com/abonander)]] - \[[#1930]]: Don't cache SQLite connection for macros \[\[[@LovecraftianHorror](https://togithub.com/LovecraftianHorror)]] - \[[#1948]]: Fix panic in Postgres `BYTEA` decode \[\[[@e00E](https://togithub.com/e00E)]] - \[[#1955]]: Fix typo in FAQ \[\[[@kenkoooo](https://togithub.com/kenkoooo)]] - \[[#1968]]: (Postgres) don't panic if `S` or `V` notice fields are not UTF-8 \[\[[@abonander](https://togithub.com/abonander)]] - \[[#1969]]: Fix sqlx-cli build \[\[[@ivan](https://togithub.com/ivan)]] - \[[#1974]]: Use the `rust-cache` action for CI \[\[[@abonander](https://togithub.com/abonander)]] - \[[#1988]]: Agree on a single default runtime for the whole workspace \[\[[@crepererum](https://togithub.com/crepererum)]] - \[[#1989]]: Fix panics in `PgListener` \[\[[@crepererum](https://togithub.com/crepererum)]] - \[[#1990]]: Switch `master` to `main` in docs \[\[[@crepererum](https://togithub.com/crepererum)]] - The change had already been made in the repo, the docs were out of date. - \[[#1993]]: Update versions in quickstart examples in README \[\[[@UramnOIL](https://togithub.com/UramnOIL)]] [0.6.1-prs]: https://togithub.com/launchbadge/sqlx/pulls?page=1&q=is%3Apr+is%3Aclosed+merged%3A2022-06-17..2022-08-02 [#1906]: https://togithub.com/launchbadge/sqlx/pull/1906 [#1495]: https://togithub.com/launchbadge/sqlx/pull/1495 [#1679]: https://togithub.com/launchbadge/sqlx/pull/1679 [#1802]: https://togithub.com/launchbadge/sqlx/pull/1802 [#1822]: https://togithub.com/launchbadge/sqlx/pull/1822 [#1848]: https://togithub.com/launchbadge/sqlx/pull/1848 [#1865]: https://togithub.com/launchbadge/sqlx/pull/1865 [#1902]: https://togithub.com/launchbadge/sqlx/pull/1902 [#1910]: https://togithub.com/launchbadge/sqlx/pull/1910 [#1915]: https://togithub.com/launchbadge/sqlx/pull/1915 [#1917]: https://togithub.com/launchbadge/sqlx/pull/1917 [#1919]: https://togithub.com/launchbadge/sqlx/pull/1919 [#1930]: https://togithub.com/launchbadge/sqlx/pull/1930 [#1948]: https://togithub.com/launchbadge/sqlx/pull/1948 [#1953]: https://togithub.com/launchbadge/sqlx/pull/1953 [#1954]: https://togithub.com/launchbadge/sqlx/pull/1954 [#1955]: https://togithub.com/launchbadge/sqlx/pull/1955 [#1959]: https://togithub.com/launchbadge/sqlx/pull/1959 [#1965]: https://togithub.com/launchbadge/sqlx/pull/1965 [#1967]: https://togithub.com/launchbadge/sqlx/pull/1967 [#1968]: https://togithub.com/launchbadge/sqlx/pull/1968 [#1969]: https://togithub.com/launchbadge/sqlx/pull/1969 [#1974]: https://togithub.com/launchbadge/sqlx/pull/1974 [#1977]: https://togithub.com/launchbadge/sqlx/pull/1977 [#1985]: https://togithub.com/launchbadge/sqlx/pull/1985 [#1988]: https://togithub.com/launchbadge/sqlx/pull/1988 [#1989]: https://togithub.com/launchbadge/sqlx/pull/1989 [#1990]: https://togithub.com/launchbadge/sqlx/pull/1990 [#1993]: https://togithub.com/launchbadge/sqlx/pull/1993 [#2001]: https://togithub.com/launchbadge/sqlx/pull/2001 [#2003]: https://togithub.com/launchbadge/sqlx/pull/2003 [#2005]: https://togithub.com/launchbadge/sqlx/pull/2005 [#2013]: https://togithub.com/launchbadge/sqlx/pull/2013

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

[ ] If you want to rebase/retry this PR, check this box

This PR has been generated by Mend Renovate. View repository job log here.

renovate[bot] commented 1 year ago

⚠ Artifact update problem

Renovate failed to update an artifact related to this branch. You probably do not want to merge this PR as-is.

♻ Renovate will retry this branch, including artifacts, only when one of the following happens:

any of the package files in this branch needs updating, or
the branch becomes conflicted, or
you click the rebase/retry checkbox if found above, or
you rename this PR's title to start with "rebase!" to trigger it manually

The artifact failure details are included below:

File name: Cargo.lock

Command failed: docker run --rm --name=renovate_a_sidecar --label=renovate_a_child --memory=3584m -v "/tmp/worker/2f4061/61e29b/repos/github/BurntNail/knot":"/tmp/worker/2f4061/61e29b/repos/github/BurntNail/knot" -v "/tmp/worker/2f4061/61e29b/cache":"/tmp/worker/2f4061/61e29b/cache" -e GIT_CONFIG_KEY_0 -e GIT_CONFIG_VALUE_0 -e GIT_CONFIG_KEY_1 -e GIT_CONFIG_VALUE_1 -e GIT_CONFIG_KEY_2 -e GIT_CONFIG_VALUE_2 -e GIT_CONFIG_COUNT -e CONTAINERBASE_CACHE_DIR -w "/tmp/worker/2f4061/61e29b/repos/github/BurntNail/knot" ghcr.io/containerbase/sidecar:9.20.8 bash -l -c "install-tool rust 1.73.0 && cargo update --config net.git-fetch-with-cli=true --manifest-path Cargo.toml --workspace"
    Updating crates.io index
error: failed to select a version for `sqlx`.
    ... required by package `knot v0.1.0 (/tmp/worker/2f4061/61e29b/repos/github/BurntNail/knot)`
versions that meet the requirements `^0.7` are: 0.7.2, 0.7.1, 0.7.0

the package `knot` depends on `sqlx`, with features: `offline` but `sqlx` does not have these features.

failed to select a version for `sqlx` which could resolve this conflict

renovate[bot] commented 1 year ago

Renovate Ignore Notification

Because you closed this PR without merging, Renovate will ignore this update (0.7). You will get a PR once a newer version is released. To ignore this dependency forever, add it to the ignoreDeps array of your Renovate config.

If you accidentally closed this PR, or if you changed your mind: rename this PR to get a fresh replacement PR.

BurntNail / vent