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