Skip to main content

rbatis_plus_sqlparser/dialect/
postgresql.rs

1//! PostgreSQL 方言(对标 mybatis-plus `PostgreSqlDialect`)。
2//!
3//! 分页语法: `LIMIT size OFFSET offset`
4
5use super::SqlDialect;
6
7/// PostgreSQL 分页方言。
8///
9/// 对应 Java `com.baomidou.mybatisplus.extension.plugins.pagination.dialects.PostgreSqlDialect`
10#[derive(Debug)]
11pub struct PostgreSqlDialect;
12
13impl SqlDialect for PostgreSqlDialect {
14    fn name(&self) -> &str {
15        "PostgreSQL"
16    }
17
18    /// PostgreSQL 分页: `SELECT ... LIMIT size OFFSET offset`
19    fn build_pagination_sql(&self, sql: &str, offset: u64, size: u64) -> String {
20        format!("{} LIMIT {} OFFSET {}", sql.trim_end(), size, offset)
21    }
22
23    fn supports(&self, db_type: &str) -> bool {
24        let lower = db_type.to_lowercase();
25        lower.contains("postgres") || lower.contains("postgresql")
26    }
27}