On Jul 20, 2010, at 5:10 PM, Lukasz Szybalski wrote:
>
>
> On Jul 20, 3:46 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
>> 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....
>>
> Sorry, I think I'm reading it wrong.
>
> a=session.query().from_statement("assp_ReportDailyTransactions
> @start_date=:start,
> @end_date=:end").params(start="20100701",end="20100719").all()
query() needs to have entities. Here's an example:
http://www.sqlalchemy.org/docs/ormtutorial.html#using-literal-sql
>
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/
> SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/orm/query.py", line 1453, in all
> return list(self)
> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/
> SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/orm/query.py", line 1565, in
> __iter__
> return self._execute_and_instances(context)
> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/
> SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/orm/query.py", line 1570, in
> _execute_and_instances
> mapper=self._mapper_zero_or_none())
> File "/home/lucas/tmp/sql2008/env/lib/python2.5/site-packages/
> SQLAlchemy-0.6.3-py2.5.egg/sqlalchemy/orm/query.py", line 276, in
> _mapper_zero_or_none
> if not getattr(self._entities[0], 'primary_entity', False):
> IndexError: list index out of range
>
> Thanks,
> Lucas
>
>
>
>>
>>
>>> 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 sqlalch...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> sqlalchemy+unsubscr...@googlegroups.com.
>>> For more options, visit this group
>>> athttp://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.
> 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.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
