def create_testdata():
checkindate1 = CheckInDate()
person1 = Person(first="Cathy",
last="Chen",
birthday=datetime.date(1995,6,20),
phone=phone_format("9178213080"),
checkin=True,
gender=True)
checkindate1.date = datetime.date(2016,1,10)
checkindate1.checkinpeople.append(person1)
checkindate2 = CheckInDate()
person2 = Person(first="Ben",
last="Hsu",
birthday=datetime.date(1994,4,2),
phone=phone_format("3920193029"),
checkin=False,
gender=True)
person3 = Person(first="Emily",
last="Huber",
birthday=datetime.date(1995,1,15),
phone=phone_format("2159283712"),
checkin=False,
gender=False)
checkindate1.checkinpeople.append(person3)
checkindate2.checkinpeople.append(person2)
db.session.add(checkindate1)
db.session.add(person1)
db.session.add(checkindate2)
db.session.add(person2)
db.session.commit()
def create_demo_data():
checkindate1 = CheckInDate()
checkindate2 = CheckInDate()
checkindate3 = CheckInDate()
checkindate4 = CheckInDate()
checkindate5 = CheckInDate()
checkindate6 = CheckInDate()
checkindate7 = CheckInDate()
checkindate1.date = datetime.date(2016,1,19)
checkindate2.date = datetime.date(2016,1,20)
checkindate3.date = datetime.date(2016,1,21)
checkindate4.date = datetime.date(2016,1,22)
checkindate5.date = datetime.date(2016,1,23)
checkindate6.date = datetime.date(2016,1,24)
checkindate7.date = datetime.date(2016,1,25)
firstnames = ["Cathy", "Ben", "Scott", "Brian", "Ryan",
"Grace", "Julia", "Scott", "Alex", "William",
"Dennis", "Jordan", "Mia", "Laura", "Veronica",
"Anosha", "Jonathan", "Yoni", "Arman", "Janice",
"Lee", "Sam", "Aaron", "Juniper", "June"]
lastnames = ["Chen", "Hsu", "Lee", "Lim", "Smith",
"Huang", "Hewitt", "Jordan", "Sands", "Zhang",
"Ho", "Amsterson", "Sonderston", "Heth", "Wharton",
"Minai", "Dubin", "Nachmany", "Boreth", "Chung",
"Anderson", "Smith", "Guo", "Herninger", "Li"]
birthdays = [datetime.date(2010,1,2),
datetime.date(2011,2,21),
datetime.date(1971,2,23),
datetime.date(1975,3,13),
datetime.date(1970,4,4),
datetime.date(1972,2,5),
datetime.date(1973,3,8),
datetime.date(1965,4,11),
datetime.date(1967,8,14),
datetime.date(1963,10,30),
datetime.date(1995,11,2),
datetime.date(1993,12,11),
datetime.date(1982,2,24),
datetime.date(1987,4,29),
datetime.date(1981,2,17),
datetime.date(1949,7,15),
datetime.date(1944,6,11),
datetime.date(1942,1,3),
datetime.date(1964,2,2),
datetime.date(1964,3,7),
datetime.date(1949,7,15),
datetime.date(1944,6,11),
datetime.date(1942,1,3),
datetime.date(1964,2,2),
datetime.date(1964,3,7),
datetime.date(1934,2,4)]
phone = ["9178213080",
"2309493083",
"3203941380",
"3103948582",
"0394837430",
"3023948930",
"9182384829",
"9123837489",
"8213983738",
"8213984728",
"2739387293",
"3489451983",
"5882938433",
"5920394839",
"9182378392",
"1293837483",
"4948485482",
"6945019384",
"0393418238",
"7128497382",
"3824972389",
"3819284847",
"4501908249",
"9128875322",
"1049482325",
"3923419552"]
gender = [True, False, False, False, False,
True, True, False, False, False,
False, True, True, True, True,
True, False, False, False, True,
False, False, False, True, True]
people = []
for i in range(len(firstnames)):
print i
person = Person(first=firstnames[i],
last=lastnames[i],
birthday=birthdays[i],
phone=phone[i],
checkin=False,
gender=gender[i])
people.append(person)
checkindate1.checkinpeople.append(people[0])
checkindate1.checkinpeople.append(people[1])
checkindate2.checkinpeople.append(people[2])
checkindate2.checkinpeople.append(people[3])
checkindate2.checkinpeople.append(people[4])
checkindate2.checkinpeople.append(people[14])
checkindate2.checkinpeople.append(people[5])
checkindate3.checkinpeople.append(people[6])
checkindate3.checkinpeople.append(people[18])
checkindate4.checkinpeople.append(people[7])
checkindate4.checkinpeople.append(people[8])
checkindate4.checkinpeople.append(people[9])
checkindate4.checkinpeople.append(people[10])
checkindate4.checkinpeople.append(people[11])
checkindate4.checkinpeople.append(people[12])
checkindate4.checkinpeople.append(people[13])
checkindate5.checkinpeople.append(people[14])
checkindate5.checkinpeople.append(people[15])
checkindate6.checkinpeople.append(people[16])
checkindate7.checkinpeople.append(people[17])
checkindate7.checkinpeople.append(people[18])
checkindate7.checkinpeople.append(people[19])
checkindate7.checkinpeople.append(people[0])
for person in people:
db.session.add(person)
db.session.add(checkindate1)
db.session.add(checkindate2)
db.session.add(checkindate3)
db.session.add(checkindate4)
db.session.add(checkindate5)
db.session.add(checkindate6)
db.session.add(checkindate7)
db.session.commit()
