2 -- Populate P2P database with test data.
5 -- insert swarms in `swarms` table
7 INSERT INTO swarms(torrent_filename, data_size)
8 VALUES('DarkKnight.torrent', '123000');
9 INSERT INTO swarms(torrent_filename, data_size)
10 VALUES('Fedora.torrent', '1024');
12 -- insert sessions in `client_sessions` table
14 INSERT INTO client_sessions(swarm_id, btclient_id, system_os,
15 system_os_version, system_ram, system_cpu, public_ip, public_port,
16 ds_limit, us_limit, start_time)
17 VALUES ('1', '2', 'Linux', '2.6.26', '512', '1500', '141.85.224.205',
18 '50500', '512', '64', julianday('2010-10-09 12:43:21'));
19 INSERT INTO client_sessions(swarm_id, btclient_id, system_os,
20 system_os_version, system_ram, system_cpu, public_ip, public_port,
21 ds_limit, us_limit, start_time)
22 VALUES('2', '4', 'Linux', '2.6.26', '512', '1500', '141.85.224.209',
23 '40400', '512', '64', julianday('2010-10-09 12:29:41'));
25 -- insert messages in `status_messages` table
27 INSERT INTO status_messages(client_session_id, timestamp, num_peers,
28 num_dht_peers, download_speed, upload_speed,
29 download_size, upload_size)
30 VALUES('1', julianday('2010-09-23 09:32:43'), '222', '0', '213',
32 INSERT INTO status_messages(client_session_id, timestamp, num_peers,
33 num_dht_peers, download_speed, upload_speed,
34 download_size, upload_size)
35 VALUES('2', julianday('2010-09-23 09:32:44'), '222', '0', '213',
38 -- insert messages in `peer_status_messages` table
40 INSERT INTO peer_status_messages(client_session_id, timestamp, peer_ip,
41 peer_port, download_speed, upload_speed)
42 VALUES('1', julianday('2010-09-23 09:30:00'), '141.85.37.24',
44 INSERT INTO peer_status_messages(client_session_id, timestamp, peer_ip,
45 peer_port, download_speed, upload_speed)
46 VALUES('2', julianday('2010-09-23 09:30:05'), '141.85.37.29',
49 -- insert messages in `verbose_messages` table
51 INSERT INTO verbose_messages(client_session_id, timestamp,
52 transfer_direction_id, peer_ip, peer_port, message_type_id)
53 VALUES('1', julianday('2010-09-23 09:32:45'), '1', '127.0.0.1',
55 INSERT INTO verbose_messages(client_session_id, timestamp,
56 transfer_direction_id, peer_ip, peer_port, message_type_id)
57 VALUES('2', julianday('2010-09-23 09:32:46'), '2', '127.0.0.1',