API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 8th, 2018
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.36 KB | None | 0 0
raw download clone embed print report
  1. const oracledb = require('oracledb');
  2.  
  3. const queries = [
  4. `create table emp (
  5. id int primary key NOT NULL,
  6. familiya varchar(128) NOT NULL,
  7. imya varchar(128) NOT NULL,
  8. otchestvo varchar(128) NOT NULL,
  9. role varchar(30) NOT NULL CONSTRAINT role_cns CHECK (role IN ('pilot', 'stuardesa', 'tehnik', 'vrach'))
  10. )`,
  11. `create table samolet (
  12. id int primary key NOT NULL ,
  13. bortname varchar(30) NOT NULL CONSTRAINT plane_bortname_cns CHECK (bortname IN ( 'Gf-1', 'Gf-2', 'Gf-3' )),
  14. modelname varchar(128) NOT NULL CONSTRAINT plane_name_cns CHECK (modelname IN ( 'Gulfstream G650')),
  15. seats int NOT NULL CONSTRAINT seats_cnstr CHECK (seats >= 1),
  16. status varchar(30) NOT NULL CONSTRAINT status_cns CHECK (status IN ( 'broken', 'ready'))
  17. )`,
  18. `create table reys (
  19. id int primary key NOT NULL ,
  20. samoletId int,
  21. firstPilotid int,
  22. secondPilotId int,
  23. stuardesaId int,
  24. dateFly date NOT NULL,
  25. track VARCHAR(30) NOT NULL CONSTRAINT track_cns CHECK (track IN ('А - G', 'G - A', 'A - D', 'D - A', 'A - V', 'V - A', 'A - B', 'B - A'))
  26. )`,
  27.  
  28. `alter table reys add foreign key (samoletId) references samolet(id)`,
  29. `alter table reys add foreign key (firstPilotId) references emp(id)`,
  30. `alter table reys add foreign key (secondPilotId) references emp(id)`,
  31. `alter table reys add foreign key (stuardesaId) references emp(id)`,
  32.  
  33. `create table passazhir (
  34. id int NOT NULL,
  35. reysId int,
  36. familiya varchar(128) NOT NULL,
  37. imya varchar(128) NOT NULL,
  38. otchestvo varchar(128) NOT NULL,
  39. passport varchar(128) NOT NULL,
  40. grazhdanstvo varchar(128) NOT NULL,
  41. cena DECIMAL NOT NULL ,
  42. mesto INT NOT NULL CONSTRAINT pass_seat_cns CHECK (mesto >= 0),
  43. constraint pas_pk primary key (id,reysId)
  44. )`,
  45.  
  46. `alter table passazhir add foreign key (reysId) references reys(id)`,
  47.  
  48. `create table medosmotr (
  49. id int NOT NULL ,
  50. pacientId int NOT NULL,
  51. reysId int,
  52. vrachId int,
  53. dateMed date NOT NULL,
  54. condition varchar(128) NOT NULL,
  55. pyls int NOT NULL ,
  56. davlenie1 int NOT NULL ,
  57. davlenie2 int NOT NULL ,
  58. temperatura decimal NOT NULL ,
  59. alcohol decimal NOT NULL,
  60. constraint med_pk primary key (id,pacientId)
  61. )`,
  62.  
  63. `alter table medosmotr add foreign key (reysId) references reys(id)`,
  64. `alter table medosmotr add foreign key (pacientId) references emp(id)`,
  65. `alter table medosmotr add foreign key (vrachId) references emp(id)`,
  66.  
  67. `create table charter (
  68. id int primary key NOT NULL ,
  69. reys1_id int,
  70. reys2_id int,
  71. zakazchik VARCHAR(128) NOT NULL ,
  72. date1 date NOT NULL,
  73. date2 date NOT NULL
  74. )`,
  75.  
  76. `alter table charter add foreign key (reys1_id) references reys(id)`,
  77. `alter table charter add foreign key (reys2_id) references reys(id)`,
  78.  
  79. `create table osmotr (
  80. id int NOT NULL ,
  81. samoletId int NOT NULL,
  82. tehnikid int,
  83. reysId int,
  84. engine varchar(30) NOT NULL,
  85. svyaz varchar(30) NOT NULL,
  86. upravlenie varchar(30) NOT NULL,
  87. shassi varchar(30) NOT NULL,
  88. dateTeh date NOT NULL,
  89. constraint osm_pk primary key (id,samoletId)
  90. )`,
  91.  
  92. `alter table osmotr add foreign key (samoletId) references samolet(id)`,
  93. `alter table osmotr add foreign key (tehnikId) references emp(id)`,
  94. `alter table osmotr add foreign key (reysId) references reys(id)`,
  95.  
  96. `create table remont (
  97. id int NOT NULL ,
  98. osmotrId int,
  99. samoletId int NOT NULL,
  100. tehnikid int,
  101. engine varchar(30) NOT NULL,
  102. svyaz varchar(30) NOT NULL,
  103. upravlenie varchar(30) NOT NULL,
  104. shassi varchar(30) NOT NULL,
  105. dateReq date NOT NULL,
  106. dateFinish date NOT NULL,
  107. status varchar(30) NOT NULL,
  108. constraint rem_pk primary key (id,samoletId)
  109. )`,
  110.  
  111. `alter table remont add foreign key (osmotrId,samoletId) references osmotr(id,samoletId)`,
  112. `alter table remont add foreign key (tehnikId) references emp(id)`,
  113.  
  114. `INSERT INTO samolet VALUES (0, 'Gf-1', 'Gulfstream G650', 6, 'ready')`,
  115. `INSERT INTO samolet VALUES (1, 'Gf-2', 'Gulfstream G650', 6, 'ready')`,
  116. `INSERT INTO samolet VALUES (2, 'Gf-3', 'Gulfstream G650', 6, 'ready')`,
  117.  
  118. `insert into emp values (0, 'Sadovkiy', 'Nikita', 'Konstantinovich', 'pilot')`,
  119. `insert into emp values (1, 'Ivanov', 'Sasha', 'Igorevich', 'pilot')`,
  120. `insert into emp values (2, 'Peplov', 'Dima', 'Dmitriyevich', 'pilot')`,
  121. `insert into emp values (3, 'Vetrov', 'Petya', 'Dmitriyevich', 'pilot')`,
  122. `insert into emp values (4, 'Ivanova', 'Zhenya', 'Andreeva', 'stuardesa')`,
  123. `insert into emp values (5, 'Gromico', 'Sasha', 'Alexandrovna', 'stuardesa')`,
  124. `insert into emp values (6, 'Ivanova', 'Natasha', 'Yuryevna', 'stuardesa')`,
  125. `insert into emp values (7, 'Reut', 'Masha', 'Dmitrievna', 'stuardesa')`,
  126. `insert into emp values (8, 'Vlasov', 'Sasha', 'Dmitriyevich', 'tehnik')`,
  127. `insert into emp values (9, 'Berzhinskiy', 'Sasha', 'Konstantinovich', 'tehnik')`,
  128. `insert into emp values (10, 'Ivanov', 'Nikita', 'Igorevich', 'tehnik')`,
  129. `insert into emp values (11, 'Lebedev', 'Petya', 'Konstantinovich', 'tehnik')`,
  130. `insert into emp values (12, 'Lebedev', 'Sasha', 'Igorevich', 'vrach')`,
  131. `insert into emp values (13, 'Zhukovech', 'Nikita', 'Konstantinovich', 'vrach')`,
  132. `insert into emp values (14, 'Kestner', 'Dima', 'Igorevich', 'vrach')`,
  133. `insert into emp values (15, 'Ivanov', 'Nikita', 'Konstantinovich', 'vrach')`,
  134.  
  135. `insert into reys values (0, 0, 0, 1, 4, to_date('20.01.2016','dd.mm.yyyy'), 'A - V')`,
  136. `insert into reys values (1, 0, 0, 1, 4, to_date('21.01.2016','dd.mm.yyyy'), 'V - A')`,
  137. `insert into reys values (2, 1, 3, 1, 6, to_date('20.02.2016','dd.mm.yyyy'), 'A - B')`,
  138. `insert into reys values (3, 1, 3, 1, 6, to_date('20.03.2016','dd.mm.yyyy'), 'B - A')`,
  139. `insert into reys values (4, 2, 1, 3, 7, to_date('20.04.2016','dd.mm.yyyy'), 'A - V')`,
  140. `insert into reys values (5, 2, 1, 3, 7, to_date('20.05.2016','dd.mm.yyyy'), 'V - A')`,
  141. `insert into reys values (6, 0, 2, 1, 5, to_date('20.06.2016','dd.mm.yyyy'), 'A - B')`,
  142. `insert into reys values (7, 0, 2, 1, 5, to_date('20.07.2016','dd.mm.yyyy'), 'B - A')`,
  143. `insert into reys values (8, 1, 0, 3, 4, to_date('20.08.2016','dd.mm.yyyy'), 'A - V')`,
  144. `insert into reys values (9, 1, 0, 3, 4, to_date('20.09.2016','dd.mm.yyyy'), 'V - A')`,
  145.  
  146. `insert into reys values (10, 0, 0, 1, 4, to_date('20.01.2015','dd.mm.yyyy'), 'А - G')`,
  147. `insert into reys values (11, 0, 0, 1, 4, to_date('21.01.2015','dd.mm.yyyy'), 'G - A')`,
  148. `insert into reys values (12, 2, 2, 3, 6, to_date('20.02.2015','dd.mm.yyyy'), 'A - D')`,
  149. `insert into reys values (13, 2, 2, 3, 6, to_date('20.03.2015','dd.mm.yyyy'), 'D - A')`,
  150. `insert into reys values (14, 1, 0, 2, 4, to_date('20.04.2015','dd.mm.yyyy'), 'А - G')`,
  151. `insert into reys values (15, 1, 0, 2, 4, to_date('20.05.2015','dd.mm.yyyy'), 'G - A')`,
  152. `insert into reys values (16, 0, 2, 1, 6, to_date('20.06.2015','dd.mm.yyyy'), 'A - D')`,
  153. `insert into reys values (17, 0, 2, 1, 6, to_date('20.07.2015','dd.mm.yyyy'), 'D - A')`,
  154. `insert into reys values (18, 2, 0, 3, 4, to_date('20.08.2015','dd.mm.yyyy'), 'А - G')`,
  155. `insert into reys values (19, 2, 0, 3, 4, to_date('20.09.2015','dd.mm.yyyy'), 'G - A')`,
  156. `insert into reys values (20, 0, 0, 1, 4, to_date('20.01.2017','dd.mm.yyyy'), 'G - A')`,
  157. `insert into reys values (21, 0, 0, 1, 4, to_date('21.01.2017','dd.mm.yyyy'), 'А - G')`,
  158. `insert into reys values (22, 2, 2, 3, 6, to_date('20.02.2017','dd.mm.yyyy'), 'A - D')`,
  159. `insert into reys values (23, 2, 2, 3, 6, to_date('20.03.2017','dd.mm.yyyy'), 'D - A')`,
  160. `insert into reys values (24, 1, 0, 2, 4, to_date('20.04.2017','dd.mm.yyyy'), 'А - G')`,
  161. `insert into reys values (25, 1, 0, 2, 4, to_date('20.05.2017','dd.mm.yyyy'), 'G - A')`,
  162. `insert into reys values (26, 0, 2, 1, 6, to_date('20.06.2017','dd.mm.yyyy'), 'A - D')`,
  163. `insert into reys values (27, 0, 2, 1, 6, to_date('20.07.2017','dd.mm.yyyy'), 'D - A')`,
  164. `insert into reys values (28, 2, 0, 3, 4, to_date('20.08.2017','dd.mm.yyyy'), 'А - G')`,
  165. `insert into reys values (29, 2, 0, 3, 4, to_date('20.09.2017','dd.mm.yyyy'), 'G - A')`,
  166.  
  167. `insert into charter values (0, 10, 11, 'invotecks', to_date('20.01.2015','dd.mm.yyyy'), to_date('21.01.2015','dd.mm.yyyy'))`,
  168. `insert into charter values (1, 12, 13, 'ithard', to_date('20.02.2015','dd.mm.yyyy'), to_date('20.03.2015','dd.mm.yyyy'))`,
  169. `insert into charter values (2, 14, 15, 'itra', to_date('20.04.2015','dd.mm.yyyy'), to_date('20.05.2015','dd.mm.yyyy'))`,
  170. `insert into charter values (3, 16, 17, 'epam', to_date('20.06.2015','dd.mm.yyyy'), to_date('20.07.2015','dd.mm.yyyy'))`,
  171. `insert into charter values (4, 18, 19, 'iba', to_date('20.08.2015','dd.mm.yyyy'), to_date('20.09.2015','dd.mm.yyyy'))`,
  172. `insert into charter values (5, 20, 21, 'invotecks', to_date('20.01.2017','dd.mm.yyyy'), to_date('21.01.2017','dd.mm.yyyy'))`,
  173. `insert into charter values (6, 22, 23, 'iba', to_date('20.02.2017','dd.mm.yyyy'), to_date('20.03.2017','dd.mm.yyyy'))`,
  174. `insert into charter values (7, 24, 25, 'itra', to_date('20.04.2017','dd.mm.yyyy'), to_date('20.05.2017','dd.mm.yyyy'))`,
  175. `insert into charter values (8, 26, 27, 'epam', to_date('20.06.2017','dd.mm.yyyy'), to_date('20.07.2017','dd.mm.yyyy'))`,
  176. `insert into charter values (9, 28, 29, 'ithard', to_date('20.08.2017','dd.mm.yyyy'), to_date('20.09.2017','dd.mm.yyyy'))`,
  177.  
  178.  
  179.  
  180.  
  181. `insert into passazhir values (0, 0, 'Sadovkiy', 'Nikita', 'Konstantinovich', 'MP0', 'rus', 100, 0)`,
  182. `insert into passazhir values (1, 0, 'Ivanov', 'Sasha', 'Igorevich', 'MP1', 'bel', 200, 1)`,
  183. `insert into passazhir values (2, 1, 'Peplov', 'Dima', 'Dmitriyevich', 'MP2', 'rus', 300, 2)`,
  184. `insert into passazhir values (3, 1, 'Vetrov', 'Petya', 'Dmitriyevich', 'MP3', 'bel', 400, 3)`,
  185. `insert into passazhir values (4, 2,'Ivanova', 'Zhenya', 'Andreeva', 'MP4', 'rus', 100, 4)`,
  186. `insert into passazhir values (5, 2,'Gromico', 'Sasha', 'Alexandrovna', 'MP5', 'bel', 200, 0)`,
  187. `insert into passazhir values (6, 3,'Ivanova', 'Natasha', 'Yuryevna', 'MP6', 'rus', 300, 1)`,
  188. `insert into passazhir values (7, 3,'Reut', 'Masha', 'Dmitrievna', 'MP7', 'bel', 400, 2)`,
  189. `insert into passazhir values (8, 4,'Vlasov', 'Sasha', 'Dmitriyevich', 'MP8', 'rus', 100, 3)`,
  190. `insert into passazhir values (9, 4,'Berzhinskiy', 'Sasha', 'Konstantinovich', 'MP9', 'bel', 200, 4)`,
  191. `insert into passazhir values (10, 5, 'Ivanov', 'Nikita', 'Igorevich', 'MP10', 'rus', 300, 0)`,
  192. `insert into passazhir values (11, 5, 'Lebedev', 'Petya', 'Konstantinovich', 'MP11', 'bel', 400, 1)`,
  193. `insert into passazhir values (12, 6, 'Lebedev', 'Sasha', 'Igorevich', 'MP12', 'rus', 100, 2)`,
  194. `insert into passazhir values (13, 6, 'Zhukovech', 'Nikita', 'Konstantinovich', 'MP13', 'bel', 200, 3)`,
  195. `insert into passazhir values (14, 7, 'Kestner', 'Dima', 'Igorevich', 'MP14', 'rus', 300, 4)`,
  196. `insert into passazhir values (15, 7, 'Ivanov', 'Nikita', 'Konstantinovich', 'MP15', 'bel', 400, 0)`,
  197. `insert into passazhir values (16, 8, 'Sadovkiy', 'Nikita', 'Konstantinovich', 'MP16', 'rus', 100, 1)`,
  198. `insert into passazhir values (17, 8, 'Ivanov', 'Sasha', 'Igorevich', 'MP17', 'bel', 200, 2)`,
  199. `insert into passazhir values (18, 9, 'Peplov', 'Dima', 'Dmitriyevich', 'MP18', 'rus', 300, 3)`,
  200. `insert into passazhir values (19, 9, 'Vetrov', 'Petya', 'Dmitriyevich', 'MP19', 'bel', 400, 4)`,
  201. `insert into passazhir values (20, 10,'Ivanova', 'Zhenya', 'Andreeva', 'MP20', 'rus', 100, 0)`,
  202. `insert into passazhir values (21, 10,'Gromico', 'Sasha', 'Alexandrovna', 'MP21', 'bel', 200, 1)`,
  203. `insert into passazhir values (22, 11,'Ivanova', 'Natasha', 'Yuryevna', 'MP22', 'rus', 300, 2)`,
  204. `insert into passazhir values (23, 11,'Reut', 'Masha', 'Dmitrievna', 'MP23', 'bel', 400, 3)`,
  205. `insert into passazhir values (24, 12,'Vlasov', 'Sasha', 'Dmitriyevich', 'MP24', 'rus', 100, 4)`,
  206. `insert into passazhir values (25, 12,'Berzhinskiy', 'Sasha', 'Konstantinovich', 'MP25', 'bel', 200, 0)`,
  207. `insert into passazhir values (26, 13, 'Ivanov', 'Nikita', 'Igorevich', 'MP26', 'rus', 300, 1)`,
  208. `insert into passazhir values (27, 13, 'Lebedev', 'Petya', 'Konstantinovich', 'MP27', 'bel', 400, 2)`,
  209. `insert into passazhir values (28, 14, 'Lebedev', 'Sasha', 'Igorevich', 'MP28', 'rus', 100, 3)`,
  210. `insert into passazhir values (29, 14, 'Zhukovech', 'Nikita', 'Konstantinovich', 'MP29', 'bel', 200, 4)`,
  211. `insert into passazhir values (30, 15, 'Sadovkiy', 'Nikita', 'Konstantinovich', 'MP30', 'rus', 300, 0)`,
  212. `insert into passazhir values (31, 15, 'Ivanov', 'Sasha', 'Igorevich', 'MP31', 'bel', 400, 1)`,
  213. `insert into passazhir values (32, 16, 'Peplov', 'Dima', 'Dmitriyevich', 'MP32', 'rus', 100, 2)`,
  214. `insert into passazhir values (33, 17, 'Vetrov', 'Petya', 'Dmitriyevich', 'MP33', 'bel', 200, 3)`,
  215. `insert into passazhir values (34, 29,'Ivanova', 'Zhenya', 'Andreeva', 'MP34', 'rus', 300, 4)`,
  216. `insert into passazhir values (35, 28,'Gromico', 'Sasha', 'Alexandrovna', 'MP35', 'bel', 400, 0)`,
  217. `insert into passazhir values (36, 18,'Ivanova', 'Natasha', 'Yuryevna', 'MP36', 'rus', 100, 1)`,
  218. `insert into passazhir values (37, 18,'Reut', 'Masha', 'Dmitrievna', 'MP37', 'bel', 200, 2)`,
  219. `insert into passazhir values (38, 19,'Vlasov', 'Sasha', 'Dmitriyevich', 'MP38', 'rus', 300, 3)`,
  220. `insert into passazhir values (39, 20,'Berzhinskiy', 'Sasha', 'Konstantinovich', 'MP39', 'bel', 400, 4)`,
  221. `insert into passazhir values (30, 21, 'Ivanov', 'Nikita', 'Igorevich', 'MP40', 'rus', 100, 0)`,
  222. `insert into passazhir values (41, 22, 'Lebedev', 'Petya', 'Konstantinovich', 'MP41', 'bel', 200, 1)`,
  223. `insert into passazhir values (42, 23, 'Lebedev', 'Sasha', 'Igorevich', 'MP42', 'rus', 300, 2)`,
  224. `insert into passazhir values (43, 24, 'Zhukovech', 'Nikita', 'Konstantinovich', 'MP43', 'bel', 400, 3)`,
  225. `insert into passazhir values (44, 25, 'Kestner', 'Dima', 'Igorevich', 'MP44', 'rus', 100, 4)`,
  226. `insert into passazhir values (45, 26, 'Ivanov', 'Nikita', 'Konstantinovich', 'MP45', 'bel', 200, 0)`,
  227.  
  228. `insert into medosmotr values (0, 0, 0, 12, to_date('19.01.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.0, 0.0)`,
  229. `insert into medosmotr values (1, 0, 1, 13, to_date('20.01.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.1, 0.0)`,
  230. `insert into medosmotr values (2, 3, 2, 14, to_date('19.02.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.2, 0.0)`,
  231. `insert into medosmotr values (3, 3, 3, 15, to_date('19.03.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.3, 0.0)`,
  232. `insert into medosmotr values (4, 1, 4, 12, to_date('20.04.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.4, 0.0)`,
  233. `insert into medosmotr values (5, 1, 5, 13, to_date('20.05.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.5, 0.0)`,
  234. `insert into medosmotr values (6, 2, 6, 14, to_date('20.06.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.6, 0.0)`,
  235. `insert into medosmotr values (7, 2, 7, 15, to_date('20.07.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.7, 0.0)`,
  236. `insert into medosmotr values (8, 0, 8, 12, to_date('20.08.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.8, 0.0)`,
  237. `insert into medosmotr values (9, 0, 9, 13, to_date('20.09.2016','dd.mm.yyyy'), 'fine', 50,120, 70, 36.9, 0.0)`,
  238. `insert into medosmotr values (10, 0, 10, 14, to_date('20.01.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.0, 0.0)`,
  239. `insert into medosmotr values (11, 0, 11, 15, to_date('21.01.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.1, 0.0)`,
  240. `insert into medosmotr values (12, 2, 12, 12, to_date('20.02.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.2, 0.0)`,
  241. `insert into medosmotr values (13, 2, 13, 13, to_date('20.03.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.3, 0.0)`,
  242. `insert into medosmotr values (14, 0, 14, 14, to_date('20.04.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.4, 0.0)`,
  243. `insert into medosmotr values (15, 0, 15, 15, to_date('20.05.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.5, 0.0)`,
  244. `insert into medosmotr values (16, 2, 16, 12, to_date('20.06.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.6, 0.0)`,
  245. `insert into medosmotr values (17, 2, 17, 13, to_date('20.07.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.7, 0.0)`,
  246. `insert into medosmotr values (18, 0, 18, 14, to_date('20.08.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.8, 0.0)`,
  247. `insert into medosmotr values (19, 0, 19, 15, to_date('20.09.2015','dd.mm.yyyy'), 'fine', 50,120, 70, 36.9, 0.0)`,
  248. `insert into medosmotr values (20, 0, 20, 12, to_date('20.01.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.0, 0.0)`,
  249. `insert into medosmotr values (21, 0, 21, 13, to_date('21.01.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.1, 0.0)`,
  250. `insert into medosmotr values (22, 2, 22, 14, to_date('20.02.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.2, 0.0)`,
  251. `insert into medosmotr values (23, 2, 23, 15, to_date('20.03.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.3, 0.0)`,
  252. `insert into medosmotr values (24, 0, 24, 12, to_date('20.04.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.4, 0.0)`,
  253. `insert into medosmotr values (25, 0, 25, 13, to_date('20.05.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.5, 0.0)`,
  254. `insert into medosmotr values (26, 2, 26, 14, to_date('20.06.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.6, 0.0)`,
  255. `insert into medosmotr values (27, 2, 27, 15, to_date('20.07.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.7, 0.0)`,
  256. `insert into medosmotr values (28, 0, 28, 12, to_date('20.08.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.8, 0.0)`,
  257. `insert into medosmotr values (29, 0, 29, 13, to_date('20.09.2017','dd.mm.yyyy'), 'fine', 50,120, 70, 36.9, 0.0)`,
  258. `insert into medosmotr values (30, 1, 0, 12, to_date('19.01.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.0, 0.0)`,
  259. `insert into medosmotr values (31, 1, 1, 13, to_date('20.01.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.1, 0.0)`,
  260. `insert into medosmotr values (32, 1, 2, 14, to_date('19.02.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.2, 0.0)`,
  261. `insert into medosmotr values (33, 1, 3, 15, to_date('19.03.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.3, 0.0)`,
  262. `insert into medosmotr values (34, 3, 4, 12, to_date('20.04.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.4, 0.0)`,
  263. `insert into medosmotr values (35, 3, 5, 13, to_date('20.05.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.5, 0.0)`,
  264. `insert into medosmotr values (36, 1, 6, 14, to_date('20.06.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.6, 0.0)`,
  265. `insert into medosmotr values (37, 1, 7, 15, to_date('20.07.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.7, 0.0)`,
  266. `insert into medosmotr values (38, 3, 8, 12, to_date('20.08.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.8, 0.0)`,
  267. `insert into medosmotr values (39, 3, 9, 13, to_date('20.09.2016','dd.mm.yyyy'), 'fine', 51,131, 71, 36.9, 0.0)`,
  268. `insert into medosmotr values (40, 1, 10, 14, to_date('20.01.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.0, 0.0)`,
  269. `insert into medosmotr values (41, 1, 11, 15, to_date('21.01.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.1, 0.0)`,
  270. `insert into medosmotr values (42, 3, 12, 12, to_date('20.02.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.2, 0.0)`,
  271. `insert into medosmotr values (43, 3, 13, 13, to_date('20.03.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.3, 0.0)`,
  272. `insert into medosmotr values (44, 2, 14, 14, to_date('20.04.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.4, 0.0)`,
  273. `insert into medosmotr values (45, 2, 15, 15, to_date('20.05.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.5, 0.0)`,
  274. `insert into medosmotr values (46, 1, 16, 12, to_date('20.06.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.6, 0.0)`,
  275. `insert into medosmotr values (47, 1, 17, 13, to_date('20.07.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.7, 0.0)`,
  276. `insert into medosmotr values (48, 3, 18, 14, to_date('20.08.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.8, 0.0)`,
  277. `insert into medosmotr values (49, 3, 19, 15, to_date('20.09.2015','dd.mm.yyyy'), 'fine', 51,131, 71, 36.9, 0.0)`,
  278. `insert into medosmotr values (50, 1, 20, 12, to_date('20.01.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.0, 0.0)`,
  279. `insert into medosmotr values (51, 1, 21, 13, to_date('21.01.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.1, 0.0)`,
  280. `insert into medosmotr values (52, 3, 22, 14, to_date('20.02.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.2, 0.0)`,
  281. `insert into medosmotr values (53, 3, 23, 15, to_date('20.03.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.3, 0.0)`,
  282. `insert into medosmotr values (54, 2, 24, 12, to_date('20.04.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.4, 0.0)`,
  283. `insert into medosmotr values (55, 2, 25, 13, to_date('20.05.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.5, 0.0)`,
  284. `insert into medosmotr values (56, 1, 26, 14, to_date('20.06.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.6, 0.0)`,
  285. `insert into medosmotr values (57, 1, 27, 15, to_date('20.07.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.7, 0.0)`,
  286. `insert into medosmotr values (58, 3, 28, 12, to_date('20.08.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.8, 0.0)`,
  287. `insert into medosmotr values (59, 3, 29, 13, to_date('20.09.2017','dd.mm.yyyy'), 'fine', 51,131, 71, 36.9, 0.0)`,
  288. `insert into medosmotr values (60, 4, 0, 12, to_date('19.01.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.0, 0.0)`,
  289. `insert into medosmotr values (61, 4, 1, 13, to_date('20.01.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.1, 0.0)`,
  290. `insert into medosmotr values (62, 6, 2, 14, to_date('19.02.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.2, 0.0)`,
  291. `insert into medosmotr values (63, 6, 3, 15, to_date('19.03.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.3, 0.0)`,
  292. `insert into medosmotr values (64, 7, 4, 12, to_date('20.04.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.4, 0.0)`,
  293. `insert into medosmotr values (65, 7, 5, 13, to_date('20.05.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.5, 0.0)`,
  294. `insert into medosmotr values (66, 5, 6, 14, to_date('20.06.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.6, 0.0)`,
  295. `insert into medosmotr values (67, 5, 7, 15, to_date('20.07.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.7, 0.0)`,
  296. `insert into medosmotr values (68, 4, 8, 12, to_date('20.08.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.8, 0.0)`,
  297. `insert into medosmotr values (69, 4, 9, 13, to_date('20.09.2016','dd.mm.yyyy'), 'fine', 52,142, 72, 36.9, 0.0)`,
  298. `insert into medosmotr values (70, 4, 10, 14, to_date('20.01.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.0, 0.0)`,
  299. `insert into medosmotr values (71, 4, 11, 15, to_date('21.01.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.1, 0.0)`,
  300. `insert into medosmotr values (72, 6, 12, 12, to_date('20.02.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.2, 0.0)`,
  301. `insert into medosmotr values (73, 6, 13, 13, to_date('20.03.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.3, 0.0)`,
  302. `insert into medosmotr values (74, 4, 14, 14, to_date('20.04.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.4, 0.0)`,
  303. `insert into medosmotr values (75, 4, 15, 15, to_date('20.05.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.5, 0.0)`,
  304. `insert into medosmotr values (76, 6, 16, 12, to_date('20.06.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.6, 0.0)`,
  305. `insert into medosmotr values (77, 6, 17, 13, to_date('20.07.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.7, 0.0)`,
  306. `insert into medosmotr values (78, 4, 18, 14, to_date('20.08.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.8, 0.0)`,
  307. `insert into medosmotr values (79, 4, 19, 15, to_date('20.09.2015','dd.mm.yyyy'), 'fine', 52,142, 72, 36.9, 0.0)`,
  308. `insert into medosmotr values (80, 4, 20, 12, to_date('20.01.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.0, 0.0)`,
  309. `insert into medosmotr values (81, 4, 21, 13, to_date('21.01.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.1, 0.0)`,
  310. `insert into medosmotr values (82, 6, 22, 14, to_date('20.02.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.2, 0.0)`,
  311. `insert into medosmotr values (83, 6, 23, 15, to_date('20.03.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.3, 0.0)`,
  312. `insert into medosmotr values (84, 4, 24, 12, to_date('20.04.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.4, 0.0)`,
  313. `insert into medosmotr values (85, 4, 25, 13, to_date('20.05.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.5, 0.0)`,
  314. `insert into medosmotr values (86, 6, 26, 14, to_date('20.06.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.6, 0.0)`,
  315. `insert into medosmotr values (87, 6, 27, 15, to_date('20.07.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.7, 0.0)`,
  316. `insert into medosmotr values (88, 4, 28, 12, to_date('20.08.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.8, 0.0)`,
  317. `insert into medosmotr values (89, 4, 29, 13, to_date('20.09.2017','dd.mm.yyyy'), 'fine', 52,142, 72, 36.9, 0.0)`,
  318.  
  319. `insert into osmotr values (0, 0, 8, 0, 'fine', 'fine', 'fine', 'fine', to_date('15.01.2016','dd.mm.yyyy'))`,
  320. `insert into osmotr values (1, 1, 9, 1, 'fine', 'fine', 'fine', 'fine', to_date('16.01.2016','dd.mm.yyyy'))`,
  321. `insert into osmotr values (2, 2, 10, 2, 'fine', 'fine', 'fine', 'fine', to_date('15.02.2016','dd.mm.yyyy'))`,
  322. `insert into osmotr values (3, 0, 11, 3, 'fine', 'fine', 'fine', 'fine', to_date('15.03.2016','dd.mm.yyyy'))`,
  323. `insert into osmotr values (4, 1, 8, 4, 'fine', 'fine', 'fine', 'fine', to_date('15.04.2016','dd.mm.yyyy'))`,
  324. `insert into osmotr values (5, 2, 9, 5, 'fine', 'fine', 'fine', 'fine', to_date('15.05.2016','dd.mm.yyyy'))`,
  325. `insert into osmotr values (6, 0, 10, 6, 'fine', 'fine', 'fine', 'fine', to_date('15.06.2016','dd.mm.yyyy'))`,
  326. `insert into osmotr values (7, 1, 11, 7, 'fine', 'fine', 'fine', 'fine', to_date('15.07.2016','dd.mm.yyyy'))`,
  327. `insert into osmotr values (8, 2, 8, 8, 'fine', 'fine', 'fine', 'fine', to_date('15.08.2016','dd.mm.yyyy'))`,
  328. `insert into osmotr values (9, 0, 9, 9, 'fine', 'fine', 'fine', 'fine', to_date('15.09.2016','dd.mm.yyyy'))`,
  329. `insert into osmotr values (10, 1, 10, 10, 'fine', 'fine', 'fine', 'fine', to_date('15.01.2015','dd.mm.yyyy'))`,
  330. `insert into osmotr values (11, 2, 11, 11, 'fine', 'fine', 'fine', 'fine', to_date('16.01.2015','dd.mm.yyyy'))`,
  331. `insert into osmotr values (12, 0, 8, 12, 'fine', 'fine', 'fine', 'fine', to_date('15.02.2015','dd.mm.yyyy'))`,
  332. `insert into osmotr values (13, 1, 9, 13, 'fine', 'fine', 'fine', 'fine', to_date('15.03.2015','dd.mm.yyyy'))`,
  333. `insert into osmotr values (14, 2, 10, 14, 'fine', 'fine', 'fine', 'fine', to_date('15.04.2015','dd.mm.yyyy'))`,
  334. `insert into osmotr values (15, 0, 11, 15, 'fine', 'fine', 'fine', 'fine', to_date('15.05.2015','dd.mm.yyyy'))`,
  335. `insert into osmotr values (16, 1, 8, 16, 'fine', 'fine', 'fine', 'fine', to_date('15.06.2015','dd.mm.yyyy'))`,
  336. `insert into osmotr values (17, 2, 9, 17, 'fine', 'fine', 'fine', 'fine', to_date('15.07.2015','dd.mm.yyyy'))`,
  337. `insert into osmotr values (18, 0, 10, 18, 'fine', 'fine', 'fine', 'fine', to_date('15.08.2015','dd.mm.yyyy'))`,
  338. `insert into osmotr values (19, 1, 11, 19, 'fine', 'fine', 'fine', 'fine', to_date('15.09.2015','dd.mm.yyyy'))`,
  339. `insert into osmotr values (20, 2, 8, 20, 'fine', 'fine', 'fine', 'fine', to_date('15.01.2017','dd.mm.yyyy'))`,
  340. `insert into osmotr values (21, 0, 9, 21, 'fine', 'fine', 'fine', 'fine', to_date('16.01.2017','dd.mm.yyyy'))`,
  341. `insert into osmotr values (22, 1, 10, 22, 'fine', 'fine', 'fine', 'fine', to_date('15.02.2017','dd.mm.yyyy'))`,
  342. `insert into osmotr values (23, 2, 11, 23, 'fine', 'fine', 'fine', 'fine', to_date('15.03.2017','dd.mm.yyyy'))`,
  343. `insert into osmotr values (24, 0, 8, 24, 'fine', 'fine', 'fine', 'fine', to_date('15.04.2017','dd.mm.yyyy'))`,
  344. `insert into osmotr values (25, 1, 9, 25, 'fine', 'fine', 'fine', 'fine', to_date('15.05.2017','dd.mm.yyyy'))`,
  345. `insert into osmotr values (26, 2, 10, 26, 'fine', 'fine', 'fine', 'fine', to_date('15.06.2017','dd.mm.yyyy'))`,
  346. `insert into osmotr values (27, 0, 11, 27, 'fine', 'fine', 'fine', 'fine', to_date('15.07.2017','dd.mm.yyyy'))`,
  347. `insert into osmotr values (28, 1, 8, 28, 'fine', 'fine', 'fine', 'fine', to_date('15.08.2017','dd.mm.yyyy'))`,
  348. `insert into osmotr values (29, 2, 9, 29, 'fine', 'fine', 'fine', 'fine', to_date('15.09.2017','dd.mm.yyyy'))`,
  349.  
  350. `insert into osmotr values (30, 0, 8, 2, 'fine', 'bad', 'fine', 'fine', to_date('15.02.2016','dd.mm.yyyy'))`,
  351. `insert into osmotr values (31, 2, 9, 4, 'fine', 'fine', 'bad', 'fine', to_date('16.04.2017','dd.mm.yyyy'))`,
  352. `insert into osmotr values (32, 3, 10, 22, 'fine', 'bad', 'fine', 'fine', to_date('15.02.2017','dd.mm.yyyy'))`,
  353. `insert into osmotr values (33, 4, 11, 23, 'fine', 'bad', 'fine', 'fine', to_date('15.03.2017','dd.mm.yyyy'))`,
  354. `insert into osmotr values (34, 3, 8, 24, 'fine', 'fine', 'bad', 'fine', to_date('15.04.2017','dd.mm.yyyy'))`,
  355. `insert into osmotr values (35, 4, 9, 25, 'fine', 'bad', 'fine', 'fine', to_date('15.05.2017','dd.mm.yyyy'))`,
  356. `insert into osmotr values (36, 3, 10, 26, 'fine', 'fine', 'bad', 'fine', to_date('15.06.2017','dd.mm.yyyy'))`,
  357. `insert into osmotr values (37, 4, 11, 27, 'fine', 'fine', 'fine', 'bad', to_date('15.07.2017','dd.mm.yyyy'))`,
  358. `insert into osmotr values (38, 3, 8, 28, 'bad', 'fine', 'fine', 'fine', to_date('15.08.2017','dd.mm.yyyy'))`,
  359. `insert into osmotr values (39, 4, 9, 29, 'fine', 'fine', 'bad', 'fine', to_date('15.09.2017','dd.mm.yyyy'))`,
  360.  
  361. `insert into remont values (0, 30, 0, 8, 20, 'fine', 'bad', 'fine', 'fine', to_date('15.02.2017','dd.mm.yyyy'), to_date('25.01.2017','dd.mm.yyyy'),)`,
  362. `insert into remont values (1,31, 2, 9, 21, 'fine', 'fine', 'bad', 'fine', to_date('16.01.2017','dd.mm.yyyy'), to_date('25.01.2017','dd.mm.yyyy'),)`,
  363. `insert into remont values (2,32, 4, 10, 22, 'fine', 'bad', 'fine', 'fine', to_date('15.02.2017','dd.mm.yyyy'), to_date('25.02.2017','dd.mm.yyyy'),)`,
  364. `insert into remont values (3,33, 6, 11, 23, 'fine', 'bad', 'fine', 'fine', to_date('15.03.2017','dd.mm.yyyy'), to_date('25.03.2017','dd.mm.yyyy'),)`,
  365. `insert into remont values (4,34, 8, 8, 24, 'fine', 'fine', 'bad', 'fine', to_date('15.04.2017','dd.mm.yyyy'), to_date('25.04.2017','dd.mm.yyyy'),)`,
  366.  
  367. `commit`
  368. ];
  369. oracledb.getConnection(
  370. {
  371. user: "system",
  372. password: "123",
  373. connectString: "localhost/XE"
  374. },
  375. function (err, connection) {
  376. if (err) {
  377. console.error(err.message);
  378. return;
  379. }
  380. queries.reduce((chain, q, i) => {
  381. return chain.then(() => {
  382. console.log(q);
  383. return connection.execute(q)})
  384. }, Promise.resolve())
  385. .then(res =>{
  386. console.log(res.rows);
  387. doRelease(connection);
  388. return;
  389. })
  390. .catch(err => {
  391. console.log(err);
  392. })
  393. });
  394.  
  395. function doRelease(connection) {
  396. connection.close(
  397. function (err) {
  398. if (err)
  399. console.error(err.message);
  400. });
  401. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!