Queries

Extends Connection by adding query methods

Just use it as Connection.* methods.

Members

Functions

describePortal
immutable(Answer) describePortal(string portalName)

Submits a request to obtain information about the specified portal, and waits for completion.

describePrepared
immutable(Answer) describePrepared(string statementName)

Submits a request to obtain information about the specified prepared statement, and waits for completion.

exec
immutable(Answer) exec(string SQLcmd)

Perform SQL query to DB It uses the old wire protocol and all values are returned in textual form. This means that the dpq2.conv.to_d_types.as template will likely not work for anything but strings. Try to used execParams instead, even if now parameters are present.

execParams
immutable(Answer) execParams(QueryParams qp)

Perform SQL query to DB

execPrepared
immutable(Answer) execPrepared(QueryParams qp)

Submits a request to execute a prepared statement with given parameters, and waits for completion.

getNextNotify
Notify getNextNotify()

Returns null if no notifies was received

prepare
immutable(Result) prepare(string statementName, string sqlStatement, Oid[] oids)

Submits a request to create a prepared statement with the given parameters, and waits for completion.

prepareEx
void prepareEx(string statementName, string sqlStatement, Oid[] oids)

Submits a request to create a prepared statement with the given parameters, and waits for completion.

putCopyData
bool putCopyData(string data)

Sends a buffer of CSV data to the COPY command

putCopyEnd
immutable(Answer) putCopyEnd()

Signals that COPY data send is finished. Finalize and flush the COPY command.

sendDescribePrepared
void sendDescribePrepared(string statementName)

Submits a request to obtain information about the specified prepared statement, without waiting for completion.

sendPrepare
void sendPrepare(string statementName, string sqlStatement, Oid[] oids)

Sends a request to create a prepared statement with the given parameters, without waiting for completion.

sendPutCopyEnd
bool sendPutCopyEnd()

Signals that COPY data send is finished.

sendQuery
void sendQuery(string SQLcmd)

Submits a command to the server without waiting for the result(s)

sendQueryParams
void sendQueryParams(QueryParams qp)

Submits a command and separate parameters to the server without waiting for the result(s)

sendQueryPrepared
void sendQueryPrepared(QueryParams qp)

Sends a request to execute a prepared statement with given parameters, without waiting for the result(s)

waitEndOf
bool waitEndOf(WaitType type, Duration timeout)
Undocumented in source. Be warned that the author may not have intended to support it.

Meta