Re: [2.0-STABLE] 2 patches : db relationship pks, caseless datarows

From: Robert Zeigler (robert..uregumption.com)
Date: Tue Dec 11 2007 - 17:11:18 EST

  • Next message: Mikaël Cluseau: "Re: [2.0-STABLE] 2 patches : db relationship pks, caseless datarows"

    The case-sensitivity of at least some DBMS depends on the host OS.
    MYSQL, for instance, with MyISAM tables is case sensitive on case-
    sensitive operating systems, and case insensitive otherwise.

    Robert

    On Dec 11, 2007, at 12/113:34 PM , Mikaël Cluseau wrote:

    > Hello,
    >
    > I was using to-one relationships as primary keys and found that it
    > wasn't working. I made it working, the right way, I hope ;-).
    >
    > This patch modifies DataDomainInsertBucket.
    >
    > The second is to fix a problem I had with DB2/AS400 using custom
    > templates to fetch DataObjects : the column names returned by the
    > server
    > were in upper case, and Cayenne was expecting them in lower-case. My
    > fix
    > is to normalize the keys in the DataRow, overriding get/put methods. I
    > think SQL is case insensitive for schema/table/column names, so it
    > shouldn't be a problem with any DBMS (again, I hope).
    >
    > This patch modifies DataRow.
    >
    > Cheers,
    >
    > --
    > .~.
    > /V\ Mikaël Cluseau <mclusea..si.nc>
    > // \\
    > /( )\ ISI.NC +687 26.93.18
    > ^`~'^
    > <caseless_datarow.patch><db_relationship_pk.patch>

    This archive was generated by hypermail 2.0.0 : Tue Dec 11 2007 - 17:11:59 EST