Home /Modules/sleela-sql/test_c.c

test_c.c

lib/sleela-sql/tests/test_c.c · 70 line(s) · c

#include "sleela_sql.h"
#include <stdio.h>
#include <string.h>
int main(int argc, char **argv) {
    if (argc != 2) return 2;
    ssql_db db;
    if (ssql_open(&db, argv[1]) != SSQL_OK) return 3;
    if (ssql_exec(&db, "CREATE TABLE items (id, name)", NULL) != SSQL_OK) return 4;
    if (ssql_exec(&db, "INSERT INTO items VALUES (1, 'alpha')", NULL) != SSQL_OK) return 5;
    if (ssql_exec(&db, "CREATE TABLE IF NOT EXISTS items (id, name)", NULL) != SSQL_OK) return 10;
    if (ssql_exec(&db, "CREATE TABLE ../escape (x)", NULL) != SSQL_ERR_SYNTAX) return 9;
    FILE *out = tmpfile();
    if (!out) return 6;
    ssql_status status = ssql_exec(&db, "SELECT name FROM items WHERE id = 1", out);
    if (status != SSQL_OK) { fclose(out); return 7; }
    rewind(out);
    char line[128];
    int ok = fgets(line, sizeof line, out) != NULL;
    fclose(out);
    if (!ok) return 8;
    if (ssql_exec(&db, "ALTER TABLE items ADD COLUMN category DEFAULT 'general'", NULL) != SSQL_OK) return 19;
    if (ssql_exec(&db, "ALTER TABLE items ADD COLUMN category", NULL) != SSQL_ERR_DUPCOL) return 20;
    out = tmpfile();
    if (!out) return 21;
    status = ssql_exec(&db, "SELECT category FROM items WHERE id = 1", out);
    rewind(out);
    char alter_header[128], alter_value[128];
    int alter_ok = status == SSQL_OK &&
                   fgets(alter_header, sizeof alter_header, out) != NULL &&
                   fgets(alter_value, sizeof alter_value, out) != NULL &&
                   strcmp(alter_value, "general\n") == 0;
    fclose(out);
    if (!alter_ok) return 22;
    out = tmpfile();
    if (!out) return 11;
    status = ssql_exec(&db, "SELECT COUNT(*) FROM items WHERE id = 1", out);
    rewind(out);
    char header[128], count[128];
    int count_ok = status == SSQL_OK && fgets(header, sizeof header, out) != NULL &&
                   fgets(count, sizeof count, out) != NULL && strcmp(count, "1\n") == 0;
    fclose(out);
    if (!count_ok) return 12;

    if (ssql_exec(&db, "UPDATE items SET name = 'gamma' WHERE id = 1", NULL) != SSQL_OK) return 13;
    out = tmpfile();
    if (!out) return 14;
    status = ssql_exec(&db, "SELECT name FROM items WHERE id = 1", out);
    rewind(out);
    char updated_header[128], updated_value[128];
    int update_ok = status == SSQL_OK &&
                    fgets(updated_header, sizeof updated_header, out) != NULL &&
                    fgets(updated_value, sizeof updated_value, out) != NULL &&
                    strcmp(updated_value, "gamma\n") == 0;
    fclose(out);
    if (!update_ok) return 15;

    if (ssql_exec(&db, "DELETE FROM items WHERE id = 1", NULL) != SSQL_OK) return 16;
    out = tmpfile();
    if (!out) return 17;
    status = ssql_exec(&db, "SELECT COUNT(*) FROM items", out);
    rewind(out);
    char delete_header[128], delete_count[128];
    int delete_ok = status == SSQL_OK &&
                    fgets(delete_header, sizeof delete_header, out) != NULL &&
                    fgets(delete_count, sizeof delete_count, out) != NULL &&
                    strcmp(delete_count, "0\n") == 0;
    fclose(out);
    return delete_ok ? 0 : 18;
}