public void importPeaksLargeFileTest1()
        {
            string testFile = sqlitefileName2;

            List <MSPeakResult> peakList = new List <MSPeakResult>();

            PeakImporterFromSQLite importer = new PeakImporterFromSQLite(testFile);
            Stopwatch sw = new Stopwatch();

            sw.Start();
            importer.ImportPeaks(peakList);
            sw.Stop();
            Console.WriteLine("Import time = " + sw.ElapsedMilliseconds);
            sw.Reset();
            Assert.AreEqual(4852790, peakList.Count);
            sw.Start();
            List <MSPeakResult> testList = peakList.Where(p => p.MSPeak.XValue > 700.01 && p.MSPeak.XValue < 700.03).ToList();

            sw.Stop();

            Console.WriteLine("test chrom time = " + sw.ElapsedMilliseconds);
            sw.Reset();
            sw.Start();
            List <MSPeakResult> testList2 = peakList.Where(p => p.MSPeak.XValue > 891.01 && p.MSPeak.XValue < 891.03).ToList();

            sw.Stop();
            Console.WriteLine("test chrom time = " + sw.ElapsedMilliseconds);

            reportChromatogram(testList);
        }
        public void importPeaksFromSqlite()
        {
            string testFile = sqlitefileName1;

            List <MSPeakResult> peakList = new List <MSPeakResult>();

            PeakImporterFromSQLite importer = new PeakImporterFromSQLite(testFile);

            importer.ImportPeaks(peakList);

            Assert.AreEqual(1096, peakList[1095].PeakID);
            Assert.AreEqual(6005, peakList[1095].Scan_num);
            Assert.AreEqual(754.37393, (decimal)peakList[1095].MSPeak.XValue);
            Assert.AreEqual(3266908, (decimal)peakList[1095].MSPeak.Height);
            Assert.AreEqual(0.01484067, (decimal)peakList[1095].MSPeak.Width);


            Assert.AreEqual(4088, peakList.Count);
        }