database.c File Reference

#include "database.h"
#include "key_derivation.h"
#include <sqlite3.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <stdbool.h>
#include <sodium.h>

Include dependency graph for database.c:

Functions
static int	initialize_schema ()
int	database_open (const char *db_path, const char *password)
	Opens and initializes the database.
void	database_close ()
	Closes the database.
PasswordEntry *	database_get_all_entries (int *count)
	Retrieves all password entries from the database.
PasswordEntry *	database_search (const char *query, int *count)
	Searches for password entries by service or username.
PasswordEntry *	database_get_entry_by_identity (const char *service, const char *username)
	Retrieves a password entry by its identity (Service + Username).
PasswordEntry *	database_get_entry_secure (int id)
	Retrieves a single password entry with ALL details (including secrets) by ID.
int	database_add_entry (const PasswordEntry *entry)
	Adds a new password entry to the database.
int	database_update_entry (const PasswordEntry *entry)
	Updates an existing password entry in the database.
int	database_delete_entry (int id)
	Deletes a password entry from the database by its ID.
void	free_password_entries (PasswordEntry *entries, int count)
	Frees a list of PasswordEntry structs.
int	database_rekey (const char *new_password)
	Changes the master password of the database.

Variables
static sqlite3 *	db = NULL
static char	current_db_path [4096] = {0}

Function Documentation

database_add_entry()

int database_add_entry

(

const PasswordEntry *

entry

)

Adds a new password entry to the database.

Parameters

entry

A pointer to the PasswordEntry to add.

Returns

The ID of the new entry, or -1 on error.

database_close()

void database_close

(

)

Closes the database.

database_delete_entry()

int database_delete_entry

(

int

id

)

Deletes a password entry from the database by its ID.

Parameters

id	The ID of the entry to delete.

Returns

0 on success, -1 on error.

database_get_all_entries()

PasswordEntry * database_get_all_entries

(

int *

count

)

Retrieves all password entries from the database.

Parameters

count

A pointer to an integer that will be filled with the number of entries.

Returns

A dynamically allocated array of PasswordEntry structs. The caller is responsible for freeing this array and its contents using free_password_entries().

database_get_entry_by_identity()

PasswordEntry * database_get_entry_by_identity	(	const char *	service,
		const char *	username )

Retrieves a password entry by its identity (Service + Username).

Parameters

service	The name of the service.
username	The username for the service.

Returns

A dynamically allocated PasswordEntry struct containing full details, or NULL if not found.

database_get_entry_secure()

PasswordEntry * database_get_entry_secure

(

int

id

)

Retrieves a single password entry with ALL details (including secrets) by ID.

Parameters

id	The ID of the entry to retrieve.

Returns

A dynamically allocated PasswordEntry struct containing full details, or NULL if not found/error. The caller is responsible for freeing this struct using free_password_entry() (to be added) or manual free.

database_open()

int database_open	(	const char *	db_path,
		const char *	password )

Opens and initializes the database.

Parameters

db_path	The path to the database file.
password	The master password for the database.

Returns

0 on success, -1 on error.

database_rekey()

int database_rekey

(

const char *

new_password

)

Changes the master password of the database.

Parameters

new_password

The new master password.

Returns

0 on success, -1 on error.

database_search()

PasswordEntry * database_search	(	const char *	query,
		int *	count )

Searches for password entries by service or username.

Parameters

query	The search query string.
count	A pointer to an integer that will be filled with the number of entries.

Returns

A dynamically allocated array of PasswordEntry structs. The caller is responsible for freeing this array and its contents using free_password_entries().

database_update_entry()

int database_update_entry

(

const PasswordEntry *

entry

)

Updates an existing password entry in the database.

Parameters

entry

A pointer to the PasswordEntry to update.

Returns

0 on success, -1 on error.

free_password_entries()

void free_password_entries	(	PasswordEntry *	entries,
		int	count )

Frees a list of PasswordEntry structs.

Parameters

entries	The array of PasswordEntry structs to free.
count	The number of entries in the array.

initialize_schema()

int initialize_schema ( )

static

Variable Documentation

current_db_path

char current_db_path[4096] = {0}

static

db

sqlite3* db = NULL

static