def db_init():
""" Initial config/population of the database tables """
#Using drop_all temporarily to prevent integrity error between
#subsequent runs. If db_init is not called this can be removed.
#this can also be called at the end of this fn
db.drop_all()
db.create_all()
#populate User table
admin1 = User("Archana", bcrypt.generate_password_hash("mypwd"), "admin")
db.session.add(admin1)
db.session.commit()
user1 = User("User1", bcrypt.generate_password_hash("upwd"), "user")
db.session.add(user1)
db.session.commit()
user2 = User("User2", bcrypt.generate_password_hash("u2pwd"), "user")
db.session.add(user2)
db.session.commit()
#populate Quiz table
qz1 = Quiz( "Python Basics ", "Simple ", "Explanation", 1, 2)
qz2 = Quiz( "Python Advanced", "Moderate", "No text ", 1)
db.session.add(qz1)
db.session.add(qz2)
db.session.commit()
#populate Questions table
ques1 = Question("What does 'def foo(): pass do",
"A fn which does nothing",1,1)
ques2 = Question("Is python an OOP l ",
"Yes python is an OOP l",1,1)
db.session.add(ques1)
db.session.add(ques2)
db.session.commit()
#populate Answer choices table
ans1 = Anschoice(1, 1, "a. This function does nothing ", True)
ans2 = Anschoice(1, 1, "b. This function returns a fn pass ", False)
ans3 = Anschoice(1, 1, "c. This function is not yet defined", False)
ans4 = Anschoice(1, 2, "a. Yes Python is object oriented ", True)
ans5 = Anschoice(1, 2, "b. No Python is not object oriented", False)
ans6 = Anschoice(1, 2, "c. Python may not be used as OOP l ", True)
db.session.add(ans1)
db.session.add(ans2)
db.session.add(ans3)
db.session.add(ans4)
db.session.add(ans5)
db.session.add(ans6)
db.session.commit()
return None
def __init__(
self,
username,
password,
email,
first_name,
last_name,
gender,
validation_token,
validation_expiry=date.today(),
suspended=False,
verified=False,
profile_public=True,
):
self.username = username
self._password = bcrypt.generate_password_hash(password)
self.email = email
self.full_name = first_name + " " + last_name
self.first_name = first_name
self.last_name = last_name
self.gender = gender
self.validation_token = validation_token
self.suspended = suspended
self.verified = verified
self.created_on = datetime.now()
self.profile_public = profile_public
def create_user(self):
new_user = User(
name='dnar',
email='*****@*****.**',
password=bcrypt.generate_password_hash('1234')
)
db.session.add(new_user)
db.session.commit()
def create_admin_user(self):
new_user = User(
name='administrator',
email='*****@*****.**',
password=bcrypt.generate_password_hash('administrator'),
role='admin'
)
db.session.add(new_user)
db.session.commit()
def password(self, pw):
self._password = bcrypt.generate_password_hash(pw)
def populate_db():
""" Initial config/population of the database tables """
user1 = models.User("user123", bcrypt.generate_password_hash("user123"), \
"*****@*****.**", "9194138865")
models.db.session.add(user1)
models.db.session.commit()
user2 = models.User("user2", bcrypt.generate_password_hash("user456"), \
"*****@*****.**", "4342984299")
models.db.session.add(user2)
models.db.session.commit()
event1 = models.Event("Founder's pitch", models.datetime.now(), \
"I am very afraid that I will not do a good job. I am very nervous. I think people will not like me at all. I can never do this. I will never learn how to speak in public. I think it will not go well at all.", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event1)
event2 = models.Event("Public speaking", models.datetime(2015, 11, 15, 5, 8, 51, 173120), \
"I am feeling very afraid of being judged by so many people. I think the event will become a complete failure because of me.", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event2)
event3 = models.Event("Toastmasters speech", models.datetime(2015, 11, 23, 5, 8, 51, 173120), \
"I am very sure that I might go blank or forget some of the lines from my speech. I am also feeling very shy. I wish it were not a formal setting. I should never try this again.", "Blank",\
7, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event3)
event4 = models.Event("Sky diving", models.datetime.now(), \
"Afraid of not falling properly and hurting myself ", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event4)
event5 = models.Event("Speech2", models.datetime.now(), \
"May not be able to do a good job", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event5)
event6 = models.Event("Public speaking2", models.datetime.now(), \
"Feeling afraid of being judged", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event6)
event7 = models.Event("Toastmasters speech2", models.datetime.now(), \
"I might go blank or forget lines from my speech", "Blank",\
7, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event7)
event8 = models.Event("Sky diving2", models.datetime.now(), \
"Afraid of not falling properly and hurting myself ", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event8)
event9 = models.Event("Speech3", models.datetime.now(), \
"May not be able to do a good job", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event9)
event10 = models.Event("Public speaking3", models.datetime.now(), \
"Feeling afraid of being judged", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event10)
event11 = models.Event("Toastmasters speech3", models.datetime.now(), \
"I might go blank or forget lines from my speech", "Blank",\
7, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event11)
event12 = models.Event("Sky diving3", models.datetime.now(), \
"Afraid of not falling properly and hurting myself ", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event12)
event13 = models.Event("Toastmasters speech4", models.datetime.now(), \
"I might go blank or forget lines from my speech", "Blank",\
7, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event13)
event14 = models.Event("Sky diving4", models.datetime.now(), \
"Afraid of not falling properly and hurting myself ", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event14)
event15 = models.Event("Speech4", models.datetime.now(), \
"May not be able to do a good job", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event15)
event16 = models.Event("Public speaking4", models.datetime.now(), \
"Feeling afraid of being judged", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event16)
event17 = models.Event("Toastmasters speech5", models.datetime.now(), \
"I might go blank or forget lines from my speech", "Blank",\
7, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event17)
event18 = models.Event("Sky diving5", models.datetime.now(), \
"Afraid of not falling properly and hurting myself ", "Blank",\
8, 0, FEARAPP_STATUS_CREATED, 0, user1.userid)
models.db.session.add(event18)
models.db.session.commit()
models.Event.query.filter_by(eventid=event1.eventid).update(dict
(posteventtxt="I was only nervous in the first 2-3 minutes of the speech. After that it all went really well.In fact people complemented me on my presentation skills. I now think I can do this.",postfearfactor=5,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event2.eventid).update(dict
(posteventtxt="It is surprising how I did not do so badly. I will be honest, my heart was pounding until the first couple mins. But after that all went great.",postfearfactor=4,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event3.eventid).update(dict
(posteventtxt="Well, I would say that I was nervous but not as bad as I thought. In fact people's reviews actually help me understand that I am actually very good.",postfearfactor=3,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event4.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=2,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event5.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=7,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event6.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=8,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event7.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=5,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event8.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=4,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event9.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=3,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event10.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=6,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event11.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=7,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event12.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=5,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event13.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=5,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event14.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=4,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event15.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=3,status=FEARAPP_STATUS_UPDATED))
models.Event.query.filter_by(eventid=event16.eventid).update(dict
(posteventtxt="Not so much any more",postfearfactor=6,status=FEARAPP_STATUS_UPDATED))
#Arch: deliberately leaving two events unupdated (the last two)
models.db.session.commit()
return None
def create_user(self, name, email, password):
new_user = User(name=name, email=email, password=bcrypt.generate_password_hash(password))
db.session.add(new_user)
db.session.commit()
