summaryrefslogtreecommitdiffstats
path: root/databaseReset.py
diff options
context:
space:
mode:
authorsubstantialnoninfringinguser <substantialnoninfringinguser@gmail.com>2009-05-13 05:16:55 +0100
committersubstantialnoninfringinguser <substantialnoninfringinguser@gmail.com>2009-05-13 05:16:55 +0100
commitf336d146f3354ba09ee1abdf0bfc217add4f392c (patch)
treebd10d78fbb8251a50d107b4d46b76c4d2a02b843 /databaseReset.py
parent33fad37eb004d07598eb202f72548c57c9abc8ab (diff)
downloadtroggle-f336d146f3354ba09ee1abdf0bfc217add4f392c.tar.gz
troggle-f336d146f3354ba09ee1abdf0bfc217add4f392c.tar.bz2
troggle-f336d146f3354ba09ee1abdf0bfc217add4f392c.zip
[svn] Moved and improved reset script from the parsers directory
Copied from http://cucc@cucc.survex.com/svn/trunk/expoweb/troggle/, rev. 8052 by julian @ 11/2/2008 11:14 PM
Diffstat (limited to 'databaseReset.py')
-rw-r--r--databaseReset.py22
1 files changed, 22 insertions, 0 deletions
diff --git a/databaseReset.py b/databaseReset.py
new file mode 100644
index 0000000..c0e4da4
--- /dev/null
+++ b/databaseReset.py
@@ -0,0 +1,22 @@
+import os
+import settings
+os.environ['PYTHONPATH'] = settings.PYTHON_PATH
+os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'
+from django.core import management
+from django.db import connection
+
+cursor = connection.cursor()
+cursor.execute("drop database %s" % settings.DATABASE_NAME)
+cursor.execute("create database %s" % settings.DATABASE_NAME)
+cursor.execute("ALTER DATABASE %s CHARACTER SET=utf8" % settings.DATABASE_NAME)
+cursor.execute("USE %s" % settings.DATABASE_NAME)
+management.call_command('syncdb')
+from django.contrib.auth.models import User
+user = User.objects.create_user('m', 'm@m.com', 'm')
+user.is_staff = True
+user.is_superuser = True
+user.save()
+
+import parsers.cavetab
+import parsers.survex
+#import parsers.logbooks \ No newline at end of file