Warning, /CondTools/DT/src/OracleDBAProcedure is written in an unsupported language. File is not indexed.
0001 pool_build_object_relational_mapping -f mapping-template-DTMtime-default.xml -o DTMtime-mapping-default.xml -d CondFormatsDTObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0002
0003 cp DTMtime-mapping-default.xml DTMtime-mapping-custom.xml
0004 edit DTMtime-mapping-custom.xml change to meaningful names
0005
0006 pool_build_object_relational_mapping -f mapping-template-DTReadOutMapping-default.xml -o DTReadOutMapping-mapping-default.xml -d CondFormatsDTObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0007
0008 cp DTReadOutMapping-mapping-default.xml DTReadOutMapping-mapping-custom.xml
0009 edit DTReadOutMapping-mapping-custom.xml
0010
0011 pool_build_object_relational_mapping -f mapping-template-DTT0-default.xml -o DTT0-mapping-default.xml -d CondFormatsDTObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0012 cp DTT0-mapping-default.xml DTT0-mapping-custom.xml
0013 edit DTT0-mapping-custom.xml
0014
0015 pool_build_object_relational_mapping -f mapping-template-DTTtrig-default.xml -o DTTtrig-mapping-default.xml -d CondFormatsDTObjects -c sqlite_file:pippo.db -b -u whoever -p whatever
0016 cp DTTtrig-mapping-default.xml DTTtrig-mapping-custom.xml
0017 edit DTTtrig-mapping-custom.xml
0018
0019 start DBA procedure:
0020 build real table in sqlite db
0021
0022 pool_build_object_relational_mapping -f DTMtime-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTMtime.debug
0023
0024 pool_build_object_relational_mapping -f DTReadOutMapping-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTReadOutMapping.debug
0025
0026 pool_build_object_relational_mapping -f DTT0-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTT0.debug
0027
0028 pool_build_object_relational_mapping -f DTTtrig-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTTtrig.debug
0029
0030 pool_build_object_relational_mapping -f mapping-template-CondIOV-default.xml -d CondCoreIOVService -c sqlite_file:testfile.db -u user -p pass -o CondIOV-mapping-default.xml -debug > DTCondIOV.debug
0031
0032 to get create statements for DBA record:
0033 grep CREATE *.debug > DTschema.debug
0034 clean up DTschema.debug and replace schema name
0035 also change the GRANT SELECT according to setup
0036
0037 add extra TIME column to the payload tables
0038 sqlplus user@devdb10/pass < addDTPayloadTime.sql
0039
0040 create METADATA table
0041 sqlplus user@devdb10/pass < createMetaDataTable.sql
0042
0043 create catalog tables
0044 setenv POOL_OUTMSG_LEVEL D
0045 FCregisterPFN -p pippo -u relationalcatalog_sqlite:testfile.db -t POOL_RDBMS > &catalog.debug
0046
0047 grep CREATE catalog.debug
