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(), auto_delete_reports(), check_db_sequences(), check_generate_scripts(), cleanup_task_schedule_iterator(), delete_reports(), get_nvti_xml(), get_ovaldi_files(), host_routes_xml(), manage_get_scanners(), 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(), ovaldef_cves(), refresh_nvt_cves(), report_add_result(), report_cache_counts(), report_severity(), reports_add_all(), reports_add_for_override(), reports_build_count_cache(), schedule_info(), sql_rename_column(), target_port_range(), task_observers(), and user_resources_in_use().
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_prepare_internal(), and iterator::stmt.
Referenced by acl_users_with_access_sql(), auto_delete_reports(), check_db_sequences(), check_generate_scripts(), host_routes_xml(), init_aggregate_iterator(), init_alert_data_iterator(), init_alert_task_iterator(), init_config_task_iterator(), init_config_timeout_iterator(), init_cpe_cve_iterator(), init_credential_scanner_iterator(), init_credential_target_iterator(), init_cve_nvt_iterator(), init_family_iterator(), init_filter_alert_iterator(), init_host_detail_iterator(), init_host_identifier_iterator(), init_nvt_preference_iterator(), init_nvt_selector_iterator(), init_os_host_iterator(), init_otp_pref_iterator(), init_ovaldi_file_iterator(), init_param_option_iterator(), init_port_list_target_iterator(), init_port_range_iterator(), init_preference_iterator(), init_report_counts_build_iterator(), init_report_errors_iterator(), init_report_format_alert_iterator(), init_report_format_param_iterator(), init_report_host_iterator(), init_report_iterator_task(), init_resource_tag_iterator(), init_scanner_task_iterator(), init_schedule_task_iterator(), init_target_task_iterator(), init_task_file_iterator(), init_task_group_iterator(), init_task_role_iterator(), init_task_schedule_iterator(), init_task_user_iterator(), init_user_group_iterator(), init_user_role_iterator(), manage_get_scanners(), 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(), ovaldef_cves(), refresh_nvt_cves(), report_severity(), reports_add_all(), reports_add_for_override(), reports_build_count_cache(), schedule_info(), sql_rename_column(), and user_resources_in_use().
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.
Referenced by init_prognosis_iterator().
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.
Referenced by prognosis_iterator_cvss_double(), report_severity(), result_iterator_level(), result_iterator_original_level(), and result_iterator_severity_double().
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 agent_iterator_trust(), agent_iterator_trust_time(), 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(), asset_os_iterator_installs(), config_iterator_families_growing(), config_iterator_family_count(), config_iterator_nvt_count(), config_iterator_nvts_growing(), config_iterator_type(), config_task_iterator_readable(), credential_iterator_allow_insecure(), credential_scanner_iterator_readable(), credential_target_iterator_readable(), filter_alert_iterator_readable(), host_identifier_iterator_source_orphan(), host_iterator_current_port(), host_iterator_max_port(), host_routes_xml(), migrate_153_to_154(), migrate_160_to_161(), migrate_165_to_166(), note_iterator_active(), note_iterator_end_time(), nvt_iterator_category(), nvt_selector_iterator_include(), nvt_selector_iterator_type(), override_iterator_active(), override_iterator_end_time(), port_list_iterator_count_all(), port_list_iterator_count_tcp(), port_list_iterator_count_udp(), port_list_target_iterator_readable(), port_range_iterator_type(), port_range_iterator_type_int(), report_counts_build_iterator_min_qod(), report_counts_build_iterator_override(), report_format_alert_iterator_readable(), report_format_iterator_trust(), report_format_iterator_trust_time(), report_format_param_iterator_type(), report_format_param_iterator_type_name(), result_iterator_level(), result_iterator_severity(), result_iterator_severity_double(), result_iterator_type(), scanner_iterator_credential_trash(), scanner_iterator_port(), scanner_iterator_type(), scanner_task_iterator_readable(), schedule_info(), schedule_iterator_duration(), schedule_iterator_first_time(), schedule_iterator_initial_offset(), schedule_iterator_next_time(), schedule_iterator_period(), schedule_iterator_period_months(), schedule_task_iterator_readable(), tag_iterator_active(), tag_iterator_orphan(), tag_iterator_resource_location(), target_iterator_alive_tests(), target_iterator_esxi_credential(), target_iterator_esxi_trash(), target_iterator_port_list_trash(), target_iterator_smb_credential(), target_iterator_smb_trash(), target_iterator_snmp_credential(), target_iterator_snmp_trash(), target_iterator_ssh_credential(), target_iterator_ssh_trash(), target_task_iterator_readable(), task_iterator_finished_reports(), task_iterator_run_status(), task_iterator_total_reports(), user_group_iterator_readable(), user_iterator_hosts_allow(), user_iterator_ifaces_allow(), and user_role_iterator_readable().
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(), asset_iterator_in_use(), asset_iterator_writable(), auto_delete_reports(), check_generate_scripts(), get_iterator_owner(), get_iterator_resource(), host_routes_xml(), 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(), next_report(), note_iterator_result(), note_iterator_task(), override_iterator_result(), override_iterator_task(), permission_iterator_resource_in_trash(), permission_iterator_resource_orphan(), permission_iterator_subject_in_trash(), refresh_nvt_cves(), report_counts_build_iterator_user(), report_errors_iterator_result(), report_format_iterator_active(), report_format_param_iterator_param(), report_format_param_iterator_type_max(), report_format_param_iterator_type_min(), reports_add_all(), reports_add_for_override(), reports_build_count_cache(), result_iterator_report(), result_iterator_result(), result_iterator_task(), scanner_iterator_credential(), task_alert_iterator_alert(), task_iterator_scanner(), task_schedule_iterator_duration(), task_schedule_iterator_first_time(), task_schedule_iterator_initial_offset(), task_schedule_iterator_next_time(), task_schedule_iterator_period(), task_schedule_iterator_period_months(), task_schedule_iterator_schedule(), task_schedule_iterator_task(), and user_resources_in_use().
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(), auto_delete_reports(), check_db_sequences(), check_generate_scripts(), filter_iterator_type(), get_iterator_comment(), host_routes_xml(), manage_get_scanners(), 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(), note_iterator_threat(), nvt_preference_iterator_config_value(), nvt_preference_iterator_nvt(), nvt_preference_iterator_real_name(), nvt_preference_iterator_type(), ovaldef_cves(), override_iterator_new_threat(), override_iterator_threat(), port_range_iterator_comment(), refresh_nvt_cves(), report_severity(), result_iterator_original_severity(), result_iterator_scan_nvt_version(), result_iterator_severity(), result_iterator_type(), scanner_iterator_key_priv(), 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(), auto_delete_reports(), buffer_aggregate_xml(), check_db_sequences(), check_generate_scripts(), create_asset_report(), get_nvti_xml(), get_ovaldi_files(), host_routes_xml(), manage_get_scanners(), manage_schedule(), manage_set_config_nvts(), 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(), next_report(), ovaldef_cves(), refresh_nvt_cves(), report_add_result(), report_cache_counts(), report_severity(), reports_add_all(), reports_add_for_override(), reports_build_count_cache(), schedule_info(), sql_rename_column(), stop_active_tasks(), target_port_range(), task_observers(), user_resources_in_use(), verify_agent(), and verify_scanner().
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.
References sqlv().
Referenced by add_role_permission(), add_task_alert(), check_config_discovery(), check_config_host_discovery(), check_config_system_discovery(), check_db_sequences(), cleanup_schedule_times(), cleanup_tables(), clear_duration_schedules(), copy_credential(), copy_target(), create_asset_host(), create_asset_report(), create_port_list_lock(), create_port_range(), create_tables(), create_tag(), delete_asset(), delete_port_range(), delete_report_assets(), delete_report_internal(), delete_task(), host_notice(), hosts_set_details(), hosts_set_identifiers(), hosts_set_max_severity(), init_nvt_iterator(), init_nvt_selector_iterator(), init_preference_iterator(), init_task_file_iterator(), init_user_config_iterator(), insert_port_range(), insert_report_host_detail(), make_config_discovery(), make_config_host_discovery(), make_config_system_discovery(), make_cve_result(), make_nvt_from_nvti(), make_osp_result(), make_report(), make_result(), manage_attach_databases(), manage_complete_nvt_cache_update(), manage_create_scanner(), manage_create_sql_functions(), manage_empty_trashcan(), manage_modify_scanner(), manage_nvt_preference_add(), manage_nvt_preferences_enable(), manage_report_host_add(), manage_session_init(), manage_session_set_timezone(), manage_set_config_comment(), manage_set_config_nvts(), manage_set_ldap_info(), manage_set_radius_info(), manage_task_remove_file(), manage_task_update_file(), 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(), modify_asset(), modify_report(), modify_tag(), permissions_set_locations(), permissions_set_orphans(), permissions_set_subjects(), refresh_nvt_cves(), report_add_result(), report_cache_counts(), report_clear_count_cache(), report_host_set_end_time(), report_set_slave_host(), report_set_slave_name(), report_set_slave_port(), report_set_slave_uuid(), report_set_source_iface(), reports_clear_count_cache(), request_delete_task_uuid(), reset_task(), set_credential_auth_algorithm(), set_credential_certificate(), set_credential_comment(), set_credential_data(), set_credential_login(), set_credential_name(), set_credential_password(), set_credential_privacy_algorithm(), set_credential_private_key(), set_credential_snmp_secret(), set_db_version(), set_nvts_feed_version(), set_password(), set_report_format_active(), set_report_format_name(), set_report_format_summary(), set_report_scan_run_status(), set_report_scheduled(), set_report_slave_progress(), set_report_slave_task_uuid(), set_scan_end_time(), set_scan_end_time_epoch(), set_scan_end_time_otp(), set_scan_host_end_time(), set_scan_host_end_time_otp(), set_scan_host_start_time(), set_scan_host_start_time_otp(), set_scan_ports(), set_scan_start_time(), set_scan_start_time_epoch(), set_scan_start_time_otp(), set_task_alerts(), set_task_alterable(), set_task_config(), set_task_end_time(), set_task_end_time_epoch(), set_task_groups(), set_task_hosts_ordering(), set_task_observers(), set_task_parameter(), set_task_preferences(), 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_rename_column(), tags_set_locations(), tags_set_orphans(), trim_partial_report(), trim_report(), update_duration_schedule_periods(), 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_column_double(), sql_finalize(), and sql_x().
Referenced by cpe_highest_cvss(), and report_add_result().
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.
References sqlv().
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_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_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.
References sqlv().
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 create_tag(), migrate_12_to_13(), migrate_4_to_5_copy_data(), migrate_9_to_10(), modify_tag(), 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_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(), config_families_growing(), config_in_use(), config_nvts_growing(), create_note(), create_override(), create_port_list(), create_port_range(), credential_in_use(), delete_asset(), delete_port_range(), delete_report_internal(), delete_task_lock(), family_count(), family_nvt_count(), filter_in_use(), host_notice(), manage_cert_loaded(), manage_create_scanner(), manage_create_sql_functions(), manage_db_empty(), manage_modify_scanner(), manage_report_host_details(), manage_scap_loaded(), manage_set_config_families(), manage_set_config_nvts(), manage_task_remove_file(), manage_task_update_file(), 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(), modify_scanner(), nvt_preference_count(), nvt_selector_family_count(), nvt_selector_family_growing(), nvt_selector_nvt_count(), permission_is_predefined(), port_list_in_use(), port_list_is_predefined(), port_range_port_list_uuid(), report_add_result(), report_format_in_use(), report_format_owner_uuid(), report_format_trust(), report_host_count(), report_host_dead(), report_host_result_count(), report_result_host_count(), report_scan_run_status(), report_slave_port_int(), report_slave_progress(), report_timestamp(), request_delete_task(), request_delete_task_uuid(), resource_exists(), resource_id_exists(), resource_tag_count(), role_is_predefined(), scan_host_end_time(), scan_start_time_epoch(), scanner_in_use(), schedule_duration(), schedule_in_use(), schedule_period(), set_credential_data(), set_scan_host_end_time(), set_scan_host_end_time_otp(), set_scan_host_start_time(), set_scan_host_start_time_otp(), set_task_preferences(), setting_auto_cache_rebuild_int(), setting_value_int(), sql_begin_exclusive_giveup(), sql_last_insert_id(), sql_uniquify(), target_alive_tests(), target_credential(), target_in_use(), target_login_port(), task_alterable(), task_average_scan_duration(), task_config_in_trash(), task_finished_report_count(), 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(), total_asset_count(), trash_alert_in_use(), trash_config_in_use(), trash_credential_in_use(), trash_filter_in_use(), trash_id_exists(), trash_port_list_in_use(), trash_report_format_in_use(), trash_scanner_in_use(), trash_schedule_in_use(), trash_target_credential(), trash_target_credential_location(), trash_target_in_use(), trash_target_login_port(), trash_task_writable(), user_ensure_in_db(), user_hosts_allow(), user_ifaces_allow(), 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_column_int64(), sql_finalize(), and sql_x().
Referenced by acl_user_has_access_uuid(), check_db_sequences(), config_scanner(), delete_asset(), delete_report_internal(), find_config(), find_nvt(), find_permission_with_permission(), find_port_list(), find_port_range_with_permission(), find_resource(), find_resource_by_name_with_permission(), find_resource_with_permission(), find_result_with_permission(), find_task(), host_nthlast_report_host(), hosts_set_identifiers(), lookup_report_format(), migrate_173_to_174(), migrate_177_to_178(), modify_asset(), permission_subject(), report_add_result(), report_format_active(), report_host_noticeable(), report_task(), reports_add_for_override(), reschedule_task(), set_report_format_param(), target_credential(), target_port_list(), task_config(), task_last_report(), task_last_stopped_report(), task_scanner(), task_schedule(), task_schedule_uuid(), task_severity_double(), task_target(), and trash_target_credential().
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 init_task_file_iterator(), set_task_parameter(), and 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_prepare_internal().
Referenced by init_prognosis_iterator(), migrate_19_to_20(), report_severity_data_prepare(), and report_severity_data_prepare_full().
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(), 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_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(), app_location(), cpe_highest_cvss(), create_asset_host(), create_asset_report(), create_config(), create_filter(), create_note(), create_override(), create_port_list(), create_port_list_lock(), create_port_list_unique(), create_port_range(), cve_cvss_base(), delete_asset(), delete_report_assets(), family_nvt_count(), filter_term(), find_config(), find_permission_with_permission(), find_port_list(), find_port_range_with_permission(), find_resource(), find_resource_by_name_with_permission(), find_resource_with_permission(), find_result_with_permission(), host_notice(), host_nthlast_report_host(), hosts_set_identifiers(), init_cert_bund_adv_info_iterator(), init_cpe_cve_iterator(), init_cpe_info_iterator(), init_cve_info_iterator(), init_dfn_cert_adv_info_iterator(), init_family_iterator(), init_nvt_info_iterator(), init_nvt_preference_iterator(), init_nvt_selector_iterator(), init_otp_pref_iterator(), init_ovaldef_info_iterator(), insert_report_host_detail(), lookup_report_format(), make_cve_result(), make_nvt_from_nvti(), make_osp_result(), make_result(), manage_create_scanner(), manage_modify_scanner(), manage_nvt_preference_add(), manage_report_host_add(), manage_set_config_comment(), manage_set_config_nvts(), manage_set_ldap_info(), manage_set_radius_info(), manage_task_remove_file(), manage_task_update_file(), 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(), modify_asset(), modify_report(), nvt_oid(), nvt_preference_count(), nvt_preference_iterator_config_value(), nvt_selector_family_growing(), nvt_selector_nvt_count(), ovaldef_cves(), ovaldef_severity(), ovaldef_uuid(), ovaldef_version(), port_range_port_list_uuid(), report_host_ip(), report_set_slave_host(), report_set_slave_name(), report_set_slave_uuid(), report_set_source_iface(), result_detection_reference(), result_host_asset_id(), scan_end_time_uuid(), scan_host_end_time(), scan_start_time_uuid(), set_credential_comment(), set_credential_data(), set_credential_name(), set_nvts_feed_version(), set_report_format_name(), set_report_format_param(), set_report_format_summary(), set_report_slave_task_uuid(), set_scan_host_end_time(), set_scan_host_end_time_otp(), set_scan_host_start_time(), set_scan_host_start_time_otp(), set_task_hosts_ordering(), set_task_parameter(), set_task_preferences(), set_task_schedule_next_time_uuid(), set_task_schedule_periods(), set_task_schedule_uuid(), setting_value_int(), sql_cpe_title(), sql_credential_value(), sql_insert(), sql_uniquify(), target_credential(), target_login_port(), task_preference_value(), task_schedule_next_time_uuid(), task_schedule_periods_uuid(), task_schedule_uuid(), trash_target_credential(), trash_target_credential_location(), trash_target_login_port(), user_ensure_in_db(), user_hosts(), user_hosts_allow(), user_ifaces(), user_ifaces_allow(), user_is_super_admin(), user_name(), 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_column_text(), sql_finalize(), and sql_x().
Referenced by agent_uuid(), alert_data(), alert_filter_id(), alert_name(), alert_owner_uuid(), alert_uuid(), app_location(), check_db_versions(), config_nvt_selector(), config_nvt_timeout(), config_type(), config_uuid(), credential_encrypted_value(), credential_name(), credential_type(), credential_uuid(), credential_value(), cve_cvss_base(), delete_asset(), delete_user(), filter_name(), filter_term(), filter_uuid(), find_resource_by_name_with_permission(), get_ovaldef_short_filename(), group_users(), group_uuid(), host_uuid(), init_report_counts_build_iterator(), make_result(), manage_cert_db_version(), manage_db_version(), manage_default_ca_cert(), manage_nvt_name(), 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(), modify_user(), note_uuid(), nvt_oid(), nvt_preference_iterator_config_value(), nvt_severity(), nvts_feed_version(), ovaldef_severity(), ovaldef_uuid(), ovaldef_version(), override_uuid(), permission_name(), permission_resource_id(), permission_resource_type(), permission_subject_id(), permission_subject_type(), permission_uuid(), port_list_uuid(), port_range_port_list_uuid(), port_range_uuid(), report_add_result(), report_cache_counts(), report_format_content_type(), report_format_extension(), report_format_name(), report_format_owner_uuid(), report_format_uuid(), report_host_ip(), report_slave_host(), report_slave_name(), report_slave_port(), report_slave_task_uuid(), report_slave_uuid(), report_source_iface(), report_uuid(), reports_add_for_override(), resource_name(), resource_uuid(), result_detection_reference(), result_host_asset_id(), result_uuid(), role_users(), role_uuid(), scan_end_time(), scan_end_time_uuid(), scan_start_time(), scan_start_time_uuid(), scanner_ca_pub(), scanner_host(), scanner_key_priv(), scanner_key_pub(), scanner_login(), scanner_name(), scanner_password(), scanner_port(), scanner_type(), scanner_uuid(), schedule_name(), schedule_uuid(), setting_filter(), setting_timezone(), sql_cpe_title(), sql_credential_value(), tag_uuid(), target_exclude_hosts(), target_hosts(), target_name(), target_reverse_lookup_only(), target_reverse_lookup_unify(), target_uuid(), task_comment(), task_config_name(), task_config_uuid(), task_definitions_file(), task_hosts_ordering(), task_name(), task_owner_name(), task_preference_value(), task_second_last_report_id(), task_uuid(), trash_credential_name(), trash_credential_uuid(), trash_filter_name(), trash_filter_uuid(), trash_target_exclude_hosts(), trash_target_hosts(), trash_target_name(), trash_target_uuid(), user_hosts(), user_ifaces(), user_name(), user_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_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().