Conntect to mssql with tiberius and tokio29.08.22

use tiberius::{Client, Config, AuthMethod};
use tokio::net::TcpStream;
use tokio_util::compat::TokioAsyncWriteCompatExt;

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    let mut config = Config::new();
File Edit Options Buffers Tools Conf Help                                                                                                                                                                                         
[package]
name = "sql2postgreSQL"
version = "0.1.0"
authors = ["veto"]
edition = "2021"

[lib]
name = "mylib"
path = "src/lib.rs"

[dependencies]
tiberius = {version ="0.10.0"}
tokio = {version = "1.11.0", features = ["full"]}
tokio-util = {version = "0.7.3", features = ["full"]}
anyhow = {version = "1.0.62"}

config.host("192.168.80.232");
    config.port(1433);
    config.authentication(AuthMethod::sql_server("Apps", "passpass"));
    config.trust_cert(); // on production, it is not a good idea to do this

let tcp = TcpStream::connect(config.get_addr()).await?;
    tcp.set_nodelay(true)?;
    let mut _client = Client::connect(config, tcp.compat_write()).await?;
    let mut  _stream = _client.query("SELECT TOP 100 * FROM sl.dbo.av0_style",&[]).await?;
    let mut _vec = _stream.into_results().await?;
    for i in _vec.into_iter()
     {
       for _row in i.into_iter()
       {
       }
     }
    Ok(())
}

https://docs.rs/tiberius/0.10.0/tiberius/index.html#modules

Anonymous

Conntect to mssql with tiberius and tokio29.08.22

Information Epoch 1713514861