Untitled

# --------------------KUTUPHANELER--------------------
# ----------------------------------------------------
import sys
from PyQt5 import QtWidgets
from PyQt5.QtWidgets import *
from PyQt5.QtGui import QIcon
from StudentUI import *

# --------------------UYGULAMA OLUŞTUR----------------
# ----------------------------------------------------

uygulama = QApplication(sys.argv)
penStudentForm = QMainWindow()
ui = Ui_MainWindow()
ui.setupUi(penStudentForm)
penStudentForm.show()

# ------------------VERITABANI OLUŞTUR----------------
# ----------------------------------------------------
import sqlite3

global conn
global curs

conn = sqlite3.connect('Student_YS.db')
curs = conn.cursor()

srgCreateTblStudent = ('CREATE TABLE IF NOT EXISTS student(                                                            \
                         Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,                                                \
                         AdSoyad TEXT NOT NULL,                                                                        \
                         OkulNo TEXT NOT NULL,                                                                         \
                         Sube TEXT NOT NULL,                                                                           \
                         Burslu TEXT NOT NULL,                                                                         \
                         YabanciDil TEXT NOT NULL,                                                                     \
                         DogumTarihi TEXT NOT NULL,                                                                    \
                         KayitTarihi TEXT NOT NULL                                                                     \
                         )')
curs.execute(srgCreateTblStudent)
conn.commit()
# -----------------------KAYDET-----------------------
# ----------------------------------------------------

def EKLE():


    _led_AdSoyad = ui.led_AdSoyad.text()
    _led_OkulNo = ui.led_OkulNo.text()
    _cob_Sube = ui.cob_Sube.currentText()
    _dat_DogumTarihi = ui.dat_DogumTarihi.setCalendar(QCalendarWidget.selectedDate().toString(QtCore.Qt.ISODate))
    _dte_KayitTarihi = ui.dte_KayitTarihi.setCalendar(QCalendarWidget.selectedDate().toString(QtCore.Qt.ISODate))
    if ui.chb_Burslu.isChecked():
        _chb_Burslu = "Yes"
    else:
        _chb_Burslu = "No"
    _lsw_YabanciDil = ui.lsw_YabanciDil.currentItem().text()

    curs.execute("INSERT INTO student                                                                                  \
                          (AdSoyad, OkulNo, Sube, DogumTarihi, KayitTarihi, Burslu, YabanciDil)                        \
                           VALUES (?,?,?,?,?,?,?)",                                                                    \
                           (_led_AdSoyad, _led_OkulNo, _cob_Sube, _dat_DogumTarihi, _dte_KayitTarihi,                  \
                           _chb_Burslu, _lsw_YabanciDil))
    conn.commit()

# ------------------SIGNAL SLOT-----------------------
# ----------------------------------------------------

ui.btn_Kaydet.clicked.connect(EKLE)

sys.exit(uygulama.exec_())