Struct pgx::spi::Spi

pub struct Spi;

Implementations

impl Spi

pub fn get_one<A: FromDatum + IntoDatum>(query: &str) -> Option<A>

pub fn get_two<A: FromDatum + IntoDatum, B: FromDatum + IntoDatum>(
    query: &str
) -> (Option<A>, Option<B>)

pub fn get_three<A: FromDatum + IntoDatum, B: FromDatum + IntoDatum, C: FromDatum + IntoDatum>(
    query: &str
) -> (Option<A>, Option<B>, Option<C>)

pub fn get_one_with_args<A: FromDatum + IntoDatum>(
    query: &str,
    args: Vec<(PgOid, Option<Datum>)>
) -> Option<A>

pub fn get_two_with_args<A: FromDatum + IntoDatum, B: FromDatum + IntoDatum>(
    query: &str,
    args: Vec<(PgOid, Option<Datum>)>
) -> (Option<A>, Option<B>)

pub fn get_three_with_args<A: FromDatum + IntoDatum, B: FromDatum + IntoDatum, C: FromDatum + IntoDatum>(
    query: &str,
    args: Vec<(PgOid, Option<Datum>)>
) -> (Option<A>, Option<B>, Option<C>)

pub fn run(query: &str)

just run an arbitrary SQL statement.

Safety

The statement runs in read/write mode

pub fn explain(query: &str) -> Json

explain a query, returning its result in json form

pub fn execute<F: FnOnce(SpiClient) + UnwindSafe>(f: F)

execute SPI commands via the provided SpiClient

pub fn connect<R: FromDatum + IntoDatum, F: FnOnce(SpiClient) -> Result<Option<R>, SpiError>>(
    f: F
) -> Option<R>

execute SPI commands via the provided SpiClient and return a value from SPI which is automatically copied into the CurrentMemoryContext at the time of this function call

pub fn check_status(status_code: i32) -> SpiOk