def get_persoane_care_se_numesc(): name = input("Introduceti numele persoanei respective: ") mydb = create_connection() my_cursor = mydb.cursor() try: my_cursor.execute("SELECT * FROM people WHERE people_name = %s", name) people_fields_array = my_cursor.fetchall() for people_fields in people_fields_array: person = Person(people_fields[0], people_fields[1], people_fields[2], people_fields[3], people_fields[4], people_fields[5], people_fields[6], people_fields[7], people_fields[8], people_fields[9], people_fields[10]) person.add_vehicles(get_vehicles_with_person_ID(person.peopleID)) person.add_starships(get_starships_with_person_id(person.peopleID)) print(str(person)) except BaseException as ex: mydb.close() my_cursor.close() print(str(ex))
def afisare_dupa_people_gender(gender): mydb = create_connection() my_cursor = mydb.cursor() try: my_cursor.execute("SELECT * FROM people WHERE people_gender = %s", gender) people_fields_array = my_cursor.fetchall() if len(people_fields_array) is 0: raise Exception(' Nu este niciun barbat in baza de date') for people_fields in people_fields_array: person = Person(people_fields[0], people_fields[1], people_fields[2], people_fields[3], people_fields[4], people_fields[5], people_fields[6], people_fields[7], people_fields[8], people_fields[9], people_fields[10]) person.add_vehicles(get_vehicles_with_person_ID(person.peopleID)) person.add_starships(get_starships_with_person_id(person.peopleID)) print(str(person)) except BaseException as ex: mydb.close() my_cursor.close() print(str(ex))
def get_persoane_dupa_anul_nasterii(): an = input("Introduceti anul nasterii: ") mydb = create_connection() my_cursor = mydb.cursor() try: my_cursor.execute("SELECT * FROM people WHERE people_birth_year = %s", an) people_fields_array = my_cursor.fetchall() if len(people_fields_array) is 0: raise Exception(" Nu este nimeni in baza de date cu anul nasterii " + str(an)) for people_fields in people_fields_array: person = Person(people_fields[0], people_fields[1], people_fields[2], people_fields[3], people_fields[4], people_fields[5], people_fields[6], people_fields[7], people_fields[8], people_fields[9], people_fields[10]) person.add_vehicles(get_vehicles_with_person_ID(person.peopleID)) person.add_starships(get_starships_with_person_id(person.peopleID)) print(str(person)) except BaseException as ex: mydb.close() my_cursor.close() print(str(ex))