Zabbix

/*

** Copyright (C) 2001-2025 Zabbix SIA

**

** This program is free software: you can redistribute it and/or modify it under the terms of

** the GNU Affero General Public License as published by the Free Software Foundation, version 3.

**

** This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

** without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

** See the GNU Affero General Public License for more details.

**

** You should have received a copy of the GNU Affero General Public License along with this program.

** If not, see <https://www.gnu.org/licenses/>.

**/

​

#ifndef ZABBIX_ZBXDB_H

#define ZABBIX_ZBXDB_H

​

#include "zbxcommon.h"

#include "zbxjson.h"

​

#define ZBX_DB_OK   0

#define ZBX_DB_FAIL -1

#define ZBX_DB_DOWN -2

​

#define ZBX_DB_TLS_CONNECT_REQUIRED_TXT     "required"

#define ZBX_DB_TLS_CONNECT_VERIFY_CA_TXT    "verify_ca"

#define ZBX_DB_TLS_CONNECT_VERIFY_FULL_TXT  "verify_full"

​

typedef char    **zbx_db_row_t;

typedef struct zbx_db_result    *zbx_db_result_t;

​

/* database field value */

typedef union

{

    int     i32;

    zbx_uint64_t    ui64;

    double      dbl;

    char        *str;

}

zbx_db_value_t;

​

typedef struct

{

    char    *config_dbhost;

    char    *config_dbname;

    char    *config_dbschema;

    char    *config_dbuser;

    char    *config_dbpassword;

    char    *config_dbsocket;

    char    *config_db_tls_connect;

    char    *config_db_tls_cert_file;

    char    *config_db_tls_key_file;

    char    *config_db_tls_ca_file;

    char    *config_db_tls_cipher;

    char    *config_db_tls_cipher_13;

    int config_dbport;

    int read_only_recoverable;

}

zbx_config_dbhigh_t;

​

#ifdef HAVE_SQLITE3

    /* we have to put double % here for sprintf */

#   define ZBX_SQL_MOD(x, y) #x "%%" #y

#else

#   define ZBX_SQL_MOD(x, y) "mod(" #x "," #y ")"

#endif

​

#ifdef HAVE_SQLITE3

#   define ZBX_FOR_UPDATE   ""  /* SQLite3 does not support "select ... for update" */

#else

#   define ZBX_FOR_UPDATE   " for update"

#endif

​

int zbx_db_init_basic(const char *dbname, const char *const dbschema, int log_slow_queries, char **error);

void    zbx_db_deinit_basic(void);

​

void    zbx_db_init_autoincrement_options_basic(void);

​

int zbx_db_connect_basic(const zbx_config_dbhigh_t *cfg);

void    zbx_db_close_basic(void);

​

int zbx_db_begin_basic(void);

int zbx_db_commit_basic(void);

int zbx_db_rollback_basic(void);

int zbx_db_txn_level(void);

int zbx_db_txn_error(void);

int zbx_db_txn_end_error(void);

const char  *zbx_db_last_strerr(void);

​

typedef enum

{