def populateProject():
conn = sqlite3.connect("mail.db")
cur = conn.cursor()
cur.execute("select * from projects order by projectId")
projects = cur.fetchall()
for project in projects:
try:
user = User.objects.get(name=project[2])
except:
user = User()
user.name = project[2]
user.usn = "T"
user.isTeacher = True
flag = True
while flag:
password = user.password = getPassword()
try:
user.save()
flag = False
except:
flag = True
cur.execute("insert into user (name, password, usn) values (?, ?, ?)", (user.name, password, user.usn))
projectObj = Project()
projectObj.title = project[1]
projectObj.guide = user
projectObj.save()
conn.commit()
