def setupWidget(self, wobj): wobj.setWindowIcon(QtGui.QIcon(QtGui.QPixmap(RESOURCE + "logo.png"))) # setup configuration model self.config_model.setTable("configuration") self.test_item_model.setTable("test_item") self.test_item_model.setRelation( 1, QtSql.QSqlRelation("configuration", "id", u"partnumber")) # setup log model self.log_model.setTable("dut") self.cycle_model.setTable("cycle") self.cycle_model.setRelation( 7, QtSql.QSqlRelation("dut", "id", u"barcode, archived")) # set log view self.log_tableView.setModel(self.log_model) # self.log_tableView.resizeColumnsToContents() # update comboBox partnumber_list = [] self.config_model.select() # get data for row in range(self.config_model.rowCount()): index = self.config_model.index(row, 1) # 1 for partnumber pn = self.config_model.data(index).toString() if (pn not in partnumber_list): partnumber_list.append(pn) self.partNum_comboBox.addItem(pn) # set configuration view self.revision_comboBox.setModel(self.config_model) self.revision_comboBox.setModelColumn( self.config_model.fieldIndex("revision")) self.test_item_tableView.setModel(self.test_item_model) self.testItem_update()
def initializeModel(model): model.setTable("projectusers") model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) model.setRelation(1, QtSql.QSqlRelation('projects', 'id', 'code')) model.setRelation(2, QtSql.QSqlRelation('users', 'id', 'username')) model.setHeaderData(0, QtCore.Qt.Horizontal, "ID") model.setHeaderData(1, QtCore.Qt.Horizontal, "Project") model.setHeaderData(2, QtCore.Qt.Horizontal, "User") model.select()
def initializeModel(model): model.setTable('employee') model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) model.setRelation(2, QtSql.QSqlRelation('city', 'id', 'name')) model.setRelation(3, QtSql.QSqlRelation('country', 'id', 'name')) model.setHeaderData(0, QtCore.Qt.Horizontal, "ID") model.setHeaderData(1, QtCore.Qt.Horizontal, "Name") model.setHeaderData(2, QtCore.Qt.Horizontal, "City") model.setHeaderData(3, QtCore.Qt.Horizontal, "Country") model.select()
def CreateTableSensor(self): self.tm = QtSql.QSqlRelationalTableModel(self) self.tm.setTable('sensor') self.tm.setFilter('address > 0') self.tm.setRelation(6, QtSql.QSqlRelation('stype', 'id', '*')) self.tm.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.tm.select() self.ui.tableSensor.setModel(self.tm)
def initializeModel(model): model.setTable("employee") model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) model.setRelation(2, QtSql.QSqlRelation("city", "id", "name")) model.setRelation(3, QtSql.QSqlRelation("country", "id", "name")) model.setHeaderData(0, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(model, "ID"))) model.setHeaderData(1, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(model, "Name"))) model.setHeaderData(2, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(model, "City"))) model.setHeaderData(3, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(model, "Country"))) model.select()
def setupSourceModels(self): self.model = QtSql.QSqlTableModel(self) self.model.setTable("distinctpackets") self.model.sort(0, Qt.DescendingOrder) self.sessionmodel = QtSql.QSqlRelationalTableModel(self) self.sessionmodel.setTable("session") self.sessionmodel.setRelation( 1, QtSql.QSqlRelation("distinctpackets", "ID", "Class")) self.sessionmodel.sort(0, Qt.DescendingOrder)
def __init__(self, parent=None): QObject.__init__(self, parent) self.model = QtSql.QSqlRelationalTableModel(self) self.model.setTable("session") self.model.setRelation( 1, QtSql.QSqlRelation("distinctpackets", "ID", "Class")) self.model.sort(0, Qt.DescendingOrder) self.proxy = QtGui.QSortFilterProxyModel() self.proxy.setSourceModel(self.model) self.proxy.setFilterKeyColumn(1) self.proxy.setDynamicSortFilter(True)
def __init__(self): super(Dialogo_Editar_Entes, self).__init__() self.msgBox = QtGui.QMessageBox() self.msgBox.setModal(True) self.dialogo = QtGui.QDialog() self.dialogo.setAttribute(QtCore.Qt.WA_DeleteOnClose) self.dialogo.setModal(True) self.ui = Ui_Dialogo_Editar_Entes(self.dialogo) self.modeloBaseDatos = QtSql.QSqlRelationalTableModel(self, db) self.modeloBaseDatos.setTable("entes") self.modeloBaseDatos.setEditStrategy( QtSql.QSqlRelationalTableModel.OnFieldChange) #la segunda columna de entes es una clave foranea, especificamente idminsiterio de la tabla minsiterios y queremos #colocar en este modelo la columna nombre de esa tabla self.modeloBaseDatos.setRelation( 2, QtSql.QSqlRelation('ministerios', 'idministerio', 'nombre')) self.modeloBaseDatos.select() self.modeloBaseDatos.setHeaderData(1, QtCore.Qt.Horizontal, "Nombre del ente") self.modeloBaseDatos.setHeaderData(2, QtCore.Qt.Horizontal, "Ministerio del ente") #Creando el modelo para filtrar data self.filtro = QtGui.QSortFilterProxyModel() self.filtro.setSourceModel(self.modeloBaseDatos) self.filtro.setFilterKeyColumn(1) #Se coloca el modelo del proxy en lugar del modelo de base de datos self.ui.tableView.setModel(self.filtro) self.ui.tableView.hideColumn(0) #self.ui.tableView.setItemDelegate(QtSql.QSqlRelationalDelegate(self.ui.tableView)) self.ui.tableView.setItemDelegate(FlipProxyDelegate(self.ui.tableView)) self.ui.tableView.setColumnWidth(1, 300) self.ui.tableView.show() self.ui.pushButton.clicked.connect(self.eliminarEntes) self.ui.pushButton_2.clicked.connect(self.agregarEnte) self.ui.lineEdit.textChanged.connect(self.filtro.setFilterRegExp) self.modeloBaseDatos.beforeInsert.connect(self.verificarData) self.modeloBaseDatos.beforeUpdate.connect(self.verificarData)
def __init__(self): super(Dialogo_Filtrar_Entes, self).__init__() self.dialogo = QtGui.QDialog() self.dialogo.setModal(True) self.dialogo.setAttribute(QtCore.Qt.WA_DeleteOnClose) self.ui = Ui_Dialogo_Filtrar_Entes(self.dialogo) self.modeloBaseDatos = QtSql.QSqlRelationalTableModel(self, db) self.modeloBaseDatos.setTable("entes") self.modeloBaseDatos.setEditStrategy( QtSql.QSqlRelationalTableModel.OnFieldChange) #la segunda columna de entes es una clave foranea, especificamente idminsiterio de la tabla minsiterios y queremos #colocar en este modelo la columna nombre de esa tabla self.modeloBaseDatos.setRelation( 2, QtSql.QSqlRelation('ministerios', 'idministerio', 'nombre')) self.modeloBaseDatos.select() #Creando el modelo para filtrar data self.filtro = QtGui.QSortFilterProxyModel() self.filtro.setSourceModel(self.modeloBaseDatos) self.filtro.setFilterKeyColumn(1) #Se coloca el modelo del proxy en lugar del modelo de base de datos self.ui.tableView.setModel(self.filtro) self.ui.tableView.hideColumn(0) self.ui.tableView.hideColumn(2) self.ui.tableView.setItemDelegate( QtSql.QSqlRelationalDelegate(self.ui.tableView)) self.ui.tableView.setSortingEnabled(True) self.listaEntesFiltrados = [ ] #self.ui.tableView.selectionModel().selectedIndexes() #print(self.listaEntesFiltrados) #print("numero = " + str(self.filtro.rowCount())) for n in range(self.filtro.rowCount()): index = self.filtro.index(n, 1) self.listaEntesFiltrados.append(str(self.filtro.data(index))) self.ui.lineEdit.textChanged.connect(self.filtro.setFilterWildcard) self.ui.lineEdit.textChanged.connect(self.filtrarLista) self.ui.comboBox.currentIndexChanged.connect(self.cambiarFiltro)
def create_widgets(self): self.model = QtSql.QSqlRelationalTableModel(self) self.model.setTable("CustomerOrder") self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit) self.model.setRelation( CUSTOMER, QtSql.QSqlRelation('customerview', 'CustomerID', 'Name')) self.model.setSort(ID, Qt.AscendingOrder) self.model.setHeaderData(ID, Qt.Horizontal, QVariant("Order")) self.model.setHeaderData(DATE, Qt.Horizontal, QVariant("DATE")) self.model.setHeaderData(TIME, Qt.Horizontal, QVariant("TIME")) self.model.setHeaderData(CUSTOMER, Qt.Horizontal, QVariant("CUSTOMER")) self.model.select() self.view = QTableView() self.view.setModel(self.model) self.view.resizeColumnsToContents()
def __init__(self, *args): QtSql.QSqlRelationalTableModel.__init__(self, *args) self.setTable("pigeon") self.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange) self.setHeaderData( YEAR_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Year")))) self.setHeaderData( IDENTIFICATION_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant( QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Identification")))) self.setRelation(NATION_COLUMN, QtSql.QSqlRelation("nation", "id", "short_name")) self.setHeaderData( NATION_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant( QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Nacionality")))) self.setHeaderData( SEX_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Sex")))) self.setHeaderData( STATE_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("State")))) self.setHeaderData( MOTHER_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant( QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Mother")))) self.setHeaderData( FATHER_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant( QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Father")))) self.setRelation(EYE_COLUMN, QtSql.QSqlRelation("eye_color", "id", "name")) self.setHeaderData( EYE_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Eye")))) self.setRelation( PLUMAGE_COLUMN, QtSql.QSqlRelation("plumage_color", "id", "short_name")) self.setHeaderData( PLUMAGE_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant( QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Plumage")))) self.setHeaderData( NAME_COLUMN, QtCore.Qt.Horizontal, QtCore.QVariant(QtCore.QObject.tr(self, QtCore.QT_TR_NOOP("Name")))) self.select()
def __init__(self): QtGui.QMainWindow.__init__(self) # Set up the user interface from Designer. self.ui = Ui_MainWindow() self.ui.setupUi(self) QtGui.QApplication.setStyle(QtGui.QStyleFactory.create("Cleanlooks")) self.s = QSettings() #read settings self.config = ConfigParser.ConfigParser() self.config.read( os.path.join(os.path.dirname(os.path.realpath(__file__)), "settings.cfg")) self.read() #db settings self.db = QtSql.QSqlDatabase.database("myconnection") print "DB is already opened:", self.db.isOpen() if not self.db.isOpen(): ok = self.db.open() if ok == True: print "Database just opened now!" else: print "Failed to open database!" # ====================NOMOTHESIA ============================================================================================== #FIELD indexes FROM TABLE aegean.nomothesia NOMOTHESIAID, NOMOTHESIA, FILENAME, HAS_MAP, NOTES, TYPE, NEWFILENAME = range( 7) self.nomothesiaModel = QtSql.QSqlRelationalTableModel(self, self.db) self.nomothesiaModel.setTable("aegean.nomothesia") if self.nomothesiaModel.lastError().isValid(): print("Error during data selection") self.nomothesiaModel.setRelation( TYPE, QtSql.QSqlRelation("aegean.nomothesia_types", "id", "description")) self.nomothesiaModel.select() self.nomothesiaModel.setHeaderData(NOMOTHESIA, QtCore.Qt.Horizontal, u"Νομοθεσία") self.nomothesiaModel.setHeaderData(TYPE, QtCore.Qt.Horizontal, u"Κατηγορία") while self.nomothesiaModel.canFetchMore(): self.nomothesiaModel.fetchMore() self.proxyModelNomothesia = QtGui.QSortFilterProxyModel() self.proxyModelNomothesia.setSourceModel(self.nomothesiaModel) self.proxyModelNomothesia.setFilterKeyColumn(NOMOTHESIA) self.ui.tableViewNomothesia.setModel(self.proxyModelNomothesia) self.ui.tableViewNomothesia.setVisible(False) self.ui.tableViewNomothesia.resizeColumnsToContents() self.ui.tableViewNomothesia.setVisible(True) self.ui.tableViewNomothesia.setAlternatingRowColors(True) self.ui.tableViewNomothesia.setSortingEnabled(True) self.ui.tableViewNomothesia.setSelectionMode( QtGui.QAbstractItemView.SingleSelection) self.ui.tableViewNomothesia.setSelectionBehavior( QAbstractItemView.SelectRows) self.ui.tableViewNomothesia.verticalHeader().setVisible(False) self.ui.tableViewNomothesia.sortByColumn( NOMOTHESIA, QtCore.Qt.AscendingOrder ) #κάνω το sort στο tableview γιατί στο QSortFilterProxyModel δεν δουλεύει όταν το datasource είναι QSqlQueryModel #Hide some columns self.ui.tableViewNomothesia.setColumnHidden(NOMOTHESIAID, True) self.ui.tableViewNomothesia.setColumnHidden(FILENAME, True) self.ui.tableViewNomothesia.setColumnHidden(HAS_MAP, True) self.ui.tableViewNomothesia.setColumnHidden(NOTES, True) self.ui.tableViewNomothesia.setColumnHidden(NEWFILENAME, True) self.ui.tableViewNomothesia.setEditTriggers( QtGui.QAbstractItemView.NoEditTriggers) #============================================================================================================================== # ====================OIKISMOI ================================================================================================ #FIELD indexes OIKISMOI_NAME, DIMOI_NAME, NOMOI_NAME, NOMOTHESIA_NOMOTHESIA, oikismoi_has_nomothesia_description, oikismoi_has_nomothesia_nomothesiaid, oikismoi_id = range( 7) self.modeloikismoi = QtSql.QSqlQueryModel(self) self.modeloikismoi.setQuery( self.config.get('Sqlsettings', 'selectOikismoi'), self.db) if self.modeloikismoi.lastError().isValid(): print("Error during data selection") self.modeloikismoi.setHeaderData(OIKISMOI_NAME, QtCore.Qt.Horizontal, u"Οικισμός") self.modeloikismoi.setHeaderData(DIMOI_NAME, QtCore.Qt.Horizontal, u"Δήμος") self.modeloikismoi.setHeaderData(NOMOI_NAME, QtCore.Qt.Horizontal, u"Νομός") self.modeloikismoi.setHeaderData(NOMOTHESIA_NOMOTHESIA, QtCore.Qt.Horizontal, u"Νομοθεσία") self.modeloikismoi.setHeaderData(oikismoi_has_nomothesia_description, QtCore.Qt.Horizontal, u"Λεπτομέρειες") while self.modeloikismoi.canFetchMore(): self.modeloikismoi.fetchMore() self.proxyModeloikismoi = QtGui.QSortFilterProxyModel() self.proxyModelNomothesia.setSortLocaleAware(True) self.proxyModeloikismoi.setSourceModel(self.modeloikismoi) self.proxyModeloikismoi.setFilterKeyColumn( oikismoi_has_nomothesia_nomothesiaid) self.ui.tableViewOikismoi.setModel(self.proxyModeloikismoi) self.ui.tableViewOikismoi.setVisible(False) self.ui.tableViewOikismoi.resizeColumnsToContents() self.ui.tableViewOikismoi.setVisible(True) self.ui.tableViewOikismoi.setSortingEnabled(True) self.ui.tableViewOikismoi.setSelectionMode( QtGui.QAbstractItemView.SingleSelection) self.ui.tableViewOikismoi.setSelectionBehavior( QAbstractItemView.SelectRows) self.ui.tableViewOikismoi.sortByColumn( OIKISMOI_NAME, QtCore.Qt.AscendingOrder ) #κάνω το sort στο tableview γιατί στο QSortFilterProxyModel δεν δουλεύει όταν το datasource είναι QSqlQueryModel self.ui.tableViewOikismoi.verticalHeader().setVisible(False) self.ui.tableViewOikismoi.setAlternatingRowColors(True) #Hide some columns self.ui.tableViewOikismoi.setColumnHidden( oikismoi_has_nomothesia_nomothesiaid, True) self.ui.tableViewOikismoi.setColumnHidden(oikismoi_id, True) #============================================================================================================================== #====================signals and slots ======================================================================================== self.ui.lineEdit.textChanged.connect(self.setFilterNomothesia) self.ui.lineEdit.textChanged.connect(self.setFilterNomothesia) self.ui.tableViewNomothesia.selectionModel().currentChanged.connect( self.setfilterOikismous) self.ui.actionFek.triggered.connect(self.starpdf) #============================================================================================================================== #====================some extra widgets======================================================================================== self.lb = QLabel('Ready...') self.lb.setFrameStyle(QtGui.QFrame.Panel | QtGui.QFrame.Sunken) self.lbfiles = QLabel('') self.lbfiles.setFrameStyle(QtGui.QFrame.Panel | QtGui.QFrame.Sunken) self.lbfiles.hide() self.pb = QtGui.QProgressBar(self) self.pb.hide() #add widgets to statusBar self.statusBar().addWidget(self.lb, 0) self.statusBar().addWidget(self.lbfiles, 1) self.statusBar().addWidget(self.pb, 2)
def __init__(self): #Qt main window init QtGui.QMainWindow.__init__(self) # instance variables self.ui = Ui_MainWindow() self.ui.setupUi(self) # sshFile="Default.css" # with open(sshFile,"r") as fh: # self.setStyleSheet(fh.read()) self.LastCG = 0 self.APIurl = "http://eknowles.com/api/" self.PlayersXML = self.APIurl + "playerslist.php?export=xml" self.TeamsXML = self.APIurl + "teamslist.php?export=xml" self.EventsXML = self.APIurl + "eventslist.php?export=xml" self.Team_EventXML = self.APIurl + "link_team_eventlist.php?export=xml" self.Player_TeamXML = self.APIurl + "link_player_teamlist.php?export=xml" QtCore.QObject.connect(self.ui.get_tweets_btn, QtCore.SIGNAL('clicked()'), self.SearchTweets) # self.ui.get_tweets_btn.clicked.connect(self.SearchTweets) QtCore.QObject.connect(self.ui.console_go, QtCore.SIGNAL('clicked()'), self.ConsoleCommand) QtCore.QObject.connect(self.ui.Console_ComingUp, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(1)) QtCore.QObject.connect(self.ui.Console_Sponsors, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(2)) QtCore.QObject.connect(self.ui.Console_TweetFeed, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(3)) QtCore.QObject.connect(self.ui.Console_TweetSingle, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(4)) QtCore.QObject.connect(self.ui.Console_TeamMatch, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(5)) QtCore.QObject.connect(self.ui.Console_Players1, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(6)) QtCore.QObject.connect(self.ui.Console_Players2, QtCore.SIGNAL('clicked()'), lambda: self.ProcessCommand(7)) #Schedule Signals QtCore.QObject.connect(self.ui.Schedule_Add, QtCore.SIGNAL('clicked()'), self.AddRundown) QtCore.QObject.connect(self.ui.Schedule_Remove, QtCore.SIGNAL('clicked()'), self.Schedule_Remove) # Event Signals QtCore.QObject.connect(self.ui.UpdateEvents, QtCore.SIGNAL('clicked()'), self.UpdateEvents) self.ui.actionReload_Client.triggered.connect(self.LoadSettings) self.ui.actionQuit.triggered.connect(self.Quit) # Load Primary Settings (First load) self.LoadSettings() self.clocktimer = QtCore.QTimer(self) self.clocktimer.timeout.connect(self.showTime) self.clocktimer.start(1000) self.showTime() self.ModifyRundown = RundownDialog(self) escg = QtSql.QSqlDatabase.addDatabase("QMYSQL") escg.setHostName("eknowles.com") escg.setDatabaseName("admin_escg") escg.setUserName("admin_escg") escg.setPassword("p4e9@;FImZ8[") escg.open() self.eventsmodel = QtSql.QSqlRelationalTableModel(self.ui.Event_Table) self.eventsmodel.setTable("events") self.eventsmodel.setRelation(7, QtSql.QSqlRelation("games", "id", "name")) self.eventsmodel.setRelation( 6, QtSql.QSqlRelation("players", "id", "handle")) self.eventsmodel.setHeaderData(0, QtCore.Qt.Horizontal, QtCore.QVariant("")) self.eventsmodel.setHeaderData(1, QtCore.Qt.Horizontal, QtCore.QVariant("Name")) self.eventsmodel.setHeaderData(2, QtCore.Qt.Horizontal, QtCore.QVariant("Start")) self.eventsmodel.setHeaderData(3, QtCore.Qt.Horizontal, QtCore.QVariant("End")) self.eventsmodel.setHeaderData(4, QtCore.Qt.Horizontal, QtCore.QVariant("Location")) self.eventsmodel.setHeaderData(5, QtCore.Qt.Horizontal, QtCore.QVariant("Shortname")) self.eventsmodel.setHeaderData(6, QtCore.Qt.Horizontal, QtCore.QVariant("Added By")) self.eventsmodel.setHeaderData(7, QtCore.Qt.Horizontal, QtCore.QVariant("Game")) self.eventsmodel.select() self.ui.Event_Table.setModel(self.eventsmodel) self.ui.Event_Table.setColumnHidden(0, 1) self.ui.Event_Table.setColumnWidth(0, 30) self.ui.Event_Table.setAlternatingRowColors(True) self.ui.Event_Table.setSelectionBehavior( QtGui.QAbstractItemView.SelectRows) self.ui.Event_Table.horizontalHeader().setStretchLastSection(True) self.ui.Event_Table.verticalHeader().setVisible(False) self.TeamsTableModel = QtSql.QSqlRelationalTableModel( self.ui.Teams_Table) self.TeamsTableModel.setTable("teams") self.TeamsTableModel.setRelation( 7, QtSql.QSqlRelation("players", "id", "handle")) self.TeamsTableModel.setHeaderData(0, QtCore.Qt.Horizontal, QtCore.QVariant("")) self.TeamsTableModel.setHeaderData(1, QtCore.Qt.Horizontal, QtCore.QVariant("")) self.TeamsTableModel.setHeaderData(2, QtCore.Qt.Horizontal, QtCore.QVariant("Team Name")) self.TeamsTableModel.setHeaderData(3, QtCore.Qt.Horizontal, QtCore.QVariant("Tag")) self.TeamsTableModel.setHeaderData(4, QtCore.Qt.Horizontal, QtCore.QVariant("Short Tag")) self.TeamsTableModel.setHeaderData(5, QtCore.Qt.Horizontal, QtCore.QVariant("Website")) self.TeamsTableModel.setSort(1, 0) # Sorting by Col 1 and 0 for AAA self.TeamsTableModel.select() self.ui.Teams_Table.setModel(self.TeamsTableModel) self.ui.Teams_Table.setColumnHidden(0, 1) self.ui.Teams_Table.setColumnHidden(4, 1) self.ui.Teams_Table.setColumnHidden(6, 1) self.ui.Teams_Table.setColumnHidden(7, 1) self.ui.Teams_Table.setColumnWidth(0, 30) self.ui.Teams_Table.setColumnWidth(1, 30) self.ui.Teams_Table.setAlternatingRowColors(True) self.ui.Teams_Table.setSelectionBehavior( QtGui.QAbstractItemView.SelectRows) self.ui.Teams_Table.horizontalHeader().setStretchLastSection(True) self.ui.Teams_Table.verticalHeader().setVisible(False) self.PlayersTableModel = QtSql.QSqlRelationalTableModel( self.ui.Players_Table) self.PlayersTableModel.setTable("players") self.PlayersTableModel.setRelation( 8, QtSql.QSqlRelation("games", "id", "shortname")) self.PlayersTableModel.setHeaderData(0, QtCore.Qt.Horizontal, QtCore.QVariant("ID")) self.PlayersTableModel.setHeaderData(1, QtCore.Qt.Horizontal, QtCore.QVariant("Handle")) self.PlayersTableModel.setHeaderData(2, QtCore.Qt.Horizontal, QtCore.QVariant("First Name")) self.PlayersTableModel.setHeaderData(3, QtCore.Qt.Horizontal, QtCore.QVariant("Last Name")) self.PlayersTableModel.setHeaderData(4, QtCore.Qt.Horizontal, QtCore.QVariant("Date of Birth")) self.PlayersTableModel.setHeaderData(5, QtCore.Qt.Horizontal, QtCore.QVariant("Country")) self.PlayersTableModel.setHeaderData(6, QtCore.Qt.Horizontal, QtCore.QVariant("Twitter")) self.PlayersTableModel.setHeaderData(8, QtCore.Qt.Horizontal, QtCore.QVariant("Game")) self.PlayersTableModel.setSort(1, 0) # Sorting by Col 1 and 0 for AAA self.PlayersTableModel.select() self.ui.Players_Table.setModel(self.PlayersTableModel) self.ui.Players_Table.setColumnHidden(0, 1) self.ui.Players_Table.setColumnHidden(7, 1) self.ui.Players_Table.setColumnHidden(9, 1) self.ui.Players_Table.setColumnHidden(10, 1) self.ui.Players_Table.setColumnHidden(11, 1) self.ui.Players_Table.setColumnHidden(12, 1) self.ui.Players_Table.setColumnHidden(13, 1) self.ui.Players_Table.setColumnHidden(14, 1) self.ui.Players_Table.setColumnHidden(15, 1) self.ui.Players_Table.setAlternatingRowColors(True) self.ui.Players_Table.setSelectionBehavior( QtGui.QAbstractItemView.SelectRows) self.ui.Players_Table.horizontalHeader().setStretchLastSection(True) self.ui.Players_Table.verticalHeader().setVisible(False) self.RundownModel = QtSql.QSqlRelationalTableModel( self.ui.Schedule_Table) self.RundownModel.setTable("rundown") self.RundownModel.setHeaderData(0, QtCore.Qt.Horizontal, QtCore.QVariant("")) self.RundownModel.setHeaderData(1, QtCore.Qt.Horizontal, QtCore.QVariant("Title")) self.RundownModel.setHeaderData(2, QtCore.Qt.Horizontal, QtCore.QVariant("Team 1")) self.RundownModel.setHeaderData(3, QtCore.Qt.Horizontal, QtCore.QVariant("Team 2")) self.RundownModel.setHeaderData(4, QtCore.Qt.Horizontal, QtCore.QVariant("Start Time")) self.RundownModel.setHeaderData(5, QtCore.Qt.Horizontal, QtCore.QVariant("Game")) self.RundownModel.setHeaderData(6, QtCore.Qt.Horizontal, QtCore.QVariant("Event")) self.RundownModel.setHeaderData(7, QtCore.Qt.Horizontal, QtCore.QVariant("Channel")) self.RundownModel.setHeaderData(8, QtCore.Qt.Horizontal, QtCore.QVariant("Status")) self.RundownModel.setRelation( 5, QtSql.QSqlRelation("games", "id", "shortname")) self.RundownModel.setRelation( 2, QtSql.QSqlRelation("teams", "id", "name")) self.RundownModel.setRelation( 3, QtSql.QSqlRelation("teams", "id", "name")) self.RundownModel.setRelation( 6, QtSql.QSqlRelation("events", "id", "name")) self.RundownModel.setSort(1, 0) # Sorting by Col 1 and 0 for AAA self.RundownModel.select() self.ui.Schedule_Table.setModel(self.RundownModel) self.ui.Schedule_Table.setColumnHidden(0, 1) self.ui.Schedule_Table.setColumnWidth(0, 30) self.ui.Schedule_Table.setColumnWidth(1, 300) self.ui.Schedule_Table.setColumnWidth(5, 60) self.ui.Schedule_Table.setColumnWidth(4, 128) self.ui.Schedule_Table.setColumnWidth(7, 60) self.ui.Schedule_Table.setAlternatingRowColors(True) self.ui.Schedule_Table.setSelectionBehavior( QtGui.QAbstractItemView.SelectRows) self.ui.Schedule_Table.horizontalHeader().setStretchLastSection(True) self.ui.Schedule_Table.verticalHeader().setVisible(False) self.UpdateEvents()