vdb

<vdb name="_GENERATED_form_pricetest" version="2"><import-vdb name="_INTERNAL_internal" version="1"/><model name="GEN_view" type="VIRTUAL"><metadata type="DDL"><![CDATA[ CREATE VIEW "_view_workflow_data" ("price" BIGDECIMAL, "id" INTEGER, "address" VARCHAR, "text" VARCHAR, PRIMARY KEY ("id")) OPTIONS (UPDATABLE 'true') AS SELECT "form"."form_pricetest_2"."price" AS "price", "form"."form_pricetest_2"."id" AS "id", "form"."form_pricetest_2"."address" AS "address", "form"."form_pricetest_2"."text" AS "text" FROM "form"."form_pricetest_2";

CREATE VIEW "_view_workflow_data_claims" ("price" BIGDECIMAL, "id" INTEGER, "address" VARCHAR, "text" VARCHAR, "__reserved__claim" STRING, PRIMARY KEY ("id")) OPTIONS (UPDATABLE 'true') AS SELECT "_view_workflow_data"."price" AS "price", "_view_workflow_data"."id" AS "id", "_view_workflow_data"."address" AS "address", "_view_workflow_data"."text" AS "text", "form"."form_pricetest_claims_latest"."claim" AS "__reserved__claim" FROM "_view_workflow_data", "form"."form_pricetest_claims_latest" WHERE "_view_workflow_data"."id" = "form"."form_pricetest_claims_latest"."id";

CREATE TRIGGER ON "_view_workflow_data_claims" INSTEAD OF UPDATE AS
FOR EACH ROW
BEGIN ATOMIC

    IF (CHANGING.price)
    BEGIN
        UPDATE "_view_workflow_data" SET "price" = NEW.price WHERE  "id" = OLD.id ;
    END
    IF (CHANGING.id)
    BEGIN
        UPDATE "_view_workflow_data" SET "id" = NEW.id WHERE  "id" = OLD.id ;
    END
    IF (CHANGING.address)
    BEGIN
        UPDATE "_view_workflow_data" SET "address" = NEW.address WHERE  "id" = OLD.id ;
    END
    IF (CHANGING.text)
    BEGIN
        UPDATE "_view_workflow_data" SET "text" = NEW.text WHERE  "id" = OLD.id ;
    END
END;

CREATE TRIGGER ON "_view_workflow_data_claims" INSTEAD OF DELETE AS
FOR EACH ROW
BEGIN ATOMIC

    DELETE FROM "_view_workflow_data" WHERE  "id" = OLD.id ;
    DELETE FROM "form"."form_pricetest_claims_latest" WHERE  "id" = OLD.id ;
END; ]]></metadata></model></vdb>