OpenVAS Manager
7.0.3~git
|
#include "sql.h"
#include "utils.h"
#include <assert.h>
#include <sqlite3.h>
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <sys/stat.h>
#include <errno.h>
Go to the source code of this file.
Data Structures | |
struct | sql_stmt |
Macros | |
#define | DB_CHUNK_SIZE 1 * 1024 * 1024 |
Chunk size for SQLite memory allocation. More... | |
#define | G_LOG_DOMAIN "md manage" |
GLib log domain. More... | |
#define | BUSY_TIMEOUT 1000 |
Busy timeout, in milliseconds. More... | |
Functions | |
int | sqlv (int, char *, va_list) |
Perform an SQL statement. More... | |
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 max) |
Setup a LIMIT argument. More... | |
const char * | sql_ilike_op () |
Get case insensitive LIKE operator. More... | |
const char * | sql_regexp_op () |
Get regular expression operator. More... | |
int | sql_is_open () |
Check whether the database is open. More... | |
const char * | sql_database () |
Return file name of current database. More... | |
const char * | sql_default_database () |
Return name of default database file. More... | |
int | sql_open (const char *database) |
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 () |
Get the number of rows changed or inserted in last statement. More... | |
resource_t | sql_last_insert_id () |
Get the ID of the last inserted row. More... | |
void | sqli (resource_t *resource, char *sql,...) |
Perform an SQL statement, retrying if database is busy or locked. More... | |
int | sql_prepare_internal (int retry, int log, const char *sql, va_list args, sql_stmt_t **stmt) |
Prepare a statement. More... | |
int | sql_exec_internal (int retry, sql_stmt_t *stmt) |
Execute a prepared statement. More... | |
int | sql_explain_internal (const char *sql, va_list args) |
Write debug messages with the query plan for an SQL query to the log. 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 exclusive transaction. More... | |
int | sql_begin_immediate_giveup () |
Begin an exclusive transaction. More... | |
void | sql_commit () |
Commit a transaction. More... | |
void | sql_rollback () |
Roll a transaction back. More... | |
int | iterator_null (iterator_t *iterator, int col) |
Get whether a column is NULL. More... | |
const char * | iterator_column_name (iterator_t *iterator, int col) |
Get a column name from an iterator. More... | |
int | iterator_column_count (iterator_t *iterator) |
Get number of columns from an iterator. More... | |
int | sql_bind_blob (sql_stmt_t *stmt, int position, const void *value, int value_size) |
Bind a blob to a statement. More... | |
int | sql_bind_int64 (sql_stmt_t *stmt, int position, long long int *value) |
Bind an int64 value to a statement. More... | |
int | sql_bind_double (sql_stmt_t *stmt, int position, double *value) |
Bind a double value to a statement. More... | |
int | sql_bind_text (sql_stmt_t *stmt, int position, const gchar *value, gsize value_size) |
Bind a text value to a statement. More... | |
void | sql_finalize (sql_stmt_t *stmt) |
Free a prepared statement. More... | |
int | sql_reset (sql_stmt_t *stmt) |
Reset a prepared statement. More... | |
double | sql_column_double (sql_stmt_t *stmt, int position) |
Return a column as a double from a prepared statement. More... | |
const char * | sql_column_text (sql_stmt_t *stmt, int position) |
Return a column as text from a prepared statement. More... | |
int | sql_column_int (sql_stmt_t *stmt, int position) |
Return a column as an integer from a prepared statement. More... | |
long long int | sql_column_int64 (sql_stmt_t *stmt, int position) |
Return a column as an int64 from a prepared statement. More... | |
int | sql_cancel_internal () |
Cancels the current SQL statement. More... | |
Variables | |
sqlite3 * | task_db = NULL |
Handle on the database. More... | |
#define BUSY_TIMEOUT 1000 |
Busy timeout, in milliseconds.
Definition at line 51 of file sql_sqlite3.c.
Referenced by sql_exec_internal(), and sql_prepare_internal().
#define DB_CHUNK_SIZE 1 * 1024 * 1024 |
Chunk size for SQLite memory allocation.
Definition at line 40 of file sql_sqlite3.c.
#define G_LOG_DOMAIN "md manage" |
GLib log domain.
Definition at line 46 of file sql_sqlite3.c.
int iterator_column_count | ( | iterator_t * | iterator | ) |
Get number of columns from an iterator.
[in] | iterator | Iterator. |
Definition at line 623 of file sql_sqlite3.c.
References iterator::done, 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 609 of file sql_sqlite3.c.
References iterator::done, iterator::stmt, and sql_stmt::stmt.
Referenced by sql_rename_column().
int iterator_null | ( | iterator_t * | iterator, |
int | col | ||
) |
Get whether a column is NULL.
[in] | iterator | Iterator. |
[in] | col | Column offset. |
Definition at line 594 of file sql_sqlite3.c.
References iterator::done, iterator::stmt, and sql_stmt::stmt.
Referenced by report_severity(), result_iterator_level(), and result_iterator_original_level().
void sql_begin_exclusive | ( | ) |
Begin an exclusive transaction.
Definition at line 528 of file sql_sqlite3.c.
References sql_stmt::sql.
Referenced by delete_report(), delete_task_lock(), delete_user(), make_nvt_from_nvti(), manage_complete_nvt_cache_update(), manage_nvt_preference_add(), manage_set_config_families(), manage_set_config_nvts(), 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(), and set_task_requested().
int sql_begin_exclusive_giveup | ( | ) |
Begin an exclusive transaction, giving up on failure.
Definition at line 539 of file sql_sqlite3.c.
References sql_giveup().
Referenced by auto_delete_reports(), and init_task_schedule_iterator().
void sql_begin_immediate | ( | ) |
Begin an exclusive transaction.
Begin an immediate transaction.
Definition at line 548 of file sql_sqlite3.c.
References sql_stmt::sql.
Referenced by copy_alert(), copy_config(), copy_group(), copy_permission(), copy_port_list(), copy_report_format(), copy_resource(), copy_role(), copy_task(), copy_user(), create_asset_host(), create_asset_report(), create_config(), create_config_from_scanner(), create_credential(), create_filter(), create_group(), create_permission(), create_port_list(), create_port_range(), create_role(), create_scanner(), create_schedule(), create_tag(), create_user(), delete_agent(), delete_alert(), delete_asset(), delete_config(), delete_credential(), delete_filter(), delete_group(), delete_note(), delete_override(), delete_permission(), delete_port_list(), delete_port_range(), delete_report_format(), delete_role(), delete_scanner(), delete_schedule(), delete_tag(), delete_target(), manage_empty_trashcan(), manage_restore(), manage_set_config(), manage_set_ldap_info(), manage_set_password(), manage_set_radius_info(), modify_agent(), modify_asset(), modify_credential(), modify_filter(), modify_group(), modify_permission(), modify_port_list(), modify_report(), modify_report_format(), modify_role(), modify_scanner(), modify_schedule(), modify_tag(), modify_target(), modify_user(), parse_osp_report(), request_delete_task_uuid(), set_report_format_param(), set_task_alerts(), set_task_groups(), set_task_observers(), set_task_preferences(), sync_config(), update_from_slave(), verify_agent(), and verify_report_format().
int sql_begin_immediate_giveup | ( | ) |
Begin an exclusive transaction.
Begin an immediate transaction.
Definition at line 559 of file sql_sqlite3.c.
References 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 643 of file sql_sqlite3.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 718 of file sql_sqlite3.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 683 of file sql_sqlite3.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 754 of file sql_sqlite3.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
Referenced by init_prognosis_iterator(), and migrate_19_to_20().
int sql_cancel_internal | ( | ) |
Cancels the current SQL statement.
Definition at line 896 of file sql_sqlite3.c.
References task_db.
Referenced by sql_cancel().
int sql_changes | ( | ) |
Get the number of rows changed or inserted in last statement.
Return 0.
Definition at line 305 of file sql_sqlite3.c.
References task_db.
Referenced by cleanup_schedule_times(), and migrate_118_to_119().
void sql_close | ( | ) |
Close the database.
Definition at line 277 of file sql_sqlite3.c.
References task_db.
Referenced by manage_cleanup_process_error().
void sql_close_fork | ( | ) |
Close the database in a forked process.
Definition at line 296 of file sql_sqlite3.c.
References task_db.
double sql_column_double | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as a double from a prepared statement.
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 843 of file sql_sqlite3.c.
References 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.
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 871 of file sql_sqlite3.c.
References 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.
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 885 of file sql_sqlite3.c.
References sql_stmt::stmt.
Referenced by iterator_int64(), and sql_int64().
const char* sql_column_text | ( | sql_stmt_t * | stmt, |
int | position | ||
) |
Return a column as text from a prepared statement.
[in] | stmt | Statement. |
[in] | position | Column position. |
Definition at line 857 of file sql_sqlite3.c.
References 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 568 of file sql_sqlite3.c.
References sql_stmt::sql.
Referenced by auto_delete_reports(), cleanup_task_schedule_iterator(), create_asset_host(), create_port_range(), create_tag(), delete_asset(), delete_port_range(), delete_report(), delete_report_assets(), delete_task_lock(), make_nvt_from_nvti(), manage_nvt_preference_add(), manage_set_ldap_info(), manage_set_radius_info(), 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(), modify_asset(), modify_report(), modify_tag(), parse_osp_report(), request_delete_task_uuid(), set_task_alerts(), set_task_groups(), set_task_preferences(), set_task_requested(), and update_from_slave().
const char* sql_database | ( | ) |
Return file name of current database.
Return name of current database.
Definition at line 172 of file sql_sqlite3.c.
Referenced by manage_cert_loaded(), manage_create_sql_functions(), manage_db_empty(), and manage_scap_loaded().
const char* sql_default_database | ( | ) |
Return name of default database file.
Return name of default database.
Definition at line 184 of file sql_sqlite3.c.
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. |
Definition at line 433 of file sql_sqlite3.c.
References BUSY_TIMEOUT, openvas_usleep(), sql_stmt::stmt, and task_db.
Referenced by next(), sql_exec(), sql_explain_internal(), sql_quiet(), and sqlv().
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 481 of file sql_sqlite3.c.
References sql_exec_internal(), sql_finalize(), sql_prepare_internal(), and sql_stmt::stmt.
Referenced by sql_explain().
void sql_finalize | ( | sql_stmt_t * | stmt | ) |
Free a prepared statement.
[in] | stmt | Statement. |
Definition at line 790 of file sql_sqlite3.c.
References sql_stmt::stmt.
Referenced by cleanup_iterator(), cleanup_prognosis_iterator(), migrate_19_to_20(), sql_double(), sql_explain_internal(), sql_int(), sql_int64(), sql_quiet(), sql_string(), and sqlv().
const char* sql_greatest | ( | ) |
Get keyword for "greatest" SQL function.
Definition at line 106 of file sql_sqlite3.c.
const char* sql_ilike_op | ( | ) |
Get case insensitive LIKE operator.
Definition at line 139 of file sql_sqlite3.c.
Referenced by init_nvt_preference_iterator(), and nvt_preference_count().
int sql_is_open | ( | ) |
Check whether the database is open.
Definition at line 161 of file sql_sqlite3.c.
References task_db.
Referenced by manage_cleanup_process_error().
int sql_is_sqlite3 | ( | ) |
Get whether backend is SQLite3.
Definition at line 84 of file sql_sqlite3.c.
Referenced by init_ovaldi_file_iterator(), manage_complete_nvt_cache_update(), 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 314 of file sql_sqlite3.c.
References task_db.
Referenced by create_asset_host(), create_port_list_lock(), create_port_range(), create_tag(), host_notice(), hosts_set_identifiers(), make_config_host_discovery(), make_config_system_discovery(), make_cve_result(), make_nvt_from_nvti(), make_osp_result(), make_report(), make_result(), manage_create_scanner(), manage_modify_scanner(), manage_report_host_add(), 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().
int sql_open | ( | const char * | database | ) |
Open the database.
[in] | database | Database, or NULL for default. |
Definition at line 197 of file sql_sqlite3.c.
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 351 of file sql_sqlite3.c.
References BUSY_TIMEOUT, openvas_usleep(), and task_db.
Referenced by init_iterator(), sql_explain_internal(), sql_prepare(), sql_quiet(), and sqlv().
const char* sql_regexp_op | ( | ) |
Get regular expression operator.
Definition at line 150 of file sql_sqlite3.c.
int sql_reset | ( | sql_stmt_t * | stmt | ) |
Reset a prepared statement.
[in] | stmt | Statement. |
Definition at line 805 of file sql_sqlite3.c.
References openvas_usleep(), sql_stmt::stmt, and task_db.
Referenced by init_prognosis_iterator().
void sql_rollback | ( | ) |
Roll a transaction back.
Definition at line 577 of file sql_sqlite3.c.
References sql_stmt::sql.
Referenced by auto_delete_reports(), copy_permission(), create_asset_host(), create_asset_report(), create_config(), create_config_from_scanner(), create_credential(), create_filter(), create_group(), create_port_list(), create_port_range(), create_role(), create_scanner(), create_schedule(), create_tag(), create_user(), delete_agent(), delete_alert(), delete_asset(), delete_config(), delete_credential(), delete_filter(), delete_group(), delete_note(), delete_override(), delete_permission(), delete_port_list(), delete_port_range(), delete_report(), delete_report_assets(), delete_report_format(), delete_role(), delete_scanner(), delete_schedule(), delete_tag(), delete_target(), delete_task_lock(), delete_user(), manage_empty_trashcan(), manage_restore(), manage_set_config_families(), manage_set_config_nvts(), 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(), modify_agent(), modify_asset(), modify_credential(), modify_filter(), modify_group(), modify_permission(), modify_port_list(), modify_report(), modify_report_format(), modify_role(), modify_scanner(), modify_schedule(), modify_tag(), modify_target(), modify_user(), request_delete_task_uuid(), set_report_format_param(), set_task_alerts(), set_task_groups(), set_task_observers(), sync_config(), update_from_slave(), verify_agent(), and verify_report_format().
const char* sql_schema | ( | ) |
Get main schema name.
Definition at line 95 of file sql_sqlite3.c.
Referenced by check_db_versions(), manage_db_version(), manage_nvt_preferences_enable(), manage_update_nvti_cache(), migrate_75_to_76(), nvts_feed_version(), set_db_version(), and set_nvts_feed_version().
const char* sql_select_limit | ( | int | max | ) |
Setup a LIMIT argument.
[in] | max | Max. |
Definition at line 119 of file sql_sqlite3.c.
Referenced by auto_delete_reports(), and init_aggregate_iterator().
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 327 of file sql_sqlite3.c.
References sql_last_insert_id(), and sqlv().
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().
sqlite3* task_db = NULL |
Handle on the database.
Definition at line 73 of file sql_sqlite3.c.
Referenced by manage_create_migrate_51_to_52_convert(), manage_create_sql_functions(), sql_bind_blob(), sql_bind_double(), sql_bind_int64(), sql_bind_text(), sql_cancel_internal(), sql_changes(), sql_close(), sql_close_fork(), sql_exec_internal(), sql_is_open(), sql_last_insert_id(), sql_prepare_internal(), and sql_reset().