database_statement.h File Reference

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures
struct	DQS_QUERY_CONDITION

Enumerations
enum	DQS_COMPARISON {   DQS_END_OF_LIST, DQS_COMPARE_LT, DQS_COMPARE_LE, DQS_COMPARE_EQ,   DQS_COMPARE_NE, DQS_COMPARE_GT, DQS_COMPARE_GE, DQS_COMPARE_IN,   DQS_COMPARE_NOT_IN, DQS_COMPARE_IS }

Functions
char *	DqsInit (const char *table)
char *	DqsCountInit (const char *table)
char *	DqsSpecifyInit (const char *table, const char *fields)
void	DqsConditionInt (char **query, const char *field, DQS_COMPARISON compare, int value, int clause)
void	DqsConditionString (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DqsConditionKeyword (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DqsOrderBy (char **query, const char *field)
void	DqsEnd (char **query)
void	DqsFree (char *query)
char *	DisInit (const char *table)
char *	DisSpecifyInit (const char *table, const char *cols)
void	DisAppendInt (char **sql, int what)
void	DisAppendString (char **sql, const char *what)
void	DisEnd (char **sql)
void	DisFree (char *sql)
char *	DusInit (const char *table)
void	DusSetInt (char **sql, const char *field, int data, int clause)
void	DusSetString (char **sql, const char *field, const char *data, int clause)
void	DusConditionInt (char **query, const char *field, DQS_COMPARISON compare, int value, int clause)
void	DusConditionString (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DusConditionKeyword (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DusEnd (char **sql)
void	DusFree (char *sql)
char *	DdsInit (const char *table)
void	DdsConditionInt (char **query, const char *field, DQS_COMPARISON compare, int value, int clause)
void	DdsConditionString (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DdsConditionKeyword (char **query, const char *field, DQS_COMPARISON compare, const char *value, int clause)
void	DdsEnd (char **query)
void	DdsFree (char *query)

Enumeration Type Documentation

enum DQS_COMPARISON

Enumerator:

DQS_END_OF_LIST
DQS_COMPARE_LT
DQS_COMPARE_LE
DQS_COMPARE_EQ
DQS_COMPARE_NE
DQS_COMPARE_GT
DQS_COMPARE_GE
DQS_COMPARE_IN
DQS_COMPARE_NOT_IN
DQS_COMPARE_IS

Definition at line 46 of file database_statement.h.

Function Documentation

void DdsConditionInt	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		int	value,
		int	clause
	)

Definition at line 90 of file dd_string.c.

References DqsConditionInt().

Referenced by cmd_purgepolicy(), do_purge(), KsmDeleteKeyRange(), KsmDeleteZone(), KsmPurge(), and PurgeKeys().

void DdsConditionKeyword	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 104 of file dd_string.c.

References DqsConditionKeyword().

void DdsConditionString	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 97 of file dd_string.c.

References DqsConditionString().

void DdsEnd

(

char **

query

)

Definition at line 111 of file dd_string.c.

References DqsEnd().

Referenced by cmd_purgepolicy(), do_purge(), KsmDeleteKeyRange(), KsmDeleteZone(), KsmPurge(), and PurgeKeys().

void DdsFree

(

char *

query

)

Definition at line 117 of file dd_string.c.

References DqsFree().

Referenced by cmd_purgepolicy(), do_purge(), KsmDeleteKeyRange(), KsmDeleteZone(), KsmPurge(), and PurgeKeys().

char* DdsInit

(

const char *

table

)

Definition at line 62 of file dd_string.c.

References StrAppend(), and StrStrdup().

Referenced by cmd_purgepolicy(), do_purge(), KsmDeleteKeyRange(), KsmDeleteZone(), KsmPurge(), and PurgeKeys().

void DisAppendInt	(	char **	sql,
		int	what
	)

Definition at line 133 of file di_string.c.

References KSM_INT_STR_SIZE, and StrAppend().

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), KsmImportRepository(), KsmImportZone(), KsmKeyPairCreate(), and KsmParameterSet().

void DisAppendString	(	char **	sql,
		const char *	what
	)

Definition at line 144 of file di_string.c.

References StrAppend().

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), KsmImportPolicy(), KsmImportRepository(), KsmImportZone(), and KsmKeyPairCreate().

void DisEnd

(

char **

sql

)

Definition at line 172 of file di_string.c.

References StrAppend().

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), KsmImportPolicy(), KsmImportRepository(), KsmImportZone(), KsmKeyPairCreate(), and KsmParameterSet().

void DisFree

(

char *

sql

)

Definition at line 193 of file di_string.c.

References StrFree.

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), KsmImportPolicy(), KsmImportRepository(), KsmImportZone(), KsmKeyPairCreate(), and KsmParameterSet().

