Skip to main content

WhitelistValidator

Struct WhitelistValidator 

Source
pub struct WhitelistValidator { /* private fields */ }
Expand description

白名单校验器,限制 SQL 只能访问允许的表和列。

Implementations§

Source§

impl WhitelistValidator

Source

pub fn new() -> Self

创建空的白名单校验器(默认拒绝所有)。

Source

pub fn allow_table(self, table: &str) -> Self

添加允许的表名。

Source

pub fn allow_tables(self, tables: &[&str]) -> Self

添加多个允许的表名。

Source

pub fn allow_columns(self, columns: &[&str]) -> Self

设置允许的列名集合。设置后,SQL 中引用的列必须在集合内。

Source

pub fn validate_tables(&self, sql: &str) -> ValidationResult

校验 SQL 中的表名是否在白名单内。

通过词法分析提取所有出现在 FROM / JOIN / INTO / UPDATE 后的标识符, 检查它们是否在 allowed_tables 集合内。

Source

pub fn validate_columns(&self, sql: &str) -> ValidationResult

校验 SQL 中的列名是否在白名单内。

提取 SELECT 后、WHERE 子句中、SET 后的标识符作为列名进行校验。 注意:此校验为启发式,可能无法覆盖所有列引用场景。

Source

pub fn validate(&self, sql: &str) -> ValidationResult

同时校验表名和列名。

Trait Implementations§

Source§

impl Clone for WhitelistValidator

Source§

fn clone(&self) -> WhitelistValidator

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl Debug for WhitelistValidator

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl Default for WhitelistValidator

Source§

fn default() -> WhitelistValidator

Returns the “default value” for a type. Read more

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> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. 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> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

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

Source§

type Error = Infallible

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

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

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.