public static void Init(TestContext _) { InitFilePath(); AddFirst5000DataRowsToDb(); for (int batchId = 1; batchId < _localDbFiles.Length; batchId++) { var preLocalDbFile = _localDbFiles[batchId - 1]; var localDbFile = _localDbFiles[batchId]; if (!File.Exists(localDbFile)) { File.Copy(preLocalDbFile, localDbFile); using var dbContext = new SqliteDBContext(localDbFile); AddDataRowsHelper.Add1BatchDataRows(dbContext.Table1, batchId); dbContext.SaveChanges(); dbContext.Database.CloseConnection(); } var sharedFolderDbFile = _sharedFolderDbFilePaths[batchId]; if (!File.Exists(sharedFolderDbFile)) { File.Copy(localDbFile, sharedFolderDbFile); } } }
public void Add100DataRowsToSharedFolderDb(int dbFilePathIndex) { using var dbContext = new SqliteDBContext(_sharedFolderDbFilePaths[dbFilePathIndex]); var dataRows = new Entity1[100]; for (int i = 0; i < 100; i++) { dataRows[i] = AddDataRowsHelper.CreateDataRow <Entity1>(dbFilePathIndex, i + 5000); } dbContext.AddRange(dataRows); dbContext.SaveChanges(); Assert.AreEqual(100, dbContext.Table1.Where(i => i.BatchId == dbFilePathIndex && i.RowNo >= 5000).Count()); }
private static void AddFirst5000DataRowsToDb() { var dbFile = _localDbFiles[0]; if (!File.Exists(dbFile)) { SqliteDBContext.CopyTempateDBFile(dbFile); using var dbContext = new SqliteDBContext(dbFile); AddDataRowsHelper.Add1BatchDataRows(dbContext.Table1, 0); dbContext.SaveChanges(); dbContext.Database.CloseConnection(); } var sharedDbFile = _sharedFolderDbFilePaths[0]; if (!File.Exists(sharedDbFile)) { File.Copy(dbFile, sharedDbFile); } }
public static void Init(TestContext _) { _localDbFilePaths = new string[10]; _sharedFolderDbFilePaths = new string[10]; for (int i = 0; i < _localDbFilePaths.Length; i++) { _localDbFilePaths[i] = Path.Combine(Properties.Resources.Local, $"{nameof(Add_SqliteDB_BasedOnDifferentDataRowCount_LocalVSSharedFolder_Tests)}{i}{SqliteDBContext.DBFileExtensionName}"); _sharedFolderDbFilePaths[i] = Path.Combine(Properties.Resources.Shared, $"{nameof(Add_SqliteDB_BasedOnDifferentDataRowCount_LocalVSSharedFolder_Tests)}{i}{SqliteDBContext.DBFileExtensionName}"); } for (int i = 0; i < _localDbFilePaths.Length; i++) { SqliteDBContext.CopyTempateDBFile(_localDbFilePaths[i]); using var localDbContext = new SqliteDBContext(_localDbFilePaths[i]); for (int j = 0; j < i + 1; j++) { AddDataRowsHelper.Add1BatchDataRows <Entity1>(localDbContext.Table1, j); } localDbContext.SaveChanges(); File.Copy(_localDbFilePaths[i], _sharedFolderDbFilePaths[i], true); } }