Looks like DBSprockets is following the assumptions of sqlalchemy backends which support autoincrement primary keys. Not sure what the right solution to this is, perhaps Chris will have an idea...
Oh, and I'm ccing the dbsprockets mailing list, because it's likely that there be more information to be found there too ;) On Thu, Nov 13, 2008 at 5:31 PM, martin1701 <[EMAIL PROTECTED]> wrote: > > ### Works with sqlite > $ paster quickstart webapp > > uncomment the admin = DBMechanic(... line and the imports in webapp/ > controllers/root.py > > $ paster setup-app development.ini > $ paster serve development.ini > > table view of > tg_group............................................works!!! > http://localhost:8080/admin/tableView/tg_group_permission > > ### switch project to Oracle > 1) modify development.ini > change sqlalchemy.url = oracle://user/[EMAIL PROTECTED]:1521/sid > 2) modify webapp/model/auth.py > remove onupdate="CASCADE" from table definitions > add Sequence('s_name') to group_id, user_id, permission_id > column definitions > > $ paster setup-app development.ini > $ paster serve development.ini > > table view of tg_group.....................................errors! > http://localhost:8080/admin/tableView/tg_group_permission > > Error Traceback: > ⇝ KeyError: 'group_id' > > Module ?:14 in <Expression u'col.get_field(row)'> view > << <tr py:for="i, row in enumerate(value)" > class="${i%2 and 'odd' or 'even'}"> > <td py:for="col in columns">${col.get_field(row)}</td> > </tr> > </tbody> >>> <td py:for="col in columns">${col.get_field(row)}</td> > Module tw.forms.datagrid:55 in get_field view > Module dbsprockets.viewconfig:1 in <lambda> view > KeyError: 'group_id' > > PS. After downloading the latest TG2 today, I was able to get the same > error > easy_install -i http://www.turbogears.org/2.0/downloads/1.9.7b1/index > tg.devtools > > > > > -- Mark Ramm-Christensen email: mark at compoundthinking dot com blog: www.compoundthinking.com/blog --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears Trunk" 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-trunk?hl=en -~----------~----~----~----~------~----~------~--~---
