0.9.0

https://www.sea-ql.org/blog/2022-07-17-whats-new-in-0.9.0/

New Features

• Cursor pagination (#822)
• Custom join on conditions (#793)
• DeriveMigrationName and sea_orm_migration::util::get_file_stem (#736)
• FromJsonQueryResult for deserializing Json from query result (#794)

Enhancements

• Added sqlx_logging_level to ConnectOptions (#800)
• Added num_items_and_pages to Paginator (#768)
• Added TryFromU64 for time (#849)
• Added Insert::on_conflict (#791)
• Added QuerySelect::join_as and QuerySelect::join_as_rev (#852)
• Include column name in TryGetError::Null (#853)
• [sea-orm-cli] Improve logging (#735)
• [sea-orm-cli] Generate enum with numeric like variants (#588)
• [sea-orm-cli] Allow old pending migration to be applied (#755)
• [sea-orm-cli] Skip generating entity for ignored tables (#837)
• [sea-orm-cli] Generate code for time crate (#724)
• [sea-orm-cli] Add various blob column types (#850)
• [sea-orm-cli] Generate entity files with Postgres's schema name (#422)

Upgrades

• Upgrade clap to 3.2 (#706)
• Upgrade time to 0.3 (#834)
• Upgrade sqlx to 0.6 (#834)
• Upgrade uuid to 1.0 (#834)
• Upgrade sea-query to 0.26 (#834)
• Upgrade sea-schema to 0.9 (#834)

House keeping

• Refactor stream metrics (#778)

Bug Fixes

• [sea-orm-cli] skip checking connection string for credentials (#851)

Breaking changes

• SelectTwoMany::one() has been dropped #813, you can get (Entity, Vec<RelatedEntity>) by first querying a single model from Entity, then use [ModelTrait::find_related] on the model.

• Feature flag revamp

  We now adopt the weak dependency syntax in Cargo. That means the flags ["sqlx-json", "sqlx-chrono", "sqlx-decimal", "sqlx-uuid", "sqlx-time"] are not needed and now removed. Instead, with-time will enable sqlx?/time only if sqlx is already enabled. As a consequence, now the features with-json, with-chrono, with-rust_decimal, with-uuid, with-time will not be enabled as a side-effects of enabling sqlx.

New Contributors

• @itsparser made their first contribution in #714
• @Eugeny made their first contribution in #716
• @SH11235 made their first contribution in #717
• @Technik97 made their first contribution in #718
• @frankhorv made their first contribution in #719
• @hilary888 made their first contribution in #741
• @aslamplr made their first contribution in #776
• @Tricked-dev made their first contribution in #712
• @kyoto7250 made their first contribution in #735
• @cache-missing made their first contribution in #792
• @POPPIN-FUMI made their first contribution in #803
• @xiaoquisme made their first contribution in #818
• @SandaruKasa made their first contribution in #800
• @liberwang1013 made their first contribution in #791
• @smonv made their first contribution in #706
• @fistons made their first contribution in #768
• @dragonnn made their first contribution in #769
• @lingdu1234 made their first contribution in #857
• @nahuakang made their first contribution in #724
• @a5huynh made their first contribution in #856

Full Changelog: 0.8.0...0.9.0