OpenDNSSEC-enforcer  1.3.9
Data Structures | Macros | Typedefs | Functions
database.h File Reference
#include <stdlib.h>
#include <sqlite3.h>
Include dependency graph for database.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures

struct  db_result
struct  db_row

Macros

#define KSM_DB_VERSION   2 /* This needs to match that given in the dbadmin table */
#define MYSQL_DB   1
#define SQLITE_DB   2
#define DB_RESULT_MAGIC   (0x10203044)
#define DB_ROW_MAGIC   (0xbedea133)

Typedefs

typedef sqlite3 * DB_HANDLE
typedef unsigned long DB_ID
typedef struct db_resultDB_RESULT
typedef struct db_rowDB_ROW

Functions

void DbInit (void)
void DbRundown (void)
int DbConnect (DB_HANDLE *dbhandle, const char *database,...)
int DbDisconnect (DB_HANDLE dbhandle)
int DbConnected (DB_HANDLE dbhandle)
int DbCheckConnected (DB_HANDLE dbhandle)
DB_HANDLE DbHandle (void)
int DbExecuteSql (DB_HANDLE handle, const char *stmt_str, DB_RESULT *result)
void DbFreeResult (DB_RESULT result)
int DbFetchRow (DB_RESULT result, DB_ROW *row)
void DbFreeRow (DB_ROW row)
int DbString (DB_ROW row, int field_index, char **result)
void DbStringFree (char *string)
int DbExecuteSqlNoResult (DB_HANDLE dbhandle, const char *stmt_str)
int DbUnsignedLong (DB_ROW row, int field_index, unsigned long *value)
int DbInt (DB_ROW row, int field_index, int *value)
int DbIntQuery (DB_HANDLE handle, int *value, const char *query)
int DbStringBuffer (DB_ROW row, int field_index, char *buffer, size_t buflen)
int DbRowId (DB_ROW, DB_ID *id)
const char * DbErrmsg (DB_HANDLE handle)
int DbErrno (DB_HANDLE handle)
int DbLastRowId (DB_HANDLE handle, DB_ID *id)
int DbBeginTransaction (void)
int DbCommit (void)
int DbRollback (void)
int DbFlavour (void)
int db_version_check (void)

Macro Definition Documentation

#define DB_RESULT_MAGIC   (0x10203044)

Definition at line 90 of file database.h.

Referenced by DbExecuteSql(), DbFetchRow(), and DbFreeResult().

#define DB_ROW_MAGIC   (0xbedea133)

Definition at line 99 of file database.h.

Referenced by DbFetchRow(), DbFreeRow(), DbString(), and DbStringBuffer().

#define KSM_DB_VERSION   2 /* This needs to match that given in the dbadmin table */

Definition at line 45 of file database.h.

Referenced by db_version_check().

#define MYSQL_DB   1

Definition at line 47 of file database.h.

Referenced by DbFlavour(), get_db_details(), and ReadConfig().

#define SQLITE_DB   2

Typedef Documentation

typedef sqlite3* DB_HANDLE

Definition at line 79 of file database.h.

typedef unsigned long DB_ID

Definition at line 80 of file database.h.

typedef struct db_result* DB_RESULT

Definition at line 92 of file database.h.

typedef struct db_row* DB_ROW

Definition at line 100 of file database.h.


Function Documentation

int db_version_check ( void  )
int DbBeginTransaction ( void  )
int DbCheckConnected ( DB_HANDLE  dbhandle)

Definition at line 209 of file database_connection_lite.c.

References DbConnected(), DBS_NOTCONERR, and MsgLog().

int DbCommit ( void  )
int DbConnect ( DB_HANDLE dbhandle,
const char *  database,
  ... 
)
int DbConnected ( DB_HANDLE  dbhandle)

Definition at line 187 of file database_connection_lite.c.

Referenced by DbCheckConnected().

int DbDisconnect ( DB_HANDLE  dbhandle)
const char* DbErrmsg ( DB_HANDLE  handle)
int DbErrno ( DB_HANDLE  handle)

Definition at line 405 of file database_support_lite.c.

