Renaming examples in apex-pdp

Renaming the examples as per what the documentation expects them.
Otherwise the documents won't work.

Change-Id: Ib9e30bf5a4cec0fec981372e1d9f3a0ee5d60f2f
Issue-ID: POLICY-861
Signed-off-by: ramverma <ram.krishna.verma@ericsson.com>

6 files changed, 329 insertions, 0 deletions

diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv
new file mode 100644
index 000000000..cd59d06c4
--- /dev/null
+++ b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv
@@ -0,0 +1,7 @@
+AssistantID,Surname,Firstname,Middlename,Age,Grade,PhoneNo
+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
\ No newline at end of file
diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv
new file mode 100644
index 000000000..8d37e1ccd
--- /dev/null
+++ b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv
@@ -0,0 +1,8 @@
+BranchName,BranchID,BranchCategory,Street,City,Country,Postcode
+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
\ No newline at end of file
diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv
new file mode 100644
index 000000000..08416546c
--- /dev/null
+++ b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv
@@ -0,0 +1,6 @@
+ItemID,Description,CostPrice,Barcode,SupplierID,Category
+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
\ No newline at end of file
diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv
new file mode 100644
index 000000000..302430789
--- /dev/null
+++ b/examples/examples-myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv
@@ -0,0 +1,45 @@
+SaleID,Amount,ItemID,Quantity,AssistantID,BranchName,Notes
+6778392,22.45,234424,10,126,Athlone,Fabulous Sale
+7883454,167.89,1277689,2,343,Tullamore,
+8988516,2445.62,16775645,3545,1222,Cork,
+10093578,10.11,1277689,5,22,Athlone,Good Product
+11198640,233.45,234424,32,13213,Dallas,
+12303702,8585.74,3455634,435,33,Vladivostok,
+13408764,55,1232,45,1222,Vladivostok,
+14513826,955,16775645,2,33,Pyongyang,
+15618888,788.52,16775645,56,33,Dallas,
+16723950,9555.12,234424,84,33,Al Raqqah,
+17829012,8.78,3455634,5,1222,Cork,
+18934074,1,1232,9,126,Al Raqqah,
+20039136,0,16775645,9,126,Cork,
+21144198,28.63,1277689,4515,126,Athlone,
+22249260,9944.6,234424,4,126,Pyongyang,
+23354322,8.74,3455634,5,343,Dallas,
+24459384,8.77,1232,65,1222,Pyongyang,
+25564446,2722.88,16775645,5,22,Vladivostok,
+26669508,855.21,16775645,65,13213,Athlone,
+27774570,644.37,234424,56,33,Tullamore,
+28879632,633.8,3455634,56,1222,Al Raqqah,
+29984694,743.74,1232,7787,33,Cork,
+31089756,144.63,234424,65,33,Cork,
+32194818,5.7,1277689,89,33,Athlone,
+33299880,522.36,16775645,8,1222,Dallas,
+34404942,855.36,1277689,897,126,Al Raqqah,
+35510004,455.79,234424,5,126,Pyongyang,
+36615066,1.1,3455634,6,343,Pyongyang,
+37720128,966.37,1232,2,1222,Vladivostok,
+38825190,5.27,16775645,2,22,Pyongyang,
+39930252,444.5,16775645,232,13213,Dallas,
+41035314,214.59,234424,2,33,Al Raqqah,
+42140376,6.3,3455634,1,1222,Cork,
+43245438,455.17,1232,1,33,Al Raqqah,
+44350500,658.74,16775645,1,33,Cork,
+45455562,75755.8,1277689,2313,33,Athlone,
+46560624,0.01,234424,1165,1222,Pyongyang,
+47665686,855.96,3455634,33,126,Dallas,
+48770748,44444,1232,3,126,Pyongyang,
+49875810,8555.6,16775645,3131,343,Vladivostok,
+50980872,444577.2,16775645,8,1222,Pyongyang,
+52085934,8277,234424,1,22,Dallas,
+53190996,987.65,3455634,561,13213,Al Raqqah,
+54296058,123.54,1232,6551,33,Cork,
\ No newline at end of file
diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql b/examples/examples-myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql
new file mode 100644
index 000000000..a2ff5733b
--- /dev/null
+++ b/examples/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
+--
+
diff --git a/examples/examples-myfirstpolicy/src/main/resources/SampleData/sql/readme.txt b/examples/examples-myfirstpolicy/src/main/resources/SampleData/sql/readme.txt
new file mode 100644
index 000000000..f86aeb02c
--- /dev/null
+++ b/examples/examples-myfirstpolicy/src/main/resources/SampleData/sql/readme.txt
@@ -0,0 +1,31 @@
+#-------------------------------------------------------------------------------
+# ============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=========================================================
+#-------------------------------------------------------------------------------
+
+To set up the apex_sales database, simply run the following command:
+psql -U postgres -a -f apex_sales.sql
+
+To test if the database has been set up correctly, rin the psql client as follows:
+
+psql -U postgres -d apex_sales
+select * from sales;
+select * from items;
+select * from assistants;
+select * from branches;
+