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 <samsli...@gmail.com>
> 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 <p...@phd.pp.ru> 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/ p...@phd.pp.ru
>> 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
>> sqlobject-discuss@lists.sourceforge.net
>> 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
> sqlobject-discuss@lists.sourceforge.net
> 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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
