public void TestEmptyMigration() { var sqliteDbPath = Path.Join(Environment.CurrentDirectory, $"{Guid.NewGuid()}.sqlite"); var factory = new CloudShopDalFactory(); var dal = factory.Create($"Data Source={sqliteDbPath}", DatabaseType.Sqlite); var migrationResult = dal.Migrate(); migrationResult.IsSuccess.ShouldBeTrue(); var users = dal.GetUsers(); users.IsSuccess.ShouldBeTrue(); users.Value.ShouldBeEmpty(); var articles = dal.GetArticles(); articles.IsSuccess.ShouldBeTrue(); articles.Value.ShouldBeEmpty(); var transactions = dal.GetTransactions(); transactions.IsSuccess.ShouldBeTrue(); transactions.Value.ShouldBeEmpty(); File.Delete(sqliteDbPath); File.Exists(sqliteDbPath).ShouldBeFalse(); }
public void CreateSampleDb() { var sqliteDbPath = GetSampleDbFile(); if (File.Exists(sqliteDbPath)) { File.Delete(sqliteDbPath); } File.Create(sqliteDbPath).Close(); var factory = new CloudShopDalFactory(); var dal = factory.Create($"Data Source={sqliteDbPath}", DatabaseType.Sqlite); var migrationResult = dal.Migrate(); migrationResult.IsSuccess.ShouldBeTrue(); }
public void TestMigrateSqlite() { var sqliteDbPath = Path.Join(Environment.CurrentDirectory, $"{Guid.NewGuid()}.sqlite"); File.Exists(sqliteDbPath).ShouldBeFalse(); File.Create(sqliteDbPath).Close(); File.Exists(sqliteDbPath).ShouldBeTrue(); var factory = new CloudShopDalFactory(); var dal = factory.Create($"Data Source={sqliteDbPath}", DatabaseType.Sqlite); var migrationResult = dal.Migrate(); migrationResult.IsSuccess.ShouldBeTrue(); File.Delete(sqliteDbPath); File.Exists(sqliteDbPath).ShouldBeFalse(); }