Python MySql.query 예제들

예제 #1

def update_test():
    session = MySql().get_session()
    try:
        brands = session.query(Product).whereclause(Product.id == 1)
        for brand in brands:
            print(brand)
    except SQLAlchemyError as error:
        print(error)
    finally:
        session.close()

예제 #2

def read_test():
    session = MySql().get_session()
    try:
        products = session.query(Product).all()
        for product in products:
            print(product)
    except SQLAlchemyError as error:
        print(error)
    finally:
        session.close()

예제 #3

파일: brand_test.py 프로젝트: marcosmarangoni/james_loader

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

예제 #4

파일: brand_test.py 프로젝트: marcosmarangoni/james_loader

def read_test():
    session = MySql().get_session()
    try:
        brands = session.query(Brand).all()
        for brand in brands:
            print(brand)
    except SQLAlchemyError as error:
        print(error)
    finally:
        session.close()

예제 #5

파일: brand_test.py 프로젝트: marcosmarangoni/james_loader

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