""" CREATE TABLE Attack( attacker_id NUMBER NOT NULL, defender_id NUMBER NOT NULL, time timestamp(0) NOT NULL, location VARCHAR2(30), victor_id NUMBER NOT NULL, ); """ import random as r import data as d for i in d.Players: for j in range(r.randint(8,15)): other = d.get_other_player(i) print """INSERT INTO ATTACK VALUES({0}, {1},\n\tTO_TIMESTAMP({2},\'YYYY-MM-DD HH24:MI:SS\'),\n\t{3}, {4});""".format(i, other, d.make_date(), d.get_anyloc_id(), r.choice([i, other]))
p_id NUMBER NOT NULL, s_id NUMBER NOT NULL, m_id NUMBER NOT NULL, order_time timestamp(0) NOT NULL, quantity NUMBER NOT NULL, ); """ import random as r import data as d def get_q(): return r.randint(1,100) for i in d.Players: for j in range(r.randint(15,30)): print """INSERT INTO SUPPLYDROP VALUES({0}, {1}, {2},\n\tTO_TIMESTAMP({3},\'YYYY-MM-DD HH24:MI:SS\'), {4});""".format(i, d.get_sid(), d.get_mid(), d.make_date(), get_q())