use testcontainers::runners::SyncRunner;
use testcontainers_modules::postgres::Postgres;
fn main() -> Result<(), Box<dyn std::error::Error + 'static>> {
let node = Postgres::default().start()?;
let connection_string = &format!(
"postgres://postgres:postgres@127.0.0.1:{}/postgres",
node.get_host_port_ipv4(5432)?
);
let mut conn = postgres::Client::connect(connection_string, postgres::NoTls).unwrap();
let rows = conn.query("SELECT 1 + 1", &[]).unwrap();
assert_eq!(rows.len(), 1);
let first_row = &rows[0];
let first_column: i32 = first_row.get(0);
assert_eq!(first_column, 2);
Ok(())
}