Hi,
Is it possible to supply bindparam a clause type?
I want to execute a query of the form
select * from f(:a, :b,:c)
where :b might be either a String or a function.
if :b is a function, i'd like to do something like:
s=select(["col1" , "col2", "col3"], from_obj=func.f(bindparam('a'),
bindparam('b' , type=Clause) ) )
and
clause_variant_1 = func.bbox( bindparam('x1') , bindparam('y1'),
bindparam('y2'), bindparam('y2'))
clause_variant_2= text("some funny value")
when i execute o'd like to do something like:
connection.execute(s, a="vala", c="valc", b= clause_variant_1, x1=11,
x2=12, y1=2, y2=3 )
or, alernativelly
connection.execute(s, a="vala", c="valc", b= clause_variant_2)
I already realized that i could set parameters with params, and then
compile SQL expressions
would perhaps this be a more accurate approach ?:
connection.execute(s, a="vala", c="valc", b=
clause_variant_1.params( x1=11, x2=12, y1=2, y2=3).compile() ).
I'm kind of stuck here
cheers,
Paul
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
