def filter_age_pet(cls):
age = int(input("Ingrese la edad de las mascotas: "))#3
pets = session.query(Pets).filter(Pets.age>=age).first()
for pet in pets:
print(pet)
def filter_first_name_pet(cls):
name = input("Ingrese el nombre de la mascota: ")
pets = session.query(Pets).filter(Pets.name==name).first()
print(pets)
def update_pet(cls, id_pet):
pet = session.query(Pets).get(id_pet)
pet.name = input("Ingrese el nombre de la mascota: ")
pet.age = int(input("Ingrese la edad de la mascota: "))
session.commit()
print("Mascota Actualizada")
def delete_pet(cls, id_pet):
pet = session.query(Pets).get(id_pet)
print(pet)
session.delete(pet)
session.commit()
print("Mascota eliminada")
def show_pet(cls, id_pet):
pet = session.query(Pets).get(id_pet)
print(pet)
def show_all_pets(cls):
pets = session.query(Pets).all()
print("-------Mascotas Registradas---------")
for pet in pets:
print(pet)
print("-------------------------")