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
|
/*
*
* Copyright (c) 2010 ForgeRock Inc. All Rights Reserved
*
* The contents of this file are subject to the terms
* of the Common Development and Distribution License
* (the License). You may not use this file except in
* compliance with the License.
*
* You can obtain a copy of the License at
* http://www.opensource.org/licenses/cddl1.php or
* OpenIDM/legal/CDDLv1.0.txt
* See the License for the specific language governing
* permission and limitations under the License.
*
* When distributing Covered Code, include this CDDL
* Header Notice in each file and include the License file
* at OpenIDM/legal/CDDLv1.0.txt.
* If applicable, add the following below the CDDL Header,
* with the fields enclosed by brackets [] replaced by
* your own identifying information:
* "Portions Copyrighted 2010 [name of copyright owner]"
*
* $Id$
*/
import groovy.sql.Sql
import groovy.sql.DataSet
import org.forgerock.openicf.misc.scriptedcommon.OperationType
// Parameters:
// The connector sends the following:
// connection: handler to the SQL connection
// objectClass: a String describing the Object class (__ACCOUNT__ / __GROUP__ / other)
// log: a handler to the Log facility
// options: a handler to the OperationOptions Map (null if operation = "GET_LATEST_SYNC_TOKEN")
// token: a handler to an Object representing the sync token (null if operation = "GET_LATEST_SYNC_TOKEN")
//
//
// Returns:
// if operation = "GET_LATEST_SYNC_TOKEN", it must return an object representing the last known
// sync token for the corresponding ObjectClass
//
// if operation = "SYNC":
// A list of Maps . Each map describing one update:
// Map should look like the following:
//
// [
// "token": <Object> token object (could be Integer, Date, String) , [!! could be null]
// "operation":<String> ("CREATE_OR_UPDATE"|"DELETE"),
// "uid":<String> uid (uid of the entry) ,
// "previousUid":<String> prevuid (This is for rename ops) ,
// "password":<String> password (optional... allows to pass clear text password if needed),
// "attributes":Map<String,List> of attributes name/values
// ]
def sql = new Sql(connection)
def operation = operation as OperationType
switch ( objectClass ) {
case "schema_defs":
if (operation.equalsIgnoreCase(OperationType.GET_LATEST_SYNC_TOKEN)) {
row = sql.firstRow("""
SELECT
to_char(max(last_used), 'YYYY-MM-DD HH24:MI:SS.MS') as latest_used
FROM
schema_defs
""")
//println ("Sync token found: " + row["latest_used"])
return row["latest_used"]
} else if (operation.equalsIgnoreCase(OperationType.SYNC)) {
def result = []
sql.eachRow("""
SELECT
s.id,
s.db_type_id,
s.short_code,
to_char(s.last_used, 'YYYY-MM-DD HH24:MI:SS.MS') as last_used,
floor(EXTRACT(EPOCH FROM age(current_timestamp, last_used))/60) as minutes_since_last_used,
s.ddl,
s.statement_separator
FROM
schema_defs s
WHERE
last_used > ?
""", [Date.parse("yyyy-MM-dd HH:mm:ss.S", token).toTimestamp()]) {
//println ("Found record: " + it.db_type_id + '_' + it.short_code)
result.add([
operation: "CREATE_OR_UPDATE",
uid: it.db_type_id + '_' + it.short_code,
token: it.last_used,
attributes: [
schema_def_id:it.id.toInteger(),
db_type_id:it.db_type_id.toInteger(),
fragment: it.db_type_id + '_' + it.short_code,
ddl: it.ddl,
last_used:it.last_used,
minutes_since_last_used:it.minutes_since_last_used != null ? it.minutes_since_last_used.toInteger(): null,
short_code:it.short_code,
statement_separator:it.statement_separator
]
])
}
println result
return result
} else { // operation not implemented
log.error("Sync script: operation '"+operation+"' is not implemented in this script")
return null;
}
break
default:
return null
}
sql.close()
|
