#include "db.h"
#include <sqlite3.h>
#include <stdlib.h>
#include <stdio.h>
#include <string.h>

Include dependency graph for db.c:

Functions
int	db_init (const char *db_path)
	Initialize the database.

void	db_close (void)
	Close the database connection and release any resources.

int	db_create_test_suite (const char title, const char description, const char system_prompt, const char model)
	Create a new test suite.

TestSuite *	db_get_test_suite (int id)
	Retrieve a test suite by ID.

TestSuite **	db_get_all_test_suites (int *count)
	Retrieve all test suites.

int	db_update_test_suite (int id, const char title, const char description, const char system_prompt, const char model)
	Update an existing test suite.

int	db_delete_test_suite (int id)
	Delete a test suite (cascading deletes associated user prompts).

void	db_free_test_suite (TestSuite *suite)
	Free a TestSuite structure.

void	db_free_test_suites (TestSuite **suites, int count)
	Free an array of TestSuite structures.

int	db_create_user_prompt (const char *prompt, int test_suite_id)
	Create a new user prompt associated with a test suite.

UserPrompt *	db_get_user_prompt (int id)
	Retrieve a user prompt by ID.

UserPrompt **	db_get_user_prompts_by_suite (int test_suite_id, int *count)
	Retrieve all user prompts for a specific test suite.

UserPrompt **	db_get_all_user_prompts (int *count)
	Retrieve all user prompts.

int	db_update_user_prompt (int id, const char *prompt, int test_suite_id)
	Update an existing user prompt.

int	db_delete_user_prompt (int id)
	Delete a user prompt.

void	db_free_user_prompt (UserPrompt *prompt)
	Free a UserPrompt structure.

void	db_free_user_prompts (UserPrompt **prompts, int count)
	Free an array of UserPrompt structures.

Variables
static sqlite3 *	db = NULL

static const char *	CREATE_TABLES_SQL

Function Documentation

◆ db_close()

void db_close ( void )

Close the database connection and release any resources.

Definition at line 76 of file db.c.

References db.

◆ db_create_test_suite()

int db_create_test_suite	(	const char *	title,
		const char *	description,
		const char *	system_prompt,
		const char *	model
	)

Create a new test suite.

Parameters

title	Test suite title
description	Test suite description
system_prompt	System prompt for the test suite
model	Model name to use

Returns: The ID of the newly created test suite, or -1 on error

Definition at line 85 of file db.c.

References db.

◆ db_create_user_prompt()

int db_create_user_prompt	(	const char *	prompt,
		int	test_suite_id
	)

Create a new user prompt associated with a test suite.

Parameters

prompt	The text of the user prompt
test_suite_id	ID of the test suite this prompt belongs to

Returns: The ID of the newly created prompt, or -1 on error

Definition at line 325 of file db.c.

References db.

◆ db_delete_test_suite()

int db_delete_test_suite ( int id )

Delete a test suite (cascading deletes associated user prompts).

Parameters

id	The test suite ID

Returns: 0 on success, -1 on error

Definition at line 277 of file db.c.

References db.

◆ db_delete_user_prompt()

int db_delete_user_prompt ( int id )

Delete a user prompt.

Parameters

id	The user prompt ID

Returns: 0 on success, -1 on error

Definition at line 553 of file db.c.

References db.

◆ db_free_test_suite()

void db_free_test_suite ( TestSuite * suite )

Free a TestSuite structure.

Parameters

suite Pointer to the test suite to free

Definition at line 304 of file db.c.

References TestSuite::description, TestSuite::model, TestSuite::system_prompt, and TestSuite::title.

Referenced by db_free_test_suites().

Here is the caller graph for this function:

◆ db_free_test_suites()

void db_free_test_suites	(	TestSuite **	suites,
		int	count
	)

Free an array of TestSuite structures.

Parameters

suites	Array of TestSuite pointers
count	Number of elements in the array

Definition at line 314 of file db.c.

References db_free_test_suite().

Referenced by db_get_all_test_suites().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ db_free_user_prompt()

void db_free_user_prompt ( UserPrompt * prompt )

Free a UserPrompt structure.

Parameters

prompt Pointer to the user prompt to free

Definition at line 580 of file db.c.

References UserPrompt::prompt.

Referenced by db_free_user_prompts().

Here is the caller graph for this function:

◆ db_free_user_prompts()

void db_free_user_prompts	(	UserPrompt **	prompts,
		int	count
	)

Free an array of UserPrompt structures.

Parameters

prompts	Array of UserPrompt pointers
count	Number of elements in the array

Definition at line 587 of file db.c.

References db_free_user_prompt().

Referenced by db_get_all_user_prompts(), and db_get_user_prompts_by_suite().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ db_get_all_test_suites()

TestSuite ** db_get_all_test_suites ( int * count )

Retrieve all test suites.

Parameters

count Output parameter receiving the number of test suites returned

Returns: Array of dynamically allocated pointers to TestSuite (caller must free using db_free_test_suites), or NULL on error

Definition at line 156 of file db.c.

References db, db_free_test_suites(), TestSuite::description, TestSuite::id, TestSuite::model, TestSuite::system_prompt, and TestSuite::title.

Here is the call graph for this function:

