use anyhow::Result;
use planetscale_driver::{query, Database, PSConnection};
use std::env::var;

#[derive(Database, Debug)]
pub struct TestD {
    pub val: bool,
}

#[tokio::main]
pub async fn main() -> Result<()> {
    let conn = PSConnection::new(&var("PS_HOST")?, &var("PS_USER")?, &var("PS_PASS")?);

    let res: TestD = query("SELECT true").fetch_one(&conn).await?;
    println!("{:?}", res);

    let res: bool = query("SELECT true").fetch_scalar(&conn).await?;
    println!("{:?}", res);

    return Ok(());
}