int main(void) {
//PRIMARY SIZE OF THE DATABASE
const int size = 4;
investorList_t * investorList = investorList_new(size);
database_t * database = database_new("investors.db");
//SIZE OF PRIMARY DATABASE
int countSize = database_getSize(database);
printf("TOTAL INVESTORS: %i\n\n", countSize);
//FILTERS FOR THE NEXT STEP
int moneyFilter = 4000000;
int projFilter = 10;
//AMOUNT OF INVESTORS FITTING FILTERS
int countFilter = database_readInvListWHERE(database, moneyFilter, projFilter, investorList);
printf("=====CONDITIONAL READ=====\nInvestors with money invested < %i OR projects invested < %i: %i\n\n", moneyFilter, projFilter, countFilter);
investorList_print(investorList);
puts("=====READ INVESTOR (BY INDEX 3)=====");
investor_t * investor = database_readInv(database, 3);
if (investor != NULL) { //CHECKING IF SUCH AN INDEX EXISTS
investor_print(investor);
}
puts("=====CREATE NEW INVESTOR=====");
investor_fillSmp(investor, "Sample", "Samploff", 5.7, 10000, 4, 2000, 3, 11);
database_createInv(database, investor);
database_readInvList(database, investorList);
investorList_print(investorList);
puts("=====UPDATE INVESTOR (BY INDEX 2)=====");
database_updateInv(database, investor, 2);
database_readInvList(database, investorList);
investorList_print(investorList);
puts("=====DELETE INVESTOR (BY INDEX 3)=====");
database_deleteInv(database, 3);
database_readInvList(database, investorList);
investorList_print(investorList);
//end of program
investor_free(investor);
investorList_free(investorList);
database_free(database);
getch();
return 0;
}
int
database_load(struct database *db, const char *path, int prot_thresh_level,
enum uproc_ecurve_format format)
{
db->fwd = db->rev = NULL;
db->idmap = NULL;
db->prot_thresh = NULL;
switch (prot_thresh_level) {
case 2:
case 3:
db->prot_thresh = uproc_matrix_load(
UPROC_IO_GZIP, "%s/prot_thresh_e%d", path, prot_thresh_level);
if (!db->prot_thresh) {
goto error;
}
break;
case 0:
break;
default:
uproc_error_msg(
UPROC_EINVAL, "protein threshold level must be 0, 2, or 3");
goto error;
}
db->idmap = uproc_idmap_load(UPROC_IO_GZIP, "%s/idmap", path);
if (!db->idmap) {
goto error;
}
db->fwd = uproc_ecurve_load(format, UPROC_IO_GZIP, "%s/fwd.ecurve", path);
if (!db->fwd) {
goto error;
}
db->rev = uproc_ecurve_load(format, UPROC_IO_GZIP, "%s/rev.ecurve", path);
if (!db->rev) {
goto error;
}
return 0;
error:
database_free(db);
return -1;
}
int main(void) {
EXCEPTION *e = exception_new();
printf ( "NEW\n" );
DATABASE *db = database_new();
database_setException(db, e);
exception_throw(e);
printf ( "PARAM\n" );
database_setHost(db, "localhost");
database_setName(db, "template1");
database_setUser(db, "postgres");
database_setPassword(db, "postgres");
printf ( "OPEN\n" );
database_open(db);
exception_throw(e);
printf ( "VERSION" );
char *ver = database_getVersion(db);
exception_throw(e);
printf ( " (%s)\n", ver );
free(ver);
printf ( "RANDOM" );
int rnd = database_getRandom(db);
exception_throw(e);
printf ( " (%d)\n", rnd );
printf ( "CLOSE\n" );
database_close(db);
exception_throw(e);
printf ( "FREE\n" );
database_free(db);
exception_throw(e);
exception_free(e);
return 0;
}
int main(void) {
EXCEPTION *e = exception_new();
printf ( "NEW\n" );
DATABASE *db = database_new();
database_setException(db, e);
exception_throw(e);
printf ( "PARAM\n" );
database_setName(db, "sqlite.db");
printf ( "OPEN\n" );
database_open(db);
exception_throw(e);
printf ( "VERSION" );
char *ver = database_getVersion(db);
exception_throw(e);
printf ( " (%s)\n", ver );
free(ver);
printf ( "RANDOM" );
int rnd = database_getRandom(db);
exception_throw(e);
printf ( " (%d)\n", rnd );
printf ( "CLOSE\n" );
database_close(db);
exception_throw(e);
printf ( "FREE\n" );
database_free(db);
exception_throw(e);
exception_free(e);
return 0;
}