Re: [Sqlrelay-discussion] Zope adapter limit of 1001 records?

[David M. <dav...@fi...>]

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