Struct wdinfo::postgresql::PostgreSQL

pub struct PostgreSQL {
    pub conn: Client,
}

PostgreSQL

• Connect to PostgreSQL
• Execute queries to PostgreSQL
• import data into PostgreSQL

Fields

conn: Client

Implementations

impl PostgreSQL

pub fn new(
    host: String,
    username: String,
    password: String,
    database: String
) -> Result<Self, &'static str>

customer connection

* You can provide:
  * host as string
  * username as string
  * password as string
  * database as string

Trait Implementations

impl Default for PostgreSQL

Default initialization of PostgreSQL

• use as defalt

fn default() -> Self

default method

* Use postgres::Client::connect method
* PostgreSQL database installed in 192.168.1.213

impl SQL for PostgreSQL

fn execute_queries_no_return(&mut self, qry: &str) -> Result<(), &'static str>

submit query without return values

fn check_table_exists(
    &mut self,
    skm: &str,
    tbl: &str
) -> Result<bool, &'static str>

check if table exist

* Return bool
* need schema and table name as argument

fn drop_table(&mut self, skm: &str, tbl: &str) -> Result<(), &'static str>

drop table

* need schema and table name as argument

fn truncate_table(&mut self, skm: &str, tbl: &str) -> Result<(), &'static str>

truncate table

* need schema and table name as argument

fn create_table(
    &mut self,
    skm: &str,
    tbl: &str,
    tbl_str: &str
) -> Result<(), &'static str>

create table

* need schema, table name, and table structure (String) as argument

fn import_data(
    &mut self,
    skm: &str,
    tbl: &str,
    datastring: String
) -> Result<(), &'static str>

import data into PostgreSQL table

* need query and data string as argument

fn execute_query_with_return(
    &mut self,
    qry: &str
) -> Result<Vec<String>, &'static str>

submit query and catch the output

* output is vector of String with [tab] as delimiter
* Leave it to be handled by the following code

fn create_truncate_table(
    &mut self,
    skm: &str,
    tbl: &str,
    tbl_str: &str
) -> Result<(), &'static str>