def get_product_name(p_no):
session = Session()
name = session.scalar('select name from wx_product where p_no=:p_no',
{'p_no': p_no})
return name
def get_product_qty(p_no):
session = Session()
qty = session.scalar(
'select qty from wx_product where p_no=:p_no limit 1',
{'p_no': p_no})
return qty
def is_active(p_no):
session = Session()
status = session.scalar(
'select status from wx_product where deleted=0 and p_no=:p_no limit 1',
{'p_no': p_no})
if operator.eq(status, P.ProductStatusActive):
return True
else:
return False
def is_first_exchange_day(p_no):
session = Session()
num = session.scalar(
'select count(*) from wx_product_history where deleted=0 and p_no=:p_no',
{'p_no': p_no})
if operator.le(num, 1):
return True
return False