Python db.DbAccess類代碼示例

    def insert(self):
        """
        Generate SQL to insert this record into the database.
        """
        # import here to avoid obscure circular import problem
        from hgu.db import DbAccess

        columnNames = None
        columnValues = None

        for name, value in self.__columnValues.items():
            sqlValue = DbAccess.formatSqlValue(value)
            if columnNames:
                columnNames += ", " + name
                columnValues += ", " + sqlValue
            else:
                columnNames = name
                columnValues = sqlValue

        query = """
            insert into """ + self.getTableName() + """
                ( """ + columnNames + """ )
              values
                ( """ + columnValues + """ );"""

        DbAccess.writeSql(query)

        return

def getByOid(nodeOid):
    """
    Return the NODE DB record with the given OID.
    """

    return AnaNodeDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + DbAccess.formatSqlValue(nodeOid)))

def getByOid(exprOid):
    """
    Return the ISH_EXPRESSION DB record with the given OID.
    """

    return IshExpressionDbRecord(DbAccess.selectOne(
        _table, where = OID_COLUMN + " = " + DbAccess.formatSqlValue(exprOid)))

def getByAncestorOid(ancestorOid, relType = Relationships.PART_OF):
    """
    Return the all records with given OID as ancestor.
    """

    if relType != Relationships.PART_OF:
        # Take this error check out if and when we support transitive
        # closure of other relationship types.
        Util.fatalError([
            "AnadRelationshipTransitive.getByAncestorOid() currently only",
            "works with " + Relationships.PART_OF + " relationships."])

    ancestorIter = Iterator(
        where = (
            ANCESTOR_OID_COLUMN + " = " +
            DbAccess.formatSqlValue(ancestorOid) +
            " and " +
            RELATIONSHIP_TYPE_NAME_COLUMN + " = " +
            DbAccess.formatSqlValue(relType)))

    rels = []

    for dbRec in ancestorIter:
        rels.append(dbRec)

    return rels

    def deleteAll(self):
        """
        Delete every record in the table.
        """
        delete = "delete from " + self.getName() + ";"
        DbAccess.writeSql(delete)

        return

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))

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)

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))

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))

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))

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))

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

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

def getByLocalId(localId):
    """
    Returns the submission record with the given local ID, or None, if
    record does not exit.  Throws exception if more than one record exists.

    localId: The ID the submission had back when it was a submission in
             an EMAGE style local database.  (That is, when it was an XML
             file in a collection of XML files.)
    """

    sqlLocalId = DbAccess.formatSqlValue(localId)
    return IshSubmissionDbRecord(DbAccess.selectOne(
        _table, LOCAL_ID_COLUMN + " = " + sqlLocalId))

def deleteAllBySubmissionOid(submissionOid):
    """
    Delete all expression records for the given submission OID.
    """
    # :TODO: Add delete support to DbAccess and/or DbTable so all caller has
    #        to provide is the where clause.
    delete = (
        "delete from " + TABLE_NAME +
        "  where " + SUBMISSION_OID_COLUMN + " = " +
        DbAccess.formatSqlValue(submissionOid) + ";")

    DbAccess.writeSql(delete)

    return