use tarantool_rs::{Connection, ExecutorExt};
use tracing::info;

#[tokio::main]
async fn main() -> Result<(), anyhow::Error> {
    pretty_env_logger::init();

    let conn = Connection::builder().build("127.0.0.1:3301").await?;

    info!(
        "{:?}",
        conn.execute_sql("SELECT * FROM \"clients\"", ())
            .await?
            .decode_select::<(u64, String)>()?
    );

    let prepared_insert = dbg!(
        conn.prepare_sql("INSERT INTO \"clients\" (\"id\", \"name\") VALUES (?, ?), (?, ?)")
            .await?
    );
    info!(
        "INSERT row count {}",
        prepared_insert
            .execute((99, "SQL", 100, "SQL"),)
            .await?
            .row_count()?
    );

    info!(
        "DELETE row count {}",
        conn.execute_sql("DELETE FROM \"clients\" WHERE \"name\" = ?", ("SQL",))
            .await?
            .row_count()?
    );

    info!(
        "{:?}",
        conn.execute_sql("SELECT * FROM \"clients\"", ())
            .await?
            .decode_select::<(u64, String)>()?
    );

    Ok(())
}