perfsonar development work

Author: roman
Date: 2009-02-04 07:12:55 -0500 (Wed, 04 Feb 2009)
New Revision: 4942

Modified:
   trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql
   trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql
Log:
sql statemets for iperf and ping stuff added


Modified: trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql
===================================================================
--- trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql       2009-02-03 
14:28:50 UTC (rev 4941)
+++ trunk/geant2-java-sql-ma/conf/psql-sqlma-dbremove.sql       2009-02-04 
12:12:55 UTC (rev 4942)
@@ -29,7 +29,11 @@
 
 drop table perfsonar_links;
 
+drop table perfsonar_iperf;
 
+drop table clmp_ping;
+
+
 -- root (postgres) user
 
 \c perfsonar_ma postgres

Modified: trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql
===================================================================
--- trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql        2009-02-03 
14:28:50 UTC (rev 4941)
+++ trunk/geant2-java-sql-ma/conf/psql-sqlma-dbsetup.sql        2009-02-04 
12:12:55 UTC (rev 4942)
@@ -102,7 +102,41 @@
          comments varchar(255)
         );
 
+create table
+    perfsonar_iperf
+        (metadataId varchar(30) not null,
+         value double precision not null,
+         valueUnits varchar(30) null,
+         numBytes integer null,
+         numBytesUnits varchar(15) null,
+         time integer not null,
+         format varchar(30) null,
+         interv varchar(30) null,
+         protocol varchar(10) null,
+         bufferLength integer null,
+         windowSize integer null,
+         windowSizeRequest varchar(30) null,
+         timeDuration varchar(30) null,
+         arguments varchar(50) null,
+         test_session_id varchar(30) null,
+         ts timestamp default now()
+         );
 
+create table
+    clmp_ping
+         (metadataId varchar(255)  not null,
+         seqNum integer null default 0,
+         value double precision not null,
+         valueUnits varchar(4)  null,
+         ttl smallint null default 0,
+         numBytes integer  null default 0,
+         numBytesUnits varchar(10)  null,
+         timeValue integer  not null,
+         timeType varchar(4)  null,
+         ts timestamp default now()
+         );
+
+
 -- insert statements for testing perfsonar_utilization table
 
 insert
@@ -182,7 +216,29 @@
     values ('PSNC-2-DFN-MUE-Link-1002', 'up', '2006-04-06 12:17:33');
 
 
+-- insert statements for testing perfsonar_iperf table
 
+insert
+    into perfsonar_iperf
+    values ('meta1-iperf-test', 93938560, 'bits/sec', 23484640, 'Bytes', 
1197642642, null, null, 'TCP', null, null, null, null, null, null, default);
+
+insert
+    into perfsonar_iperf
+    values ('meta2-iperf-test', 93938560, 'bits/sec', 23484640, 'Bytes', 
1197642662, null, null, 'UDP', null, null, null, null, null, null, default);
+
+
+-- insert statements for testing clmp_ping table
+
+insert
+    into clmp_ping
+    values ('ping-meta1', 1, 5.3, 'ms', 253, 8, 'Bytes', 1233655716, 'unix', 
default);
+
+insert
+    into clmp_ping
+    values ('ping-meta1', 2, 2.5, 'ms', 253, 8, 'Bytes', 1233655718, 'unix', 
default);
+
+
+
 -- trigger
 
 create trigger trigger1