Skip to main content

SqlDialect

Trait SqlDialect 

Source
pub trait SqlDialect: Send + Sync {
    // Required methods
    fn name(&self) -> &str;
    fn build_pagination_sql(&self, sql: &str, offset: u64, size: u64) -> String;
    fn supports(&self, db_type: &str) -> bool;
}
Expand description

SQL 方言 trait(对标 Java IDialect)。

每种数据库实现自己的分页 SQL 改写逻辑。

use rbatis_plus_sqlparser::dialect::SqlDialect;
use rbatis_plus_sqlparser::dialect::mysql::MysqlDialect;

let dialect = MysqlDialect;
let sql = dialect.build_pagination_sql("SELECT * FROM users", 0, 10);
assert!(sql.contains("LIMIT"));

Required Methods§

Source

fn name(&self) -> &str

方言名称。

Source

fn build_pagination_sql(&self, sql: &str, offset: u64, size: u64) -> String

改写 SQL 添加分页(对标 IDialect.buildPaginationSql())。

§参数
  • sql: 原始 SQL
  • offset: 偏移量
  • size: 每页大小
Source

fn supports(&self, db_type: &str) -> bool

是否支持该方言的 SQL(用于自动检测)。

Dyn Compatibility§

This trait is dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety".

Implementors§