Thanks for pointing me to South. I've glanced over it, but I did have one question:
My understanding is that Django will introduce tables for models that have been added on a syncdb, but not alter tables for models that have been changed. And from a glance at the documentation, it looks like South would provide more granularity. However, it is my understanding that this should have the consequence that if you start with a fresh database and run syncdb, then that should result in appropriate tables. This might not be a first choice way to update the database as normally wiping the database when you implement a schema update is not desirable if you have any real data, but my understanding from the documentation is that this forceful solution should work. If I'm mistaken, I'd like to know both how I presently misunderstand, and what an appropriate way is to generate a fresh database with tables matching your models. On Fri, Jun 25, 2010 at 5:25 PM, Mark Linsey <[email protected]> wrote: > I don't quite understand what changes you made before producing this error, > and I'm totally unfamiliar with sqllite. > > But I do know that for many (really, most) different model changes, just > running syncdb will not make the appropriate changes to your tables. You > probably need to look into south migrations. > > On Fri, Jun 25, 2010 at 2:09 PM, Jonathan Hayward < > [email protected]> wrote: > >> P.S. Renaming the (SQLite) database file and running syncdb again produces >> (basically) the same behavior. I had to do some initialization things again, >> but outside of that I got equivalent behavior to what I pasted below. >> >> What I am trying to do is create a few instances of the Entity model >> defined in my [directory/]models.py. So far I have managed to get them to >> show up as an option to manage in the admin interface, but not yet to save >> one. >> >> Should it be looking for directory_models_entity instead of >> directory_entity? "entity" seems not to be populated; from the command line >> sqlite3: >> >> sqlite> .tables >> auth_group auth_user_user_permissions >> auth_group_permissions django_admin_log >> auth_message django_content_type >> auth_permission django_session >> auth_user django_site >> auth_user_groups >> >> On Fri, Jun 25, 2010 at 3:00 PM, Jonathan Hayward < >> [email protected]> wrote: >> >>> I received the error below from the admin interface; I thought it was >>> because I needed to run a syncdb, but stopping the server, running a syncdb, >>> and restarting has generated the same error: >>> >>> OperationalError at /admin/directory/entity/ >>> >>> no such table: directory_entity >>> >>> Request Method:GET Request URL: >>> http://linux:8000/admin/directory/entity/ Exception Type: >>> OperationalError Exception Value: >>> >>> no such table: directory_entity >>> >>> Exception >>> Location:/usr/lib/pymodules/python2.6/django/db/backends/sqlite3/base.py >>> in execute, line 193 Python Executable:/usr/bin/python Python Version: >>> 2.6.5 Python Path:['/home/jonathan/directory', >>> '/usr/local/lib/python2.6/dist-packages/pip-0.6.3-py2.6.egg', >>> '/home/jonathan/store/src/satchmo/satchmo/apps', >>> '/usr/local/lib/python2.6/dist-packages/django_threaded_multihost-1.3_3-py2.6.egg', >>> '/usr/local/lib/python2.6/dist-packages/django_signals_ahoy-0.1_1-py2.6.egg', >>> '/usr/local/lib/python2.6/dist-packages/django_tagging-0.3.1-py2.6.egg', >>> '/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', >>> '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', >>> '/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages', >>> '/usr/lib/python2.6/dist-packages/PIL', >>> '/usr/lib/python2.6/dist-packages/gst-0.10', '/usr/lib/pymodules/python2.6', >>> '/usr/lib/python2.6/dist-packages/gtk-2.0', >>> '/usr/lib/pymodules/python2.6/gtk-2.0', >>> '/usr/local/lib/python2.6/dist-packages'] Server time:Fri, 25 Jun 2010 >>> 14:56:26 -0500 >>> >>> I have an Entity class/model defined in my models.py and want to manually >>> create some dummy data in the table. Any suggestions? >>> >>> -- >>> → Jonathan Hayward, [email protected] >>> → An Orthodox Christian author: theology, literature, et cetera. >>> → My award-winning collection is available for free reading online: >>> ☩ I invite you to visit my main site at http://JonathansCorner.com/ >>> >> >> >> >> -- >> → Jonathan Hayward, [email protected] >> → An Orthodox Christian author: theology, literature, et cetera. >> → My award-winning collection is available for free reading online: >> ☩ I invite you to visit my main site at http://JonathansCorner.com/ >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<django-users%[email protected]> >> . >> 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<django-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- → Jonathan Hayward, [email protected] → An Orthodox Christian author: theology, literature, et cetera. → My award-winning collection is available for free reading online: ☩ I invite you to visit my main site at http://JonathansCorner.com/ -- You received this message because you are subscribed to the Google Groups "Django users" 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-users?hl=en.
