replace schema with prefix DB__
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/d05a67b2 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/d05a67b2 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/d05a67b2 Branch: refs/heads/master Commit: d05a67b29dd0ca83ba719a706e531943501b54dc Parents: e4ea1ca Author: Kevin Xu <[email protected]> Authored: Wed Dec 23 13:34:59 2015 +0800 Committer: Kevin Xu <[email protected]> Committed: Wed Dec 23 13:59:07 2015 +0800 ---------------------------------------------------------------------- .../lib_mgmt/src/main/resources/init_libmgmt.sh | 35 ++++++++++---------- 1 file changed, 18 insertions(+), 17 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d05a67b2/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh ---------------------------------------------------------------------- diff --git a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh index 9dd16b1..ec6c031 100644 --- a/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh +++ b/core/sql/lib_mgmt/src/main/resources/init_libmgmt.sh @@ -20,21 +20,22 @@ # # @@@ END COPYRIGHT @@@ -SERVER_JAR=${MY_SQROOT}/export/lib/spj_mgmt.jar +SERVER_JAR=${MY_SQROOT}/export/lib/lib_mgmt.jar CI=sqlci CATALOG_NAME=TRAFODION -CIS_SCHEMA="_LIBMGR_" +LIB_SCHEMA="DB__LIBMGR" DB__LIBMGRROLE=DB__LIBMGRROLE +LIB_NAME=LIBMGMTNAME function dropAndCreateSchema { - echo "Creating Schema for SPJ_MGMT" + echo "Creating Schema for ${LIB_SCHEMA}" ${CI} << sqlciEOF cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; - DROP SCHEMA $CATALOG_NAME.$CIS_SCHEMA CASCADE; - CREATE SCHEMA $CATALOG_NAME.$CIS_SCHEMA; + DROP SCHEMA $CATALOG_NAME.$LIB_SCHEMA CASCADE; + CREATE SCHEMA $CATALOG_NAME.$LIB_SCHEMA; cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off'; cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off'; @@ -45,24 +46,24 @@ sqlciEOF function createProcedures { - echo "Creating Procedures in schema '$CATALOG_NAME.$CIS_SCHEMA' " + echo "Creating Procedures in schema '$CATALOG_NAME.$LIB_SCHEMA' " ${CI} << procEOF cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on'; cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on'; -- Creating Procedures - set schema $CATALOG_NAME.$CIS_SCHEMA; + set schema $CATALOG_NAME.$LIB_SCHEMA; - DROP LIBRARY SPJMGMT CASCADE; - CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}'; + DROP LIBRARY ${LIB_NAME} CASCADE; + CREATE LIBRARY ${LIB_NAME} FILE '${SERVER_JAR}'; CREATE ROLE ${DB__LIBMGRROLE}; CREATE PROCEDURE HELP ( INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.help (java.lang.String[])' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -75,7 +76,7 @@ function createProcedures { IN CREATEFLAG INTEGER) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.put(java.lang.String,java.lang.String,int)' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -87,7 +88,7 @@ function createProcedures { OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.ls(java.lang.String,java.lang.String[])' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -98,7 +99,7 @@ function createProcedures { OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.lsAll(java.lang.String[])' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -109,7 +110,7 @@ function createProcedures { IN FILENAME VARCHAR(256) CHARACTER SET ISO88591) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.rm(java.lang.String)' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -121,7 +122,7 @@ function createProcedures { OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.rmRex(java.lang.String, java.lang.String[])' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -135,7 +136,7 @@ function createProcedures { OUT DATALENGTH LARGEINT) EXTERNAL NAME 'org.trafodion.libmgmt.FileMgmt.get (java.lang.String,int,java.lang.String[],long[])' EXTERNAL SECURITY DEFINER - LIBRARY SPJMGMT + LIBRARY ${LIB_NAME} LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA @@ -152,4 +153,4 @@ procEOF dropAndCreateSchema createProcedures -echo "Successfully completed installation of SPJs." +echo "Successfully completed installation of procedures."
