coupon_boilerplate.py

        old_code = db.execute(
            '''SELECT coupon_code, coupon_offer
               FROM surveys
               WHERE survey_id = %s''', survey_id).first()
        if old_code:
            logging.info("Returning old coupon_code %s for survey_id %d and panelist_id %d",
                    old_code, survey_id, panelist_id)
            return dict(coupon_code=old_code['coupon_code'],
                        coupon_offer=old_code['coupon_offer'],
                        )