41sql_select_limit (
int);
53sql_default_database ();
56sql_recursive_triggers_off ();
107sql_int64 (
long long int *ret,
char *, ...);
116sql_cancel_internal ();
121sql_begin_immediate ();
124sql_begin_immediate_giveup ();
long long int resource_t
A resource, like a task or target.
Definition: iterator.h:39
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:140
double iterator_double(iterator_t *iterator, int col)
Get a double column from an iterator.
Definition: sql.c:621
gchar * sql_insert(const char *string)
Get the SQL insert expression for a string.
Definition: sql.c:198
int sql_giveup(char *sql,...)
Perform an SQL statement, giving up if database is busy or locked.
Definition: sql.c:342
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:562
int iterator_int(iterator_t *iterator, int col)
Get a int column from an iterator.
Definition: sql.c:636
void init_iterator(iterator_t *iterator, const char *sql,...)
Initialise an iterator.
Definition: sql.c:592
gchar * sql_quote(const char *string)
Quotes a string to be passed to sql statements.
Definition: sql.c:146
int sql_error(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
Definition: sql.c:310
const char * iterator_string(iterator_t *iterator, int col)
Get a string column from an iterator.
Definition: sql.c:666
int sql_int64(long long int *ret, char *sql,...)
Get a particular cell from a SQL query, as an int64.
Definition: sql.c:521
gchar ** iterator_array(iterator_t *iterator, int col)
Get a string column from an iterator.
Definition: sql.c:685
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:101
char * sql_string(char *sql,...)
Get a particular cell from a SQL query, as an string.
Definition: sql.c:489
void sql(char *sql,...)
Perform an SQL statement, retrying if database is busy or locked.
Definition: sql.c:269
int sql_int(char *sql,...)
Get a particular cell from a SQL query, as an int.
Definition: sql.c:458
long long int iterator_int64(iterator_t *iterator, int col)
Get an integer column from an iterator.
Definition: sql.c:651
double sql_double(char *sql,...)
Get the first value from a SQL query, as a double.
Definition: sql.c:424
gchar * sql_ascii_escape_and_quote(const char *string)
Quotes a string for use in SQL statements, also ASCII escaping it if it is not valid UTF-8.
Definition: sql.c:161
Data structure for info used to connect to the database.
Definition: manage.h:47
A generic SQL iterator structure.
Definition: iterator.h:50