AS tenant_id, CONCAT('"', t.id, '"') AS old_id, CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at, CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at, sys.CSVSTR(t.country_number) AS country_number, sys.CSVSTR(t.zip_code) AS zip_code, sys.CSVSTR(t.pref) AS pref, sys.CSVSTR(t.city) AS city, sys.CSVSTR(t.street) AS street, sys.CSVSTR(t.building) AS building, sys.CSVSTR(t.literal_yomi) AS literal_yomi FROM <%= dbname %>.addresses AS t ORDER BY t.id ASC;
BIGINT, tenant_id TEXT) RETURNS TEXT CHARSET utf8mb4 DETERMINISTIC BEGIN SET @sha2 = SHA2(CONCAT('table_name:',table_name,'::id:',id,'::tenant_id:',tenant_id), 512); SET @uuid = CONCAT( SUBSTR(@sha2 from 10 for 8), '-', SUBSTR(@sha2 from 18 for 4), '-4', SUBSTR(@sha2 from 22 for 3), '-', LOWER(CONV(CONV(SUBSTR(@sha2 from 26 for 1), 16, 10) & 3 | 8, 10, 16)), SUBSTR(@sha2 from 27 for 3), '-', SUBSTR(@sha2 from 40 for 12) ); RETURN @uuid; END; // DELIMITER ;
AS tenant_id, CONCAT('"', t.id, '"') AS old_id, CONCAT('"', DATE_FORMAT(t.created_at, '%Y-%m-%d %T'), '"') AS created_at, CONCAT('"', DATE_FORMAT(t.updated_at, '%Y-%m-%d %T'), '"') AS updated_at, COALESCE(s.uuid, sys.GHOSTUUID('Payslip', t.payslip_id, '<%= tenant_id %>')) AS payslip_id, sys.CSVSTR(t.name) AS name, t.amount AS amount FROM <%= dbname %>.deductions AS t LEFT OUTER JOIN <%= dbname %>.payslips AS s ON t.payslip_id = s.id ORDER BY t.id ASC ;