Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.

#1 March 25, 2008 18:01:27

J.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

SQL woes


Hi,
1) This is my first time posting, I hope someone can lead me in a
direction of a good django wiki or the like to get this kind of info
from in the future.

2) My question is, I have noticed that when I change things in the
models.py of my project, and then run manage.py syncdb, after that I
get OperationalError: no such table:

So I am using SQLite, and maybe the problem is coming from that... I
can destroy the records (as theyre all foo at this point) I am just
looking for how to.... I guess the real question, how do I ask django
to erase the db entirely and build the new one based on 'models'.
--~--~---------~--~----~------------~-------~--~----~
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
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

#2 March 25, 2008 18:13:55

Karen T.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

SQL woes


On Tue, Mar 25, 2008 at 1:01 PM, Jacob <> wrote:

>
> Hi,
> 1) This is my first time posting, I hope someone can lead me in a
> direction of a good django wiki or the like to get this kind of info
> from in the future.
>
> 2) My question is, I have noticed that when I change things in the
> models.py of my project, and then run manage.py syncdb, after that I
> get OperationalError: no such table:
>
> So I am using SQLite, and maybe the problem is coming from that... I
> can destroy the records (as theyre all foo at this point) I am just
> looking for how to.... I guess the real question, how do I ask django
> to erase the db entirely and build the new one based on 'models'.
>

manage.py reset

drops your old tables and re-creates them per the doc here:http://www.djangoproject.com/documentation/django-admin/Karen

--~--~---------~--~----~------------~-------~--~----~
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
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

#3 March 25, 2008 19:01:57

J.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

SQL woes


That worked nice!

I read through the page you linked and cannot find, is there a more
clean way of doing this?

So if I basically need the tables rebuilt, but I want to retain the
records, is there a command?

On Mar 25, 10:13 am, "Karen Tracey" <> wrote:
> On Tue, Mar 25, 2008 at 1:01 PM, Jacob <> wrote:
>
> > Hi,
> > 1) This is my first time posting, I hope someone can lead me in a
> > direction of a good django wiki or the like to get this kind of info
> > from in the future.
>
> > 2) My question is, I have noticed that when I change things in the
> > models.py of my project, and then run manage.py syncdb, after that I
> > get OperationalError: no such table:
>
> > So I am using SQLite, and maybe the problem is coming from that... I
> > can destroy the records (as theyre all foo at this point) I am just
> > looking for how to.... I guess the real question, how do I ask django
> > to erase the db entirely and build the new one based on 'models'.
>
> manage.py reset
>
> drops your old tables and re-creates them per the doc here:
>
>http://www.djangoproject.com/documentation/django-admin/>
> Karen
--~--~---------~--~----~------------~-------~--~----~
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
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

#4 March 25, 2008 22:44:55

Karen T.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

SQL woes


On Tue, Mar 25, 2008 at 2:01 PM, Jacob <> wrote:

>
> That worked nice!
>
> I read through the page you linked and cannot find, is there a more
> clean way of doing this?
>
> So if I basically need the tables rebuilt, but I want to retain the
> records, is there a command?
>

Sounds like you want schema evolution. I've not had any need for this so
haven't followed the topic, but my understanding is there are at least a
couple of external projects that help with this. You might want to check
out this page:http://code.djangoproject.com/wiki/SchemaEvolutionPerhaps someone with more interest in the topic can give better guidance.

Karen


> On Mar 25, 10:13 am, "Karen Tracey" <> wrote:
> > On Tue, Mar 25, 2008 at 1:01 PM, Jacob <> wrote:
> >
> > > Hi,
> > > 1) This is my first time posting, I hope someone can lead me in a
> > > direction of a good django wiki or the like to get this kind of info
> > > from in the future.
> >
> > > 2) My question is, I have noticed that when I change things in the
> > > models.py of my project, and then run manage.py syncdb, after that I
> > > get OperationalError: no such table:
> >
> > > So I am using SQLite, and maybe the problem is coming from that... I
> > > can destroy the records (as theyre all foo at this point) I am just
> > > looking for how to.... I guess the real question, how do I ask django
> > > to erase the db entirely and build the new one based on 'models'.
> >
> > manage.py reset
> >
> > drops your old tables and re-creates them per the doc here:
> >
> >http://www.djangoproject.com/documentation/django-admin/> >
> > Karen
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en-~----------~----~----~----~------~----~------~--~---

Offline

Board footer

Moderator control

Enjoy the 11th of December
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support