Struct rssql::SQLRets

pub struct SQLRets {
    pub column: Vec<String>,
    pub rets: Vec<HashMap<String, SQLDataTypes>>,
}

Fields

column: Vec<String>

Column name vec sort by default.

rets: Vec<HashMap<String, SQLDataTypes>>

Returns.

Implementations

impl SQLRets

pub fn new() -> SQLRets

pub fn push_rets(&mut self, row: HashMap<String, SQLDataTypes>)

pub fn push_column_name(&mut self, column_name: &str)

pub fn get_first_one(&self, column_name: &str) -> Option<SQLDataTypes>

Get first data by column name.

use rssql::MySQL;
async fn test_mysql_one() {
    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();
    for c in &rets.column {
        println!("{}", rets.get_first_one(&c).unwrap());
    }
    for r in rets.get_all("id").unwrap() {
        println!("{}", r);
    }
    mysql.close().await;
}

pub fn get_all(&self, column_name: &str) -> Option<Vec<SQLDataTypes>>

Get all data by column name.

Trait Implementations

impl Debug for SQLRets

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

Formats the value using the given formatter.

impl Display for SQLRets

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

Formats the value using the given formatter.