vdY9xd3a

1Migration V2020_07_22_10__BUILD_TRACKER_migrate_exist_quality_inspections_item.sql failed
2-----------------------------------------------------------------------------------------
3SQL State  : 42P01
4Error Code : 0
5Message    : ERROR: relation "build_tracker_daily_progress_acceptance2quality_inspection_item" does not exist
6  Где: SQL statement "CREATE TABLE IF NOT EXISTS build_tracker_daily_progress_accept2qual_insp_items
7    (
8      id_accept2qual int not null
9        constraint build_tracker_daily_progress_acceptance2quality_inspection_item_id_fk
10          references build_tracker_daily_progress_acceptance2quality_inspection_item
11             on update cascade on delete cascade DEFERRABLE INITIALLY DEFERRED,
12      id_qu_insp_item int not null
13        constraint quality_inspection_item_id_fk
14          references quality_inspection_item
15             on update cascade on delete cascade DEFERRABLE INITIALLY DEFERRED,
16      constraint build_tracker_daily_progress_accept2qual_insp_items_pk
17      primary key (id_accept2qual, id_qu_insp_item)
18    )"
19PL/pgSQL function inline_code_block line 9 at SQL statement
20Location   : geo/model/build_tracker/db_migration/V2020_07_22_10__BUILD_TRACKER_migrate_exist_quality_inspections_item.sql (/opt/apache-tomcat/webapps/ROOT/WEB-INF/classes/geo/model/build_tracker/db_migration/V2020_07_22_10__BUILD_TRACKER_migrate_exist_quality_inspection
21s_item.sql)
22Line       : 1
23Statement  : DO $$
24  DECLARE
25        -- Одна строка из таблицы контрактов
26        contr RECORD;
27        -- Одна строка из таблицы статуса приемки спула к пунктам ПКК
28        accept RECORD;
29  BEGIN
30    -- Создание таблицы для хранения связи многие ко многим отношение статуса приемки спула к пунктам ПКК
31    CREATE TABLE IF NOT EXISTS build_tracker_daily_progress_accept2qual_insp_items
32    (
33      id_accept2qual int not null
34        constraint build_tracker_daily_progress_acceptance2quality_inspection_item_id_fk
35          references build_tracker_daily_progress_acceptance2quality_inspection_item
36             on update cascade on delete cascade DEFERRABLE INITIALLY DEFERRED,
37      id_qu_insp_item int not null
38        constraint quality_inspection_item_id_fk
39          references quality_inspection_item
40             on update cascade on delete cascade DEFERRABLE INITIALLY DEFERRED,
41      constraint build_tracker_daily_progress_accept2qual_insp_items_pk
42      primary key (id_accept2qual, id_qu_insp_item)
43    );
44    -- Цикл по контрактам
45    FOR contr IN SELECT id FROM build_tracker_control_control_contract
46    LOOP
47      -- Цикл по записям отношении статуса приемки спула к пунктам ПКК на данном контракте
48      FOR accept IN
49            SELECT build_tracker_daily_progress_acceptance2quality_inspection_item.id AS id,
50                   build_tracker_daily_progress_acceptance2quality_inspection_item.quality_inspection_item AS quality_inspection_item
51                FROM build_tracker_daily_progress_acceptance2quality_inspection_item
52                WHERE build_tracker_daily_progress_acceptance2quality_inspection_item.contract = contr.id
53      LOOP
54        -- Создание строк в новой таблицы, где теперь храниться связь многие ко многим
55        INSERT INTO build_tracker_daily_progress_accept2qual_insp_items (id_accept2qual, id_qu_insp_item) VALUES (accept.id, accept.quality_inspection_item) ON CONFLICT DO NOTHING;
56
57      END LOOP;
58
59    END LOOP;
60  END
61$$
62
63