43 #include "CUnit/Basic.h"
58 static void TestDusSetInt(
void)
70 CU_ASSERT_STRING_EQUAL(sql,
"UPDATE TEST SET ALPHA = 1");
81 CU_ASSERT_STRING_EQUAL(sql,
"UPDATE TEST SET ALPHA = 1, BETA = 2");
97 static void TestDusSetString(
void)
109 CU_ASSERT_STRING_EQUAL(sql,
"UPDATE TEST SET ALPHA = 'XYZZY'");
119 CU_ASSERT_STRING_EQUAL(sql,
"UPDATE TEST SET BETA = NULL");
130 CU_ASSERT_STRING_EQUAL(sql,
131 "UPDATE TEST SET ALPHA = 'XYZZY', BETA = NULL");
145 static void TestDusConditionInt(
void)
150 static const char* TEST =
151 "UPDATE TEST SET ALPHA = 0 WHERE ALPHA < 1 AND BETA <= 2 AND GAMMA = 3 "
152 "AND DELTA != 4 AND EPSILON >= 5 AND ZETA > 6";
164 CU_ASSERT_STRING_EQUAL(sql, TEST);
178 static void TestDusConditionString(
void)
183 static const char* TEST =
184 "UPDATE TEST SET ALPHA = 0 "
185 "WHERE ALPHA < 'PETER' AND BETA <= 'PIPER' "
186 "AND GAMMA = 'PICKED' AND DELTA != 'A' AND EPSILON >= 'PECK' "
199 CU_ASSERT_STRING_EQUAL(sql, TEST);
214 static void TestDusConditionKeyword(
void)
219 static const char* TEST =
220 "UPDATE TEST SET ALPHA = 0, BETA = 'GIMMEL' WHERE ALPHA IN (1, 2, 3) "
221 "AND BETA IN ('ALEPH', 'BETH')";
231 CU_ASSERT_STRING_EQUAL(sql, TEST);
257 {
"TestDusSetInt", TestDusSetInt},
258 {
"TestDusSetString", TestDusSetString},
259 {
"TestDusConditionInt", TestDusConditionInt},
260 {
"TestDusConditionString", TestDusConditionString},
261 {
"TestDusConditionKeyword", TestDusConditionKeyword},