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()
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()
