Warning, /CondTools/SiStrip/test/Documentation/OracleDBAProcedure_Strip is written in an unsupported language. File is not indexed.
0001 ##
0002 ## To create mapping descriptions, if not already defined here
0003 ##
0004
0005 rm -f SiStripPedestals-mapping-default.xml
0006
0007 pool_build_object_relational_mapping -f mapping-template-SiStripPedestals.xml -o SiStripPedestals-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0008
0009 rm -f pippo.db
0010
0011 cp SiStripPedestals-mapping-default.xml SiStripPedestals-mapping-custom.xml
0012
0013 ######################
0014 rm -f SiStripNoises-mapping-default.xml
0015
0016 pool_build_object_relational_mapping -f mapping-template-SiStripNoises.xml -o SiStripNoises-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0017
0018 rm -f pippo.db
0019
0020 cp SiStripNoises-mapping-default.xml SiStripNoises-mapping-custom.xml
0021
0022 ###########################
0023 rm -f SiStripFedCabling-mapping-default.xml
0024
0025 pool_build_object_relational_mapping -f mapping-template-SiStripFedCabling.xml -o SiStripFedCabling-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0026
0027 rm -f pippo.db
0028
0029 cp SiStripFedCabling-mapping-default.xml SiStripFedCabling-mapping-custom.xml
0030
0031 ######################
0032
0033 rm -f SiStripBadStrip-mapping-default.xml
0034
0035 pool_build_object_relational_mapping -f mapping-template-SiStripBadStrip.xml -o SiStripBadStrip-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0036
0037 rm -f pippo.db
0038
0039 cp SiStripBadStrip-mapping-default.xml SiStripBadStrip-mapping-custom.xml
0040
0041 ######################
0042
0043 rm -f SiStripModuleHV-mapping-default.xml
0044
0045 pool_build_object_relational_mapping -f mapping-template-SiStripModuleHV.xml -o SiStripModuleHV-mapping-default.xml -d CondFormatsSiStripObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0046
0047 rm -f pippo.db
0048
0049 cp SiStripModuleHV-mapping-default.xml SiStripModuleHV-mapping-custom.xml
0050
0051
0052
0053 ##################################
0054 # OBSOLETE PART
0055
0056
0057
0058
0059 ######################
0060
0061 ## edit SiStrip*-mapping-custom.xml change to meaningful names
0062
0063 ######################################
0064
0065 ## start DBA procedure:
0066 ## build real table in oracle db
0067
0068 setenv TNS_ADMIN /afs/cern.ch/project/oracle/admin
0069
0070 pool_build_object_relational_mapping -f SiStripPedestals-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripPedestals.debug
0071
0072 pool_build_object_relational_mapping -f SiStripNoises-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripNoises.debug
0073
0074 pool_build_object_relational_mapping -f SiStripFedCabling-mapping-custom.xml -d CondFormatsSiStripObjects -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -debug >! SiStripFedCabling.debug
0075
0076 pool_build_object_relational_mapping -f mapping-template-CondIOV-default.xml -d CondCoreIOVService -c oracle://devdb10/CMS_COND_STRIP -u CMS_COND_STRIP -p strip_cern200603 -o CondIOV-mapping-default.xml -debug >! SiStripCondIOV.debug
0077
0078 #####################################################
0079 ## NOT NEEDED ANYMORE
0080 ##to get create statements for DBA record:
0081 ##grep CREATE *.debug > SiStripschema.debug
0082 ##clean up SiStripschema.debug and replace CMS_XIEZHEN_DEV by SiStrip schema name
0083 ## NOT NEEDED ANYMORE
0084 ###################################################################
0085
0086 ## also change the GRANT SELECT according to setup (still not implemented, do it )
0087 ##sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < grants.sql
0088
0089 ## add extra TIME column to the payload tables
0090 sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < addSiStripPayloadTime.sql
0091
0092 ## create METADATA table
0093 sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < createMetaDataTable.sql
0094
0095 ## create catalog tables
0096 setenv POOL_OUTMSG_LEVEL D
0097 FCregisterPFN -p pippo -u relationalcatalog_oracle://devdb10/CMS_COND_STRIP -t POOL_RDBMS > &catalog.debug
0098
0099 grep CREATE catalog.debug
0100
0101
0102 ##########################################
0103 ## To remove all tables in CMS_COND_STRIP
0104 sqlplus CMS_COND_STRIP/strip_cern200603@devdb10 < clear.sql
0105 ##
0106 #########################################
