# force password entry to be manual
password = getpass.getpass()
try:
con = None
con = mdb.connect(hostname, username, password, database)
cur = con.cursor(mdb.cursors.DictCursor)
cur.execute("SELECT * FROM auth_user")
rows = cur.fetchall()
except mdb.Error, e:
raise CommandError("Error %d: %s" % (e.args[0], e.args[1]))
finally:
if con:
con.close()
for du in rows:
user = CRITsUser.objects(username=du['username']).first()
if not user:
user = CRITsUser()
user.username = du['username']
user.password = du['password']
user.date_joined = du['date_joined']
user.email = du['email']
user.first_name = du['first_name']
user.last_name = du['last_name']
user.is_active = True if du['is_active'] else False
user.is_staff = True if du['is_staff'] else False
user.is_superuser = True if du['is_superuser'] else False
user.last_login = du['last_login']
user.save()
