<gh_stars>10-100
#!/usr/bin/env python

"""
Oracle implementation of AddChecksumByLFN
"""





from WMCore.WMBS.MySQL.Files.AddChecksumByLFN import AddChecksumByLFN as MySQLAddChecksumByLFN

class AddChecksumByLFN(MySQLAddChecksumByLFN):
    """
    Add Checksums using LFN as file identifier

    """
    sql = """INSERT INTO wmbs_file_checksums (fileid, typeid, cksum)
             SELECT (SELECT id FROM wmbs_file_details WHERE lfn = :lfn),
              (SELECT id FROM wmbs_checksum_type WHERE type = :cktype),
              :cksum FROM dual
             WHERE NOT EXISTS (SELECT fileid FROM wmbs_file_checksums WHERE
                               fileid = (SELECT id FROM wmbs_file_details WHERE lfn = :lfn)
                               AND typeid = (SELECT id FROM wmbs_checksum_type WHERE type = :cktype))"""

#!/usr/bin/env python

"""
Oracle implementation of AddChecksumByLFN
"""





from WMCore.WMBS.MySQL.Files.AddChecksumByLFN import AddChecksumByLFN as MySQLAddChecksumByLFN

class AddChecksumByLFN(MySQLAddChecksumByLFN):
    """
    Add Checksums using LFN as file identifier

    """
    sql = """INSERT INTO wmbs_file_checksums (fileid, typeid, cksum)
             SELECT (SELECT id FROM wmbs_file_details WHERE lfn = :lfn),
              (SELECT id FROM wmbs_checksum_type WHERE type = :cktype),
              :cksum FROM dual
             WHERE NOT EXISTS (SELECT fileid FROM wmbs_file_checksums WHERE
                               fileid = (SELECT id FROM wmbs_file_details WHERE lfn = :lfn)
                               AND typeid = (SELECT id FROM wmbs_checksum_type WHERE type = :cktype))"""
#!/usr/bin/env python Oracle implementation of AddChecksumByLFN Add Checksums using LFN as file identifier INSERT INTO wmbs_file_checksums (fileid, typeid, cksum)              SELECT (SELECT id FROM wmbs_file_details WHERE lfn = :lfn),               (SELECT id FROM wmbs_checksum_type WHERE type = :cktype),               :cksum FROM dual              WHERE NOT EXISTS (SELECT fileid FROM wmbs_file_checksums WHERE                                fileid = (SELECT id FROM wmbs_file_details WHERE lfn = :lfn)                                AND typeid = (SELECT id FROM wmbs_checksum_type WHERE type = :cktype))