Re: [sqlalchemy] PyODBCConnector dbapi question

2010-04-02 Thread Bo Shi
Awesome! Thanks! We work with large amounts of time series data so we have high hopes for the c extension. Bo On Fri, Apr 2, 2010 at 2:38 PM, Michael Bayer mike...@zzzcomputing.com wrote: Michael Bayer wrote: Bo Shi wrote: pep 249 specifies list of tuples for fetchmany() and fetchall

Re: [sqlalchemy] PyODBCConnector dbapi question

2010-04-02 Thread Bo Shi
Hrm, some different errors pop up. I'll move the dialog to the ticket in question. http://www.sqlalchemy.org/trac/ticket/1757 On Fri, Apr 2, 2010 at 2:40 PM, Bo Shi bs1...@gmail.com wrote: Awesome!  Thanks! We work with large amounts of time series data so we have high hopes for the c

Re: [sqlalchemy] PyODBCConnector dbapi question

2010-03-30 Thread Bo Shi
for fetchone(), though I'm pretty sure it intends tuples there as well. On Mar 29, 2010, at 7:43 PM, Bo Shi wrote: Also, dunno if it's helpful or not, but this is a regression in 0.6beta3.  My dialect plugin works as is when using 0.6beta2. On Mon, Mar 29, 2010 at 7:41 PM, Bo Shi bs1...@gmail.com

[sqlalchemy] PyODBCConnector dbapi question

2010-03-29 Thread Bo Shi
assigned somewhere else? Thanks, Bo -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more

Re: [sqlalchemy] PyODBCConnector dbapi question

2010-03-29 Thread Bo Shi
, in process_rows for row in rows] TypeError: row must be a tuple Any idea what's going on? The stack trace isn't very informative, I'm afraid. On Mon, Mar 29, 2010 at 6:05 PM, Michael Bayer mike...@zzzcomputing.com wrote: Bo Shi wrote: Hello, I had a custom dialect based on the PyODBC

Re: [sqlalchemy] PyODBCConnector dbapi question

2010-03-29 Thread Bo Shi
Also, dunno if it's helpful or not, but this is a regression in 0.6beta3. My dialect plugin works as is when using 0.6beta2. On Mon, Mar 29, 2010 at 7:41 PM, Bo Shi bs1...@gmail.com wrote: Thanks, explicitly assigning self.dbapi in my dialect constructor seems to get around the exception. I

Re: [sqlalchemy] PyODBCConnector dbapi question

2010-03-29 Thread Bo Shi
how come the strack trace shows beta2 as the version number in the path ? Yeesh. My bad; I spoke too soon. As you had hypothesized, the error occurs only when I install using --with-cextensions (it doesn't have anything to do with beta2/3). Thanks, Bo On Mon, Mar 29, 2010 at 8:03 PM, Michael

Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-02-02 Thread Bo Shi
they're useful as Vertica is frustratingly secretive about everything) if you have time to review and comment. On Fri, Jan 15, 2010 at 2:57 PM, Bo Shi bs1...@gmail.com wrote: That's funny because Oracle and SQL server are utterly, totally different from a SQL quirks perspective.   If I were to pick

[sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-01-15 Thread Bo Shi
Hi All, I'm attempting to get rudimentary support for a Vertica deployment using an ODBC connector. According to their docs, their dialect is mostly compatible with Oracle and SQLServer dialects. create_engine() using 'mssql+pyodbc' seems to work but upon attempting to execute a simple select

Re: [sqlalchemy] Mixing matching connectors and dialects in 0.6

2010-01-15 Thread Bo Shi
That's funny because Oracle and SQL server are utterly, totally different from a SQL quirks perspective.   If I were to pick two dialects in SQLA that were *most* different from each other and also non-standard, those would be the two. I was a bit puzzled by this also (granted this was from

[sqlalchemy] pyodbc ini file

2009-12-04 Thread Bo Shi
normally be specified with the ini file? Thanks, Bo -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com

[sqlalchemy] Is there a way to get a list of bindparam() names from a pre-constructed select clause?

2009-02-20 Thread Bo
I have a select clause containing a subselect that may or may not have a bindparam... I haven't been able to dig up a way to get the list of bindparams in said clause. Is there a way to do this? --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: MySQL, unions and ordering

2008-12-06 Thread Bo Shi
Right; my bad - I misread the instructions. On Sat, Dec 6, 2008 at 9:41 AM, Michael Bayer [EMAIL PROTECTED] wrote: you'd say, s.alias().select() it makes subqueries which MySQL probably doesn't require. On Dec 5, 2008, at 10:35 PM, Bo Shi wrote: Thanks; the monkeypatch approach works

[sqlalchemy] MySQL, unions and ordering

2008-12-05 Thread Bo Shi
is meaningless/useless :-) -- Bo Shi 207-469-8264 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send

[sqlalchemy] Re: MySQL, unions and ordering

2008-12-05 Thread Bo Shi
, at 3:55 PM, Bo Shi wrote: Hi all, There appear to be some nuances to using order by statements with set operations like unions in MySQL but the following is allowed*: (SELECT a,b from DBA.tbl ORDER BY b LIMIT 5) UNION ALL (SELECT a,b from DBB.tbl ORDER BY b LIMIT 5) ORDER BY b When I

[sqlalchemy] Re: MySQL, unions and ordering

2008-12-05 Thread Bo Shi
table) ORDER BY foo On Dec 5, 2008, at 4:17 PM, Bo Shi wrote: Thanks for the quick response! The following does *not* work. Am I making the call incorrectly? sel = union_all(*[q.self_group() for q in querylist]) On Fri, Dec 5, 2008 at 4:08 PM, Michael Bayer [EMAIL PROTECTED] wrote

[sqlalchemy] Re: MySQL, unions and ordering

2008-12-05 Thread Bo Shi
) frozen_order_by() calls self_group() thereby generating a new select() so that the original is unchanged. On Dec 5, 2008, at 5:08 PM, Bo Shi wrote: Oh, check this out: (SA 0.4.7) from sqlalchemy import * s = select([x, y]).select_from(table) qlist = [s.limit(10).order_by('x').self_group(), s.limit

[sqlalchemy] Re: Problem using utf-8

2008-09-18 Thread Bo Shi
Switching to 1.2.2 and using connect_args = {'use_unicode': False,'charset': 'utf8'} works fine for me. Hi Jürgen, I'm curious; if you upgraded to 1.2.2, does the issue persist if you stop using connect_args = {'use_unicode': False,'charset': 'utf8'}? Bo On Thu, Sep 18, 2008 at 3:07 AM

[sqlalchemy] Re: Problem using utf-8

2008-09-17 Thread Bo Shi
I ran into a similar issue using MySQL-python-1.2.1_p2-1 (mysqldb) with SA 0.4.2p3-1. http://www.mail-archive.com/sqlalchemy@googlegroups.com/msg00373.html might shed some more light on this issue which might be a double encoding problem? Here is the subset of relevant keyword arguments we use