1Workflow::Persister::DBUIs:e:rExCtornatDraitbau(t3e)d PeWrolrkDfolcouwm:e:nPteartsiiosnter::DBI::ExtraData(3)
2
6 Workflow::Persister::DBI::ExtraData - Fetch extra data with each
7 workflow and put it into the context
8
10 This documentation describes version 1.61 of this package
11
13 <persister name="MyPersister"
14 class="Workflow::Persister::DBI::ExtraData"
15 dsn="DBI:mysql:database=workflows"
16 user="wf"
17 password="mypass"
18 extra_table="workflow_ticket"
19 extra_data_field="ticket_id"
20 extra_context_key="ticket_id"/>
21
23 Overview
24 Simple subclass of Workflow::Persister::DBI to allow you to declare an
25 extra table and data field(s) from which to fetch data whenever you
26 fetch a workflow. There is a simple restriction: the table must have a
27 field 'workflow_id' of the same datatype as the 'workflow_id' field in
28 the 'workflow' table.
29 Examples
31 # Specify a single field 'ticket_id' from the table 'workflow_ticket'
32 # and store it in the context using the same key:
33 <persister
35 ...
36 extra_table="workflow_ticket"
37 extra_data_field="ticket_id"
38 ...
39 # How you would use this:
41 my $wf = FACTORY->fetch_workflow( 'Ticket', 55 );
42 print "Workflow is associated with ticket: ",
43 $wf->context->param( 'ticket_id' );
44 # Specify a single field 'ticket_id' from the table 'workflow_ticket'
46 # and store it in the context using a different key
47 <persister
49 ...
50 extra_table="workflow_ticket"
51 extra_data_field="ticket_id"
52 extra_context_key="THE_TICKET_ID"
53 ...
54 # How you would use this:
56 my $wf = FACTORY->fetch_workflow( 'Ticket', 55 );
57 print "Workflow is associated with ticket: ",
58 $wf->context->param( 'THE_TICKET_ID' );
59 # Specify multiple fields ('ticket_id', 'last_viewer',
61 # 'last_view_date') to pull from the 'workflow_ticket' table:
62 <persister
64 ...
65 extra_table="workflow_ticket"
66 extra_data_field="ticket_id,last_viewer,last_view_date"
67 ...
68 # How you would use this:
70 my $wf = FACTORY->fetch_workflow( 'Ticket', 55 );
71 print "Workflow is associated with ticket: ",
72 $wf->context->param( 'ticket_id' ), " ",
73 "which was last viewed by ",
74 $wf->context->param( 'last_viewer' ), " on ",
75 $wf->context->param( 'last_view_date' );
76 Configuration
78 extra_table (required)
79 Table where the extra data are kept.
81 extra_data_field (required)
83 Can be a single field or a comma-separated list of fields, all in the
85 same table. If a single field specified you have the option of
86 declaring a different "extra_context_key" under which the value should
87 be stored in the workflow context. Otherwise the values are stored by
88 the field names in the workflow context.
89 extra_context_key (optional)
91 Key under which to save the data from "extra_data_field" in the
93 workflow context.
94 Note: this is ignored when you specify multiple fields in
96 "extra_data_field"; we just use the fieldnames for the context keys in
97 that case. And if you specify a single data field and do not specify a
98 context key we also use the data field name.
99 METHODS
101 init ( \%params )
102 Initializes persister for extra workflow data.
104 Throws Workflow::Exception if initialization is not successful.
106 fetch_extra_workflow_data ( $wf )
108 Fetches extra data from database and feeds this to context of given
110 workflow.
111 Takes a single parameter, a workflow object to which extra data are
113 feed if retrieved successfully.
114 Throws Workflow::Exception if retrieval is not successful.
116
118 Copyright (c) 2003-2022 Chris Winters. All rights reserved.
119 This library is free software; you can redistribute it and/or modify it
121 under the same terms as Perl itself.
122 Please see the LICENSE
124
126 Please see Workflow
127perl v5.36.0 2023-01W-o2r0kflow::Persister::DBI::ExtraData(3)