Skip to main content

SqlRewriter

Struct SqlRewriter 

Source
pub struct SqlRewriter;
Expand description

SQL 改写器(对标 Java AbstractJsqlParser 的分页改写功能)。

负责将原始 SQL 改写为带分页的 SQL。

Implementations§

Source§

impl SqlRewriter

Source

pub fn rewrite_pagination( sql: &str, page_no: u64, page_size: u64, dialect: &dyn SqlDialect, ) -> String

改写 SQL 添加分页(对标 JsqlParserSupport.parserSingle() + 方言改写)。

§参数
  • sql: 原始 SQL
  • page_no: 页码(从 1 开始)
  • page_size: 每页大小
  • dialect: 数据库方言
§返回

改写后的分页 SQL。

Source

pub fn rewrite_count(sql: &str) -> String

改写 COUNT SQL(对标 JsqlParserSupport.parserMulti() + COUNT 改写)。

将原始查询 SQL 改写为 COUNT 查询。

Source

pub fn can_paginate(sql: &str) -> bool

检查 SQL 是否可以安全分页(不包含 FOR UPDATE 等不安全语句)。

对应 Java PaginationInnerInterceptor.consumes() 中的安全检查

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = !

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, !>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.