Greenbone Vulnerability Manager
9.0.1
|
98 sql_quiet (
char *
sql, ...);
110 sql_int64 (
long long int *ret,
char *, ...);
173 sql_bind_int64 (
sql_stmt_t *,
int,
long long int *);
179 sql_bind_double (
sql_stmt_t *,
int,
double *);
gchar * sql_insert(const char *string)
Get the SQL insert expression for a string.
Definition: sql.c:138
gchar * sql_nquote(const char *string, size_t length)
Quotes a string of a known length to be passed to sql statements.
Definition: sql.c:78
void sql_rollback()
Roll a transaction back.
Definition: sql_pg.c:668
double iterator_double(iterator_t *iterator, int col)
Get a double column from an iterator.
Definition: sql.c:605
const char * sql_select_limit(int max)
Setup a LIMIT argument.
Definition: sql_pg.c:120
int sql_reset(sql_stmt_t *stmt)
Reset a prepared statement.
Definition: sql_pg.c:783
sql_stmt_t * sql_prepare(const char *sql,...)
Prepare a statement.
Definition: sql.c:733
double sql_double(char *sql,...)
Get the first value from a SQL query, as a double.
Definition: sql.c:371
int sql_is_open()
Check whether the database is open.
Definition: sql_pg.c:194
char * sql_string(char *sql,...)
Get a particular cell from a SQL query, as an string.
Definition: sql.c:436
int sql_exec(sql_stmt_t *stmt)
Execute a prepared statement.
Definition: sql.c:756
void sql_close_fork()
Close the database in a forked process.
Definition: sql_pg.c:388
const char * sql_schema()
Get main schema name.
Definition: sql_pg.c:96
int sql_int64(long long int *ret, char *sql,...)
Get a particular cell from a SQL query, as an int64.
Definition: sql.c:468
long long int resource_t
A resource, like a task or target.
Definition: iterator.h:40
long long int iterator_int64(iterator_t *iterator, int col)
Get an integer column from an iterator.
Definition: sql.c:635
void sql_commit()
Commit a transaction.
Definition: sql_pg.c:659
int iterator_int(iterator_t *iterator, int col)
Get a int column from an iterator.
Definition: sql.c:620
int sql_bind_blob(sql_stmt_t *stmt, int position, const void *value, int value_size)
Bind a blob to a statement.
Definition: sql_pg.c:730
int sql_open(const char *database)
Open the database.
Definition: sql_pg.c:254
int sql_begin_immediate_giveup()
Begin an immediate transaction.
Definition: sql_pg.c:645
A generic SQL iterator structure.
Definition: iterator.h:51
void sql_finalize(sql_stmt_t *stmt)
Free a prepared statement.
Definition: sql_pg.c:765
const char * sql_default_database()
Return name of default database.
Definition: sql_pg.c:230
void sql(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
Definition: sql.c:207
int sql_changes()
Return 0.
Definition: sql_pg.c:400
int sql_error(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
Definition: sql.c:238
int sql_int(char *sql,...)
Get a particular cell from a SQL query, as an int.
Definition: sql.c:405
void sql_close()
Close the database.
Definition: sql_pg.c:378
const char * sql_column_text(sql_stmt_t *stmt, int position)
Return a column as text from a prepared statement.
Definition: sql_pg.c:828
int sql_cancel_internal()
Cancels the current SQL statement.
Definition: sql_pg.c:902
long long int sql_int64_0(char *sql,...)
Get a first column of first row from a SQL query, as an int64.
Definition: sql.c:509
const char * iterator_string(iterator_t *iterator, int col)
Get a string column from an iterator.
Definition: sql.c:650
int sql_giveup(char *sql,...)
Perform an SQL statement, giving up if database is busy or locked.
Definition: sql.c:270
const char * sql_database()
Return name of current database.
Definition: sql_pg.c:219
int sql_bind_text(sql_stmt_t *stmt, int position, const gchar *value, gsize value_size)
Bind a text value to a statement.
Definition: sql_pg.c:748
int sql_column_int(sql_stmt_t *stmt, int position)
Return a column as an integer from a prepared statement.
Definition: sql_pg.c:847
void sql_recursive_triggers_off()
Turn off recursive triggers.
Definition: sql_pg.c:241
void sql_begin_immediate()
Begin an immediate transaction.
Definition: sql_pg.c:634
void init_iterator(iterator_t *iterator, const char *sql,...)
Initialise an iterator.
Definition: sql.c:575
const char * sql_greatest()
Get keyword for "greatest" SQL function.
Definition: sql_pg.c:107
gchar * sql_quote(const char *string)
Quotes a string to be passed to sql statements.
Definition: sql.c:123
const char * sql_regexp_op()
Get regular expression operator.
Definition: sql_pg.c:183
long long int sql_column_int64(sql_stmt_t *stmt, int position)
Return a column as an int64 from a prepared statement.
Definition: sql_pg.c:877
int iterator_null(iterator_t *iterator, int col)
Get whether a column is NULL.
Definition: sql_pg.c:685
resource_t sql_last_insert_id()
Get the ID of the last inserted row.
Definition: sql_pg.c:412
void init_prepared_iterator(iterator_t *iterator, sql_stmt_t *stmt)
Initialise an iterator.
Definition: sql.c:559
const char * sql_ilike_op()
Get case insensitive LIKE operator.
Definition: sql_pg.c:172
void sqli(resource_t *resource, char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
Definition: sql_pg.c:425
void sql_rename_column(const char *old_table, const char *new_table, const char *old_name, const char *new_name)
Move data from a table to a new table, heeding column rename.
Definition: manage_pg.c:496
double sql_column_double(sql_stmt_t *stmt, int position)
Return a column as a double from a prepared statement.
Definition: sql_pg.c:809
An SQL statement.
Definition: sql_pg.c:61