char* DisInit

(

const char *

table

)

Definition at line 67 of file di_string.c.

References StrAppend(), and StrStrdup().

Referenced by KsmParameterSet().

char* DisSpecifyInit	(	const char *	table,
		const char *	cols
	)

Definition at line 101 of file di_string.c.

References StrAppend(), and StrStrdup().

Referenced by KsmDnssecKeyCreate(), KsmImportKeyPair(), KsmImportPolicy(), KsmImportRepository(), KsmImportZone(), and KsmKeyPairCreate().

void DqsConditionInt	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		int	value,
		int	clause
	)

Definition at line 226 of file dq_string.c.

References KSM_INT_STR_SIZE, and StrAppend().

Referenced by ChangeKeyState(), cmd_exportkeys(), CountKeysInState(), DdsConditionInt(), DusConditionInt(), get_policy_name_from_id(), keyRoll(), KsmCheckHSMkeyID(), KsmCheckNextRollover(), KsmDNSSECKeysInSMCountInit(), KsmDNSSECKeysStateCountInit(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmKeyGetUnallocated(), KsmKeyInit(), KsmKillKey(), KsmMarkBackup(), KsmMarkKeysAsDead(), KsmMarkPreBackup(), KsmParameterInit(), KsmPolicyIdFromZoneId(), KsmPolicyNameFromId(), KsmPolicyPopulateSMFromIds(), KsmPolicyUpdateSalt(), KsmPurge(), KsmRequestAvailableCount(), KsmRequestChangeState(), KsmRequestCheckActiveKey(), KsmRequestCheckCompromisedFlag(), KsmRequestCheckFirstPass(), KsmRequestCountReadyKey(), KsmRequestGenerateCount(), KsmRequestIssueKeys(), KsmRequestPendingRetireCount(), KsmRequestSetActiveExpectedRetire(), KsmRequestStandbyKSKCount(), KsmRollbackMarkPreBackup(), KsmZoneCountInit(), KsmZoneInit(), KsmZoneNameFromId(), and NewDSSet().

void DqsConditionKeyword	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 253 of file dq_string.c.

References StrAppend().

Referenced by cmd_exportkeys(), DdsConditionKeyword(), DusConditionKeyword(), KsmImportZone(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmKeyGetUnallocated(), KsmPolicyParametersInit(), KsmRequestAvailableCount(), KsmRequestCheckActiveKey(), KsmRequestIssueKeys(), KsmRequestPendingRetireCount(), KsmRequestStandbyKSKCount(), and NewDSSet().

void DqsConditionString	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 240 of file dq_string.c.

References StrAppend().

Referenced by ChangeKeyState(), DdsConditionString(), DusConditionString(), KsmCheckHSMkeyID(), KsmImportRepository(), KsmParameterExist(), KsmParameterInit(), KsmPolicyIdFromName(), KsmPolicyInit(), KsmPolicyParametersInit(), KsmRequestChangeState(), KsmRequestCheckActiveKey(), KsmSerialIdFromName(), KsmSmIdFromName(), KsmZoneIdAndPolicyFromName(), and KsmZoneIdFromName().

char* DqsCountInit

(

const char *

table

)

Definition at line 92 of file dq_string.c.

References StrAppend(), and StrStrdup().

Referenced by ChangeKeyState(), CountKeysInState(), do_purge(), KsmCheckHSMkeyID(), KsmDNSSECKeysInSMCountInit(), KsmDNSSECKeysStateCountInit(), KsmImportRepository(), KsmImportZone(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmMarkBackup(), KsmMarkPreBackup(), KsmRequestAvailableCount(), KsmRequestChangeState(), KsmRequestCheckActiveKey(), KsmRequestCheckCompromisedFlag(), KsmRequestCheckFirstPass(), KsmRequestCountReadyKey(), KsmRequestGenerateCount(), KsmRequestPendingRetireCount(), KsmRequestSetActiveExpectedRetire(), KsmRequestStandbyKSKCount(), KsmRollbackMarkPreBackup(), KsmZoneCountInit(), NewDSSet(), PurgeKeys(), and update_zones().

void DqsEnd

(

char **

query

)

Definition at line 301 of file dq_string.c.

Referenced by ChangeKeyState(), cmd_exportkeys(), CountKeysInState(), DdsEnd(), do_purge(), keyRoll(), KsmCheckHSMkeyID(), KsmCheckNextRollover(), KsmImportRepository(), KsmImportZone(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmKeyInit(), KsmMarkBackup(), KsmMarkKeysAsDead(), KsmMarkPreBackup(), KsmPolicyIdFromName(), KsmPurge(), KsmRequestAvailableCount(), KsmRequestChangeState(), KsmRequestCheckActiveKey(), KsmRequestCheckCompromisedFlag(), KsmRequestCheckFirstPass(), KsmRequestCountReadyKey(), KsmRequestGenerateCount(), KsmRequestIssueKeys(), KsmRequestPendingRetireCount(), KsmRequestSetActiveExpectedRetire(), KsmRequestStandbyKSKCount(), KsmRollbackMarkPreBackup(), KsmSerialIdFromName(), KsmSmIdFromName(), NewDSSet(), PurgeKeys(), and update_zones().

void DqsFree

(

char *

query

)

Definition at line 322 of file dq_string.c.

References StrFree.

Referenced by ChangeKeyState(), CountKeysInState(), DdsFree(), do_purge(), get_policy_name_from_id(), keyRoll(), KsmCheckHSMkeyID(), KsmDNSSECKeysInSMCountInit(), KsmDNSSECKeysStateCountInit(), KsmImportRepository(), KsmImportZone(), KsmKeyCountQueue(), KsmKeyCountStillGood(), KsmKeyGetUnallocated(), KsmKeyInit(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterExist(), KsmParameterInit(), KsmPolicyIdFromName(), KsmPolicyIdFromZoneId(), KsmPolicyInit(), KsmPolicyNameFromId(), KsmPolicyParametersInit(), KsmPolicyPopulateSMFromIds(), KsmPolicyUpdateSalt(), KsmRequestAvailableCount(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestCheckActiveKey(), KsmRequestCheckCompromisedFlag(), KsmRequestCheckFirstPass(), KsmRequestCountReadyKey(), KsmRequestGenerateCount(), KsmRequestIssueKeys(), KsmRequestPendingRetireCount(), KsmRequestSetActiveExpectedRetire(), KsmRequestStandbyKSKCount(), KsmRollbackMarkPreBackup(), KsmSerialIdFromName(), KsmSmIdFromName(), KsmZoneCountInit(), KsmZoneIdAndPolicyFromName(), KsmZoneIdFromName(), KsmZoneInit(), KsmZoneNameFromId(), NewDSSet(), PurgeKeys(), and update_zones().

char* DqsInit

(

const char *

table

)

Definition at line 63 of file dq_string.c.

References StrAppend(), and StrStrdup().

void DqsOrderBy	(	char **	query,
		const char *	field
	)

Definition at line 279 of file dq_string.c.

References StrAppend().

Referenced by cmd_exportkeys(), get_policy_name_from_id(), KsmParameterExist(), KsmParameterInit(), KsmPolicyIdFromZoneId(), KsmPolicyInit(), KsmPolicyNameFromId(), KsmPolicyParametersInit(), KsmPolicyUpdateSalt(), KsmZoneIdAndPolicyFromName(), KsmZoneIdFromName(), KsmZoneInit(), KsmZoneNameFromId(), and update_zones().

char* DqsSpecifyInit	(	const char *	table,
		const char *	fields
	)

Definition at line 119 of file dq_string.c.

References StrAppend(), StrFree, and StrStrdup().

Referenced by ChangeKeyState(), cmd_exportkeys(), get_policy_name_from_id(), keyRoll(), KsmCheckNextRollover(), KsmKeyGetUnallocated(), KsmKeyInit(), KsmMarkKeysAsDead(), KsmParameterExist(), KsmParameterInit(), KsmPolicyIdFromName(), KsmPolicyIdFromZoneId(), KsmPolicyInit(), KsmPolicyNameFromId(), KsmPolicyParametersInit(), KsmPolicyPopulateSMFromIds(), KsmPolicyUpdateSalt(), KsmPurge(), KsmRequestChangeState(), KsmRequestIssueKeys(), KsmRequestSetActiveExpectedRetire(), KsmSerialIdFromName(), KsmSmIdFromName(), KsmZoneIdAndPolicyFromName(), KsmZoneIdFromName(), KsmZoneInit(), KsmZoneNameFromId(), NewDSSet(), and update_zones().

void DusConditionInt	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		int	value,
		int	clause
	)

Definition at line 172 of file du_string.c.

References DqsConditionInt().

Referenced by ChangeKeyState(), keyRoll(), KsmImportAudit(), KsmKillKey(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterSet(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRollbackMarkPreBackup(), MarkDSSeen(), and RetireOldKey().

void DusConditionKeyword	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 184 of file du_string.c.

References DqsConditionKeyword().

Referenced by ChangeKeyState(), KsmRequestChangeState(), KsmRequestChangeStateN(), and KsmRequestSetActiveExpectedRetire().

void DusConditionString	(	char **	query,
		const char *	field,
		DQS_COMPARISON	compare,
		const char *	value,
		int	clause
	)

Definition at line 178 of file du_string.c.

References DqsConditionString().

Referenced by KsmImportRepository(), and KsmImportZone().

void DusEnd

(

char **

sql

)

Definition at line 204 of file du_string.c.

Referenced by ChangeKeyState(), CountKeys(), do_purge(), keyRoll(), KsmImportAudit(), KsmImportRepository(), KsmImportZone(), KsmKillKey(), KsmListBackups(), KsmListPolicies(), KsmListRepos(), KsmListRollovers(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterSet(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestSetActiveExpectedRetire(), KsmRollbackMarkPreBackup(), ListKeys(), MarkDSSeen(), and PurgeKeys().

void DusFree

(

char *

sql

)

Definition at line 225 of file du_string.c.

References StrFree.

Referenced by ChangeKeyState(), CountKeys(), do_purge(), keyRoll(), KsmCheckNextRollover(), KsmImportAudit(), KsmImportRepository(), KsmImportZone(), KsmKillKey(), KsmListBackups(), KsmListPolicies(), KsmListRepos(), KsmListRollovers(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterSet(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestSetActiveExpectedRetire(), KsmRollbackMarkPreBackup(), ListKeys(), MarkDSSeen(), PurgeKeys(), RetireOldKey(), and update_zones().

char* DusInit

(

const char *

table

)

Definition at line 62 of file du_string.c.

References StrAppend(), and StrStrdup().

Referenced by ChangeKeyState(), keyRoll(), KsmImportAudit(), KsmImportRepository(), KsmImportZone(), KsmKillKey(), KsmMarkBackup(), KsmMarkPreBackup(), KsmParameterSet(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestSetActiveExpectedRetire(), KsmRollbackMarkPreBackup(), MarkDSSeen(), and RetireOldKey().

void DusSetInt	(	char **	sql,
		const char *	field,
		int	data,
		int	clause
	)

Definition at line 99 of file du_string.c.

References KSM_INT_STR_SIZE, and StrAppend().

Referenced by ChangeKeyState(), keyRoll(), KsmImportRepository(), KsmImportZone(), KsmKillKey(), KsmParameterSet(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestSetActiveExpectedRetire(), MarkDSSeen(), and RetireOldKey().

void DusSetString	(	char **	sql,
		const char *	field,
		const char *	data,
		int	clause
	)

Definition at line 115 of file du_string.c.

References StrAppend().

Referenced by ChangeKeyState(), keyRoll(), KsmImportAudit(), KsmImportRepository(), KsmImportZone(), KsmKillKey(), KsmMarkBackup(), KsmMarkPreBackup(), KsmRequestChangeState(), KsmRequestChangeStateN(), KsmRequestSetActiveExpectedRetire(), KsmRollbackMarkPreBackup(), MarkDSSeen(), and RetireOldKey().