db.h

Go to the documentation of this file.

/*
 * Prompt Workbench Core - Database Layer
 * Copyright (c) 2025 nnlazaro
 * 
 * This file is part of Prompt Workbench Core, licensed under the
 * Educational and Non-Commercial Use License.
 * See LICENSE file for details.
 * 
 * FOR EDUCATIONAL USE ONLY - NOT FOR PRODUCTION OR COMMERCIAL USE
 */
 
#ifndef DB_H
#define DB_H
 
#ifdef __cplusplus
extern "C" {
#endif
 
/* ==========================================================================
 * Database entity structures
 * ========================================================================== */
 
typedef struct {
    int id;
    char* title;
    char* description;
    char* system_prompt;
    char* model;
} TestSuite;
 
typedef struct {
    int id;
    char* prompt;
    int test_suite_id;
} UserPrompt;
 
/* ==========================================================================
 * Database lifecycle functions
 * ========================================================================== */
 
int db_init(const char* db_path);
 
void db_close(void);
 
/* ==========================================================================
 * Test Suite CRUD operations
 * ========================================================================== */
 
int db_create_test_suite(const char* title, const char* description, 
                         const char* system_prompt, const char* model);
 
TestSuite* db_get_test_suite(int id);
 
TestSuite** db_get_all_test_suites(int* count);
 
int db_update_test_suite(int id, const char* title, const char* description,
                         const char* system_prompt, const char* model);
 
int db_delete_test_suite(int id);
 
void db_free_test_suite(TestSuite* suite);
 
void db_free_test_suites(TestSuite** suites, int count);
 
/* ==========================================================================
 * User Prompt CRUD operations
 * ========================================================================== */
 
int db_create_user_prompt(const char* prompt, int test_suite_id);
 
UserPrompt* db_get_user_prompt(int id);
 
UserPrompt** db_get_user_prompts_by_suite(int test_suite_id, int* count);
 
UserPrompt** db_get_all_user_prompts(int* count);
 
int db_update_user_prompt(int id, const char* prompt, int test_suite_id);
 
int db_delete_user_prompt(int id);
 
void db_free_user_prompt(UserPrompt* prompt);
 
void db_free_user_prompts(UserPrompt** prompts, int count);
 
#ifdef __cplusplus
}
#endif
 
#endif /* DB_H */