private TimeSeries_SmallInt_Seconds GenerateTimeSeries_SmallInt_Seconds(int timeOffset, Guid stripId, string samplesText) { TimeSeries_SmallInt_Seconds v = (TimeSeries_SmallInt_Seconds)EntityFactory.GetEntityObject(TimeSeries_SmallInt_Seconds.EntityName, GetSourceTypeEnum.Table); v.TSDateOffset = timeOffset; v.TSValue = Convert.ToInt16(TestUtils.RandomUtils.RandomNumber(0, short.MaxValue)); v.TimeSeriesTypeID = (byte)EntityEnums.TimeSeriesTypeEnum.ECG; v.UserID = TestEnums.User.constPatientUserID; v.TSValueBinary = CompressionUtils.SerializeAndCompress(samplesText); v.TimeSeriesStripID = stripId; return(v); }
//[TestMethod()] //public void PopulateDatabaseByRandomValues() //{ // //DateTime startDateTime = new DateTime(2010, 1, 1); // //DateTime startDateTime = DateTime.UtcNow; // PopulateDatabaseByRandomValues(100); //} //[TestMethod] //public void PopulateDatabaseFromFileRealData() //{ // string fileName = @"I:\iosProjects\HealthCareTracker\Resources\Datasets\ECG-DataSamples\ecg_stream_sample.csv"; // //DateTime startDateTime = DateTime.UtcNow; // int samplesPerSecond = 300; // char samplesSeparator = ','; // TimeSeriesStrip strip = InsertStrip(); // Guid stripId = strip.TimeSeriesStripID; // TimeSeries_SmallInt_SecondsService service = CreateNewTimeSeries_SmallInt_SecondsService(); // int TSDateOffset = strip.StartDateOffset; // DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime); // string fileContent = System.IO.File.ReadAllText(fileName); // string[] numbers = fileContent.Split(samplesSeparator); // StringBuilder samplesTextSB = new StringBuilder(); // int commaCount = 0; // for (int i = 0; i < fileContent.Length; i++) // { // if (fileContent[i] == ',') // { // commaCount++; // if (commaCount == samplesPerSecond) // once we got enough samples // { // // insert samples to database // commaCount = 0; // string samplesText = samplesTextSB.ToString(); // TimeSeries_SmallInt_Seconds v = GenerateTimeSeries_SmallInt_Seconds(TSDateOffset, stripId, samplesText); // service.Insert(v, new InsertParameters()); // samplesTextSB.Clear(); // TSDateOffset++; // add one second // continue; // } // } // samplesTextSB.Append(fileContent[i]); // } //} //[TestMethod()] private void PopulateDatabaseByRandomValues(int numberOfValues) { TimeSeriesStrip strip = InsertStrip(); Guid stripId = strip.TimeSeriesStripID; TimeSeries_SmallInt_SecondsService service = CreateNewTimeSeries_SmallInt_SecondsService(); //DateTime startDateTime = new DateTime(2014, 1, 1); //int TSDateOffset = DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime); int TSDateOffset = strip.StartDateOffset; for (int i = 0; i < numberOfValues; i++) { string samplesText = GetOneSecondSamples(); TimeSeries_SmallInt_Seconds v = GenerateTimeSeries_SmallInt_Seconds(TSDateOffset, stripId, samplesText); service.Insert(v, new InsertParameters()); TSDateOffset++; // add one second } }