Hi Michael~
thank you very much for your answer~
can you give me an example?
I really don't know..how to use it...
thanks a lot~
2010/4/20 Michael Bayer <mike...@zzzcomputing.com>
> use a text() construct as the argument to your from_statement() call, and
> specify a "typemap" of {'birthday':NormalDate} along with it.
>
>
> http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html?highlight=text#sqlalchemy.sql.expression.text
>
>
>
> On Apr 19, 2010, at 5:38 AM, Rita Liang wrote:
>
> > I have a custom type NormalDate which uses to convert Integer Date
> > type to String Date type.
> >
> > but when I use form_statement to query the date.it did't work!
> >
> > however,it will work, if I use a query method...
> >
> > for example.
> >
> > crew = query.from_statement("SELECT * from crew_member where " +
> >
> > "rtrim(crew_member.lastname) || rtrim(crew_member.firstname) " +
> > " like '%" + crew_name
> > + "%'").first()
> >
> > this will not work. crew.birthday shows "41274135"
> >
> >
> > but " user = query.filter(CrewMember.last_name.like(u'%j
> > %'.encode('gbk'))).first()" works well.
> >
> > and the crew.birthday shows "1969/06/23" this is want I want....
> >
> > anybody any suggestion?
> >
> > --
> > 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<sqlalchemy%2bunsubscr...@googlegroups.com>
> .
> > For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
> >
>
> --
> 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<sqlalchemy%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
Rita Liang
--
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.
