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}