ValidationMatrix_v2 Namespace Reference

Classes
class	ReleaseComparison

Functions
def	call_compare_using_files (args)
def	merge_dbs (main_db, partial_db)
def	partial_db_name (db_name, i)

Variables
	action
	args
	default
	dest
	help
	no_url
	optional_group
	opts
	parser
	Parse options. More...
	rel_cmp
	start
	usage
	use_external

Detailed Description

The script compares two releases, generates SQLite3 database file with release
comparison information.

Author:  Albertas Gimbutas,  Vilnius University (LT)
e-mail:  albertasgim@gmail.com

Note: default Pool size for file comparison is 7.
Note: did NOT finish static HTML generation implementation.

Function Documentation

def ValidationMatrix_v2.call_compare_using_files

(

args

)

Definition at line 63 of file ValidationMatrix_v2.py.

References join().

def call_compare_using_files(args):
    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.

Referenced by ValidationMatrix_v2.ReleaseComparison.compare().

def merge_dbs(main_db, partial_db):
    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.

Referenced by ValidationMatrix_v2.ReleaseComparison.compare().

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

Variable Documentation

ValidationMatrix_v2.action

Definition at line 27 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.args

Definition at line 262 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.default

Definition at line 27 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.dest

Definition at line 27 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.help

Definition at line 28 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.no_url

Definition at line 266 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.optional_group

Definition at line 39 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.opts

Definition at line 262 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.parser

Parse options.

Definition at line 25 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.rel_cmp

Definition at line 266 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.start

Definition at line 261 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.usage

Definition at line 25 of file ValidationMatrix_v2.py.

ValidationMatrix_v2.use_external

Definition at line 266 of file ValidationMatrix_v2.py.