I am converting an old web based system from TCL to Python and I am using
SQLObject to help me out with the task. Here's my structure:
CREATE TABLE users (
id int ....);
CREATE TABLE roles (
CREATE TABLE user_roles (
As you can see, this does *not* follow any type of standard. I wish that it
did, but it would be big work to make a change to standardize it.
I am trying to use RelatedJoin to map Users to Roles, and Roles to Users but
am failing miserably. I have tried it what seems like 100 different ways, but
a synario is (in Users class):
roles = RelatedJoin('Roles', intermediateTable='user_roles')
This obviously cannot work because of the goofy naming in user_roles, but how
*can* I make it work?