use sqlx::{Arguments, Database, Postgres};
use std::borrow::Cow;
use sqlx::postgres::{PgArguments};
use taitan_orm_trait::traits::Mutation;
use taitan_orm_trait::result::Result;
use time::macros::datetime;
use time::PrimitiveDateTime;
use taitan_orm_trait::traits::Parameter;
#[derive(Debug)]
struct UserMutation {
name: Option<String>,
created: Option<PrimitiveDateTime>,
}
impl Parameter<Postgres> for UserMutation {
fn add_to_args<'a, 'b>(&'a self, args: &'b mut <Postgres as Database>::Arguments<'a>) -> Result<()> {
if let Some(name) = &self.name {
args.add(name)?;
}
if let Some(created) = &self.created {
args.add(created)?;
}
Ok(())
}
}
impl Mutation<Postgres> for UserMutation {
fn gen_update_set_sql<'a>(&self) -> Cow<'a, str> {
let mut sql = String::from("UPDATE `user`");
if self.name.is_some() {
sql.push_str(" name = ?");
}
if self.created.is_some() {
sql.push_str(" created = ?");
}
Cow::from(sql)
}
fn all_none(&self) -> bool {
self.name.is_none() && self.created.is_none()
}
}
#[test]
fn mutation_trait_spec() {
let user = UserMutation {
name: Some("Allen".to_string()),
created: Some(datetime!(2019-01-01 0:00)),
};
let update_set_sql = user.gen_update_set_sql();
let mut args = PgArguments::default();
let update_set_args = user.add_to_args(&mut args).unwrap();
}