use sqlx::postgres::{PgArguments, PgRow};
use sqlx::query::Query;
use std::borrow::Cow;
use super::bind_query;
use super::ExecError;
use super::Postgres;
use crate::core::InsertQuery;
use crate::sql::Dialect as _;
pub(crate) async fn pg_insert_returning<'c, E>(
executor: E,
query: Cow<'_, InsertQuery>,
) -> Result<PgRow, ExecError>
where
E: sqlx::Executor<'c, Database = sqlx::Postgres>,
{
if query.returning.is_empty() {
return Err(ExecError::EmptyReturning);
}
query.validate()?;
let stmt = Postgres.compile_insert_cow(query)?;
let mut q: Query<'_, sqlx::Postgres, PgArguments> = sqlx::query(&stmt.sql);
for value in stmt.params {
q = bind_query(q, value);
}
let row = q.fetch_one(executor).await?;
Ok(row)
}