public void UserConfigurationPersisterPersistedTest() { var config = new UserConfiguration(); config.AllowSeeking = false; config.CacheArt = false; config.CacheSongs = true; config.Password = @"password's"; config.User = "******"; config.ServerUrl = "testserver"; var conn = new SQLiteConnection("Data Source=:memory:"); using(var cmd = conn.CreateCommand()) using(var target = new UserConfigurationPersister(conn)){ target.Persist(config); string format = @"select value from properties where key = '{0}';"; cmd.CommandText = string.Format(format, "url"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(config.ServerUrl)); cmd.CommandText = string.Format(format, "user"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(config.User.Replace(@"'", @"""))); cmd.CommandText = string.Format(format, "password"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(config.Password.Replace(@"'", @"""))); cmd.CommandText = string.Format(format, "allowSeeking"); Assert.That(bool.Parse(cmd.ExecuteScalar().ToString()), Is.EqualTo(config.AllowSeeking)); cmd.CommandText = string.Format(format, "cacheArt"); Assert.That(bool.Parse(cmd.ExecuteScalar().ToString()), Is.EqualTo(config.CacheArt)); } }
public void UserConfigurationPersisterSelectAllTest() { var config = new UserConfiguration(); config.AllowSeeking = false; config.CacheArt = false; config.CacheSongs = true; config.Password = @"password's"; config.User = "******"; config.ServerUrl = "testserver"; var conn = new SQLiteConnection("Data Source=:memory:"); using(var cmd = conn.CreateCommand()) using(var target = new UserConfigurationPersister(conn)){ target.Persist(config); var actual = target.SelectAll().ToList(); Assert.That(actual.Count, Is.EqualTo(1)); var res = actual.First(); Assert.That(res.AllowSeeking, Is.EqualTo(config.AllowSeeking)); Assert.That(res.CacheArt, Is.EqualTo(config.CacheArt)); Assert.That(res.ServerUrl, Is.EqualTo(config.ServerUrl)); Assert.That(res.User, Is.EqualTo(config.User)); Assert.That(res.Password, Is.EqualTo(config.Password)); } }