getting data into my first prototype with django.
I am prototyping an application called repository, syncdb builds my
tables and all seems to work in the admin interface.
However, I have 600 lines of data I want to use as the seed for my
main table. I have a sql file with INSERT commands stored in sql
folder named after the model (sql/date.sql)
Immediately after running syncdb, I insert the data with either
<python manage.py sqlall repository> or <python manage.py sqlcustom
repository>. This seems to work, it reads through the SQL and ends
with this:
INSERT INTO repository_date
(`labno`,`siteno`,`site`,`material`,`materialcomment`,`technique`,`d13`,`rcybp`,`error`,`ref`,`provtype`,`provenience`,`provenience2`,`generalcult`,`taxon`,`comments`)
VALUES
('ISGS-4242','14CM406','','CHG','','CNV','-26.7','430','70','Bevitt
1999','','','','','WLM','');
INSERT INTO repository_date
(`labno`,`siteno`,`site`,`material`,`materialcomment`,`technique`,`d13`,`rcybp`,`error`,`ref`,`provtype`,`provenience`,`provenience2`,`generalcult`,`taxon`,`comments`)
VALUES
('unk','14RH301','','MAZ','','AMS','-25.3','600','40','','','','','','WLM','');
CREATE INDEX "repository_date_5b0c863a" ON
"repository_date" ("siteno_id");
CREATE INDEX "repository_reference_6223029" ON
"repository_reference" ("site_id");COMMIT;
Problem is that when I try to access these data in the admin interface
or do dumpdata, nothing is there. I'm at a loss for why the data
aren't populating my database.
I appollogize if this is completely obvious, it's my first hack at web
development and as much as I love it, some things totally mystify my.
Thanks!
--
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 django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
No comments:
Post a Comment