/*

  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

  *

  * Copyright 2009 Sun Microsystems, Inc. All rights reserved.

  *

  * The contents of this file are subject to the terms of either the GNU

  * General Public License Version 2 only ("GPL") or the Common

  * Development and Distribution License("CDDL") (collectively, 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.netbeans.org/cddl-gplv2.html

  * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the

  * specific language governing permissions and limitations under the

  * License.  When distributing the software, include this License Header

  * Notice in each file and include the License file at

  * nbbuild/licenses/CDDL-GPL-2-CP.  Sun designates this

  * particular file as subject to the "Classpath" exception as provided

  * by Sun in the GPL Version 2 section of the License file that

  * accompanied this code. If applicable, add the following below the

  * License Header, with the fields enclosed by brackets [] replaced by

  * your own identifying information:

  * "Portions Copyrighted [year] [name of copyright owner]"

  *

  * If you wish your version of this file to be governed by only the CDDL

  * or only the GPL Version 2, indicate your decision by adding

  * "[Contributor] elects to include this software in this distribution

  * under the [CDDL or GPL Version 2] license." If you do not indicate a

  * single choice of license, a recipient has the option to distribute

  * your version of this file under either the CDDL, the GPL Version 2 or

  * to extend the choice of license to its licensees as provided above.

  * However, if you add GPL Version 2 code and therefore, elected the GPL

  * Version 2 license, then the option applies only if the new code is

  * made subject to such option by the copyright holder.

  *

  * Contributor(s):

  *

  * Portions Copyrighted 2009 Sun Microsystems, Inc.

  */

 package test

 import groovy.sql.Sql

 import org.xml.sax.SAXParseException

 /**

  *

  * @author lukas

  */

 class Utils {

     private Utils(){}

     private static Sql db

     static {

         db = Sql.newInstance("jdbc:derby://localhost:1527/sample", "app", "app", "org.apache.derby.jdbc.ClientDriver")

     }

     static void readXml(String text) throws SAXParseException {

         new XmlParser().parseText(text)

     }

     static String readFile(String relPath) {

         Utils.class.getResource(relPath).getText()

     }

     static int getCreditLimit(int customerID) {

         def r = db.firstRow("select CREDIT_LIMIT from customer where CUSTOMER_ID=${customerID}")

         if (r) {

             return r['CREDIT_LIMIT']

         }

         return -1

     }

 }