diff options
Diffstat (limited to 'examples/myfirstpolicy/src/main/resources/SampleData')
6 files changed, 0 insertions, 329 deletions
diff --git a/examples/myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv b/examples/myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv deleted file mode 100644 index cd59d06c4..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/csv/AssistantInput.csv +++ /dev/null @@ -1,7 +0,0 @@ -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/myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv b/examples/myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv deleted file mode 100644 index 8d37e1ccd..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/csv/BranchInput.csv +++ /dev/null @@ -1,8 +0,0 @@ -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/myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv b/examples/myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv deleted file mode 100644 index 08416546c..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/csv/ItemInput.csv +++ /dev/null @@ -1,6 +0,0 @@ -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/myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv b/examples/myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv deleted file mode 100644 index 302430789..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/csv/SalesInput.csv +++ /dev/null @@ -1,45 +0,0 @@ -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/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql b/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql deleted file mode 100644 index a2ff5733b..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/sql/apex_sales.sql +++ /dev/null @@ -1,232 +0,0 @@ -/* - * ============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/myfirstpolicy/src/main/resources/SampleData/sql/readme.txt b/examples/myfirstpolicy/src/main/resources/SampleData/sql/readme.txt deleted file mode 100644 index f86aeb02c..000000000 --- a/examples/myfirstpolicy/src/main/resources/SampleData/sql/readme.txt +++ /dev/null @@ -1,31 +0,0 @@ -#------------------------------------------------------------------------------- -# ============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; - |