def migrateUsers(legacyDbPath):
conn = sqlite3.connect(legacyDbPath)
c = conn.cursor()
sql = "Select * from user order BY id asc"
for row in c.execute(sql):
exists = database.db_session.query(User).filter_by(email=row[1].lower()).first()
if not exists:
newUser = User(None,None)
newUser.id = utilities.guid()
newUser.email = row[1]
newUser.pwdhash = row[2]
newUser.role = row[3]
newUser.state = row[4]
newUser.created = utilities.cDate(row[5])
database.db_session.add(newUser)
database.db_session.commit()
print("created " + newUser.email + " " + newUser.id)
else:
print("skipping existing user " + row[1])
