Re: [SQLObject] Paramaterized queryAll...

[Frank W. <fra...@no...>]

I absolutely second that!
I'd love to see parameterized queries in SQLObject, but am unfortunately not
a skilled enough programmer to do this kind of work ...

Frank




2009/8/16 Sam's Lists <sam...@gm...>

> Oleg....
>
> I'm not sure I'm the one to do the merge, you wrote the code, and you seem
> to know more about SQLObject than anyone else in the world, including I'd
> guess Ian at this point.
>
> But it does seem like a really cool, and important feature.  So if you do
> decide to merge it at some point, thank you!  I know I'll benefit from it
> and so will many other SQLObject users.
>
> Thanks
> Sam
>
>
> On Sat, Aug 15, 2009 at 7:48 AM, Oleg Broytmann <ph...@ph...> wrote:
>
>> On Fri, Aug 14, 2009 at 10:19:23PM -0700, Sam's Lists wrote:
>> > QueryAll and QueryOne work okay with strings.
>> >
>> > But I'd like to be able to pass parameterized queries to them.  Am I
>> correct
>> > that this is not supported?  What are my options?
>> >
>> > I.e. something like this:
>> >
>> > queryAll('select * from stocks where symbol=?', (symbol,))
>> >
>> > (My actual queries are much more complicated, of course).
>>
>>    The best thing would be to merge my work on the parameterized queries
>> at
>> http://svn.colorstudy.com/home/phd/SQLObject/paramstyles/ . Look at
>> sqlobject/include/DBSingleStyle.py and sqlobject/dbconnection.py. I was
>> working on the branch and wanted to merge it into mainline, but at that
>> time Luke Opperman merged his work (all SELECT implementations moved to
>> SQLBuilder, and all implementations use unified sqlbuilder.Select) and the
>> paramstyles branch became too much incompatible with the mainline, so I
>> dropped it. Now it requires a lot of work to be merged; actually I think
>> most of the work needs to be redone almost from the beginning; the work
>> must change SQLBuilder instead of DBConnection.
>>
>>   The second option is to create query strings yourself using
>> SQLBuilder.Select or just string interpolation.
>>
>> Oleg.
>> --
>>     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
>>           Programmers don't die, they just GOSUB without RETURN.
>>
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> sqlobject-discuss mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
>