import sys
from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtWidgets import QInputDialog, QLineEdit, QDialog, QWidget, QPushButton, QHBoxLayout, QVBoxLayout, QApplication, QComboBox
import sqlite3

class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.resize(800, 755)
        MainWindow.setAutoFillBackground(False)
        MainWindow.setTabShape(QtWidgets.QTabWidget.Rounded)

        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.listWidget = QtWidgets.QListWidget(self.centralwidget)
        self.listWidget.setGeometry(QtCore.QRect(430, 200, 331, 501))
        self.listWidget.setObjectName("listWidget")
        item = QtWidgets.QListWidgetItem()
        self.listWidget.addItem(item)
        item = QtWidgets.QListWidgetItem()
        self.listWidget.addItem(item)
        self.groupBox = QtWidgets.QGroupBox(self.centralwidget)
        self.groupBox.setGeometry(QtCore.QRect(20, 10, 731, 121))
        self.groupBox.setObjectName("groupBox")
        self.lcdNumber = QtWidgets.QLCDNumber(self.groupBox)
        self.lcdNumber.setGeometry(QtCore.QRect(200, 30, 64, 23))
        self.lcdNumber.setObjectName("lcdNumber")
        self.label = QtWidgets.QLabel(self.groupBox)
        self.label.setGeometry(QtCore.QRect(70, 30, 101, 31))
        self.label.setObjectName("label")
        self.label_2 = QtWidgets.QLabel(self.groupBox)
        self.label_2.setGeometry(QtCore.QRect(370, 60, 121, 31))
        self.label_2.setObjectName("label_2")
        self.label_3 = QtWidgets.QLabel(self.groupBox)
        self.label_3.setGeometry(QtCore.QRect(70, 70, 101, 31))
        self.label_3.setObjectName("label_3")
        self.label_4 = QtWidgets.QLabel(self.groupBox)
        self.label_4.setGeometry(QtCore.QRect(370, 30, 91, 31))
        self.label_4.setObjectName("label_4")
        self.lcdNumber_2 = QtWidgets.QLCDNumber(self.groupBox)
        self.lcdNumber_2.setGeometry(QtCore.QRect(200, 70, 64, 23))
        self.lcdNumber_2.setObjectName("lcdNumber_2")
        self.lcdNumber_3 = QtWidgets.QLCDNumber(self.groupBox)
        self.lcdNumber_3.setGeometry(QtCore.QRect(520, 30, 64, 23))
        self.lcdNumber_3.setObjectName("lcdNumber_3")
        self.lcdNumber_4 = QtWidgets.QLCDNumber(self.groupBox)
        self.lcdNumber_4.setGeometry(QtCore.QRect(520, 70, 64, 23))
        self.lcdNumber_4.setObjectName("lcdNumber_4")
        self.lcdNumber_5 = QtWidgets.QLCDNumber(self.centralwidget)
        self.lcdNumber_5.setGeometry(QtCore.QRect(260, 140, 64, 23))
        self.lcdNumber_5.setObjectName("lcdNumber_5")
        self.label_5 = QtWidgets.QLabel(self.centralwidget)
        self.label_5.setGeometry(QtCore.QRect(100, 140, 111, 31))
        self.label_5.setObjectName("label_5")
        self.label_6 = QtWidgets.QLabel(self.centralwidget)
        self.label_6.setGeometry(QtCore.QRect(520, 140, 81, 31))
        self.label_6.setObjectName("label_6")
        self.lcdNumber_6 = QtWidgets.QLCDNumber(self.centralwidget)
        self.lcdNumber_6.setGeometry(QtCore.QRect(650, 140, 64, 23))
        self.lcdNumber_6.setObjectName("lcdNumber_6")
        self.tabWidget = QtWidgets.QTabWidget(self.centralwidget)
        self.tabWidget.setGeometry(QtCore.QRect(50, 180, 341, 521))
        self.tabWidget.setObjectName("tabWidget")
        self.tab = QtWidgets.QWidget()
        self.tab.setObjectName("tab")
        self.listWidget_3 = QtWidgets.QListWidget(self.tab)
        self.listWidget_3.setGeometry(QtCore.QRect(0, 0, 341, 501))
        self.listWidget_3.setObjectName("listWidget_3")
        self.tabWidget.addTab(self.tab, "")
        self.tab_2 = QtWidgets.QWidget()
        self.tab_2.setObjectName("tab_2")
        self.listWidget_2 = QtWidgets.QListWidget(self.tab_2)
        self.listWidget_2.setGeometry(QtCore.QRect(0, 0, 341, 501))
        self.listWidget_2.setObjectName("listWidget_2")
        self.tabWidget.addTab(self.tab_2, "")
        self.tab_3 = QtWidgets.QWidget()
        self.tab_3.setObjectName("tab_3")
        self.listWidget_4 = QtWidgets.QListWidget(self.tab_3)
        self.listWidget_4.setGeometry(QtCore.QRect(0, 0, 341, 501))
        self.listWidget_4.setObjectName("listWidget_4")
        self.tabWidget.addTab(self.tab_3, "")
        self.tab_4 = QtWidgets.QWidget()
        self.tab_4.setObjectName("tab_4")
        self.listWidget_5 = QtWidgets.QListWidget(self.tab_4)
        self.listWidget_5.setGeometry(QtCore.QRect(0, 0, 341, 501))
        self.listWidget_5.setObjectName("listWidget_5")
        self.tabWidget.addTab(self.tab_4, "")
        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 26))
        self.menubar.setObjectName("menubar")
        self.menuManage_Teams = QtWidgets.QMenu(self.menubar)
        self.menuManage_Teams.setObjectName("menuManage_Teams")
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)
        self.actionNew_Team = QtWidgets.QAction(MainWindow)
        self.actionNew_Team.setObjectName("actionNew_Team")
        self.actionOpen_Team = QtWidgets.QAction(MainWindow)
        self.actionOpen_Team.setObjectName("actionOpen_Team")

        self.actionSave_Team = QtWidgets.QAction(MainWindow)
        self.actionSave_Team.setObjectName("actionSave_Team")
        self.actionSave_Team.setEnabled(False)

        self.actionEvacuate_Team = QtWidgets.QAction(MainWindow)
        self.actionEvacuate_Team.setObjectName("actionEvacuate_Team")
        self.actionEvacuate_Team.setEnabled(False)
        self.menuManage_Teams.addAction(self.actionNew_Team)
        self.menuManage_Teams.addAction(self.actionOpen_Team)
        self.menuManage_Teams.addSeparator()
        self.menuManage_Teams.addAction(self.actionSave_Team)
        self.menuManage_Teams.addSeparator()
        self.menuManage_Teams.addAction(self.actionEvacuate_Team)
        self.menubar.addAction(self.menuManage_Teams.menuAction())

        self.retranslateUi(MainWindow)
        self.setupEvents(MainWindow)
        self.tabWidget.setCurrentIndex(0)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)

    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "Fantasy Cricket"))
        __sortingEnabled = self.listWidget.isSortingEnabled()
        self.listWidget.setSortingEnabled(False)
        item = self.listWidget.item(0)
        item.setText(_translate("MainWindow", "sfasf"))
        item = self.listWidget.item(1)
        item.setText(_translate("MainWindow", "asfaf"))
        self.listWidget.setSortingEnabled(__sortingEnabled)
        self.groupBox.setTitle(_translate("MainWindow", "SELECTIONS"))
        self.label.setText(_translate("MainWindow", "BATSMEN (BAT)"))
        self.label_2.setText(_translate("MainWindow", "ALL ROUNDERS(AR)"))
        self.label_3.setText(_translate("MainWindow", "BOWLERS (BOW)"))
        self.label_4.setText(_translate("MainWindow", "WICKETKEEPER"))
        self.label_5.setText(_translate("MainWindow", "POINTS AVAILABLE"))
        self.label_6.setText(_translate("MainWindow", "POINTS USED"))
        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("MainWindow", "BAT"))
        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("MainWindow", "WK"))
        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_3), _translate("MainWindow", "AR"))
        self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_4), _translate("MainWindow", "BOW"))
        self.menuManage_Teams.setTitle(_translate("MainWindow", "Manage Teams"))
        self.actionNew_Team.setText(_translate("MainWindow", "New Team"))
        self.actionOpen_Team.setText(_translate("MainWindow", "Open Team"))
        self.actionSave_Team.setText(_translate("MainWindow", "Save Team"))
        self.actionEvacuate_Team.setText(_translate("MainWindow", "Evaluate Team"))
    
    def setupEvents(self, MainWindow):
        self.actionNew_Team.triggered.connect(self.newTeam)
        self.actionOpen_Team.triggered.connect(self.openTeam)

    def newTeam(self, MainWindow):
        n = NewTeamDialog()
        n.exec_()

    def openTeam(self, MainWindow):
        o = OpenTeamDialog()
        o.exec_()

    def saveTeam(self, MainWindow):
        pass

