groovy/modules/classic/src/test/groovy/sql/TestHelper.groovy

package groovy.sql

import org.axiondb.jdbc.AxionDataSource

class TestHelper extends GroovyTestCase {

    static counter = 1
    
    static Sql makeSql() {
        foo = new TestHelper()
        return foo.createSql()
    }
    
    
    protected createEmptySql() {
        return newSql(getURI())
    }
    
    protected createSql() {
        sql = newSql(getURI())
        
        sql.execute("create table PERSON ( firstname varchar, lastname varchar, id integer, location_id integer, location_name varchar )")     
        sql.execute("create table FOOD ( type varchar, name varchar)")
        sql.execute("create table FEATURE ( id integer, name varchar)")
        
        // now lets populate the datasets
        people = sql.dataSet("PERSON")
        people.add( firstname:"James", lastname:"Strachan", id:1, location_id:10, location_name:'London' )
        people.add( firstname:"Bob", lastname:"Mcwhirter", id:2, location_id:20, location_name:'Atlanta' )
        people.add( firstname:"Sam", lastname:"Pullara", id:3, location_id:30, location_name:'California' )
        
        food = sql.dataSet("FOOD")
        food.add( type:"cheese", name:"edam" )
        food.add( type:"cheese", name:"brie" )
        food.add( type:"cheese", name:"cheddar" )
        food.add( type:"drink", name:"beer" )
        food.add( type:"drink", name:"coffee" )
        
        features = sql.dataSet("FEATURE")
        features.add( id:1, name:'GDO' )
        features.add( id:2, name:'GPath' )
        features.add( id:3, name:'GroovyMarkup' )
        return sql
    }
    
    protected getURI() {
		answer = "jdbc:axiondb:foo"
		name = getMethodName()
		if (name == null) { name = "" }
		name += counter++
		return answer + name
    }
    
    protected newSql(String uri) {
	    dataSource = new AxionDataSource(uri)
	    return new Sql(dataSource)
    }
}