def populateUser():
conn = sqlite3.connect("mail.db")
cur = conn.cursor()
cur.execute("select rowid, name, usn, email, project from user")
students = cur.fetchall()[3:] # empty fields
for student in students:
user = User()
user.name = student[1]
user.usn = student[2]
user.email = student[3]
user.project_id = student[4]
flag = True
while flag:
password = user.password = getPassword()
try:
user.save()
flag = False
except:
flag = True
cur.execute("update user set password = ? where rowid = ?", (password, student[0])) # for the mail
conn.commit()
