pg-proto 0.2.0

Session-typed PostgreSQL wire protocol
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

//! Runs a transparent proxy which logs inbound SQL and result row counts.

#[path = "../proxy_support/mod.rs"]
mod proxy_support;

use std::{env, error::Error, net::SocketAddr, sync::Arc};

use proxy_support::Observation;
use tokio::net::TcpListener;

#[tokio::main]
async fn main() -> Result<(), Box<dyn Error>> {
    let listen = address(1, "127.0.0.1:6432")?;
    let upstream = proxy_support::ExampleUpstream::resolve(env::args().nth(2).as_deref()).await?;
    let upstream_address = upstream.address();
    let tls = proxy_support::ExampleTlsIdentity::generate()?;
    let listener = TcpListener::bind(listen).await?;
    println!("SQL logging proxy listening on {listen}; upstream is {upstream_address}");

    proxy_support::serve(
        listener,
        upstream_address,
        tls,
        Arc::new(|event| match event {
            Observation::Sql {
                connection,
                statement,
            } => println!("[{connection}] SQL: {statement}"),
            Observation::RowCount {
                connection,
                rows,
                command,
            } => println!("[{connection}] ROWS: {rows} ({command})"),
            Observation::Protocol { .. } => {}
        }),
    )
    .await?;
    Ok(())
}

fn address(argument: usize, default: &str) -> Result<SocketAddr, Box<dyn Error>> {
    Ok(env::args()
        .nth(argument)
        .as_deref()
        .unwrap_or(default)
        .parse()?)
}