Struct Pgsql 

pub struct Pgsql {
    pub connection: Connection,
    pub default: String,
    pub params: Params,
    pub client: Pools,
}

Fields

connection: Connection

当前连接配置

default: String

当前选中配置

params: Params

client: Pools

Implementations

impl Pgsql

pub fn connect(connection: Connection, default: String) -> Result<Self, String>

Trait Implementations

impl Clone for Pgsql

fn clone(&self) -> Pgsql

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl DbMode for Pgsql

fn database_tables(&mut self) -> JsonValue

数据库是否存在

fn database_create(&mut self, name: &str) -> bool

创建数据库

fn truncate(&mut self, table: &str) -> bool

fn backups(&mut self, _filename: &str) -> bool

备份

impl Mode for Pgsql

fn table_create(&mut self, options: TableOptions) -> JsonValue

fn table_update(&mut self, options: TableOptions) -> JsonValue

fn table_info(&mut self, table: &str) -> JsonValue

获取表信息

fn table_is_exist(&mut self, name: &str) -> bool

判断表是否存在

fn table(&mut self, name: &str) -> &mut Pgsql

当前表

fn change_table(&mut self, name: &str) -> &mut Self

别名

fn autoinc(&mut self) -> &mut Self

主键自增

fn timestamps(&mut self) -> &mut Self

自动时间戳

fn fetch_sql(&mut self) -> &mut Self

返回sql语句

fn order(&mut self, field: &str, by: bool) -> &mut Self

排序

fn group(&mut self, field: &str) -> &mut Self

分组

fn distinct(&mut self) -> &mut Self

消除重复记录

fn json(&mut self, field: &str) -> &mut Self

JSON 字段

fn location(&mut self, field: &str) -> &mut Self

location 字段

fn field(&mut self, field: &str) -> &mut Self

显示字段

fn field_raw(&mut self, expr: &str) -> &mut Self

原始表达式字段（不加表前缀，如 “SUM(amount) as total”、“CASE WHEN … END as status_count”）

fn hidden(&mut self, name: &str) -> &mut Self

隐藏字段

fn where_and( &mut self, field: &str, compare: &str, value: JsonValue, ) -> &mut Self

查询

fn where_or( &mut self, field: &str, compare: &str, value: JsonValue, ) -> &mut Self

fn where_raw(&mut self, expr: &str) -> &mut Self

原始 WHERE 条件（不加表前缀，如 “YEAR(created_at) = 2026”）

fn where_in_sub(&mut self, field: &str, sub_sql: &str) -> &mut Self

子查询 WHERE field IN (sub_sql)

fn where_not_in_sub(&mut self, field: &str, sub_sql: &str) -> &mut Self

子查询 WHERE field NOT IN (sub_sql)

fn where_exists(&mut self, sub_sql: &str) -> &mut Self

fn where_not_exists(&mut self, sub_sql: &str) -> &mut Self

fn where_column( &mut self, field_a: &str, compare: &str, field_b: &str, ) -> &mut Self

比较两个列

fn update_column(&mut self, field_a: &str, compare: &str) -> &mut Self

更新指定列

fn page(&mut self, page: i32, limit: i32) -> &mut Self

分页

fn limit(&mut self, count: i32) -> &mut Self

独立限制返回条数（不带分页偏移）

fn column(&mut self, field: &str) -> JsonValue

查询指定列并返回数组

fn count(&mut self) -> JsonValue

总数量

fn max(&mut self, field: &str) -> JsonValue

最大值

fn min(&mut self, field: &str) -> JsonValue

最小值

fn sum(&mut self, field: &str) -> JsonValue

合计

fn avg(&mut self, field: &str) -> JsonValue

平均值

fn having(&mut self, expr: &str) -> &mut Self

HAVING 条件（用于 GROUP BY 后过滤，如 “COUNT(*) > 5”）

fn select(&mut self) -> JsonValue

获取集合

fn find(&mut self) -> JsonValue

获取单记录

fn value(&mut self, field: &str) -> JsonValue

获取单一列值

fn insert(&mut self, data: JsonValue) -> JsonValue

添加

fn insert_all(&mut self, data: JsonValue) -> JsonValue

批量添加

fn upsert(&mut self, data: JsonValue, conflict_fields: Vec<&str>) -> JsonValue

插入或更新（冲突时更新）

fn update(&mut self, data: JsonValue) -> JsonValue

更新

fn update_all(&mut self, data: JsonValue) -> JsonValue

批量更新

fn delete(&mut self) -> JsonValue

删除

fn transaction(&mut self) -> bool

事务开始

fn commit(&mut self) -> bool

事务提交

fn rollback(&mut self) -> bool

事务回滚

fn sql(&mut self, sql: &str) -> Result<JsonValue, String>

sql语句执行

fn sql_execute(&mut self, sql: &str) -> Result<JsonValue, String>

fn inc(&mut self, field: &str, num: f64) -> &mut Self

自增

fn dec(&mut self, field: &str, num: f64) -> &mut Self

自减

fn buildsql(&mut self) -> String

构造子查询

fn join_fields(&mut self, fields: Vec<&str>) -> &mut Self

fn join( &mut self, main_table: &str, main_fields: &str, right_table: &str, right_fields: &str, ) -> &mut Self

连结

fn join_inner( &mut self, table: &str, main_fields: &str, second_fields: &str, ) -> &mut Self

内连接–用来取交集

fn join_right( &mut self, main_table: &str, main_fields: &str, right_table: &str, right_fields: &str, ) -> &mut Self

右连接

fn join_full( &mut self, main_table: &str, main_fields: &str, right_table: &str, right_fields: &str, ) -> &mut Self

全连接

fn union(&mut self, sub_sql: &str) -> &mut Self

fn union_all(&mut self, sub_sql: &str) -> &mut Self

fn lock_for_update(&mut self) -> &mut Self

fn lock_for_share(&mut self) -> &mut Self