Home /Modules/db-connector/test_connector.c

test_connector.c

lib/db-connector/tests/test_connector.c · 87 line(s) · c

/*
 * lib/db-connector/tests/test_connector.c
 *
 * Exercises the connector's JDBC-style lifecycle through the bundled
 * "sleelasql" driver, plus the honest-stub behaviour for external backends.
 * Usage: test-connector <db-dir>. Exit 0 = all pass.
 */
#include "sldbc.h"

#include <stdio.h>
#include <string.h>

static int fails = 0;
#define CHECK(c, m) do { if (!(c)) { printf("FAIL: %s\n", m); ++fails; } \
                         else printf("ok:   %s\n", m); } while (0)

int main(int argc, char **argv) {
  if (argc != 2) return 2;
  char url[512];
  snprintf(url, sizeof url, "sleelasql:%s", argv[1]);
  printf("sldbc version %s\n", sldbc_version());

  /* driver manager */
  CHECK(sldbc_driver_available("sleelasql"), "sleelasql driver available");
  CHECK(!sldbc_driver_available("postgresql"), "postgresql is a stub (not available)");

  sldbc_conn *c = NULL;
  CHECK(sldbc_open(url, &c) == SLDBC_OK && c, "open sleelasql connection");
  CHECK(strcmp(sldbc_driver_name(c), "sleelasql") == 0, "driver name is sleelasql");

  /* honest stub: a known external scheme is refused, not faked */
  sldbc_conn *pg = NULL;
  CHECK(sldbc_open("postgresql:localhost/db", &pg) == SLDBC_UNSUPPORTED,
        "external backend refused (UNSUPPORTED)");
  CHECK(pg == NULL, "no connection handed back for a stub");
  CHECK(sldbc_open("bogus:x", &pg) == SLDBC_ERR_NODRIVER, "unknown scheme -> NODRIVER");
  CHECK(sldbc_open("noscheme", &pg) == SLDBC_ERR_URL, "missing scheme -> URL error");

  /* DDL + DML through prepared statements */
  sldbc_stmt *s = NULL;
  CHECK(sldbc_prepare(c, "CREATE TABLE person (id, name)", &s) == SLDBC_OK, "prepare CREATE");
  CHECK(sldbc_execute(s) == SLDBC_OK, "execute CREATE");
  sldbc_finalize(s);

  /* parameterised insert (JDBC-style '?' binds) */
  CHECK(sldbc_prepare(c, "INSERT INTO person VALUES (?, ?)", &s) == SLDBC_OK, "prepare INSERT ?");
  CHECK(sldbc_bind(s, 1, "1") == SLDBC_OK, "bind id=1");
  CHECK(sldbc_bind(s, 2, "Ada") == SLDBC_OK, "bind name=Ada");
  CHECK(sldbc_execute(s) == SLDBC_OK, "execute INSERT (1,Ada)");
  sldbc_clear(s);
  CHECK(sldbc_bind(s, 1, "2") == SLDBC_OK, "bind id=2");
  CHECK(sldbc_bind(s, 2, "Linus") == SLDBC_OK, "bind name=Linus");
  CHECK(sldbc_execute(s) == SLDBC_OK, "execute INSERT (2,Linus)");
  sldbc_finalize(s);

  /* query + result set */
  CHECK(sldbc_prepare(c, "SELECT id, name FROM person", &s) == SLDBC_OK, "prepare SELECT");
  sldbc_rows *rows = NULL;
  CHECK(sldbc_query(s, &rows) == SLDBC_OK && rows, "query returns rows");
  CHECK(sldbc_rows_columns(rows) == 2, "two columns");
  CHECK(sldbc_rows_count(rows) == 2, "two rows");
  CHECK(strcmp(sldbc_rows_column_name(rows, 1), "name") == 0, "column 1 is name");
  CHECK(strcmp(sldbc_rows_value(rows, 0, 1), "Ada") == 0, "row0.name = Ada");
  CHECK(strcmp(sldbc_rows_value_named(rows, 1, "name"), "Linus") == 0, "row1.name by name = Linus");
  CHECK(sldbc_rows_value(rows, 9, 0) == NULL, "out-of-range row -> NULL");
  sldbc_rows_free(rows);
  sldbc_finalize(s);

  /* transaction: rollback undoes a write */
  CHECK(sldbc_begin(c) == SLDBC_OK, "begin txn");
  CHECK(sldbc_prepare(c, "INSERT INTO person VALUES (3, 'Temp')", &s) == SLDBC_OK, "prepare txn insert");
  CHECK(sldbc_execute(s) == SLDBC_OK, "execute txn insert");
  sldbc_finalize(s);
  CHECK(sldbc_rollback(c) == SLDBC_OK, "rollback txn");
  CHECK(sldbc_prepare(c, "SELECT COUNT(*) FROM person", &s) == SLDBC_OK, "prepare count");
  CHECK(sldbc_query(s, &rows) == SLDBC_OK, "query count");
  CHECK(strcmp(sldbc_rows_value(rows, 0, 0), "2") == 0, "rollback undid the insert (count=2)");
  sldbc_rows_free(rows);
  sldbc_finalize(s);

  sldbc_close(c);

  if (fails) { printf("\n%d test(s) FAILED\n", fails); return 1; }
  printf("\nall db-connector tests passed\n");
  return 0;
}