26 #ifndef OPENVAS_MANAGER_SQL_H 27 #define OPENVAS_MANAGER_SQL_H 112 sql_int64 (
long long int * ret,
char *, ...);
int sql_is_sqlite3()
Get whether backend is SQLite3.
void sql_close_fork()
Close the database in a forked process.
int sql_is_open()
Check whether the database is open.
void sqli(resource_t *, char *,...)
Perform an SQL statement, retrying if database is busy or locked.
const char * sql_schema()
Get main schema name.
int sql_begin_exclusive_giveup()
Begin an exclusive transaction, giving up on failure.
int sql_bind_double(sql_stmt_t *, int, double *)
Bind a double value to a statement.
int sql_int64(long long int *ret, char *,...)
Get a particular cell from a SQL query, as an int64.
double sql_column_double(sql_stmt_t *, int)
Return a column as a double from a prepared statement.
int sql_giveup(char *sql,...)
Perform an SQL statement, giving up if database is busy or locked.
void sql_begin_exclusive()
Begin an exclusive transaction.
resource_t sql_last_insert_id()
Get the ID of the last inserted row.
const char * iterator_string(iterator_t *, int)
Get a string column from an iterator.
const char * sql_greatest()
Get keyword for "greatest" SQL function.
gchar * sql_insert(const char *)
Get the SQL insert expression for a string.
void sql(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
void sql_rollback()
Roll a transaction back.
void sql_rename_column(const char *, const char *, const char *, const char *)
Move data from a table to a new table, heeding column rename.
int sql_begin_immediate_giveup()
Begin an immediate transaction.
void sql_quiet(char *sql,...)
Perform an SQL statement, without logging.
int iterator_int(iterator_t *, int)
Get a int column from an iterator.
long long int sql_column_int64(sql_stmt_t *, int)
Return a column as an int64 from a prepared statement.
int sql_column_int(sql_stmt_t *, int)
Return a column as an integer from a prepared statement.
gchar * sql_quote(const char *)
Quotes a string to be passed to sql statements.
int sql_changes()
Return 0.
int sql_open(const char *)
Open the database.
int sql_exec(sql_stmt_t *)
Execute a prepared statement.
const char * iterator_column_name(iterator_t *, int)
Get a column name from an iterator.
const char * sql_column_text(sql_stmt_t *, int)
Return a column as text from a prepared statement.
int iterator_null(iterator_t *, int)
Get whether a column is NULL.
double iterator_double(iterator_t *, int)
Get a double column from an iterator.
int sql_error(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
const char * sql_regexp_op()
Get regular expression operator.
gchar * sql_nquote(const char *, size_t)
Quotes a string of a known length to be passed to sql statements.
int sql_bind_int64(sql_stmt_t *, int, long long int *)
Bind an int64 value to a statement.
void sql_close()
Close the database.
void sql_begin_immediate()
Begin an immediate transaction.
const char * sql_default_database()
Return name of default database.
long long int iterator_int64(iterator_t *, int)
Get an integer column from an iterator.
void init_prepared_iterator(iterator_t *, sql_stmt_t *)
Initialise an iterator.
double sql_double(char *sql,...)
Get the first value from a SQL query, as a double.
int sql_bind_blob(sql_stmt_t *, int, const void *, int)
Bind a blob to a statement.
char * sql_string(char *,...)
Get a particular cell from a SQL query, as an string.
int iterator_column_count(iterator_t *)
Get number of columns from an iterator.
void sql_commit()
Commit a transaction.
const char * sql_ilike_op()
Get case insensitive LIKE operator.
void init_iterator(iterator_t *, const char *,...)
Initialise an iterator.
const char * sql_database()
Return name of current database.
int sql_cancel_internal()
Cancels the current SQL statement.
int sql_int(char *,...)
Get a particular cell from a SQL query, as an int.
const char * sql_select_limit(int)
Setup a LIMIT argument.
int sql_bind_text(sql_stmt_t *, int, const gchar *, gsize)
Bind a text value to a statement.
int sql_reset(sql_stmt_t *)
Reset a prepared statement.
sql_stmt_t * sql_prepare(const char *sql,...)
Prepare a statement.
void sql_finalize(sql_stmt_t *)
Free a prepared statement.
long long int resource_t
A resource, like a task or target.