1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
use crate::{prelude::Arel, statements::ArelStatement};
use std::marker::PhantomData;
#[derive(Debug)]
pub struct Group<M: Arel> {
sqls: Vec<crate::Sql>,
_marker: PhantomData<M>,
}
impl<M: Arel> ArelStatement for Group<M> {
fn to_sql(&self) -> crate::Result<Option<crate::Sql>> {
if self.sqls.len() > 0 {
let mut final_sql = crate::Sql::new("GROUP BY ");
final_sql.push_sqls(self.sqls.clone(), ", ");
Ok(Some(final_sql))
} else {
Ok(None)
}
}
}
impl<M: Arel> Default for Group<M> {
fn default() -> Self {
Self {
sqls: vec![],
_marker: PhantomData::<M>,
}
}
}
impl<M: Arel> Group<M> {
/// # Examples
///
/// ```
/// use arel::prelude::*;
/// use arel::statements::group::Group;
/// #[arel]
/// struct User {}
/// impl Arel for User {}
/// let group = Group::<User>::new(vec!["name", "age"]);
/// assert_eq!(group.to_sql().unwrap().unwrap().to_sql_string().unwrap(), r#"GROUP BY "user"."name", "user"."age""#);
///
/// ```
pub fn new<T: AsRef<str>>(columns: Vec<T>) -> Self {
let table_name = M::table_name();
Self {
sqls: columns.iter().map(|column| crate::Sql::new(format!(r#""{}"."{}""#, table_name, column.as_ref()))).collect(),
_marker: PhantomData::<M>,
}
}
pub fn new_sql<S: Into<crate::Sql>>(sql: S) -> Self {
Self {
sqls: vec![sql.into()],
_marker: PhantomData::<M>,
}
}
/// # Examples
///
/// ```
/// use arel::prelude::*;
/// use arel::statements::group::Group;
/// #[arel]
/// struct User {}
/// impl Arel for User {}
/// let group = Group::<User>::new_sqls(vec!["name", "age"]);
/// assert_eq!(group.to_sql().unwrap().unwrap().to_sql_string().unwrap(), r#"GROUP BY name, age"#);
///
/// ```
pub fn new_sqls<S: Into<crate::Sql>>(sqls: Vec<S>) -> Self {
Self {
sqls: sqls.into_iter().map(|sql| sql.into()).collect(),
_marker: PhantomData::<M>,
}
}
}