Example #1
0
def audit_shop_pass(shop_id):
    conn = src.pydev.mysql.connection()
    cursor = conn.cursor()
    # set fd_t_shopaccount
    sql = 'update fd_t_shopaccount set service_deadline = %s, service_status = %s where shop_id = %s'
    params = [datetime.datetime.now() + datetime.timedelta(days=365), src.define.SERVICE_STATUS.NORMAL, shop_id]
    row_count = cursor.execute(sql, params)

    # set fd_t_fansmessage
    sql2 = 'update fd_t_fansmessageconfig set ' \
           'current_p2p_count = %s, p2p_remain_count = %s, next_p2p_count = %s, ' \
           'current_mass_count = %s, mass_remain_count = %s, next_mass_count = %s where shop_id = %s'
    params2 = [conf.get('fansmessageconfig', 'current_p2p_count'),
               conf.get('fansmessageconfig', 'p2p_remain_count'),
               conf.get('fansmessageconfig', 'next_p2p_count'),
               conf.get('fansmessageconfig', 'current_mass_count'),
               conf.get('fansmessageconfig', 'mass_remain_count'),
               conf.get('fansmessageconfig', 'next_mass_count'),
               shop_id
               ]
    row_count2 = cursor.execute(sql2, params2)
    logger.info('audit shop: shop_id: %s, fd_t_shopaccount row count:%s, fd_t_fansmessageconfig row count:%s' % (
        shop_id, row_count, row_count2))
    cursor.close()
    conn.commit()
    conn.close()
    return row_count, row_count2
Example #2
0
def audit_shop_not_pass(shop_id):
    conn = src.pydev.mysql.connection()
    cursor = conn.cursor()
    # set fd_t_shopaccount
    sql = 'update fd_t_shopaccount set service_status = %s where shop_id = %s'
    params = [src.define.SERVICE_STATUS.AUDIT_NOT_PASS, shop_id]
    row_count = cursor.execute(sql, params)
    logger.info('audit shop not pass: shop_id: %s, fd_t_shopaccount row count:%s' % (shop_id, row_count, ))
    cursor.close()
    conn.commit()
    conn.close()
    return True