public void Deleted_Configuration() { using (var dbManager = DbManagerEx.CreateDbManager()) { using (var context = CreateContext(dbManager)) { context.Settings.Add(new Setting { Key = "configuration.Key", Value = "string configuration value 123".ToByteArray(), Type = SettingType.Other }); context.SaveChanges(); context.Settings.Remove(context.Settings.Single()); context.UndoChanges(); context.SaveChanges(); } using (var context = CreateContext(dbManager)) { Assert.AreEqual(context.Settings.Single().Value.ConvertToString(), "string configuration value 123"); } } }
public void Changed_Configuration() { using (var dbManager = DbManagerEx.CreateDbManager()) { using (var context = CreateContext(dbManager)) { context.Settings.Add(new Setting { Key = "Key", Value = "Value".ToByteArray(), Type = SettingType.String }); context.SaveChanges(); context.Settings.Single().Value = "Updated Value".ToByteArray(); context.UndoChanges(); context.SaveChanges(); } using (var context = CreateContext(dbManager)) { Assert.AreEqual(context.Settings.Single().Value.ConvertToString(), "Value"); } } }
public static DbManagerEx CreateDbManager() { string connectionString = String.Format("Data Source={0}; foreign keys=true;", Path.Combine(Directory.GetCurrentDirectory(), Guid.NewGuid().ToString())); DbManagerEx dbManager = new DbManagerEx(connectionString); dbManager.CreateAndInitDb(true); return(dbManager); }
public void That_Exists_In_Database_Succeed() { string filterFactor = "Key"; string valueToAdd = " updated from test"; Setting[] configsToAdd = new[] { new Setting { Key = "Key 1", Value = "value 1".ToByteArray(), Type = SettingType.Other }, new Setting { Key = "Key 2", Value = "value 2".ToByteArray(), Type = SettingType.Boolean }, new Setting { Key = "Key 3", Value = "value 3".ToByteArray(), Type = SettingType.String }, new Setting { Key = "other 3", Value = "other 3".ToByteArray(), Type = SettingType.Integer }, }; using (var dbManager = DbManagerEx.CreateDbManager()) { // Initialize using (var context = CreateContext(dbManager)) { foreach (var config in configsToAdd) { context.Settings.Add(config); } context.SaveChanges(); } // Update using (var context = CreateContext(dbManager)) { foreach (var config in context.Settings.Where(c => c.Key.Contains(filterFactor))) { config.Value = (config.Value.ConvertToString() + valueToAdd).ToByteArray(); } context.SaveChanges(); } // Assert using (var context = CreateContext(dbManager)) { var configs = context.Settings.Where(c => c.Key.Contains(filterFactor)); foreach (var config in configs.Where(c => c.Key.Contains(filterFactor))) { Assert.IsTrue(config.Value.ConvertToString().Contains(valueToAdd)); } } } }
public void With_Empty_Setting_Value_Throws() { using (var dbManager = DbManagerEx.CreateDbManager()) { using (var context = CreateContext(dbManager)) { Setting config = new Setting { Key = "Key", Type = SettingType.String }; context.Settings.Add(config); context.SaveChanges(); } } }
public void With_Empty_Setting_Name_Throws() { using (var dbManager = DbManagerEx.CreateDbManager()) { using (var context = CreateContext(dbManager)) { Setting config = new Setting { Value = "SettingValue".ToByteArray(), Type = SettingType.String }; context.Settings.Add(config); context.SaveChanges(); } } }
public void That_Contains_Correct_Values_Succeed() { using (var dbManager = DbManagerEx.CreateDbManager()) { using (var context = CreateContext(dbManager)) { Setting config = new Setting { Key = "Key", Value = "SettingValue".ToByteArray(), Type = SettingType.String }; context.Settings.Add(config); context.SaveChanges(); } using (var context = CreateContext(dbManager)) { Assert.AreEqual(context.Settings.Count(), 1); } } }
internal static ConfigurationContext CreateContext(DbManagerEx dbManager) { return(new ConfigurationContext(new SQLiteConnection(dbManager.ConnectionString))); }