Cookbook Articles - Githubissues

SeaQL / sea-orm-cookbook

ebook for SeaORM Cookbook

https://www.sea-ql.org/sea-orm-cookbook/

Apache License 2.0

7 stars 1 forks source link

Cookbook Articles #2

Open billy1624 opened 1 year ago

billy1624 commented 1 year ago

See https://github.com/SeaQL/sea-orm-cookbook/issues/2#issuecomment-1510612752

tyt2y3 commented 1 year ago

Great list

asdfcube commented 1 year ago

[ ] ~~How to define an entity with dynamic table name? https://github.com/SeaQL/sea-orm/discussions/1574~~
[X] How to execute SQL at the beginning of each connection? https://github.com/SeaQL/sea-orm/discussions/1542 #4
[X] How to establish database connection lazily? https://github.com/SeaQL/sea-orm/discussions/1485 #4
[x] How to insert rows from a select statement? https://github.com/SeaQL/sea-orm/discussions/1482
[X] How to invoke custom function? https://github.com/SeaQL/sea-orm/discussions/1408 #3
[X] How to initialize a static DB connection with lazy_static? https://github.com/SeaQL/sea-orm/discussions/1383 #5
[ ] ~~How to select a random row matching specific criteria? https://github.com/SeaQL/sea-orm/discussions/1343 https://github.com/SeaQL/sea-orm/discussions/1009~~
[x] How to select a sub-query? https://github.com/SeaQL/sea-orm/discussions/1314 https://github.com/SeaQL/sea-orm/discussions/1205 https://github.com/SeaQL/sea-orm/discussions/982
[ ] How to add a computed model field? https://github.com/SeaQL/sea-orm/discussions/1309
[x] How to execute multiple SQL at once? https://github.com/SeaQL/sea-orm/discussions/1296 https://www.sea-ql.org/SeaORM/docs/basic-crud/raw-sql/#execute-unprepared-sql-statement
[ ] ?? How to execute migration in transaction? https://github.com/SeaQL/sea-orm/discussions/1324
[X] How to configure search_path for Postgres connection? https://github.com/SeaQL/sea-orm/discussions/1274 #4
[x] How to insert or update a JSON object? https://github.com/SeaQL/sea-orm/discussions/1269 https://github.com/SeaQL/sea-orm/discussions/734
[ ] !! How to select from a view? https://github.com/SeaQL/sea-orm/discussions/1244 https://github.com/SeaQL/sea-orm/discussions/814
[x] Why ActiveModelBehaviour::before_save method not being invoked? https://github.com/SeaQL/sea-orm/discussions/1532
[ ] !! How to specify a database connection string with special character? https://github.com/SeaQL/sea-orm/discussions/1263
[ ] ?? How to create Postgres table on a specific schema? https://github.com/SeaQL/sea-orm/discussions/1029
[x] How to select a tuple value result? https://github.com/SeaQL/sea-orm/discussions/1248 https://docs.rs/sea-orm/latest/sea_orm/entity/prelude/struct.Select.html#method.into_tuple
[x] How to log changes? https://github.com/SeaQL/sea-orm/discussions/972 https://github.com/SeaQL/sea-orm/blob/3c00e8f1f709261e99a25fb316e67190fb14298a/tests/common/features/repository.rs#L18-L71
[ ] !! How to batch inserts? https://github.com/SeaQL/sea-orm/discussions/710
[x] How to check any or all of the columns are set? https://github.com/SeaQL/sea-orm/discussions/502
[x] How to perform count or exists? https://github.com/SeaQL/sea-orm/discussions/484
[x] How to define model field of newtype? https://github.com/SeaQL/sea-orm/discussions/477
[ ] How to define multiple relations between two entities? https://github.com/SeaQL/sea-orm/discussions/1462