· 7 years ago · Feb 01, 2019, 04:40 AM
1postgresql:
2 persistence:
3 enabled: false
4 livenessProbe:
5 timeoutSeconds: 15
6 periodSeconds: 30
7 initialDelaySeconds: 180
8 readinessProbe:
9 initialDelaySeconds: 60
10 periodSeconds: 30
11 timeoutSeconds: 15
12 postgresqlUsername: "psql"
13 postgresqlPassword: "passw0rd"
14 postgresqlDatabase: "coco"
15 service:
16 type: NodePort
17 initdbScripts:
18 CompDir-ContactEmail.sh: |
19 #/bin/true
20 1;C;ZachNow@cocopharmaceutical.com
21 1;S;zach@cocopharmaceutical.com
22 2;C;SteveStarter@cocopharmaceutical.com
23 2;S;steve@cocopharmaceutical.com
24 3;C;TerriDaring@cocopharmaceutical.com
25 3;S;terri@cocopharmaceutical.com
26 4;C;tania.tidie@cocopharmaceutical.com
27 3;S;tania@cocopharmaceutical.com
28 5;C;polly.tasker@cocopharmaceutical.com
29 5;S;polly@cocopharmaceutical.com
30 6;C;tessa.tube@cocopharmaceutical.com
31 6;S;tessa@cocopharmaceutical.com
32 7;C;callie.quartile@cocopharmaceutical.com
33 7;S;callie@cocopharmaceutical.com
34 8;C;ivor.padlock@cocopharmaceutical.com
35 8;S;ivor@cocopharmaceutical.com
36 9;C;robert.nitter@cocopharmaceutical.com
37 10;C;faith.broker@cocopharmaceutical.com
38 11;C;sally.counter@cocopharmaceutical.com
39 12;C;lemmie.stage@cocopharmaceutical.com
40 13;C;erin.overview@cocopharmaceutical.com
41 14;C;harry.hopeful@cocopharmaceutical.com
42 15;C;gary.geeke@cocopharmaceutical.com
43 16;C;grant.able@hh-care.org
44 17;C;robert.records@hh-care.org
45 18;C;reggie.mint@cocopharmaceutical.com
46 19;C;peter.profile@cocopharmaceutical.com
47 20;C;nancy.noah@pretend.ibm.com
48 21;C;SJKSeeker@SecIncConSvcs.gmail
49 22;C;tom.tally@cocopharmaceutical.com
50 23;C;julie.stitched@hh-care.org
51 24;C;des.signa@pretend.ibm.com
52 25;C;angela.cummings@hh-care.org
53 26;C;jules.keeper@cocopharmaceutical.com
54
55 CompDir-ContactList.sh: |
56 #/bin/true
57 1;E;Zach;Now;Coco Pharmaceuticals;Founder;3
58 2;E;Steve;Starter;Coco Pharmaceuticals;Founder;1
59 3;E;Terri;Daring;Coco Pharmaceuticals;Founder;2
60 4;E;Tanya;Tidy;Coco Pharmaceuticals;Data Steward, Clinical Trials;3
61 5;E;Polly;Tasker;Coco Pharmaceuticals;IT Project Leader;1
62 6;E;Tessa;Tube;Coco Pharmaceuticals;Lead Researcher, Clinical Trials;3
63 7;E;Callie;Quartile;Coco Pharmaceuticals;Data Scientist;3
64 8;E;Ivor;Padlock;Coco Pharmaceuticals;Chief Security Officer;1
65 9;E;Bob;Nitter;Coco Pharmaceuticals;Application Developer;1
66 10;E;Faith;Broker;Coco Pharmaceuticals;Human Resources and Compliance Director;1
67 11;E;Sally;Counter;Coco Pharmaceuticals;Payment Clerk;2
68 12;E;Lemmie;Stage;Coco Pharmaceuticals;DataStage Specialist;1
69 13;E;Erin;Overview;Coco Pharmaceuticals;Information Architect;2
70 14;E;Harry;Hopeful;Coco Pharmaceuticals;Sales Specialist, New York;3
71 15;E;Gary;Geeke;Coco Pharmaceuticals;IT Infrastructure Lead;1
72 16;P;Grant;Able;Hampton Hospital;Consultant;4
73 17;P;Robbie;Records;Hampton Hospital;Patient Records Manager;4
74 18;E;Reggie;Mint;Coco Pharmaceuticals;Chief Finance Officer (CFO);2
75 19;E;Peter;Profile;Coco Pharmaceuticals;Information Analyst;2
76 20;C;Nancy;Noah;IBM;Cloud Architect;2
77 21;C;Sidney;Seeker;Sec Inc Consultancy Services;Fraud Investigator;2
78 22;E;Tom;Tally;Coco Pharmaceuticals;Accounts Manager, Finance HQ;2
79 23;P;Julie;Stitched;Hampton Hospital;Surgeon;4
80 24;C;Des;Signa;IBM;Mobile Developer;2
81 25;P;Angela;Cummings;Hampton Hospital;Nurse (Oncology);4
82 26;E;Jules;Keeper;Coco Pharmaceuticals;Chief Data Officer (CDO);2
83
84 CompDir-ContactPhone.sh: |
85 #/bin/true
86 1;O;1-912-333-4444 (ext 4)
87 1;M;1-912-380-7277
88 2;O;31-20-5274986 (ext 2)
89 3;O;44-20-372-2223 (ext 4)
90 4;O;1-912-333-4444
91 5;O;31-20-5274986 (ext 3)
92 6;O;1-912-333-4444 (ext 5)
93 7;O;1-912-333-4444 (ext 3)
94 8;O;31-20-5274986 (ext 4)
95 9;O;31-20-5274986 (ext 5)
96 10;O;31-20-5274986 (ext 6)
97 11;O;44-20-372-2223 (ext 2)
98 12;O;31-20-5274986 (ext 7)
99 13;O;44-20-372-2223 (ext 3)
100 14;O;1-912-333-4444 (ext 6)
101 14;M;1-912-345-8765
102 15;M;31-20-5274986 (ext 8)
103 16;M;1-912-456-6789
104 17;O;1-912-876-3456
105 18;O;44-20-372-2223 (ext 5)
106 19;O;44-20-372-2223 (ext 6)
107 20;M;44-800-323-4564
108 21;M;44-877-399-1999
109 22;O;44-20-372-2223 (ext 7)
110 23;M;1-912-666-4783
111 24;M;44-0800-567-1234
112 25;M;1-912-445-6655
113 26;O;44-20-372-2223 (ext 8)
114
115 EmplSAnl-EmpSalaryAnalysis.sh: |
116 #/bin/true
117 0;3809890;11;5;Zach;Now;133777;9999;9;New York;3;27;Founder;1;123800;5600;27;Code St;Harlem;NY;1;3
118 0;3809890;11;5;Steve;Starter;439222;9999;9;Amsterdam;1;27;Founder;1;123800;5600;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
119 0;3809890;11;5;Terri;Daring;371803;9999;9;London;2;27;Founder;1;123800;5600;32;Wibble Rd;Corterville;Greater London;1;2
120 0;3809890;10;7;Tanya;Tidy;209482;4051;2;New York;3;27;Data Steward;1;43800;215;27;Code St;Harlem;NY;1;3
121 0;3809890;9;7;Polly;Tasker;338575;2373;7;Amsterdam;1;27;IT Project Leader;1;46781;560;32;Wibble Rd;Corterville;North Holland;1;1
122 0;3809890;9;7;Tessa;Tube;302145;2343;7;New York;3;27;Lead Researcher;1;78934;1500;27;Code St;Harlem;NY;1;3
123 0;3809890;9;7;Callie;Quartile;328080;4051;5;New York;3;27;Data Scientist;1;56944;45;27;Code St;Harlem;NY;1;3
124 0;3809890;9;7;Ivor;Padlock;499888;2373;8;Amsterdam;1;27;Chief Security Officer;1;86453;4000;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
125 0;3809890;9;6;Bob;Nitter;458109;3082;4;Amsterdam;1;15;Application Developer;0;34504;150;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
126 0;3809890;9;5;Faith;Broker;139870;2373;8;Amsterdam;1;27;Human Resources and Compliance Director;1;84355;4000;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
127 0;3809890;8;6;Sally;Counter;457911;6877;2;London;2;20;Payment Clerk;0;23568;500;32;Wibble Rd;Corterville;Greater London;1;2
128 0;3809890;8;7;Lemmie;Stage;818928;3082;4;Amsterdam;1;27;DataStage Specialist;1;45324;300;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
129 0;3809890;8;7;Erin;Overview;324713;7432;7;London;2;27;Information Architect;1;87452;2000;32;Wibble Rd;Corterville;Greater London;1;2
130 0;3809890;6;7;Harry;Hopeful;144994;2343;6;New York;3;27;Sales Specialist, New York;1;56340;25465;27;Code St;Harlem;NY;1;3
131 0;3809890;6;7;Gary;Geeke;199995;3082;6;Amsterdam;1;27;IT Infrastructure Lead;1;54650;500;1833;Wilhelmdreef;Amsterdam-Zuidoost;North Holland;1;1
132 0;3809890;5;5;Reggie;Mint;188888;5656;8;London;2;27;Chief Finance Officer (CFO);1;125640;4100;32;Wibble Rd;Corterville;Greater London;1;2
133 0;3809890;2;7;Peter;Profile;986419;7432;5;London;2;27;Information Analyst;1;34520;450;32;Wibble Rd;Corterville;Greater London;1;2
134 0;3809890;2;7;Tom;Tally;896522;6788;7;London;2;27;Accounts Manager, Finance HQ;1;65432;800;32;Wibble Rd;Corterville;Greater London;1;2
135 0;3809890;0;5;Jules;Keeper;296776;5656;8;London;2;27;Chief Data Officer (CDO);1;11230;4000;32;Wibble Rd;Corterville;Greater London;1;2
136
137 Employee-Dept.sh: |
138 #/bin/true
139 4051;Clinical Trials;302145
140 3082;IT;338575
141 7432;Chief Data Office;296776
142 6877;Accounts;896522
143 6788;Finance;188888
144 2373;Amsterdam Lab;439222
145 5656;London Lab;371803
146 2343;New York Lab;133777
147 9999;Founders;
148
149 Employee-Employee.sh: |
150 #/bin/true
151 133777;Zach;Now;5;9;9999;Founder;3
152 439222;Steve;Starter;5;9;9999;Founder;1
153 371803;Terri;Daring;5;9;9999;Founder;2
154 209482;Tanya;Tidy;7;2;4051;Data Steward;3
155 338575;Polly;Tasker;7;7;2373;IT Project Leader;1
156 302145;Tessa;Tube;7;7;2343;Lead Researcher;3
157 328080;Callie;Quartile;7;5;4051;Data Scientist;3
158 499888;Ivor;Padlock;7;8;2373;Chief Security Officer;1
159 458109;Bob;Nitter;6;4;3082;Application Developer;1
160 139870;Faith;Broker;5;8;2373;Human Resources and Compliance Director;1
161 457911;Sally;Counter;6;2;6877;Payment Clerk;2
162 818928;Lemmie;Stage;7;4;3082;DataStage Specialist;1
163 324713;Erin;Overview;7;7;7432;Information Architect;2
164 144994;Harry;Hopeful;7;6;2343;Sales Specialist, New York;3
165 199995;Gary;Geeke;7;6;3082;IT Infrastructure Lead;1
166 188888;Reggie;Mint;5;8;5656;Chief Finance Officer (CFO);2
167 986419;Peter;Profile;7;5;7432;Information Analyst;2
168 896522;Tom;Tally;7;7;6788;Accounts Manager, Finance HQ;2
169 296776;Jules;Keeper;5;8;5656;Chief Data Officer (CDO);2
170
171 Location-WorkLocation.sh: |
172 #/bin/true
173 1;Amsterdam;;1833;Wilhelmdreef;Amsterdam-Zuidoost;Amsterdam;North Holland;Netherlands
174 2;London;;32;Wibble Rd;Corterville;London;Greater London;United Kingdom
175 3;New York;;27;Code St;Harlem;New York;NY;United States
176 4;Hampton Hospital;Oncology Unit 1, Hampton Hospital;;Nightingale St;Harlem;New York;NY;United States
177
178 Patient-Patient.sh: |
179 #/bin/true
180 1;Miss Apricot Lace;92 Bookworm Ave;Alesbelly;Oxfordshire;OX99 2EE;;UK1
181 2;A Steif;4 Button Cottages;Sawdust Hill;Waltenborough;WS45 1VF;;UK1
182 3;Mr William Smart;90 Bookworm Avenue;Alesbelly;Oxfordshire;OX99 2EE;;UK1
183 4;Mr Angus Atlantic;27 highland Rd;Loch User;Scotland;LO22 9fD;;UK1
184 5;Rodney Soft;37 Street Rd;Carshire;Nessex;NX23 9GH;;UK1
185 6;Mr Alistair Steiff;4 Button Cottages;Sawdust Hill;Waltenborough;WS45 1VF;;UK2
186 7;Mr Alistair Steiff;4 Button Cottages;Sawdust Hill;Waltenborough;WS45 1VF;;UK3
187 8;Mrs Daisy Seiff;4 Button Cottages;Sawdust Hill;Waltenborough;WS45 1VF;Wife;UK3
188 9;Mr T Bach;1 Daffodill Close;The Valles;Wales;LL4 7CW;;UK2
189 10;Mr Jonathon Trip;3 rRidge Road;Ropley;Arland;Old Hampshire;FD2 9MN;UK3
190 11;Mrs G Type;45 Long Rd;London;SW9 12GQ;;;UK3
191 12;Mr Fred Bean;5 Can Lane;Alleyvale Rd;Windford;Windfordshire;WN2 12FG;UK3
192 13;Alistare Steif;4 Button Cottages;Sawdust Hill;Waltenborough;WS45 1VF;;UK4
193 14;P J Bronson;132 Four Wheel Drive;Leatherseat;Surrey;;;UK3
194 15;Mrs S Counter;56 Number Close;Timeworth;London;SW45 6YU;;UK2
195 16;Graham Turner;The Spinney;Roundly;Cumbria;FD7 4RD;;UK1
196 17;Mr Gavin Fall;199 Long Rd;Midton;Centerville;Middleshire;MI6 1FF;UK1
197 18;Mrs Florence Bell;3 High St;Ringley;Hants;RG56 1DF;;UK2
198 19;Jeffery Fawkes;4 Green Rd;Countryside;Surrey;GU11 $GG;;UK4
199 20;Mr D Bloke;Will;Supply;Later;;;UK5
200 21;John Brown;Unit 1;Fairfield Estate;Windsor;WN33 9ED;;UK2
201 22;Mr David Nice;Rose Cottage;Dingleton;Devon;DI9 7FD;;UK2
202 23;Mrs Celia Nice;Rose Cottage;Dingleton;Devon;DI9 7FD;;UK3
203 24;Cathy Starter;1 First Row;Headley;Cornwall;HD9 8MN;;UK4
204 25;John Smith;18 Beer Street;Barrelton;Berkshire;BA25 7MZ;;UK5
205 26;John Smith Jr;Hursley Park;Winchester;Hants;SO21 2JN;;UK5
206 27;Miss Callie jones;IBM;Hursley Park;Winchester;Hants;So21 2JN;UK4
207 28;Ms D Rawlings;4 Cross Road;Wimpleton;Hants;ED3 4MA;;UK4
208 29;Sir Issac Cummings;The Manor;Crossby;Wiltshire;BH1 5TF;;UK4
209 30;Walter Steiff;4 Button Cottages;Sawdust hill;Waltenborough;WS45 1VF;;UK4
210 31;Dr Mike Cross;Surgery House;Main St;Wellton;WE20 2MN;;UK5
211 32;Mr Alister Steiff;4 Button Cottages;Waltenborough;OX99 2EE;;;UK5
212
213 loadCOMPDIR.sql: |
214 CREATE TABLE IF NOT EXISTS "CONTACTLIST" (
215 "RECID" INT NOT NULL PRIMARY KEY,
216 "CONTACTTYPE" CHAR NOT NULL,
217 "FIRSTNAME" VARCHAR(50) NOT NULL,
218 "LASTNAME" VARCHAR(50) NOT NULL,
219 "COMPANY" VARCHAR(50) NOT NULL,
220 "JOBTITLE" VARCHAR(80) NOT NULL,
221 "WORKLOCATION" INT NOT NULL
222 );
223 CREATE TABLE IF NOT EXISTS "CONTACTEMAIL" (
224 "REDIF" INT NOT NULL REFERENCES "CONTACTLIST",
225 "ETYPE" CHAR NOT NULL,
226 "EMAIL" VARCHAR(120) NOT NULL
227 );
228 CREATE TABLE IF NOT EXISTS "CONTACTPHONE" (
229 "RECID" INT NOT NULL REFERENCES "CONTACTLIST",
230 "CONTACTTYPE" CHAR NOT NULL,
231 "NUMBER" VARCHAR(40) NOT NULL
232 );
233 delete from "CONTACTPHONE";
234 delete from "CONTACTEMAIL";
235 delete from "CONTACTLIST";
236 \copy "CONTACTLIST" from '/docker-entrypoint-initdb.d/CompDir-ContactList.sh' with csv header DELIMITER ';';
237 \copy "CONTACTEMAIL" from '/docker-entrypoint-initdb.d/CompDir-ContactEmail.sh' with csv header DELIMITER ';';
238 \copy "CONTACTPHONE" from '/docker-entrypoint-initdb.d/CompDir-ContactPhone.sh' with csv header DELIMITER ';';
239
240 loadEMPLOYEE.sql: |
241 CREATE TABLE IF NOT EXISTS "DEPT" (
242 "DEPCODE" INT NOT NULL PRIMARY KEY,
243 "DEPNAME" VARCHAR(40) NOT NULL,
244 "MANAGER" INT
245 );
246 CREATE TABLE IF NOT EXISTS "EMPLOYEE" (
247 "PNUM" INT NOT NULL PRIMARY KEY,
248 "FNAME" VARCHAR(40) NOT NULL,
249 "LNAME" VARCHAR(120) NOT NULL,
250 "EMPSTATUS" INT NOT NULL,
251 "LVL" INT NOT NULL,
252 "DEPT" INT NOT NULL REFERENCES "DEPT",
253 "ROLE" VARCHAR(40) NOT NULL,
254 "LOCCODE" INT NOT NULL
255 );
256 delete from "EMPLOYEE";
257 delete from "DEPT";
258 \copy "DEPT" from '/docker-entrypoint-initdb.d/Employee-Dept.sh' with csv header DELIMITER ';';
259 \copy "EMPLOYEE" from '/docker-entrypoint-initdb.d/Employee-Employee.sh' with csv header DELIMITER ';';
260
261 loadEMPLSANL.sql: |
262 CREATE TABLE IF NOT EXISTS "EMPSALARYANALYSIS" (
263 "HDR" INT NOT NULL,
264 "RECTYPE" INT NOT NULL,
265 "SERVICE" INT NOT NULL,
266 "EMPSTATUS" INT NOT NULL,
267 "FNAME" VARCHAR(40) NOT NULL,
268 "LNAME" VARCHAR(40) NOT NULL,
269 "PNUM" INT NOT NULL,
270 "DEPT" INT NOT NULL,
271 "LVL" INT NOT NULL,
272 "LOCATION" VARCHAR(40) NOT NULL,
273 "LOCCODE" INT NOT NULL,
274 "HOL" INT NOT NULL,
275 "ROLE" VARCHAR(40) NOT NULL,
276 "ETYPE" INT NOT NULL,
277 "SALARY" INT NOT NULL,
278 "BONUS" INT NOT NULL,
279 "SNUM" INT NOT NULL,
280 "STREET" VARCHAR(40) NOT NULL,
281 "CITY" VARCHAR(40) NOT NULL,
282 "STATE" VARCHAR(40) NOT NULL,
283 "TAX" INT NOT NULL,
284 "TAXP" INT NOT NULL
285 );
286 delete from "EMPSALARYANALYSIS";
287 \copy "EMPSALARYANALYSIS" from '/docker-entrypoint-initdb.d/EmplSAnl-EmpSalaryAnalysis.sh' with csv header DELIMITER ';';
288
289 loadLOCATION.sql: |
290 CREATE TABLE IF NOT EXISTS "WORKLOCATION" (
291 "WLID" INT NOT NULL PRIMARY KEY,
292 "WLNAME" VARCHAR(40) NOT NULL,
293 "ADDR1" VARCHAR(40),
294 "ADDR2" VARCHAR(40),
295 "ADDR3" VARCHAR(40),
296 "ADDR4" VARCHAR(40),
297 "ADDR5" VARCHAR(40),
298 "ADDR6" VARCHAR(40),
299 "ADDR7" VARCHAR(40)
300 );
301 delete from "WORKLOCATION";
302 \copy "WORKLOCATION" from '/docker-entrypoint-initdb.d/Location-WorkLocation.sh' with csv header DELIMITER ';';
303
304 loadPATIENT.sql: |
305 CREATE TABLE IF NOT EXISTS "PATIENT" (
306 "PATIENTID" INT NOT NULL,
307 "PATIENT" VARCHAR(40) NOT NULL,
308 "LH_ADDR_1" VARCHAR(40),
309 "LH_ADDR_2" VARCHAR(40),
310 "LH_ADDR_3" VARCHAR(40),
311 "LH_ADDR_4" VARCHAR(40),
312 "LH_ADDR_5" VARCHAR(40),
313 "TRIAL" VARCHAR(10) NOT NULL
314 );
315 delete from "PATIENT";
316 \copy "PATIENT" from '/docker-entrypoint-initdb.d/Patient-Patient.sh' with csv header DELIMITER ';';