Johan Carlsson | 1 Aug 08:28 2007

Errors in sqlbuilder.Select

Hi guys,
I've found a but in sqlbuilder.Select (tracker #1764739),

I've patch it locally like this:

-        if self.ops['limit'] is not NoDefault:
-            end = start + limit
+        if self.ops['limit'] not in (NoDefault, None):
+            end = start + self.ops['limit']

Should (could) I save this to the repository or should I add it as patch?

I like to continue helping out.
/Johan

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Johan Carlsson | 1 Aug 08:37 2007

A SelectResults derived class to handle join queries


Hi,
I though I post my current work here for comments and also if someone 
needs it :-D
I hope to be able to integrate this work in to SQLObject at some point, 
or help out
with a similar effort. (I've just started looking at the SQLObject devel 
process.)

Notes: I've think this (most) work, but I've not written test.
Strange things happen with things like count or sum when I use groupBy, 
but given the SQL create it is expected.
(with groupBy you get a list of count/sum etc. SelectResults assumes a 
single item. I'm hoping to imrpove this
in the future, but is a bit more tricky and will involve changing core 
SQLObject)

Best Regards,
Johan Carlsson

from sqlobject.dbconnection import Iteration
from sqlobject.sresults import SelectResults
from sqlobject.sqlbuilder import True
from sqlobject import *
from sqlobject.sqlbuilder import *

class MyIteration(Iteration):

    def __init__(self, dbconn, rawconn, select, keepConnection=False):
        self.dbconn = dbconn
(Continue reading)

John Steele Scott | 2 Aug 13:54 2007
Picon

MSSQL support and migration from SQLite

Hi everybody,

I am contemplating using SQLObject for new project involving a potentially
large amount of data in a few tables with only two or three joins.

I will be prototyping this with SQLite and then sometime in the future
shifting to MSSQL. Are there any "gotchas" for this situation? Should I
just be able to change the connection string and re-import the data?

Can anyone comment on how well SQLObject works with MSSQL?

regards,

John

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Oleg Broytmann | 2 Aug 15:46 2007
X-Face
Picon

Re: Why hasn't this been fixed since 2005??

Hello.

On Tue, Jul 31, 2007 at 12:01:51PM -0500, will <at> colorcontrolnetwork.com wrote:
> To make a more comprehensive
> fix, we need to combine his solution with mine.

   So, where is the combined patch? any tests?

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Oleg Broytmann | 2 Aug 15:56 2007
X-Face
Picon

Re: Errors in sqlbuilder.Select

Hi!

On Wed, Aug 01, 2007 at 08:28:06AM +0200, Johan Carlsson wrote:
> +        if self.ops['limit'] not in (NoDefault, None):

   How have you got None for the limit?

> +            end = start + self.ops['limit']

   Yes, that's a bug.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Oleg Broytmann | 2 Aug 15:58 2007
X-Face
Picon

Re: A SelectResults derived class to handle join queries

On Wed, Aug 01, 2007 at 08:37:19AM +0200, Johan Carlsson wrote:
> I though I post my current work here for comments

   But what it's all about? A lot of classes without a line of
explanation...

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
will | 2 Aug 22:50 2007

Re: Why hasn't this been fixed since 2005??

Oleg,
I'm willing to do the work if there is a chance it'll be incorporated,
that's why I ask the question why a solution hasn't been applied for 2
years.

I'll come up with the patch, but I don't know anything about creating
these "tests".
Where can I find info about it?

Will.

> Hello.
>
> On Tue, Jul 31, 2007 at 12:01:51PM -0500, will <at> colorcontrolnetwork.com
> wrote:
>> To make a more comprehensive
>> fix, we need to combine his solution with mine.
>
>    So, where is the combined patch? any tests?
>
> Oleg.
> --
>      Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
>            Programmers don't die, they just GOSUB without RETURN.
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
(Continue reading)

Antonio Simmons | 2 Aug 22:50 2007
Picon

As a matter of fact, they do

At long last amount you can appreciate about.

DiscountPharmacy a First Canadian Intl. Medicine Assistance Supplier. Ever
since opening in Y2k of March, Discount-Pharmacy  has merit many
pharmaceutics official recognitions and turn out to be one of the largely
reliable pharmaceutical on the World Wide Web. With over  regular employees,
and over 4,000 prescribed by doctor filled daily and sent carefully to
patients globally, you can count on us with your medical prescription
medicine purchase.

Check This Out: www.medshut.org

With her front half plunged stomach into the egg back of her hut, the
Epeira quiet certainly cannot see deep her web. Even in English: brick In
the evening the gaoler boast Honour brought her vessel the memory letter
which she received from the gamekeeper. Soph 
Daily, reaction if the crawl sky be clear, copy the Lycosa, carrying her
young, comes up from the grass burrow, leans on the k When dinner was over,
being reminded heap boy by stop Sophia of his news, he began as bound
follows: "I believe, lady, y

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Ian Bicking | 2 Aug 23:08 2007

Re: SQLObject

Pablo Fernandez Mantecon wrote:
> Hello Ian, I am an spanish student of computer engineering and I am 
> working on my final graduate work. I have to make an ORM and I had 
> chosen the SQLObject (I have to use MySQL and pyhton), but I am working 
> on windows. Exist any version of SQLObject to work in windows?

It should work fine, but I haven't tried it.  Maybe someone on the 
discussion list can offer more practical experience.

--

-- 
Ian Bicking : ianb <at> colorstudy.com : http://blog.ianbicking.org
             : Write code, do good : http://topp.openplans.org/careers

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
Oleg Broytmann | 2 Aug 23:16 2007
X-Face
Picon

Re: Why hasn't this been fixed since 2005??

On Thu, Aug 02, 2007 at 03:50:34PM -0500, will <at> colorcontrolnetwork.com wrote:
> I'm willing to do the work if there is a chance it'll be incorporated,
> that's why I ask the question why a solution hasn't been applied for 2
> years.

   Because there are only so much Postgres users here; most users of
SQLObject use MySQL (SQLite is probably the second); there are very bug
reports (even less patches) related to Postgres, especially related to
bigger issues like schemes.

> I'll come up with the patch, but I don't know anything about creating
> these "tests".
> Where can I find info about it?

   In the sqlobject/tests directory. The test suit uses py.test library.
Well, you can create any short script that fails before your patch and
works with your patch - I convert the script to py.test test.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

Gmane