Keep code from running during syncdb

Question

I have some code that throws causes syncdb to throw an error (because it tries to access the model before the tables are created).

Is there a way to keep the code from running on syncdb? something like:

if not syncdb:
    run_some_code()

Thanks :)

edit: PS - I thought about using the post_init signal... for the code that accesses the db, is that a good idea?

More info

Here is some more info as requested :)

I've run into this a couple times, for instance... I was hacking on django-cron and determined it necessary to make sure there are not existing jobs when you load django (because it searches all the installed apps for jobs and adds them on load anyway).

So I added the following code to the top of the __init__.py file:

import sqlite3

try:
        # Delete all the old jobs from the database so they don't interfere with this instance of django
        oldJobs = models.Job.objects.all()
        for oldJob in oldJobs:
                oldJob.delete()
except sqlite3.OperationalError:
        # When you do syncdb for the first time, the table isn't 
        # there yet and throws a nasty error... until now
        pass

For obvious reasons this is crap. it's tied to sqlite and I'm there are better places to put this code (this is just how I happened upon the issue) but it works.

As you can see the error you get is Operational Error (in sqlite) and the stack trace says something along the lines of "table django_cron_job not found"

Solution

In the end, the goal was to run some code before any pages were loaded.

This can be accomplished by executing it in the urls.py file, since it has to be imported before a page can be served (obviously).

And I was able to remove that ugly try/except block :) Thank god (and S. Lott)

Answer 1

"edit: PS - I thought about using the post_init signal... for the code that accesses the db, is that a good idea?"

Never.

If you have code that's accessing the model before the tables are created, you have big, big problems. You're probably doing something seriously wrong.

Normally, you run syncdb approximately once. The database is created. And your web application uses the database.

Sometimes, you made a design change, drop and recreate the database. And then your web application uses that database for a long time.

You (generally) don't need code in an __init__.py module. You should (almost) never have executable code that does real work in an __init__.py module. It's very, very rare, and inappropriate for Django.

I'm not sure why you're messing with __init__.py when Django Cron says that you make your scheduling arrangements in urls.py.

---

Edit

Clearing records is one thing.

Messing around with __init__.py and Django-cron's base.py are clearly completely wrong ways to do this. If it's that complicated, you're doing it wrong.

It's impossible to tell what you're trying to do, but it should be trivial.

Your urls.py can only run after syncdb and after all of the ORM material has been configured and bound correctly.

Your urls.py could, for example, delete some rows and then add some rows to a table. At this point, all syncdb issues are out of the way.

Why don't you have your logic in urls.py?