Navigation

Changeset 32ddc52a40c4d76a2cfc234cae27df4212c7c745 for sql

Timestamp:

10/21/09 15:50:40 (7 years ago)

Author:

Robert Treat <robert@omniti.com>

git-committer:

Robert Treat <robert@omniti.com> 1256140240 +0000

git-parent:

[e7461293e27d140464ef3333137cbe5621df7fc3]

git-author:

Robert Treat <robert@omniti.com> 1256140240 +0000

Message:

is it as easy as using the right table names?

Files:

re746129	r32ddc52
51	51	IF v_min_whence <= v_max_rollup_5 THEN
52	52	-- do we still need this? i think "we" dont, but maybe some people do?
53		DELETE FROM ~~rollup_matrix_numeric_5m~~
	53	DELETE FROM metric_numeric_rollup_5m
54	54	WHERE rollup_time = v_min_whence;
55	55	END IF;
…	…
59	59	v_offset := ( 12*(extract('hour' from v_min_whence))+floor(extract('minute' from v_min_whence)/5) );
60	60
61		SELECT * FROM ~~rollup_matrix_numeric~~_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec;
	61	SELECT * FROM metric_numeric_rollup_5m WHERE rollup_time = v_info.rollup_time AND sid=v_info.sid AND name=v_info.name INTO v_rec;
62	62	IF NOT FOUND THEN
63		SELECT * FROM ~~init_rollup_matrix_numeric~~_5m() INTO v_rec;
	63	SELECT * FROM stratcon.init_metric_numeric_rollup_5m() INTO v_rec;
64	64	v_init := true;
65	65	END IF;
…	…
73	73
74	74	IF v_init THEN
75		INSERT INTO ~~rollup_matrix_numeric~~_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev)
	75	INSERT INTO metric_numeric_rollup_5m (sid,name,rollup_time,count_rows,avg_value,counter_dev)
76	76	VALUES (v_rec.sid,v_rec.name,v_rec.rollup_time,v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev);
77	77	ELSE
78		UPDATE ~~rollup_matrix_numeric~~_5m SET (count_rows,avg_value,counter_dev)
	78	UPDATE metric_numeric_rollup_5m SET (count_rows,avg_value,counter_dev)
79	79	= (v_rec.count_rows,v_rec.avg_value,v_rec.counter_dev)
80	80	WHERE rollup_time = v_info.rollup_time AND sid = v_info.sid AND name = v_info.name;