From 3d02543fc00a46da2da8f682f71b538ca2fd36e5 Mon Sep 17 00:00:00 2001
From: ramverma <ram.krishna.verma@ericsson.com>
Date: Thu, 19 Jul 2018 18:45:16 +0100
Subject: Adding examples module to apex-pdp

Adding examples (MyFirstPolicy, AADM, Adaptive, PCVS) to apex-pdp
so that anyone can try out running few sample policies
and understand how to create and run policies in apex-pdp.

Change-Id: I0dff6d54ef94d8b5bdb63eabcb09e9f64d76fd0c
Issue-ID: POLICY-861
Signed-off-by: ramverma <ram.krishna.verma@ericsson.com>
---
 .../main/resources/SampleData/sql/apex_sales.sql   | 232 +++++++++++++++++++++
 1 file changed, 232 insertions(+)
 create mode 100644 examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql

(limited to 'examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql')

diff --git a/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql b/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql
new file mode 100644
index 000000000..a2ff5733b
--- /dev/null
+++ b/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql
@@ -0,0 +1,232 @@
+/*
+ * ============LICENSE_START=======================================================
+ *  Copyright (C) 2016-2018 Ericsson. All rights reserved.
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * 
+ * SPDX-License-Identifier: Apache-2.0
+ * ============LICENSE_END=========================================================
+ */
+
+--
+-- Create apex_sales database and populate it
+--
+
+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;
+
+--
+-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
+--
+
+CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
+
+
+--
+-- 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;
+
+--
+-- Create the database and switch to it
+--
+CREATE DATABASE apex_sales;
+\connect apex_sales;
+
+--
+-- Name: assistants; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE assistants (
+    assistantid text,
+    surname text,
+    firstname text,
+    middlename text,
+    age text,
+    grade text,
+    phoneno text
+);
+
+
+ALTER TABLE assistants OWNER TO postgres;
+
+--
+-- Name: branches; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE branches (
+    branchname text,
+    branchid text,
+    branchcategory text,
+    street text,
+    city text,
+    country text,
+    postcode text
+);
+
+
+ALTER TABLE branches OWNER TO postgres;
+
+--
+-- Name: items; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE items (
+    itemid text,
+    description text,
+    costprice text,
+    barcode text,
+    supplierid text,
+    category text
+);
+
+
+ALTER TABLE items OWNER TO postgres;
+
+--
+-- Name: sales; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE sales (
+    saleid text,
+    amount text,
+    itemid text,
+    quantity text,
+    assistantid text,
+    branchname text,
+    notes text
+);
+
+
+ALTER TABLE sales OWNER TO postgres;
+
+--
+-- Data for Name: assistants; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+COPY assistants (assistantid, surname, firstname, middlename, age, grade, phoneno) FROM stdin;
+1222	Citizen	Sean	Tadhg	23	3	871234321
+126	Doe	Jane	Donna	56	2	861234567
+13213	Svensson	Sven	Lars	72	1	854323456
+22	Bloggs	Joe	John	19	3	839877654
+33	Yamada	Taro	Nanno	34	3	892344333
+343	Mustermann	Max	Fritz	21	2	887655432
+\.
+
+
+--
+-- Data for Name: branches; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+COPY branches (branchname, branchid, branchcategory, street, city, country, postcode) FROM stdin;
+Al Raqqah	5667	Main	7 April Park	Al Raqqa	Syria	SY.RA.RA
+Athlone	99556	Sub	Church Street	Athlone	Ireland	N37 E733
+Cork	326	Main	Saint Patrick's Street	Cork	Ireland	T12 TE45
+Dallas	323	Main	John West Road	Dallas, TX	USA	75228
+Pyongyang	3233	Sub	Sungri Street	Pyongyang	Korea	23060
+Tullamore	59	Franchise	O'Moore Street	Tullamore	Ireland	R35 YP55
+Vladivostok	7884	Main	Admiral Yumasheva Street	Vladivostok	Russian Federation	690000
+\.
+
+
+--
+-- Data for Name: items; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+COPY items (itemid, description, costprice, barcode, supplierid, category) FROM stdin;
+1232	Table and Chairs	122.34	233454432	12452	Furniture
+1277689	Crested Ten	15.23	45543345	134435	Alcahol
+16775645	Marlboro Lights	2.25	13215321	2332	Tobacco
+234424	Stool	23.23	2132132	12452	Furniture
+3455634	Bed	96.78	123123	13325	Furniture
+\.
+
+
+--
+-- Data for Name: sales; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+COPY sales (saleid, amount, itemid, quantity, assistantid, branchname, notes) FROM stdin;
+6778392	22.45	234424	10	126	Athlone	Fabulous Sale
+7883454	167.89	1277689	2	343	Tullamore	\N
+8988516	2445.62	16775645	3545	1222	Cork	\N
+10093578	10.11	1277689	5	22	Athlone	Good Product
+11198640	233.45	234424	32	13213	Dallas	\N
+12303702	8585.74	3455634	435	33	Vladivostok	\N
+13408764	55	1232	45	1222	Vladivostok	\N
+14513826	955	16775645	2	33	Pyongyang	\N
+15618888	788.52	16775645	56	33	Dallas	\N
+16723950	9555.12	234424	84	33	Al Raqqah	\N
+17829012	8.78	3455634	5	1222	Cork	\N
+18934074	1	1232	9	126	Al Raqqah	\N
+20039136	0	16775645	9	126	Cork	\N
+21144198	28.63	1277689	4515	126	Athlone	\N
+22249260	9944.6	234424	4	126	Pyongyang	\N
+23354322	8.74	3455634	5	343	Dallas	\N
+24459384	8.77	1232	65	1222	Pyongyang	\N
+25564446	2722.88	16775645	5	22	Vladivostok	\N
+26669508	855.21	16775645	65	13213	Athlone	\N
+27774570	644.37	234424	56	33	Tullamore	\N
+28879632	633.8	3455634	56	1222	Al Raqqah	\N
+29984694	743.74	1232	7787	33	Cork	\N
+31089756	144.63	234424	65	33	Cork	\N
+32194818	5.7	1277689	89	33	Athlone	\N
+33299880	522.36	16775645	8	1222	Dallas	\N
+34404942	855.36	1277689	897	126	Al Raqqah	\N
+35510004	455.79	234424	5	126	Pyongyang	\N
+36615066	1.1	3455634	6	343	Pyongyang	\N
+37720128	966.37	1232	2	1222	Vladivostok	\N
+38825190	5.27	16775645	2	22	Pyongyang	\N
+39930252	444.5	16775645	232	13213	Dallas	\N
+41035314	214.59	234424	2	33	Al Raqqah	\N
+42140376	6.3	3455634	1	1222	Cork	\N
+43245438	455.17	1232	1	33	Al Raqqah	\N
+44350500	658.74	16775645	1	33	Cork	\N
+45455562	75755.8	1277689	2313	33	Athlone	\N
+46560624	0.01	234424	1165	1222	Pyongyang	\N
+47665686	855.96	3455634	33	126	Dallas	\N
+48770748	44444	1232	3	126	Pyongyang	\N
+49875810	8555.6	16775645	3131	343	Vladivostok	\N
+50980872	444577.2	16775645	8	1222	Pyongyang	\N
+52085934	8277	234424	1	22	Dallas	\N
+53190996	987.65	3455634	561	13213	Al Raqqah	\N
+54296058	123.54	1232	6551	33	Cork	\N
+\.
+
+
+--
+-- 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;
+
+
+--
+-- PostgreSQL database dump complete
+--
+
-- 
cgit 1.2.3-korg

