Public.getoutagetimeinwindow (function) - Revision history

Bot at 09:19, 27 August 2011

2011-08-27T09:19:35Z

Bot at 22:38, 24 June 2010

2010-06-24T22:38:53Z

Bot at 07:37, 11 February 2010

2010-02-11T07:37:54Z

Bot at 07:31, 11 February 2010

2010-02-11T07:31:47Z

Bot at 13:52, 7 August 2009

2009-08-07T13:52:44Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getoutagetimeinwindow |- |}

 CREATE OR REPLACE FUNCTION public...

2009-08-07T13:15:59Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | public.getoutagetimeinwindow |- |} <pre> CREATE OR REPLACE FUNCTION public...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''function
| public.getoutagetimeinwindow
|-
|}

<pre>
CREATE OR REPLACE FUNCTION public.getoutagetimeinwindow(integer, character varying, integer, timestamp without time zone, timestamp without time zone)
RETURNS double precision
LANGUAGE plpgsql
AS $function$
DECLARE
nid ALIAS FOR $1;
ipid ALIAS FOR $2;
sid ALIAS FOR $3;
xtime ALIAS FOR $4;
ytime ALIAS FOR $5;
orec RECORD;
lostTime timestamp without time zone;
gainTime timestamp without time zone;
downtime float8;
zero CONSTANT float8 := 0.0;
epochTime CONSTANT timestamp without time zone := to_timestamp('01 Jan 1970 00:00:00', 'DD Mon YYYY HH24:MI:SS');
BEGIN
downtime = zero;
FOR orec IN SELECT ifLostService,ifRegainedService
FROM outages WHERE (nodeID = nid AND ipAddr = ipid AND serviceID = sid AND
((ifRegainedService IS NULL AND ifLostService <= xtime) OR
(ifRegainedService > ytime)))
LOOP
BEGIN
gainTime := epochTime;
lostTime := orec.ifLostService;
IF orec.ifRegainedService IS NOT NULL THEN
gainTime := orec.ifRegainedService;
END IF;
--
-- Find the appropriate records
--
IF xtime > lostTime THEN
--
-- for any outage to be in window of
-- opportunity the lost time must ALWAYS be
-- less that the x time.
--
IF gainTime = epochTime THEN
--
-- if the gain time is epochTime then the outage
-- does not have an uptime.
--
IF ytime > lostTime THEN
downtime := downtime + EXTRACT(EPOCH FROM (xtime - ytime));
ELSE
downtime := downtime + EXTRACT(EPOCH FROM (xtime - lostTime));
END IF;
ELSE
IF xtime > gainTime AND gainTime > ytime THEN
--
-- regain time between x & y
--
IF ytime > lostTime THEN
downtime := downtime + EXTRACT (EPOCH FROM (gainTime - ytime));
ELSE
downtime := downtime + EXTRACT (EPOCH FROM (gainTime - lostTime));
END IF;
ELSE
IF gainTime > xtime THEN
--
-- regain time greater than x, lost less that x
--
IF ytime > lostTime THEN
downtime := downtime + EXTRACT (EPOCH FROM (xtime - ytime));
ELSE
downtime := downtime + EXTRACT (EPOCH FROM (xtime - lostTime));
END IF;
-- end gainTime > xtime
END IF;
-- end xtime > gainTime AND gainTime > ytime
END IF;
-- end gaintime == epochTime
END IF;
-- end xtime > lostTime
END IF;
END;
END LOOP;
RETURN downtime*1000.0;
END;
$function$
</pre>

← Older revision		Revision as of 09:19, 27 August 2011
Line 91:		Line 91:
	$function$		$function$
	</pre>		</pre>
−
−	~~=== References ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Dependency Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referenced Object~~
−
−	~~\|- valign="top"~~
−	~~\| Select~~
−	~~\| Table~~
−	~~\| [[public.outages_(table)\|public.outages]]~~
−
−	\|}
−
−	~~=== Dependencies ===~~
−	~~{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"~~
−	~~\|- style="background:silver"~~
−	~~\| '''Reference Type~~
−	~~\| '''Object Type~~
−	~~\| '''Referencing Object~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getmanagedoutageforintfinwindow_(function)\|public.getmanagedoutageforintfinwindow]]~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getmanagedoutagefornodeinwindow_(function)\|public.getmanagedoutagefornodeinwindow]]~~
−
−	~~\|- valign="top"~~
−	~~\| Execute~~
−	~~\| Function~~
−	~~\| [[public.getpercentavailabilityinwindow_(function)\|public.getpercentavailabilityinwindow]]~~
−
−	\|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Function
 | public.getoutagetimeinwindow
 |}
 === Source ===
@@ Line 101: / Line 99: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 115: / Line 113: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Execute
 | Function
 | [[public.getmanagedoutageforintfinwindow_(function)|public.getmanagedoutageforintfinwindow]]
-|-
+|- valign="top"
 | Execute
 | Function
 | [[public.getmanagedoutagefornodeinwindow_(function)|public.getmanagedoutagefornodeinwindow]]
-|-
+|- valign="top"
 | Execute
 | Function

@@ Line 1: / Line 1: @@
 == wikibot ==
 CREATE OR REPLACE FUNCTION public.getoutagetimeinwindow(integer, character varying, integer, timestamp without time zone, timestamp without time zone)
   RETURNS double precision
@@ Line 81: / Line 92: @@
     END;
 $function$
 |-
 | Select
 | Table
 | [[public.outages_(table)|public.outages]]
 |-
@@ Line 100: / Line 129: @@
 | Function
 | [[public.getpercentavailabilityinwindow_(function)|public.getpercentavailabilityinwindow]]

@@ Line 7: / Line 7: @@
 |-
 |}
 <pre>