• Home
• org.kuali.db.impex
• impex-legacy-bundle
• 1.0.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

impex.impex-legacy-bundle.1.0.0.source-code.kfs-import-template.properties Maven / Gradle / Ivy

# -------------------------------------------------------------------
#
#  D A T A B A S E  S E T T I N G S
#
# -------------------------------------------------------------------
# JDBC connection settings. This is used by the JDBCToXML task that
# will create an XML database schema from JDBC metadata. These
# settings are also used by the SQL Ant task to initialize your
# Torque system with the generated SQL.
#
# sameJavaName
#   If true, the JDBC task will set the javaName attribute for the tables
#   and columns to be the same as SQL name.
# -------------------------------------------------------------------

torque.project = kfs
#
# the module and tag to check out from SVN for satellite updates
# these are to be used by a Satellite DBA for automating the refresh of the database
# 
svnroot=https://test.kuali.org/svn/
svn.module=kfs-cfg-dbs
svn.base=trunk
#
# the directory from which to read/write database XML files
#
torque.schema.dir=../../${svn.module}
torque.sql.dir=${torque.schema.dir}/sql
#
# where to find JDBC drivers
#
drivers.directory = ../../../drivers
drivers.file.pattern=ojdbc*.jar,mysql*.jar

#
# Modify these to match the database into which you are going to import
#

import.torque.database = ${import.torque.database}
import.torque.database.driver = ${import.torque.database.driver}
import.torque.database.url = ${kfs.import.torque.database.url}
import.torque.database.user=${kfs.import.torque.database.user}
import.torque.database.schema=${kfs.import.torque.database.schema}
import.torque.database.password=${kfs.import.torque.database.password}


# uncomment this to skip some of the larger (and mostly unnecessary) tables in the system
# import.exclude.data.pattern=LD_LDGR_ENTR_T.xml,GL_BALANCE_T.xml,GL_ENTRY_T.xml,LD_LDGR_BAL_T.xml,GL_ACCT_BALANCES_T.xml


# set if you want to use the ant script to set up the users and schemas for the import
# see build.properties for the commands that will be executed
import.admin.user=${kfs.import.admin.user}
import.admin.password=${kfs.import.admin.password}

# this may need to be different if (like in the case of MySQL) there is a schema name on the URL
# admin commands will not run with that URL if the schema has not yet been created
import.admin.url =  ${kfs.import.admin.url}

# these are used by the bootstrapping mechanism
oracle.usermaint.user=${kfs.oracle.usermaint.user}
oracle.usermaint.password=${kfs.oracle.usermaint.password}

# SQL statements used for creating and dropping users
# 
# THESE SHOULD NOT NEED TO BE MODIFIED 

# Oracle commands

oracle.drop.user.commands=DECLARE temp NUMBER; BEGIN temp := ${oracle.usermaint.user}.kuluser_maint_pk.drop_user( '${import.torque.database.user}' ); END;

oracle.create.user.commands=DECLARE temp NUMBER; BEGIN temp := ${oracle.usermaint.user}.kuluser_maint_pk.create_user( '${import.torque.database.user}', '${import.torque.database.password}' ); END;

oracle.empty.schema.commands=DECLARE temp NUMBER; BEGIN temp := ${oracle.usermaint.user}.kuluser_maint_pk.recreate_user( '${import.torque.database.user}' ); END;

# MySQL commands

mysql.create.user.command=CREATE USER '${import.torque.database.user}'@'localhost' IDENTIFIED BY '${import.torque.database.password}'

mysql.grant.command=GRANT ALL ON ${import.torque.database.schema}.* TO '${import.torque.database.user}'@'localhost' WITH GRANT OPTION

mysql.create.user.commands=${mysql.create.user.command}    
    
mysql.create.schema.commands=CREATE DATABASE IF NOT EXISTS ${import.torque.database.schema} DEFAULT CHARACTER SET 'utf8' DEFAULT COLLATE 'utf8_bin'\n\
/\n\
${mysql.grant.command}

mysql.drop.schema.commands=DROP DATABASE IF EXISTS ${import.torque.database.schema}