#4231: manage.py loaddata problem if app name is Capitalised
---------------------------------------------------+------------------------
Reporter: Mark Jarecki <[EMAIL PROTECTED]> | Owner: jacob
Status: new | Component: Uncategorized
Version: SVN | Keywords: loaddata
Stage: Unreviewed | Has_patch: 0
---------------------------------------------------+------------------------
System: Apache2.2.4, mod_python3.3.1, Python-2.5.1, postgresql-8.2.4,
psycopg2-2.0.5.1, latest django version.
Models:
{{{
class VenueType(models.Model):
venueTypeName = models.CharField(maxlength=200, db_index=True)
venueTypeSlug = models.SlugField(prepopulate_from=
('venueTypeName',), db_index=True)
class Admin:
pass
class Venue(models.Model):
venueSlug = models.SlugField(prepopulate_from=('venueName',),
unique=True, db_index=True)
venueType = models.ManyToManyField(VenueType,
filter_interface=models.HORIZONTAL)
}}}
Process:
{{{
./manage.py dumpdata --format=json Guide > guide.json
[Clear database]
./manage.py syncdb
./manage.py loaddata guide.json
}}}
Error:
{{{
Loading 'test' fixtures...
Installing json fixture 'test' from absolute path.
Installed 1 object(s) from 1 fixture(s)
Traceback (most recent call last):
File "./manage.py", line 11, in <module>
execute_manager(settings)
File "/opt/python/lib/python2.5/site-packages/django/core/
management.py", line 1674, in execute_manager
execute_from_command_line(action_mapping, argv)
File "/opt/python/lib/python2.5/site-packages/django/core/
management.py", line 1588, in execute_from_command_line
action_mapping[action](args[1:], int(options.verbosity))
File "/opt/python/lib/python2.5/site-packages/django/core/
management.py", line 1418, in load_data
cursor.execute(line)
File "/opt/python/lib/python2.5/site-packages/django/db/backends/
util.py", line 12, in execute
return self.cursor.execute(sql, params)
File "/opt/python/lib/python2.5/site-packages/django/db/backends/
postgresql/base.py", line 44, in execute
return self.cursor.execute(sql, [smart_basestring(p,
self.charset) for p in params])
psycopg.ProgrammingError: ERROR: relation "guide_venuetype_id_seq"
does not exist
SELECT setval('Guide_venuetype_id_seq', (SELECT max("id") FROM
"Guide_venuetype"));
}}}
Test file:
{{{
[{"pk": "1", "model": "Guide.venuetype", "fields": {"venueTypeSlug":
"stadium", "venueTypeName": "Stadium"}}]
}}}
./manage.py sqlall Guide output:
{{{
BEGIN;
CREATE TABLE "Guide_venuetype" (
"id" serial NOT NULL PRIMARY KEY,
"venueTypeName" varchar(200) NOT NULL,
"venueTypeSlug" varchar(50) NOT NULL
);
CREATE TABLE "Guide_venue" (
"id" serial NOT NULL PRIMARY KEY,
"venueName" varchar(200) NOT NULL,
"venueSlug" varchar(50) NOT NULL UNIQUE
);
CREATE TABLE "Guide_venue_venueType" (
"id" serial NOT NULL PRIMARY KEY,
"venue_id" integer NOT NULL REFERENCES "Guide_venue" ("id") DEFERRABLE
INITIALLY DEFERRED,
"venuetype_id" integer NOT NULL REFERENCES "Guide_venuetype" ("id")
DEFERRABLE INITIALLY DEFERRED,
UNIQUE ("venue_id", "venuetype_id")
);
CREATE INDEX "Guide_venuetype_venueTypeName" ON "Guide_venuetype"
("venueTypeName");
CREATE INDEX "Guide_venuetype_venueTypeSlug" ON "Guide_venuetype"
("venueTypeSlug");
CREATE INDEX "Guide_venue_venueName" ON "Guide_venue" ("venueName");
CREATE UNIQUE INDEX "Guide_venue_venueSlug" ON "Guide_venue"
("venueSlug");
COMMIT;
}}}
Link to Google Groups Django Users Discoussion:
[http://groups.google.com/group/django-
users/browse_thread/thread/56728d3bfd791639/3664b7e423ed8b43#3664b7e423ed8b43
Loaddata-issue]
I hope this is enough information.
--
Ticket URL: <http://code.djangoproject.com/ticket/4231>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
