...
Info | ||
---|---|---|
| ||
New developers should request SVN access by creating a ticket in the Kuali Rice Access JIRA project. |
Pre-production Deployments
TheĀ
Data Set Management Requirements
- Release versions of data sets must be stored in
<Repository Root/tags/<client release version>
(e.g. https://svn.ucdavis.edu/svn/kuali/RiceApplications/MyInfoVault/tags/3.5) - Only the Rice DBA and appropriate client application migrators have access to the
tags
directory in the repositories. - The data sets must come in the form of SQL scripts. Each deployment will contain a wrapper script and then one or more data scripts.
- You can download template of deploy script and data script.
Code Block | |||
---|---|---|---|
|
...
| |
|
...
---------------Opening Section-------------------
COL DT NOPRINT NEW_VALUE db_date;
SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD-HH24MISS') DT FROM DUAL;
COL db NOPRINT NEW_VALUE db_name;
SELECT SYS_CONTEXT ('RICE', 'MOTHRA') DB FROM DUAL;
----- Name the spool file -----
SPOOL ./deploy-rice-KR-<Jira-####>--&db_date-&db_name.log;
SET ECHO ON;
SET TERMOUT ON;
SET VERIFY OFF;
SET TRIMSPOOL ON;
SET SERVEROUTPUT ON SIZE 1000000;
WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK;
WHENEVER OSERROR EXIT SQL.SQLCODE ROLLBACK;
SET ECHO ON;
----- RICE KR-#### Deployment -----
SHOW USER;
@<child-script1>.sql
@<child-script2>.sql
----- Deployment Complete -----
SPOOL OFF;
|
Code Block | ||||
---|---|---|---|---|
|
...
| |
|
...
SET SQLBLANKLINES ON SET DEFINE OFF -- DDL/DML Statements -- DDL/DML Statements commit; / |
Data Set Migration Process
...