public void ConnectionStringWebTest() { string connectionsExmaple = "server=serverName;database=Northwind;persistsecurityinfo=True;User ID=userName;Password=password"; string value = MySqlDatabase.ConnectionString(connectionsExmaple, out _); General.HasValue(value, _errOut); }
public void ValueExistsTests() { string sql = "select * from `DB_Version`"; string connString = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut); bool value = MySqlDatabase.ValueExists(connString, sql, out _errOut); General.HasTrueValue(value, _errOut); }
public void TestMethod_RunQuery() { string sql = "CREATE TABLE `DB_Version` (`ID` int(11) NOT NULL AUTO_INCREMENT,`verNo` varchar(45) DEFAULT NULL,`dtUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(`ID`), UNIQUE KEY `ID_UNIQUE` (`ID`)) ENGINE = MyISAM AUTO_INCREMENT = 5 DEFAULT CHARSET = latin1;"; string connString = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut); bool value = MySqlDatabase.RunQuery(connString, sql, out _errOut); General.HasTrueValue(value, _errOut); }
public void TestMethod_ConnectDB() { MySqlDatabase obj = new MySqlDatabase(); string connString = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut); bool value = obj.ConnectDb(connString, out _errOut); obj.Close(); General.HasTrueValue(value, _errOut); }
public void GetDataSetTest() { string sql = "select * from `DB_Version`"; string connString = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut); DataSet value = MySqlDatabase.GetData(connString, sql, "dbversion", out _errOut); bool didPass = false; foreach (DataTable table in value.Tables) { foreach (DataRow row in table.Rows) { TestContext.WriteLine($"Version #: {row["VerNo"]}"); TestContext.WriteLine($"Date Created: {row["dtUpdated"]}"); didPass = true; } } General.HasTrueValue(didPass, _errOut); }
public void TestMethod_ConnectionString() { string value = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut); General.HasValue(value, _errOut); }