#[macro_export]
macro_rules! myfind {
($t:expr, {
$(j0: [$jk0:tt, $jm0:tt, $jv0:expr],)?
$(j1: [$jk1:tt, $jm1:tt, $jv1:expr],)?
$(j2: [$jk2:tt, $jm2:tt, $jv2:expr],)?
$(j3: [$jk3:tt, $jm3:tt, $jv3:expr],)?
$(p0: [$k0:tt, $m0:tt, $v0:expr],)?
$(p1: [$k1:tt, $m1:tt, $v1:expr],)?
$(p2: [$k2:tt, $m2:tt, $v2:expr],)?
$(p3: [$k3:tt, $m3:tt, $v3:expr],)?
$(p4: [$k4:tt, $m4:tt, $v4:expr],)?
$(p5: [$k5:tt, $m5:tt, $v5:expr],)?
$(p6: [$k6:tt, $m6:tt, $v6:expr],)?
$(p7: [$k7:tt, $m7:tt, $v7:expr],)?
$(p8: [$k8:tt, $m8:tt, $v8:expr],)?
$(p9: [$k9:tt, $m9:tt, $v9:expr],)?
$(r: $r:expr,)?
$(page: $page:expr,)?
$(limit: $limit:expr,)?
$(order_by: $order_by:expr,)?
$(select: $select:expr,)?
}) => {
{
fn _type_of<T>(_: T) -> &'static str {
std::any::type_name::<T>()
}
fn get_table(tt: &str) -> &str {
let t_list: Vec<&str> = tt.split_whitespace().collect();
let table_change = t_list[t_list.len() - 1];
table_change
}
fn _get_table_f<'a>(tf: &'a str, main_t: &'a str) -> (&'a str, &'a str, &'a str) {
let mut _tmp_t = ""; let mut _tmp_f = ""; if tf.contains(".") {
let tmp_vc: Vec<&str> = tf.split(".").collect();
_tmp_t = tmp_vc[0];
_tmp_f = tmp_vc[1];
} else {
_tmp_t = main_t;
_tmp_f = tf;
}
let t_list: Vec<&str> = _tmp_t.split_whitespace().collect();
let table_change = t_list[t_list.len() - 1];
(_tmp_t, table_change, _tmp_f) }
fn _rename_field(field: &str, main_t_change: &str) -> String {
let mut tmp_name = field.to_string();
if !field.contains(".") {
let tmp = main_t_change.to_string() + "." + field;
tmp_name = tmp;
}
tmp_name
}
fn _get_p_in(tmp_v: String) -> String {
let tmp_v = tmp_v.replace("\"", "");
let tmp_vl: Vec<&str> = tmp_v.split(",").collect();
let mut tmp_vs: Vec<String> = vec![];
for t in tmp_vl.iter() {
let tm: String = t.split_whitespace().collect();
let mut v_r = tm.as_str().replace("\\", "\\\\");
v_r = v_r.replace("\"", "\\\"");
tmp_vs.push( "\"".to_string() + &v_r + "\"");
}
tmp_vs.join(",")
}
fn _get_p(k: &str, m: &str, v: &str, vty: &str, main_table_change: &str) -> String {
let tmp_v = match vty {
"&str" => {
let mut v_r = v.to_string().as_str().replace("\\", "\\\\");
v_r = v_r.replace("\"", "\\\"");
"\"".to_string() + &v_r + "\""
},
"alloc::string::String" => {
let mut v_r = v.to_string().as_str().replace("\\", "\\\\");
v_r = v_r.replace("\"", "\\\"");
"\"".to_string() + &v_r + "\""
},
_ => {
v.to_string() + ""
}
};
let k_re = _rename_field(k, main_table_change);
let p = match m {
">" => k_re + " > " + tmp_v.as_str(),
"<" => k_re + " < " + tmp_v.as_str(),
"=" => k_re + " = " + tmp_v.as_str(),
">=" => k_re + " >= " + tmp_v.as_str(),
"<=" => k_re + " <= " + tmp_v.as_str(),
"!=" => k_re + " != " + tmp_v.as_str(),
"like" => k_re + " LIKE " + tmp_v.as_str(),
"in" => k_re + " IN (" + _get_p_in(tmp_v).as_str() + ")",
"not_in" => k_re + " NOT IN (" + _get_p_in(tmp_v).as_str() + ")",
"is_null" => {
let is_null = if tmp_v == "true" {"NULL"} else {"NOT NULL"};
k_re + " is " + is_null
},
_ => "".to_string(),
};
p
}
fn _get_j(k: &str, m: &str, v: &str, t: &str) -> String {
let (_, k_table_re, k_field) = _get_table_f(k, t);
let (v_table, v_table_re, v_field) = _get_table_f(v, t);
let j_string = match m {
"inner" => " INNER JOIN ".to_string() + v_table + " ON " + k_table_re + "." + k_field + " = " + v_table_re + "." + v_field,
"left" => " LEFT JOIN ".to_string() + v_table + " ON " + k_table_re + "." + k_field + " = " + v_table_re + "." + v_field,
"right" => " RIGHT JOIN ".to_string() + v_table + " ON " + k_table_re + "." + k_field + " = " + v_table_re + "." + v_field,
_ => "".to_string()
};
j_string
}
fn _get_select(s: &str, main_table_change: &str) -> String {
let mut tmp_select = String::from("");
for v in s.split(",").collect::<Vec<&str>>().iter() {
let tmpv = v.trim();
tmp_select = tmp_select + _rename_field(tmpv, main_table_change).as_str() + ",";
}
tmp_select.pop();
tmp_select
}
fn _get_order_by(order: &str, main_table_change: &str) -> String {
let mut tmp_order = String::from("");
let tmp_o: String = order.split_whitespace().collect();
for v in tmp_o.split(",").collect::<Vec<&str>>().iter() {
let frs = &v[0..1];
if frs == "-" {
tmp_order = tmp_order + _rename_field(&v[1..], main_table_change).as_str() + " DESC,";
} else {
tmp_order = tmp_order + _rename_field(v, main_table_change).as_str() + " ASC,";
}
}
tmp_order.pop();
" ORDER BY ".to_string() + tmp_order.as_str()
}
let _table_change = get_table($t);
let mut _join = String::from("");
{
$(
_join = _join + _get_j($jk0, $jm0, $jv0, $t).as_str();
)?
}
{
$(
_join = _join + _get_j($jk1, $jm1, $jv1, $t).as_str();
)?
}
{
$(
_join = _join + _get_j($jk2, $jm2, $jv2, $t).as_str();
)?
}
{
$(
_join = _join + _get_j($jk3, $jm3, $jv3, $t).as_str();
)?
}
let mut hash_p: std::collections::HashMap<String, String> = std::collections::HashMap::new();
{
$(
let tm = $v0.clone();
let vt = _type_of($v0);
let t = tm.to_string();
hash_p.insert("p0".to_string(), _get_p($k0, $m0, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v1.clone();
let vt = _type_of($v1);
let t = tm.to_string();
hash_p.insert("p1".to_string(), _get_p($k1, $m1, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v2.clone();
let vt = _type_of($v2);
let t = tm.to_string();
hash_p.insert("p2".to_string(), _get_p($k2, $m2, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v3.clone();
let vt = _type_of($v3);
let t = tm.to_string();
hash_p.insert("p3".to_string(), _get_p($k3, $m3, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v4.clone();
let vt = _type_of($v4);
let t = tm.to_string();
hash_p.insert("p4".to_string(), _get_p($k4, $m4, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v5.clone();
let vt = _type_of($v5);
let t = tm.to_string();
hash_p.insert("p5".to_string(), _get_p($k5, $m5, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v6.clone();
let vt = _type_of($v6);
let t = tm.to_string();
hash_p.insert("p6".to_string(), _get_p($k6, $m6, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v7.clone();
let vt = _type_of($v7);
let t = tm.to_string();
hash_p.insert("p7".to_string(), _get_p($k7, $m7, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v8.clone();
let vt = _type_of($v8);
let t = tm.to_string();
hash_p.insert("p8".to_string(), _get_p($k8, $m8, t.as_str(), vt, _table_change));
)?
}
{
$(
let tm = $v9.clone();
let vt = _type_of($v9);
let t = tm.to_string();
hash_p.insert("p9".to_string(), _get_p($k9, $m9, t.as_str(), vt, _table_change));
)?
}
let mut where_r = String::from("");
let mut _r = String::from("");
let mut _list: Vec<&str> = vec![];
$(
_r = $r.split_whitespace().collect();
let re1 = regex::Regex::new(r"(\()|(\))").unwrap();
_r = re1.replace_all(_r.as_str(), "#$1$2#").to_string();
_list = _r.split("#").collect();
)?
if (_list.len() > 0) {
let mut stack: Vec<String> = vec![];
let mut top_brackets = String::from("");
for (index, item) in _list.iter().enumerate() {
if *item == ")" {
let mut stack_top = if let Some(s) = stack.pop() {s.to_string()} else {"".to_string()};
loop {
if stack_top != "(" {
top_brackets = stack_top + top_brackets.as_str();
stack_top = if let Some(s) = stack.pop() {s.to_string()} else {break;};
continue;
} else {
break;
}
}
let re2 = regex::Regex::new(r"(&&)|(\|\|)").unwrap();
let top_re2 = re2.replace_all(top_brackets.as_str(), "#$1$2#");
let temp_arr: Vec<&str> = top_re2.split("#").collect();
let mut temp_qq = if let Some(p_x) = hash_p.get(temp_arr[0]) {p_x.to_string()} else {"".to_string()};
let mut n = 0;
loop {
if n < temp_arr.len() - 1 {
let tmp = if let Some(p_x) = hash_p.get(temp_arr[n + 2]) {p_x} else {""};
if temp_arr[n + 1] == "&&" {
temp_qq = "(".to_string() + temp_qq.as_str() + " AND " + tmp + ")";
}
if temp_arr[n + 1] == "||" {
temp_qq = "(".to_string() + temp_qq.as_str() + " OR " + tmp + ")";
}
n += 2;
continue;
} else {
break;
}
}
let tmp_pp_name = ("pp".to_string() + index.to_string().as_str()).to_owned();
let tmp_pp_n = tmp_pp_name.clone();
hash_p.insert(tmp_pp_name, temp_qq);
top_brackets = String::from("");
stack.push(tmp_pp_n);
continue;
} else {
stack.push(item.to_string());
}
}
let temp_arr_str2 = String::from_iter(stack);
let re3 = regex::Regex::new(r"(&&)|(\|\|)").unwrap();
let top_re3 = re3.replace_all(temp_arr_str2.as_str(), "#$1$2#");
let temp_arr2: Vec<&str> = top_re3.split("#").collect();
let mut qq_all = if let Some(p_x) = hash_p.get(temp_arr2[0]) {p_x.to_string()} else {"".to_string()};
let mut n_all = 0;
loop {
if n_all < temp_arr2.len() - 1 {
let tmp = if let Some(p_x) = hash_p.get(temp_arr2[n_all + 2]) {p_x} else {""};
if temp_arr2[n_all + 1] == "&&" {
qq_all = "(".to_string() + qq_all.as_str() + " AND " + tmp + ")"
}
if temp_arr2[n_all + 1] == "||" {
qq_all = "(".to_string() + qq_all.as_str() + " OR " + tmp + ")"
}
n_all += 2;
continue;
} else {
break;
}
}
where_r = " WHERE ".to_string() + qq_all.as_str();
}
let mut _page: u32 = 0;
let mut _limit: u32 = 0;
$( _page = $page; )?
$( _limit = $limit; )?
let mut _limit_page = String::from("");
if _page > 0 && _limit > 0 {
_limit_page = " LIMIT ".to_string() + _limit.to_string().as_str() +
" OFFSET " + (_limit * (_page - 1)).to_string().as_str();
} else if _page > 0 {
_limit = 20;
_limit_page = " LIMIT ".to_string() + _limit.to_string().as_str() +
" OFFSET " + (_limit * (_page - 1)).to_string().as_str();
} else if _limit > 0 {
_page = 1;
_limit_page = " LIMIT ".to_string() + _limit.to_string().as_str() +
" OFFSET " + (_limit * (_page - 1)).to_string().as_str();
} else {
_limit_page = " ".to_string();
}
let mut _order_by = String::from("");
$(
_order_by = _get_order_by($order_by, _table_change);
)?
let mut _select = "*";
$(
let tmp_s = _get_select($select, _table_change);
_select = tmp_s.as_str();
)?
let sql = "SELECT ".to_string() + _select +
" FROM " + $t +
_join.as_str() +
where_r.as_str() +
_order_by.as_str() +
_limit_page.as_str();
sql
}
};
}