class NewTeamDialog(QDialog):
    def __init__(self):
        super(NewTeamDialog, self).__init__()
        self.setWindowTitle("Create New Team")
        self.setFixedWidth(300)
        self.setFixedHeight(100)
        self.nameInput = QLineEdit()
        self.nameInput.setPlaceholderText("Enter Team Name")
        self.addBtn = QPushButton()
        self.addBtn.setText("Add Team")
        self.addBtn.clicked.connect(self.addTeam)
        layout = QVBoxLayout()
        layout.addWidget(self.nameInput)
        layout.addWidget(self.addBtn)
        self.setLayout(layout)
        
    def addTeam(self):
        name = self.nameInput.text()
        conn = sqlite3.connect("example.db")
        c = conn.cursor()
        c.execute('SELECT * FROM batsmen')
        print(c.fetchall())
        conn.close()
        self.close()

class OpenTeamDialog(QDialog):
    def __init__(self):
        super(OpenTeamDialog, self).__init__()

        self.setWindowTitle("Open Saved Team")
        self.setFixedWidth(300)
        self.setFixedHeight(100)

        self.dropDown = QComboBox()
        layout = QVBoxLayout()
        layout.addWidget(self.dropDown)
        self.setLayout(layout)
        
    def openTeam(self):
        pass

class EvaluateDialog(QDialog):
    pass

if __name__ == "__main__":
    app = QtWidgets.QApplication(sys.argv)
    MainWindow = QtWidgets.QMainWindow()
    ui = Ui_MainWindow()
    ui.setupUi(MainWindow)
    MainWindow.show()
    sys.exit(app.exec_())

Add a code snippet to your website: www.paste.org