Functions | |
apr_pool_t * | rxv_spin_db_pool (rxv_spin_db_t *db) |
char * | rxv_spin_db_cinfo (rxv_spin_db_t *db) |
const apr_dbd_driver_t * | rxv_spin_db_driver (rxv_spin_db_t *db) |
apr_dbd_t * | rxv_spin_db_handle (rxv_spin_db_t *db) |
apr_dbd_transaction_t * | rxv_spin_db_txn (rxv_spin_db_txn_t *txn) |
rxv_spin_db_t * | rxv_spin_db_connect (rxv_spin_ctx_t *ctx, const char *conninfo) |
rxv_spin_data_t * | rxv_spin_db_data (apr_pool_t *pool, rxv_spin_db_t *db, apr_dbd_results_t *dbdres) |
rxv_spin_data_t * | rxv_spin_db_select (apr_pool_t *pool, rxv_spin_db_t *db, const char *query) |
int | rxv_spin_db_query (apr_pool_t *pool, rxv_spin_db_t *db, const char *query) |
rxv_spin_data_t * | rxv_spin_db_pselect (apr_pool_t *pool, rxv_spin_db_t *db, const char *query,...) |
int | rxv_spin_db_pquery (apr_pool_t *pool, rxv_spin_db_t *db, const char *query,...) |
rxv_spin_db_txn_t * | rxv_spin_db_start (apr_pool_t *pool, rxv_spin_db_t *db) |
apr_status_t | rxv_spin_db_end (rxv_spin_db_txn_t *txn) |
apr_status_t | rxv_spin_db_status (apr_pool_t *pool, rxv_spin_db_t *db) |
apr_pool_t* rxv_spin_db_pool | ( | rxv_spin_db_t * | db | ) |
Retrieve database specific pool.
db | Database connection |
rxv_spin_db_pool(db);
char* rxv_spin_db_cinfo | ( | rxv_spin_db_t * | db | ) |
Retrieve database connection information.
db | Database connection |
rxv_spin_db_cinfo(db);
const apr_dbd_driver_t* rxv_spin_db_driver | ( | rxv_spin_db_t * | db | ) |
Retrieve database driver.
db | Database connection |
rxv_spin_db_driver(db);
apr_dbd_t* rxv_spin_db_handle | ( | rxv_spin_db_t * | db | ) |
Retrieve database handle.
db | Database connection |
rxv_spin_db_handle(db);
apr_dbd_transaction_t* rxv_spin_db_txn | ( | rxv_spin_db_txn_t * | txn | ) |
Retrieve database transaction.
txn | Database transaction |
rxv_spin_db_txn(txn);
rxv_spin_db_t* rxv_spin_db_connect | ( | rxv_spin_ctx_t * | ctx, | |
const char * | conninfo | |||
) |
Connect to a database and optionally pool the connection.
ctx | Context | |
conninfo | Connection string |
rxv_spin_db_connect(ctx,"pgsql:dbname=spintest");
Connections will be pooled by using connection string as a key into the hash. So, if a connection string differs in the amount of white space or case, this will open a new connection.
rxv_spin_data_t* rxv_spin_db_data | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db, | |||
apr_dbd_results_t * | dbdres | |||
) |
Convert APR DBD SQL result set to mod_spin database result.
pool | Pool used for memory allocation | |
db | Database connection | |
dbdres | APR DBD results |
rxv_spin_db_data(pool,conn,&result,dbdres);
rxv_spin_data_t* rxv_spin_db_select | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db, | |||
const char * | query | |||
) |
Execute a database query that returns a result set (i.e. SELECT).
pool | Pool used for memory allocation | |
db | Database connection | |
query | SQL query to be performed |
result=rxv_spin_db_select(pool,db,"select * from spintest");
int rxv_spin_db_query | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db, | |||
const char * | query | |||
) |
Execute a database query that doesn't return a result set.
pool | Pool used for memory allocation | |
db | Database connection | |
query | SQL query to be performed |
nrows=rxv_spin_db_query(pool,db,"delete from spintest");
rxv_spin_data_t* rxv_spin_db_pselect | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db, | |||
const char * | query, | |||
... | ||||
) |
Prepare and execute database that returns a result set (i.e. SELECT)
pool | Pool used for memory allocation | |
db | Database connection | |
query | SQL query to be prepared and executed | |
... | Parameters for prepared statement, (char *) |
result=rxv_spin_db_pselect(pool,db,"select * from names where name = %s", "Dude",NULL);
int rxv_spin_db_pquery | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db, | |||
const char * | query, | |||
... | ||||
) |
Prepare and execute database that doesn't return a result set.
pool | Pool used for memory allocation | |
db | Database connection | |
query | SQL query to be prepared and executed | |
... | Parameters for prepared statement, (char *) |
nrows=rxv_spin_db_pquery(pool,db,"delete from names where name = %s", "Dude",NULL);
rxv_spin_db_txn_t* rxv_spin_db_start | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db | |||
) |
Start a transaction.
pool | Pool used for memory allocation | |
db | Database connection |
txn=rxv_spin_db_start(pool,db);
apr_status_t rxv_spin_db_end | ( | rxv_spin_db_txn_t * | txn | ) |
End a transaction.
txn | Database transaction |
rxv_spin_db_end(txn);
apr_status_t rxv_spin_db_status | ( | apr_pool_t * | pool, | |
rxv_spin_db_t * | db | |||
) |
Get the status of the connection.
pool | Pool used for memory allocation | |
db | Database connection |
rxv_spin_db_status(pool,db);