How do I use sqlite as DB backend ?

[tjyang]

After finished https://loco.rs/docs/getting-started/tour/ tutorial that using postgresql as DB.

Is there a doc for using sqlite as DB backend ?
I see issue 112 mentioned sqlite is supported.

[kaplanelad]

@tjyang you can change the DB connection string to sqlite://./db.sqlite?mode=rwc

[tjyang]

• Chane to use sqlite in DATABASE_URL.

[me@rocky9t01a myapp2]$ egrep DATA config/development.yaml |egrep -v '#'
  uri: {{ get_env(name="DATABASE_URL", default="sqlite://./db.sqlite?mode=rwc") }}
[me@rocky9t01a myapp2]$ cargo install --path .
[me@rocky9t01a myapp2]$ /home/me/.cargo/bin/myaqpp2-cli db migrate
[me@rocky9t01a myapp2]$ /home/me/.cargo/bin/myaqpp2-cli start

• we can see sqlite3 db file(db.sqlte ) got created after migrate and start

-rw-r--r--  1 me me  32768 Dec 24 06:39 db.sqlite
[me@rocky9t01a myapp2]$

• quick sqlite db checks.

[me@rocky9t01a myapp2]$ sqlite3 db.sqlite
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> .table
notes             seaql_migrations  users
sqlite> select * from users;
sqlite> select * from notes;
sqlite> select * from seaql_migrations;
m20220101_000001_users|1703421564
m20231103_114510_notes|1703421564
sqlite> 

[tjyang]

• I created new app as sqlsaas name.
• Trying to finish the create post CRUD controller using SQLlite as DB backend, ran into following errors.
  Same step of cargo loco generate scaffold post title:string content:text using postgresql DB beckend is ok.

[me@rocky9t01a sqlsaas.warning]$ cargo loco generate scaffold post title:string content:text
[me@rocky9t01a sqlsaas.warning]$ cargo build
   Compiling sqlsaas v0.1.0 (/home/me/locos/sqlsaas.warning)
error[E0308]: mismatched types
   --> src/models/users.rs:217:65
    |
217 |         self.email_verification_sent_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                                            ---- ^^^^^^^^^^^^^^^^^^^^^^^^^^- help: try using a conversion method: `.to_string()`
    |                                                            |    |
    |                                                            |    expected `String`, found `NaiveDateTime`
    |                                                            arguments to this enum variant are incorrect
    |
help: the type constructed contains `NaiveDateTime` due to the type of the argument passed
   --> src/models/users.rs:217:60
    |
217 |         self.email_verification_sent_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                                            ^^^^^--------------------------^
    |                                                                 |
    |                                                                 this argument influences the type of `Some`
note: tuple variant defined here
   --> /home/me/.rustup/toolchains/stable-x86_64-unknown-linux-gnu/lib/rustlib/src/rust/library/core/src/option.rs:571:5
    |
571 |     Some(#[stable(feature = "rust1", since = "1.0.0")] T),
    |     ^^^^

error[E0308]: mismatched types
   --> src/models/users.rs:250:56
    |
250 |         self.email_verified_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                                   ---- ^^^^^^^^^^^^^^^^^^^^^^^^^^- help: try using a conversion method: `.to_string()`
    |                                                   |    |
    |                                                   |    expected `String`, found `NaiveDateTime`
    |                                                   arguments to this enum variant are incorrect
    |
help: the type constructed contains `NaiveDateTime` due to the type of the argument passed
   --> src/models/users.rs:250:51
    |
250 |         self.email_verified_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                                   ^^^^^--------------------------^
    |                                                        |
    |                                                        this argument influences the type of `Some`
note: tuple variant defined here
   --> /home/me/.rustup/toolchains/stable-x86_64-unknown-linux-gnu/lib/rustlib/src/rust/library/core/src/option.rs:571:5
    |
571 |     Some(#[stable(feature = "rust1", since = "1.0.0")] T),
    |     ^^^^

error[E0308]: mismatched types
   --> src/models/users.rs:235:52
    |
235 |         self.reset_sent_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                               ---- ^^^^^^^^^^^^^^^^^^^^^^^^^^- help: try using a conversion method: `.to_string()`
    |                                               |    |
    |                                               |    expected `String`, found `NaiveDateTime`
    |                                               arguments to this enum variant are incorrect
    |
help: the type constructed contains `NaiveDateTime` due to the type of the argument passed
   --> src/models/users.rs:235:47
    |
235 |         self.reset_sent_at = ActiveValue::set(Some(Local::now().naive_local()));
    |                                               ^^^^^--------------------------^
    |                                                    |
    |                                                    this argument influences the type of `Some`
note: tuple variant defined here
   --> /home/me/.rustup/toolchains/stable-x86_64-unknown-linux-gnu/lib/rustlib/src/rust/library/core/src/option.rs:571:5
    |
571 |     Some(#[stable(feature = "rust1", since = "1.0.0")] T),
    |     ^^^^

error[E0308]: mismatched types
  --> src/models/users.rs:54:45
   |
54 |                 this.pid = ActiveValue::Set(Uuid::new_v4());
   |                            ---------------- ^^^^^^^^^^^^^^- help: try using a conversion method: `.to_string()`
   |                            |                |
   |                            |                expected `String`, found `Uuid`
   |                            arguments to this enum variant are incorrect
   |
help: the type constructed contains `uuid::Uuid` due to the type of the argument passed
  --> src/models/users.rs:54:28
   |
54 |                 this.pid = ActiveValue::Set(Uuid::new_v4());
   |                            ^^^^^^^^^^^^^^^^^--------------^
   |                                             |
   |                                             this argument influences the type of `ActiveValue`
note: tuple variant defined here
  --> /home/me/.cargo/registry/src/index.crates.io-6f17d22bba15001f/sea-orm-0.12.10/src/entity/active_model.rs:44:5
   |
44 |     Set(V),
   |     ^^^

For more information about this error, try `rustc --explain E0308`.
error: could not compile `sqlsaas` (lib) due to 4 previous errors
[me@rocky9t01a sqlsaas.warning]$