public void GetInsertSqlTest()
{
var id = HelperObjectFactory.GetRandomInt(0, 100);
var value = new Album(id, id, id, StringExtensions.GetRandomStringAsync(23).Result, 2002);
var parameters = new List <SQLiteParameter>();
var table = new AlbumTable();
var expected = $"INSERT OR IGNORE INTO {TableFactory<Album>.GetTable<AlbumTable>().TableName} ({AlbumTable.IdColumnName}, {AlbumTable.ArtistIdColumnName}, {AlbumTable.GenreIdColumnName}, {AlbumTable.NameColumnName}, {AlbumTable.YearColumnName}) VALUES(@{AlbumTable.IdColumnName}, @{AlbumTable.ArtistIdColumnName}, @{AlbumTable.GenreIdColumnName}, @{AlbumTable.NameColumnName}, @{AlbumTable.YearColumnName});";
Assert.AreEqual(expected, table.GetInsertSql(value, ref parameters));
Assert.AreEqual(5, parameters.Count);
}
public async Task InitializeDatabaseNonUniqueIdsExceptionTest()
{
using (var container = Substitute.For <UnityContainer>())
{
using (var cursor = Substitute.For <ICursor>())
{
cursor.GetInt(0).Returns(1);
var artistTable = new ArtistTable();
var albumTable = new AlbumTable();
var genreTable = new GenreTable();
var artistParameters = new List <SQLiteParameter>();
var albumParameters = new List <SQLiteParameter>();
var genreParameters = new List <SQLiteParameter>();
var artistSql = artistTable.GetInsertSql(new Artist(0, "Michael Jackson"), ref artistParameters);
var genreSql = genreTable.GetInsertSql(new Genre(0, "Pop"), ref genreParameters);
var albumSql = albumTable.GetInsertSql(new Album(0, 0, 0, "Thriller", 1982), ref albumParameters);
var dataAccess = Substitute.For <IDataAccess>();
dataAccess.OpenOrCreateDatabaseAsync().Returns(DatabaseState.New);
dataAccess.ExecuteQueryWithParametersAsync(Arg.Any <string>(), Arg.Any <List <SQLiteParameter> >()).Returns(cursor);
dataAccess.ExecuteSqlWithParametersAsync(artistSql, Arg.Any <List <SQLiteParameter> >()).Returns(1);
dataAccess.ExecuteSqlWithParametersAsync(genreSql, Arg.Any <List <SQLiteParameter> >()).Returns(0);
dataAccess.ExecuteSqlWithParametersAsync(albumSql, Arg.Any <List <SQLiteParameter> >()).Returns(1);
container.RegisterInstance(Resources.DataAccessObjectName, dataAccess, new ContainerControlledLifetimeManager());
container.RegisterType <AlbumController>(new InjectionFactory(s => new AlbumController(dataAccess)));
container.RegisterType <ArtistController>(new InjectionFactory(s => new ArtistController(dataAccess)));
container.RegisterType <GenreController>(new InjectionFactory(s => new GenreController(dataAccess)));
container.RegisterType <StatisticsController>(new InjectionFactory(s => new StatisticsController(dataAccess)));
try
{
await DatabaseHelpers.InitializeDatabase(container);
}
catch (Exception ex)
{
Assert.IsInstanceOf <SQLiteException>(ex);
Assert.AreEqual($"unknown error\r\n{Resources.ErrorAddingItemMessage}", ex.Message);
}
}
}
}