Re: [Sqlrelay-discussion] Zope adapter limit of 1001 records?
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] Zope adapter limit of 1001 records?
|
From: Cameron L. <cla...@gm...> - 2009-07-08 11:48:02
|
Marvelous! Many thanks. I'll spend a couple of days shaking down changes in our code, and then get back to you so I can begin to repay you by helping modernize ZSQLRelayDA. Do you work with Zope? You seem to have quite a span, being comfortable wrangling the adapters for several different languages and/or frameworks. On Tue, Jul 7, 2009 at 10:57 PM, David Muse <dav...@fi...>wrote: > Hey Cameron, > > I figured out the 1001 rows issue. By default, a ZSQLMethod has a limit > of 1000 rows and passes this limit into the ZSQLRelayDA adapter when it > runs the query. To change this, click the Advanced tab of the > ZSQLMethod and set the "Maximum rows to retrieve" setting to a larger > number. > > If you have a gazillion ZSQLMethods, then you can probably modify > lib/python/Shared/DC/ZRDB/DA.py and change the line: > > max_rows_=1000 > > to something else. > > Arguably the ZSQLRelayDA adapter does have a bug that's causing it to > retrieve 1001 rather than 1000 rows. > > > Aside from that though, the adapter doesn't work with Zope 2.11 or > higher because it uses several deprecated objects and attributes. So, > that does need to be fixed, ideally in a back-compatible way. > > Dave > dav...@fi... > > Cameron Laird wrote: > > Super! > > > > Yes, I'm ready to commit to a few hours a week on the Zope (and > > Python?) adapter for SQL Relay. We can follow-up in this same thread > > once we have a technical solution. In the meantime, I'll reply > > privately so we can set up a development environment and maintenance > > plan for me. > > > > On Tue, Jun 30, 2009 at 10:01 PM, David Muse > > <dav...@fi... <mailto:dav...@fi...>> wrote: > > > > Someone else reported this issue a while back. I was able to > > reproduce > > it, but I didn't spend enough time to track down the exact source. > > > > I plan on putting in some time later this week working on this and > > other > > issues and getting a release out as soon as possible. > > > > If you guys are willing to put in some work updating and > > maintaining the > > adapter, then I'd be happy to include the updates in the official > > distro. I'd be grateful if you'd maintain it going forward as well. > > > > Most of the language bindings and adapters were written, > > contributed and > > maintained by others, and then eventually they quit maintaining > > them and > > I took over. Some of them I haven't done too much maintenance on :) > > Most are up-to-date because they mimic the c/c++ api, but the ones > > that > > don't (zope, python db, php pear db, perl dbi, etc.) I usually > > just run > > some quick tests on to make sure they haven't gotten really broken. > > Some may have had long standing bugs that were never addressed. > > > > David Muse > > dav...@fi... <mailto:dav...@fi...> > > > > Cameron Laird wrote: > > > We have well-reproducible cases that suggest a Z SQLRelay Database > > > Connection truncates its results at 1001 records. I welcome any > > > information on my alternatives. I've searched without success for > > > similar results. > > > > > > Happiest, of course, would be to find that there's some way to > > > configure the Database Connection to accept larger results. > > > > > > More broadly, are there any plans to maintain this adapter? It > > > appears to be at least six years old. We've collected a few > > definite > > > errors or at least version skews (improper handling of MONEY > > datatype, > > > ...). We'd be open to shouldering the responsibility of > maintenance > > > for the adapter, and/or paying others (firstworks?) to do so. > > > > > > -- > > > > > > Cameron Laird > > > +1 817 280 1145 Building 27, Q2/#35 > > > +1 281 648 9889 > > > > > > ------------------------------------------------------------------------ > > > > > > > > > ------------------------------------------------------------------------------ > > > > > > __________________________________________________ > > > D O T E A S Y - "Join the web hosting revolution!" > > > http://www.doteasy.com > > > > > > ------------------------------------------------------------------------ > > > > > > _______________________________________________ > > > Sqlrelay-discussion mailing list > > > Sql...@li... > > <mailto:Sql...@li...> > > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > __________________________________________________ > > > D O T E A S Y - "Join the web hosting revolution!" > > > http://www.doteasy.com > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > <mailto:Sql...@li...> > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > -- > > > > Cameron Laird > > +1 817 280 1145 Building 27, Q2/#35 > > +1 281 648 9889 > > ------------------------------------------------------------------------ > > > > > ------------------------------------------------------------------------------ > > > > __________________________________________________ > > D O T E A S Y - "Join the web hosting revolution!" > > http://www.doteasy.com > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > __________________________________________________ > > D O T E A S Y - "Join the web hosting revolution!" > > http://www.doteasy.com > > > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > -- Cameron Laird +1 817 280 1145 Building 27, Q2/#35 +1 281 648 9889 |
