Re: Support for Federated MySql table?

2007-11-30 Thread James Bennett

On 11/30/07, Gloria W <[EMAIL PROTECTED]> wrote:
> The problem I have is that the manage.py inspectdb dumps a table which
> matches my sql table in construct, but no info about being federated.
> So an objects.filter() on some of these fields is failing, although I
> can see the fields when I iterate over the records.

The 'inspectdb' command is meant to be a starting point for
integrating with an existing database; it does not, cannot and will
not be aware of every conceivable thing your database is capable of,
so you'll often need to review the generated models and add any
information it didn't pick up (MySQL in particular is notoriously hard
to introspect because of the way is various storage engines handle
foreign keys).

Manually adding the appropriate fields to the model file should be all
you need to do in this case.

-- 
"Bureaucrat Conrad, you are technically correct -- the best kind of correct."

--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---



Support for Federated MySql table?

2007-11-30 Thread Gloria W

Hi, I'm using Django 0.95 on Python2.4, and it seems that it doesn't
fully support federated tables in Mysql.

The problem I have is that the manage.py inspectdb dumps a table which
matches my sql table in construct, but no info about being federated.
So an objects.filter() on some of these fields is failing, although I
can see the fields when I iterate over the records.

Any help or pointers to good docs on Django's handling of federated
tables and foreign keys (for another problem I'm having) would be
greatly appreciated.

Thank you,
Gloria
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---