Python-сообщество

#!usr/bin/python
#-*- coding: utf-8 -*-
from PyQt4 import QtSql
from message_bd_1 import My_Messqge

class Baza_Dannyh():
    def create_connection(self):
        db=QtSql.QSqlDatabase.addDatabase("QSQLITE")
        db.setDatabaseName("baza_avto_zapchasty_my_baza")
        if not db.open():
            my_message=My_Messqge()
            my_message.show()
            my_message.exec_()
            return False
         
        query=QtSql.QSqlQuery()
        query.exec("CREATE TABLE IF NOT EXISTS zapchasty(id INTEGER PRIMARY KEY AUTOINCREMENT, naimenovanie VARCHAR(50), kolichestvo INTEGER, price FLOAT, marka VARCHAR(50), year INTEGER)")
        return True

def otobrazit_dannye(self):
        n=self.my_mainwindow.my_table.rowCount()
        for i in range(n):
            self.my_mainwindow.my_table.removeRow(0)
            
        query=QtSql.QSqlQuery()
        query.exec("SELECT * FROM zapchasty")
        while query.next():
           
            item0=QtGui.QTableWidgetItem(str(query.value(0)))
            item0.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
            item1=QtGui.QTableWidgetItem(str(query.value(1)))
            item1.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
            item2=QtGui.QTableWidgetItem(str(query.value(2)))
            item2.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
            item3=QtGui.QTableWidgetItem(str(query.value(3)))
            item3.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
            item4=QtGui.QTableWidgetItem(str(query.value(4)))
            item4.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
            item5=QtGui.QTableWidgetItem(str(query.value(5)))
            item5.setFlags(QtCore.Qt.ItemIsSelectable|QtCore.Qt.ItemIsEnabled)
             
            self.my_mainwindow.my_table.insertRow(0)
            self.my_mainwindow.my_table.setItem(0,0,item0)
            self.my_mainwindow.my_table.setItem(0,1,item1)
            self.my_mainwindow.my_table.setItem(0,2,item2)
            self.my_mainwindow.my_table.setItem(0,3,item3)
            self.my_mainwindow.my_table.setItem(0,4,item4)
            self.my_mainwindow.my_table.setItem(0,5,item5)
            self.my_mainwindow.my_table.sortItems(0)

   def add_zapis(self):
        a=self.my_form_add_zapchasty.edit_naimenovanie.text()
        b=self.my_form_add_zapchasty.edit_kolichestvo.value()
        c=self.my_form_add_zapchasty.edit_price.value()
        d=self.my_form_add_zapchasty.combobox_avto.currentText()
        e=self.my_form_add_zapchasty.combobox_year.currentText()
        
        query=QtSql.QSqlQuery()
        query.prepare("INSERT INTO zapchasty(naimenovanie,kolichestvo,price,marka,year) VALUES(:naimen,:kolich,:pr,:mark,:year)")
        query.bindValue(":naimen",a)
        query.bindValue(":kolich",b)
        query.bindValue(":pr",c)
        query.bindValue(":mark",d)
        query.bindValue(":year",e)
        query.exec_()
        
        print(d,e)#здесь проверил в консоль выводит нормально а вот дальше строка походу не срабатывает и ничего не отображается
        self.otobrazit_dannye()
        self.my_form_add_zapchasty.hide()

    self.my_mainwindow.my_table.setItem(0,0,item0)

#!/usr/bin/env python
import sys
from PyQt4.QtCore import *
from PyQt4.QtGui import *
from PyQt4.QtSql import *

def createConnection():
    db = QSqlDatabase.addDatabase("QSQLITE")
    db.setDatabaseName(":memory:")
    if not db.open():
        QMessageBox.critical(0, qApp.tr("Cannot open database"),
                qApp.tr("Unable to establish a database connection.\n"
                              "This example needs SQLite support. Please read "
                              "the Qt SQL driver documentation for information "
                              "how to build it.\n\nClick Cancel to exit."),
                QMessageBox.Cancle, QMessageBox.NoButton)
        return False
    query = QSqlQuery()
    query.exec_("create table person(id int primary key, "
                "firstname varchar(20), lastname varchar(20))")
    query.exec_("insert into person values(101, 'Danny', 'Young')")
    query.exec_("insert into person values(102, 'Christine', 'Holand')")
    query.exec_("insert into person values(103, 'Lars', 'Gordon')")
    query.exec_("insert into person values(104, 'Roberto', 'Robitaille')")
    query.exec_("insert into person values(105, 'Maria', 'Papadopoulos')")
    query.exec_("insert into person values(106, 'Ma', 'Papa')")
    return True

