public void UserConfigurationPersisterIsPersistedTest()
{
var conn = new SQLiteConnection("Data Source=:memory:");
using(var target = new UserConfigurationPersister(conn)){
Assert.That(target.IsPersisted(new AmpacheSong()));
}
}
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 UserConfigurationPersisterSelectByIdTest()
{
var conn = new SQLiteConnection("Data Source=:memory:");
using(var target = new UserConfigurationPersister(conn)){
var actual = target.SelectBy(123456);
Assert.That(actual, Is.Not.Null);
}
}
public void UserConfigurationPersisterSelectByStringTest()
{
var conn = new SQLiteConnection("Data Source=:memory:");
using(var target = new UserConfigurationPersister(conn)){
var actual = target.SelectBy("test").ToList();
Assert.That(actual.Count, Is.EqualTo(1));
}
}
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));
}
}
