X-Git-Url: https://git.stderr.nl/gitweb?a=blobdiff_plain;f=import.py;h=58205ac59deba2d7d07fbcf24784736ca807a463;hb=86800ade2dc1966a05ddc437ca67111dd87fd34f;hp=d1d5e421a202d68a7c3c529d264aa5f5d99489a3;hpb=df3058d295e7475798be7c288ae3575f54b4b732;p=matthijs%2Fprojects%2Fxerxes.git diff --git a/import.py b/import.py index d1d5e42..58205ac 100644 --- a/import.py +++ b/import.py @@ -1,12 +1,12 @@ import sys import os -sys.path = sys.path + ['/home/matthijs/docs/src/django'] -os.environ['DJANGO_SETTINGS_MODULE']='ee.settings' +sys.path = sys.path + [os.path.dirname(os.path.dirname(os.path.abspath(__file__)))] +os.environ['DJANGO_SETTINGS_MODULE']='xerxes.settings' import MySQLdb from django.contrib.auth.models import User -from ee.base.models import UserProfile +from xerxes.base.models import UserProfile from datetime import datetime conn = MySQLdb.connect( @@ -31,6 +31,11 @@ for row in c.fetchall(): except User.DoesNotExist: u = User(username=username) + if row[1]: + su = 1 + else: + su = 0 + c.execute("SELECT dyn_prop.name, dyn_prop_value.value" " FROM dyn_prop_value, dyn_prop WHERE" " dyn_prop_value.dynamicPropertyObjectId=%s AND" @@ -40,10 +45,6 @@ for row in c.fetchall(): for row in c.fetchall(): props[row[0]] = row[1] - if row[1]: - su = 1 - else: - su = 0 u.is_superuser = su u.is_staff = su names = props.get('Naam','').split(' ', 1) @@ -79,3 +80,4 @@ for row in c.fetchall(): p.save() except Exception: print props +# vim: set sts=4 sw=4 expandtab: