lib

trade_product.rs (5468B)

---

 use radroots_replica_db_schema::trade_product::{
     ITradeProductCreate, ITradeProductCreateResolve, ITradeProductDelete,
     ITradeProductDeleteResolve, ITradeProductFieldsFilter, ITradeProductFindMany,
     ITradeProductFindManyResolve, ITradeProductFindOne, ITradeProductFindOneResolve,
     ITradeProductUpdate, ITradeProductUpdateResolve, TradeProduct, TradeProductQueryBindValues,
 };
 use radroots_sql_core::error::SqlError;
 use radroots_sql_core::{SqlExecutor, utils};
 use radroots_types::types::{IError, IResult, IResultList};
 use serde_json::Value;
 
 const TABLE_NAME: &str = "trade_product";
 
 pub fn create(
     exec: &dyn SqlExecutor,
     opts: &ITradeProductCreate,
 ) -> Result<ITradeProductCreateResolve, IError<SqlError>> {
     let field_map = utils::to_object_map(opts).expect("serialize object map");
     let id = utils::uuidv4();
     let now = utils::time_created_on();
     let meta: [(&str, Value); 3] = [
         ("id", Value::from(id.clone())),
         ("created_at", Value::from(now.clone())),
         ("updated_at", Value::from(now.clone())),
     ];
     let (sql, bind_values) = utils::build_insert_query_with_meta(TABLE_NAME, &meta, &field_map);
     let params_json = utils::to_params_json(bind_values).expect("serialize bind params");
     let _ = exec.exec(&sql, &params_json)?;
     let on = TradeProductQueryBindValues::Id { id: id.clone() };
     let result = find_one_by_on(exec, &on)?.ok_or(IError::from(SqlError::NotFound(id.clone())))?;
     Ok(IResult { result })
 }
 
 pub fn find_one(
     exec: &dyn SqlExecutor,
     opts: &ITradeProductFindOne,
 ) -> Result<ITradeProductFindOneResolve, IError<SqlError>> {
     let result = match opts {
         ITradeProductFindOne::On(args) => find_one_by_on(exec, &args.on)?,
     };
     Ok(IResult { result })
 }
 
 pub fn find_many(
     exec: &dyn SqlExecutor,
     opts: &ITradeProductFindMany,
 ) -> Result<ITradeProductFindManyResolve, IError<SqlError>> {
     let results = find_many_filter(exec, &opts.filter)?;
     Ok(IResultList { results })
 }
 
 fn find_many_filter(
     exec: &dyn SqlExecutor,
     filter: &Option<ITradeProductFieldsFilter>,
 ) -> Result<Vec<TradeProduct>, IError<SqlError>> {
     let (sql, bind_values) = utils::build_select_query_with_meta(TABLE_NAME, filter.as_ref());
     let params_json = utils::to_params_json(bind_values).expect("serialize bind params");
     let json = exec.query_raw(&sql, &params_json)?;
     let rows: Vec<TradeProduct> = utils::parse_json(&json)?;
     Ok(rows)
 }
 
 fn find_one_by_on(
     exec: &dyn SqlExecutor,
     on: &TradeProductQueryBindValues,
 ) -> Result<Option<TradeProduct>, IError<SqlError>> {
     let (column, value) = on.to_filter_param();
     let sql = format!("SELECT * FROM {TABLE_NAME} WHERE {column} = ? LIMIT 1;");
     let params_json = utils::to_params_json(vec![value]).expect("serialize bind params");
     let json = exec.query_raw(&sql, &params_json)?;
     let mut rows: Vec<TradeProduct> = utils::parse_json(&json)?;
     Ok(rows.pop())
 }
 
 fn select_by_id(exec: &dyn SqlExecutor, id: &str) -> Result<TradeProduct, IError<SqlError>> {
     let params_json =
         utils::to_params_json(vec![Value::from(id.to_owned())]).expect("serialize bind params");
     let sql = format!("SELECT * FROM {TABLE_NAME} WHERE id = ?;");
     let json = exec.query_raw(&sql, &params_json)?;
     let mut rows: Vec<TradeProduct> = utils::parse_json(&json)?;
     rows.pop()
         .ok_or(IError::from(SqlError::NotFound(id.to_owned())))
 }
 
 pub fn update(
     exec: &dyn SqlExecutor,
     opts: &ITradeProductUpdate,
 ) -> Result<ITradeProductUpdateResolve, IError<SqlError>> {
     let mut updates =
         utils::to_partial_object_map(&opts.fields).expect("serialize partial object map");
     if updates.is_empty() {
         return Err(IError::from(SqlError::InvalidArgument(String::from(
             "no fields to update",
         ))));
     }
     updates.insert(
         String::from("updated_at"),
         Value::from(utils::time_created_on()),
     );
     let mut set_parts = Vec::with_capacity(updates.len());
     let mut bind_values = Vec::with_capacity(updates.len() + 1);
     for (column, value) in updates {
         set_parts.push(format!("{column} = ?"));
         bind_values.push(utils::to_db_bind_value(&value));
     }
     let id_for_lookup = match &opts.on {
         TradeProductQueryBindValues::Id { id } => id.clone(),
     };
     bind_values.push(Value::from(id_for_lookup.clone()));
     let sql = format!(
         "UPDATE {TABLE_NAME} SET {} WHERE id = ?;",
         set_parts.join(", ")
     );
     let params_json = utils::to_params_json(bind_values).expect("serialize bind params");
     let _ = exec.exec(&sql, &params_json)?;
     let updated = select_by_id(exec, &id_for_lookup)?;
     Ok(IResult { result: updated })
 }
 
 pub fn delete(
     exec: &dyn SqlExecutor,
     opts: &ITradeProductDelete,
 ) -> Result<ITradeProductDeleteResolve, IError<SqlError>> {
     let id_for_lookup = match opts {
         ITradeProductDelete::On(args) => match &args.on {
             TradeProductQueryBindValues::Id { id } => id.clone(),
         },
     };
     let params_json = utils::to_params_json(vec![Value::from(id_for_lookup.clone())])
         .expect("serialize bind params");
     let sql = format!("DELETE FROM {TABLE_NAME} WHERE id = ?;");
     let outcome = exec.exec(&sql, &params_json)?;
     if outcome.changes == 0 {
         return Err(IError::from(SqlError::NotFound(id_for_lookup.clone())));
     }
     Ok(IResult {
         result: id_for_lookup,
     })
 }