/* libdatabase_database_new */ static PyObject * _libdatabase_database_new(PyObject * self, PyObject * args) { Database * database; char const * engine; char const * section; if(!PyArg_ParseTuple(args, "ss", &engine, §ion)) return NULL; /* FIXME obtain the Config object */ if((database = database_new(engine, config_new(), section)) == NULL) return NULL; return PyCapsule_New(database, _libdatabase_database_name, _libdatabase_database_delete); }
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 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; }