public void Can_read_total_rows_from_Sqlite_database() { var fileName = GetExpectedFileName(); var sqliteFolderLocation = _applicationSettings.SqliteStorageFolderLocation; currentTestSqliteFile = Path.Combine(sqliteFolderLocation, fileName); TearDown(); var rawDataSet = GetTestData(); _importedDataPointStorage.WriteRangeToDatabase(fileName, rawDataSet); var importedData = _importedDataPointStorage.ReadFromDatabase(sqliteFolderLocation, fileName); Assert.That(importedData.Count, Is.EqualTo(rawDataSet.Count)); }
public IList <AggregateDataPoint> ImportFolder(string folderLocation) { var systemSlash = OperatingSystemHelpers.SystemSlash; var files = Directory.GetFiles(folderLocation).Select(file => file.Replace(folderLocation + systemSlash, "")).ToList(); var dbFiles = files.Where(file => file.EndsWith(".db")).ToList(); foreach (var dbFile in dbFiles) { try { var metadataFileName = dbFile.GetSqliteAssociatedMetadataFileName(); var importedData = _importedDataPointRepository.ReadFromDatabase(folderLocation, dbFile); StoreFileMetadata associatedMetaData = null; if (files.Contains(metadataFileName)) { var metaDataFileLocation = Path.Combine(folderLocation, metadataFileName); using (var fileReader = new StreamReader(metaDataFileLocation)) { associatedMetaData = JsonConvert.DeserializeObject <StoreFileMetadata>(fileReader.ReadToEnd()); } } var aggregateDataPoints = importedData.Select(data => new AggregateDataPoint { TimeStamp = data.TimeStampInUtc, RawIntensity = data.Bits, RoomNumber = associatedMetaData?.RoomNumber ?? String.Empty, RackIdentifier = associatedMetaData?.RackIdentifier ?? 0, RackCoordinateX = associatedMetaData?.RackCoordinates?.X ?? 0, RackCoordinateY = associatedMetaData?.RackCoordinates?.Y ?? 0, ConversionKey = Convert.ToDouble(associatedMetaData?.ConversionKey ?? "0") }); AddDataPoints(aggregateDataPoints.ToList()); } catch (Exception e) { throw e; } } return(GetAllDataPoints()); }