Oh, just read a little better... wanted to clarify...<br>
<br>
""" It doesnt work with stored procedures though. I put a patch up on sourceforge in July, for the ZMySQLDA. """<br>
<br>
Mysql-python works fine fine, as you said Andy, it's just the Zope DA.<br>
<br>
Greg<br>
<br>
(I hate it when reply-all doesnt send to zope list too)<br><br><div><span class="gmail_quote">On 10/7/05, <b class="gmail_sendername">Greg Fischer</b> <<a href="mailto:retheoff@gmail.com">retheoff@gmail.com</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">It doesnt work with stored procedures though. I put a patch up on sourceforge in July, for the ZMySQLDA.
<br>
<br>
<a href="http://sourceforge.net/tracker/index.php?func=detail&aid=1242842&group_id=22307&atid=374934" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://sourceforge.net/tracker/index.php?func=detail&aid=1242842&group_id=22307&atid=374934
</a>
<br>
<br>
I probably didnt do it right, but I at least wanted to get the info up
there. (maybe should have listed a bug?) MySQLdb works fine
directly from python, but the DA doesnt open a connection with the
right client_flags. It needs MULTI_STATEMENTS.<br>
<br>
I just added this to db.py in _parse_connection_string, right before it parses the socket. (line 234, I think)<br>
<br>
if not items: return kwargs<br>
kwargs['client_flag'], items = int(items[0]), items[1:]<br>
<br>
One caveat, you must use a dash to turn off transactions. I don't
know why that is, or how to get around it. But, with that patch,
and a connection string like the one below, it works great!<br>
<br>
-adatabase auser apassword 65536 /tmp/mysql.sock<br>
<br>
I just wanted to specify the client_flags before the socket.
Before you couldnt specify them at all. On Linux this was fine,
but on Windows, if memory serves, the mysql.c had some issues. Maybe
needs compiled with new libs?<br>
<br>
Anyway, like I said on that patch post, there is probably a better way
to tackle the issue. I just did it this way, and it works for me.
Though, the transaction thing needs attention.<br><span class="sg">
<br>
Greg</span><div><span class="e" id="q_106cd4a33bc8dc5c_2"><br>
<br>
<br><br><div><span class="gmail_quote">On 10/7/05, <b class="gmail_sendername">Andy Dustman</b> <<a href="mailto:farcepest@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">farcepest@gmail.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 10/7/05, Tres Seaver <<a href="mailto:tseaver@palladion.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">tseaver@palladion.com</a>> wrote:<br>> Greg Fischer wrote:<br>><br>> > I guess it's not a matter of should, but rather a preference. I am running
<br>> > it just fine on Linux. Had to do some tweeks to the ZMySQLDA, but it works<br>> > great. Stored Procedures and everything. I just havent seen hardly anyone<br>> > testing it, so I thought I would ask around and see if others are running it
<br>> > too.<br>><br>> Cool. Could you send the patches for your tweaks to the ZMySQLDA<br>> maintainer (Andy Dustman, I believe)? Maybe it would be better to<br>> upload them to the SourceForge patches page:
<br><br>I've done a small amount of testing with MySQLdb-1.2.0 and MySQL-5.0,<br>and there don't seem to be any issues, so ZMySQLDA-2.0.9 (latest beta)<br>ought to work as well. There is a bugfix that needs to be applied (for
<br>the "tried to unlock unlocked lock" issue), but this should already be<br>in the bug tracker on sourceforge.<br><br>--<br>Computer interfaces should never be made of meat.<br><a href="http://www.terrybisson.com/meat.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.terrybisson.com/meat.html</a><br></blockquote></div><br><br clear="all"><br></span></div><div><span class="e" id="q_106cd4a33bc8dc5c_3">-- <br>Greg Fischer<br>1st Byte Solutions<br><a href="http://www.1stbyte.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.1stbyte.com</a>
</span></div></blockquote></div><br><br clear="all"><br>-- <br>Greg Fischer<br>1st Byte Solutions<br><a href="http://www.1stbyte.com">http://www.1stbyte.com</a>