Rice Impex 4.0.0 org.kuali.rice rice-db 2.2.1 rice-impex pom master server client com.oracle ${oracle.jdbc.groupId} ${oracle.jdbc.artifactId} ${oracle.jdbc.version} false true ascending true false row false false false false generate-resources ${impex.generate.phase} ${impex.generate.sql.phase} ${impex.generate.sql.phase} ${impex.generate.phase} ${impex.generate.phase} yyyyMMddHHmmss / users temp UNLIMITED -01918 -01920 utf8 utf8_bin SELECT 1 DROP DATABASE IF EXISTS ${impex.database} / GRANT USAGE ON *.* TO '${impex.username}'@'%' IDENTIFIED BY '${impex.password}' / GRANT USAGE ON *.* TO '${impex.username}'@'localhost' IDENTIFIED BY '${impex.password}' / DROP USER '${impex.username}'@'%' / DROP USER '${impex.username}'@'localhost' / CREATE DATABASE IF NOT EXISTS ${impex.database} DEFAULT CHARACTER SET '${sql.mysql.character.set}' DEFAULT COLLATE '${sql.mysql.collate}' / CREATE USER '${impex.username}'@'%' IDENTIFIED BY '${impex.password}' / CREATE USER '${impex.username}'@'localhost' IDENTIFIED BY '${impex.password}' / GRANT ALL ON ${impex.database}.* TO '${impex.username}'@'%' WITH GRANT OPTION / SELECT SYSDATE FROM DUAL BEGIN EXECUTE IMMEDIATE 'DROP USER ${impex.username} CASCADE'; EXCEPTION WHEN OTHERS THEN IF SQLCODE != ${sql.oracle.error.userDoesNotExist} THEN RAISE; END IF; END; / CREATE USER ${impex.username} IDENTIFIED BY ${impex.password} DEFAULT TABLESPACE ${impex.oracle.defaultTablespace} TEMPORARY TABLESPACE ${impex.oracle.temporaryTablespace} QUOTA ${impex.oracle.quota} ON ${impex.oracle.defaultTablespace} / GRANT CREATE PROCEDURE , CREATE SEQUENCE , CREATE SESSION , CREATE SYNONYM , CREATE TRIGGER , CREATE TABLE , CREATE TYPE , CREATE VIEW TO ${impex.username} / purge recyclebin / org.kuali.maven.plugins sql-maven-plugin 1.0.10 ${impex.username} ${impex.password} ${impex.url} ${impex.driver} ${impex.delimiter} ${sql.plugin.delimiter.type} ${sql.plugin.force.execution} ${sql.plugin.skip} ${sql.plugin.keepFormat} ${sql.plugin.printResultSet} ${sql.plugin.outputFile} ${sql.plugin.orderFile} ${sql.plugin.escapeProcessing} ${sql.plugin.enableAnonymousPassword} validate-dba none execute ${impex.dba.url} ${impex.dba.username} ${impex.dba.password} ${impex.sql.validate} validate none execute ${impex.username} ${impex.password} ${impex.sql.validate} clean none execute ${impex.dba.url} ${impex.dba.username} ${impex.dba.password} ${impex.sql.drop} initialize none execute ${impex.dba.url} ${impex.dba.username} ${impex.dba.password} ${impex.sql.initialize} pre-export none execute true ${impex.sql.pre.export} org.kuali.rice rice-sql ${project.version} ${jdbc.groupId} ${jdbc.artifactId} ${jdbc.version} org.kuali.maven.plugins maven-impex-plugin ${jdbc.groupId} ${jdbc.artifactId} ${jdbc.version} ${db.vendor} ${impex.username} ${impex.password} ${impex.url} ${impex.driver} ${project.build.directory}/generated-impex/xml ${project.build.directory}/generated-impex ${project.build.directory}/generated-impex/${project.artifactId}.xml ${impex.date.format} ${impex.include.version.in.comment} ${impex.ant.compatibility.mode} morph ${impex.generate.morph.phase} morphschema morphdata ${project.basedir}/src/main/resources/schema.xml ${project.basedir}/src/main/resources datadtd ${impex.generate.dtd.phase} datadtd oracle ${impex.generate.sql.oracle.phase} schemasql datasql oracle mysql ${impex.generate.sql.mysql.phase} schemasql datasql mysql install none import kuali-release ${project.basedir} ${project.artifactId} org.kuali.maven.plugins mvn-maven-plugin sql process-resources mvn process-resources classpath:org/kuali/common/deploy/mvn/impex-with-sql-plus-meta.xml impex.basedir impex.schema.name plugin.impex.version org.kuali.common kuali-deploy ${kuali-deploy.version} maven-jar-plugin sql jar true ${project.build.directory}/impex sql org.kuali.maven.plugins mvn-maven-plugin export none org.kuali.maven.plugins maven-impex-plugin export none exportschema exportdata datadtd oracle.jdbc.mapDateToTimestamp false ${basedir}/src/main/resources/schema.xml ${basedir}/src/main/resources ${basedir}/src/main/resources/data.dtd ${impex.database} true mysql mysql com.mysql.jdbc.Driver rice root NONE jdbc:mysql://localhost ${impex.dba.url}/${impex.database} mysql ${mysql.jdbc.artifactId} ${mysql.jdbc.version} ${impex.mysql.sql.validate} ${impex.mysql.sql.drop} ${impex.mysql.sql.pre.export} ${impex.mysql.sql.create} ${impex.mysql.sql.grants} none CREATE TABLE IF NOT EXISTS ${impex.database}.EN_UNITTEST_T(COL VARCHAR(1) NULL); rds_mysql mysql com.mysql.jdbc.Driver rice master jdbc:mysql://mysql.rice.kuali.org ${impex.dba.url}/${impex.database} mysql ${mysql.jdbc.artifactId} ${mysql.jdbc.version} ${impex.mysql.sql.validate} ${impex.mysql.sql.drop} ${impex.mysql.sql.pre.export} ${impex.mysql.sql.create} ${impex.mysql.sql.grants} none CREATE TABLE IF NOT EXISTS ${impex.database}.EN_UNITTEST_T(COL VARCHAR(1) NULL); oracle oracle oracle.jdbc.driver.OracleDriver SYSTEM change_on_install jdbc:oracle:thin:@localhost:1521:XE ${impex.url} ${impex.oracle.sql.validate} ${impex.oracle.sql.drop} ${impex.oracle.sql.pre.export} ${impex.oracle.sql.create} ${impex.oracle.sql.grants} none CREATE TABLE ${impex.database}.EN_UNITTEST_T(COL VARCHAR2(1) NULL) / integration-test org.kuali.maven.plugins sql-maven-plugin pre-integration-test pre-integration-test execute ${impex.sql.UNITTEST.create} rds ojdbc6_g 11.2.0.2 jdbc:oracle:thin:@oracle.rice.kuali.org:1521:ORACLE ${impex.url} master db ${project.build.directory}/generated-impex org.kuali.maven.plugins maven-impex-plugin install install org.kuali.maven.plugins sql-maven-plugin clean clean validate-dba validate initialize initialize validate verify commit none initialize org.kuali.maven.plugins maven-impex-plugin id-invalid ${impex.invalid.phase} id-invalid-data-files ${project.basedir}/src/main/resources/schema.xml ${project.basedir}/src/main/resources org.kuali.maven.plugins maven-scm-plugin 1.6 Automated Impex update add ${scm.phase} add checkin **/src/main/resources/*.xml,**/src/main/resources/*.dtd maven-antrun-plugin remove-from-scm ${scm.phase} run