X-Git-Url: https://git.stderr.nl/gitweb?p=matthijs%2Fprojects%2Fxerxes.git;a=blobdiff_plain;f=import.py;h=58205ac59deba2d7d07fbcf24784736ca807a463;hp=1e77c90b10123c1a1ea767af95b954666eba0d27;hb=a974141892f10ff9f89908d878d1246f3983fe66;hpb=c2998045cc19b7b4fd960375c53acc2aa390467a diff --git a/import.py b/import.py index 1e77c90..58205ac 100644 --- a/import.py +++ b/import.py @@ -2,11 +2,11 @@ import sys import os sys.path = sys.path + [os.path.dirname(os.path.dirname(os.path.abspath(__file__)))] -os.environ['DJANGO_SETTINGS_MODULE']='ee.settings' +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: