I am sure there is a better way to do this, but...
In db.py, _parse_connection_string function, it would
be nice to have the ability to use 'client_flag'. This
is so we can use MySQL 5.x with stored procedures in
Zope. In Python, simply specifying the connection
option for client_flag is fine, but the Zope DA doesnt
give us that ability. Here is the lines I have added
(I believe line 234):
if not items: return kwargs
kwargs['client_flag'], items = int(items), items[1:]
This is just before the checking for 'unix_socket'
argument. (because, IMHO, you would want to specify
client_flag more often than unix_socket)
Maybe this is best implements as a checkbox option or
something else, but for me this at least works good.
One other thing to note, you must use a '-' (dash)
right before your connection string to disable
transaction. Not sure why, but it wouldnt work
properly using stored procedures without that.
My blog has more info:
Basically I want client_flag to be specified on the
connection string like so:
-adatabase auser apassword 65536
This enables MULTI_STATEMENTS.