I'm essentially building a tool for a large group of people that don't know
SQLalchemy, and will never care enough or want to know, about SQLalchemy or
SQL in general. And they need to be able to build queries to the dataset
based on really minimal information. All they would input are filter
conditions of "parameter operand value" and the system builds the rest of
the query. They should be able to update these values without having to
reset and rebuild the query.
The actual query build is a strange generic combination of SQLalchemy +
WTForms-Alchemy, but the pseudocode is something like
q = Query()
q.set_params(params=params) = the input parameters they are searching on
as {'X': '< 10'}
q.add_conditions() = builds and adds the filter clauses, something like
for parameter in parameters:
if parameter table not in the join:
On Wednesday, March 2, 2016 at 5:31:09 PM UTC-5, Simon King wrote:
>
> Out of interest, how are you building your query, and why do you need to
> be able to change the values afterwards?
>
> Simon
>
> > On 2 Mar 2016, at 21:59, Brian Cherinka <havo...@gmail.com <javascript:>>
> wrote:
> >
> > Thanks, Mike. This is excellent. That did the trick. That's much
> easier than what I was trying to do. Do you know if there is a way to
> auto bindparam every parameter I have in my Declarative Bases, if and when
> they get added into a filter? Basically, I need to allow the user to be
> able to modify any parameter they set after the fact, but I have a crazy
> amount of parameters to explicitly do this for.
> >
> > Cheers, Brian
> >
> > On Wednesday, March 2, 2016 at 4:28:46 PM UTC-5, Mike Bayer wrote:
> >
> >
> >
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "sqlalchemy" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an email to sqlalchemy+...@googlegroups.com <javascript:>.
> > To post to this group, send email to sqlal...@googlegroups.com
> <javascript:>.
> > Visit this group at https://groups.google.com/group/sqlalchemy.
> > For more options, visit https://groups.google.com/d/optout.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
