UpdateScript.groovy revision a4bf32dcbc74d4ad01c20d0e9b89ceeeed86fd1a
/*
* 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 legal/CDDLv1.0.txt. See the License for the
* specific language governing permission and limitations under the License.
*
* When distributing Covered Software, include this CDDL Header Notice in each file and include
* the License file at 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 copyright [year] [name of copyright owner]".
*
* Copyright 2015 ForgeRock AS.
*/
package org.forgerock.openicf.connectors.hrdb
import groovy.sql.Sql
import org.forgerock.openicf.connectors.hrdb.HRDBConfiguration
import org.forgerock.openicf.misc.scriptedcommon.OperationType
import org.identityconnectors.common.logging.Log
import org.identityconnectors.framework.common.objects.ObjectClass
import org.identityconnectors.framework.common.objects.Uid
import org.identityconnectors.framework.common.exceptions.ConnectorException
import org.identityconnectors.framework.common.objects.Attribute
import org.identityconnectors.framework.common.objects.AttributesAccessor
import org.identityconnectors.framework.common.objects.ObjectClass
import org.identityconnectors.framework.common.objects.OperationOptions
import java.sql.Connection
/**
* Built-in accessible objects
**/
// OperationType is UPDATE for this script
def operation = operation as OperationType
// The configuration class created specifically for this connector
def configuration = configuration as HRDBConfiguration
// Default logging facility
def log = log as Log
// Set of attributes describing the object to be updated
def updateAttributes = new AttributesAccessor(attributes as Set<Attribute>)
// The Uid of the object to be updated
def uid = id as String
// The objectClass of the object to be updated, e.g. ACCOUNT or GROUP
def objectClass = objectClass as ObjectClass
/**
* Script action - Customizable
*
* Update an object in the external source. Connectors that do not support this should
* throw an UnsupportedOperationException.
*
* This script should return the Uid of the updated object
**/
/* Log something to demonstrate this script executed */
log.info("Create script, operation = " + operation.toString());
def connection = connection as Connection
def sql = new Sql(connection);
def ORG = new ObjectClass("organization")
switch (operation) {
case OperationType.UPDATE:
switch (objectClass) {
case ObjectClass.ACCOUNT:
sql.executeUpdate("""
UPDATE
users
SET
fullname = ?,
firstname = ?,
lastname = ?,
email = ?,
organization = ?,
password = coalesce(sha1(?), password),
timestamp = now()
WHERE
uid = ?
""",
[
updateAttributes.findString("fullname"),
updateAttributes.findString("firstname"),
updateAttributes.findString("lastname"),
updateAttributes.findString("email"),
updateAttributes.findString("organization"),
updateAttributes.findString("password"),
uid
]
);
sql.executeUpdate("DELETE FROM car WHERE users_id=?",
[
uid
]
);
updateAttributes.findMap("cars").each {
sql.executeInsert(
"INSERT INTO car (users_id,year,make,model) VALUES (?,?,?,?)",
[
uid,
it.year,
it.make,
it.model
]
)
};
break
case ObjectClass.GROUP:
sql.executeUpdate("""
UPDATE
groups
SET
description = ?,
name = ?,
gid = ?,
timestamp = now()
WHERE
id = ?
""",
[
updateAttributes.findString("description"),
updateAttributes.findString("name"),
updateAttributes.findString("gid"),
uid
]
);
sql.executeUpdate("DELETE FROM groups_users WHERE groups_id=?",
[
uid
]
);
updateAttributes.findMap("users").each {
sql.executeInsert(
"INSERT INTO groups_users (users_id,groups_id) SELECT id,? FROM users WHERE uid=?",
[
it.uid,
uid
]
)
}
break
case ORG:
sql.executeUpdate("""
UPDATE
Organizations
SET
description = ?,
timestamp = now()
WHERE
id = ?
""",
[
updateAttributes.findString("description"),
uid
]
);
break
default:
uid
}
return uid
case OperationType.ADD_ATTRIBUTE_VALUES:
throw new UnsupportedOperationException(operation.name() + " operation of type:" +
objectClass.objectClassValue + " is not supported.")
case OperationType.REMOVE_ATTRIBUTE_VALUES:
throw new UnsupportedOperationException(operation.name() + " operation of type:" +
objectClass.objectClassValue + " is not supported.")
default:
throw new ConnectorException("UpdateScript can not handle operation:" + operation.name())
}