UpdateScript.groovy revision f2b76022e244a5f1078d49d4d098f1f686062f62
/*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
*
* Copyright (c) 2014 ForgeRock AS. 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://forgerock.org/license/CDDLv1.0.html
* 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 http://forgerock.org/license/CDDLv1.0.html
* If applicable, add the following below the CDDL Header,
* with the fields enclosed by brackets [] replaced by
* your own identifying information:
* "Portions Copyrighted [year] [name of copyright owner]"
*
* @author Gael Allioux <gael.allioux@forgerock.com>
*/
import groovy.sql.Sql
import org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConfiguration
import org.forgerock.openicf.misc.scriptedcommon.OperationType
import org.identityconnectors.common.logging.Log
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 org.identityconnectors.framework.common.objects.Uid
import java.sql.Connection
def operation = operation as OperationType
def updateAttributes = new AttributesAccessor(attributes as Set<Attribute>)
def configuration = configuration as ScriptedSQLConfiguration
def connection = connection as Connection
def id = id as String
def log = log as Log
def objectClass = objectClass as ObjectClass
def options = options as OperationOptions
def uid = uid as Uid
def ORG = new ObjectClass("organization")
log.info("Entering " + operation + " Script");
def sql = new Sql(connection);
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
id = ?
""",
[
updateAttributes.findString("fullname"),
updateAttributes.findString("firstname"),
updateAttributes.findString("lastname"),
updateAttributes.findString("email"),
updateAttributes.findString("organization"),
updateAttributes.findString("password"),
uid.uidValue
]
);
break
case ObjectClass.GROUP:
sql.executeUpdate("""
UPDATE
Groups
SET
description = ?,
gid = ?,
timestamp = now()
WHERE
id = ?
""",
[
updateAttributes.findString("description"),
updateAttributes.findString("gid"),
uid.uidValue
]
);
break
case ORG:
sql.executeUpdate("""
UPDATE
Organizations
SET
description = ?,
timestamp = now()
WHERE
id = ?
""",
[
updateAttributes.findString("description"),
uid.uidValue
]
);
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())
}