createMetaData.py

#!/usr/bin/env python
from os import listdir
from os.path import isfile, join

def writeMetaData(iovs):
    script="""{{
    "destinationDatabase": "oracle://cms_orcon_prod/CMS_CONDITIONS", 
    "destinationTags": {{
        "SiPixelQuality_v07_offline": {{}}
    }}, 
    "inputTag": "SiPixelQuality_v07_offline", 
    "since": null, 
    "userText": "append IOVs {iovs} to SiPixelQuality_v07_offline"
}}""".format(iovs=iovs)
    return script

def main():
    mypath="."
    onlyfiles = [f for f in listdir(mypath) if isfile(join(mypath, f))]
    #print onlyfiles
    for file in onlyfiles:
        if file.endswith(".db"):
            tokens=file.split(".")[0].split("_")
            iovs=tokens[len(tokens)-1]+":"+tokens[len(tokens)-2]
            #print iovs
            metadataFileName = file.replace(".db",".txt")
            print metadataFileName
            metadataFile = open(metadataFileName,'w')
            metadataFile.write( writeMetaData(iovs) )   

if __name__ == '__main__':
    main()