#![allow(unused_imports)] use dm_pure::{DmClient, ExecuteResult, Param, OutType};
fn main() -> Result<(), Box<dyn std::error::Error>> {
let host = std::env::var("DM_HOST").unwrap_or_else(|_| "127.0.0.1".into());
let port: u16 = std::env::var("DM_PORT").unwrap_or_else(|_| "5236".into()).parse()?;
let user = std::env::var("DM_USER").unwrap_or_else(|_| "SYSDBA".into());
let pwd = std::env::var("DM_PWD").unwrap_or_else(|_| "password".into());
let mut c = DmClient::new(&host, port, &user, &pwd);
c.connect()?;
println!("✅ 连接成功,会话密钥前缀: {:02x?}...", &c.session_key().unwrap()[..4]);
let r = c.execute("select 1", &[])?;
if let ExecuteResult::Query { columns, rows } = r {
println!("select 1 => cols={:?} rows={:?}", columns.iter().map(|c| &c.name).collect::<Vec<_>>(), rows);
}
c.execute(
"CREATE TABLE IF NOT EXISTS rust_demo (id INT, name VARCHAR(100), d DATE, f DOUBLE)",
&[],
)?;
let r = c.execute(
"INSERT INTO rust_demo VALUES (?, ?, ?, ?)",
&[
Param::Int(1),
Param::Str("测试".into()),
Param::Date(dm_pure::DmDate::new(2026, 8, 12)),
Param::Float(std::f64::consts::PI),
],
)?;
println!("INSERT affected: {:?}", r.affected());
let r = c.execute("SELECT id, name, d, f FROM rust_demo WHERE id >= ?", &[Param::Int(1)])?;
if let ExecuteResult::Query { columns, rows } = r {
println!("查询 {} 列, {} 行:", columns.len(), rows.len());
for row in &rows {
println!(" {:?}", row);
}
}
c.begin()?;
c.execute("UPDATE rust_demo SET name = ? WHERE id = ?", &[Param::Str("改".into()), Param::Int(1)])?;
c.rollback()?; println!("事务回滚完成");
c.execute("DROP TABLE rust_demo", &[])?;
c.close();
println!("✅ 示例结束");
Ok(())
}