Python fetchOne Examples

Example #1

File: rna_quantification.py Project: ga4ghpoc/server

 def getExpressionLevelById(self, expressionId):
     """
     :param expressionId: the ExpressionLevel ID
     :return: dictionary representing an ExpressionLevel object,
         or None if no match is found.
     """
     sql = ("SELECT * FROM Expression WHERE id = ?")
     query = self._dbconn.execute(sql, (expressionId, ))
     try:
         return sqlite_backend.fetchOne(query)
     except AttributeError:
         raise exceptions.ExpressionLevelNotFoundException(expressionId)

Example #2

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

 def getExpressionLevelById(self, expressionId):
     """
     :param expressionId: the ExpressionLevel ID
     :return: dictionary representing an ExpressionLevel object,
         or None if no match is found.
     """
     sql = ("SELECT * FROM Expression WHERE id = ?")
     query = self._dbconn.execute(sql, (expressionId,))
     try:
         return sqlite_backend.fetchOne(query)
     except AttributeError:
         raise exceptions.ExpressionLevelNotFoundException(
             expressionId)

Example #3

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

 def getRnaQuantificationById(self, rnaQuantificationId):
     """
     :param rnaQuantificationId: the RNA Quantification ID
     :return: dictionary representing an RnaQuantification object,
         or None if no match is found.
     """
     sql = ("SELECT * FROM RnaQuantification WHERE id = ?")
     query = self._dbconn.execute(sql, (rnaQuantificationId,))
     try:
         return sqlite_backend.fetchOne(query)
     except AttributeError:
         raise exceptions.RnaQuantificationNotFoundException(
             rnaQuantificationId)

Example #4

File: rna_quantification.py Project: ga4ghpoc/server

 def getRnaQuantificationById(self, rnaQuantificationId):
     """
     :param rnaQuantificationId: the RNA Quantification ID
     :return: dictionary representing an RnaQuantification object,
         or None if no match is found.
     """
     sql = ("SELECT * FROM RnaQuantification WHERE id = ?")
     query = self._dbconn.execute(sql, (rnaQuantificationId, ))
     try:
         return sqlite_backend.fetchOne(query)
     except AttributeError:
         raise exceptions.RnaQuantificationNotFoundException(
             rnaQuantificationId)

Example #5

File: test_sql_backend.py Project: ga4ghpoc/server

 def fetchOneMethod(self):
     sql = "SELECT id, name FROM ReadGroup LIMIT 1"
     query = self._dbconn.execute(sql)
     rowDict = sqlite_backend.fetchOne(query)
     return rowDict

Example #6

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

 def fetchOneMethod(self):
     sql = "SELECT id, name FROM ReadGroup LIMIT 1"
     query = self._dbconn.execute(sql)
     rowDict = sqlite_backend.fetchOne(query)
     return rowDict