public void MySQLDatabaseHandlerOpenConnectionTest()
{
MySQLDatabaseHandler handler = new MySQLDatabaseHandler(server, database, username, password);
DbConnection con = handler.OpenConnection();
Assert.IsNotNull(con);
handler.CloseConnection();
}
public void MySQLDatabaseHandlerCloseConnectionTest()
{
MySQLDatabaseHandler handler = new MySQLDatabaseHandler(server, database, username, password);
DbConnection con = handler.OpenConnection();
bool sucess = handler.CloseConnection();
Assert.IsTrue(sucess);
}
public BlackboardDatabaseConnector(MySQLDatabaseHandler rHandler, string vTableName)
{
tblName = vTableName;
tableCreationQuery = "CREATE TABLE IF NOT EXISTS `" + vTableName + "` (`id` int(15) NOT NULL AUTO_INCREMENT,`from` int(5) NOT NULL, `to` int(5) NOT NULL,`type` int(5) NOT NULL,`message` text NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
if (rHandler == null)
{
throw new ArgumentException("DatabaseHandler has to be != null!!");
}
conn = rHandler;
}
public void MySQLDatabaseHandlerConstructorTest()
{
MySQLDatabaseHandler handler = new MySQLDatabaseHandler(server, database, username, password);
Assert.IsNotNull(handler);
}
