Seems like my ForeignKeys aren't working any more. This is my model
(abbreviated):
-----------------------------------
class Log(meta.Model):
id = meta.AutoField(primary_key=True)
jobid = meta.ForeignKey(Job, null=True)
status = meta.CharField(maxlength=1, default='U')
timestamp = meta.DateTimeField(auto_now_add=True)
log = meta.TextField()
uid = meta.CharField(maxlength=255)
class META:
db_table = 'log'
ordering = ['-timestamp']
------------------------------------
But when I try to run a simple get_list() against this I get this...
------------------------------------
>>> from django.models.jobmonitor import logs
>>> logs.get_list()
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.4/site-packages/django/utils/functional.py",
line 3, in _curried
return args[0](*(args[1:]+moreargs), **dict(kwargs.items() +
morekwargs.items()))
File "/usr/lib/python2.4/site-packages/django/core/meta/__init__.py",
line 1120, in function_get_list
return list(function_get_iterator(opts, klass, **kwargs))
File "/usr/lib/python2.4/site-packages/django/core/meta/__init__.py",
line 1103, in function_get_iterator
cursor.execute("SELECT " + (kwargs.get('distinct') and "DISTINCT "
or "") + ",".join(select) + sql, params)
File "/usr/lib/python2.4/site-packages/django/core/db/base.py", line
10, in execute
result = self.cursor.execute(sql, params)
psycopg.ProgrammingError: ERROR: column log.jobid_id does not exist
SELECT log.id,log.jobid_id,log.status,log.timestamp,log.log,log.uid
FROM log ORDER BY log.timestamp DESC
-----------------------------------
Any ideas where I'm going wrong? I'm not sure why it's appending "_id"
onto my fieldname for log.jobid here...
Thanks, Tom
