API tools faq
paste
Guest User

Untitled

a guest
Jan 31st, 2019
199
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.79 KB | None | 0 0
raw download clone embed print report
  1. postgresql:
  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 ';';
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!