Python fetchOne示例

示例#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)

示例#2

文件： rna_quantification.py 项目： ga4gh/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)

示例#3

文件： rna_quantification.py 项目： ga4gh/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)

示例#4

 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)

示例#5

文件： test_sql_backend.py 项目： ga4gh/server

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

示例#6

文件： test_sql_backend.py 项目： biodatasphere/candig-server

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