Python wc_Shop Examples

Example #1

File: update_price.py Project: sonikandpikachu/wc_work

def get_or_create_shop(name):
    shop = db.session.query(sql.wc_Shop).filter_by(name=name).first()
    if shop:
        return shop
    else:
        shop = sql.wc_Shop(name=name)
        db.session.add(shop)
        db.session.commit()
        return shop

Example #2

File: db_development.py Project: sonikandpikachu/wc_work

def __insert_shops():
    '''Inserting all shops from workpass'''
    pkl_shops = ptd.shops(workpass, "Устройство.магазины")
    dbshops = [dbs[0] for dbs in db.session.query(sql.wc_Shop.name).all()]
    for s in pkl_shops:
        if not s.decode('utf-8') in dbshops:
            shop = sql.wc_Shop(name=s)
            db.session.add(shop)
    db.session.commit()

Example #3

File: db_development.py Project: sonikandpikachu/wc_heroku

def __insert_shops():
    '''Inserting all shops from workpass'''
    pkl_shops = ptd.shops(workpass, "Устройство.магазины")
    dbshops = [dbs[0] for dbs in db.session.query(sql.wc_Shop.name).all()]
    for s in pkl_shops:
        if not s.decode('utf-8') in dbshops:
            shop = sql.wc_Shop(name=s)
            db.session.add(shop)
    db.session.commit()