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
