import sys
from PyQt4.QtGui import *
from PyQt4.QtCore import *
import pypyodbc

connection = pypyodbc.connect(Driver = '{SQL Server}',Server = 'DESKTOP-EDIF42G\SQLEXPRESS',Database ='Organization')
cursor = connection.cursor()



Zapros1 = ("""
         select * from dbo.Customers
         """)

Zapros2 = ("""

         """)

Zapros3 = ("""

         """)

Zapros4 = ("""

         """)

Zapros5 = ("""

         """)

Zapros6 = ("""

         """)

Zapros7 = ("""

         """)

Zapros8 = ("""

         """)

Zapros9 = ("""

         """)

Zapros10 = ("""

         """)




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

        self.ComboBox = QComboBox()
        self.ComboBox.addItems(['Все поставщики',
                                'Zapros2',
                                'Zapros3',
                                'Zapros4',
                                'Zapros5',
                                'Zapros6',
                                'Zapros7',
                                'Zapros8',
                                'Zapros9',
                                'Zapros10'])

        self.pushButton = QPushButton()
        self.pushButton.setText('Выполнить')
        self.pushButton.pressed.connect(self.printer)

        self.textEdit = QTextEdit()

        hbox_1 = QHBoxLayout()
        vbox_1 = QVBoxLayout()
        hbox_1.addWidget(self.ComboBox)
        hbox_1.addWidget(self.pushButton)
        vbox_1.addLayout(hbox_1)
        vbox_1.addWidget(self.textEdit)

        self.setLayout(vbox_1)
        self.setWindowTitle('Базы Данных')

    def zapros(self):
        if self.ComboBox.currentText() == 'Все поставщики':
            cursor.execute(Zapros1)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros2':
            cursor.execute(Zapros2)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros3':
            cursor.execute(Zapros3)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros4':
            cursor.execute(Zapros4)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros5':
            cursor.execute(Zapros5)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros6':
            cursor.execute(Zapros6)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros7':
            cursor.execute(Zapros7)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros8':
            cursor.execute(Zapros8)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros9':
            cursor.execute(Zapros9)
            result = cursor.fetchall()
            return result
        elif self.ComboBox.currentText() == 'Zapros10':
            cursor.execute(Zapros10)
            result = cursor.fetchall()
            return result

    def printer(self):
        text = self.zapros()
        result = ''
        for row in text:
            i = 0
            for _ in row:
                while i!= len(row):
                    result += str(row[i])
                    result += ' '
                    i += 1
            result += '\n'
            self.textEdit.setText(result)




def main():


    app = QApplication(sys.argv)
    ex = Kursovaya()
    ex.show()
    sys.exit(app.exec_())


if __name__ == '__main__':

    main()