#include "../lib/client.h" #include "../lib/heap.h" #include "../lib/runner.h" #include "../lib/server.h" #include "../lib/sqlite.h" #ifndef FLAKY /****************************************************************************** * * Handle client requests * ******************************************************************************/ SUITE(client); struct fixture { struct test_server server; struct client_proto *client; }; static void *setUp(const MunitParameter params[], void *user_data) { struct fixture *f = munit_malloc(sizeof *f); (void)user_data; test_heap_setup(params, user_data); test_sqlite_setup(params); test_server_setup(&f->server, 1, params); test_server_start(&f->server, params); f->client = test_server_client(&f->server); HANDSHAKE; OPEN; return f; } static void tearDown(void *data) { struct fixture *f = data; test_server_tear_down(&f->server); test_sqlite_tear_down(); test_heap_tear_down(data); free(f); } TEST(client, exec, setUp, tearDown, 0, NULL) { struct fixture *f = data; uint32_t stmt_id; uint64_t last_insert_id; uint64_t rows_affected; (void)params; PREPARE("CREATE TABLE test (n INT)", &stmt_id); EXEC(stmt_id, &last_insert_id, &rows_affected); return MUNIT_OK; } TEST(client, execWithOneParam, setUp, tearDown, 0, NULL) { struct fixture *f = data; uint32_t stmt_id; uint64_t last_insert_id; uint64_t rows_affected; struct value param = {0}; int rv; (void)params; PREPARE("CREATE TABLE test (n INT)", &stmt_id); EXEC(stmt_id, &last_insert_id, &rows_affected); PREPARE("INSERT INTO test (n) VALUES(?)", &stmt_id); param.type = SQLITE_INTEGER; param.integer = 17; rv = clientSendExec(f->client, stmt_id, ¶m, 1, NULL); munit_assert_int(rv, ==, 0); rv = clientRecvResult(f->client, &last_insert_id, &rows_affected, NULL); munit_assert_int(rv, ==, 0); return MUNIT_OK; } TEST(client, execSql, setUp, tearDown, 0, NULL) { struct fixture *f = data; uint64_t last_insert_id; uint64_t rows_affected; (void)params; EXEC_SQL("CREATE TABLE test (n INT)", &last_insert_id, &rows_affected); return MUNIT_OK; } TEST(client, query, setUp, tearDown, 0, NULL) { struct fixture *f = data; uint32_t stmt_id; uint64_t last_insert_id; uint64_t rows_affected; unsigned i; struct rows rows; (void)params; PREPARE("CREATE TABLE test (n INT)", &stmt_id); EXEC(stmt_id, &last_insert_id, &rows_affected); PREPARE("BEGIN", &stmt_id); EXEC(stmt_id, &last_insert_id, &rows_affected); PREPARE("INSERT INTO test (n) VALUES(123)", &stmt_id); for (i = 0; i < 256; i++) { EXEC(stmt_id, &last_insert_id, &rows_affected); } PREPARE("COMMIT", &stmt_id); EXEC(stmt_id, &last_insert_id, &rows_affected); PREPARE("SELECT n FROM test", &stmt_id); QUERY(stmt_id, &rows); clientCloseRows(&rows); return MUNIT_OK; } TEST(client, querySql, setUp, tearDown, 0, NULL) { struct fixture *f = data; uint32_t stmt_id; uint64_t last_insert_id; uint64_t rows_affected; unsigned i; struct rows rows; (void)params; EXEC_SQL("CREATE TABLE test (n INT)", &last_insert_id, &rows_affected); EXEC_SQL("BEGIN", &last_insert_id, &rows_affected); PREPARE("INSERT INTO test (n) VALUES(123)", &stmt_id); for (i = 0; i < 256; i++) { EXEC(stmt_id, &last_insert_id, &rows_affected); } EXEC_SQL("COMMIT", &last_insert_id, &rows_affected); QUERY_SQL("SELECT n FROM test", &rows); clientCloseRows(&rows); return MUNIT_OK; } #endif /* not FLAKY */