Python Person.insert Examples

Example #1

	def submit_all():
		result = askquestion(title="Confirmation", message= "Do you want to process?")

		if result == "yes":
			person = Person()
			person.lname = input_lastname.get(1.0, "end-1c")
			person.fname = input_firstname.get(1.0, "end-1c")
			person.birthday = datetime.date(birthYear.get(), months.index(birthMonth.get()) + 1, birthDay.get())
			person.nationality = selected_nationality.get()
			person.gender = selected_gender.get()
			person.streetNumber = str(input_houseNo.get(1.0, "end-1c")) + str(input_houseNo2.get(1.0, "end-1c"))
			person.streetname = input_street.get(1.0, "end-1c")
			person.city = input_city.get(1.0, "end-1c")
			person.postalCode = str(input_postal.get(1.0, "end-1c")) + str(input_postal2.get(1.0, "end-1c"))
			person.phone = input_phoneNumber.get(1.0, "end-1c")
			person.email = input_email.get(1.0, "end-1c")
			person.insert()

			student = Student()
			student.personID = person.personID
			student.studentID = int(input_studentID.get(1.0, "end-1c"))
			student.startYear = datetime.date(startYear.get(), 1, 1)
			student.enrolled = selected_study.get()
			counseler_index = counsellornames.index(selected_counsellor.get())
			student.studyCouncelor = counsellors[counseler_index].teacherID
			student.insert()

			person.userName = (person.lname + str(student.studentID))
			person.userPass = "******"
			person.update()
		
			ui.AdminWindowStudents.admin_window_students(window, return_function) #avoid circular import

Example #2

File: AdminWindowTeacherCreateNew.py Project: Pawopiiieee/Project-Database-DBMSII

	def submit_all():
		result = askquestion(title="Confirmation", message= "Do you want to process?")
		if result == "yes":
			person = Person()
			person.lname = input_lastname.get(1.0, "end-1c")
			person.fname = input_firstname.get(1.0, "end-1c")
			person.birthday = datetime.date(birthYear.get(), months.index(birthMonth.get()) + 1, birthDay.get())
			person.nationality = selected_nationality.get()
			person.gender = selected_gender.get()
			person.streetNumber = str(input_houseNo.get(1.0, "end-1c")) + str(input_houseNo2.get(1.0, "end-1c"))
			person.streetname = input_street.get(1.0, "end-1c")
			person.city = input_city.get(1.0, "end-1c")
			person.postalCode = str(input_postal.get(1.0, "end-1c")) + str(input_postal2.get(1.0, "end-1c"))
			person.phone = input_phoneNumber.get(1.0, "end-1c")
			person.email = input_email.get(1.0, "end-1c")
			person.insert()

			teacher = Teacher()
			teacher.personID = person.personID
			teacher.salary = input_salary.get(1.0, "end-1c")

			person.userName = (person.lname + str(teacher.teacherID))
			person.userPass = "******"
			person.update()

			get_counsellor = selected_counsellor.get()
			if (get_counsellor == "Yes"):
				teacher.studycouncelor = 'Y'
			else:
				teacher.studycouncelor = 'N'

			teacher.insert()

			ui.AdminWindowTeachers.admin_window_teachers(window, return_function) #avoid circular import

Example #3

File: random_student_data.py Project: Pawopiiieee/Project-Database-DBMSII

def generatePerson():
    person = Person()
    person.gender = random.choice(['M', 'F', 'O'])
    if (person.gender == 'F'):
        person.fname = random.choice(female_name)
    else:
        person.fname = random.choice(male_name)
    person.lname = random.choice(last_name)
    domain = ["gmail.com", "hotmail.com", "yahoo.com"]
    person.email = person.lname + "_" + person.fname + "@" + random.choice(
        domain)
    person.phone = "0" + str(random.randint(600000000, 699999999))
    person.birthday = getRandomDate(1980, 2004)
    person.nationality = random.choice(nationality)
    alphabets = [
        "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n",
        "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z"
    ]
    person.streetname = ''.join(random.choice(alphabets) for _ in range(6))
    person.streetNumber = random.randint(1, 99)
    person.city = random.choice(city_name)
    person.postalCode = str(random.randint(1111, 9999)) + str(''.join(
        random.choice(alphabets) for _ in range(2))).upper()
    person.insert()
    return person