|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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
cp DTMtime-mapping-default.xml DTMtime-mapping-custom.xml
edit DTMtime-mapping-custom.xml change to meaningful names
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
cp DTReadOutMapping-mapping-default.xml DTReadOutMapping-mapping-custom.xml
edit DTReadOutMapping-mapping-custom.xml
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
cp DTT0-mapping-default.xml DTT0-mapping-custom.xml
edit DTT0-mapping-custom.xml
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
cp DTTtrig-mapping-default.xml DTTtrig-mapping-custom.xml
edit DTTtrig-mapping-custom.xml
start DBA procedure:
build real table in sqlite db
pool_build_object_relational_mapping -f DTMtime-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTMtime.debug
pool_build_object_relational_mapping -f DTReadOutMapping-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTReadOutMapping.debug
pool_build_object_relational_mapping -f DTT0-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTT0.debug
pool_build_object_relational_mapping -f DTTtrig-mapping-custom.xml -d CondFormatsDTObjects -c sqlite_file:testfile.db -u user -p pass -debug>DTTtrig.debug
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
to get create statements for DBA record:
grep CREATE *.debug > DTschema.debug
clean up DTschema.debug and replace schema name
also change the GRANT SELECT according to setup
add extra TIME column to the payload tables
sqlplus user@devdb10/pass < addDTPayloadTime.sql
create METADATA table
sqlplus user@devdb10/pass < createMetaDataTable.sql
create catalog tables
setenv POOL_OUTMSG_LEVEL D
FCregisterPFN -p pippo -u relationalcatalog_sqlite:testfile.db -t POOL_RDBMS > &catalog.debug
grep CREATE catalog.debug
|