Skip to content

Instantly share code, notes, and snippets.

@mche

mche/электроэнергия

Last active April 16, 2020 08:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mche/c126605490602c15b3f9da1753f02dae to your computer and use it in GitHub Desktop.
Save mche/c126605490602c15b3f9da1753f02dae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
электроэнергия
sost=# select * from "удалить объект"('public', 'категории', 'refs', 272660, 1732);
INFO: В таблице "public"."категории" удалена запись {"id":272660,"ts":"2018-08-27T17:14:28.688584","title":"электроэнергия","parent":3,"childs":[],"disabled":null,"img":null,"order":null}
INFO: В таблице "public"."refs" удалена запись {"id":441782,"ts":"2019-02-18T12:20:09.444477","id1":272660,"id2":441781}
INFO: В таблице "public"."refs" удалена запись {"id":441815,"ts":"2019-02-18T12:23:17.482758","id1":272660,"id2":441814}
INFO: В таблице "public"."refs" удалена запись {"id":441824,"ts":"2019-02-18T12:23:54.508557","id1":272660,"id2":441823}
INFO: В таблице "public"."refs" удалена запись {"id":465254,"ts":"2019-03-14T12:41:12.104624","id1":272660,"id2":465253}
INFO: В таблице "public"."refs" удалена запись {"id":465268,"ts":"2019-03-14T12:42:25.000011","id1":272660,"id2":465267}
INFO: В таблице "public"."refs" удалена запись {"id":465317,"ts":"2019-03-14T12:47:11.20518","id1":272660,"id2":465316}
INFO: В таблице "public"."refs" удалена запись {"id":465327,"ts":"2019-03-14T12:47:43.783847","id1":272660,"id2":465326}
INFO: В таблице "public"."refs" удалена запись {"id":506377,"ts":"2019-04-17T11:28:54.068042","id1":272660,"id2":506376}
INFO: В таблице "public"."refs" удалена запись {"id":506382,"ts":"2019-04-17T11:29:23.550628","id1":272660,"id2":506381}
INFO: В таблице "public"."refs" удалена запись {"id":506391,"ts":"2019-04-17T11:30:45.673013","id1":272660,"id2":506390}
INFO: В таблице "public"."refs" удалена запись {"id":506396,"ts":"2019-04-17T11:31:51.771033","id1":272660,"id2":506395}
INFO: В таблице "public"."refs" удалена запись {"id":579837,"ts":"2019-06-19T19:03:36.417675","id1":272660,"id2":579836}
INFO: В таблице "public"."refs" удалена запись {"id":579842,"ts":"2019-06-19T19:04:09.276074","id1":272660,"id2":579841}
INFO: В таблице "public"."refs" удалена запись {"id":579856,"ts":"2019-06-19T19:06:18.249954","id1":272660,"id2":579855}
INFO: В таблице "public"."refs" удалена запись {"id":579865,"ts":"2019-06-19T19:07:42.136317","id1":272660,"id2":579864}
INFO: В таблице "public"."refs" удалена запись {"id":588214,"ts":"2019-06-26T12:55:30.66637","id1":272660,"id2":588213}
INFO: В таблице "public"."refs" удалена запись {"id":600149,"ts":"2019-07-02T16:42:10.403901","id1":272660,"id2":600148}
INFO: В таблице "public"."refs" удалена запись {"id":600198,"ts":"2019-07-02T16:55:34.982067","id1":272660,"id2":600197}
INFO: В таблице "public"."refs" удалена запись {"id":600203,"ts":"2019-07-02T16:56:18.901364","id1":272660,"id2":600202}
INFO: В таблице "public"."refs" удалена запись {"id":610083,"ts":"2019-07-11T12:12:50.134771","id1":272660,"id2":610082}
INFO: В таблице "public"."refs" удалена запись {"id":623433,"ts":"2019-07-18T10:34:56.552323","id1":272660,"id2":623432}
INFO: В таблице "public"."refs" удалена запись {"id":623438,"ts":"2019-07-18T10:35:22.903341","id1":272660,"id2":623437}
INFO: В таблице "public"."refs" удалена запись {"id":623465,"ts":"2019-07-18T10:38:56.907283","id1":272660,"id2":623464}
INFO: В таблице "public"."refs" удалена запись {"id":625873,"ts":"2019-07-19T11:02:48.383391","id1":272660,"id2":625872}
INFO: В таблице "public"."refs" удалена запись {"id":625882,"ts":"2019-07-19T11:05:44.744532","id1":272660,"id2":625881}
INFO: В таблице "public"."refs" удалена запись {"id":631904,"ts":"2019-07-23T15:07:04.524753","id1":272660,"id2":631903}
INFO: В таблице "public"."refs" удалена запись {"id":658308,"ts":"2019-08-07T11:39:19.294202","id1":272660,"id2":658307}
INFO: В таблице "public"."refs" удалена запись {"id":673622,"ts":"2019-08-19T12:24:56.361511","id1":272660,"id2":673621}
INFO: В таблице "public"."refs" удалена запись {"id":673630,"ts":"2019-08-19T12:25:40.209846","id1":272660,"id2":673629}
INFO: В таблице "public"."refs" удалена запись {"id":673671,"ts":"2019-08-19T12:30:15.220694","id1":272660,"id2":673670}
INFO: В таблице "public"."refs" удалена запись {"id":673676,"ts":"2019-08-19T12:30:55.81871","id1":272660,"id2":673675}
INFO: В таблице "public"."refs" удалена запись {"id":673699,"ts":"2019-08-19T12:31:49.710368","id1":272660,"id2":673698}
INFO: В таблице "public"."refs" удалена запись {"id":673719,"ts":"2019-08-19T12:32:25.052055","id1":272660,"id2":673718}
INFO: В таблице "public"."refs" удалена запись {"id":680561,"ts":"2019-08-22T12:27:28.332852","id1":272660,"id2":680560}
INFO: В таблице "public"."refs" удалена запись {"id":680569,"ts":"2019-08-22T12:27:53.729227","id1":272660,"id2":680568}
INFO: В таблице "public"."refs" удалена запись {"id":702589,"ts":"2019-09-04T11:59:37.918958","id1":272660,"id2":702588}
INFO: В таблице "public"."refs" удалена запись {"id":730029,"ts":"2019-09-19T12:29:01.617234","id1":272660,"id2":730028}
INFO: В таблице "public"."refs" удалена запись {"id":730034,"ts":"2019-09-19T12:29:36.34546","id1":272660,"id2":730033}
INFO: В таблице "public"."refs" удалена запись {"id":730048,"ts":"2019-09-19T12:31:25.828999","id1":272660,"id2":730047}
INFO: В таблице "public"."refs" удалена запись {"id":730053,"ts":"2019-09-19T12:32:08.006269","id1":272660,"id2":730052}
INFO: В таблице "public"."refs" удалена запись {"id":753508,"ts":"2019-10-04T12:52:28.125738","id1":272660,"id2":753507}
INFO: В таблице "public"."refs" удалена запись {"id":786379,"ts":"2019-10-22T18:34:41.097799","id1":272660,"id2":786378}
INFO: В таблице "public"."refs" удалена запись {"id":786577,"ts":"2019-10-22T19:05:41.507946","id1":272660,"id2":786576}
INFO: В таблице "public"."refs" удалена запись {"id":786582,"ts":"2019-10-22T19:06:13.339322","id1":272660,"id2":786581}
INFO: В таблице "public"."refs" удалена запись {"id":795850,"ts":"2019-10-30T12:28:26.130215","id1":272660,"id2":795849}
INFO: В таблице "public"."refs" удалена запись {"id":796854,"ts":"2019-10-30T14:05:26.562805","id1":272660,"id2":796853}
INFO: В таблице "public"."refs" удалена запись {"id":812971,"ts":"2019-11-08T12:39:52.789134","id1":272660,"id2":812970}
INFO: В таблице "public"."refs" удалена запись {"id":823059,"ts":"2019-11-15T18:53:23.437978","id1":272660,"id2":823058}
INFO: В таблице "public"."refs" удалена запись {"id":832555,"ts":"2019-11-20T12:13:14.464255","id1":272660,"id2":832554}
INFO: В таблице "public"."refs" удалена запись {"id":832560,"ts":"2019-11-20T12:14:11.442753","id1":272660,"id2":832559}
INFO: В таблице "public"."refs" удалена запись {"id":832604,"ts":"2019-11-20T12:22:35.058974","id1":272660,"id2":832603}
INFO: В таблице "public"."refs" удалена запись {"id":832609,"ts":"2019-11-20T12:23:14.258715","id1":272660,"id2":832608}
INFO: В таблице "public"."refs" удалена запись {"id":837811,"ts":"2019-11-25T15:10:39.240085","id1":272660,"id2":837810}
INFO: В таблице "public"."refs" удалена запись {"id":876180,"ts":"2019-12-17T17:14:58.080364","id1":272660,"id2":876179}
INFO: В таблице "public"."refs" удалена запись {"id":880011,"ts":"2019-12-19T17:31:56.11542","id1":272660,"id2":880010}
INFO: В таблице "public"."refs" удалена запись {"id":888063,"ts":"2019-12-25T12:44:51.338277","id1":272660,"id2":888062}
INFO: В таблице "public"."refs" удалена запись {"id":888068,"ts":"2019-12-25T12:45:23.993274","id1":272660,"id2":888067}
INFO: В таблице "public"."refs" удалена запись {"id":888078,"ts":"2019-12-25T12:46:37.121803","id1":272660,"id2":888077}
INFO: В таблице "public"."refs" удалена запись {"id":888097,"ts":"2019-12-25T12:47:05.897246","id1":272660,"id2":888096}
INFO: В таблице "public"."refs" удалена запись {"id":887987,"ts":"2019-12-25T12:34:24.5673","id1":272660,"id2":887986}
INFO: В таблице "public"."refs" удалена запись {"id":888020,"ts":"2019-12-25T12:38:29.194979","id1":272660,"id2":888019}
INFO: В таблице "public"."refs" удалена запись {"id":889350,"ts":"2019-12-25T15:03:44.537095","id1":272660,"id2":889349}
INFO: В таблице "public"."refs" удалена запись {"id":910386,"ts":"2020-01-14T18:21:12.563293","id1":272660,"id2":910385}
INFO: В таблице "public"."refs" удалена запись {"id":935992,"ts":"2020-01-29T13:57:26.800545","id1":272660,"id2":935991}
INFO: В таблице "public"."refs" удалена запись {"id":936002,"ts":"2020-01-29T14:00:10.192286","id1":272660,"id2":936001}
INFO: В таблице "public"."refs" удалена запись {"id":936007,"ts":"2020-01-29T14:00:38.549967","id1":272660,"id2":936006}
INFO: В таблице "public"."refs" удалена запись {"id":968153,"ts":"2020-02-19T13:08:07.901155","id1":272660,"id2":968152}
INFO: В таблице "public"."refs" удалена запись {"id":979484,"ts":"2020-02-26T16:45:46.330022","id1":272660,"id2":979483}
INFO: В таблице "public"."refs" удалена запись {"id":979489,"ts":"2020-02-26T16:46:29.437968","id1":272660,"id2":979488}
INFO: В таблице "public"."refs" удалена запись {"id":1027429,"ts":"2020-03-20T14:23:14.347943","id1":272660,"id2":1027428}
INFO: В таблице "public"."refs" удалена запись {"id":1027434,"ts":"2020-03-20T14:23:42.846884","id1":272660,"id2":1027433}
INFO: В таблице "public"."refs" удалена запись {"id":354479,"ts":"2018-11-16T10:55:07.532001","id1":272660,"id2":354478}
INFO: В таблице "public"."refs" удалена запись {"id":357576,"ts":"2018-11-22T09:28:50.197832","id1":272660,"id2":357575}
INFO: В таблице "public"."refs" удалена запись {"id":357594,"ts":"2018-11-22T09:32:07.01016","id1":272660,"id2":357593}
INFO: В таблице "public"."refs" удалена запись {"id":357599,"ts":"2018-11-22T09:33:32.744449","id1":272660,"id2":357598}
INFO: В таблице "public"."refs" удалена запись {"id":378248,"ts":"2018-12-13T15:26:55.53645","id1":272660,"id2":378247}
INFO: В таблице "public"."refs" удалена запись {"id":378253,"ts":"2018-12-13T15:27:25.467758","id1":272660,"id2":378252}
INFO: В таблице "public"."refs" удалена запись {"id":378262,"ts":"2018-12-13T15:28:51.056967","id1":272660,"id2":378261}
INFO: В таблице "public"."refs" удалена запись {"id":378267,"ts":"2018-12-13T15:29:36.242835","id1":272660,"id2":378266}
INFO: В таблице "public"."refs" удалена запись {"id":413111,"ts":"2019-01-17T12:44:37.847297","id1":272660,"id2":413110}
INFO: В таблице "public"."refs" удалена запись {"id":413116,"ts":"2019-01-17T12:45:27.197667","id1":272660,"id2":413115}
INFO: В таблице "public"."refs" удалена запись {"id":413125,"ts":"2019-01-17T12:46:34.214175","id1":272660,"id2":413124}
INFO: В таблице "public"."refs" удалена запись {"id":413130,"ts":"2019-01-17T12:47:14.206186","id1":272660,"id2":413129}
INFO: В таблице "public"."refs" удалена запись {"id":1032321,"ts":"2020-04-16T12:03:22.416066","id1":1009623,"id2":272660}
Raw
электроэнергия.sql
sost=# select * from "удалить объект"('public', 'категории', 'refs', 272660, 1732);
insert into "категории"
select *
from json_to_recordset('[{"id":272660,"ts":"2018-08-27T17:14:28.688584","title":"электроэнергия","parent":3,"childs":[]}]') c("id" int, "ts" timestamp, "title" text, "parent" int, childs int[]);
insert into refs
select * from json_to_recordset('[{"id":441782,"ts":"2019-02-18T12:20:09.444477","id1":272660,"id2":441781}
, {"id":441815,"ts":"2019-02-18T12:23:17.482758","id1":272660,"id2":441814}
, {"id":441824,"ts":"2019-02-18T12:23:54.508557","id1":272660,"id2":441823}
, {"id":465254,"ts":"2019-03-14T12:41:12.104624","id1":272660,"id2":465253}
, {"id":465268,"ts":"2019-03-14T12:42:25.000011","id1":272660,"id2":465267}
, {"id":465317,"ts":"2019-03-14T12:47:11.20518","id1":272660,"id2":465316}
, {"id":465327,"ts":"2019-03-14T12:47:43.783847","id1":272660,"id2":465326}
, {"id":506377,"ts":"2019-04-17T11:28:54.068042","id1":272660,"id2":506376}
, {"id":506382,"ts":"2019-04-17T11:29:23.550628","id1":272660,"id2":506381}
, {"id":506391,"ts":"2019-04-17T11:30:45.673013","id1":272660,"id2":506390}
, {"id":506396,"ts":"2019-04-17T11:31:51.771033","id1":272660,"id2":506395}
, {"id":579837,"ts":"2019-06-19T19:03:36.417675","id1":272660,"id2":579836}
, {"id":579842,"ts":"2019-06-19T19:04:09.276074","id1":272660,"id2":579841}
, {"id":579856,"ts":"2019-06-19T19:06:18.249954","id1":272660,"id2":579855}
, {"id":579865,"ts":"2019-06-19T19:07:42.136317","id1":272660,"id2":579864}
, {"id":588214,"ts":"2019-06-26T12:55:30.66637","id1":272660,"id2":588213}
, {"id":600149,"ts":"2019-07-02T16:42:10.403901","id1":272660,"id2":600148}
, {"id":600198,"ts":"2019-07-02T16:55:34.982067","id1":272660,"id2":600197}
, {"id":600203,"ts":"2019-07-02T16:56:18.901364","id1":272660,"id2":600202}
, {"id":610083,"ts":"2019-07-11T12:12:50.134771","id1":272660,"id2":610082}
, {"id":623433,"ts":"2019-07-18T10:34:56.552323","id1":272660,"id2":623432}
, {"id":623438,"ts":"2019-07-18T10:35:22.903341","id1":272660,"id2":623437}
, {"id":623465,"ts":"2019-07-18T10:38:56.907283","id1":272660,"id2":623464}
, {"id":625873,"ts":"2019-07-19T11:02:48.383391","id1":272660,"id2":625872}
, {"id":625882,"ts":"2019-07-19T11:05:44.744532","id1":272660,"id2":625881}
, {"id":631904,"ts":"2019-07-23T15:07:04.524753","id1":272660,"id2":631903}
, {"id":658308,"ts":"2019-08-07T11:39:19.294202","id1":272660,"id2":658307}
, {"id":673622,"ts":"2019-08-19T12:24:56.361511","id1":272660,"id2":673621}
, {"id":673630,"ts":"2019-08-19T12:25:40.209846","id1":272660,"id2":673629}
, {"id":673671,"ts":"2019-08-19T12:30:15.220694","id1":272660,"id2":673670}
, {"id":673676,"ts":"2019-08-19T12:30:55.81871","id1":272660,"id2":673675}
, {"id":673699,"ts":"2019-08-19T12:31:49.710368","id1":272660,"id2":673698}
, {"id":673719,"ts":"2019-08-19T12:32:25.052055","id1":272660,"id2":673718}
, {"id":680561,"ts":"2019-08-22T12:27:28.332852","id1":272660,"id2":680560}
, {"id":680569,"ts":"2019-08-22T12:27:53.729227","id1":272660,"id2":680568}
, {"id":702589,"ts":"2019-09-04T11:59:37.918958","id1":272660,"id2":702588}
, {"id":730029,"ts":"2019-09-19T12:29:01.617234","id1":272660,"id2":730028}
, {"id":730034,"ts":"2019-09-19T12:29:36.34546","id1":272660,"id2":730033}
, {"id":730048,"ts":"2019-09-19T12:31:25.828999","id1":272660,"id2":730047}
, {"id":730053,"ts":"2019-09-19T12:32:08.006269","id1":272660,"id2":730052}
, {"id":753508,"ts":"2019-10-04T12:52:28.125738","id1":272660,"id2":753507}
, {"id":786379,"ts":"2019-10-22T18:34:41.097799","id1":272660,"id2":786378}
, {"id":786577,"ts":"2019-10-22T19:05:41.507946","id1":272660,"id2":786576}
, {"id":786582,"ts":"2019-10-22T19:06:13.339322","id1":272660,"id2":786581}
, {"id":795850,"ts":"2019-10-30T12:28:26.130215","id1":272660,"id2":795849}
, {"id":796854,"ts":"2019-10-30T14:05:26.562805","id1":272660,"id2":796853}
, {"id":812971,"ts":"2019-11-08T12:39:52.789134","id1":272660,"id2":812970}
, {"id":823059,"ts":"2019-11-15T18:53:23.437978","id1":272660,"id2":823058}
, {"id":832555,"ts":"2019-11-20T12:13:14.464255","id1":272660,"id2":832554}
, {"id":832560,"ts":"2019-11-20T12:14:11.442753","id1":272660,"id2":832559}
, {"id":832604,"ts":"2019-11-20T12:22:35.058974","id1":272660,"id2":832603}
, {"id":832609,"ts":"2019-11-20T12:23:14.258715","id1":272660,"id2":832608}
, {"id":837811,"ts":"2019-11-25T15:10:39.240085","id1":272660,"id2":837810}
, {"id":876180,"ts":"2019-12-17T17:14:58.080364","id1":272660,"id2":876179}
, {"id":880011,"ts":"2019-12-19T17:31:56.11542","id1":272660,"id2":880010}
, {"id":888063,"ts":"2019-12-25T12:44:51.338277","id1":272660,"id2":888062}
, {"id":888068,"ts":"2019-12-25T12:45:23.993274","id1":272660,"id2":888067}
, {"id":888078,"ts":"2019-12-25T12:46:37.121803","id1":272660,"id2":888077}
, {"id":888097,"ts":"2019-12-25T12:47:05.897246","id1":272660,"id2":888096}
, {"id":887987,"ts":"2019-12-25T12:34:24.5673","id1":272660,"id2":887986}
, {"id":888020,"ts":"2019-12-25T12:38:29.194979","id1":272660,"id2":888019}
, {"id":889350,"ts":"2019-12-25T15:03:44.537095","id1":272660,"id2":889349}
, {"id":910386,"ts":"2020-01-14T18:21:12.563293","id1":272660,"id2":910385}
, {"id":935992,"ts":"2020-01-29T13:57:26.800545","id1":272660,"id2":935991}
, {"id":936002,"ts":"2020-01-29T14:00:10.192286","id1":272660,"id2":936001}
, {"id":936007,"ts":"2020-01-29T14:00:38.549967","id1":272660,"id2":936006}
, {"id":968153,"ts":"2020-02-19T13:08:07.901155","id1":272660,"id2":968152}
, {"id":979484,"ts":"2020-02-26T16:45:46.330022","id1":272660,"id2":979483}
, {"id":979489,"ts":"2020-02-26T16:46:29.437968","id1":272660,"id2":979488}
, {"id":1027429,"ts":"2020-03-20T14:23:14.347943","id1":272660,"id2":1027428}
, {"id":1027434,"ts":"2020-03-20T14:23:42.846884","id1":272660,"id2":1027433}
, {"id":354479,"ts":"2018-11-16T10:55:07.532001","id1":272660,"id2":354478}
, {"id":357576,"ts":"2018-11-22T09:28:50.197832","id1":272660,"id2":357575}
, {"id":357594,"ts":"2018-11-22T09:32:07.01016","id1":272660,"id2":357593}
, {"id":357599,"ts":"2018-11-22T09:33:32.744449","id1":272660,"id2":357598}
, {"id":378248,"ts":"2018-12-13T15:26:55.53645","id1":272660,"id2":378247}
, {"id":378253,"ts":"2018-12-13T15:27:25.467758","id1":272660,"id2":378252}
, {"id":378262,"ts":"2018-12-13T15:28:51.056967","id1":272660,"id2":378261}
, {"id":378267,"ts":"2018-12-13T15:29:36.242835","id1":272660,"id2":378266}
, {"id":413111,"ts":"2019-01-17T12:44:37.847297","id1":272660,"id2":413110}
, {"id":413116,"ts":"2019-01-17T12:45:27.197667","id1":272660,"id2":413115}
, {"id":413125,"ts":"2019-01-17T12:46:34.214175","id1":272660,"id2":413124}
, {"id":413130,"ts":"2019-01-17T12:47:14.206186","id1":272660,"id2":413129}
]') r ("id" int, "ts" timestamp, "id1" int, "id2" int);
insert into refs
select * from json_to_recordset('[{"id":1032321,"ts":"2020-04-16T12:03:22.416066","id1":1009623,"id2":272660}]') r ("id" int, "ts" timestamp, "id1" int, "id2" int);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment