|
Groovy example source code file (SqlCallTest.groovy)
The Groovy SqlCallTest.groovy source code/* * Copyright 2003-2009 the original author or authors. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package groovy.sql import java.sql.Connection import javax.sql.DataSource /** * Test Sql transaction features using a Sql built from a connection * * @author Paul King */ class SqlCallTest extends GroovyTestCase { Sql sql protected Sql setUpSql() { DataSource ds = new org.hsqldb.jdbc.jdbcDataSource() ds.database = "jdbc:hsqldb:mem:foo" + getMethodName() ds.user = 'sa' ds.password = '' Connection con = ds.connection return new Sql(con) } protected tryDrop(String tableName) { try { sql.execute("DROP TABLE $tableName".toString()) } catch(Exception e){ } } void setUp() { sql = setUpSql() ["PERSON"].each{ tryDrop(it) } sql.execute("CREATE TABLE person ( id INTEGER, firstname VARCHAR, lastname VARCHAR, PRIMARY KEY (id))") // populate some data def people = sql.dataSet("PERSON") people.add(id: 1, firstname: "James", lastname: "Strachan") people.add(id: 2, firstname: "Bob", lastname: "Mcwhirter") people.add(id: 3, firstname: "Sam", lastname: "Pullara") people.add(id: 4, firstname: "Jean", lastname: "Gabin") people.add(id: 5, firstname: "Lino", lastname: "Ventura") } void testBuiltinStoredProcedureQuery() { def pi = sql.firstRow("call PI()")['@p0'] assert pi.toString().startsWith('3.14159') } void testSelectWithFunction() { def result = sql.firstRow("select firstname, lastname, CHAR_LENGTH(firstname) as firstsize from PERSON") assert result.firstname == 'James' && result.firstsize == 5 } } Other Groovy examples (source code examples)Here is a short list of links related to this Groovy SqlCallTest.groovy source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.