ifndef _EPHOTO_DATABASE_H_
#define _EPHOTO_DATABASE_H_

#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>


sqlite3 *ephoto_db_init(void);
//constructor
void ephoto_db_destroy(sqlite3 *);
//destructor

int ephoto_db_add_album(sqlite3 *,char []);
//create a new album
//(db,"albumanme")
//returns 1 on failure
int ephoto_db_add_file(sqlite3 *,char [], char []);
//add a thumb to an album
//(db,"albumname","/path/to/thumb")
//returns 1 on failure
int ephoto_db_remove_album(sqlite3 *,char *);
//remove an album from the database
//will dissasociate all files with it
//(db,"albumanme")
//returns 1 on failure
int ephoto_db_remove_file(sqlite3 *,char *,char *);
//dissasociate a file from a specific album or "ALL"
//(db,"albumanme","/path/to/file")
//pass albumname = "ALL" to dissasociate a file from all albums, removing all knowlege of it from the database
//returns 1 on failure
Ecore_List ephoto_db_read(sqlite3 *);

#endif