Another swing at TurboGears.
Up to bat with PostgreSQL.
FOUL BALL.
Any suggestions?

OS:
Windows 2000 SP4


Installed:
Python 2.4.2
PostgreSQL 8.1.3
Win-psycopg2 2.0b8 from
http://stickpeople.com/projects/python/win-psycopg/
Turbo Gears .9a4


dev.cfg and prod.cfg:
sqlobject.dburi="postgres://[EMAIL PROTECTED]:5432/ajaxdb"


model.py:
hub = PackageHub("ajaxdb")
__connection__ = hub
class User(SQLObject):
        email = StringCol(alternateID=True)
        lists = MultipleJoin('List')
class List(SQLObject):
        title = UnicodeCol(notNone=True)
        user = ForeignKey('User')
        items = MultipleJoin('Item')
class Item(SQLObject):
        value = UnicodeCol(notNone=True)
        list = ForeignKey('List')


Result for tg-admin sql create:
Using database URI postgres://[EMAIL PROTECTED]:5432/ajaxdb
Exception exceptions.AttributeError: "PostgresConnection instance has
no attribu
te '_connection'" in <bound method Transaction.__del__ of
<sqlobject.dbconnectio
n.Transaction object at 0x01261C70>> ignored
Exception exceptions.AttributeError: "PostgresConnection instance has
no attribu
te '_connection'" in <bound method Transaction.__del__ of
<sqlobject.dbconnectio
n.Transaction object at 0x0129D890>> ignored
Traceback (most recent call last):
  File "C:\Python24\Scripts\tg-admin-script.py", line 7, in ?
    sys.exit(
  File
"c:\python24\lib\site-packages\TurboGears-0.9a4-py2.4.egg\turbogears\comm

and\base.py", line 262, in main
    command.run()
  File
"c:\python24\lib\site-packages\TurboGears-0.9a4-py2.4.egg\turbogears\comm

and\base.py", line 121, in run
    command.the_runner.run(sys.argv)
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\manager\command.py", line 102, in run
    runner.run()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\manager\command.py", line 233, in run
    self.command()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\manager\command.py", line 550, in command
    exists = soClass._connection.tableExists(soClass.sqlmeta.table)
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\postgres\pgconnection.py", line 176, in tableExists
    result = self.queryOne(query)
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\dbconnection.py", line 348, in queryOne
    return self._runWithConnection(self._queryOne, s)
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\dbconnection.py", line 217, in _runWithConnection
    conn = self.getConnection()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\dbconnection.py", line 228, in getConnection
    conn = self.makeConnection()
  File
"c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1675-py2.4.egg\sqlobje

ct\postgres\pgconnection.py", line 110, in makeConnection
    conn = self.module.connect(**self.dsn_dict)
TypeError: an integer is required


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" 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/turbogears
-~----------~----~----~----~------~----~------~--~---

Reply via email to