covid/
covid.rs

1use anyhow::Result;
2use queryer_sql_polars::query;
3
4#[tokio::main]
5async fn main() -> Result<()> {
6    tracing_subscriber::fmt::init();
7
8    let url = "https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/latest/owid-covid-latest.csv";
9
10    // 使用 sql 从 URL 里获取数据
11    let sql = format!(
12        "SELECT location name, total_cases, new_cases, total_deaths, new_deaths \
13        FROM {} where new_deaths >= 200 ORDER BY new_cases DESC",
14        url
15    );
16    println!("{sql}");
17
18    let df = query(sql, "csv").await?;
19    println!("{:?}", df);
20
21    Ok(())
22}