Python QSqlQueryModel.__init__ Examples

Example #1

File: Show Transactions.py Project: setavenger/Portfolio_Viewer

 def __init__(self, parent=None):
     db = QSqlDatabase.addDatabase('QSQLITE')
     db.setDatabaseName(
         '/Users/setor/PycharmProjects/Portfolio/Equity_Ticker/Portfolio Data'
     )
     db.open()
     QSqlQueryModel.__init__(self, parent=parent)
     self.setQuery("select * from Transactions ORDER BY Date DESC ")

Example #2

File: tasks_sort.py Project: titanmet/task

 def __init__(self):
     QSqlQueryModel.__init__(self)
     self.setQuery("Select * from hierarhy")
     self.setHeaderData(0, Qt.Horizontal, "id")
     self.setHeaderData(1, Qt.Horizontal, "id_parent")
     self.setHeaderData(2, Qt.Horizontal, "Name")
     self.setHeaderData(3, Qt.Horizontal, "Image")
     self.setHeaderData(4, Qt.Horizontal, "state")

Example #3

    def __init__(self, connectionName='', parent=None):
        """

        :type connectionName:str
        :type parent: QObject
        :return:
        """
        QSqlQueryModel.__init__(self, parent)

        self.__mConnectionName = connectionName

Example #4

File: main.py Project: dec1/stackoverflow-egs

 def __init__(self, parent=None):
     QSqlQueryModel.__init__(self, parent=parent)
     self.setQuery("select * from person")

Example #5

 def __init__(self, modelData={}):
     QSqlQueryModel.__init__(self)
     self._model_data = modelData