Working to make the CLI support sqlite, and allow to create migration with sqlite

kurtbuilds / ormlite

An ORM in Rust for developers that love SQL.

https://crates.io/crates/ormlite

MIT License

237 stars 13 forks source link

Working to make the CLI support sqlite, and allow to create migration with sqlite #51

Open lefuturiste opened 5 months ago

lefuturiste commented 5 months ago

Hi,

I'm currently working to integrate sqlite into the ormlite CLI.

lefuturiste commented 5 months ago

So it will require to also add sqlite support to kurtbuilds/sqlmo

kurtbuilds commented 5 months ago

That's awesome! PRs definitely welcome for both.

lefuturiste commented 5 months ago

I'm a relative beginner to complex typing, trait, lifetime in rust so it's difficult for me to navigate the shear mass of code. I tried to go full in and try adding feature "sqlite" but it's too difficult for now. For now the best bet for me is to begin by duplicating the cli crate into cli_sqlite to workout what's needed and have a prototype.

lefuturiste commented 5 months ago

The main problem is to make the argument "conn" that represent "Connection" configurable to be either PgConnection or SqliteConnection.

There is no function argument generics in rust
I did not find a way to change the PgConnection types to impl Executor, idk how to that, if you have a example it would be great. So there is two approach that I see:
have a way with impl Executor
have total code duplication with sqlite and pg
try to use macro rules to generate two bundle of code for each one postgres and sqlite