class App: def __init__(self): self.db = DbManager() def initApp(self): msg = "*****\n1-Öğrenci Listesi\n2-Öğrenci Ekle\n3-Öğrenci Güncelle\n4-Öğrenci Sil\n5-Öğretmen Ekle\n6-Sınıflara Göre Dersler\n7-Çıkış(E/Ç)" while True: print(msg) islem = input("Seçim: ") if islem == '1': self.displayStudents() elif islem == '2': self.addStudent() elif islem == '3': self.editStudent() elif islem == '4': self.deleteStudent() elif islem == 'E' or islem == 'Ç': break else: print('yanlış seçim') def deleteStudent(self): classid = self.displayStudents() studentid = int(input('öğrenci id: ')) self.db.deleteStudent(studentid) def editStudent(self): classid = self.displayStudents() studentid = int(input('öğrenci id: ')) student = self.db.getStudentById(studentid) student[0].name = input('name:') or student[0].name student[0].surname = input('surname:') or student[0].surname student[0].gender = input('cinsiyet (E/K):') or student[0].gender student[0].classid = input('sınıf: ') or student[0].classid #or student[0].x demek kullanıcı herhangi bir degisiklik yapmazsa eski hali kalsın dedik. year = input("yıl: ") or student[0].birthdate.year month = input("ay: ") or student[0].birthdate.month day = input("gün: ") or student[0].birthdate.day student[0].birthdate = datetime.date(year, month, day) self.db.editStudent(student[0]) def addStudent(self): self.displayClasses() classid = int(input('hangi sınıf: ')) number = input('numara: ') name = input('ad') surname = input('soyad') year = int(input('yıl')) month = int(input('ay')) day = int(input('gün')) birthdate = datetime.date(year, month, day) gender = input('cinsiyet (E/K)') student = Student(None, number, name, surname, birthdate, gender, classid) self.db.addStudent(student) def displayClasses(self): classes = self.db.getClasses() for c in classes: print(f'{c.id}: {c.name}') def displayStudents(self): self.displayClasses() classid = int(input('hangi sınıf: ')) students = self.db.getStudentsByClassId(classid) print("Öğrenci Listesi") for std in students: print(f'{std.id}-{std.name} {std.surname}') return classid
class App: def __init__(self): self.db = DbManager() def initApp(self): msg = "*****\n1-Öğrenci Listesi\n2-Öğrenci Ekle\n3-Öğrenci Güncelle\n4-Öğrenci Sil\n5-Öğretmen Listesi\n6-Öğretmen Ekle\n7-Öğretmen Güncelle\n8-Öğretmen Sil\n9-Sınıflara Göre Dersler\n7-Çıkış(E/Ç)" while True: print(msg) islem = input("Seçim: ") if islem == '1': self.displayStudents() elif islem == '2': self.addStudent() elif islem == '3': self.editStudent() elif islem == '4': self.deleteStudent() elif islem == '5': self.displayTeachers() elif islem == '6': self.addTeacher() elif islem == '7': self.editTeacher() elif islem == '8': self.deleteTeacher() elif islem == '9': self.getLessonsByClass() elif islem == 'E' or islem == 'Ç': break else: print("yanlış seçim") def deleteStudent(self): classid = self.displayStudents() studentid = int(input("öğrenci id: ")) self.db.deleteStudent(studentid) def editStudent(self): classid = self.displayStudents() studentid = int(input("öğrenci id: ")) student = self.db.getStudentById(studentid) student[0].name = input("name: ") or student[0].name student[0].surname = input("surname: ") or student[0].surname student[0].gender = input("gender (E/K): ") or student[0].gender student[0].classid = input("class: ") or student[0].classid year = input("year: ") or student[0].birthdate.year month = input("month: ") or student[0].birthdate.month day = input("day: ") or student[0].birthdate.day student[0].birthdate = datetime.date(year, month, day) self.db.editStudent(student[0]) def addStudent(self): self.displayClasses() classid = int(input("hangi sınıf: ")) number = input("numara: ") name = input("ad: ") surname = input("soyad: ") year = int(input("yıl: ")) month = int(input("ay: ")) day = int(input("gün: ")) birthdate = datetime.date(year, month, day) gender = input("cinsiyet (E/K)") student = Student(None, number, name, surname, birthdate, gender, classid) self.db.addStudent(student) def displayClasses(self): classes = self.db.getClasses() for c in classes: print(f"{c.id}: {c.name}") def displayStudents(self): self.displayClasses() classid = int(input("hangi sınıf: ")) students = self.db.getStudentsByClassId(classid) print("Öğrenci Listesi") for std in students: print(f"{std.id}-{std.name} {std.surname}") return classid def deleteTeacher(self): self.displayTeachers() ogretmenid = int(input("öğretmen id: ")) self.db.deleteTeacher(ogretmenid) def editTeacher(self): self.displayTeachers() ogretmenid = int(input("öğretmen id: ")) ogretmen = self.db.getTeacherById(ogretmenid) ogretmen[0].branch = input("branch: ") or ogretmen[0].branch ogretmen[0].name = input("name: ") or ogretmen[0].name ogretmen[0].surname = input("surname: ") or ogretmen[0].surname ogretmen[0].gender = input("gender (E/K): ") or ogretmen[0].gender year = input("year: ") or ogretmen[0].birthdate.year month = input("month: ") or ogretmen[0].birthdate.month day = input("day: ") or ogretmen[0].birthdate.day ogretmen[0].birthdate = datetime.date(year, month, day) self.db.editTeacher(ogretmen[0]) def addTeacher(self): branch = input("branş: ") name = input("ad: ") surname = input("soyad: ") year = int(input("yıl: ")) month = int(input("ay: ")) day = int(input("gün: ")) birthdate = datetime.date(year, month, day) gender = input("cinsiyet (E/K)") ogretmen = Teacher(None, branch, name, surname, birthdate, gender) self.db.addTeacher(ogretmen) def displayTeachers(self): ogretmenler = self.db.getTeachers() print("Öğretmen Listesi") for std in ogretmenler: print(f"{std.id}-{std.name} {std.surname}") def getLessonsByClass(self): self.cursor = connection.cursor() self.cursor.execute( "SELECT class.Name, lesson.Name FROM lesson INNER JOIN class ON lesson.Id = class.Id GROUP BY(class.Id)" ) result = self.cursor.fetchall() for i in result: print(f"Sınıf: {i[0]} - Dersler: {i[1]}")
class App: def __init__(self): self.db = DbManager() def initApp(self): msg = "*****\n1-Öğrenci Listesi\n2-Öğrenci Ekle\n3-Öğrenci Güncelle\n4-Öğrenci Sil\n5-Öğretmen Ekle\n6-Sınıflara Göre Dersler\n7-Çıkış(E/Ç)" while True: print(msg) islem = input("Seçim : ") if islem == '1': self.displayStudents() elif islem == '2': self.addStudent() elif islem == '3': self.editStudent() elif islem == '4': self.deleteStudent() elif islem == 'E' or islem == 'Ç': break else: print("yanlış seçim") def displayClasses(self): classes = self.db.getClasses() for sinif in classes: print(f'{sinif.id} : {sinif.name}') def displayStudents(self): self.displayClasses() classid = int(input("hangi sınıf :")) students = self.db.getStudentsByClassId(classId=classid) print("\n\nÖĞRENCİ LİSTESİ\n") for index, std in enumerate(students): print(f'{std.id}- {std.name} {std.surname}') return classid def addStudent(self): self.displayClasses() classid = int(input("hangi sınıf :")) studentNumber = input("Numara: ") name = input("Ad: ") surname = input("Soyad: ") year = int(input("Doğum Tarihi Yılı: ")) month = int(input("Doğum Tarihi Ay: ")) day = int(input("Doğum Tarihi Gün: ")) birthdate = datetime(year, month, day) gender = input("Cinsiyet (E/K): ") student = Student(None, studentNumber, name, surname, birthdate, gender, classid) self.db.addStudent(student) def editStudent(self): classid = self.displayStudents() studentid = int(input("Öğrenci id : ")) student = self.db.getStudentById(studentid) student[0].name = input('adı : ') or student[0].name student[0].surname = input('soyadı : ') or student[0].surname student[0].gender = input('cinsiyet (E/K) : ') or student[0].gender student[0].classId = input('Sınıf : ') or student[0].classId year = input("Doğum Tarihi Yılı: ") or student[0].birthdate.year month = input("Doğum Tarihi Ay: ") or student[0].birthdate.month day = input("Doğum Tarihi Gün: ") or student[0].birthdate.day birthdate = datetime(year, month, day) student[0].birthdate = datetime(year, month, day) self.db.editStudent(student[0]) def deleteStudent(self): classid = self.displayStudents() studentid = int(input("öğrenci no : ")) student = self.db.getStudentById(studentid) self.db.deleteStudent(student[0])
class App: def __init__(self): self.db = DbManager() def initApp(self): msg = "*****\n1-Öğrenci Listesi\n2-Öğrenci Ekle\n3-Öğrenci Güncelle\n4-Öğrenci Sil\n5-Çıkış(E/Ç)" while True: print(msg) islem = input("İşlem Seçiniz") if islem == '1': self.displayStudents() elif islem == '2': self.addStudent() elif islem == '3': self.editStudent() elif islem == '4': self.deleteStudent() pass elif islem == 'E' or islem == 'Ç': break else: print("Yanlış Seçim Yaptınız.") def displayClasses(self): classes = self.db.getClasses() for i in classes: print(f'{i.id}: {i.name}') # Öğrenci Ekler. def addStudent(self): self.displayClasses() ClassId = int(input('Hangi sınıfın bilgileri ?')) number = input("Öğrenci Numarası :") name = input("Öğrenci Adı :") surname = input("Öğrenci Soyad :") birthdate = input("Birthdate (YYYY,MM,DD): ") gender = input("Cinsiyet (E/K) :") student = Student(None, number, name, surname, birthdate, gender, ClassId) self.db.addStudent(student) def deleteStudent(self): self.displayStudents() studentid = int(input("Öğrenci İD:")) self.db.deleteStudent(studentid) # Öğrenci Güncelleme def editStudent(self): self.displayStudents() # ClassId = int(input('Hangi sınıfın bilgileri ?')) studentid = int(input("Öğrenci İD:")) student = self.db.getStudentById(studentid) print(student[0].Ad, student[0].Soyad) student[0].Ad = input("Ad:") or student[0].Ad student[0].Soyad = input("Soyad:") or student[0].Soyad student[0].DogumTarihi = input( "Doğum Tarihi(YYYY/MM/DD) :") or student[0].DogumTarihi student[0].Cinsiyet = input("Cinsiyet: ") or student[0].Cinsiyet # student[0].ClassId = input("Sınıf :") or student[0].ClassId self.db.editStudent(student[0]) # Öğrenci listesi def displayStudents(self): self.displayClasses() ClassId = int(input('Hangi sınıfın bilgileri ?')) student = self.db.getStudentsByClassId(ClassId) print("Öğrenci Listesi : ") for std in student: print(f"{std.id}-{std.Ad} {std.Soyad}")
class App: def __init__(self): self.db = DbManager() def initApp(self): msg = '****\n1-Öğrenci Listesi\n2-Öğrenci Ekle\n3-Öğrenci Güncelle\n4-Öğrenci Sil\nÇıkış(E/Ç)' while True: print(msg) islem = input('Seçim: ') if islem == '1': self.displayStudents() elif islem == '2': self.addStudent() elif islem == '3': self.editStudent() elif islem == '4': pass elif islem == 'E' or islem == 'Ç': break else: print('Yanlış Seçim yaptınız') def editStudent(self): def displayClasses(self): classes = self.db.getClasses() for c in classes: print(c.id, c.name) def displayStudents(self): self.displayClasses() classid = int(input('Hangi Sınıf:')) students = self.db.getStudentsByClassId(classid) print('Öğrenci Listesi') for index,std in enumerate(students): print((index+1),std.name,std.surname) def addStudent(self): self.displayClasses() classid = int(input('Hangi Sınıf:')) number = input('Numara: ') name = input('isim: ') surname = input('soyisim: ') year = int(input('yıl: ')) month = int(input('ay: ')) day = int(input('gün: ')) birthdate = datetime.date(year,month,day) gender = input('E/K: ') student = Student(None,number,name,surname,birthdate,gender,classid) self.db.addStudent(student) app = App() app.initApp()