1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| #creation base de donnee
con=connect('mabase.db')
cur = con.cursor()
cur.execute("""DROP TABLE IF EXISTS 'headers'""")
cur.execute("""CREATE TABLE headers (StudyInstanceUID VARCHAR(200),
SeriesInstanceUID VARCHAR(200), SOPInstanceUID VARCHAR(200) UNIQUE,
fonImTy VARCHAR(200), StudyDescription VARCHAR(200),
ScanOptions VARCHAR(200),SliceLocation DOUBLE, KVP DOUBLE,
XRayTubeCurrent DOUBLE,Files BLOB )""")
################question N°3############################################
#######scanner les fichier dans la base ################################
Chemin= "C:\Users\ProBook4540s\Desktop\Projet python\Exam_Projet/"
mabase =[]
for dirName, subdirList, fileList in os.walk(Chemin):
for filename in fileList:
if ".dcm" in filename.lower():
mabase.append(os.path.join(dirName,filename))
################### fonction prend dicom et renvoi les valeurs.##########
for Fichier in mabase:
dcm=read_file(Fichier)
tab1=[dcm.StudyInstanceUID,dcm.SeriesInstanceUID,dcm.SOPInstanceUID
,fonImTy(dcm.ImageType),dcm.StudyDescription,dcm.ScanOptions
,dcm.SliceLocation, dcm.KVP, dcm.XRayTubeCurrent]
############ insértion des éléments dans la base de données###############
cur.execute("""INSERT INTO headers(StudyInstanceUID, SeriesInstanceUID,
SOPInstanceUID, fonImTy,
StudyDescription, ScanOptions, SliceLocation, KVP, XRayTubeCurrent
) VALUES(?,?,?,?,?,?,?,?,?)""" ,tab1)
f=open('C:\Users\ProBook4540s\Desktop\Projet python\Exam_Projet/',"rb")
content=f.read()
cur.execute("""Insert Into Files ('data')values(?)""",( buffer(content)))
con.commit() |
Partager