Struct tiny_web::sys::db::DB

pub struct DB { /* private fields */ }

Responsible for working with postgresql database:

Properties

• client: Option<tokio_postgres::Client> - Client for connection to database;
• sql_conn: tokio_postgres::Config - Connection config;
• tls: Option<MakeTlsConnector> - Use tls for connection when sslmode=require;
• zone: Option<String> - Time zone to init database;
• prepare: Vec<DBStatement> - Prepare statement to database.

Implementations

impl DB

pub async fn new(config: Arc<DBConfig>) -> DB

Initializes a new object DB

Parameters

• config: Arc<DBConfig> - database configuration.

Return

• DB - new DB object

pub async fn connect(&mut self) -> bool

Connect to the database

Return

• true - the connection was successful;
• false - the connection was fail.

pub async fn query_params( &mut self, query: &str, params: &[&(dyn ToSql + Sync)] ) -> Option<Vec<Row>>

Execute query to database with paramaters

Parmeters

• query: &str - SQL query;
• params: &[&(dyn ToSql + Sync)] - Array of params.

Return

• Option::None - When error query or diconnected;
• Option::Some(Vec<Row>) - Get result.

pub async fn query_raw(&mut self, query: &str) -> Option<Vec<Row>>

Execute query to database and return a raw result

Parmeters

• query: &str - SQL query;
• params: &[&(dyn ToSql + Sync)] - Array of params.

Return

• Option::None - When error query or diconnected;
• Option::Some(Vec<Row>) - Results.

pub async fn query(&mut self, query: &str, assoc: bool) -> Option<Vec<Data>>

Execute query to database

Parmeters

• query: &str - SQL query;
• params: &[&(dyn ToSql + Sync)] - Array of params.

Return

• Option::None - When error query or diconnected;
• Option::Some(Vec<Data>) - Results.

pub async fn query_fast( &mut self, index: usize, params: &[&(dyn ToSql + Sync)] ) -> Option<Vec<Row>>

Execute prepare query to database

Parmeters

• index: usize - index of prepare query;
• params: &[&(dyn ToSql + Sync)] - Array of params.

Return

• Option::None - When error query or diconnected;
• Option::Some(Vec<Row>) - Results.

Trait Implementations

impl Debug for DB

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

Formats the value using the given formatter.