Can anyone give me an idea of what I need to do here? If I can just get a high level overview of what I need to do, I am happy to read the documentation and source to fill in the details.
Thanks. On Oct 1, 1:56 pm, Randy Syring <[email protected]> wrote: > Mike, > > Thank you for the prompt reply: > > On Oct 1, 1:11 pm, "Michael Bayer" <[email protected]> wrote: > > >RandySyring wrote: > > > I'm not sure of the context here. are you generating code or just > > executing SQL ? > > Ok, maybe a small example. Here is a declarative object and the how > the datagrid gets defined: > > http://paste.pocoo.org/show/142448/ > > Note that the datagrid currently accepts the column from the table or > the declarative attribute. It would also accept an elixir attribute. > > Then, inside the datagrid library, I have references to those objects > that were passed in. Use them to construct SQL based on options > selected by the user. So, a user might request something like: > > /foo?filteron=firstname&filteronop=ne&filterfor=test* > > and we would generate something like: > > SELECT persons.id AS persons_id, persons.firstname AS > persons_firstname, persons.last_name AS persons_last_name > FROM persons > WHERE persons.firstname NOT LIKE 'test' > > run that against the DB and then return the results in an HTML table. > > The way we generate the SQL is by using the SA/Elixir column/ > attributes in a query, here is a small snippet of that: > > http://paste.pocoo.org/show/142453/ > > So, my problem currently is that in the above snippet, "ffor" might be > an empty string. That's fine if the column is a text type, but I have > to handle it differently if the column is a time stamp. I am also > assuming I will run into other problems related to the type of column > being used that I will need to handle. But, I can't currently handle > those situations b/c I don't know enough about the SA objects to > figure what type they are. > > > if the latter wouldn't you be using TypeEngine subclasses > > to handle coersion of type values ? > > And that's where you lose me, sorry. All I know is that I have an SA > table column, SA declarative attribute, or elixir entity attribute and > I need to figure out what "type" of SA column they represent (i.e. > DateTime, Time, Date, etc.). I really have no idea what it will take > to bridge the gap, hence this post. :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