int DbExecuteSql ( DB_HANDLE  handle,
const char *  stmt_str,
DB_RESULT result 
)
int DbExecuteSqlNoResult ( DB_HANDLE  dbhandle,
const char *  stmt_str 
)
int DbFetchRow ( DB_RESULT  result,
DB_ROW row 
)
int DbFlavour ( void  )
void DbFreeResult ( DB_RESULT  result)
void DbFreeRow ( DB_ROW  row)
DB_HANDLE DbHandle ( void  )

Definition at line 237 of file database_connection_lite.c.

Referenced by ChangeKeyState(), cmd_listzone(), cmd_purgepolicy(), CountKeys(), CountKeysInState(), db_version_check(), DbBeginTransaction(), DbCommit(), DbRollback(), do_purge(), get_policy_name_from_id(), keyRoll(), KsmCheckHSMkeyID(), KsmCheckNextRollover(), KsmDeleteKeyRange(), KsmDeleteZone(), KsmDnssecKeyCreate(), KsmDNSSECKeysInSMCount(), KsmDNSSECKeysInSMCountInit(), KsmDNSSECKeysStateCountInit(), KsmImportAudit(), KsmImportKeyPair(), KsmImportPolicy(), KsmImportRepository(), KsmImportZone(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmKeyGetUnallocated(), KsmKeyInitSql(), KsmKeyPairCreate(), KsmKillKey(), KsmListBackups(), KsmListPolicies(), KsmListRepos(), KsmListRollovers(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterExist(), KsmParameterInit(), KsmParameterSet(), KsmPolicy(), KsmPolicyExists(), KsmPolicyIdFromName(), KsmPolicyIdFromZoneId(), KsmPolicyInit(), KsmPolicyNameFromId(), KsmPolicyNullSaltStamp(), KsmPolicyParameter(), KsmPolicyParametersInit(), KsmPolicyPopulateSMFromIds(), KsmPolicySetIdFromName(), KsmPolicyUpdateSalt(), KsmPurge(), KsmRequestAvailableCount(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestCheckActiveKey(), KsmRequestCheckCompromisedFlag(), KsmRequestCheckFirstPass(), KsmRequestCountReadyKey(), KsmRequestGenerateCount(), KsmRequestKeys(), KsmRequestKeysByType(), KsmRequestPendingRetireCount(), KsmRequestSetActiveExpectedRetire(), KsmRequestStandbyKSKCount(), KsmRollbackMarkPreBackup(), KsmSerialIdFromName(), KsmSmIdFromName(), KsmUpdateKeyTime(), KsmZone(), KsmZoneCount(), KsmZoneCountInit(), KsmZoneIdAndPolicyFromName(), KsmZoneIdFromName(), KsmZoneInit(), KsmZoneNameFromId(), ListKeys(), MarkDSSeen(), NewDSSet(), PurgeKeys(), RetireOldKey(), TdbTeardown(), and update_zones().

void DbInit ( void  )

Definition at line 59 of file database_init_rundown.c.

References DBS_MAX_VALUE, DBS_MIN_VALUE, and MsgRegister().

Referenced by DbConnect(), KsmInit(), and TdbSetup().

int DbInt ( DB_ROW  row,
int  field_index,
int *  value 
)
int DbIntQuery ( DB_HANDLE  handle,
int *  value,
const char *  query 
)
int DbLastRowId ( DB_HANDLE  handle,
DB_ID id 
)

Definition at line 459 of file database_support_lite.c.

References DBS_INVARG, DBS_NOSUCHROW, and MsgLog().

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), and KsmKeyPairCreate().

int DbRollback ( void  )
int DbRowId ( DB_ROW  ,
DB_ID id 
)

Definition at line 120 of file database_support_lite.c.

References DBS_INVARG, DbUnsignedLong(), and MsgLog().

void DbRundown ( void  )

Definition at line 81 of file database_init_rundown.c.

Referenced by KsmRundown(), and TdbTeardown().

int DbString ( DB_ROW  row,
int  field_index,
char **  result 
)
int DbStringBuffer ( DB_ROW  row,
int  field_index,
char *  buffer,
size_t  buflen 
)
void DbStringFree ( char *  string)
int DbUnsignedLong ( DB_ROW  row,
int  field_index,
unsigned long *  value 
)