Skip to main content

rbatis_plus_sqlparser/dialect/
sqlite.rs

1//! SQLite 方言(对标 mybatis-plus `SQLiteDialect`)。
2//!
3//! 分页语法: `LIMIT size OFFSET offset`(与 PostgreSQL 相同)
4
5use super::SqlDialect;
6
7/// SQLite 分页方言。
8#[derive(Debug)]
9pub struct SqliteDialect;
10
11impl SqlDialect for SqliteDialect {
12    fn name(&self) -> &str {
13        "SQLite"
14    }
15
16    /// SQLite 分页: `SELECT ... LIMIT size OFFSET offset`
17    fn build_pagination_sql(&self, sql: &str, offset: u64, size: u64) -> String {
18        format!("{} LIMIT {} OFFSET {}", sql.trim_end(), size, offset)
19    }
20
21    fn supports(&self, db_type: &str) -> bool {
22        db_type.to_lowercase().contains("sqlite")
23    }
24}