use crate::dialect::SqlDialect;
use crate::parser::SqlParser;
pub struct SqlRewriter;
impl SqlRewriter {
pub fn rewrite_pagination(
sql: &str,
page_no: u64,
page_size: u64,
dialect: &dyn SqlDialect,
) -> String {
let offset = (page_no - 1) * page_size;
dialect.build_pagination_sql(sql, offset, page_size)
}
pub fn rewrite_count(sql: &str) -> String {
SqlParser::get_count_sql(sql)
}
pub fn can_paginate(sql: &str) -> bool {
let parsed = SqlParser::parse(sql);
if parsed.has_for_update {
return false;
}
matches!(parsed.statement_type, crate::parser::StatementType::Select)
}
}