Using:
Windows XP
Python 2.4.2
TurboGears .9a6 (also fails with .9a5)
SQLite 3.3.5
Pysqlite 2.1.0.win32-py24
Brian's Tutorial
The SQLite implementation tests OK directly from Python.
The dev.cfg string:
sqlobject.dburi="sqlite:///C:/Turbogears/tuta/tuta.db"
also used sqlobject.dburi="sqlite:///C|/Turbogears/tuta/tuta.db"
The Model.py was adapted to work with postgresql (TUser for User and
the soClasses line). Yes it also failed with SQLite without the
changes.
Model.py
-----------------------------------------------------------------------------------
from sqlobject import *
from turbogears.database import PackageHub
hub = PackageHub("tuta")
__connection__ = hub
soClasses = ('TUser','List','Item')
class TUser(SQLObject):
email = StringCol(alternateID=True)
lists = MultipleJoin('List')
class List(SQLObject):
title = UnicodeCol(notNone=True)
user = ForeignKey('TUser')
items = MultipleJoin('Item')
class Item(SQLObject):
value = UnicodeCol(notNone=True)
list = ForeignKey('List')
-----------------------------------------------------------------------------------
The database file is created in the proper location but is empty.
The error reported:
pysqlite2.dbapi2.OperationalError: unable to open database file
Exception exceptions.AttributeError: "'pysqlite2.dbapi2.Connection'
object has n
o attribute 'autocommit'" in <bound method Transaction.__del__ of
<sqlobject.dbc
onnection.Transaction object at 0x01650DF0>> ignored
Any suggestions?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
