Thanks
now it works,
In time i posted the question syncdb did not generated database file
"referenc.db".
Thats i posted the question.
Now it works normally again.
regards,
gintare
On Mar 3, 6:02 pm, Matt McCants <mattmcca...@gmail.com> wrote:
> For sqlite3, you don't even need to create an empty db. Just put the desired
> filename in your settings.py for the database name and run
>
> python manage.py syncdb
>
> and the database will be created along with all the tables based on the
> models for all the installed apps. You don't actually need to run the sql
> command unless you're just interested in what Django is going to do when you
> run syncdb. Or you're going to manually run the SQL or modify it to alter
> existing structure.
>
> I'm not sure if I'm misunderstanding, but it sounds like you made the
> changes in the database without making the changes to your models. It's all
> about the models! Make the changes there then re-run syncdb. Hope this helps
> some. There really aren't any lines to change, just a process to follow.
>
> On Wed, Mar 3, 2010 at 1:47 AM, gintare <g.statk...@gmail.com> wrote:
> > Hello.
>
> > to summarize the question is
>
> > which lines has to be changed when the database file i.e, referenc.db
> > is deleted and later created manually as empty database?
>
> > The problem is that i created whole project a week before.
> > Later i modified modules, added new tables and new fields (Rrest
> > column was added for sure in table Areferenc_aref).
> > I deleted empty database file referenc.db, created new database file
> > referenc.db manually expecting that new tables will be generated with
> > additional fields for hem.
>
> > Nevertheless the django finds only old columns.
>
> > besides i made one check:
>
> > 1) first of all i totally deleted referenc.db again. For big surprise
> > command manage.py syncdb runs without mistakes.
>
> > Besides python manage.py sql Areferenc generates tables for non
> > existing database.
>
> > ^Cworking:/opt/pages/referenc# python manage.py sql Areferenc
>
> > BEGIN;
> > CREATE TABLE "Areferenc_aref" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rfirstauthor" varchar(500) NOT NULL,
> > "Rauthors" varchar(500) NOT NULL,
> > "Rjournal" varchar(500) NOT NULL,
> > "Rrest" varchar(500) NOT NULL,
> > "Rpage" varchar(500) NOT NULL,
> > "Rissue" integer NOT NULL,
> > "Rvolume" integer NOT NULL,
> > "Ryear" integer NOT NULL,
> > "Rtitle" varchar(500) NOT NULL,
> > "Rkeyw" varchar(500) NOT NULL,
> > "Rurl" varchar(200) NOT NULL,
> > "Rindex" varchar(500) NOT NULL,
> > "Rname" varchar(500) NOT NULL,
> > "Rdoi" varchar(500) NOT NULL,
> > "Rlink" varchar(100) NOT NULL,
> > "Rmail" varchar(75) NOT NULL,
> > "Rconcl" text NOT NULL,
> > "Rexists" bool NOT NULL,
> > "Rinst" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_experimental" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rexp" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_characterization" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rchar" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_devices" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rdev" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_calculations" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rcal" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_afieldorder" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "Rorder" varchar(500) NOT NULL
> > )
> > ;
> > CREATE TABLE "Areferenc_aref_Rexperimental" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "aref_id" integer NOT NULL REFERENCES "Areferenc_aref" ("id"),
> > "experimental_id" integer NOT NULL REFERENCES
> > "Areferenc_experimental" ("id"),
> > UNIQUE ("aref_id", "experimental_id")
> > )
> > ;
> > CREATE TABLE "Areferenc_aref_Rcharacterization" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "aref_id" integer NOT NULL REFERENCES "Areferenc_aref" ("id"),
> > "characterization_id" integer NOT NULL REFERENCES
> > "Areferenc_characterization" ("id"),
> > UNIQUE ("aref_id", "characterization_id")
> > )
> > ;
> > CREATE TABLE "Areferenc_aref_Rdevice" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "aref_id" integer NOT NULL REFERENCES "Areferenc_aref" ("id"),
> > "devices_id" integer NOT NULL REFERENCES
> > "Areferenc_devices" ("id"),
> > UNIQUE ("aref_id", "devices_id")
> > )
> > ;
> > CREATE TABLE "Areferenc_aref_Rcalculation" (
> > "id" integer NOT NULL PRIMARY KEY,
> > "aref_id" integer NOT NULL REFERENCES "Areferenc_aref" ("id"),
> > "calculations_id" integer NOT NULL REFERENCES
> > "Areferenc_calculations" ("id"),
> > UNIQUE ("aref_id", "calculations_id")
> > )
> > ;
> > COMMIT
>
> > 2) Secondly I created referenc.db in ./referenc manually again.
>
> > generated tables with command mentioned in step1 with the same output
> > (table Areferenc_aref contains column Rrest )
>
> > performed manage.py syncdb, which went fluently without mistakes.
>
> > executing view i am getting error:
>
> > Exception Type:
> > OperationalError
> > Exception Value:
> > table Areferenc_aref has no column named Rrest
> > Exception Location:
> > /usr/lib/python2.5/site-packages/django/db/backends/sqlite3/base.py in
> > execute, line 193
>
> > :
>
> > :
>
> > regards,
> > gintare
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Django users" group.
> > To post to this group, send email to django-us...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/django-users?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