def createView( title, model ):
    return view

class Window(QWidget):

    def __init__(self, parent = None):
        QWidget.__init__(self, parent)

        model = QSqlTableModel(self)
        model.setTable("person")
        model.setEditStrategy(QSqlTableModel.OnManualSubmit)
        model.select()

        model.setHeaderData(0, Qt.Horizontal, QVariant(QObject.tr(model, "ID")))
        model.setHeaderData(1, Qt.Horizontal, QVariant(QObject.tr(model, "First name")))
        model.setHeaderData(2, Qt.Horizontal, QVariant(QObject.tr(model, "Last name")))

        view1 = QTableView(self)
        view1.setModel(model)
        view1.setViewportMargins (-100, -100, -100, -100)
        view1.verticalScrollBar().hide()
        view1.horizontalScrollBar().hide()
        view1.setSelectionBehavior(QAbstractItemView.SelectRows)
        view1.setContextMenuPolicy(Qt.ActionsContextMenu)

        def delrow():
            view1.model().removeRow(view1.currentIndex().row())
            view1.model().submitAll()

        a=QAction("delete", view1)
        a.triggered.connect(delrow)
        view1.addAction(a)

        def listtbl():
            c=QSqlQuery("select * from person")
            c.last()
            print "Total number records: ",  c.at()+1

        b=QAction("check", view1)
        b.triggered.connect(listtbl)
        view1.addAction(b)


        view2 = QTableView(self)
        view2.setModel(model)
        view2.setSelectionBehavior(QAbstractItemView.SelectRows)
        view1.selectRow(0)
        view2.selectRow(0)
        layout = QHBoxLayout()
        layout.addWidget(view1)
        layout.addWidget(view2)
        self.setLayout(layout)
        layout.setMargin( 1)
        layout.setSpacing(0)

        ############################################
        def selectionChanged1():
            view2.selectRow(selectionModel1.currentIndex().row())
        def selectionChanged2():
            view1.selectRow(selectionModel2.currentIndex().row())

        selectionModel1 = QItemSelectionModel(model, view1)
        view1.setSelectionModel(selectionModel1)
        self.connect(selectionModel1, SIGNAL("currentChanged(const QModelIndex &, const QModelIndex &)"),selectionChanged1)

        selectionModel2 = QItemSelectionModel(model, view2)
        view2.setSelectionModel(selectionModel2)
        self.connect(selectionModel2, SIGNAL("currentChanged(const QModelIndex &, const QModelIndex &)"),selectionChanged2)

        view2.connect(view1.verticalScrollBar(), SIGNAL("valueChanged(int)"),view2.verticalScrollBar(), SLOT("setValue(int)"))
        view2.connect(view2.verticalScrollBar(), SIGNAL("valueChanged(int)"),view1.verticalScrollBar(), SLOT("setValue(int)"))
        ############################################

if __name__ == "__main__":
    app = QApplication(sys.argv)
    if not createConnection():
        sys.exit(1)

    window = Window()
    window.show()
    sys.exit(app.exec_())

self.connect(selectionModel1,
                  SIGNAL("currentChanged(const QModelIndex &, const QModelIndex &)"),selectionChanged1)

selectionModel1.currentChanged.connect(selectionChanged1)

def createView( title, model ):
    return view

view1.model().removeRow(view1.currentIndex().row())

view1.currentIndex().row()

    row = view1.currentIndex().row()
    modelIndex = view1.currentIndex()
    modelIndex = modelIndex.sibling(row,0)
    id = view1.model().data(modelIndex).toString()

        while query.next():
            a=str(query.value(0))