Package | Description |
---|---|
com.caucho.quercus.lib.db |
Modifier and Type | Method and Description |
---|---|
PostgresResult |
Postgres.getAsynchronousResult() |
static PostgresResult |
PostgresModule.pg_exec(Env env,
Postgres conn,
java.lang.String query)
pg_query() alias
|
static PostgresResult |
PostgresModule.pg_execute(Env env,
Postgres conn,
java.lang.String stmtName,
ArrayValue params)
Sends a request to execute a prepared statement with given parameters,
and waits for the result
|
static PostgresResult |
PostgresModule.pg_get_result(Env env,
Postgres conn)
Get asynchronous query result
|
static PostgresResult |
PostgresModule.pg_query_params(Env env,
Postgres conn,
java.lang.String query,
ArrayValue params)
Submits a command to the server and waits for the result,
with the ability to pass parameters separately from the SQL command text
|
static PostgresResult |
PostgresModule.pg_query(Env env,
Postgres conn,
java.lang.String query)
Execute a query
|
static PostgresResult |
PostgresModule.pg_query(Env env,
java.lang.String query)
Execute a query
|
PostgresResult |
Postgres.query(Env env,
java.lang.String sql)
Executes a query.
|
Modifier and Type | Method and Description |
---|---|
static int |
PostgresModule.pg_affected_rows(Env env,
PostgresResult result)
Returns number of affected records (tuples)
|
static int |
PostgresModule.pg_cmdtuples(Env env,
PostgresResult result)
pg_affected_rows() alias.
|
static ArrayValue |
PostgresModule.pg_fetch_all_columns(Env env,
PostgresResult result,
LongValue column)
Fetches all rows in a particular result column as an array
|
static ArrayValue |
PostgresModule.pg_fetch_all(Env env,
PostgresResult result)
Fetches all rows from a result as an array
|
static Value |
PostgresModule.pg_fetch_array(Env env,
PostgresResult result,
Value row,
int resultType)
Fetch a row as an array
|
static Value |
PostgresModule.pg_fetch_assoc(Env env,
PostgresResult result,
Value row)
Fetch a row as an associative array
|
static Value |
PostgresModule.pg_fetch_object(Env env,
PostgresResult result,
Value row,
int resultType)
Fetch a row as an object
|
static Value |
PostgresModule.pg_fetch_result(Env env,
PostgresResult result,
Value row,
Value fieldNameOrNumber)
Returns values from a result resource
|
static Value |
PostgresModule.pg_fetch_row(Env env,
PostgresResult result,
Value row)
Get a row as an enumerated array
|
static LongValue |
PostgresModule.pg_field_is_null(Env env,
PostgresResult result,
Value row,
Value fieldNameOrNumber)
Test if a field is SQL NULL
|
static Value |
PostgresModule.pg_field_name(Env env,
PostgresResult result,
int fieldNumber)
Returns the name of a field
|
static int |
PostgresModule.pg_field_num(Env env,
PostgresResult result,
java.lang.String fieldName)
Returns the field number of the named field
|
static int |
PostgresModule.pg_field_prtlen(Env env,
PostgresResult result,
Value rowNumber,
Value fieldNameOrNumber)
Returns the printed length
|
static LongValue |
PostgresModule.pg_field_size(Env env,
PostgresResult result,
int fieldNumber)
Returns the internal storage size of the named field
|
static java.lang.String |
PostgresModule.pg_field_table(Env env,
PostgresResult result,
int fieldNumber,
boolean oidOnly)
Returns the name or oid of the tables field
|
static LongValue |
PostgresModule.pg_field_type_oid(Env env,
PostgresResult result,
int fieldNumber)
Returns the type ID (OID) for the corresponding field number
|
static StringValue |
PostgresModule.pg_field_type(Env env,
PostgresResult result,
int fieldNumber)
Returns the type name for the corresponding field number
|
static LongValue |
PostgresModule.pg_fieldisnull(Env env,
PostgresResult result,
Value row,
Value fieldNameOrNumber)
pg_field_is_null() alias.
|
static Value |
PostgresModule.pg_fieldname(Env env,
PostgresResult result,
int fieldNumber)
pg_field_name() alias.
|
static int |
PostgresModule.pg_fieldnum(Env env,
PostgresResult result,
java.lang.String fieldName)
pg_field_num() alias.
|
static int |
PostgresModule.pg_fieldprtlen(Env env,
PostgresResult result,
Value rowNumber,
Value fieldNameOrNumber)
pg_field_ptrlen() alias.
|
static LongValue |
PostgresModule.pg_fieldsize(Env env,
PostgresResult result,
int fieldNumber)
pg_field_size() alias.
|
static StringValue |
PostgresModule.pg_fieldtype(Env env,
PostgresResult result,
int fieldNumber)
pg_field_type() alias.
|
static boolean |
PostgresModule.pg_free_result(Env env,
PostgresResult result)
Free result memory
|
static boolean |
PostgresModule.pg_freeresult(Env env,
PostgresResult result)
pg_free_result() alias.
|
static java.lang.String |
PostgresModule.pg_getlastoid(Env env,
PostgresResult result) |
static java.lang.String |
PostgresModule.pg_last_oid(Env env,
PostgresResult result)
Returns the last row's OID
Note that:
- OID is a unique id.
|
static int |
PostgresModule.pg_num_fields(Env env,
PostgresResult result)
Returns the number of fields in a result
|
static LongValue |
PostgresModule.pg_num_rows(Env env,
PostgresResult result)
Returns the number of rows in a result
|
static int |
PostgresModule.pg_numfields(Env env,
PostgresResult result)
pg_num_fields() alias.
|
static LongValue |
PostgresModule.pg_numrows(Env env,
PostgresResult result)
pg_num_rows() alias.
|
static Value |
PostgresModule.pg_result_error_field(Env env,
PostgresResult result,
int fieldCode)
Returns an individual field of an error report
|
static java.lang.String |
PostgresModule.pg_result_error(Env env,
PostgresResult result)
Get error message associated with result
|
static boolean |
PostgresModule.pg_result_seek(Env env,
PostgresResult result,
int offset)
Set internal row offset in result resource
|
static int |
PostgresModule.pg_result_status(Env env,
PostgresResult result,
int type)
Get status of query result
|
static Value |
PostgresModule.pg_result(Env env,
PostgresResult result,
Value row,
Value fieldNameOrNumber)
Returns values from a result resource
|
void |
Postgres.setAsynchronousResult(PostgresResult asyncResult) |