Upgrading `time` crate to 0.3.35

[billy1624]

The time crate released a new 0.3.35 version, and it introduced a few breaking changes, mainly in the module naming and re-export path. Resulting in compile error, if one depends on the latest time release.

error[E0432]: unresolved import `time::format_description::FormatItem`
   --> /home/runner/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-sqlite-0.7.4/src/types/time.rs:192:72
    |
192 |     use time::format_description::{modifier, Component::*, FormatItem, FormatItem::*};
    |                                                                        ^^^^^^^^^^ `FormatItem` is a type alias, not a module

error[E0425]: cannot find function, tuple struct or tuple variant `Component` in this scope
   --> /home/runner/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sqlx-sqlite-0.7.4/src/types/time.rs:194:34
    |
194 |     const YEAR: FormatItem<'_> = Component(Year({
    |                                  ^^^^^^^^^ not found in this scope
    |
help: consider importing one of these items
    |
192 +     use time::format_description::BorrowedFormatItem::Component;
    |
192 +     use time::format_description::OwnedFormatItem::Component;
    |

Full log: https://github.com/SeaQL/sea-query/actions/runs/8626694053/job/23645278046#step:4:452

[abonander]

As a temporary workaround, just pin the version of time in your dependencies:

time = "=0.3.34"

Sorry @wyatt-herkamp, I'm sure you have the best of intentions, but given the recent attack on xz-utils, I don't think it's a good idea to recommend that people patch SQLx to a repository controlled by a third party.

[wyatt-herkamp]

As a temporary workaround, just pin the version of time in your dependencies:

time = "=0.3.34"

Sorry @wyatt-herkamp, I'm sure you have the best of intentions, but given the recent attack on xz-utils, I don't think it's a good idea to recommend that people patch SQLx to a repository controlled by a third party.

I tried doing that. However, it was still erroring out. I completely understand. I am using this in a school project so it won't get near production.

Also I deleted the comment. I plan to delete the REPO as soon as an official fix has been released.

[gilgabo]

Hi, all our pipelines are failing by this issue, any estimated deadline?

[billy1624]

If anyone is still having the same issue, please upgrade your local time dependency to 0.3.36, just like:

• Fix doc build SeaQL/sea-orm#2267

The breaking change in time crate has been patched in 0.3.36 but not in 0.3.35

• https://github.com/time-rs/time/blob/main/CHANGELOG.md#0336-2024-04-10
• Renaming of FormatItem is a breaking change time-rs/time#675