On 2/10/07, David Abrahams <[EMAIL PROTECTED]> wrote:
>
> Whatever django bugs may be lurking asid, I need to move forward with
> my project ASAP so I'd really appreciate it if someone could give me a
> few hints about how to evolve my existing DB (which was created
> without the primary_key=True and (I think) also without null=True) so
> I can still use the data.
Disclamer: I know almost nothing about databases.
Oh, this is a (new) hint. You are not sure if you created your data when
the Session -> Track ForeignKey had null=True? If it hadn' t and you are
now trying to modify it it to use that option without also modifying the DB,
it's not that strange you are getting errors.
You could confirm that by examining the table stucture. Use:
$ ./manage.py sql program
twice, once without null=True and once with null=True, to see the difference
and eventually create the ALTER TABLE SQL sentence to modify to reflect
the change you' ve made to your model without losing your valuable data.
This is using sqlite3:
--- nonull.txt 2007-02-10 19:29:23.000000000 -0300
+++ nulltrue.txt 2007-02-10 19:28:48.000000000 -0300
@@ -13,13 +13,13 @@
CREATE TABLE "program_session" (
"id" integer NOT NULL PRIMARY KEY,
"title" varchar(200) NOT NULL,
"short_title" varchar(50) NOT NULL,
"description" text NOT NULL,
"start_id" integer NOT NULL REFERENCES "program_timedivision" ("id"),
- "track_id" integer NOT NULL REFERENCES "program_track" ("id"),
+ "track_id" integer NULL REFERENCES "program_track" ("id"),
"duration" time NOT NULL,
UNIQUE ("start_id", "track_id"),
UNIQUE ("title")
);
CREATE TABLE "program_speaker" (
"id" integer NOT NULL PRIMARY KEY,
Regards,
--
Ramiro Morales
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
