use chrono::{DateTime, Utc};
use rustango::sql::Auto;
use rustango::Model;
use serde::{Deserialize, Serialize};
#[derive(Model, Debug, Clone, Serialize, Deserialize)]
#[rustango(
table = "cms_category_translation",
app = "cms",
admin(
list_display = "category_id, locale_id, field_path, value, updated_at",
ordering = "category_id",
list_filter = "locale_id, field_path",
)
)]
pub struct CategoryTranslation {
#[rustango(primary_key)]
pub id: Auto<i64>,
#[rustango(fk = "cms_category", on = "id", index)]
pub category_id: i64,
#[rustango(fk = "cms_locale", on = "id", index)]
pub locale_id: i64,
#[rustango(max_length = 64, index)]
pub field_path: String,
pub value: String,
#[rustango(auto_now)]
pub updated_at: Auto<DateTime<Utc>>,
}
pub const TRANSLATABLE_FIELDS: [&str; 1] = ["name"];
pub async fn fetch_for_categories(
pool: &rustango::sql::Pool,
category_ids: &[i64],
locale_id: i64,
) -> Result<
std::collections::HashMap<i64, std::collections::HashMap<String, String>>,
rustango::sql::ExecError,
> {
use rustango::core::Column as _;
use rustango::sql::FetcherPool as _;
if category_ids.is_empty() {
return Ok(std::collections::HashMap::new());
}
let rows: Vec<CategoryTranslation> = CategoryTranslation::objects()
.where_(CategoryTranslation::locale_id.eq(locale_id))
.where_(CategoryTranslation::category_id.is_in(category_ids.iter().copied()))
.fetch(pool)
.await?;
let mut out: std::collections::HashMap<i64, std::collections::HashMap<String, String>> =
std::collections::HashMap::new();
for row in rows {
if row.value.is_empty() {
continue;
}
out.entry(row.category_id)
.or_default()
.insert(row.field_path, row.value);
}
Ok(out)
}
pub async fn delete_for_category_tx(
tx: &mut rustango::sql::PoolTx<'_>,
category_id: i64,
) -> Result<(), rustango::sql::ExecError> {
use rustango::core::Column as _;
let query = CategoryTranslation::objects()
.where_(CategoryTranslation::category_id.eq(category_id))
.compile_delete()?;
rustango::sql::delete_tx(tx, &query).await?;
Ok(())
}