Hey Djangoers,
In my first words I would like to THANK all the Django developers for
such a wonderful tool! I used it all through my work on my MSc thesis.
I've built a database browsing tool, a dedicated data inspection and
basic analysis tools. I've also implemented a basic set algebra in
Django which allowed to pick sets of objects based on tag
presence/absence rules. I wouldn't be able to accomplish this task
without Django. Thanks!
I'm going to start using Django for the next project. I'm running a
forum based on PhpBB. I wish to create an add-on, a small Django app.
The application will use some data from PhpBB tables and have some
tables on its own. I want the PhpBB tables to remain intact.
The application will allow users to log in, using PhpBB logins and
passwords. I've already read relevant docs about Django auth module. It
looks all good to me (i.e. doable). However, there is one problem.
I've created a ForumUser class which sits on top of the legacy
"phpbb_users" table. There is "User" class from django.contrib.auth.
- both classes need to remain intact
- I need to create a 1-1 relation between them
I can't add any fields neither to User nor to ForumUser (I don't want an
extra column in the "phpbb_user" table). I've come up with this idea:
class DjangoPhpbbUserMapping(models.Model):
django_user = models.OneToOneField(User)
phpbb_user = models.OneToOneField(ForumUser)
It would be great if it worked. But...
--------------------------------------------------------------
$ ./manage.py syncdb
Creating table phpbb_djangophpbbusermapping
Traceback (most recent call last):
File "./manage.py", line 11, in ?
execute_manager(settings)
File "/usr/lib/python2.4/site-packages/django/core/management.py", line 1447,
in execute_manager
execute_from_command_line(action_mapping, argv)
File "/usr/lib/python2.4/site-packages/django/core/management.py", line 1355,
in execute_from_command_line
action_mapping[action](int(options.verbosity), options.interactive)
File "/usr/lib/python2.4/site-packages/django/core/management.py", line 486,
in syncdb
cursor.execute(statement)
File "/usr/lib/python2.4/site-packages/django/db/backends/util.py", line 12,
in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.4/site-packages/django/db/backends/mysql/base.py",
line 42, in execute
return self.cursor.execute(sql, params)
File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 137, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 33, in
defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1068, 'Multiple primary key defined')
--------------------------------------------------------------
Do you have any ideas how to solve my problem? Should the above class be
valid and should Django successfully create the tables? Or is there some
other way to map objects from two classes in 1-1 manner without creating
additional columns in their database tables?
Maciej
--
Maciej Bliziński
http://automatthias.wordpress.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