◆ db_get_all_user_prompts()

UserPrompt ** db_get_all_user_prompts ( int * count )

Retrieve all user prompts.

Parameters

count Output parameter receiving the number of user prompts returned

Returns: Array of dynamically allocated UserPrompt pointers (caller must free using db_free_user_prompts), or NULL on error

Definition at line 451 of file db.c.

References db, db_free_user_prompts(), UserPrompt::id, UserPrompt::prompt, and UserPrompt::test_suite_id.

Here is the call graph for this function:

◆ db_get_test_suite()

TestSuite * db_get_test_suite ( int id )

Retrieve a test suite by ID.

Parameters

id	The test suite ID

Returns: Pointer to a dynamically allocated TestSuite (caller must free using db_free_test_suite), or NULL on error

Definition at line 117 of file db.c.

References db, TestSuite::description, TestSuite::id, TestSuite::model, TestSuite::system_prompt, and TestSuite::title.

◆ db_get_user_prompt()

UserPrompt * db_get_user_prompt ( int id )

Retrieve a user prompt by ID.

Parameters

id	The user prompt ID

Returns: Pointer to a dynamically allocated UserPrompt (caller must free using db_free_user_prompt), or NULL on error

Definition at line 353 of file db.c.

References db, UserPrompt::id, UserPrompt::prompt, and UserPrompt::test_suite_id.

◆ db_get_user_prompts_by_suite()

UserPrompt ** db_get_user_prompts_by_suite	(	int	test_suite_id,
		int *	count
	)

Retrieve all user prompts for a specific test suite.

Parameters

test_suite_id	The test suite ID
count	Output parameter receiving the number of user prompts returned

Returns: Array of dynamically allocated UserPrompt pointers (caller must free using db_free_user_prompts), or NULL on error

Definition at line 389 of file db.c.

References db, db_free_user_prompts(), UserPrompt::id, UserPrompt::prompt, and UserPrompt::test_suite_id.

Here is the call graph for this function:

◆ db_init()

int db_init ( const char * db_path )

Initialize the database.

Creates the database file if it does not exist and sets up required tables.

Parameters

db_path Path to the database file

Returns: 0 on success, -1 on error

Definition at line 35 of file db.c.

References CREATE_TABLES_SQL, and db.

◆ db_update_test_suite()

int db_update_test_suite	(	int	id,
		const char *	title,
		const char *	description,
		const char *	system_prompt,
		const char *	model
	)

Update an existing test suite.

Parameters

id	The test suite ID
title	New title (NULL to leave unchanged)
description	New description (NULL to leave unchanged)
system_prompt	New system prompt (NULL to leave unchanged)
model	New model (NULL to leave unchanged)

Returns: 0 on success, -1 on error

Definition at line 218 of file db.c.

References db.

◆ db_update_user_prompt()

int db_update_user_prompt	(	int	id,
		const char *	prompt,
		int	test_suite_id
	)

Update an existing user prompt.

Parameters

id	The user prompt ID
prompt	New prompt text (NULL to leave unchanged)
test_suite_id	New test suite ID (0 or negative to leave unchanged)

Returns: 0 on success, -1 on error

Definition at line 511 of file db.c.

References db.

Variable Documentation

◆ CREATE_TABLES_SQL

const char* CREATE_TABLES_SQL

static

Initial value:

= 
    "CREATE TABLE IF NOT EXISTS test_suites ("
    "    id INTEGER PRIMARY KEY AUTOINCREMENT,"
    "    title TEXT NOT NULL,"
    "    description TEXT,"
    "    system_prompt TEXT NOT NULL,"
    "    model TEXT NOT NULL"
    ");"
    "CREATE TABLE IF NOT EXISTS user_prompts ("
    "    id INTEGER PRIMARY KEY AUTOINCREMENT,"
    "    prompt TEXT NOT NULL,"
    "    test_suite_id INTEGER NOT NULL,"
    "    FOREIGN KEY (test_suite_id) REFERENCES test_suites(id) ON DELETE CASCADE"
    ");"

Definition at line 20 of file db.c.

Referenced by db_init().

◆ db

sqlite3* db = NULL

static

Definition at line 18 of file db.c.

Referenced by db_close(), db_create_test_suite(), db_create_user_prompt(), db_delete_test_suite(), db_delete_user_prompt(), db_get_all_test_suites(), db_get_all_user_prompts(), db_get_test_suite(), db_get_user_prompt(), db_get_user_prompts_by_suite(), db_init(), db_update_test_suite(), and db_update_user_prompt().

Functions

Variables

Function Documentation

◆ db_close()

◆ db_create_test_suite()

◆ db_create_user_prompt()

◆ db_delete_test_suite()

◆ db_delete_user_prompt()

◆ db_free_test_suite()

◆ db_free_test_suites()

◆ db_free_user_prompt()

◆ db_free_user_prompts()

◆ db_get_all_test_suites()

◆ db_get_all_user_prompts()

◆ db_get_test_suite()

◆ db_get_user_prompt()

◆ db_get_user_prompts_by_suite()

◆ db_init()

◆ db_update_test_suite()

◆ db_update_user_prompt()

Variable Documentation

◆ CREATE_TABLES_SQL

◆ db