Changeset c1fcb76822fc1aa6b47a9999834cab6c2abeba47

Timestamp:

05/12/08 16:10:25 (5 years ago)

Author:

Denish Patel <denish@omniti.com>

git-committer:

Denish Patel <denish@omniti.com> 1210608625 +0000

git-parent:

[87e2e42dc13b0cfe0cfafcbc70430174c89a04a1]

git-author:

Denish Patel <denish@omniti.com> 1210608625 +0000

Message:

Added metric_name_summary table and updated functions to insert rows to summary table.

Files:

• sql/schema.sql (modified) (6 diffs)

sql/schema.sql

@@ -133 +133 @@
-);
-
+CREATE TABLE stratcon.metric_name_summary (
+  sid integer NOT NULL,
+  name text NOT NULL,
+  type character varying(22),
+  active boolean default 'true',
+  PRIMARY KEY (sid,name)
+);
--- Schema Sequence 
-
@@ -160 +167 @@
- GRANT SELECT,INSERT ON stratcon.map_uuid_to_sid TO stratcon;
- GRANT SELECT,INSERT,UPDATE,DELETE ON stratcon.rollup_runner TO stratcon;
+ GRANT SELECT,INSERT,UPDATE,DELETE ON stratcon.metric_name_summary TO stratcon;
- ALTER TABLE stratcon.seq_sid OWNER TO stratcon;
- 
@@ -242 +250 @@
-DECLARE
-    v_oldvalue TEXT;
+    v_sid integer;
+    v_name text;
-BEGIN
-
@@ -254 +264 @@
-        INSERT INTO stratcon.loading_dock_metric_text_s_change_log (sid,whence,name,value)
-            VALUES (NEW.sid, NEW.whence, NEW.name, NEW.value); 
-
+
+
+
+
+
+
-    END IF;
-
@@ -274 +289 @@
-DECLARE
-v_whence timestamptz;
+v_sid integer;
+v_name text;
-BEGIN
-IF TG_OP = 'INSERT' THEN
@@ -281 +298 @@
-       INSERT INTO  stratcon.log_whence_s VALUES(date_trunc('H',NEW.WHENCE) + (round(extract('minute' from NEW.WHENCE)/5)*5) * '1 minute'::interval,'5 minutes');
-    END IF;
+
+   SELECT sid,name FROM stratcon.metric_name_summary WHERE sid=NEW.sid  and name=NEW.name
+     INTO v_sid,v_name;
+   IF NOT FOUND THEN
+       INSERT INTO  stratcon.metric_name_summary VALUES(NEW.sid,NEW.name,'numeric');
+    END IF;
+
-END IF;
-