int main ( ) {
/* Create MySQL object */
MySQL sql;
/* Open Database */
std::cout << "Connecting to 'localhost' using 'test' database" << std::endl;
assert ( sql.connect ( "localhost", "root", "blue23", "test" ) == true );
std::cout << "Opening was successful" << std::endl;
/* Create a table */
std::cout << "Creating table tbl1 (one int, two int)" << std::endl;
assert ( sql.exec ( "create table tbl1 (one int, two int);" ) == 1 );
std::cout << "Created table tbl1" << std::endl;
/* Insert values */
std::cout << "Insert values ( 10, 10 ) into tbl1" << std::endl;
assert ( sql.exec ( "insert into tbl1 (one, two) VALUES ( 10, 10 )" ) == 1 );
std::cout << "Inserted values successfully" << std::endl;
/* Query values */
std::cout << "Query values to make sure of integraty" << std::endl;
assert ( sql.query ( "select * from tbl1" ) == 1);
std::cout << "Query was successful" << std::endl;
/* Integraty of values */
std::cout << "Checking to see if query returned results" << std::endl;
assert ( sql.hasNext ( ) );
std::cout << "Results were returned" << std::endl;
/* Check to see that we get a total of two columns ( one, two ) from query */
std::cout << "Checking to see if a record has two entries ( one, two )" << std::endl;
std::vector<std::string> l = sql.next ( );
assert( l.size() == 2 );
std::cout << "Integraty was achieved for record count" << std::endl;
/* Check Integraty of inserted row ( 10, 10 ) */
std::cout << "Checking to see one = 10" << std::endl;
assert( l[0].compare ( "10" ) == 0 );
std::cout << "Checking to see two = 10" << std::endl;
assert( l[1].compare ( "10" ) == 0 );
/* Clear out values */
std::cout << "Clearing values from database" << std::endl;
assert ( sql.query ( "delete from tbl1" ) == 1 );
std::cout << "Database values were cleared" << std::endl;
/* Remove table */
std::cout << "Removing table tbl1 from database" << std::endl;
assert ( sql.query ( "DROP TABLE IF EXISTS tbl1" ) == 1);
std::cout << "Table tbl1 was removed from database" << std::endl;
/* Close database */
std::cout << "Database attempting to close" << std::endl;
sql.disconnect ();
std::cout << "Database closed" << std::endl;
/* Closing statements */
std::cout << "Finished unit testing :D" << std::endl;
return 1;
};
MySQL* ConnectionPool::init_connect() {
MySQL *query = new MySQL();
if (!query->init()) {
printf("!query->init()\n");
return NULL;
}
if (!query->connect("127.0.0.1", "root", "", "sitev")) {
printf("!query->connect()\n");
return NULL;
}
query->exec("SET NAMES utf8");
return query;
}
