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); }