Python DBSSqlQueries示例

示例#1

    def __init__(self, methodName='runTest'):
        super(CompareDBS2ToDBS3, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3, ownerDBS2)

示例#2

文件： ValidateMigration_t.py 项目： PerilousApricot/DBS

    def __init__(self, methodName='runTest'):
        super(CompareDBS2ToDBS3, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3, ownerDBS2)

示例#3

文件： ValidateMigration_t.py 项目： AndresTanasijczuk/DBS

    def __init__(self, methodName="runTest"):
        super(CompareDBS2ToDBS3, self).__init__(methodName)
        ownerDBS3 = DBS3Secret["databaseOwner"]
        connectUrlDBS3 = DBS3Secret["connectUrl"]["reader"]

        ownerDBS2 = DBS2Secret["databaseOwner"]

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3, ownerDBS2)

示例#4

文件： ValidateOriginSiteName_t.py 项目： AndresTanasijczuk/DBS

class CompareOriginSiteName(unittest.TestCase):
    def __init__(self, methodName='runTest'):
        super(CompareOriginSiteName, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3, ownerDBS2)

    def test_origin_site_name(self):
        resultsUnion = self.dbssqlqueries.originSiteName(sort=False)

        self.assertEqual(len(resultsUnion), 0)

示例#5

文件： ValidateOriginSiteName_t.py 项目： giffels/DBS

class CompareOriginSiteName(unittest.TestCase):
    def __init__(self, methodName='runTest'):
        super(CompareOriginSiteName, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3,
                                           ownerDBS2)

    def test_origin_site_name(self):
        resultsUnion = self.dbssqlqueries.originSiteName(sort=False)

        self.assertEqual(len(resultsUnion), 0)

示例#6

文件： ValidateMigration_t.py 项目： PerilousApricot/DBS

class CompareDBS2ToDBS3(unittest.TestCase):
    def __init__(self, methodName='runTest'):
        super(CompareDBS2ToDBS3, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3, ownerDBS2)

    def test_acquisition_eras(self):
        resultsUnion = self.dbssqlqueries.acquisitionEras(sort=False)
        
        self.assertEqual(len(resultsUnion), 0)
        
    def test_application_executables(self):
        resultsUnion = self.dbssqlqueries.applicationExecutables(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_blocks(self):
        resultsUnion = self.dbssqlqueries.block(sort=False)

        self.assertEqual(len(resultsUnion), 0)
        
    def test_block_parents(self):
        resultsUnion = self.dbssqlqueries.blockParents(sort=False)
                    
        self.assertEqual(len(resultsUnion), 0)
    
    def test_datasets(self):
        resultsUnion = self.dbssqlqueries.dataset(sort=False)
        
        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_access_types(self):
        resultsUnion = self.dbssqlqueries.datasetAccessTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_output_mod_configs(self):
        resultsUnion = self.dbssqlqueries.datasetOutputModConfigs(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_parents(self):
        resultsUnion = self.dbssqlqueries.datasetParents(sort=False)

        self.assertEqual(len(resultsUnion), 0)
    
    def test_data_tiers(self):
        resultsUnion = self.dbssqlqueries.dataTier(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_files(self):
        resultsUnion = self.dbssqlqueries.file(sort=False)
            
        self.assertEqual(len(resultsUnion), 0)

    def test_file_data_types(self):
        resultsUnion = self.dbssqlqueries.fileDataTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_file_lumis(self):
        resultsUnion = self.dbssqlqueries.fileLumis(sort=False)
                    
        self.assertEqual(len(resultsUnion), 0)
        
    def test_file_output_mod_configs(self):
        resultsUnion = self.dbssqlqueries.fileOutputModConfigs(sort=False)
        
        self.assertEqual(len(resultsUnion), 0)
    
    def test_file_parents(self):
        resultsUnion = self.dbssqlqueries.fileParents(sort=False)
                    
        self.assertEqual(len(resultsUnion), 0)
    
    def test_output_module_config(self):
        resultsUnion = self.dbssqlqueries.outputModuleConfig(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_parameter_set_hashes(self):
        resultsUnion = self.dbssqlqueries.parametersetHashes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_physics_groups(self):
        resultsUnion = self.dbssqlqueries.physicsGroups(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_primary_datasets(self):
        resultsUnion = self.dbssqlqueries.primaryDataset(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_primary_ds_types(self):
        resultsUnion = self.dbssqlqueries.primaryDSTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)
        
    def test_processed_datasets(self):
        resultsUnion= self.dbssqlqueries.processedDatasets(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_release_versions(self):
        resultsUnion = self.dbssqlqueries.releaseVersions(sort=False)
       
        self.assertEqual(len(resultsUnion), 0)

示例#7

文件： ValidateMigration_t.py 项目： bbockelm/DBS-1

class CompareDBS2ToDBS3(unittest.TestCase):
    def __init__(self, methodName='runTest'):
        super(CompareDBS2ToDBS3, self).__init__(methodName)
        ownerDBS3 = DBS3Secret['databaseOwner']
        connectUrlDBS3 = DBS3Secret['connectUrl']['reader']

        ownerDBS2 = DBS2Secret['databaseOwner']

        logger = logging.getLogger()

        self.dbssqlqueries = DBSSqlQueries(logger, connectUrlDBS3, ownerDBS3,
                                           ownerDBS2)

    def test_acquisition_eras(self):
        resultsUnion = self.dbssqlqueries.acquisitionEras(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_application_executables(self):
        resultsUnion = self.dbssqlqueries.applicationExecutables(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_blocks(self):
        resultsUnion = self.dbssqlqueries.block(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_block_parents(self):
        resultsUnion = self.dbssqlqueries.blockParents(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_datasets(self):
        resultsUnion = self.dbssqlqueries.dataset(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_access_types(self):
        resultsUnion = self.dbssqlqueries.datasetAccessTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_output_mod_configs(self):
        resultsUnion = self.dbssqlqueries.datasetOutputModConfigs(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_dataset_parents(self):
        resultsUnion = self.dbssqlqueries.datasetParents(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_data_tiers(self):
        resultsUnion = self.dbssqlqueries.dataTier(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_files(self):
        resultsUnion = self.dbssqlqueries.file(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_file_data_types(self):
        resultsUnion = self.dbssqlqueries.fileDataTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_file_lumis(self):
        resultsUnion = self.dbssqlqueries.fileLumis(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_file_output_mod_configs(self):
        resultsUnion = self.dbssqlqueries.fileOutputModConfigs(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_file_parents(self):
        resultsUnion = self.dbssqlqueries.fileParents(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_output_module_config(self):
        resultsUnion = self.dbssqlqueries.outputModuleConfig(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_parameter_set_hashes(self):
        resultsUnion = self.dbssqlqueries.parametersetHashes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_physics_groups(self):
        resultsUnion = self.dbssqlqueries.physicsGroups(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_primary_datasets(self):
        resultsUnion = self.dbssqlqueries.primaryDataset(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_primary_ds_types(self):
        resultsUnion = self.dbssqlqueries.primaryDSTypes(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_processed_datasets(self):
        resultsUnion = self.dbssqlqueries.processedDatasets(sort=False)

        self.assertEqual(len(resultsUnion), 0)

    def test_release_versions(self):
        resultsUnion = self.dbssqlqueries.releaseVersions(sort=False)

        self.assertEqual(len(resultsUnion), 0)