Changes between Version 13 and Version 14 of notasVarias

Timestamp:

Sep 16, 2015, 2:44:43 PM (9 years ago)

Author:

aaraujo

Comment:

Agregada sección con información de estadísticas de uso del servicio

notasVarias

@@ -115 +115 @@
 
 
-
-
-
-
-
-
-
+== Estadísticas de uso del servicio ==
+
+Para mantener un registro básico de las estadísticas de uso del servicio Murachi se utiliza una base de datos Postgresql.
+
+En el servidor donde se ejecuta el servicio se debe crear una base de datos de Postgresql con el siguiente nombre {{{databasemurachi}}}. 
+
+La estructura de la base de datos es la siguiente:
+
+{{{
+--
+-- PostgreSQL database dump
+--
+
+-- Dumped from database version 9.1.18
+-- Dumped by pg_dump version 9.1.18
+-- Started on 2015-09-16 14:47:26 VET
+
+SET statement_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+--
+-- TOC entry 167 (class 3079 OID 11645)
+-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
+--
+
+CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
+
+
+--
+-- TOC entry 1886 (class 0 OID 0)
+-- Dependencies: 167
+-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
+--
+
+COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
+
+
+SET search_path = public, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- TOC entry 162 (class 1259 OID 16920)
+-- Dependencies: 5
+-- Name: signatures; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+CREATE TABLE signatures (
+    signature_id integer NOT NULL,
+    type character(4) NOT NULL
+);
+
+
+ALTER TABLE public.signatures OWNER TO aaraujo;
+
+--
+-- TOC entry 166 (class 1259 OID 16936)
+-- Dependencies: 5
+-- Name: signatures_error; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+CREATE TABLE signatures_error (
+    signature_error_id integer NOT NULL
+);
+
+
+ALTER TABLE public.signatures_error OWNER TO aaraujo;
+
+--
+-- TOC entry 165 (class 1259 OID 16934)
+-- Dependencies: 166 5
+-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
+--
+
+CREATE SEQUENCE signatures_error_signature_error_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.signatures_error_signature_error_id_seq OWNER TO aaraujo;
+
+--
+-- TOC entry 1887 (class 0 OID 0)
+-- Dependencies: 165
+-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
+--
+
+ALTER SEQUENCE signatures_error_signature_error_id_seq OWNED BY signatures_error.signature_error_id;
+
+
+--
+-- TOC entry 161 (class 1259 OID 16918)
+-- Dependencies: 5 162
+-- Name: signatures_signature_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
+--
+
+CREATE SEQUENCE signatures_signature_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.signatures_signature_id_seq OWNER TO aaraujo;
+
+--
+-- TOC entry 1888 (class 0 OID 0)
+-- Dependencies: 161
+-- Name: signatures_signature_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
+--
+
+ALTER SEQUENCE signatures_signature_id_seq OWNED BY signatures.signature_id;
+
+
+--
+-- TOC entry 164 (class 1259 OID 16928)
+-- Dependencies: 5
+-- Name: verifications; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+CREATE TABLE verifications (
+    verification_id integer NOT NULL
+);
+
+
+ALTER TABLE public.verifications OWNER TO aaraujo;
+
+--
+-- TOC entry 163 (class 1259 OID 16926)
+-- Dependencies: 164 5
+-- Name: verifications_verification_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
+--
+
+CREATE SEQUENCE verifications_verification_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+ALTER TABLE public.verifications_verification_id_seq OWNER TO aaraujo;
+
+--
+-- TOC entry 1889 (class 0 OID 0)
+-- Dependencies: 163
+-- Name: verifications_verification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
+--
+
+ALTER SEQUENCE verifications_verification_id_seq OWNED BY verifications.verification_id;
+
+
+--
+-- TOC entry 1763 (class 2604 OID 16923)
+-- Dependencies: 162 161 162
+-- Name: signature_id; Type: DEFAULT; Schema: public; Owner: aaraujo
+--
+
+ALTER TABLE ONLY signatures ALTER COLUMN signature_id SET DEFAULT nextval('signatures_signature_id_seq'::regclass);
+
+
+--
+-- TOC entry 1765 (class 2604 OID 16939)
+-- Dependencies: 165 166 166
+-- Name: signature_error_id; Type: DEFAULT; Schema: public; Owner: aaraujo
+--
+
+ALTER TABLE ONLY signatures_error ALTER COLUMN signature_error_id SET DEFAULT nextval('signatures_error_signature_error_id_seq'::regclass);
+
+
+--
+-- TOC entry 1764 (class 2604 OID 16931)
+-- Dependencies: 164 163 164
+-- Name: verification_id; Type: DEFAULT; Schema: public; Owner: aaraujo
+--
+
+ALTER TABLE ONLY verifications ALTER COLUMN verification_id SET DEFAULT nextval('verifications_verification_id_seq'::regclass);
+
+
+--
+-- TOC entry 1874 (class 0 OID 16920)
+-- Dependencies: 162 1879
+-- Data for Name: signatures; Type: TABLE DATA; Schema: public; Owner: aaraujo
+--
+
+COPY signatures (signature_id, type) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1878 (class 0 OID 16936)
+-- Dependencies: 166 1879
+-- Data for Name: signatures_error; Type: TABLE DATA; Schema: public; Owner: aaraujo
+--
+
+COPY signatures_error (signature_error_id) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1890 (class 0 OID 0)
+-- Dependencies: 165
+-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
+--
+
+SELECT pg_catalog.setval('signatures_error_signature_error_id_seq', 1, false);
+
+
+--
+-- TOC entry 1891 (class 0 OID 0)
+-- Dependencies: 161
+-- Name: signatures_signature_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
+--
+
+SELECT pg_catalog.setval('signatures_signature_id_seq', 3, true);
+
+
+--
+-- TOC entry 1876 (class 0 OID 16928)
+-- Dependencies: 164 1879
+-- Data for Name: verifications; Type: TABLE DATA; Schema: public; Owner: aaraujo
+--
+
+COPY verifications (verification_id) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1892 (class 0 OID 0)
+-- Dependencies: 163
+-- Name: verifications_verification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
+--
+
+SELECT pg_catalog.setval('verifications_verification_id_seq', 1, false);
+
+
+--
+-- TOC entry 1771 (class 2606 OID 16941)
+-- Dependencies: 166 166 1880
+-- Name: signatures_error_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+ALTER TABLE ONLY signatures_error
+    ADD CONSTRAINT signatures_error_pkey PRIMARY KEY (signature_error_id);
+
+
+--
+-- TOC entry 1767 (class 2606 OID 16925)
+-- Dependencies: 162 162 1880
+-- Name: signatures_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+ALTER TABLE ONLY signatures
+    ADD CONSTRAINT signatures_pkey PRIMARY KEY (signature_id);
+
+
+--
+-- TOC entry 1769 (class 2606 OID 16933)
+-- Dependencies: 164 164 1880
+-- Name: verifications_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
+--
+
+ALTER TABLE ONLY verifications
+    ADD CONSTRAINT verifications_pkey PRIMARY KEY (verification_id);
+
+
+--
+-- TOC entry 1885 (class 0 OID 0)
+-- Dependencies: 5
+-- Name: public; Type: ACL; Schema: -; Owner: postgres
+--
+
+REVOKE ALL ON SCHEMA public FROM PUBLIC;
+REVOKE ALL ON SCHEMA public FROM postgres;
+GRANT ALL ON SCHEMA public TO postgres;
+GRANT ALL ON SCHEMA public TO PUBLIC;
+
+
+-- Completed on 2015-09-16 14:47:26 VET
+
+--
+-- PostgreSQL database dump complete
+--
+
+}}}
+
+En el servidor se debe cargar el script sql anterior en la base de datos creada previamente.
+
+Para obtener un JSON con las estadísticas básicas del servicio se utiliza el siguiente recurso: {{{https://murachi.cenditel.gob.ve/Murachi/0.1/archivos/estadisticas}}}. Por ejemplo:
+
+{{{
+{"numeroDeFimasIncompletas":"0","numeroDeVerificaciones":"0","numeroDeFirmasEjecutadas":"3"}
+}}}
+
+
+
+
+
+
+
+
+
+