def update_test():
session = MySql().get_session()
try:
brand = session.query(Brand).first()
brand.name = 'TestBrandUpdate'
session.commit()
except SQLAlchemyError as error:
print(error)
finally:
session.close()
def create_test():
session = MySql().get_session()
try:
newBrand = Brand(name='TestingOrm', code='123321123')
session.add(newBrand)
session.commit()
except SQLAlchemyError as error:
print(error)
finally:
session.close()
pass
def delete_test():
session = MySql().get_session()
try:
brand = session.query(Brand).first()
session.delete(brand)
session.commit()
except SQLAlchemyError as error:
print(error)
finally:
session.close()
pass