OpenVAS Manager
7.0.3~git
|
Go to the source code of this file.
Macros | |
#define | G_LOG_DOMAIN "md manage" |
GLib log domain. More... | |
Functions | |
int | sql_prepare_internal (int, int, const char *, va_list, sql_stmt_t **) |
Prepare a statement. More... | |
int | sql_exec_internal (int, sql_stmt_t *) |
Execute a prepared statement. More... | |
int | sql_explain_internal (const char *, va_list) |
Write debug messages with the query plan for an SQL query to the log. More... | |
int | sql_explain (const char *sql,...) |
Write debug messages with the query plan for an SQL query to the log. More... | |
gchar * | sql_nquote (const char *string, size_t length) |
Quotes a string of a known length to be passed to sql statements. More... | |
gchar * | sql_quote (const char *string) |
Quotes a string to be passed to sql statements. More... | |
gchar * | sql_insert (const char *string) |
Get the SQL insert expression for a string. More... | |
int | sqlv (int retry, char *sql, va_list args) |
Perform an SQL statement. More... | |
void | sql (char *sql,...) |
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... | |
int | sql_x (char *sql, va_list args, sql_stmt_t **stmt_return) |
Get a particular cell from a SQL query. More... | |
double | sql_double (char *sql,...) |
Get the first value from a SQL query, as a double. More... | |
int | sql_int (char *sql,...) |
Get a particular cell from a SQL query, as an int. More... | |
char * | sql_string (char *sql,...) |
Get a particular cell from a SQL query, as an string. More... | |
int | sql_int64 (long long int *ret, char *sql,...) |
Get a particular cell from a SQL query, as an int64. More... | |
void | init_prepared_iterator (iterator_t *iterator, sql_stmt_t *stmt) |
Initialise an iterator. More... | |
void | init_iterator (iterator_t *iterator, const char *sql,...) |
Initialise an iterator. More... | |
double | iterator_double (iterator_t *iterator, int col) |
Get a double column from an iterator. More... | |
int | iterator_int (iterator_t *iterator, int col) |
Get a int column from an iterator. More... | |
long long int | iterator_int64 (iterator_t *iterator, int col) |
Get an integer column from an iterator. More... | |
const char * | iterator_string (iterator_t *iterator, int col) |
Get a string column from an iterator. More... | |
void | cleanup_iterator (iterator_t *iterator) |
Cleanup an iterator. More... | |
gboolean | next (iterator_t *iterator) |
Increment an iterator. More... | |
sql_stmt_t * | sql_prepare (const char *sql,...) |
Prepare a statement. More... | |
int | sql_exec (sql_stmt_t *stmt) |
Execute a prepared statement. More... | |
Variables | |
int | log_errors = 1 |
Whether to log errors. More... | |
void cleanup_iterator | ( | iterator_t * | iterator | ) |
Cleanup an iterator.
[in] | iterator | Iterator. |
Definition at line 664 of file sql.c.
References iterator::crypt_ctx, lsc_crypt_release(), iterator::prepared, sql_finalize(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), check_db_sequences(), check_generate_scripts(), delete_reports(), get_nvti_xml(), get_ovaldi_files(), migrate_122_to_123(), migrate_12_to_13(), 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_35_to_36(), migrate_3_to_4(), migrate_4_to_5_copy_data(), migrate_55_to_56(), migrate_9_to_10(), refresh_nvt_cves(), sql_rename_column(), and task_observers().
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.
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().
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().
gboolean next | ( | iterator_t * | iterator | ) |
Increment an iterator.
[in] | iterator | Iterator. |
Definition at line 689 of file sql.c.
References iterator::crypt_ctx, iterator::done, log_errors, lsc_crypt_flush(), sql_exec_internal(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), buffer_aggregate_xml(), check_db_sequences(), check_generate_scripts(), get_nvti_xml(), get_ovaldi_files(), manage_schedule(), 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_3_to_4(), migrate_4_to_5_copy_data(), migrate_55_to_56(), migrate_9_to_10(), refresh_nvt_cves(), sql_rename_column(), stop_active_tasks(), and task_observers().
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().
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().
int sql_exec_internal | ( | int | retry, |
sql_stmt_t * | stmt | ||
) |
Execute a prepared statement.
[in] | retry | Whether to keep retrying while database is busy or locked. |
[in] | stmt | Statement. |
[in] | retry | Whether to keep retrying while database is busy or locked. |
[in] | stmt | Statement. |
Definition at line 482 of file sql_pg.c.
References BUSY_TIMEOUT, conn, sql_stmt::current_row, sql_stmt::executed, log_errors, openvas_usleep(), sql_stmt::param_formats, sql_stmt::param_lengths, sql_stmt::param_values, sql_stmt::result, sql_stmt::sql, sql_stmt::stmt, and task_db.
Referenced by next(), sql_exec(), sql_explain_internal(), sql_quiet(), and sqlv().
int sql_explain | ( | const char * | sql, |
... | |||
) |
Write debug messages with the query plan for an SQL query to the log.
[in] | sql | Format string for the SQL query. |
[in] | ... | Format string arguments. |
Definition at line 540 of file sql.c.
References sql(), and sql_explain_internal().
int sql_explain_internal | ( | const char * | sql, |
va_list | args | ||
) |
Write debug messages with the query plan for an SQL query to the log.
[in] | sql | Format string for the SQL query. |
[in] | args | Format string arguments in a va_list. |
Definition at line 551 of file sql_pg.c.
References sql_stmt::current_row, log_errors, sql_stmt::result, sql(), sql_exec_internal(), sql_finalize(), sql_prepare_internal(), and sql_stmt::stmt.
Referenced by sql_explain().
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().
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().
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().
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().
int sql_prepare_internal | ( | int | retry, |
int | log, | ||
const char * | sql, | ||
va_list | args, | ||
sql_stmt_t ** | stmt | ||
) |
Prepare a statement.
[in] | retry | Whether to keep retrying while database is busy or locked. |
[in] | log | Whether to keep retrying while database is busy or locked. |
[in] | sql | Format string for SQL statement. |
[in] | args | Arguments for format string. |
[out] | stmt | Statement return. |
Definition at line 458 of file sql_pg.c.
References BUSY_TIMEOUT, openvas_usleep(), sql(), and task_db.
Referenced by init_iterator(), sql_explain_internal(), sql_prepare(), sql_quiet(), and sqlv().
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().
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().
int sql_x | ( | char * | sql, |
va_list | args, | ||
sql_stmt_t ** | stmt_return | ||
) |
Get a particular cell from a SQL query.
Do logging as usual.
[in] | sql | Format string for SQL query. |
[in] | args | Arguments for format string. |
[out] | stmt_return | Return from statement. |
Definition at line 385 of file sql.c.
Referenced by sql_double(), sql_int(), sql_int64(), sql_string(), and sqli().
int sqlv | ( | int | retry, |
char * | sql, | ||
va_list | args | ||
) |
Perform an SQL statement.
[in] | retry | Whether to keep retrying while database is busy or locked. |
[in] | sql | Format string for SQL statement. |
[in] | args | Arguments for format string. |
Definition at line 158 of file sql.c.
References log_errors, sql(), sql_exec_internal(), sql_finalize(), and sql_prepare_internal().
Referenced by sql(), sql_error(), sql_giveup(), and sqli().
int log_errors = 1 |
Whether to log errors.
Used to turn off logging when cancelling statements on exit.
Definition at line 62 of file sql.c.
Referenced by next(), sql_cancel_internal(), sql_exec_internal(), sql_explain_internal(), sql_quiet(), and sqlv().