macatc03:~/eclipseworkspaces/Eowyn lgoossen$ python
Python 2.3.5 (#1, Mar 20 2005, 20:38:20)
[GCC 3.3 20030304 (Apple Computer, Inc. build 1809)] on darwin
Type "help", "copyright", "credits" or "license" for more information.

>>> import ProdDBProxyOracle
Protocol version OK

>>> pdb=ProdDBProxyOracle.ProdDBProxyOracle(None,'atlas_t0','xxxxxxxx','atlas_t0')

>>> pdb.connect()
>>>> PDBORA:connect:0 trying to connect to prodDB (pdb v1.128 sup v? pro v1.34)
>>>> PDBORA:connect:0 connected to prodDB
'ok'

>>> pdb.insertDataset('foobar.TAG','TAGMC','FILLING','NONE',0)
>>>> PDBORA:insertDataset:9 CALLED with ('foobar.TAG', 'TAGMC', 'FILLING', 'NONE', 0, 'NONE', 'NONE')
>>>> PDBORA:updateSQL:10 --> executing INSERT INTO DATASET
(datasetname,type,writer1,reader1,partnr,ddm,t1,sfo,maxsfo) VALUES
('foobar.TAG','TAGMC','FILLING','NONE',0,'NONE','NONE','UNKNOWN',1)
>>>> PDBORA:updateSQL:10 --> varmap {}
>>>> PDBORA:updateSQL:10 SQL update took : 190 ms
>>>> PDBORA:insertDataset:5 INSERT dataset took 190ms
>>>> PDBORA:commit:10 committing prodDB ...
>>>> PDBORA:commit:10 committing prodDB done
>>>> PDBORA:insertDataset:9 RETURNS ok
'ok'

>>>pdb.insertFiles([('foobar.TAG','foobar.TAG._001',123456,'guid7302730','md5473047340034','NONE','/castor/tags/foobar.TA
G._001',100)])
>>>> PDBORA:insertFiles:9 CALLED with [('foobar.TAG', 'foobar.TAG._001', 123456, 'guid7302730',
'md5473047340034', 'NONE', '/castor/tags/foobar.TAG._001', 100)]
>>>> PDBORA:updateSQL:10 --> executing INSERT INTO tomfile
(datasetname,filename,filesize,guid,md5,state,pfn,nrevents) VALUES
('foobar.TAG','foobar.TAG._001',123456,'guid7302730','md5473047340034','NONE','/castor/tags/foobar.TAG._001',100)
>>>> PDBORA:updateSQL:10 --> varmap {}
>>>> PDBORA:updateSQL:10 SQL update took : 134 ms
>>>> PDBORA:insertFiles:5 INSERT one file took 134ms
>>>> PDBORA:commit:10 committing prodDB ...
>>>> PDBORA:commit:10 committing prodDB done
>>>> PDBORA:insertFiles:9 RETURNS ok
'ok'

>>>pdb.insertFiles([('foobar.TAG','foobar.TAG._0021',123456,'guid7302730','md5473047340034','NONE','/castor/tags/foobar.T
AG._002',100)])
>>>> PDBORA:insertFiles:9 CALLED with [('foobar.TAG', 'foobar.TAG._0021', 123456, 'guid7302730',
'md5473047340034', 'NONE', '/castor/tags/foobar.TAG._002', 100)]
>>>> PDBORA:updateSQL:10 --> executing INSERT INTO tomfile
(datasetname,filename,filesize,guid,md5,state,pfn,nrevents) VALUES
('foobar.TAG','foobar.TAG._0021',123456,'guid7302730','md5473047340034','NONE','/castor/tags/foobar.TAG._002',100)
>>>> PDBORA:updateSQL:10 --> varmap {}
>>>> PDBORA:updateSQL:10 SQL update took : 346 ms
>>>> PDBORA:insertFiles:5 INSERT one file took 346ms
>>>> PDBORA:commit:10 committing prodDB ...
>>>> PDBORA:commit:10 committing prodDB done
>>>> PDBORA:insertFiles:9 RETURNS ok
'ok'

>>> pdb.updateDataset('foobar.TAG',writer1='FILLED')
>>>> PDBORA:updateDataset:9 CALLED with ('foobar.TAG', None, 'FILLED', None)
>>>> PDBORA:updateSQL:10 --> executing UPDATE DATASET SET� writer1 = :w1 WHERE datasetname = :ds
>>>> PDBORA:updateSQL:10 --> varmap {'ds': 'foobar.TAG', 'w1': 'FILLED'}
>>>> PDBORA:updateSQL:10 SQL update took : 177 ms
>>>> PDBORA:updateDataset:5 UPDATE dataset took 177ms
>>>> PDBORA:commit:10 committing prodDB ...
>>>> PDBORA:commit:10 committing prodDB done
>>>> PDBORA:updateDataset:9 RETURNS ok
'ok'