1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
|
#
# Default PIP Configuration from Policy.
#
xacml.pip.engines=AAF,sql1
### AAF PIP Configuration.
AAF.description=AAFEngine to communicate with AAF to take decisions
AAF.classname=org.openecomp.policy.xacml.std.pip.engines.aaf.AAFEngine
AAF.name=AAFEngine
### sql1 PIP Configuration.
# Class from XACML resource.
sql1.classname=com.att.research.xacml.std.pip.engines.jdbc.JDBCEngine
sql1.name=OperationsHistory
sql1.description=Database of operations performed via closed loop.
sql1.issuer=org:openecomp:xacml:sql123
sql1.type=jdbc
sql1.jdbc.driver=com.mysql.jdbc.Driver
sql1.jdbc.url=jdbc:mysql://localhost:3306/policy
sql1.jdbc.conn.user=root
sql1.jdbc.conn.password=password
#Each of the following resolvers corresponds to a specific time window. The only difference between them is the "interval" in the "select" SQL query and the "issuer".
sql1.resolvers=tw5min,tw10min,tw30min,tw1h,tw12h,tw1d,tw5d,tw1w,tw1mon
##############################################
sql1.resolver.tw5min.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 5 minute) and now()
sql1.resolver.tw5min.field.count.issuer=org:openecomp:xacml:sql:tw5min
sql1.resolver.tw5min.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw5min.name=OperationsCount
sql1.resolver.tw5min.description=This returns the number of previous operations within the given time window
sql1.resolver.tw5min.fields=count
sql1.resolver.tw5min.field.count.id=count
sql1.resolver.tw5min.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw5min.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5min.parameters=actor,operation,target
sql1.resolver.tw5min.parameter.actor.id=actor
sql1.resolver.tw5min.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5min.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5min.parameter.operation.id=recipe
sql1.resolver.tw5min.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5min.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5min.parameter.target.id=target
sql1.resolver.tw5min.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5min.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
##############################################
sql1.resolver.tw10min.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 10 minute) and now()
sql1.resolver.tw10min.field.count.issuer=org:openecomp:xacml:sql:tw10min
sql1.resolver.tw10min.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw10min.name=OperationsCount
sql1.resolver.tw10min.description=This returns the number of previous operations within the given time window
sql1.resolver.tw10min.fields=count
sql1.resolver.tw10min.field.count.id=count
sql1.resolver.tw10min.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw10min.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw10min.parameters=actor,operation,target
sql1.resolver.tw10min.parameter.actor.id=actor
sql1.resolver.tw10min.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw10min.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw10min.parameter.operation.id=recipe
sql1.resolver.tw10min.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw10min.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw10min.parameter.target.id=target
sql1.resolver.tw10min.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw10min.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
##############################################
sql1.resolver.tw30min.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 30 minute) and now()
sql1.resolver.tw30min.field.count.issuer=org:openecomp:xacml:sql:tw30min
sql1.resolver.tw30min.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw30min.name=OperationsCount
sql1.resolver.tw30min.description=This returns the number of previous operations within the given time window
sql1.resolver.tw30min.fields=count
sql1.resolver.tw30min.field.count.id=count
sql1.resolver.tw30min.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw30min.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw30min.parameters=actor,operation,target
sql1.resolver.tw30min.parameter.actor.id=actor
sql1.resolver.tw30min.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw30min.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw30min.parameter.operation.id=recipe
sql1.resolver.tw30min.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw30min.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw30min.parameter.target.id=target
sql1.resolver.tw30min.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw30min.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
##############################################
sql1.resolver.tw1h.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 1 hour) and now()
sql1.resolver.tw1h.field.count.issuer=org:openecomp:xacml:sql:tw1h
sql1.resolver.tw1h.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw1h.name=OperationsCount
sql1.resolver.tw1h.description=This returns the number of previous operations within the given time window
sql1.resolver.tw1h.fields=count
sql1.resolver.tw1h.field.count.id=count
sql1.resolver.tw1h.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw1h.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1h.parameters=actor,operation,target
sql1.resolver.tw1h.parameter.actor.id=actor
sql1.resolver.tw1h.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1h.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1h.parameter.operation.id=recipe
sql1.resolver.tw1h.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1h.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1h.parameter.target.id=target
sql1.resolver.tw1h.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1h.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
##############################################
sql1.resolver.tw12h.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 12 hour) and now()
sql1.resolver.tw12h.field.count.issuer=org:openecomp:xacml:sql:tw12h
sql1.resolver.tw12h.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw12h.name=OperationsCount
sql1.resolver.tw12h.description=This returns the number of previous operations within the given time window
sql1.resolver.tw12h.fields=count
sql1.resolver.tw12h.field.count.id=count
sql1.resolver.tw12h.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw12h.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw12h.parameters=actor,operation,target
sql1.resolver.tw12h.parameter.actor.id=actor
sql1.resolver.tw12h.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw12h.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw12h.parameter.operation.id=recipe
sql1.resolver.tw12h.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw12h.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw12h.parameter.target.id=target
sql1.resolver.tw12h.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw12h.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
#############################
sql1.resolver.tw1d.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 1 day) and now()
sql1.resolver.tw1d.field.count.issuer=org:openecomp:xacml:sql:tw1d
sql1.resolver.tw1d.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw1d.name=OperationsCount
sql1.resolver.tw1d.description=This returns the number of previous operations within the given time window
sql1.resolver.tw1d.fields=count
sql1.resolver.tw1d.field.count.id=count
sql1.resolver.tw1d.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw1d.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1d.parameters=actor,operation,target
sql1.resolver.tw1d.parameter.actor.id=actor
sql1.resolver.tw1d.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1d.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1d.parameter.operation.id=recipe
sql1.resolver.tw1d.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1d.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1d.parameter.target.id=target
sql1.resolver.tw1d.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1d.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
#############################
sql1.resolver.tw5d.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 5 day) and now()
sql1.resolver.tw5d.field.count.issuer=org:openecomp:xacml:sql:tw5d
sql1.resolver.tw5d.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw5d.name=OperationsCount
sql1.resolver.tw5d.description=This returns the number of previous operations within the given time window
sql1.resolver.tw5d.fields=count
sql1.resolver.tw5d.field.count.id=count
sql1.resolver.tw5d.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw5d.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5d.parameters=actor,operation,target
sql1.resolver.tw5d.parameter.actor.id=actor
sql1.resolver.tw5d.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5d.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5d.parameter.operation.id=recipe
sql1.resolver.tw5d.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5d.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw5d.parameter.target.id=target
sql1.resolver.tw5d.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw5d.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
#############################
sql1.resolver.tw1w.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 1 week) and now()
sql1.resolver.tw1w.field.count.issuer=org:openecomp:xacml:sql:tw1w
sql1.resolver.tw1w.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw1w.name=OperationsCount
sql1.resolver.tw1w.description=This returns the number of previous operations within the given time window
sql1.resolver.tw1w.fields=count
sql1.resolver.tw1w.field.count.id=count
sql1.resolver.tw1w.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw1w.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1w.parameters=actor,operation,target
sql1.resolver.tw1w.parameter.actor.id=actor
sql1.resolver.tw1w.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1w.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1w.parameter.operation.id=recipe
sql1.resolver.tw1w.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1w.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1w.parameter.target.id=target
sql1.resolver.tw1w.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1w.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
#############################
sql1.resolver.tw1mon.select=select count(*) as count from operationshistory10 where outcome<>'Failure_Guard' and actor=? and operation=? and target=? and endtime between date_sub(now(),interval 1 month) and now()
sql1.resolver.tw1mon.field.count.issuer=org:openecomp:xacml:sql:tw1mon
sql1.resolver.tw1mon.classname=com.att.research.xacml.std.pip.engines.jdbc.ConfigurableJDBCResolver
sql1.resolver.tw1mon.name=OperationsCount
sql1.resolver.tw1mon.description=This returns the number of previous operations within the given time window
sql1.resolver.tw1mon.fields=count
sql1.resolver.tw1mon.field.count.id=count
sql1.resolver.tw1mon.field.count.datatype=http://www.w3.org/2001/XMLSchema#integer
sql1.resolver.tw1mon.field.count.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1mon.parameters=actor,operation,target
sql1.resolver.tw1mon.parameter.actor.id=actor
sql1.resolver.tw1mon.parameter.actor.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1mon.parameter.actor.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1mon.parameter.operation.id=recipe
sql1.resolver.tw1mon.parameter.operation.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1mon.parameter.operation.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
sql1.resolver.tw1mon.parameter.target.id=target
sql1.resolver.tw1mon.parameter.target.datatype=http://www.w3.org/2001/XMLSchema#string
sql1.resolver.tw1mon.parameter.target.category=urn:oasis:names:tc:xacml:3.0:attribute-category:resource
|
