This is probably SQL limitation, as group is a keyword.
Cheers,
Simon
Enigma Curry wrote:
> Hi, I've been designing a new model this morning and I ran into a bug
> or a misconception on my part.
>
> Here is my very simple model to illustrate the problem:
>
> from sqlobject import *
> from turbogears.database import PackageHub
> # Uncomment the following line if you wish to use Identity and
> SO_Provider
> #from turbogears.identity.soprovider import TG_User, TG_Group,
> TG_Permission
>
> hub = PackageHub("enigmacurryblog")
> __connection__ = hub
>
> class Group(SQLObject):
> stuff = StringCol(length=10)
>
> When I do a "tg-admin sql create" I get the following traceback:
> Using database URI
> sqlite:///airlock/subversion/blog/EnigmaCurryBlog/enigmacurry.sqlite
> Traceback (most recent call last):
> File "/usr/local/bin/tg-admin", line 7, in ?
> sys.exit(
> File
> "/usr/lib64/python2.4/site-packages/TurboGears-0.9a1-py2.4.egg/turbogears/command
> /base.py", line 270, in main
> command.run()
> File
> "/usr/lib64/python2.4/site-packages/TurboGears-0.9a1-py2.4.egg/turbogears/command
> /base.py", line 129, in run
> command.the_runner.run(sys.argv)
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> manager/command.py", line 102, in run
> runner.run()
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> manager/command.py", line 233, in run
> self.command()
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> manager/command.py", line 569, in command
> soClass.createTable()
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> main.py", line 1322, in createTable
> conn.createTable(cls)
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> dbconnection.py", line 522, in createTable
> self.query(self.createTableSQL(soClass))
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> dbconnection.py", line 303, in query
> return self._runWithConnection(self._query, s)
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> dbconnection.py", line 217, in _runWithConnection
> val = meth(conn, *args)
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> dbconnection.py", line 300, in _query
> self._executeRetry(conn, conn.cursor(), s)
> File
> "/usr/lib64/python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
> dbconnection.py", line 295, in _executeRetry
> return cursor.execute(query)
> pysqlite2.dbapi2.OperationalError: near "group": syntax error
>
>
> If I rename my class from Group to something else I get no error. Is
> the word Group reserved somehow? I haven't tested another database
> server yet as it does appear to be sqlite that is producing the final
> error.
>
> If Group is reserved somehow it would be nice if there were a pre-parse
> step to "tg-admin sql create" that created a better error message.
> Also, maybe we put a warning in ModelDesigner too of class names people
> can't use.
>
> Using Turbogears 0.9a1
>
>
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
