本文整理汇总了Python中db.Database.get_pol_beers方法的典型用法代码示例。如果您正苦于以下问题：Python Database.get_pol_beers方法的具体用法？Python Database.get_pol_beers怎么用？Python Database.get_pol_beers使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类db.Database的用法示例。
在下文中一共展示了Database.get_pol_beers方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: update_pol_stock
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import get_pol_beers [as 别名]
def update_pol_stock(conn_str=None):
db = Database(conn_str)
beers = db.get_pol_beers()
shops = [pol['id'] for pol in db.get_pol_shops()]
stock_by_pol = []
for beer in beers:
stocks = check_beer(beer['id'])
for stock in stocks:
num = stock['stock']
updated = stock['updated']
stock_by_pol.append({
'shop_id': stock['pol_id'],
'pol_beer_id': beer['id'],
'stock': num,
'updated': updated
})
shops_with_beer = [int(stock['pol_id']) for stock in stocks]
for pol_id in shops:
if pol_id not in shops_with_beer:
stock_by_pol.append({
'shop_id': pol_id,
'pol_beer_id': beer['id'],
'stock': 0,
'updated': datetime.now()
})
save_stock(stock_by_pol, db)
db.add_log('pol_stock')示例2: update_pol_stock
# 需要导入模块: from db import Database [as 别名]
# 或者: from db.Database import get_pol_beers [as 别名]
def update_pol_stock(conn_str=None):
db = Database(conn_str)
beer_ids = [beer['id'] for beer in db.get_pol_beers()]
shops = [pol['id'] for pol in db.get_pol_shops()]
for shop_id in shops:
stock_for_pol = get_pol_stock_for_pol(shop_id)
stock_by_pol = []
for stock in stock_for_pol:
beer_id = stock['product_id']
if beer_id in beer_ids:
stock_by_pol.append({
'shop_id': shop_id,
'pol_beer_id': beer_id,
'stock': stock['stock'],
'updated': stock['updated']
})
save_stock(stock_by_pol, db)
db.add_log('pol_stock')