[Devel] [GIT] OpenBioMaps GIT repository, branch devel_2.0 updated: new pds function introduced:

[banm at vocs.unideb.hu]

    The project "OpenBioMaps GIT repository":

    The branch, devel_2.0 has been updated
       via  a8a2a59141efe20fa1fe1e604e1ebd0a1440c002 (commit)
       via  f19796c0217748cc4a783e700a7a4384e2a54b4b (commit)
       via  70d2581e236e7bbf80a694a18846c84de52cb409 (commit)
      from  9609d28b5da0ff453d502c99f4bd0ec05efb6ef7 (commit)


- Log -----------------------------------------------------------------
commit a8a2a59141efe20fa1fe1e604e1ebd0a1440c002
Author: Bán Miklós <banm at vocs.unideb.hu>
Date:   Sun Apr 30 23:51:44 2017 +0200

new pds function introduced:
get_report
Using this function users can perform custom stored SQL queries to get
data as JSON or XML.
This function is integrated in the PDS and available using r-api.
e.g. OBM_get('get_report','last')
Where the "last" is a custom label of a custom function.
This function is defined in the biomaps/custom_reports table.
This is a new table. The next gekko update will contains the following
SQL code to create it:

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: custom_reports; Type: TABLE; Schema: public; Owner: gisadmin; Tablespace:
--

CREATE TABLE custom_reports (
id integer NOT NULL,
command text NOT NULL,
user_id integer NOT NULL,
key character varying(32)
);

ALTER TABLE custom_reports OWNER TO gisadmin;

--
-- Name: custom_reports_id_seq; Type: SEQUENCE; Schema: public; Owner: gisadmin
--

CREATE SEQUENCE custom_reports_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

ALTER TABLE custom_reports_id_seq OWNER TO gisadmin;

--
-- Name: custom_reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gisadmin
--

ALTER SEQUENCE custom_reports_id_seq OWNED BY custom_reports.id;

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: gisadmin
--

ALTER TABLE ONLY custom_reports ALTER COLUMN id SET DEFAULT nextval('custom_reports_id_seq'::regclass);

--
-- Name: custom_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: gisadmin; Tablespace:
--

ALTER TABLE ONLY custom_reports ADD CONSTRAINT custom_reports_pkey PRIMARY KEY (id);

--
-- Name: user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gisadmin
--

ALTER TABLE ONLY custom_reports
ADD CONSTRAINT user_id_fkey
FOREIGN KEY (user_id)
REFERENCES users(id) ON
UPDATE CASCADE ON DELETE
CASCADE;

--
-- PostgreSQL database dump complete
--

commit f19796c0217748cc4a783e700a7a4384e2a54b4b
Author: Bán Miklós <banm at vocs.unideb.hu>
Date:   Sun Apr 30 19:54:50 2017 +0200

bug fixes

commit 70d2581e236e7bbf80a694a18846c84de52cb409
Author: Bán Miklós <banm at vocs.unideb.hu>
Date:   Sat Apr 22 06:53:10 2017 +0200

profile query without pds call

-----------------------------------------------------------------------

Summary of changes:
 libs/common_pg_funcs.php |   48 ++++++++++++++++++++++------------------------
 libs/interface.php       |   47 ++++++++++++++++++++++++++++-----------------
 oauth/resource.php       |    6 ++++++
 oauth/server.php         |    3 ++-
 pds/common_pg_funcs.php  |   28 +++++++++++++++++++++++++++
 pds/pds_class.php        |   42 ++++++++++++++++++++++++++++++++++++++--
 r-api                    |    2 +-
 r-api.DESCRIPTION        |   12 ++++++++++++
 8 files changed, 141 insertions(+), 47 deletions(-)
 create mode 100644 r-api.DESCRIPTION

-- 
OpenBioMaps GIT repository