OpenVAS Manager
7.0.3~git
|
Go to the source code of this file.
Functions | |
int | sql_is_sqlite3 () |
Get whether backend is SQLite3. More... | |
const char * | sql_schema () |
Get main schema name. More... | |
const char * | sql_greatest () |
Get keyword for "greatest" SQL function. More... | |
const char * | sql_select_limit (int) |
Setup a LIMIT argument. More... | |
const char * | sql_regexp_op () |
Get regular expression operator. More... | |
const char * | sql_ilike_op () |
Get case insensitive LIKE operator. More... | |
const char * | sql_database () |
Return name of current database. More... | |
const char * | sql_default_database () |
Return name of default database. More... | |
int | sql_is_open () |
Check whether the database is open. More... | |
int | sql_open (const char *) |
Open the database. More... | |
void | sql_close () |
Close the database. More... | |
void | sql_close_fork () |
Close the database in a forked process. More... | |
int | sql_changes () |
Return 0. More... | |
resource_t | sql_last_insert_id () |
Get the ID of the last inserted row. More... | |
gchar * | sql_nquote (const char *, size_t) |
Quotes a string of a known length to be passed to sql statements. More... | |
gchar * | sql_quote (const char *) |
Quotes a string to be passed to sql statements. More... | |
gchar * | sql_insert (const char *) |
Get the SQL insert expression for a string. More... | |
void | sql (char *sql,...) |
Perform an SQL statement, retrying if database is busy or locked. More... | |
void | sqli (resource_t *, char *,...) |
Perform an SQL statement, retrying if database is busy or locked. More... | |
int | sql_error (char *sql,...) |
Perform an SQL statement, retrying if database is busy or locked. More... | |
int | sql_giveup (char *sql,...) |
Perform an SQL statement, giving up if database is busy or locked. More... | |
void | sql_quiet (char *sql,...) |
Perform an SQL statement, without logging. More... | |
double | sql_double (char *sql,...) |
Get the first value from a SQL query, as a double. More... | |
int | sql_int (char *,...) |
Get a particular cell from a SQL query, as an int. More... | |
char * | sql_string (char *,...) |
Get a particular cell from a SQL query, as an string. More... | |
int | sql_int64 (long long int *ret, char *,...) |
Get a particular cell from a SQL query, as an int64. More... | |
void | sql_rename_column (const char *, const char *, const char *, const char *) |
Move data from a table to a new table, heeding column rename. More... | |
void | sql_begin_exclusive () |
Begin an exclusive transaction. More... | |
int | sql_begin_exclusive_giveup () |
Begin an exclusive transaction, giving up on failure. More... | |
void | sql_begin_immediate () |
Begin an immediate transaction. More... | |
int | sql_begin_immediate_giveup () |
Begin an immediate transaction. More... | |
void | sql_commit () |
Commit a transaction. More... | |
void | sql_rollback () |
Roll a transaction back. More... | |
void | init_prepared_iterator (iterator_t *, sql_stmt_t *) |
Initialise an iterator. More... | |
void | init_iterator (iterator_t *, const char *,...) |
Initialise an iterator. More... | |
double | iterator_double (iterator_t *, int) |
Get a double column from an iterator. More... | |
int | iterator_int (iterator_t *, int) |
Get a int column from an iterator. More... | |
long long int | iterator_int64 (iterator_t *, int) |
Get an integer column from an iterator. More... | |
int | iterator_null (iterator_t *, int) |
Get whether a column is NULL. More... | |
const char * | iterator_string (iterator_t *, int) |
Get a string column from an iterator. More... | |
const char * | iterator_column_name (iterator_t *, int) |
Get a column name from an iterator. More... | |
int | iterator_column_count (iterator_t *) |
Get number of columns from an iterator. More... | |
sql_stmt_t * | sql_prepare (const char *sql,...) |
Prepare a statement. More... | |
int | sql_bind_blob (sql_stmt_t *, int, const void *, int) |
Bind a blob to a statement. More... | |
int | sql_bind_int64 (sql_stmt_t *, int, long long int *) |
Bind an int64 value to a statement. More... | |
int | sql_bind_text (sql_stmt_t *, int, const gchar *, gsize) |
Bind a text value to a statement. More... | |
int | sql_bind_double (sql_stmt_t *, int, double *) |
Bind a double value to a statement. More... | |
int | sql_exec (sql_stmt_t *) |
Execute a prepared statement. More... | |
void | sql_finalize (sql_stmt_t *) |
Free a prepared statement. More... | |
int | sql_reset (sql_stmt_t *) |
Reset a prepared statement. More... | |
double | sql_column_double (sql_stmt_t *, int) |
Return a column as a double from a prepared statement. More... | |
const char * | sql_column_text (sql_stmt_t *, int) |
Return a column as text from a prepared statement. More... | |
int | sql_column_int (sql_stmt_t *, int) |
Return a column as an integer from a prepared statement. More... | |
long long int | sql_column_int64 (sql_stmt_t *, int) |
Return a column as an int64 from a prepared statement. More... | |
int | sql_cancel_internal () |
Cancels the current SQL statement. More... | |
void init_iterator | ( | iterator_t * | iterator, |
const char * | sql, | ||
... | |||
) |
Initialise an iterator.
[in] | iterator | Iterator. |
[in] | sql | Format string for SQL. |
Definition at line 577 of file sql.c.
References iterator::crypt_ctx, iterator::done, iterator::prepared, sql(), sql_prepare_internal(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), check_db_sequences(), check_generate_scripts(), init_aggregate_iterator(), init_alert_data_iterator(), init_alert_task_iterator(), init_task_group_iterator(), init_task_role_iterator(), init_task_user_iterator(), migrate_122_to_123(), migrate_12_to_13(), migrate_138_to_139(), migrate_143_to_144(), migrate_153_to_154(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_168_to_169(), migrate_16_to_17(), migrate_19_to_20(), migrate_1_to_2(), migrate_21_to_22(), migrate_24_to_25(), migrate_35_to_36(), migrate_4_to_5_copy_data(), migrate_55_to_56(), migrate_9_to_10(), refresh_nvt_cves(), and sql_rename_column().
void init_prepared_iterator | ( | iterator_t * | iterator, |
sql_stmt_t * | stmt | ||
) |
Initialise an iterator.
[in] | iterator | Iterator. |
[in] | stmt | Statement. |
Definition at line 561 of file sql.c.
References iterator::crypt_ctx, iterator::done, iterator::prepared, and iterator::stmt.
int iterator_column_count | ( | iterator_t * | iterator | ) |
Get number of columns from an iterator.
[in] | iterator | Iterator. |
Definition at line 706 of file sql_pg.c.
References iterator::done, sql_stmt::result, iterator::stmt, and sql_stmt::stmt.
Referenced by sql_rename_column().
const char* iterator_column_name | ( | iterator_t * | iterator, |
int | col | ||
) |
Get a column name from an iterator.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 691 of file sql_pg.c.
References iterator::done, sql_stmt::result, iterator::stmt, and sql_stmt::stmt.
Referenced by sql_rename_column().
double iterator_double | ( | iterator_t * | iterator, |
int | col | ||
) |
Get a double column from an iterator.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 607 of file sql.c.
References iterator::done, sql_column_double(), and iterator::stmt.
int iterator_int | ( | iterator_t * | iterator, |
int | col | ||
) |
Get a int column from an iterator.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 622 of file sql.c.
References iterator::done, sql_column_int(), and iterator::stmt.
Referenced by alert_iterator_condition(), alert_iterator_event(), alert_iterator_filter_name(), alert_iterator_filter_readable(), alert_iterator_filter_trash(), alert_iterator_filter_uuid(), alert_iterator_method(), alert_task_iterator_readable(), migrate_153_to_154(), migrate_160_to_161(), migrate_165_to_166(), task_iterator_finished_reports(), task_iterator_run_status(), and task_iterator_total_reports().
long long int iterator_int64 | ( | iterator_t * | iterator, |
int | col | ||
) |
Get an integer column from an iterator.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 637 of file sql.c.
References iterator::done, sql_column_int64(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), alert_iterator_filter(), check_generate_scripts(), migrate_138_to_139(), migrate_143_to_144(), migrate_153_to_154(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_168_to_169(), migrate_16_to_17(), migrate_19_to_20(), migrate_1_to_2(), migrate_21_to_22(), migrate_35_to_36(), migrate_4_to_5_copy_data(), migrate_55_to_56(), migrate_9_to_10(), refresh_nvt_cves(), task_alert_iterator_alert(), and task_iterator_scanner().
int iterator_null | ( | iterator_t * | iterator, |
int | col | ||
) |
Get whether a column is NULL.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 675 of file sql_pg.c.
References iterator::done, sql_stmt::result, iterator::stmt, and sql_stmt::stmt.
const char* iterator_string | ( | iterator_t * | iterator, |
int | col | ||
) |
Get a string column from an iterator.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 652 of file sql.c.
References iterator::done, sql_column_text(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), alert_data_iterator_data(), alert_data_iterator_name(), alert_task_iterator_name(), alert_task_iterator_uuid(), check_db_sequences(), check_generate_scripts(), migrate_122_to_123(), migrate_12_to_13(), migrate_138_to_139(), migrate_143_to_144(), migrate_153_to_154(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_16_to_17(), migrate_19_to_20(), migrate_1_to_2(), migrate_21_to_22(), migrate_4_to_5_copy_data(), migrate_55_to_56(), migrate_9_to_10(), refresh_nvt_cves(), task_iterator_first_report(), task_iterator_hosts_ordering(), task_iterator_last_report(), and task_iterator_run_status_name().
void sql | ( | char * | sql, |
... | |||
) |
Perform an SQL statement, retrying if database is busy or locked.
[in] | sql | Format string for SQL statement. |
[in] | ... | Arguments for format string. |
Definition at line 199 of file sql.c.
Referenced by add_role_permission(), add_task_alert(), check_config_discovery(), check_config_host_discovery(), check_config_system_discovery(), check_db_sequences(), cleanup_tables(), create_tables(), init_iterator(), make_config_discovery(), make_config_host_discovery(), make_config_system_discovery(), manage_attach_databases(), manage_create_sql_functions(), manage_session_init(), manage_session_set_timezone(), migrate_0_to_1(), migrate_100_to_101(), migrate_101_to_102(), migrate_102_to_103(), migrate_103_to_104(), migrate_104_to_105(), migrate_105_to_106(), migrate_106_to_107(), migrate_107_to_108(), migrate_108_to_109(), migrate_109_to_110(), migrate_10_to_11(), migrate_110_to_111(), migrate_111_to_112(), migrate_112_to_113(), migrate_113_to_114(), migrate_114_to_115(), migrate_115_to_116(), migrate_116_to_117(), migrate_117_to_118(), migrate_118_to_119(), migrate_119_to_120(), migrate_11_to_12(), migrate_120_to_121(), migrate_121_to_122(), migrate_122_to_123(), migrate_123_to_124(), migrate_124_to_125(), migrate_125_to_126(), migrate_126_to_127(), migrate_127_to_128(), migrate_128_to_129(), migrate_129_to_130(), migrate_12_to_13(), migrate_130_to_131(), migrate_131_to_132(), migrate_132_to_133(), migrate_133_to_134(), migrate_134_to_135(), migrate_135_to_136(), migrate_136_to_137(), migrate_137_to_138(), migrate_138_to_139(), migrate_139_to_140(), migrate_13_to_14(), migrate_140_to_141(), migrate_141_to_142(), migrate_142_to_143(), migrate_143_to_144(), migrate_144_to_145(), migrate_145_to_146(), migrate_146_to_147(), migrate_148_to_149(), migrate_149_to_150(), migrate_14_to_15(), migrate_153_to_154(), migrate_154_to_155(), migrate_155_to_156(), migrate_156_to_157(), migrate_157_to_158(), migrate_158_to_159(), migrate_159_to_160(), migrate_15_to_16(), migrate_160_to_161(), migrate_161_to_162(), migrate_162_to_163(), migrate_163_to_164(), migrate_164_to_165(), migrate_165_to_166(), migrate_166_to_167(), migrate_167_to_168(), migrate_16_to_17(), migrate_172_to_173(), migrate_173_to_174(), migrate_175_to_176(), migrate_176_to_177(), migrate_177_to_178(), migrate_178_to_179(), migrate_179_to_180(), migrate_179_to_180_update_ref(), migrate_17_to_18(), migrate_17_to_18_set_pref(), migrate_180_to_181(), migrate_182_to_183(), migrate_183_to_184(), migrate_18_to_19(), migrate_19_to_20(), migrate_1_to_2(), migrate_20_to_21(), migrate_21_to_22(), migrate_22_to_23(), migrate_23_to_24(), migrate_25_to_26(), migrate_26_to_27(), migrate_27_to_28(), migrate_28_to_29(), migrate_29_to_30(), migrate_2_to_3(), migrate_30_to_31(), migrate_31_to_32(), migrate_32_to_33(), migrate_33_to_34_set_pref(), migrate_34_to_35(), migrate_35_to_36(), migrate_35_to_36_duplicate_target(), migrate_36_to_37(), migrate_38_to_39(), migrate_39_to_40_set_pref(), migrate_3_to_4(), migrate_40_to_41(), migrate_41_to_42(), migrate_42_to_43(), migrate_44_to_45(), migrate_45_to_46(), migrate_46_to_47(), migrate_47_to_48(), migrate_48_to_49(), migrate_49_to_50(), migrate_4_to_5(), migrate_4_to_5_copy_data(), migrate_50_to_51(), migrate_51_to_52(), migrate_52_to_53(), migrate_53_to_54(), migrate_54_to_55_format(), migrate_55_to_56(), migrate_55_to_56_ensure_predefined_port_lists_exist(), migrate_56_to_57(), migrate_57_to_58(), migrate_58_to_59(), migrate_59_to_60(), migrate_5_to_6_move_other_config(), migrate_60_to_61(), migrate_61_to_62(), migrate_62_to_63(), migrate_63_to_64(), migrate_64_to_65(), migrate_65_to_66(), migrate_66_to_67(), migrate_67_to_68(), migrate_68_to_69(), migrate_69_to_70(), migrate_6_to_7(), migrate_70_to_71(), migrate_71_to_72(), migrate_72_to_73(), migrate_73_to_74(), migrate_74_to_75(), migrate_75_to_76(), migrate_76_to_77(), migrate_77_to_78(), migrate_78_to_79(), migrate_79_to_80_remove_users(), migrate_7_to_8(), migrate_80_to_81(), migrate_82_to_83(), migrate_83_to_84(), migrate_84_to_85(), migrate_85_to_86(), migrate_86_to_87(), migrate_87_to_88(), migrate_88_to_89(), migrate_89_to_90(), migrate_8_to_9(), migrate_90_to_91(), migrate_91_to_92(), migrate_92_to_93(), migrate_93_to_94(), migrate_94_to_95(), migrate_95_to_96(), migrate_96_to_97(), migrate_97_to_98(), migrate_98_to_99(), migrate_99_to_100(), migrate_9_to_10(), refresh_nvt_cves(), set_db_version(), set_report_scheduled(), set_task_alerts(), set_task_alterable(), set_task_config(), set_task_groups(), set_task_hosts_ordering(), set_task_observers(), set_task_scanner(), set_task_schedule(), set_task_schedule_next_time(), set_task_schedule_next_time_uuid(), set_task_schedule_periods(), set_task_schedule_periods_id(), set_task_schedule_uuid(), set_task_start_time(), set_task_start_time_epoch(), set_task_start_time_otp(), set_task_target(), sql(), sql_begin_exclusive(), sql_begin_immediate(), sql_commit(), sql_double(), sql_error(), sql_explain(), sql_explain_internal(), sql_giveup(), sql_int(), sql_int64(), sql_prepare(), sql_prepare_internal(), sql_quiet(), sql_rename_column(), sql_reset(), sql_rollback(), sql_string(), sqli(), sqlv(), and user_ensure_in_db().
void sql_begin_exclusive | ( | ) |
Begin an exclusive transaction.
Definition at line 598 of file sql_pg.c.
References sql().
Referenced by migrate_0_to_1(), migrate_100_to_101(), migrate_101_to_102(), migrate_102_to_103(), migrate_103_to_104(), migrate_104_to_105(), migrate_105_to_106(), migrate_106_to_107(), migrate_107_to_108(), migrate_108_to_109(), migrate_109_to_110(), migrate_10_to_11(), migrate_110_to_111(), migrate_111_to_112(), migrate_112_to_113(), migrate_113_to_114(), migrate_114_to_115(), migrate_115_to_116(), migrate_116_to_117(), migrate_117_to_118(), migrate_118_to_119(), migrate_119_to_120(), migrate_11_to_12(), migrate_120_to_121(), migrate_121_to_122(), migrate_122_to_123(), migrate_123_to_124(), migrate_124_to_125(), migrate_125_to_126(), migrate_126_to_127(), migrate_127_to_128(), migrate_128_to_129(), migrate_129_to_130(), migrate_12_to_13(), migrate_130_to_131(), migrate_131_to_132(), migrate_132_to_133(), migrate_133_to_134(), migrate_134_to_135(), migrate_135_to_136(), migrate_136_to_137(), migrate_137_to_138(), migrate_138_to_139(), migrate_139_to_140(), migrate_13_to_14(), migrate_140_to_141(), migrate_141_to_142(), migrate_142_to_143(), migrate_143_to_144(), migrate_144_to_145(), migrate_145_to_146(), migrate_146_to_147(), migrate_147_to_148(), migrate_148_to_149(), migrate_149_to_150(), migrate_14_to_15(), migrate_150_to_151(), migrate_151_to_152(), migrate_152_to_153(), migrate_153_to_154(), migrate_154_to_155(), migrate_155_to_156(), migrate_156_to_157(), migrate_157_to_158(), migrate_158_to_159(), migrate_159_to_160(), migrate_15_to_16(), migrate_160_to_161(), migrate_161_to_162(), migrate_162_to_163(), migrate_163_to_164(), migrate_164_to_165(), migrate_165_to_166(), migrate_166_to_167(), migrate_167_to_168(), migrate_168_to_169(), migrate_169_to_170(), migrate_16_to_17(), migrate_170_to_171(), migrate_171_to_172(), migrate_172_to_173(), migrate_173_to_174(), migrate_174_to_175(), migrate_175_to_176(), migrate_176_to_177(), migrate_177_to_178(), migrate_178_to_179(), migrate_179_to_180(), migrate_17_to_18(), migrate_180_to_181(), migrate_181_to_182(), migrate_182_to_183(), migrate_183_to_184(), migrate_18_to_19(), migrate_19_to_20(), migrate_1_to_2(), migrate_20_to_21(), migrate_21_to_22(), migrate_22_to_23(), migrate_23_to_24(), migrate_24_to_25(), migrate_25_to_26(), migrate_26_to_27(), migrate_27_to_28(), migrate_28_to_29(), migrate_29_to_30(), migrate_2_to_3(), migrate_30_to_31(), migrate_31_to_32(), migrate_32_to_33(), migrate_33_to_34(), migrate_34_to_35(), migrate_35_to_36(), migrate_36_to_37(), migrate_37_to_38(), migrate_38_to_39(), migrate_39_to_40(), migrate_3_to_4(), migrate_40_to_41(), migrate_41_to_42(), migrate_42_to_43(), migrate_43_to_44(), migrate_44_to_45(), migrate_45_to_46(), migrate_46_to_47(), migrate_47_to_48(), migrate_48_to_49(), migrate_49_to_50(), migrate_4_to_5(), migrate_50_to_51(), migrate_51_to_52(), migrate_52_to_53(), migrate_53_to_54(), migrate_54_to_55(), migrate_55_to_56(), migrate_56_to_57(), migrate_57_to_58(), migrate_58_to_59(), migrate_59_to_60(), migrate_5_to_6(), migrate_60_to_61(), migrate_61_to_62(), migrate_62_to_63(), migrate_63_to_64(), migrate_64_to_65(), migrate_65_to_66(), migrate_66_to_67(), migrate_67_to_68(), migrate_68_to_69(), migrate_69_to_70(), migrate_6_to_7(), migrate_70_to_71(), migrate_71_to_72(), migrate_72_to_73(), migrate_73_to_74(), migrate_74_to_75(), migrate_75_to_76(), migrate_76_to_77(), migrate_77_to_78(), migrate_78_to_79(), migrate_7_to_8(), migrate_80_to_81(), migrate_81_to_82(), migrate_82_to_83(), migrate_83_to_84(), migrate_84_to_85(), migrate_85_to_86(), migrate_86_to_87(), migrate_87_to_88(), migrate_88_to_89(), migrate_89_to_90(), migrate_8_to_9(), migrate_90_to_91(), migrate_91_to_92(), migrate_92_to_93(), migrate_93_to_94(), migrate_94_to_95(), migrate_95_to_96(), migrate_96_to_97(), migrate_97_to_98(), migrate_98_to_99(), migrate_99_to_100(), migrate_9_to_10(), set_task_requested(), and sql_begin_immediate().
int sql_begin_exclusive_giveup | ( | ) |
Begin an exclusive transaction, giving up on failure.
Definition at line 610 of file sql_pg.c.
References sql_giveup(), sql_int(), and sql_rollback().
Referenced by sql_begin_immediate_giveup().
void sql_begin_immediate | ( | ) |
Begin an immediate transaction.
Begin an immediate transaction.
Definition at line 627 of file sql_pg.c.
References sql(), and sql_begin_exclusive().
Referenced by copy_alert(), copy_resource(), delete_alert(), set_task_alerts(), set_task_groups(), and set_task_observers().
int sql_begin_immediate_giveup | ( | ) |
Begin an immediate transaction.
Begin an immediate transaction.
Definition at line 639 of file sql_pg.c.
References sql_begin_exclusive_giveup(), and sql_giveup().
Referenced by manage_update_nvti_cache().
int sql_bind_blob | ( | sql_stmt_t * | stmt, |
int | position, | ||
const void * | value, | ||
int | value_size | ||
) |
Bind a blob to a statement.
[in] | stmt | Statement. |
[in] | position | Position in statement. |
[in] | value | Blob. |
[in] | value_size | Blob size. |
Definition at line 751 of file sql_pg.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
int sql_bind_double | ( | sql_stmt_t * | stmt, |
int | position, | ||
double * | value | ||
) |
Bind a double value to a statement.
[in] | stmt | Statement. |
[in] | position | Position in statement. |
[in] | value | Value. |
Definition at line 787 of file sql_pg.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
int sql_bind_int64 | ( | sql_stmt_t * | stmt, |
int | position, | ||
long long int * | value | ||
) |
Bind an int64 value to a statement.
[in] | stmt | Statement. |
[in] | position | Position in statement. |
[in] | value | Value. |
Definition at line 768 of file sql_pg.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
int sql_bind_text | ( | sql_stmt_t * | stmt, |
int | position, | ||
const gchar * | value, | ||
gsize | value_size | ||
) |
Bind a text value to a statement.
[in] | stmt | Statement. |
[in] | position | Position in statement. |
[in] | value | Value. |
[in] | value_size | Value size, or -1 to use strlen of value. |
Definition at line 807 of file sql_pg.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
Referenced by migrate_19_to_20().
int sql_cancel_internal | ( | ) |
Cancels the current SQL statement.
Definition at line 961 of file sql_pg.c.
References conn, log_errors, and task_db.
int sql_changes | ( | ) |
Return 0.
Return 0.
Definition at line 385 of file sql_pg.c.
References task_db.
Referenced by migrate_118_to_119().
void sql_close | ( | ) |
Close the database.
Definition at line 363 of file sql_pg.c.
Referenced by manage_cleanup_process_error().
void sql_close_fork | ( | ) |
double sql_column_double | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as a double from a prepared statement.
It's up to the caller to ensure that there is a row available.
[in] | stmt | Statement. |
[in] | position | Column position. |
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 868 of file sql_pg.c.
References sql_stmt::current_row, sql_stmt::result, and sql_stmt::stmt.
Referenced by aggregate_iterator_max(), aggregate_iterator_mean(), aggregate_iterator_min(), aggregate_iterator_sum(), iterator_double(), and sql_double().
int sql_column_int | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as an integer from a prepared statement.
It's up to the caller to ensure that there is a row available.
[in] | stmt | Statement. |
[in] | position | Column position. |
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 906 of file sql_pg.c.
References sql_stmt::current_row, sql_stmt::result, and sql_stmt::stmt.
Referenced by aggregate_iterator_count(), iterator_int(), and sql_int().
long long int sql_column_int64 | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as an int64 from a prepared statement.
It's up to the caller to ensure that there is a row available.
[in] | stmt | Statement. |
[in] | position | Column position. |
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 936 of file sql_pg.c.
References sql_stmt::current_row, sql_stmt::result, and sql_stmt::stmt.
Referenced by iterator_int64(), sql_int64(), and sqli().
const char* sql_column_text | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as text from a prepared statement.
It's up to the caller to ensure that there is a row available.
[in] | stmt | Statement. |
[in] | position | Column position. |
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 887 of file sql_pg.c.
References sql_stmt::current_row, sql_stmt::result, and sql_stmt::stmt.
Referenced by aggregate_iterator_subgroup_value(), aggregate_iterator_text(), aggregate_iterator_value(), iterator_string(), and sql_string().
void sql_commit | ( | ) |
Commit a transaction.
Definition at line 649 of file sql_pg.c.
References sql().
Referenced by migrate_0_to_1(), migrate_100_to_101(), migrate_101_to_102(), migrate_102_to_103(), migrate_103_to_104(), migrate_104_to_105(), migrate_105_to_106(), migrate_106_to_107(), migrate_107_to_108(), migrate_108_to_109(), migrate_109_to_110(), migrate_10_to_11(), migrate_110_to_111(), migrate_111_to_112(), migrate_112_to_113(), migrate_113_to_114(), migrate_114_to_115(), migrate_115_to_116(), migrate_116_to_117(), migrate_117_to_118(), migrate_118_to_119(), migrate_119_to_120(), migrate_11_to_12(), migrate_120_to_121(), migrate_121_to_122(), migrate_122_to_123(), migrate_123_to_124(), migrate_124_to_125(), migrate_125_to_126(), migrate_126_to_127(), migrate_127_to_128(), migrate_128_to_129(), migrate_129_to_130(), migrate_12_to_13(), migrate_130_to_131(), migrate_131_to_132(), migrate_132_to_133(), migrate_133_to_134(), migrate_134_to_135(), migrate_135_to_136(), migrate_136_to_137(), migrate_137_to_138(), migrate_138_to_139(), migrate_139_to_140(), migrate_13_to_14(), migrate_140_to_141(), migrate_141_to_142(), migrate_142_to_143(), migrate_143_to_144(), migrate_144_to_145(), migrate_145_to_146(), migrate_146_to_147(), migrate_147_to_148(), migrate_148_to_149(), migrate_149_to_150(), migrate_14_to_15(), migrate_150_to_151(), migrate_151_to_152(), migrate_152_to_153(), migrate_153_to_154(), migrate_154_to_155(), migrate_155_to_156(), migrate_156_to_157(), migrate_157_to_158(), migrate_158_to_159(), migrate_159_to_160(), migrate_15_to_16(), migrate_160_to_161(), migrate_161_to_162(), migrate_162_to_163(), migrate_163_to_164(), migrate_164_to_165(), migrate_165_to_166(), migrate_167_to_168(), migrate_16_to_17(), migrate_170_to_171(), migrate_171_to_172(), migrate_172_to_173(), migrate_173_to_174(), migrate_174_to_175(), migrate_175_to_176(), migrate_176_to_177(), migrate_177_to_178(), migrate_178_to_179(), migrate_179_to_180(), migrate_17_to_18(), migrate_180_to_181(), migrate_181_to_182(), migrate_182_to_183(), migrate_183_to_184(), migrate_18_to_19(), migrate_19_to_20(), migrate_1_to_2(), migrate_20_to_21(), migrate_21_to_22(), migrate_22_to_23(), migrate_23_to_24(), migrate_25_to_26(), migrate_26_to_27(), migrate_27_to_28(), migrate_28_to_29(), migrate_29_to_30(), migrate_2_to_3(), migrate_30_to_31(), migrate_31_to_32(), migrate_32_to_33(), migrate_33_to_34(), migrate_34_to_35(), migrate_35_to_36(), migrate_36_to_37(), migrate_37_to_38(), migrate_38_to_39(), migrate_39_to_40(), migrate_3_to_4(), migrate_40_to_41(), migrate_41_to_42(), migrate_42_to_43(), migrate_43_to_44(), migrate_44_to_45(), migrate_45_to_46(), migrate_46_to_47(), migrate_47_to_48(), migrate_48_to_49(), migrate_49_to_50(), migrate_50_to_51(), migrate_51_to_52(), migrate_52_to_53(), migrate_53_to_54(), migrate_54_to_55(), migrate_55_to_56(), migrate_56_to_57(), migrate_57_to_58(), migrate_58_to_59(), migrate_59_to_60(), migrate_60_to_61(), migrate_61_to_62(), migrate_62_to_63(), migrate_63_to_64(), migrate_64_to_65(), migrate_65_to_66(), migrate_66_to_67(), migrate_67_to_68(), migrate_68_to_69(), migrate_69_to_70(), migrate_6_to_7(), migrate_70_to_71(), migrate_71_to_72(), migrate_72_to_73(), migrate_73_to_74(), migrate_74_to_75(), migrate_75_to_76(), migrate_76_to_77(), migrate_77_to_78(), migrate_78_to_79(), migrate_7_to_8(), migrate_80_to_81(), migrate_81_to_82(), migrate_82_to_83(), migrate_83_to_84(), migrate_84_to_85(), migrate_85_to_86(), migrate_86_to_87(), migrate_87_to_88(), migrate_88_to_89(), migrate_89_to_90(), migrate_8_to_9(), migrate_90_to_91(), migrate_91_to_92(), migrate_92_to_93(), migrate_93_to_94(), migrate_94_to_95(), migrate_95_to_96(), migrate_96_to_97(), migrate_97_to_98(), migrate_98_to_99(), migrate_99_to_100(), migrate_9_to_10(), set_task_alerts(), set_task_groups(), and set_task_requested().
const char* sql_database | ( | ) |
Return name of current database.
Return name of current database.
Definition at line 226 of file sql_pg.c.
References conn.
Referenced by manage_cert_loaded(), manage_create_sql_functions(), manage_db_empty(), and manage_scap_loaded().
const char* sql_default_database | ( | ) |
double sql_double | ( | char * | sql, |
... | |||
) |
Get the first value from a SQL query, as a double.
row
. The caller must ensure that the query will return sufficient rows.[in] | sql | Format string for SQL query. |
[in] | ... | Arguments for format string. |
Definition at line 404 of file sql.c.
References sql(), sql_column_double(), sql_finalize(), and sql_x().
int sql_error | ( | char * | sql, |
... | |||
) |
Perform an SQL statement, retrying if database is busy or locked.
Return on error, instead of aborting.
[in] | sql | Format string for SQL statement. |
[in] | ... | Arguments for format string. |
Definition at line 229 of file sql.c.
Referenced by manage_attach_databases(), manage_cert_loaded(), and manage_scap_loaded().
int sql_exec | ( | sql_stmt_t * | stmt | ) |
Execute a prepared statement.
[in] | stmt | Statement. |
Definition at line 776 of file sql.c.
References sql_exec_internal().
Referenced by migrate_19_to_20().
void sql_finalize | ( | sql_stmt_t * | stmt | ) |
Free a prepared statement.
[in] | stmt | Statement. |
Definition at line 824 of file sql_pg.c.
References sql_stmt::param_formats, sql_stmt::param_lengths, sql_stmt::param_values, sql_stmt::result, sql_stmt::sql, and sql_stmt::stmt.
Referenced by cleanup_iterator(), migrate_19_to_20(), sql_double(), sql_explain_internal(), sql_int(), sql_int64(), sql_quiet(), sql_string(), sqli(), and sqlv().
int sql_giveup | ( | char * | sql, |
... | |||
) |
Perform an SQL statement, giving up if database is busy or locked.
[in] | sql | Format string for SQL statement. |
[in] | ... | Arguments for format string. |
Definition at line 257 of file sql.c.
Referenced by sql_begin_exclusive_giveup(), and sql_begin_immediate_giveup().
const char* sql_greatest | ( | ) |
const char* sql_ilike_op | ( | ) |
gchar* sql_insert | ( | const char * | string | ) |
Get the SQL insert expression for a string.
[in] | string | The string, which may be NULL. |
Definition at line 136 of file sql.c.
References sql_quote().
Referenced by migrate_12_to_13(), migrate_4_to_5_copy_data(), migrate_9_to_10(), and refresh_nvt_cves().
int sql_int | ( | char * | sql, |
... | |||
) |
Get a particular cell from a SQL query, as an int.
row
. The caller must ensure that the query will return sufficient rows.[in] | sql | Format string for SQL query. |
[in] | ... | Arguments for format string. |
Definition at line 438 of file sql.c.
References sql(), sql_column_int(), sql_finalize(), and sql_x().
Referenced by acl_role_can_super_everyone(), acl_user_can_everything(), acl_user_can_super_everyone(), acl_user_has_access_uuid(), acl_user_has_super(), acl_user_has_super_on(), acl_user_has_super_on_resource(), acl_user_is_admin(), acl_user_is_observer(), acl_user_is_owner(), acl_user_is_user(), acl_user_may(), acl_user_owns(), acl_user_owns_name(), acl_user_owns_trash_uuid(), acl_user_owns_uuid(), alert_in_use(), check_config_host_discovery(), check_config_system_discovery(), manage_cert_loaded(), manage_create_sql_functions(), manage_db_empty(), manage_scap_loaded(), manage_update_nvti_cache(), migrate_128_to_129(), migrate_12_to_13(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_168_to_169(), migrate_177_to_178(), migrate_17_to_18(), migrate_17_to_18_set_pref(), migrate_21_to_22(), migrate_33_to_34_set_pref(), migrate_35_to_36(), migrate_55_to_56_ensure_predefined_port_lists_exist(), migrate_5_to_6(), migrate_5_to_6_move_other_config(), resource_exists(), resource_id_exists(), sql_begin_exclusive_giveup(), sql_last_insert_id(), sql_uniquify(), task_alterable(), task_average_scan_duration(), task_config_in_trash(), task_in_trash(), task_iterator_current_report(), task_result_count(), task_run_status(), task_running_report(), task_scanner_in_trash(), task_schedule_in_trash(), task_schedule_next_time(), task_schedule_next_time_uuid(), task_schedule_periods(), task_schedule_periods_uuid(), task_target_in_trash(), task_writable(), trash_alert_in_use(), trash_id_exists(), trash_task_writable(), user_ensure_in_db(), and user_is_super_admin().
int sql_int64 | ( | long long int * | ret, |
char * | sql, | ||
... | |||
) |
Get a particular cell from a SQL query, as an int64.
[in] | ret | Return value. |
[in] | sql | Format string for SQL query. |
[in] | ... | Arguments for format string. |
Definition at line 501 of file sql.c.
References sql(), sql_column_int64(), sql_finalize(), and sql_x().
Referenced by acl_user_has_access_uuid(), check_db_sequences(), find_resource(), find_resource_by_name_with_permission(), find_resource_with_permission(), migrate_173_to_174(), migrate_177_to_178(), task_config(), task_last_report(), task_last_stopped_report(), task_scanner(), task_schedule(), task_schedule_uuid(), task_severity_double(), and task_target().
int sql_is_open | ( | ) |
Check whether the database is open.
Definition at line 201 of file sql_pg.c.
Referenced by manage_cleanup_process_error().
int sql_is_sqlite3 | ( | ) |
Get whether backend is SQLite3.
Definition at line 92 of file sql_pg.c.
Referenced by migrate_131_to_132(), migrate_132_to_133(), migrate_133_to_134(), migrate_153_to_154(), migrate_155_to_156(), migrate_156_to_157(), migrate_157_to_158(), migrate_158_to_159(), migrate_166_to_167(), migrate_172_to_173(), migrate_180_to_181(), migrate_182_to_183(), and refresh_nvt_cves().
resource_t sql_last_insert_id | ( | ) |
Get the ID of the last inserted row.
Definition at line 395 of file sql_pg.c.
References sql_int(), and task_db.
Referenced by make_config_host_discovery(), make_config_system_discovery(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_35_to_36_duplicate_target(), migrate_55_to_56(), migrate_55_to_56_ensure_predefined_port_lists_exist(), migrate_5_to_6_move_other_config(), and sqli().
gchar* sql_nquote | ( | const char * | string, |
size_t | length | ||
) |
Quotes a string of a known length to be passed to sql statements.
[in] | string | String to quote. |
[in] | length | Size of string . |
Definition at line 76 of file sql.c.
Referenced by sql_quote().
int sql_open | ( | const char * | database | ) |
Open the database.
[in] | database | Database, or NULL for default. |
Definition at line 250 of file sql_pg.c.
sql_stmt_t* sql_prepare | ( | const char * | sql, |
... | |||
) |
Prepare a statement.
[in] | sql | Format string for SQL. |
Definition at line 753 of file sql.c.
References sql(), and sql_prepare_internal().
Referenced by migrate_19_to_20().
void sql_quiet | ( | char * | sql, |
... | |||
) |
Perform an SQL statement, without logging.
[in] | sql | Format string for SQL statement. |
[in] | ... | Arguments for format string. |
Definition at line 275 of file sql.c.
References log_errors, sql(), sql_exec_internal(), sql_finalize(), and sql_prepare_internal().
gchar* sql_quote | ( | const char * | string | ) |
Quotes a string to be passed to sql statements.
[in] | string | String to quote, has to be \0 terminated. |
Definition at line 121 of file sql.c.
References sql_nquote().
Referenced by acl_role_can_super_everyone(), acl_user_can_everything(), acl_user_can_super_everyone(), acl_user_has_access_uuid(), acl_user_has_super(), acl_user_has_super_on(), acl_user_is_admin(), acl_user_is_observer(), acl_user_is_user(), acl_user_may(), acl_user_owns_name(), acl_user_owns_trash_uuid(), acl_user_owns_uuid(), acl_where_owned_user(), alert_data(), find_resource(), find_resource_by_name_with_permission(), find_resource_with_permission(), manage_user_hash(), migrate_129_to_130(), migrate_138_to_139(), migrate_143_to_144(), migrate_156_to_157(), migrate_158_to_159(), migrate_160_to_161(), migrate_165_to_166(), migrate_35_to_36(), migrate_35_to_36_duplicate_target(), migrate_3_to_4(), migrate_55_to_56(), migrate_5_to_6_move_other_config(), set_task_hosts_ordering(), set_task_schedule_next_time_uuid(), set_task_schedule_periods(), set_task_schedule_uuid(), sql_cpe_title(), sql_credential_value(), sql_insert(), sql_uniquify(), task_schedule_next_time_uuid(), task_schedule_periods_uuid(), task_schedule_uuid(), user_ensure_in_db(), user_is_super_admin(), and user_uuid_method().
const char* sql_regexp_op | ( | ) |
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.
[in] | old_table | Existing table. |
[in] | new_table | New empty table with renamed column. |
[in] | old_name | Name of column in old table. |
[in] | new_name | Name of column in new table. |
Definition at line 101 of file manage_pg.c.
References cleanup_iterator(), init_iterator(), iterator_column_count(), iterator_column_name(), next(), and sql().
Referenced by migrate_56_to_57().
int sql_reset | ( | sql_stmt_t * | stmt | ) |
Reset a prepared statement.
[in] | stmt | Statement. |
Definition at line 842 of file sql_pg.c.
References openvas_usleep(), sql_stmt::param_formats, sql_stmt::param_lengths, sql_stmt::param_values, sql_stmt::result, sql_stmt::sql, sql(), sql_stmt::stmt, and task_db.
void sql_rollback | ( | ) |
Roll a transaction back.
Definition at line 658 of file sql_pg.c.
References sql().
Referenced by delete_alert(), migrate_0_to_1(), migrate_100_to_101(), migrate_101_to_102(), migrate_102_to_103(), migrate_103_to_104(), migrate_104_to_105(), migrate_105_to_106(), migrate_106_to_107(), migrate_107_to_108(), migrate_108_to_109(), migrate_109_to_110(), migrate_10_to_11(), migrate_110_to_111(), migrate_111_to_112(), migrate_112_to_113(), migrate_113_to_114(), migrate_114_to_115(), migrate_115_to_116(), migrate_116_to_117(), migrate_117_to_118(), migrate_118_to_119(), migrate_119_to_120(), migrate_11_to_12(), migrate_120_to_121(), migrate_121_to_122(), migrate_122_to_123(), migrate_123_to_124(), migrate_124_to_125(), migrate_125_to_126(), migrate_126_to_127(), migrate_127_to_128(), migrate_128_to_129(), migrate_129_to_130(), migrate_12_to_13(), migrate_130_to_131(), migrate_131_to_132(), migrate_132_to_133(), migrate_133_to_134(), migrate_134_to_135(), migrate_135_to_136(), migrate_136_to_137(), migrate_137_to_138(), migrate_138_to_139(), migrate_139_to_140(), migrate_13_to_14(), migrate_140_to_141(), migrate_141_to_142(), migrate_142_to_143(), migrate_143_to_144(), migrate_144_to_145(), migrate_145_to_146(), migrate_146_to_147(), migrate_147_to_148(), migrate_148_to_149(), migrate_149_to_150(), migrate_14_to_15(), migrate_150_to_151(), migrate_151_to_152(), migrate_152_to_153(), migrate_153_to_154(), migrate_154_to_155(), migrate_155_to_156(), migrate_156_to_157(), migrate_157_to_158(), migrate_158_to_159(), migrate_159_to_160(), migrate_15_to_16(), migrate_160_to_161(), migrate_161_to_162(), migrate_162_to_163(), migrate_163_to_164(), migrate_164_to_165(), migrate_165_to_166(), migrate_166_to_167(), migrate_167_to_168(), migrate_168_to_169(), migrate_169_to_170(), migrate_16_to_17(), migrate_170_to_171(), migrate_171_to_172(), migrate_172_to_173(), migrate_173_to_174(), migrate_174_to_175(), migrate_175_to_176(), migrate_176_to_177(), migrate_177_to_178(), migrate_178_to_179(), migrate_179_to_180(), migrate_17_to_18(), migrate_180_to_181(), migrate_181_to_182(), migrate_182_to_183(), migrate_183_to_184(), migrate_18_to_19(), migrate_19_to_20(), migrate_1_to_2(), migrate_20_to_21(), migrate_21_to_22(), migrate_22_to_23(), migrate_23_to_24(), migrate_24_to_25(), migrate_25_to_26(), migrate_26_to_27(), migrate_27_to_28(), migrate_28_to_29(), migrate_29_to_30(), migrate_2_to_3(), migrate_30_to_31(), migrate_31_to_32(), migrate_32_to_33(), migrate_33_to_34(), migrate_34_to_35(), migrate_35_to_36(), migrate_36_to_37(), migrate_37_to_38(), migrate_38_to_39(), migrate_39_to_40(), migrate_3_to_4(), migrate_40_to_41(), migrate_41_to_42(), migrate_42_to_43(), migrate_43_to_44(), migrate_44_to_45(), migrate_45_to_46(), migrate_46_to_47(), migrate_47_to_48(), migrate_48_to_49(), migrate_49_to_50(), migrate_4_to_5(), migrate_50_to_51(), migrate_51_to_52(), migrate_52_to_53(), migrate_53_to_54(), migrate_54_to_55(), migrate_55_to_56(), migrate_56_to_57(), migrate_57_to_58(), migrate_58_to_59(), migrate_59_to_60(), migrate_5_to_6(), migrate_5_to_6_move_other_config(), migrate_60_to_61(), migrate_61_to_62(), migrate_62_to_63(), migrate_63_to_64(), migrate_64_to_65(), migrate_65_to_66(), migrate_66_to_67(), migrate_67_to_68(), migrate_68_to_69(), migrate_69_to_70(), migrate_6_to_7(), migrate_70_to_71(), migrate_71_to_72(), migrate_72_to_73(), migrate_73_to_74(), migrate_74_to_75(), migrate_75_to_76(), migrate_76_to_77(), migrate_77_to_78(), migrate_78_to_79(), migrate_7_to_8(), migrate_80_to_81(), migrate_81_to_82(), migrate_82_to_83(), migrate_83_to_84(), migrate_84_to_85(), migrate_85_to_86(), migrate_86_to_87(), migrate_87_to_88(), migrate_88_to_89(), migrate_89_to_90(), migrate_8_to_9(), migrate_90_to_91(), migrate_91_to_92(), migrate_92_to_93(), migrate_93_to_94(), migrate_94_to_95(), migrate_95_to_96(), migrate_96_to_97(), migrate_97_to_98(), migrate_98_to_99(), migrate_99_to_100(), migrate_9_to_10(), set_task_alerts(), set_task_groups(), set_task_observers(), and sql_begin_exclusive_giveup().
const char* sql_schema | ( | ) |
Get main schema name.
Definition at line 103 of file sql_pg.c.
Referenced by check_db_versions(), manage_db_version(), manage_update_nvti_cache(), migrate_75_to_76(), and set_db_version().
const char* sql_select_limit | ( | int | max | ) |
Setup a LIMIT argument.
[in] | max | Max. |
Definition at line 127 of file sql_pg.c.
Referenced by init_aggregate_iterator().
char* sql_string | ( | char * | sql, |
... | |||
) |
Get a particular cell from a SQL query, as an string.
[in] | sql | Format string for SQL query. |
[in] | ... | Arguments for format string. |
Definition at line 469 of file sql.c.
References sql(), sql_column_text(), sql_finalize(), and sql_x().
Referenced by alert_data(), alert_filter_id(), alert_name(), alert_owner_uuid(), alert_uuid(), check_db_versions(), find_resource_by_name_with_permission(), manage_cert_db_version(), manage_db_version(), manage_port_name(), manage_scap_db_version(), manage_user_hash(), migrate_165_to_166(), migrate_168_to_169(), migrate_21_to_22(), migrate_35_to_36(), migrate_5_to_6_move_other_config(), resource_name(), resource_uuid(), sql_cpe_title(), sql_credential_value(), task_comment(), task_config_name(), task_config_uuid(), task_hosts_ordering(), task_name(), task_owner_name(), task_second_last_report_id(), task_uuid(), and user_uuid_method().
void sqli | ( | resource_t * | resource, |
char * | sql, | ||
... | |||
) |
Perform an SQL statement, retrying if database is busy or locked.
[out] | resource | Last inserted resource. |
[in] | sql | Format string for SQL statement. |
[in] | ... | Arguments for format string. |
Definition at line 408 of file sql_pg.c.
References sql(), sql_column_int64(), sql_finalize(), sql_last_insert_id(), sql_x(), and sqlv().