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);
}
}
