Documentation Review

[tyt2y3]

https://www.sea-ql.org/SeaORM/docs/write-test/sqlite

This example is not illustrative enough. We need some asserts.

And perhaps we can copy a more real example from our test suite, like 'create_order'

[billy1624]

But our updated test suit is targeted to run on MySQL for now. Perhaps I will update the doc after the updates completed?

[tyt2y3]

There is not too much database specific code right?

[billy1624]

We use UUID & decimal in test suit. These two can map to column type in Sqlite?

[billy1624]

Yes, UUID & decimal map to compatible column type in Sqlite.

https://github.com/SeaQL/sea-query/blob/9a8806221a1392302faea00dc49fd513457d0ee8/src/backend/sqlite/table.rs#L38-L109

[billy1624]

The special attribute types we used in Model are supported by all three databases (MySQL, Postgres, Sqlite), except for rust_decimal::Decimal

• uuid::Uuid
• rust_decimal::Decimal (not supported by sqlx-sqlite)
• chrono::NaiveDateTime

The supported rust types of each database in Sqlx

• https://docs.rs/sqlx/0.5.5/sqlx/mysql/struct.MySql.html
• https://docs.rs/sqlx/0.5.5/sqlx/postgres/struct.Postgres.html
• https://docs.rs/sqlx/0.5.5/sqlx/sqlite/struct.Sqlite.html

[tyt2y3]

Yes sure lets pick a small example

[tyt2y3]

https://www.sea-ql.org/SeaORM/docs/basic-crud/raw-sql-and-json
Add also examples for:

1. the raw query_* API (on DbConn and using QueryResult
2. the raw execute API
3. some asserts for the JSON results

[billy1624]

Updated, please check

• https://www.sea-ql.org/SeaORM/docs/basic-crud/json
• https://www.sea-ql.org/SeaORM/docs/basic-crud/raw-sql