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