[Zope] Gadfly Problem with 2.0b?

[Jesse D. Sightler]

I was testing out Gadfly 2.0b on my 486 server here <g>, and it seems
that I can't get Gadfly to read an existing database.  All that I did
was copy the files for the database over from
/usr/www/users/jsight/biddin/pyPit/programsdatabase to
/home/jsight/Zope/var/gadfly/programsdatabase.  I did a cd to the
database's directory under Zope and opened up the Python interepreter
and opened the database with
"connection=gadfly.gadfly('.','pyProgramsDatabase')".  This worked, so I
got a cursor and did a "cursor.execute ('select * from pyLibraries')"
and printed the results.  All was fine up until this point.

Then I used my browser to open the management screens for Zope, added a
connection to "programsdatabase" and added a new SQL method with no
arguments which consisted of "select * from pyLibraries".  However, from
here when I click add and test it tells me that there exists no relation
pyLibraries!  Could someone please explain to me why this might happen? 
Perhaps there is something that I am missing in regards to how to
actually setup the database connectin?  All of the status screens say
that the connection is open, though.

Here is the full output from the test:

Z SQL Method at /pyPit / all_entries 


Error, exceptions.NameError: 'PYLIBRARIES' no such relation in DB 

SQL used:

select *
from pyLibraries







Traceback (innermost last):
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py,
line 256, in publish_module
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py,
line 161, in publish
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/mapply.py,
line 154, in mapply
    (Object: manage_test)
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/ZPublisher/Publish.py,
line 98, in call_object
    (Object: manage_test)
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py,
line 310, in manage_test
    (Object: all_entries)
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py,
line 291, in manage_test
    (Object: all_entries)
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py,
line 395, in __call__
    (Object: all_entries)
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/db.py,
line 175, in query
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gadfly.py,
line 339, in execute
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/sqlsem.py,
line 2604, in relbind
  File
/home/jsight/Zope-2.0.0b1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/gfdb0.py,
line 305, in bindings
NameError: (see above)




-- 
---------------
Jesse D. Sightler
http://www.biddin.com/pyPit/