bool FileRecord::verify(void) {
// Performing various kinds of verifications
std::string dbpath = basepath_ + G_DIR_SEPARATOR_S + FR_DB_NAME;
{
Db db_test(NULL,DB_CXX_NO_EXCEPTIONS);
if(!dberr("Error verifying databases",
db_test.verify(dbpath.c_str(),NULL,NULL,DB_NOORDERCHK))) {
if(error_num_ != ENOENT) return false;
};
};
{
Db db_test(NULL,DB_CXX_NO_EXCEPTIONS);
if(!dberr("Error verifying database 'meta'",
db_test.verify(dbpath.c_str(),"meta",NULL,DB_ORDERCHKONLY))) {
if(error_num_ != ENOENT) return false;
};
};
// Skip 'link' - it is not of btree kind
// Skip 'lock' - for unknown reason it returns DB_NOTFOUND
// Skip 'locked' - for unknown reason it returns DB_NOTFOUND
return true;
}
void db_flag(sqlite3 * db, int * create_flag, int * test_flag
, char * pTable_name)
{
if(create_flag)
{
if(*test_flag)
{
db_test(db, pTable_name, &test_flag);
}
}
return;
}
int main()
{
db_connect db_test(USERNAME, PASSWD, DB);
// std::cout<<mysql_get_client_info()<<std::endl;
db_test.mysql_connect();
std::string sql = "select * from students";
//std::string insert_sql = "insert into bit_student_tbl ( student_name, student_age, student_school, register_time) values ('AAA', 20, 'xxy', NOW())";
std::string insert_sql = "INSERT INTO students(name, sex, age, school)VALUES ('haha', 'm', 19, 'qinghua')";
// std::cout<<insert_sql<<std::endl;
db_test.mysql_operator(insert_sql);
db_test.mysql_operator(sql);
db_test.mysql_show_table();
return 0;
}
/*
* Load a specified database driver and bind its functions
*/
int db_init(config_t *set) {
lt_dlhandle dbhandle;
/* initialize libtool */
if (lt_dlinit() > 0)
return FALSE;
dbhandle = lt_dlopen(set->dbdriver);
if (dbhandle == NULL) {
fatal("Couldn't load database driver %s: %s\n", set->dbdriver,(char *) lt_dlerror());
return FALSE;
} else {
debug(LOW, "Loaded database driver %s\n", set->dbdriver);
}
/*
* load the dbi functions from the library and bind them to local functions
* the function defs are in rtgdbi.h
*/
if ((db_test = lt_dlsym(dbhandle, "__db_test")) == NULL) {
debug(LOW, "Couldn't load db_test: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_status = lt_dlsym(dbhandle, "__db_status")) == NULL) {
debug(LOW, "Couldn't load db_status: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_connect = lt_dlsym(dbhandle, "__db_connect")) == NULL) {
debug(LOW, "Couldn't load db_connect: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_disconnect = lt_dlsym(dbhandle, "__db_disconnect")) == NULL) {
debug(LOW, "Couldn't load db_disconnect: %s\n",(char *) lt_dlerror());
return FALSE;
}
/*
if ((db_commit= lt_dlsym(dbhandle, "__db_commit")) == NULL) {
debug(LOW, "Couldn't load db_commit: %s\n",(char *) lt_dlerror());
return FALSE;
}
*/
if ((db_insert = lt_dlsym(dbhandle, "__db_insert")) == NULL) {
debug(LOW, "Couldn't load db_insert: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_lookup_oid = lt_dlsym(dbhandle, "__db_lookup_oid")) == NULL) {
debug(LOW, "Couldn't load db_lookup_oid: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_escape_string = lt_dlsym(dbhandle, "__db_escape_string")) == NULL) {
debug(LOW, "Couldn't load db_escape_string: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_check_and_create_data_table = lt_dlsym(dbhandle, "__db_check_and_create_data_table")) == NULL) {
debug(LOW, "Couldn't load db_check_and_create_data_table: %s\n",(char *) lt_dlerror());
return FALSE;
}
if ((db_check_and_create_oids_table = lt_dlsym(dbhandle, "__db_check_and_create_oids_table")) == NULL) {
debug(LOW, "Couldn't load db_check_and_create_oids_table: %s\n",(char *) lt_dlerror());
return FALSE;
}
db_test();
return TRUE;
}
