use serde::{Deserialize, Serialize};
use serde_json::json;
use yang_db::postgres::Database;
fn db_url() -> String {
std::env::var("PG_TEST_URL")
.unwrap_or_else(|_| "postgres://postgres:postgres@localhost:5433/test".to_string())
}
#[derive(Debug, Serialize, Deserialize, sqlx::FromRow)]
struct User {
id: i32,
name: String,
age: Option<i32>,
}
#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
println!("=== PostgreSQL 基础用法示例 ===\n");
let db = Database::connect(&db_url()).await?;
println!("✓ 数据库连接成功\n");
let table_name = yang_db::table!("example_pg_users");
let _ = db.drop_table(table_name).await;
db.create_table(&format!(
"CREATE TABLE {} (
id SERIAL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
age INT
)",
table_name
))
.await?;
println!("✓ 测试表已创建\n");
let new_id = db
.table(table_name)
.insert(&json!({"name": "张三", "age": 25}))
.await?;
println!("✓ INSERT 成功,新行 id = {}\n", new_id);
let affected = db
.table(table_name)
.on_conflict(&[yang_db::field!("id")])
.upsert(&json!({"id": new_id as i64, "name": "张三(改)", "age": 26}))
.await?;
println!("✓ UPSERT 完成,影响 {} 行\n", affected);
let users: Vec<User> = db
.table(table_name)
.field(yang_db::field!("id"))
.field(yang_db::field!("name"))
.field(yang_db::field!("age"))
.where_and(yang_db::field!("age"), yang_db::CompareOp::Gte, 18)?
.order(yang_db::field!("id"), yang_db::SortOrder::Asc)
.limit(10)
.select()
.await?;
println!("✓ SELECT 命中 {} 行: {:?}\n", users.len(), users);
let _ = db.drop_table(table_name).await;
println!("=== 示例结束 ===");
Ok(())
}