Struct rssql::MySQL

pub struct MySQL { /* private fields */ }

Implementations

impl MySQL

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

Connect to mysql (mariadb) database.

Example

use rssql::MySQL;
async fn test_mysql() {
    let url = "mysql://user:password@docker:13306/test";
    let mut mysql = MySQL::connect(url).await.unwrap();
    let check = mysql.check_connection().await;
    println!("{}", check);
    let rets = mysql.execute("SELECT * FROM info").await.unwrap();
    println!("{}", rets);
    let rets = mysql.execute("INSERT INTO info (name, datetime, date) VALUES ('test3', '2011-01-01', '2011-02-02')").await.unwrap();
    let rets = mysql.execute("SELECT * FROM info").await.unwrap();
    println!("{}", rets);
    mysql.close().await;
}

Output

true
+----+-------+---------------------+------------+
| id | name  |      datetime       |    date    |
+----+-------+---------------------+------------+
| 1  | test1 | 2023-03-20 00:00:00 | 2001-10-22 |
| 2  | test2 | 2023-03-20 00:00:00 | 2001-10-22 |
+----+-------+---------------------+------------+
+----+-------+---------------------+------------+
| id | name  |      datetime       |    date    |
+----+-------+---------------------+------------+
| 1  | test1 | 2023-03-20 00:00:00 | 2001-10-22 |
| 2  | test2 | 2023-03-20 00:00:00 | 2001-10-22 |
| 3  | test3 | 2011-01-01 00:00:00 | 2011-02-02 |
+----+-------+---------------------+------------+

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

Execute the sql.

pub async fn close(self)

Close the mysql (mariadb) connnection.

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

Check if the connection is valid.