{"type":"doc","content":[{"type":"paragraph","content":[{"text":"In the example ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cohgawiki.atlassian.net/wiki/spaces/WUG/pages/2698086768"}},{"text":" we saw how to write edits on a database view to its underlying table. ","type":"text"}]},{"type":"paragraph","content":[{"text":"In a similar mode it's possible to attach an ","type":"text"},{"text":"audit","type":"text","marks":[{"type":"code"}]},{"text":" edit configuration item to an existing ","type":"text"},{"text":"edit","type":"text","marks":[{"type":"code"}]},{"text":" configuration item and have write attribute values from the parent edit configuration table, and additional computed values, written to an associated (audit) table.","type":"text"}]},{"type":"paragraph","content":[{"text":"See the ","type":"text"},{"text":"public.graffiti ","type":"text","marks":[{"type":"strong"}]},{"text":"table is defined in ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://cohgawiki.atlassian.net/wiki/spaces/WUG/pages/2698084393"}},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"A new table, ","type":"text"},{"text":"public.graffiti_audit","type":"text","marks":[{"type":"code"}]},{"text":" is defined as follows:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"DROP TABLE IF EXISTS public.graffiti_audit;\n\nCREATE TABLE public.graffiti_audit (\n ID serial not null primary key,\n GRAFFITIID int, -- foreign key to graffiti table's id column\n DESCRIPTION text,\n STATUS varchar(100),\n FIELDVERIFIED varchar(5),\n REPORTEDBY varchar(100),\n REPORTEDON timestamp,\n CREATEDBY varchar(100),\n CREATEDON timestamp,\n MODIFIEDBY varchar(100),\n MODIFIEDON timestamp,\n GEOM text -- at the moment this is text, not actual Geometry, in WKT format\n);","type":"text"}]},{"type":"paragraph","content":[{"text":"An edit configuration for the base ","type":"text"},{"text":"public","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"},{"text":"graffiti","type":"text","marks":[{"type":"code"}]},{"text":"table is as follows.","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n graffiti\n Grafitti (Audit Table)\n Report graffiti for removal\n \n \n \n ","type":"text"}]},{"type":"paragraph","content":[{"text":"The following ","type":"text"},{"text":"edit:audit","type":"text","marks":[{"type":"code"}]},{"text":" edit configuration implements auditing of the ","type":"text"},{"text":"public.graffiti","type":"text","marks":[{"type":"code"}]},{"text":" table which enables the writing of values to the ","type":"text"},{"text":"public.graffiti_audit","type":"text","marks":[{"type":"code"}]},{"text":" table. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The configuration requires that the ","type":"text"},{"text":"table","type":"text","marks":[{"type":"code"}]},{"text":" and the ","type":"text"},{"text":"datasource","type":"text","marks":[{"type":"code"}]},{"text":"where it is located be defined. ","type":"text"}]},{"type":"paragraph","content":[{"text":"An optional list of parameters that correspond to the columns in that table can also be defined. ","type":"text"}]},{"type":"paragraph","content":[{"text":"The parameter columns can derive their values either from the values entered by the user as a parameter in the original ","type":"text"},{"text":"audit.edit","type":"text","marks":[{"type":"code"}]},{"text":" configuration, or as a formula using a ","type":"text"},{"text":"value","type":"text","marks":[{"type":"code"}]},{"text":" tag or as a hard coded value.","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"mode","type":"text","marks":[{"type":"code"}]},{"text":" tag describes which actions cause an audit record to be created. The ","type":"text"},{"text":"mode","type":"text","marks":[{"type":"code"}]},{"text":"tag is specified as a comma separated list containing up to three possible values ","type":"text"},{"text":"create","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"update ","type":"text","marks":[{"type":"strong"}]},{"text":"or ","type":"text"},{"text":"delete","type":"text","marks":[{"type":"strong"}]},{"text":". If mode was set as follows,","type":"text"},{"text":"create","type":"text","marks":[{"type":"code"}]},{"text":", an audit record would only be written when a new entity is created. The default, if not specified, is ","type":"text"},{"text":"create,update,delete.","type":"text","marks":[{"type":"code"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n create,update,delete \n audit.edit\n ds.postgresql\n public.graffiti_audit

\n\t\n \n \n \t\n \n \n \n \n \n","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Parameters in ","type":"text"},{"text":"edit","type":"text","marks":[{"type":"code"}]},{"text":" configurations can be setup with or without a ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]},{"text":" attribute. If there is a ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]},{"text":" specified then the value will be written to the corresponding column in the underlying spatial table, if there is no ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]},{"text":" specified then no value will be written during this phase. However, the value the user enters for the parameter, in both cases, is available to be written as part of an ","type":"text"},{"text":"audit","type":"text","marks":[{"type":"code"}]},{"text":" configuration.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Creating a new point record in the ","type":"text"},{"text":"public.graffiti ","type":"text","marks":[{"type":"strong"}]},{"text":"table when selecting the ","type":"text"},{"text":"audit.edit","type":"text","marks":[{"type":"code"}]},{"text":" configuration is as follows:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1142,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1292,"id":"323855d2-02ce-4e10-82dc-5749eb61a4c9","collection":"contentId-2698086999","type":"file","height":784}},{"type":"caption","content":[{"text":"New Graffiti Point Near a Tree","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The following records are written to the database.","type":"text"}]},{"type":"paragraph","content":[{"text":"Graffiti Table","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1142,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":2018,"id":"f71699da-f61d-47aa-a93f-23726e9c951a","collection":"contentId-2698086999","type":"file","height":490}},{"type":"caption","content":[{"text":"Graffiti ","type":"text","marks":[{"type":"strong"}]},{"text":"Table Record","type":"text"}]}]},{"type":"paragraph","content":[{"text":"Graffiti Audit Table","type":"text","marks":[{"type":"strong"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1142,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":2033,"id":"10acfa4b-88ea-4c5f-a6a7-ad9a4da6204d","collection":"contentId-2698086999","type":"file","height":488}}]},{"type":"paragraph","content":[{"text":"Note that the ","type":"text"},{"text":"graffitiid","type":"text","marks":[{"type":"strong"}]},{"text":" column value is the same as the ","type":"text"},{"text":"id","type":"text","marks":[{"type":"strong"}]},{"text":" value in the base ","type":"text"},{"text":"graffiti","type":"text","marks":[{"type":"strong"}]},{"text":" table.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Currently only writing new records to the audit table is supported: existing audit records cannot be updated. ","type":"text"}]},{"type":"paragraph","content":[{"text":"However, if you edit an existing base table record, as in the following example where ","type":"text"},{"text":"Fred Flintstone","type":"text","marks":[{"type":"strong"}]},{"text":" is changed to ","type":"text"},{"text":"Wilma Flintstone","type":"text","marks":[{"type":"strong"}]},{"text":", a new audit record is written.","type":"text"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":515,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":515,"id":"323855d2-02ce-4e10-82dc-5749eb61a4c9","collection":"contentId-2698086999","type":"file","height":315}},{"type":"caption","content":[{"text":"Update Existing Record","type":"text"}]}]},{"type":"paragraph","content":[{"text":"A new record is written to the ","type":"text"},{"text":"public.graffiti_audit ","type":"text","marks":[{"type":"strong"}]},{"text":"table:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":1142,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":2033,"id":"10acfa4b-88ea-4c5f-a6a7-ad9a4da6204d","collection":"contentId-2698086999","type":"file","height":488}},{"type":"caption","content":[{"text":"Audit Table Recording Wilma Flintstone Change","type":"text"}]}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"57af8b8e-d628-4b94-b7e9-0aeaf4d35bb8"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"<< Previous","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/WUG/pages/2698086768"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"text":"Next >>","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/WUG/pages/2698087082"}}]}]}]}]}]}],"version":1}

Browser not supported