summaryrefslogtreecommitdiff
path: root/dbSetup/dbtestdata.sql
diff options
context:
space:
mode:
authorDaniel Langesten <daniel.langest@gmail.com>2015-03-17 12:01:38 +0100
committerDaniel Langesten <daniel.langest@gmail.com>2015-03-17 12:01:38 +0100
commit38eb46bad4062e04f1db1b93bf5d0d1a935c4d96 (patch)
treea9c64eae94da4f54478c6cd6f00e31b9df38bc19 /dbSetup/dbtestdata.sql
parent22ee0829d5ce9508d74d20abae3e06583e3d1820 (diff)
merged db setups into one file
Diffstat (limited to 'dbSetup/dbtestdata.sql')
-rw-r--r--dbSetup/dbtestdata.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/dbSetup/dbtestdata.sql b/dbSetup/dbtestdata.sql
new file mode 100644
index 0000000..7f877f1
--- /dev/null
+++ b/dbSetup/dbtestdata.sql
@@ -0,0 +1,11 @@
+-- New data that should not be processed in case there is more that should be aggregated together with it.
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("123.123.123.123", "12.12.12.12", NOW(), 80, 255);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("123.123.123.123", "12.12.12.12", NOW(), 80, 255);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("45.45.45.45", "12.12.12.12", NOW(), 80, 255);
+
+-- Old data that should be processed
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("63.63.63.63", "73.73.73.73", '2008-12-01 12:00:00', 80, 200);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("63.63.63.63", "73.73.73.73", '2008-12-01 12:00:00', 80, 200);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("8.8.8.8", "11.73.73.73", '2008-12-01 12:00:00', 80, 200);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("63.63.63.63", "73.73.73.73", '2008-12-01 12:00:00', 80, 200);
+INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("100.63.63.63", "8.8.8.8", '2008-12-01 12:00:00', 80, 200);