Struct DB 

pub struct DB {}

A struct that represents a database.

Implementations

impl DB

pub fn exist_db(db_name: &str) -> bool

Checks whether a database exists.

Arguments

• db_name - The name of the database to check.

Returns

• bool - true if the database exists, false otherwise.

pub fn exist(table_name: &str) -> bool

Checks whether a table exists in the database.

Arguments

• table_name - The name of the table to check.

Returns

• bool - true if the table exists, false otherwise.

pub fn exist_schema(table_name: &str, schema: &str) -> bool

Checks whether a table exists in the database.

Arguments

• table_name - The name of the table to check.
• schema - Optional. The name of the schema to check in.

Returns

• bool - true if the table exists, false otherwise.

pub fn exec(sql: &str) -> i32

Executes an SQL statement and returns the number of rows affected.

Arguments

• sql - The SQL statement to execute.

Returns

• i32 - The number of rows affected by the statement.

pub fn transaction(query: DBQuery) -> bool

Executes a list of SQL statements as a single transaction.

Arguments

• query - A list of SQL statements to execute.

Returns

• bool - true if the transaction was successful, false otherwise.

pub fn transaction_async(query: DBQuery, callback: Box<dyn FnMut(bool)>)

Executes a list of SQL statements as a single transaction asynchronously.

Arguments

• sqls - A list of SQL statements to execute.
• callback - A callback function that is invoked when the transaction is executed, receiving the result of the transaction.

Returns

• bool - true if the transaction was successful, false otherwise.

pub fn query(sql: &str, with_columns: bool) -> DBRecord

Executes an SQL query and returns the results as a list of rows.

Arguments

• sql - The SQL statement to execute.
• with_column - Whether to include column names in the result.

Returns

• DBRecord - A list of rows returned by the query.

pub fn query_with_params( sql: &str, params: &Array, with_columns: bool, ) -> DBRecord

Executes an SQL query and returns the results as a list of rows.

Arguments

• sql - The SQL statement to execute.
• params - A list of values to substitute into the SQL statement.
• with_column - Whether to include column names in the result.

Returns

• DBRecord - A list of rows returned by the query.

pub fn insert(table_name: &str, values: DBParams)

Inserts a row of data into a table within a transaction.

Arguments

• table_name - The name of the table to insert into.
• values - The values to insert into the table.

Returns

• bool - true if the insertion was successful, false otherwise.

pub fn exec_with_records(sql: &str, values: DBParams) -> i32

Executes an SQL statement and returns the number of rows affected.

Arguments

• sql - The SQL statement to execute.
• values - Lists of values to substitute into the SQL statement.

Returns

• i32 - The number of rows affected by the statement.

pub fn query_with_params_async( sql: &str, params: &Array, with_columns: bool, callback: Box<dyn FnMut(DBRecord)>, )

Executes an SQL query asynchronously and returns the results as a list of rows.

Arguments

• sql - The SQL statement to execute.
• params - Optional. A list of values to substitute into the SQL statement.
• with_column - Optional. Whether to include column names in the result. Default is false.
• callback - A callback function that is invoked when the query is executed, receiving the results as a list of rows.

pub fn insert_async( table_name: &str, values: DBParams, callback: Box<dyn FnMut(bool)>, )

Inserts a row of data into a table within a transaction asynchronously.

Arguments

• table_name - The name of the table to insert into.
• values - The values to insert into the table.
• callback - A callback function that is invoked when the insertion is executed, receiving the result of the insertion.

pub fn exec_async(sql: &str, values: DBParams, callback: Box<dyn FnMut(i64)>)

Executes an SQL statement with a list of values within a transaction asynchronously and returns the number of rows affected.

Arguments

• sql - The SQL statement to execute.
• values - A list of values to substitute into the SQL statement.
• callback - A callback function that is invoked when the statement is executed, recieving the number of rows affected.