public void Can_create_Sqlite_database()
{
var fileName = GetExpectedFileName();
var sqliteFolderLocation = _applicationSettings.SqliteStorageFolderLocation;
currentTestSqliteFile = Path.Combine(sqliteFolderLocation, fileName);
TearDown();
var rawDataSet = GetTestData();
_importedDataPointStorage.WriteRangeToDatabase(fileName, rawDataSet);
Assert.That(currentTestSqliteFile, Does.Exist);
}
public static int GenerateWeeksWorthOfData(this IImportedDataPointRepository dataPointRepository, IApplicationSettings applicationSettings)
{
var totalCount = 0;
var typesOfSavedData = 1;
var daysInWeek = 7;
var hoursInDay = 24;
var minutesInHour = 60;
var readingsInMinute = 12;
var oneWeekOfData = daysInWeek * hoursInDay;
var readingsPerHour = minutesInHour * readingsInMinute;
var sqliteFolderLocation = applicationSettings.SqliteStorageFolderLocation;
for (var fileTypeIndex = 0; fileTypeIndex < typesOfSavedData; fileTypeIndex++)
{
for (var fileIndex = 0; fileIndex < oneWeekOfData; fileIndex++)
{
var databaseName = $"VibrationType{fileTypeIndex}{fileIndex}.db";
var fileTypeData = new List <ImportedDataPoint>();
for (var dataPointIndex = 0; dataPointIndex < readingsPerHour; dataPointIndex++)
{
fileTypeData.Add(new ImportedDataPoint
{
TimeStampInUtc = DateTime.Now.AddDays(-7).AddMinutes(5 * dataPointIndex),
Bits = dataPointIndex
});
totalCount++;
}
var metadata = new StoreFileMetadata
{
FileName = databaseName,
RoomNumber = fileIndex.ToString(),
RackIdentifier = fileIndex,
RackCoordinates = new RackCoordinate
{
X = fileIndex,
Y = fileIndex
},
ConversionKey = fileIndex.ToString()
};
var json = JsonConvert.SerializeObject(metadata);
dataPointRepository.WriteRangeToDatabase(databaseName, fileTypeData);
File.WriteAllText(Path.Combine(sqliteFolderLocation, databaseName.GetSqliteAssociatedMetadataFileName()), json);
}
}
return(totalCount);
}
