o yeah!
I solved the question~
these are codes.hope it's useful to someone who have the same question~
crew = query.from_statement(text("SELECT * from crew_member where " +
"rtrim(crew_member.lastname)
|| rtrim(crew_member.firstname) " +
" like '%" + crew_name +
"%'", typemap = {'birthday' : NormalDate})).first()
by the way...I want to know ..why it be like this?
what is difference between from_statement query and filter query?
2010/4/20 Cancer <[email protected]>
> by the way....
>
> I read some document about how to use text()
>
> but it seems when I use text().I got records from database,not instances of
> class object.
>
> I want to get instance ....
>
> anyone can help me ?
>
> 2010/4/20 Cancer <[email protected]>
>
> 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 <[email protected]>
>>
>> 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 [email protected].
>>> > To unsubscribe from this group, send email to
>>> [email protected]<sqlalchemy%[email protected]>
>>> .
>>> > 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 [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected]<sqlalchemy%[email protected]>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/sqlalchemy?hl=en.
>>>
>>>
>>
>>
>> --
>> Rita Liang
>>
>
>
>
> --
> Rita Liang
>
--
Rita Liang
--
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.
