import sqlite3
 
# إنشاء اتصال بقاعدة بيانات SQLite (سيتم إنشاء ملف قاعدة البيانات إذا لم يكن موجودًا)
conn = sqlite3.connect('patients.db')
cursor = conn.cursor()
 
# 1. إنشاء جدول المرضى
cursor.execute('''
CREATE TABLE IF NOT EXISTS Patients (
    ID INTEGER PRIMARY KEY,
    Name VARCHAR(100),
    Age INTEGER,
    Issue VARCHAR(100)
)
''')
 
# 2. إدراج بيانات المرضى
patients_data = [
    (2580000, 'Malak', 24, 'pressure'),
    (567778, 'Ahmed', 30, 'sugar'),
    (78999865, 'mina', 40, 'migraine'),
    (777666, 'Mariam', 40, 'sugar')
]
cursor.executemany('INSERT OR IGNORE INTO Patients (ID, Name, Age, Issue) VALUES (?, ?, ?, ?)', patients_data)
 
# 3. تحديث بيانات مريض (تحديث المشكلة للمريض أحمد)
cursor.execute('UPDATE Patients SET Issue = ? WHERE ID = ?', ('pressure', 567778))
 
# 4. حذف بيانات مريض (حذف المريض mina)
cursor.execute('DELETE FROM Patients WHERE Name = ?', ('mina',))
 
# 5. إضافة مريض جديد اسمه Abanoub
cursor.execute('INSERT OR IGNORE INTO Patients (ID, Name, Age, Issue) VALUES (?, ?, ?, ?)', (56788, 'Abanoub', 28, 'Covid'))
 
# 6. عرض جميع بيانات المرضى
cursor.execute('SELECT * FROM Patients')
all_patients = cursor.fetchall()
for patient in all_patients:
    print(patient)
 
# حفظ (commit) التغييرات وإغلاق الاتصال
conn.commit()
conn.close()

aW1wb3J0IHNxbGl0ZTMKCiMg2KXZhti02KfYoSDYp9iq2LXYp9mEINio2YLYp9i52K/YqSDYqNmK2KfZhtin2KogU1FMaXRlICjYs9mK2KrZhSDYpdmG2LTYp9ihINmF2YTZgSDZgtin2LnYr9ipINin2YTYqNmK2KfZhtin2Kog2KXYsNinINmE2YUg2YrZg9mGINmF2YjYrNmI2K/Zi9inKQpjb25uID0gc3FsaXRlMy5jb25uZWN0KCdwYXRpZW50cy5kYicpCmN1cnNvciA9IGNvbm4uY3Vyc29yKCkKCiMgMS4g2KXZhti02KfYoSDYrNiv2YjZhCDYp9mE2YXYsdi22YkKY3Vyc29yLmV4ZWN1dGUoJycnCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIFBhdGllbnRzICgKICAgIElEIElOVEVHRVIgUFJJTUFSWSBLRVksCiAgICBOYW1lIFZBUkNIQVIoMTAwKSwKICAgIEFnZSBJTlRFR0VSLAogICAgSXNzdWUgVkFSQ0hBUigxMDApCikKJycnKQoKIyAyLiDYpdiv2LHYp9isINio2YrYp9mG2KfYqiDYp9mE2YXYsdi22YkKcGF0aWVudHNfZGF0YSA9IFsKICAgICgyNTgwMDAwLCAnTWFsYWsnLCAyNCwgJ3ByZXNzdXJlJyksCiAgICAoNTY3Nzc4LCAnQWhtZWQnLCAzMCwgJ3N1Z2FyJyksCiAgICAoNzg5OTk4NjUsICdtaW5hJywgNDAsICdtaWdyYWluZScpLAogICAgKDc3NzY2NiwgJ01hcmlhbScsIDQwLCAnc3VnYXInKQpdCmN1cnNvci5leGVjdXRlbWFueSgnSU5TRVJUIE9SIElHTk9SRSBJTlRPIFBhdGllbnRzIChJRCwgTmFtZSwgQWdlLCBJc3N1ZSkgVkFMVUVTICg/LCA/LCA/LCA/KScsIHBhdGllbnRzX2RhdGEpCgojIDMuINiq2K3Yr9mK2Ksg2KjZitin2YbYp9iqINmF2LHZiti2ICjYqtit2K/ZitirINin2YTZhdi02YPZhNipINmE2YTZhdix2YrYtiDYo9it2YXYrykKY3Vyc29yLmV4ZWN1dGUoJ1VQREFURSBQYXRpZW50cyBTRVQgSXNzdWUgPSA/IFdIRVJFIElEID0gPycsICgncHJlc3N1cmUnLCA1Njc3NzgpKQoKIyA0LiDYrdiw2YEg2KjZitin2YbYp9iqINmF2LHZiti2ICjYrdiw2YEg2KfZhNmF2LHZiti2IG1pbmEpCmN1cnNvci5leGVjdXRlKCdERUxFVEUgRlJPTSBQYXRpZW50cyBXSEVSRSBOYW1lID0gPycsICgnbWluYScsKSkKCiMgNS4g2KXYttin2YHYqSDZhdix2YrYtiDYrNiv2YrYryDYp9iz2YXZhyBBYmFub3ViCmN1cnNvci5leGVjdXRlKCdJTlNFUlQgT1IgSUdOT1JFIElOVE8gUGF0aWVudHMgKElELCBOYW1lLCBBZ2UsIElzc3VlKSBWQUxVRVMgKD8sID8sID8sID8pJywgKDU2Nzg4LCAnQWJhbm91YicsIDI4LCAnQ292aWQnKSkKCiMgNi4g2LnYsdi2INis2YXZiti5INio2YrYp9mG2KfYqiDYp9mE2YXYsdi22YkKY3Vyc29yLmV4ZWN1dGUoJ1NFTEVDVCAqIEZST00gUGF0aWVudHMnKQphbGxfcGF0aWVudHMgPSBjdXJzb3IuZmV0Y2hhbGwoKQpmb3IgcGF0aWVudCBpbiBhbGxfcGF0aWVudHM6CiAgICBwcmludChwYXRpZW50KQoKIyDYrdmB2LggKGNvbW1pdCkg2KfZhNiq2LrZitmK2LHYp9iqINmI2KXYutmE2KfZgiDYp9mE2KfYqti12KfZhApjb25uLmNvbW1pdCgpCmNvbm4uY2xvc2UoKQ==