45 #include "CUnit/Basic.h"
60 static void TestDbExecuteSql(
void)
69 CU_ASSERT_EQUAL(status, 0);
86 static void TestDatabaseAccess(
void)
98 CU_ASSERT_EQUAL(status, 0);
108 CU_ASSERT_EQUAL(status, 0);
110 CU_ASSERT_EQUAL(status, 0);
111 CU_ASSERT_PTR_NULL(
string);
117 CU_ASSERT_EQUAL(status, 0);
119 CU_ASSERT_EQUAL(status, 0);
120 CU_ASSERT_STRING_EQUAL(
string,
"ABC");
127 CU_ASSERT_EQUAL(status, 0);
129 CU_ASSERT_EQUAL(status, 0);
130 CU_ASSERT_STRING_EQUAL(
string,
"DEF");
137 CU_ASSERT_EQUAL(status, -1);
157 static void TestDbExecuteSqlNoResult(
void)
170 CU_ASSERT_EQUAL(status, 0);
179 CU_ASSERT_EQUAL(status, 0);
182 CU_ASSERT_EQUAL(rowcount, 1);
196 static void TestDbIntQuery(
void)
211 CU_ASSERT_EQUAL(status, 0);
213 CU_ASSERT_EQUAL(rowcount, 1);
226 static void TestDbStringBuffer(
void)
239 CU_ASSERT_EQUAL(status, 0);
245 CU_ASSERT_EQUAL(status, 0);
247 CU_ASSERT_EQUAL(status, 0);
248 CU_ASSERT_STRING_EQUAL(buffer,
"ABC");
254 CU_ASSERT_EQUAL(status, -1);
275 static void TestDbLastRowId(
void)
285 CU_ASSERT_PTR_NOT_NULL(sql);
295 CU_ASSERT_EQUAL(status, 0);
298 CU_ASSERT_EQUAL(status, 0);
299 CU_ASSERT_NOT_EQUAL(first_id, 0);
302 CU_ASSERT_EQUAL(status, 0);
305 CU_ASSERT_EQUAL(status, 0);
306 CU_ASSERT_EQUAL(second_id, (first_id + 1));
316 static void TestDbCommit(
void)
324 CU_ASSERT_EQUAL(status, 0);
332 CU_ASSERT_EQUAL(status, 0);
336 CU_ASSERT_EQUAL(status, 0);
344 CU_ASSERT_EQUAL(status, 0);
347 CU_ASSERT_EQUAL(rowcount, 1);
352 static void TestDbRollback(
void)
360 CU_ASSERT_EQUAL(status, 0);
368 CU_ASSERT_EQUAL(status, 0);
376 CU_ASSERT_EQUAL(status, 0);
377 CU_ASSERT_EQUAL(rowcount, 1);
381 CU_ASSERT_EQUAL(status, 0);
385 CU_ASSERT_EQUAL(status, 0);
386 CU_ASSERT_EQUAL(rowcount, 0);
412 {
"TestDbExecuteSql", TestDbExecuteSql},
413 {
"TestDatabaseAccess", TestDatabaseAccess},
414 {
"TestDbExecuteSqlNoResult", TestDbExecuteSqlNoResult},
415 {
"TestDbIntQuery", TestDbIntQuery},
416 {
"TestDbStringBuffer", TestDbStringBuffer},
417 {
"TestDbLastRowId", TestDbLastRowId},
418 {
"TestDbCommit", TestDbCommit},
419 {
"TestDbRollback", TestDbRollback},
void DbFreeResult(DB_RESULT result)
int DbFetchRow(DB_RESULT result, DB_ROW *row)
int TcuCreateSuite(const char *title, int(*init)(), int(*teardown)(), struct test_testdef *tests)
void DqsOrderBy(char **query, const char *field)
void DqsFree(char *query)
char * DqsCountInit(const char *table)
int DbString(DB_ROW row, int field_index, char **result)
void DqsConditionInt(char **query, const char *field, DQS_COMPARISON compare, int value, int index)
int DbLastRowId(DB_HANDLE handle, DB_ID *id)
void DisAppendString(char **sql, const char *what)
void DbFreeRow(DB_ROW row)
int DbExecuteSql(DB_HANDLE handle, const char *stmt_str, DB_RESULT *result)
int DbStringBuffer(DB_ROW row, int field_index, char *buffer, size_t buflen)
int DbIntQuery(DB_HANDLE handle, int *value, const char *query)
char * DqsInit(const char *table)
char * DisInit(const char *table)
void DisAppendInt(char **sql, int what)
void DqsEnd(char **query)
int DbBeginTransaction(void)
int DbExecuteSqlNoResult(DB_HANDLE handle, const char *stmt_str)
void DqsConditionString(char **query, const char *field, DQS_COMPARISON compare, const char *value, int index)
void DbStringFree(char *string)