juventus/
juventus.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 file = "file://juventus.json";
9
10    // 使用 sql 从 URL 里获取数据
11    // let sql = format!(
12    //     "SELECT Name,Position,Nationality,\"Kit Number\",DOB \
13    //     FROM {} where Nationality = 'Italy'",
14    //     file
15    // );
16    let sql = format!(
17        "SELECT * \
18        FROM {} where Nationality = 'Italy'",
19        file
20    );
21    println!("{sql}");
22    // let ast = sqlparser::parser::Parser::parse_sql(&queryer::TyrDialect::default(), &sql);
23    // println!("{:#?}", ast);
24
25    let df1 = query(sql, "json").await?;
26    println!("{:?}", df1);
27
28    Ok(())
29}
juventus/juventus.rs

juventus/
juventus.rs
