use sqlx::MySql;
use sqlx::Pool;

use sqlx::Row;
use qians_xql::blanket::ExprExt;
use qians_xql::blanket::StmtExt;
use qians_xql::select;

#[tokio::test]
async fn test() -> Result<(), Box<dyn std::error::Error>> {
    let user = std::env::var("USER")?;
    let dburi = format!("mysql://{user}@localhost/");
    let pool = Pool::<MySql>::connect(&dburi).await?;

    let query = select([1.alias("one"), 2.alias("two"), 3.alias("three")]);

    let result = query.fetch_one(&pool).await?;
    let one: i32 = result.try_get("one")?;
    let two: i32 = result.try_get("two")?;
    let three: i32 = result.try_get("three")?;
    assert_eq!(one, 1);
    assert_eq!(two, 2);
    assert_eq!(three, 3);
    Ok(())
}