7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller/*
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller *
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemay * Copyright (c) 2013-2014 ForgeRock AS. All rights reserved.
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller *
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * The contents of this file are subject to the terms
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * of the Common Development and Distribution License
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * (the License). You may not use this file except in
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * compliance with the License.
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller *
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * You can obtain a copy of the License at
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * http://forgerock.org/license/CDDLv1.0.html
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * See the License for the specific language governing
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * permission and limitations under the License.
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller *
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * When distributing Covered Code, include this CDDL
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * Header Notice in each file and include the License file
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * at http://forgerock.org/license/CDDLv1.0.html
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * If applicable, add the following below the CDDL Header,
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * with the fields enclosed by brackets [] replaced by
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * your own identifying information:
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * "Portions Copyrighted [year] [name of copyright owner]"
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller */
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmillerimport groovy.sql.Sql;
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemayimport org.identityconnectors.common.logging.Log;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemayimport java.sql.Connection;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// Parameters:
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// The connector sends the following:
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// connection: handler to the SQL connection
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// action: a string describing the action ("TEST" here)
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// log: a handler to the Log facility
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemaydef sql = new Sql(connection as Connection);
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemaydef log = log as Log;
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemay
7f6887b5c5e1d621fbbb48d93b8ac940521d1e38Jason Lemaylog.info("Entering Test Script");
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller
548846fe158900a483ca91f47603c6bb6fde9b47Jon Branch// a relatively-cheap query to run on start up to ensure database connectivity and table existence
548846fe158900a483ca91f47603c6bb6fde9b47Jon Branchsql.eachRow("select * from auditauthentication limit 1", { } );
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditrecon limit 1", { } );
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditactivity limit 1", { } );
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditaccess limit 1", { } );
8013147372959d2435f1f8b0305057cfce308168Jason Lemaysql.eachRow("select * from auditsync limit 1", { } );
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller