def sale_order_update_entry_date(conn, year=2013, month=1): def gen(): for order in db2.query(conn, 'select sales_order_key as id from test_sales_orders'): yield (date.rand_date(year=year, month=month), order['ID']) db2.execute(conn, ''' update test_sales_orders set entry_date = ? where sales_order_key = ? ''', gen())
def delivery_order_update_carrier(conn): carriers = [2,3,4,5] def gen(): for order in db2.query(conn, 'select delivery_order_key as id from test_delivery_orders'): yield (random.choice(carriers), order['ID']) db2.execute(conn, ''' update test_delivery_orders set carrier_key = ? where delivery_order_key = ? ''', gen())