Mercurial > hg > orthanc-tests
annotate PerfsDb/DbPopulator.py @ 164:ff939d07989f
saving results
| author | am@osimis.io |
|---|---|
| date | Mon, 20 Aug 2018 15:50:47 +0200 |
| parents | 53575aa2614b |
| children | 1ff0d830bb87 |
| rev | line source |
|---|---|
| 156 | 1 import typing |
| 161 | 2 import time |
| 163 | 3 import csv |
| 4 import os | |
| 156 | 5 from orthancRestApi import OrthancClient |
| 161 | 6 from TestResult import TestResult |
| 156 | 7 from DbSize import DbSize |
| 8 | |
| 9 class DbPopulator: | |
| 10 | |
| 11 def __init__(self, orthanc: OrthancClient, dbSize: DbSize): | |
| 12 self._orthanc = orthanc | |
| 13 self._dbSize = dbSize | |
| 14 self._sourceInstanceId = None | |
| 161 | 15 self._fileCounter = 0 |
| 16 | |
| 163 | 17 def populate(self, label: str): |
| 156 | 18 self._sourceInstanceId = self._orthanc.uploadDicomFile("../Database/DummyCT.dcm") |
| 19 | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
20 if self._dbSize == DbSize.Tiny: |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
21 patientCount = 1 |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
22 smallStudiesPerPatient = 2 |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
23 largeStudiesPerPatient = 1 |
| 161 | 24 seriesPerSmallStudy = 1 |
| 25 seriesPerLargeStudy = 2 | |
| 26 instancesPerSmallSeries = 1 | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
27 instancesPerLargeSeries = 5 |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
28 elif self._dbSize == DbSize.Small: |
| 161 | 29 patientCount = 100 |
| 156 | 30 smallStudiesPerPatient = 2 |
| 31 largeStudiesPerPatient = 1 | |
| 161 | 32 seriesPerSmallStudy = 1 |
| 33 seriesPerLargeStudy = 2 | |
| 34 instancesPerSmallSeries = 1 | |
| 35 instancesPerLargeSeries = 30 | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
36 elif self._dbSize == DbSize.Medium: |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
37 patientCount = 1000 |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
38 smallStudiesPerPatient = 2 |
| 161 | 39 largeStudiesPerPatient = 2 |
| 40 seriesPerSmallStudy = 1 | |
| 41 seriesPerLargeStudy = 2 | |
| 42 instancesPerSmallSeries = 1 | |
| 43 instancesPerLargeSeries = 300 | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
44 elif self._dbSize == DbSize.Large: |
| 161 | 45 patientCount = 10000 |
| 46 smallStudiesPerPatient = 2 | |
| 47 largeStudiesPerPatient = 2 | |
| 48 seriesPerSmallStudy = 1 | |
| 49 seriesPerLargeStudy = 2 | |
| 50 instancesPerSmallSeries = 1 | |
| 51 instancesPerLargeSeries = 300 | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
52 else: |
|
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
53 raise NotImplementedError |
| 156 | 54 |
| 161 | 55 print("Will generate data for (approximately):") |
| 56 print("{n:>12} patients".format(n=patientCount)) | |
| 57 print("{n:>12} studies".format(n=patientCount * (smallStudiesPerPatient + largeStudiesPerPatient))) | |
| 58 print("{n:>12} instances".format(n=patientCount * (smallStudiesPerPatient * seriesPerSmallStudy * instancesPerSmallSeries + largeStudiesPerPatient * seriesPerLargeStudy * instancesPerLargeSeries))) | |
| 59 | |
| 60 startTime = time.time() | |
|
158
df1f9946571c
perfs db continued: tests working with tiny DBs on all setup but the sqliteplugin
am@osimis.io
parents:
156
diff
changeset
|
61 # first add data that are the same in small and large DBs (and that can be used in tests for comparing the same things !!) |
| 156 | 62 |
| 63 # used in TestFindStudyByPatientId5Results | |
| 64 self.createStudy(studyIndex=99994, patientIndex=99998, seriesCount=1, instancesPerSeries=1) | |
| 65 self.createStudy(studyIndex=99995, patientIndex=99998, seriesCount=1, instancesPerSeries=1) | |
| 66 self.createStudy(studyIndex=99996, patientIndex=99998, seriesCount=1, instancesPerSeries=1) | |
| 67 self.createStudy(studyIndex=99997, patientIndex=99998, seriesCount=1, instancesPerSeries=1) | |
| 68 self.createStudy(studyIndex=99998, patientIndex=99998, seriesCount=1, instancesPerSeries=1) | |
| 69 | |
| 70 # used in TestFindStudyByStudyDescription1Result | |
| 71 # used in TestFindStudyByPatientId1Result | |
| 162 | 72 # used in TestToolsFindStudyByStudyInstanceUID |
| 156 | 73 self.createStudy(studyIndex=99999, patientIndex=99999, seriesCount=1, instancesPerSeries=1) |
| 74 | |
| 163 | 75 with open(os.path.join(os.path.dirname(os.path.abspath(__file__)), "Results/db-init-" + label), 'w', newline='') as resultFile: |
| 76 resultWriter = csv.writer(resultFile) | |
| 77 resultWriter.writerow(["patientCount", "filesCount", "duration", "files/sec"]) | |
| 78 # then, add data to make the DB "large" or "small" | |
| 79 for patientIndex in range(0, patientCount): | |
| 80 studyIndex=0 | |
| 81 print("Generating data for patient " + str(patientIndex)) | |
| 82 fileCounterAtPatientStart = self._fileCounter | |
| 83 startTimePatient = time.time() | |
| 84 | |
| 85 for i in range(0, smallStudiesPerPatient): | |
| 86 print("Generating small study " + str(i)) | |
| 87 self.createStudy(studyIndex=studyIndex, patientIndex=patientIndex, seriesCount=seriesPerSmallStudy, instancesPerSeries=instancesPerSmallSeries) | |
| 88 studyIndex+=1 | |
| 89 for i in range(0, largeStudiesPerPatient): | |
| 90 print("Generating large study " + str(i)) | |
| 91 self.createStudy(studyIndex=studyIndex, patientIndex=patientIndex, seriesCount=seriesPerLargeStudy, instancesPerSeries=instancesPerLargeSeries) | |
| 92 studyIndex+=1 | |
| 93 | |
| 94 endTimePatient = time.time() | |
| 95 print("STATS: uploaded {n} files in {s:.2f} seconds; {x:.2f} files/sec".format( | |
| 96 n=self._fileCounter - fileCounterAtPatientStart, | |
| 97 s=endTimePatient - startTimePatient, | |
| 98 x=(self._fileCounter - fileCounterAtPatientStart)/(endTimePatient - startTimePatient) | |
| 99 )) | |
| 100 resultWriter.writerow([ | |
| 101 patientIndex, | |
| 102 self._fileCounter - fileCounterAtPatientStart, | |
| 103 endTimePatient - startTimePatient, | |
| 104 (self._fileCounter - fileCounterAtPatientStart)/(endTimePatient - startTimePatient) | |
| 105 ]) | |
| 106 resultFile.flush() | |
| 156 | 107 |
| 161 | 108 endTime = time.time() |
| 109 print("Generation completed. Elapsed time: {duration:.2f} sec".format(duration=endTime-startTime)) | |
| 110 print("Uploaded {n} files -> {p:.2f} files/sec".format(n=self._fileCounter, p=self._fileCounter/(endTime-startTime))) | |
| 156 | 111 |
| 112 def createStudy(self, studyIndex: int, patientIndex: int, seriesCount: int, instancesPerSeries: int): | |
| 113 for seriesIndex in range(0, seriesCount): | |
| 114 for instanceIndex in range(0, instancesPerSeries): | |
| 115 dicomFile = self.createDicomFile(patientIndex=patientIndex, studyIndex=studyIndex, seriesIndex=seriesIndex, instanceIndex=instanceIndex) | |
| 116 self._orthanc.uploadDicom(dicomFile) | |
| 117 | |
| 118 def createDicomFile(self, patientIndex: int, studyIndex: int, seriesIndex: int, instanceIndex: int) -> object: | |
| 161 | 119 self._fileCounter += 1 |
| 156 | 120 return self._orthanc.instances.modify( |
| 121 instanceId=self._sourceInstanceId, | |
| 122 replaceTags={ | |
| 123 "PatientName": "Patient-" + str(patientIndex), | |
| 124 "PatientID": str(patientIndex), | |
| 125 "StudyDescription": str(patientIndex) + "-" + str(studyIndex), | |
| 126 "SeriesDescription": str(patientIndex) + "-" + str(studyIndex) + "-" + str(seriesIndex), | |
| 127 "SOPInstanceUID": str(patientIndex) + "." + str(studyIndex) + "." + str(seriesIndex) + "." + str(instanceIndex), | |
| 128 "StudyInstanceUID": str(patientIndex) + "." + str(studyIndex), | |
| 129 "SeriesInstanceUID": str(patientIndex) + "." + str(studyIndex) + "." + str(seriesIndex), | |
| 130 "SeriesNumber": str(seriesIndex), | |
| 131 "InstanceNumber": str(instanceIndex) | |
| 132 }, | |
| 133 deleteOriginal=False | |
| 134 ) |