public void TestInitialize()
{
//setup access to secrets.json file
var builder = new ConfigurationBuilder().AddUserSecrets <CMSPropertiesTests>();
Configuration = builder.Build();
//create the database object
var csb = new MySqlConnectionStringBuilder
{
Server = Configuration["MySqlServer"],
Port = Convert.ToUInt32(Configuration["MySqlPort"]),
UserID = Configuration["MySqlUser"],
Password = Configuration["MySqlPassword"]
};
_database = new CMSDatabase(csb.ToString());
//create database
_database.NonQuery("CREATE DATABASE IF NOT EXISTS TestDatabase");
_database.NonQuery("USE TestDatabase");
//create properties table
_database.NonQuery("CREATE TABLE IF NOT EXISTS Properties (Timestamp DATETIME NOT NULL, Property CHAR(150) NOT NULL, Value TEXT NOT NULL, PRIMARY KEY (Property));");
}
public void NonQueryTest()
{
_database.NonQuery($"DELETE IGNORE FROM Properties WHERE Property='{Test01Name}'");
var b = _database.ExistsQuery($"SELECT * FROM Properties WHERE Property='{Test01Name}'");
Assert.IsFalse(b);
}
public void DeleteProperty(string propertyName)
{
var sql = $"DELETE IGNORE FROM Properties WHERE Property='{propertyName}'";
_database.NonQuery(sql);
}