sql server load test using groovy

test.groovy

@GrabConfig(systemClassLoader=true)
@Grab(group='net.sourceforge.jtds', module='jtds', version='1.2.4')
import groovy.sql.Sql

sql = Sql.newInstance( 'jdbc:jtds:sqlserver://localhost/test', 'sa',
                       'sasasa', 'net.sourceforge.jtds.jdbc.Driver' )
                       
//sql.eachRow( 'select * from test1' ) { println "$it.id -- ${it.rnd} --" }

sql.execute('delete from test1');

begin = new Date()

for (i = 0; i < 1000000; i++) {
    random = new Random(new Date().time)
    sql.execute('insert into test1 (rnd, data) values(?,?)', ["${random.nextInt(199)+100}${random.nextInt(199)+100}${random.nextInt(199)+100}".toString(), new Date().time])
}

println(new Date().time - begin.time)

sql.close()