Skip to main content

dump/
dump.rs

1//! Ferramenta de depuração: conecta, prepara um SELECT e despeja os bytes crus
2//! do describe-info para conferir o parsing.
3//!
4//! Uso:
5//! ```sh
6//! FB_PASSWORD=masterkey cargo run --example dump
7//! ```
8
9use firebird_wire::{ConnectConfig, Connection, Result, WireCrypt};
10
11fn main() -> Result<()> {
12    let cfg = ConnectConfig::new()
13        .host(std::env::var("FB_HOST").unwrap_or_else(|_| "127.0.0.1".into()))
14        .port(
15            std::env::var("FB_PORT")
16                .ok()
17                .and_then(|p| p.parse().ok())
18                .unwrap_or(3555),
19        )
20        .database(std::env::var("FB_DB").unwrap_or_else(|_| "employee".into()))
21        .user(std::env::var("FB_USER").unwrap_or_else(|_| "SYSDBA".into()))
22        .password(std::env::var("FB_PASSWORD").expect("set FB_PASSWORD"))
23        .wire_crypt(WireCrypt::Enabled);
24
25    let mut conn = Connection::connect(&cfg)?;
26    println!("conectado: protocolo v{}", conn.protocol_version());
27    let tx = conn.begin()?;
28
29    let sql = "SELECT emp_no, first_name FROM employee WHERE emp_no = 2";
30    let stmt = conn.prepare(&tx, sql)?;
31    println!(
32        "\nstmt_type={} colunas={}",
33        stmt.stmt_type(),
34        stmt.columns().len()
35    );
36    for c in stmt.columns() {
37        println!(
38            "  [{}] name={:?} field={:?} relation={:?} alias={:?} owner={:?} type={} sub={} scale={} len={}",
39            c.index,
40            c.name(),
41            c.field,
42            c.relation,
43            c.alias,
44            c.owner,
45            c.sql_type,
46            c.sub_type,
47            c.scale,
48            c.length
49        );
50    }
51
52    stmt.drop_statement(&mut conn)?;
53    tx.commit(&mut conn)?;
54    conn.close()?;
55    Ok(())
56}