當前位置: 首頁>>代碼示例>>Python>>正文

Python DbAccess.selectOne方法代碼示例

本文整理匯總了Python中hgu.db.DbAccess.selectOne方法的典型用法代碼示例。如果您正苦於以下問題：Python DbAccess.selectOne方法的具體用法？Python DbAccess.selectOne怎麽用？Python DbAccess.selectOne使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類hgu.db.DbAccess的用法示例。


在下文中一共展示了DbAccess.selectOne方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Python代碼示例。

示例1: getByAccessionId

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByAccessionId(accessionId):
    """
    Returns the submission record with the given accession (public) ID, or None, if
    record does not exit.  Throws exception if more than one record exists.

    accessionId: The public ID of the submission, e.g., ERG:123.
    """

    sqlAccessionId = DbAccess.formatSqlValue(accessionId)
    
    if IshSubmissionDbRecord(DbAccess.selectOne(_table, ACCESSION_ID_COLUMN + " = " + sqlAccessionId)) == None:
        print "NONE"
        
    return IshSubmissionDbRecord(DbAccess.selectOne(
        _table, ACCESSION_ID_COLUMN + " = " + sqlAccessionId))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:17，代碼來源:IshSubmissionDb.py

示例2: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(exprOid):
    """
    Return the ISH_PATTERN DB record with the given OID.
    """

    return IshPatternDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + str(exprOid)))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:9，代碼來源:IshPatternDb.py

示例3: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(versionOid):
    """
    Return the VERSION DB record with the given OID.
    """

    return AnaVersionDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + str(versionOid)))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:9，代碼來源:AnaVersionDb.py

示例4: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(exprOid):
    """
    Return the ISH_EXPRESSION DB record with the given OID.
    """

    return IshExpressionDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + DbAccess.formatSqlValue(exprOid)))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:9，代碼來源:IshExpressionDb.py

示例5: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(nodeOid):
    """
    Return the NODE DB record with the given OID.
    """

    return AnaNodeDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + DbAccess.formatSqlValue(nodeOid)))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:9，代碼來源:AnaNodeDb.py

示例6: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(exprOid):
    """
    Return the ISH_IMAGE_NOTE DB record with the given OID.
    """

    return IshImageNoteDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + str(exprOid)))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:9，代碼來源:IshImageNoteDb.py

示例7: getBySubmissionOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getBySubmissionOid(subOid):
    """
    Returns the probe record with the given submission OID, or None, if
    record does not exit.  Throws exception if more than one record exists.
    """

    sqlOid = DbAccess.formatSqlValue(subOid)
    return IshProbeDbRecord(DbAccess.selectOne(
        _table, SUBMISSION_OID_COLUMN + " = " + sqlOid))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:11，代碼來源:IshProbeDb.py

示例8: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(apoOid):
    """
    Return the AND_PART_OF record with the given OID.  Returns None
    if no record with that OID exists.
    """
    where = (
        "where " + OID_COLUMN + " = " + DbAccess.formatSqlValue(apoOid))

    return DbAccess.selectOne(_table, where)
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:11，代碼來源:AnadPartOfDb.py

示例9: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(oid):
    """
    Returns the submission record with the given OID, or None, if
    record does not exit.  Throws exception if more than one record exists.
    """

    sqlOid = DbAccess.formatSqlValue(oid)
    return IshSubmissionDbRecord(DbAccess.selectOne(
        _table, OID_COLUMN + " = " + sqlOid))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:11，代碼來源:IshSubmissionDb.py

示例10: getBySubFk

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getBySubFk(subfk):
    """
    Returns the sample row with the given Sub ID (FK), 
     or None, if row does not exist.
      Throws exception if more than one record exists.
    """

    sqlSubFk = DbAccess.formatSqlValue(subfk)
    return MicSampleDbRecord(DbAccess.selectOne(
        _table, SUB_FK + " = " + sqlSubFk))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:12，代碼來源:MicSampleDb.py

示例11: getByFileName

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByFileName(fname):
    """
    Returns the sample row with the given File Name,
     or None, if row does not exist.
      Throws exception if more than one record exists.
    """

    sqlFname = DbAccess.formatSqlValue(fname)
    return MicSampleDbRecord(DbAccess.selectOne(
        _table, FILE_NAME_COLUMN + " = " + sqlFname))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:12，代碼來源:MicSampleDb.py

示例12: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(oid):
    """
    Returns the sample row with the given OID, 
     or None, if row does not exist.
      Throws exception if more than one record exists.
    """

    sqlOid = DbAccess.formatSqlValue(oid)
    return MicSeriesDbRecord(DbAccess.selectOne(
        _table, OID_COLUMN + " = " + sqlOid))
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:12，代碼來源:MicSeriesDb.py

示例13: getByOid

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByOid(timedNodeOid):
    """
    Return the TIMED NODE DB record with the given OID.
    """

    dbRecord = DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + DbAccess.formatSqlValue(timedNodeOid))
    if dbRecord:
        return AnaTimedNodeDbRecord(dbRecord)
    else:
        return None
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:13，代碼來源:AnaTimedNodeDb.py

示例14: getLatestVersion

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getLatestVersion():
    """
    Return the newest VERSION DB record.
    """

    return AnaVersionDbRecord(
        DbAccess.selectOne(
            _table,
            where = (
                DATE_COLUMN + " = (select max(" + DATE_COLUMN + ") from " +
                TABLE_NAME + ")" ) ) )
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:13，代碼來源:AnaVersionDb.py

示例15: getByDisplayId

# 需要導入模塊: from hgu.db import DbAccess [as 別名]
# 或者: from hgu.db.DbAccess import selectOne [as 別名]
def getByDisplayId(timedDisplayId):
    """
    Return the TIMED NODE DB record with the given display ID.
    """

    dbRecord = DbAccess.selectOne(
        _table, where = (DISPLAY_ID_COLUMN + " = " +
                         DbAccess.formatSqlValue(timedDisplayId)))
    if dbRecord:
        return AnaTimedNodeDbRecord(dbRecord)
    else:
        return None
開發者ID:ma-tech，項目名稱:Anatomy，代碼行數:14，代碼來源:AnaTimedNodeDb.py


注：本文中的hgu.db.DbAccess.selectOne方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。