错误使用添加Python中的多对多关系壳
问题描述:
从一开始后.save()的时候,我创建的表在我MyApp文件夹,并从壳跑错误使用添加Python中的多对多关系壳
蟒蛇manage.py SQL MYAPP
其然后产生预期的输出 >
BEGIN;
CREATE TABLE "myapp_dude" (
"id" integer NOT NULL PRIMARY KEY,
"name" varchar(128) NOT NULL
)
;
CREATE TABLE "myapp_group_members" (
"id" integer NOT NULL PRIMARY KEY,
"group_id" integer NOT NULL,
"dude_id" integer NOT NULL REFERENCES "myapp_dude" ("id"),
UNIQUE ("group_id", "dude_id")
)
;
CREATE TABLE "myapp_group" (
"id" integer NOT NULL PRIMARY KEY,
"name" varchar(128) NOT NULL
)
;
CREATE TABLE "myapp_membership" (
"id" integer NOT NULL PRIMARY KEY,
"dude_id" integer NOT NULL REFERENCES "myapp_dude" ("id"),
"group_id" integer NOT NULL REFERENCES "myapp_group" ("id"),
"date_joined" date NOT NULL,
"invite_reason" varchar(64) NOT NULL
)
;
COMMIT;
我然后同步的数据库,并开始运行该蟒壳。它接受所有参数到我的表中,并适当地添加名称/组,甚至会员的作品,但是,当我试图简单地保存它时,我得到以下错误。
>>> from myapp.models import Membership, Group, Dude
>>> from datetime import date
>>> ringo = Dude.objects.create(name="Ringo Starr")
>>> paul = Dude.objects.create(name="Paul McCartney")
>>> beatles = Group.objects.create(name="The Beatles")
>>> m1 = Membership(dude=ringo, group=beatles,
... date_joined=date(1962, 8, 16),
... invite_reason="Needed a new drummer.")
>>> m1.save()
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "C:\Python27\lib\site-packages\django\db\models\base.py", line 460, in sa
ve
self.save_base(using=using, force_insert=force_insert, force_update=force_up
date)
File "C:\Python27\lib\site-packages\django\db\models\base.py", line 553, in sa
ve_base
result = manager._insert(values, return_id=update_pk, using=using)
File "C:\Python27\lib\site-packages\django\db\models\manager.py", line 195, in
_insert
return insert_query(self.model, values, **kwargs)
File "C:\Python27\lib\site-packages\django\db\models\query.py", line 1436, in
insert_query
return query.get_compiler(using=using).execute_sql(return_id)
File "C:\Python27\lib\site-packages\django\db\models\sql\compiler.py", line 79
1, in execute_sql
cursor = super(SQLInsertCompiler, self).execute_sql(None)
File "C:\Python27\lib\site-packages\django\db\models\sql\compiler.py", line 73
5, in execute_sql
cursor.execute(sql, params)
File "C:\Python27\lib\site-packages\django\db\backends\util.py", line 34, in e
xecute
return self.cursor.execute(sql, params)
File "C:\Python27\lib\site-packages\django\db\backends\sqlite3\base.py", line
234, in execute
return Database.Cursor.execute(self, query, params)
DatabaseError: table myapp_membership has no column named dude_id
我完全投入循环使用这一点,因为你可以看到,在创建表时,有创造了“dude_id”一栏,但在错误信息的底部,它说,它没有一个。而且,我可以添加到花花公子,并添加到会员表罚款,但不能保存也没有多大意义。我已经通过这个网站,谷歌,你的名字,但我一直无法找到一个解决方案,这一个..任何见解将非常感谢!
答
你能确保你的数据库有dude_id
,因为我认为它没有。这可能会发生,因为syncdb
如果它们已存在不会重新创建表。
请让这个问题的背景更清楚,例如,将django添加到标签。 – aquavitae 2012-03-11 13:18:43