Function main

21_postgresql/rust/pg_blocking/src/main.rs:37–66

()

}

fn main() -> Result<(), Error> {
    let mut client = Client::connect("host=localhost user=htd", NoTls)?;

    let rows = client.query(MOST_RECOVERED, &[])?;

    let value: chrono::NaiveDate = rows[0].get(0);
    println!("{:?}", value);
    println!("{:?}", row_to_str_vec(&rows[0]));
    println!("{:?}", row_to_str_hashmap(&rows[0]));

    let mut transaction = client.transaction()?;
    transaction.query("DELETE FROM month_cases", &[])?;
    let ins_mv = transaction.prepare(
        "INSERT INTO month_cases
            (mon, new_cases, recovered)
            VALUES ($1, $2, $3)",
    )?;
    for row in transaction.query(GROUP_BY_MONTH, &[])? {
        println!("{:?}", row_to_str_vec(&row));
        let date: chrono::NaiveDate = row.get(0);
        let new_cases: i64 = row.get(1);
        let recovered: i64 = row.get(2);
        transaction.execute(
            &ins_mv,
            &[&date.to_string(), &(new_cases as i32), &(recovered as i32)],
        )?;
    }
    transaction.commit()?;
    Ok(())
}