ValidationMatrix_v2 Namespace Reference

Classes
class	ReleaseComparison
Functions
def	call_compare_using_files
def	merge_dbs
def	partial_db_name
Variables
string	help = 'First CMSSW release for release comparison, e.g. CMSSW_5_3_2_pre7.'
tuple	optional_group = OptionGroup(parser, 'Optional')
tuple	parser
	Parse options.
tuple	rel_cmp = ReleaseComparison(opts.dir, opts.db_name, opts.clear_db, opts.dry, opts.no_url, use_external=True)
tuple	start = datetime.now()

---

Function Documentation

def ValidationMatrix_v2::call_compare_using_files

(

args

)

Definition at line 63 of file ValidationMatrix_v2.py.

                                  :
    file1, file2, work_path, db_name, clear_db = args
    command = ['./compare_using_files_v2.py', join(work_path, file1), join(work_path, file2), '--db', db_name]
    if clear_db:
        command.append('--cl')
    return call(command)

def ValidationMatrix_v2::merge_dbs	(		main_db,
			partial_db
	)

Definition at line 74 of file ValidationMatrix_v2.py.

                                  :
    conn = sqlite3.connect(main_db)
    c = conn.cursor()

    ## Test if database is empty
    c.execute('''SELECT * FROM Directory limit 1;''')
    directory_row = c.fetchall()

    ## Select offsets
    rel_cmp_offset, file_cmp_offset, directory_offset, hist_cmp_offset = 0, 0, 0, 0
    if directory_row:
        c.execute('''SELECT count(*) FROM ReleaseComparison;''')
        rel_cmp_offset = c.fetchone()[0]
        c.execute('''SELECT count(*) FROM RootFileComparison;''')
        file_cmp_offset = c.fetchone()[0]
        c.execute('''SELECT max(id) FROM Directory;''')
        directory_offset = c.fetchone()[0]
        c.execute('''SELECT max(id) FROM HistogramComparison;''')
        hist_cmp_offset = c.fetchone()[0]

    ## Merge DBs
    c.executescript("""
    ATTACH '{0}' AS partial;
    BEGIN;

    INSERT INTO ReleaseComparison (title, release1, release2, statistical_test)
    SELECT title, release1, release2, statistical_test FROM partial.ReleaseComparison;

    INSERT INTO RootFileComparison (filename1, filename2, release_comparison_id, directory_id)
    SELECT filename1, filename2, release_comparison_id+{1}, directory_id+{3} FROM partial.RootFileComparison;

    INSERT INTO Directory (id, name, parent_id, from_histogram_id, till_histogram_id)
    SELECT id+{3}, name, parent_id+{3}, from_histogram_id+{4}, till_histogram_id+{4} FROM partial.Directory;

    INSERT INTO HistogramComparison (name, p_value, directory_id)
    SELECT name, p_value, directory_id+{3} FROM partial.HistogramComparison;

    COMMIT;""".format(partial_db, rel_cmp_offset, file_cmp_offset, directory_offset, hist_cmp_offset))

    ## Select Last RootFileComparison ID
    c.execute('''SELECT max(id) FROM RootFileComparison;''')
    max_file_cmp_id = c.fetchone()[0]
    conn.close()
    return max_file_cmp_id

def ValidationMatrix_v2::partial_db_name	(		db_name,
			i
	)

Generates temporary database name.

Definition at line 70 of file ValidationMatrix_v2.py.

                               :
    """Generates temporary database name."""
    return '%s___%d.db' % (db_name.strip('.db'), i + 1)

---

Variable Documentation

string ValidationMatrix_v2::help = 'First CMSSW release for release comparison, e.g. CMSSW_5_3_2_pre7.'

Definition at line 28 of file ValidationMatrix_v2.py.

tuple ValidationMatrix_v2::optional_group = OptionGroup(parser, 'Optional')

Definition at line 39 of file ValidationMatrix_v2.py.

tuple ValidationMatrix_v2::parser

Initial value:

OptionParser(usage='Usage: %prog --re1 RELEASE1 [--f1 FR,FR,..] ' +
                            '--re2 RELEASE2 [--f2 FR,FR,..] [--st ST_TESTS] [options]')

Parse options.

Definition at line 25 of file ValidationMatrix_v2.py.

tuple ValidationMatrix_v2::rel_cmp = ReleaseComparison(opts.dir, opts.db_name, opts.clear_db, opts.dry, opts.no_url, use_external=True)

Definition at line 266 of file ValidationMatrix_v2.py.

tuple ValidationMatrix_v2::start = datetime.now()

Definition at line 261 of file ValidationMatrix_v2.py.