def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql = \
"""insert all
when not exists (select * from %sfile_data_types where file_type = file_t) then
into %sfile_data_types(file_type_id, file_type) values( %sseq_ft.nextval, file_t )
when 1 = 1 then
into %sfiles (file_id, logical_file_name, is_file_valid,
dataset_id, block_id, file_type_id, check_sum, event_count, file_size,
adler32, md5, auto_cross_section,
last_modification_date, last_modified_by)
values (:file_id, :logical_file_name, :is_file_valid, :dataset_id, :block_id,
nvl(( select file_type_id from %sfile_data_types where file_type = file_t ), %sseq_ft.nextval ),
:check_sum, :event_count, :file_size,
:adler32, :md5, :auto_cross_section,
:last_modification_date, :last_modified_by)
select :file_type file_t from dual
""" % ((self.owner,)*6)
#Move these part to business layer. YG 11/23/2010
#def formatBinds(self, daoinput):
"""
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sBLOCKS SET FILE_COUNT=:file_count, BLOCK_SIZE=:block_size where BLOCK_ID=:block_id""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.basesql = " D.DATASET FROM %sDATASETS D " % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.logger = logger
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
#all listFile APIs should return the same data structure defined by self.sql
self.sql_sel = \
"""
SELECT F.FILE_ID, F.LOGICAL_FILE_NAME, F.IS_FILE_VALID,
F.DATASET_ID, D.DATASET,
F.BLOCK_ID, B.BLOCK_NAME,
F.FILE_TYPE_ID, FT.FILE_TYPE,
F.CHECK_SUM, F.EVENT_COUNT, F.FILE_SIZE,
F.BRANCH_HASH_ID, F.ADLER32, F.MD5,
F.AUTO_CROSS_SECTION,
F.CREATION_DATE, F.CREATE_BY,
F.LAST_MODIFICATION_DATE, F.LAST_MODIFIED_BY
"""
self.sql_cond = \
"""
FROM %sFILES F
JOIN %sFILE_DATA_TYPES FT ON FT.FILE_TYPE_ID = F.FILE_TYPE_ID
JOIN %sDATASETS D ON D.DATASET_ID = F.DATASET_ID
JOIN %sBLOCKS B ON B.BLOCK_ID = F.BLOCK_ID
JOIN %sDATASET_ACCESS_TYPES DT ON DT.DATASET_ACCESS_TYPE_ID = D.DATASET_ACCESS_TYPE_ID
""" % ((self.owner,)*5)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sDATASETS SET IS_DATASET_VALID = :is_dataset_valid where DATASET = :dataset""" % self.owner
def __init__(self, logger, dbi, owner=""):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.block_join = "JOIN {owner}BLOCKS BS ON BS.BLOCK_ID=FS.BLOCK_ID".format(
owner=self.owner)
self.dataset_join = "JOIN {owner}DATASETS DS ON BS.DATASET_ID=DS.DATASET_ID".format(
owner=self.owner)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT FILE_CLOB FROM %sFILE_BUFFERS WHERE BLOCK_ID=:block_id AND rownum < 10""" % self.owner
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql = \
"""insert all
when not exists (select * from %sprocessed_datasets where processed_ds_name=processed_n) then
into %sprocessed_datasets(processed_ds_id, processed_ds_name) values (%sseq_psds.nextval, processed_n)
when not exists (select * from %sdataset_access_types where dataset_access_type=access_t) then
into %sdataset_access_types(dataset_access_type_id, dataset_access_type) values (%sseq_dtp.nextval, access_t)
when exists (select data_tier_id from %sdata_tiers where data_tier_name=tier) then
into %sdatasets ( dataset_id, dataset, primary_ds_id, processed_ds_id, data_tier_id,
dataset_access_type_id, acquisition_era_id, processing_era_id,
physics_group_id, xtcrosssection, prep_id, creation_date, create_by,
last_modification_date, last_modified_by
)
values ( :dataset_id, :dataset, :primary_ds_id,
nvl((select processed_ds_id from %sprocessed_datasets where processed_ds_name=processed_n),
%sseq_psds.nextval),
(select data_tier_id from %sdata_tiers where data_tier_name=tier),
nvl((select dataset_access_type_id from %sdataset_access_types where dataset_access_type=access_t), %sseq_dtp.nextval),
:acquisition_era_id, :processing_era_id, :physics_group_id,
:xtcrosssection, :prep_id, cdate, cby,
:last_modification_date, :last_modified_by
)
select :processed_ds_name processed_n,
:data_tier_name tier, :dataset_access_type access_t,
:creation_date cdate, :create_by cby
from dual""" %((self.owner,)*13)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sBLOCKS SET FILE_COUNT=:file_count, BLOCK_SIZE=:block_size where BLOCK_ID=:block_id""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT DISTINCT BLOCK_ID from %sFILE_BUFFERS""" % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sACQUISITION_ERAS SET END_DATE=:end_date where acquisition_era_name=:acquisition_era_name""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT DISTINCT BLOCK_ID from %sFILE_BUFFERS""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """ SELECT B.BLOCK_NAME FROM %sBLOCKS B """ % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = ""
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT FILE_CLOB FROM %sFILE_BUFFERS WHERE BLOCK_ID=:block_id AND rownum < 10""" % self.owner
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """INSERT INTO %sPHYSICS_GROUPS ( PHYSICS_GROUP_ID, PHYSICS_GROUP_NAME)
VALUES (:physics_group_id, :physics_group_name)""" % (
self.owner)
def __init__(self, config = {}):
"""
__DatabasePage__
A page with a database connection (a WMCore.Database.DBFormatter) held
in self.dbi. Look at the DBFormatter class for other handy helper
methods, such as getBinds and formatDict.
The DBFormatter class was originally intended to be extensively
sub-classed, such that it's subclasses followed the DAO pattern. For web
tools we do not generally do this, and you will normally access the
database interface directly:
binds = {'id': 123}
sql = "select * from table where id = :id"
result = self.dbi.processData(sql, binds)
return self.formatDict(result)
Although following the DAO pattern is still possible and encouraged
where appropriate. However, if you want to use the DAO pattern it may be
better to *not* expose the DAO classes and have a normal DatabasePage
exposed that passes the database connection to all the DAO's.
"""
TemplatedPage.__init__(self, config)
dbConfig = ConfigDBMap(config)
conn = DBFactory(self, dbConfig.getDBUrl(), dbConfig.getOption()).connect()
DBFormatter.__init__(self, self, conn)
myThread = threading.currentThread()
myThread.transaction = Transaction(conn)
myThread.transaction.commit()
return
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """DELETE FROM %sFILE_BUFFERS WHERE LOGICAL_FILE_NAME=:logical_file_name""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT B.BLOCK_ID as BLOCK_ID, B.DATASET_ID as DATASET_ID FROM %sBLOCKS B JOIN %sFILES FL ON FL.BLOCK_ID=B.BLOCK_ID LEFT OUTER JOIN %sFILE_PARENTS FP ON FP.PARENT_FILE_ID = FL.FILE_ID WHERE FP.THIS_FILE_ID IN ( """% ((self.owner,)*3)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT D.DATASET_ID FROM %sDATASETS D WHERE D.DATASET = :dataset""" % ( self.owner )
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sFILES SET IS_FILE_VALID = :is_file_valid where LOGICAL_FILE_NAME = :logical_file_name""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.basesql = " D.DATASET FROM %sDATASETS D " % self.owner
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql = """INSERT INTO %sDATASET_OUTPUT_MOD_CONFIGS ( DS_OUTPUT_MOD_CONF_ID, DATASET_ID, OUTPUT_MOD_CONFIG_ID)
VALUES (%sSEQ_DC.nextval, :dataset_id, :output_mod_config_id)""" % (
(self.owner, ) * 2)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.logger = logger
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
#all listFile APIs should return the same data structure defined by self.sql
self.sql_sel = \
"""
SELECT F.FILE_ID, F.LOGICAL_FILE_NAME, F.IS_FILE_VALID,
F.DATASET_ID, D.DATASET,
F.BLOCK_ID, B.BLOCK_NAME,
F.FILE_TYPE_ID, FT.FILE_TYPE,
F.CHECK_SUM, F.EVENT_COUNT, F.FILE_SIZE,
F.BRANCH_HASH_ID, F.ADLER32, F.MD5,
F.AUTO_CROSS_SECTION,
F.CREATION_DATE, F.CREATE_BY,
F.LAST_MODIFICATION_DATE, F.LAST_MODIFIED_BY
"""
self.sql_cond = \
"""
FROM %sFILES F
JOIN %sFILE_DATA_TYPES FT ON FT.FILE_TYPE_ID = F.FILE_TYPE_ID
JOIN %sDATASETS D ON D.DATASET_ID = F.DATASET_ID
JOIN %sBLOCKS B ON B.BLOCK_ID = F.BLOCK_ID
JOIN %sDATASET_ACCESS_TYPES DT ON DT.DATASET_ACCESS_TYPE_ID = D.DATASET_ACCESS_TYPE_ID
""" % ((self.owner,)*5)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql1 = \
"""
SELECT R.RELEASE_VERSION,
P.PSET_HASH, P.PSET_NAME,
A.APP_NAME,
O.OUTPUT_MODULE_LABEL,
O.GLOBAL_TAG,
O.CREATION_DATE,
O.CREATE_BY
"""
self.sql2 = \
"""
from %sOUTPUT_MODULE_CONFIGS O
JOIN %sRELEASE_VERSIONS R
ON O.RELEASE_VERSION_ID=R.RELEASE_VERSION_ID
JOIN %sAPPLICATION_EXECUTABLES A
ON O.APP_EXEC_ID=A.APP_EXEC_ID
JOIN %sPARAMETER_SET_HASHES P
ON O.PARAMETER_SET_HASH_ID=P.PARAMETER_SET_HASH_ID
""" % ( self.owner, self.owner, self.owner, self.owner )
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT FLBUF.LOGICAL_FILE_NAME FROM %sFILE_BUFFERS FLBUF JOIN %sFILES FL ON FL.LOGICAL_FILE_NAME=FLBUF.LOGICAL_FILE_NAME""" % (2*(self.owner,))
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql = \
"""insert all
when not exists (select * from %sprocessed_datasets where processed_ds_name=processed_n) then
into %sprocessed_datasets(processed_ds_id, processed_ds_name) values (%sseq_psds.nextval, processed_n)
when 1 = 1 then
into %sdatasets ( dataset_id, dataset, primary_ds_id, processed_ds_id, data_tier_id,
dataset_access_type_id, acquisition_era_id, processing_era_id,
physics_group_id, xtcrosssection, prep_id, creation_date, create_by,
last_modification_date, last_modified_by
)
values ( :dataset_id, :dataset,
(select primary_ds_id from %sprimary_datasets where primary_ds_name=pri_n),
nvl((select processed_ds_id from %sprocessed_datasets where processed_ds_name=processed_n),
%sseq_psds.nextval),
(select data_tier_id from %sdata_tiers where data_tier_name=tier),
(select dataset_access_type_id from %sdataset_access_types where dataset_access_type=access_t),
:acquisition_era_id, :processing_era_id, :physics_group_id,
:xtcrosssection, :prep_id, :creation_date, :create_by,
:last_modification_date, :last_modified_by
)
select :primary_ds_name pri_n, :processed_ds_name processed_n,
:data_tier_name tier, :dataset_access_type access_t
from dual""" %((self.owner,)*9)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT MIN(MIGRATION_REQUEST_ID) AS MIGRATION_REQUEST_ID FROM %sMIGRATION_REQUESTS WHERE MIGRATION_STATUS='PENDING' """ % (self.owner)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.logger = logger
#logger.warning('I am in dataset dao init')
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.basesql = \
"""
D.DATASET_ID, D.DATASET, D.PREP_ID,
D.XTCROSSSECTION,
D.CREATION_DATE, D.CREATE_BY,
D.LAST_MODIFICATION_DATE, D.LAST_MODIFIED_BY,
P.PRIMARY_DS_NAME,
PDT.PRIMARY_DS_TYPE,
PD.PROCESSED_DS_NAME,
DT.DATA_TIER_NAME,
DP.DATASET_ACCESS_TYPE,
AE.ACQUISITION_ERA_NAME,
PE.PROCESSING_VERSION,
PH.PHYSICS_GROUP_NAME
FROM %sDATASETS D
JOIN %sPRIMARY_DATASETS P ON P.PRIMARY_DS_ID = D.PRIMARY_DS_ID
JOIN %sPRIMARY_DS_TYPES PDT ON PDT.PRIMARY_DS_TYPE_ID = P.PRIMARY_DS_TYPE_ID
JOIN %sPROCESSED_DATASETS PD ON PD.PROCESSED_DS_ID = D.PROCESSED_DS_ID
JOIN %sDATA_TIERS DT ON DT.DATA_TIER_ID = D.DATA_TIER_ID
JOIN %sDATASET_ACCESS_TYPES DP on DP.DATASET_ACCESS_TYPE_ID= D.DATASET_ACCESS_TYPE_ID
LEFT OUTER JOIN %sACQUISITION_ERAS AE ON AE.ACQUISITION_ERA_ID = D.ACQUISITION_ERA_ID
LEFT OUTER JOIN %sPROCESSING_ERAS PE ON PE.PROCESSING_ERA_ID = D.PROCESSING_ERA_ID
LEFT OUTER JOIN %sPHYSICS_GROUPS PH ON PH.PHYSICS_GROUP_ID = D.PHYSICS_GROUP_ID
""" % ((self.owner,)*9)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql1 = \
"""
SELECT R.RELEASE_VERSION,
P.PSET_HASH, P.PSET_NAME,
A.APP_NAME,
O.OUTPUT_MODULE_LABEL,
O.GLOBAL_TAG,
O.CREATION_DATE,
O.CREATE_BY
"""
self.sql2 = \
"""
from %sOUTPUT_MODULE_CONFIGS O
JOIN %sRELEASE_VERSIONS R
ON O.RELEASE_VERSION_ID=R.RELEASE_VERSION_ID
JOIN %sAPPLICATION_EXECUTABLES A
ON O.APP_EXEC_ID=A.APP_EXEC_ID
JOIN %sPARAMETER_SET_HASHES P
ON O.PARAMETER_SET_HASH_ID=P.PARAMETER_SET_HASH_ID
""" % ( self.owner, self.owner, self.owner, self.owner )
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sBLOCKS SET OPEN_FOR_WRITING = :open_for_writing where BLOCK_NAME = :block_name""" % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = ""
def __init__(self, logger, dbi):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """INSERT INTO %sDATASET_RUNS ( DATASET_RUN_ID, DATASET_ID, RUN_NUMBER, COMPLETE, LUMI_SECTION_COUNT, CREATION_DATE, CREATE_BY)
VALUES (:datasetrunid, :datasetid, :runnumber, :complete, :lumisectioncount, :creationdate, :createby)""" % (
self.owner)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.logger = logger
#logger.warning('I am in dataset dao init')
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.basesql = \
"""
D.DATASET_ID, D.DATASET, D.PREP_ID,
D.XTCROSSSECTION,
D.CREATION_DATE, D.CREATE_BY,
D.LAST_MODIFICATION_DATE, D.LAST_MODIFIED_BY,
P.PRIMARY_DS_NAME,
PDT.PRIMARY_DS_TYPE,
PD.PROCESSED_DS_NAME,
DT.DATA_TIER_NAME,
DP.DATASET_ACCESS_TYPE,
AE.ACQUISITION_ERA_NAME,
PE.PROCESSING_VERSION,
PH.PHYSICS_GROUP_NAME
FROM %sDATASETS D
JOIN %sPRIMARY_DATASETS P ON P.PRIMARY_DS_ID = D.PRIMARY_DS_ID
JOIN %sPRIMARY_DS_TYPES PDT ON PDT.PRIMARY_DS_TYPE_ID = P.PRIMARY_DS_TYPE_ID
JOIN %sPROCESSED_DATASETS PD ON PD.PROCESSED_DS_ID = D.PROCESSED_DS_ID
JOIN %sDATA_TIERS DT ON DT.DATA_TIER_ID = D.DATA_TIER_ID
JOIN %sDATASET_ACCESS_TYPES DP on DP.DATASET_ACCESS_TYPE_ID= D.DATASET_ACCESS_TYPE_ID
LEFT OUTER JOIN %sACQUISITION_ERAS AE ON AE.ACQUISITION_ERA_ID = D.ACQUISITION_ERA_ID
LEFT OUTER JOIN %sPROCESSING_ERAS PE ON PE.PROCESSING_ERA_ID = D.PROCESSING_ERA_ID
LEFT OUTER JOIN %sPHYSICS_GROUPS PH ON PH.PHYSICS_GROUP_ID = D.PHYSICS_GROUP_ID
""" % ((self.owner,)*9)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """DELETE FROM %sFILE_BUFFERS WHERE LOGICAL_FILE_NAME=:logical_file_name""" % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sBLOCKS SET OPEN_FOR_WRITING = :open_for_writing , LAST_MODIFIED_BY=:myuser,
LAST_MODIFICATION_DATE = :ltime where BLOCK_NAME = :block_name""" % self.owner
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = \
"""insert into %sfile_parents
(this_file_id, parent_file_id)
values(:this_file_id, (select file_id from %sfiles where logical_file_name=:parent_logical_file_name))
""" % ((self.owner,)*2)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """ SELECT B.BLOCK_NAME """
self.fromsql = """ FROM %sBLOCKS B """ % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sDATASETS SET DATASET_ACCESS_TYPE_ID = ( select DATASET_ACCESS_TYPE_ID from %sDATASET_ACCESS_TYPES where
DATASET_ACCESS_TYPE=:dataset_access_type) where DATASET = :dataset""" % ((self.owner,)*2)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = (
"""INSERT INTO %sPARAMETER_SET_HASHES ( PARAMETER_SET_HASH_ID, PSET_HASH, NAME) VALUES (:parameter_set_hash_id, :pset_hash, :name)"""
% (self.owner)
)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = \
"""insert into %sfile_parents
(this_file_id, parent_file_id)
values(:this_file_id, (select file_id from %sfiles where logical_file_name=:parent_logical_file_name))
""" % ((self.owner,)*2)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql = """INSERT INTO %sCOMPONENT_STATUS
(COMP_STATUS_ID, COMPONENT_NAME, COMPONENT_STATUS, LAST_CONTACT_TIME)
values (:comp_status_id, :component_name, :component_status, :last_contact_time)
""" % self.owner
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE {owner}BLOCKS SET ORIGIN_SITE_NAME = :origin_site_name , LAST_MODIFIED_BY=:myuser,
LAST_MODIFICATION_DATE = :mtime where BLOCK_NAME = :block_name""".format(owner=self.owner)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """INSERT INTO %sPROCESSING_ERAS ( PROCESSING_ERA_ID, PROCESSING_VERSION, CREATION_DATE, CREATE_BY, DESCRIPTION)
VALUES (:processing_era_id, :processing_version, :creation_date, :create_by, :description)""" % (
self.owner
)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT MIN(MIGRATION_REQUEST_ID) AS MIGRATION_REQUEST_ID FROM %sMIGRATION_REQUESTS WHERE MIGRATION_STATUS='PENDING' """ % (
self.owner)
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
#all listFile APIs should return the same data structure defined by self.sql
self.sql = """select FILE_CLOB from %sFILE_BUFFERS WHERE BLOCK_ID=:block_id LIMIT 10""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
#all listFile APIs should return the same data structure defined by self.sql
self.sql = " SELECT F.LOGICAL_FILE_NAME FROM %sFILES F " % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT B.BLOCK_ID as BLOCK_ID, B.DATASET_ID as DATASET_ID FROM %sBLOCKS B JOIN %sFILES FL ON FL.BLOCK_ID=B.BLOCK_ID LEFT OUTER JOIN %sFILE_PARENTS FP ON FP.PARENT_FILE_ID = FL.FILE_ID WHERE FP.THIS_FILE_ID IN ( """ % (
(self.owner, ) * 3)
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE %sDATASETS SET LAST_MODIFIED_BY=:myuser, LAST_MODIFICATION_DATE=:mydate,
IS_DATASET_VALID = :is_dataset_valid where DATASET = :dataset""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
#all listFile APIs should return the same data structure defined by self.sql
self.sql = """select FILE_CLOB from %sFILE_BUFFERS WHERE BLOCK_ID=:block_id LIMIT 10""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """SELECT FLBUF.LOGICAL_FILE_NAME FROM %sFILE_BUFFERS FLBUF JOIN %sFILES FL ON FL.LOGICAL_FILE_NAME=FLBUF.LOGICAL_FILE_NAME""" % (
2 * (self.owner, ))
def __init__(self, logger, dbi, owner):
"""
Add schema owner and sql.
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = """UPDATE {owner}BLOCKS SET ORIGIN_SITE_NAME = :origin_site_name , LAST_MODIFIED_BY=:myuser,
LAST_MODIFICATION_DATE = :mtime where BLOCK_NAME = :block_name""".format(
owner=self.owner)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = \
"""
insert into %sfile_lumis
(run_num, lumi_section_num, file_id)
values (:run_num, :lumi_section_num, :file_id)
""" % (self.owner)
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.sql = \
"""INSERT INTO %sPROCESSED_DATASETS
(PROCESSED_DS_ID, PROCESSED_DS_NAME)
VALUES (:processed_ds_id, :processed_ds_name)
""" % self.owner
def __init__(self, logger, dbi, owner=""):
"""
Add schema owner and sql.
For now IS_DATASET_VALID = 1
"""
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.basesql = " D.DATASET FROM %sDATASETS D " % self.owner
self.wheresql = " WHERE D.IS_DATASET_VALID = 1"
def __init__(self, logger, dbi, owner):
DBFormatter.__init__(self, logger, dbi)
self.owner = "%s." % owner if not owner in ("", "__MYSQL__") else ""
self.logger = logger
self.sql =\
"""insert into %sdataset_parents ( this_dataset_id, parent_dataset_id)
values (:this_dataset_id,
(select dataset_id as parent_dataset_id from %sdatasets where dataset=:dataset))
""" % ( (self.owner,)*2 )
