use crate::mysql::condition::SqlValue;
use super::{QueryBuilder, SqlGenerator};
impl<'a> QueryBuilder<'a> {
pub fn try_to_sql(&self) -> Result<String, crate::error::DbError> {
let mut generator = SqlGenerator::new();
generator.build_select(self)?;
Ok(generator.get_sql().to_string())
}
pub(crate) fn render_for_transaction(
&self,
lock: Option<crate::RowLock>,
) -> Result<(String, Vec<SqlValue>), crate::error::DbError> {
if lock.is_some()
&& (self.distinct
|| !self.group_by.is_empty()
|| !self.having_clause.is_empty()
|| !self.unions.is_empty())
{
return Err(crate::error::DbError::InvalidArgument(
"行锁不支持 DISTINCT、GROUP BY、HAVING 或 UNION 查询".to_string(),
));
}
let mut generator = SqlGenerator::new();
generator.build_select(self)?;
if let Some(lock) = lock {
generator.sql.push(' ');
generator.sql.push_str(lock.as_sql());
}
Ok((generator.sql, generator.params))
}
pub fn to_sql(&self) -> String {
match self.try_to_sql() {
Ok(sql) => sql,
Err(err) => {
if self.enable_logging {
log::warn!("生成 SELECT SQL 失败: {err}");
}
"/* SQL generation failed */".to_string()
}
}
}
}