Lemmy Rust code needs help, Diesel ORM quick change, adding a select field to SiteAggregates::read
Lemmy Rust code needs help, Diesel ORM quick change, adding a select field to SiteAggregates::read
We have an urgent performance problem to get finished. The SQL changes are fine, but it seems the Lemmy test code in Rust is defective. This test is failing after we fixed a faulty stored procedure function in PostgreSQL: https://github.com/LemmyNet/lemmy/blob/13a866aeb0c24f20ed18ab40c0ea5616ef910676/crates/db_schema/src/aggregates/site_aggregates.rs#L157
The underlying Rust code needs to be enhanced to query the SQL table with SELECT site_aggregates WHERE site_id = 1, hard-coded 1 is fine, that is always the local site in Lemmy.
Can you please detail all the code changes so that the read method takes an integer parameter for site_id field?
Right now the query has no WHERE clause, pulling the first row it gets. Thank you.
Looking at the diesel docs it should be
site_aggregates::table.filter(site_aggregates::site_id.eq(1)).load(…https://diesel.rs/ see the third example