Lines Matching refs:db

56     db:close(): Closes an open database connection.
62 lua_db_handle *db;
66 db = lua_get_db_handle(L);
67 if (db && db->alive) {
68 if (db->type == LUA_DBTYPE_APR_DBD) {
69 rc = apr_dbd_close(db->driver, db->handle);
70 if (db->pool) apr_pool_destroy(db->pool);
75 if (db->dbdhandle) lua_ap_dbd_close(db->server, db->dbdhandle);
78 db->driver = NULL;
79 db->handle = NULL;
80 db->alive = 0;
81 db->pool = NULL;
91 db:__gc(): Garbage collecting function.
97 lua_db_handle *db;
100 db = lua_touserdata(L, 1);
101 if (db && db->alive) {
102 if (db->type == LUA_DBTYPE_APR_DBD) {
103 apr_dbd_close(db->driver, db->handle);
104 if (db->pool) apr_pool_destroy(db->pool);
109 if (db->dbdhandle) lua_ap_dbd_close(db->server, db->dbdhandle);
111 db->driver = NULL;
112 db->handle = NULL;
113 db->alive = 0;
114 db->pool = NULL;
122 db:active(): Returns true if the connection to the db is still active.
128 lua_db_handle *db = 0;
132 db = lua_get_db_handle(L);
133 if (db && db->alive) {
134 rc = apr_dbd_check_conn(db->driver, db->pool, db->handle);
147 db:query(statement): Executes the given database query and returns the
155 lua_db_handle *db = 0;
162 db = lua_get_db_handle(L);
163 if (db && db->alive)
164 rc = apr_dbd_query(db->driver, db->handle, &x, statement);
175 const char *err = apr_dbd_error(db->driver, db->handle, rc);
190 db:escape(string): Escapes a string for safe use in the given database type.
196 lua_db_handle *db = 0;
206 db = lua_get_db_handle(L);
207 if (db && db->alive) {
209 escaped = apr_dbd_escape(db->driver, r->pool, statement,
210 db->handle);
303 db:select(statement): Queries the database for the given statement and
311 lua_db_handle *db = 0;
320 db = lua_get_db_handle(L);
321 if (db && db->alive) {
329 rc = apr_dbd_select(db->driver, db->pool, db->handle,
333 cols = apr_dbd_num_cols(db->driver, results);
339 resultset->driver = db->driver;
340 resultset->pool = db->pool;
341 resultset->rows = apr_dbd_num_tuples(db->driver, results);
356 const char *err = apr_dbd_error(db->driver, db->handle, rc);
407 vars = apr_pcalloc(st->db->pool, have*sizeof(char *));
413 if (st->db && st->db->alive) {
420 rc = apr_dbd_pselect(st->db->driver, st->db->pool, st->db->handle,
428 cols = apr_dbd_num_cols(st->db->driver, results);
432 resultset->driver = st->db->driver;
433 resultset->pool = st->db->pool;
434 resultset->rows = apr_dbd_num_tuples(st->db->driver, results);
448 const char *err = apr_dbd_error(st->db->driver, st->db->handle, rc);
498 vars = apr_pcalloc(st->db->pool, have*sizeof(char *));
504 if (st->db && st->db->alive) {
510 rc = apr_dbd_pquery(st->db->driver, st->db->pool, st->db->handle,
519 const char *err = apr_dbd_error(st->db->driver, st->db->handle, rc);
539 db:prepare(statement): Prepares a statement for later query/select.
540 Returns a table with a :query and :select function, same as the db funcs.
546 lua_db_handle *db = 0;
573 db = lua_get_db_handle(L);
574 rc = apr_dbd_prepare(db->driver, r->pool, db->handle, statement,
578 const char *err = apr_dbd_error(db->driver, db->handle, rc);
594 st->db = db;
612 db:prepared(statement): Fetches a prepared statement made through
619 lua_db_handle *db = 0;
628 db = lua_get_db_handle(L);
633 pstatement = apr_hash_get(db->dbdhandle->prepared, tag,
649 st->db = db;
670 lua_db_handle* db;
672 db = lua_newuserdata(L, sizeof(lua_db_handle));
673 db->alive = 1;
674 db->pool = pool;
675 db->type = type;
676 db->dbdhandle = 0;
677 db->server = r->server;
712 return db;
732 lua_db_handle *db = 0;
751 db = lua_push_db_handle(L, r, LUA_DBTYPE_MOD_DBD, dbdhandle->pool);
752 db->driver = dbdhandle->driver;
753 db->handle = dbdhandle->handle;
754 db->dbdhandle = dbdhandle;
789 db = lua_push_db_handle(L, r, LUA_DBTYPE_APR_DBD, pool);
790 db->driver = dbdhandle->driver;
791 db->handle = dbdhandle->handle;
792 db->dbdhandle = dbdhandle;