43 #include "CUnit/Basic.h"
58 static void TestDbExecuteSql(
void)
67 CU_ASSERT_EQUAL(status, 0);
84 static void TestDatabaseAccess(
void)
96 CU_ASSERT_EQUAL(status, 0);
106 CU_ASSERT_EQUAL(status, 0);
108 CU_ASSERT_EQUAL(status, 0);
109 CU_ASSERT_PTR_NULL(
string);
115 CU_ASSERT_EQUAL(status, 0);
117 CU_ASSERT_EQUAL(status, 0);
118 CU_ASSERT_STRING_EQUAL(
string,
"ABC");
125 CU_ASSERT_EQUAL(status, 0);
127 CU_ASSERT_EQUAL(status, 0);
128 CU_ASSERT_STRING_EQUAL(
string,
"DEF");
135 CU_ASSERT_EQUAL(status, -1);
155 static void TestDbExecuteSqlNoResult(
void)
168 CU_ASSERT_EQUAL(status, 0);
177 CU_ASSERT_EQUAL(status, 0);
180 CU_ASSERT_EQUAL(rowcount, 1);
194 static void TestDbIntQuery(
void)
209 CU_ASSERT_EQUAL(status, 0);
211 CU_ASSERT_EQUAL(rowcount, 1);
224 static void TestDbStringBuffer(
void)
237 CU_ASSERT_EQUAL(status, 0);
243 CU_ASSERT_EQUAL(status, 0);
245 CU_ASSERT_EQUAL(status, 0);
246 CU_ASSERT_STRING_EQUAL(buffer,
"ABC");
252 CU_ASSERT_EQUAL(status, -1);
273 static void TestDbLastRowId(
void)
283 CU_ASSERT_PTR_NOT_NULL(sql);
293 CU_ASSERT_EQUAL(status, 0);
296 CU_ASSERT_EQUAL(status, 0);
297 CU_ASSERT_NOT_EQUAL(first_id, 0);
300 CU_ASSERT_EQUAL(status, 0);
303 CU_ASSERT_EQUAL(status, 0);
304 CU_ASSERT_EQUAL(second_id, (first_id + 1));
314 static void TestDbCommit(
void)
322 CU_ASSERT_EQUAL(status, 0);
330 CU_ASSERT_EQUAL(status, 0);
334 CU_ASSERT_EQUAL(status, 0);
342 CU_ASSERT_EQUAL(status, 0);
345 CU_ASSERT_EQUAL(rowcount, 1);
350 static void TestDbRollback(
void)
358 CU_ASSERT_EQUAL(status, 0);
366 CU_ASSERT_EQUAL(status, 0);
374 CU_ASSERT_EQUAL(status, 0);
375 CU_ASSERT_EQUAL(rowcount, 1);
379 CU_ASSERT_EQUAL(status, 0);
383 CU_ASSERT_EQUAL(status, 0);
384 CU_ASSERT_EQUAL(rowcount, 0);
390 static void TestDbDateDiff(
void)
393 char small_buffer[16];
394 char* datetime =
"2010-01-01 12:00:00";
399 status =
DbDateDiff(datetime, deltat, 1, buffer, 128);
401 CU_ASSERT_EQUAL(status, 0);
404 CU_ASSERT_STRING_EQUAL(buffer,
"DATE_ADD('2010-01-01 12:00:00', INTERVAL 120 SECOND)");
406 CU_ASSERT_STRING_EQUAL(buffer,
"DATETIME('2010-01-01 12:00:00', '+120 SECONDS')");
410 status =
DbDateDiff(datetime, deltat, -1, buffer, 128);
412 CU_ASSERT_EQUAL(status, 0);
415 CU_ASSERT_STRING_EQUAL(buffer,
"DATE_ADD('2010-01-01 12:00:00', INTERVAL -120 SECOND)");
417 CU_ASSERT_STRING_EQUAL(buffer,
"DATETIME('2010-01-01 12:00:00', '-120 SECONDS')");
421 status =
DbDateDiff(datetime, deltat, 1, small_buffer, 16);
423 CU_ASSERT_EQUAL(status, 1);
447 {
"TestDbExecuteSql", TestDbExecuteSql},
448 {
"TestDatabaseAccess", TestDatabaseAccess},
449 {
"TestDbExecuteSqlNoResult", TestDbExecuteSqlNoResult},
450 {
"TestDbIntQuery", TestDbIntQuery},
451 {
"TestDbStringBuffer", TestDbStringBuffer},
452 {
"TestDbLastRowId", TestDbLastRowId},
453 {
"TestDbCommit", TestDbCommit},
454 {
"TestDbRollback", TestDbRollback},
455 {
"TestDbDateDiff", TestDbDateDiff},