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