public void test_startAndStopMySqlService()
 {
     Services_OunceV6.stopService_MySql();
     Assert.That(Services_OunceV6.isRunning_MySql() == false, "isRunning_MySql() was true");
     Services_OunceV6.startService_MySql();
     Assert.That(Services_OunceV6.isRunning_MySql(), "isRunning_MySql() was false;");
 }
        public void test_connectToDatabase()
        {
            Services_OunceV6.startService_MySql();
            // check that the connection is working
            Assert.That(OunceMySql.isConnectionOpen());

            // load config and recheck connectoin
            MySqlConfig.setMySqlConnectionDetailsFromAppConfig();
            Assert.That(OunceMySql.refreshDbConnection());
            Assert.That(OunceMySql.isConnectionOpen());
            // set up a bad pwd
            OunceMySql.MySqlLoginUsername = "******";
            Assert.That(false == OunceMySql.refreshDbConnection());

            // reload config and recheck connection
            MySqlConfig.setMySqlConnectionDetailsFromAppConfig();
            Assert.That(OunceMySql.refreshDbConnection());
        }