Struct rssql::PostgreSQL

pub struct PostgreSQL { /* private fields */ }

Implementations

impl PostgreSQL

pub async fn connect(url: &str) -> Result<PostgreSQL>

Connect to postgresql database.

use rssql::PostgreSQL;
async fn test_postgresql() {
    let url = "postgre://user:password@docker:15432/test";
    let mut postgresql = PostgreSQL::connect(url).await.unwrap();
    let check = postgresql.check_connection().await;
    println!("{}", check);
    let rets = postgresql.execute("SELECT * FROM info").await.unwrap();
    println!("{}", rets);
    postgresql.close().await;
}

Output

true
+----+-------+------------+
| id | name  |    date    |
+----+-------+------------+
| 1  | test2 | 2023-06-11 |
| 2  | test1 | 2023-06-11 |
+----+-------+------------+

pub async fn execute(&mut self, sql: &str) -> Result<SQLRets>

Execute the sql.

pub async fn close(self)

Close the postgresql connnection.

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

Check if the connection is valid.