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()
