This is my code
extern crate postgres;
use postgres::{Connection, SslMode};
struct User {
reference: String,
email: String
}
static DB_URI: &'static str = "postgres://postgres:postgres@localhost/test";
fn main() {
let conn = Connection::connect(DB_URI, &SslMode::None).unwrap();
let trans = conn.transaction().unwrap();
let user = User {
reference: "123abc".to_string(),
email: "test@test.com".to_string()
};
let result = insert_user(&trans, &user);
trans.set_commit();
trans.finish();
}
fn insert_user<'_>(trans: &postgres::Transaction<'_>, user: &User) -> postgres::Result<postgres::rows::Rows<'_>> {
let query = "INSERT INTO usr (reference, email) VALUES ($1, $2)";
trans.prepare(query).unwrap().query(&[&user.reference, &user.email])
}
It's producing an error:
src/main.rs:31:2: 31:31 error: borrowed value does not live long enough
src/main.rs:31 trans.prepare(query).unwrap().query(&[&user.reference, &user.email])
^~~~~~~~~~~~~~~~~~~~~~~~~~~~~
src/main.rs:29:114: 32:2 note: reference must be valid for the lifetime '_ as defined on the block at 29:113...
src/main.rs:29 fn insert_user<'_>(trans: &postgres::Transaction<'_>, user: &User) -> postgres::Result<postgres::rows::Rows<'_>> {
src/main.rs:30 let query = "INSERT INTO usr (reference, email) VALUES ($1, $2)";
src/main.rs:31 trans.prepare(query).unwrap().query(&[&user.reference, &user.email])
src/main.rs:32 }
src/main.rs:29:114: 32:2 note: ...but borrowed value is only valid for the block at 29:113
src/main.rs:29 fn insert_user<'_>(trans: &postgres::Transaction<'_>, user: &User) -> postgres::Result<postgres::rows::Rows<'_>> {
src/main.rs:30 let query = "INSERT INTO usr (reference, email) VALUES ($1, $2)";
src/main.rs:31 trans.prepare(query).unwrap().query(&[&user.reference, &user.email])
src/main.rs:32 }
error: aborting due to previous error
Could not compile `test`.
What is the problem here?