Python sqliteRowToDict Examples

Example #1

File: test_sql_backend.py Project: ga4ghpoc/server

 def testRowToDict(self):
     rows = None
     with self._db as db:
         rows = db.getReadGroupRows()
     row = rows[0]
     rowDict = sqlite_backend.sqliteRowToDict(row)
     self._testRowDict(rowDict)

Example #2

File: test_sql_backend.py Project: david4096/server-1

 def testRowToDict(self):
     rows = None
     with self._db as db:
         rows = db.getReadGroupRows()
     row = rows[0]
     rowDict = sqlite_backend.sqliteRowToDict(row)
     self._testRowDict(rowDict)

Example #3

File: sequence_annotations.py Project: david4096/server-1

    def getFeatureById(self, featureId):
        """
        Fetch feature by featureID.

        :param featureId: the FeatureID as found in GFF3 records
        :return: dictionary representing a feature object,
            or None if no match is found.
        """
        sql = "SELECT * FROM FEATURE WHERE id = ?"
        query = self._dbconn.execute(sql, (featureId,))
        ret = query.fetchone()
        if ret is None:
            return None
        return sqlite_backend.sqliteRowToDict(ret)

Example #4

File: sequence_annotations.py Project: ga4ghpoc/server

    def getFeatureById(self, featureId):
        """
        Fetch feature by featureID.

        :param featureId: the FeatureID as found in GFF3 records
        :return: dictionary representing a feature object,
            or None if no match is found.
        """
        sql = "SELECT * FROM FEATURE WHERE id = ?"
        query = self._dbconn.execute(sql, (featureId, ))
        ret = query.fetchone()
        if ret is None:
            return None
        return sqlite_backend.sqliteRowToDict(ret)