metridoc.workflows.dataStores.groovy Maven / Gradle / Ivy
The newest version!
/*
* Copyright 2010 Trustees of the University of Pennsylvania Licensed under the
* Educational Community 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.osedu.org/licenses/ECL-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 metridoc.workflows
import groovy.sql.Sql
/**
* script used to wipe repository tables containing replaceable data
*
* User: pkeavney
* Date: 3/15/12
*/
static clear () { dataStores.metaClass.invokeConstructor() }
Sql sql = Sql.newInstance( repository )
sql.execute( "truncate ill_group" )
sql.execute( "truncate ill_lending" )
sql.execute( "truncate ill_borrowing" )
sql.execute( "truncate ill_user_info" )
sql.execute( "truncate ill_transaction" )
sql.execute( "truncate ill_lender_info" )
sql.execute( "truncate ill_lender_group" )
sql.execute( "truncate ill_reference_number" )