[Zope] "migration" issues - 2.2.4 -> 2.30

Andy Dustman andy@dustman.net
Mon, 29 Jan 2001 09:52:49 -0500 (EST)


On Sun, 28 Jan 2001, Lee wrote:

> 2- MySQL DBA. I'm not responsible for installing Zope or the MySQL DBA
> on the Unix machine but from what I understand, people have had a few
> problems working with MySQL DBA. What problems can I expect?

The main problem seems to be that there are three distinct versions of
ZMySQLDA available:

1.1.3 - very old version which uses MySQLmodule-1.4, which is also very
old. There may be a 1.1.4 which has been adapted to use MySQLdb.

1.2.x - a somewhat newer version designed to use MySQLdb (not sure what
the status is of this)

2.0.4 - my version, derived from the ZOracleDA, adapted to use
MySQLdb-0.3.x. Issues: Returns INTEGER columns as Python longs (by design,
to avoid overflows on INTEGER UNSIGNED columns), and Python 1.5.2 appends
an L when converting to a string with str(). Can't put in your own LIMIT
clause unless you set max_rows on the Z SQL Method to zero; max_rows=0
with no LIMIT clauses returns zero rows instead of all of them (fixed in
upcoming MySQLdb-0.3.2, will not require a ZMySQLDA update).

-- 
Andy Dustman         PGP: 0xC72F3F1D
    @       .net     http://dustman.net/andy
"Normally with carbonara you use eggs, but I used lobster brains instead."
    -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle