Hey,
I have been working on this database handler a
while, and then for some reason I ended up having to
restore my whole /usr directory from a previous date,
because I was having problems with Wt/Boost. Now I run
the same code that previously created tables, I even
get a message that its rolling back and to the
existing tables, but they do not exist. Im getting
really frustrated here. Anyone have any idea whats up
with this?
Here is the code from my dbhandler:
dbo::SqlConnectionPool *dbHandler::createConnectionPool(const std::string db, const std::string dbuser, const std::string dbpasswd,<
span style=" color:#c0c0c0;"> const std::string dbhost, unsigned int dbport)
{
dbo::backend::MySQL *connection = new dbo::backend::MySQL(db, dbuser, dbpasswd, dbhost, dbport); //"sre_db", "root", "Hioa_2014", "127.0.0.1", 3306
connection->setProperty("show-queries", "true");
return new dbo::FixedSqlConnectionPool(connection, 10);
}
dbHandler::dbHandler(dbo::SqlConnectionPool& connectionPool)
: connectionPool_(connectionPool)
{
setConnectionPool(connectionPool);
std::cout << " lag tabeller " << std::endl;
mapClass<gsa_table>("gsa_table");
mapClass<gga_table>("gga_table");
mapClass<average_gga_table>("average_gga_table");
mapClass<average_gsa_table>("average_gsa_table");
mapClass<jobDataT>("jobdataT");
mapClass<pointDataT>("pointdataT");
try {
createTables();
Wt::log("info") << "Database created";
} catch (Wt::Dbo::Exception &) {
Wt::log("info") << "Using existing database";
}
}
And in main I run:
Wt::Dbo::SqlConnectionPool *connPool
= dbHandler::createConnectionPool("sre_db", "root", «Password", "127.0.0.1", 3306);
dbHandler * db = new dbHandler(*connPool);
And this is the pleasant message I get when I run this:
rollback
Using existing database
/Users/taf/Dropbox/qt/DbHandler/build/DbHandler exited with code 0
My current main is just a lot of testing out different methods, but just about everything is commented out at this point.
Best regards,
Tor
