//[TestMethod()] //public void InsertTest() //{ // ITimeSeries_SmallInt_SecondsService service = CreateNewTimeSeries_SmallInt_SecondsService(); // DateTime startDateTime = DateTime.UtcNow; // int TSDateOffset = DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime); // TimeSeries_SmallInt_Seconds v = GenerateTimeSeries_SmallInt_Seconds(TSDateOffset); // service.Insert(v, new InsertParameters()); //} private TimeSeriesStrip InsertStrip() { ITimeSeriesStripService service = (ITimeSeriesStripService) EntityFactory.GetEntityServiceByName(vTimeSeriesStrip.EntityName, ""); TimeSeriesStrip st = new TimeSeriesStrip(); //st.StartDateOffset = DateTimeEpoch.ConvertDateToSecondsEpoch(startDateTime); st.TimeSeriesTypeID = (byte)EntityEnums.TimeSeriesTypeEnum.ECG; //st.UserID = FWUtils.SecurityUtils.GetCurrentUserIDLong().Value; service.Insert(st, new InsertParameters()); return(st); }
//[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 } }