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())
