-- Загрузка только с правами postgres

CREATE TEMP TABLE t_fc2f6

(

"EntityId" uuid

);

copy t_fc2f617d3c2a48c5a02fe12d6d89bfae from '/home/alexandr/remCY.csv';

insert into rtneo_entityes_temporary_set (id, entity_id, entity_name, set_name, version, create_ts)

(select newid(), t."EntityId", 'Contragent', 'contragentFromFile', 1, now() from t_fc2f617d3c2a48c5a02fe12d6d89bfae t);

CREATE TEMP TABLE t_fc2f617d3c2a48c5a02fe12d6d89bfae

(

"cad" varchar(50),

"code" varchar(50)

);

copy t_fc2f617d3c2a48c5a02fe12d6d89bfae from '/home/rtneo/rtneo/data/realEstateCode.csv' (delimiter ',');

update

rtneo_contragent_real_estate as cre

set

type_id = case rec.code when '204001000000' then 'a1122505-7e60-19f0-be56-5ec549ab80c8'::uuid when '206001000000' then 'a633833e-83bc-52b1-0aef-9898739f434f'::uuid end

from rtneo_real_estate rre

join t_fc2f617d3c2a48c5a02fe12d6d89bfae rec on rec.cad = rre.cadastral_number

where cre.real_estate_id = rre.id