def __init__(self, parent=None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) #QtCore.QObject.connect(self.ui.actionExit, QtCore.SIGNAL("triggered()"), self.close) QtCore.QObject.connect(self.ui.pushButton, QtCore.SIGNAL("clicked()"), self.open_file)
class StartMyMain(QtGui.QMainWindow): _name = "" def __init__(self, parent=None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) #QtCore.QObject.connect(self.ui.actionExit, QtCore.SIGNAL("triggered()"), self.close) QtCore.QObject.connect(self.ui.pushButton, QtCore.SIGNAL("clicked()"), self.open_file) def open_file(self): name = QtGui.QFileDialog.getOpenFileName(self, "File Open") print(name) wb = open_workbook(name, encoding_override = "cp1251") # ws = wb.sheet_by_name('Лист1') ws = wb.sheet_by_index(0) if ws.row(0)[1].value == '': i = 2 else: i = 1 names = [] for row_index in range(i, ws.nrows): names.append((ws.row(row_index)[12].value,)) names = list(set(names)) #выводим на экран #for item in lis: #my_list.insert(END, item) con = sqlite3.connect('ebank.db') with con: cursor = con.cursor() cursor.execute('pragma foreign_keys=ON') cursor.execute('pragma foreign_keys') cursor.executemany('INSERT INTO people(name) values(?)', names) rows = [] for row_index in range(i, ws.nrows): name = ws.row(row_index)[12].value a = list(x.value for x in ws.row(row_index) if x.value != name) a[3] = xldate.xldate_as_datetime(a[3], wb.datemode).date() a[4] = xldate.xldate_as_datetime(a[4], wb.datemode).date() a[8] = xldate.xldate_as_datetime(a[8], wb.datemode).date() a[9] = xldate.xldate_as_datetime(a[9], wb.datemode).date() a = tuple(a) a = (names.index((name,))+1,) + a#сложение кортежей rows.append(a) cursor.execute('pragma foreign_keys=ON') cursor.execute('pragma foreign_keys') operation = cursor.executemany('INSERT INTO contract(man_id, summa, numer_dog, days, nachalo, okonchanie, rate, summa_k_uplate, tek_period, tek_nachalo, tek_okonchanie, summa_za_period, vsego_za_period, word_doc) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)', rows) con.commit() con.close() print("База создана")