On Jul 20, 2010, at 4:44 PM, Lukasz Szybalski wrote:
>
>> Session.execute() accepts strings that are converted to text():
>>
>> a=session.execute("assp_ReportDailyTransactions
>> @start_date=:start,@end_date=:end",
>> params={'start':"20100701",'end':"20100719"})
>
> Thanks,
> That does work.
>
> Is it possible to get each record to be returned as object instead of
> dictionary or change it so that it is similar object
> as ..session.query(....).all()?
sure, query.from_statement(), its in the ORM tutorial....
>
> I need to pass in the objects a[5] or do
>
> a=session.execute("assp_ReportDailyTransactions
> @start_date=:start,@end_date=:end",
> params={'start':"20100701",'end':"20100719"})
> new_record=a[5]
>
> print new_record.customername
> #call a function by passing the object
> process_client(new_record)
> #the process_client function can access records like
> new_record.clientname,new_record.transaction_date
>
> right now I get:
> a[5]
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> TypeError: 'ResultProxy' object is unindexable
>
> Do I convert the return or I use a different command?
>
> Thanks,
> Lucas
>
> --
> 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.
>
--
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.
