TestScript.groovy revision 18f2985c5be44e17aff0b118ee2c6f18967fa150
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller/*
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller *
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller * Copyright (c) 2013 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;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmillerimport groovy.sql.DataSet;
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller
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
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmillerlog.info("Entering "+action+" Script");
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmillerdef sql = new Sql(connection);
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller// a relatively-cheap query to run on start up to ensure database connectivity
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditrecon limit 1", { } );
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditactivity limit 1", { } );
18f2985c5be44e17aff0b118ee2c6f18967fa150Brendan Mmillersql.eachRow("select * from auditaccess limit 1", { } );
7dcb2f62e25d05f2afeb4e79f10102350d7c2c7bBrendan Mmiller