working spyce web server no longer works after upgrade

"Noel Quintos" <[email protected]> Tue, 24 Jun 2008 23:58:55 -0400

Newsgroups	gmane.comp.python.spyce.general
Message-ID	<[email protected]>

Hi there!

I already have a working Spyce web server running SqlAlchemy-0.4.0 on
Postgresql. Then, I decided to buy a new PC and develop it there but
my web displays that used to run on the old PC installation would not
run anymore.

The following web page would display/run without any error:


<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY>
  This is a test whether it works on spy
<BR>
[[\
li = db.customer.select()
]]
<TABLE>
   <TH>Name</TH><TH>Address</TH>
[[ for s in li: { ]]
<TR>
    <TD>[[=s.customer]]</TD><TD>[[=s.address]]</TD>
</TR>
[[ } ]]
</TABLE>
</BODY>
</HTML>

However, if I replace "db.customer.select()" with "db.customer.all()"
and call the file test3.spy, I have the following error message:

File: /home/postgres/farmers/www/test3.spy
Message: AttributeError: all

Stack: /home/postgres/spyce-2.1/sqlalchemy/orm/query.py:303, in __getattr__:
raise AttributeError(key)
/home/postgres/spyce-2.1/sqlalchemy/ext/sqlsoup.py:313, in __getattr__:
return getattr(cls._query, attr)
test3.spy:9, in (main):
li = db.customer.all()


I also tried doing it manually on the interactive python shell and
db.customer.all() does not raise any error at all! Whats wrong?
Thanks!

Noel


-- 
Noel P. Quintos

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php