web::dbfile2html Namespace Reference

Functions
def	create_page
def	dbfile2html
Variables
tuple	env = Environment(loader=FileSystemLoader('templates'))
string	help = 'Absolute path to SQLite3 database file.'
tuple	parser = OptionParser(usage='Usage: %prog --db PATH_TO_DB [options]')

---

Function Documentation

def web::dbfile2html::create_page	(		path,
			content
	)

Definition at line 26 of file dbfile2html.py.

                              :
    path = join(*path)
    if not exists(dirname(path)):
        makedirs(dirname(path))
    f = open(path + '.html', 'w')
    f.write(content)
    f.close()

def web::dbfile2html::dbfile2html	(		db_name,
			work_path,
			threshold = 1e-5
	)

Generates static HTML from given release comparison database file.
Algorithm: iterates through database, renders Jinja2 templates and saves
them to static HTML files.

Definition at line 34 of file dbfile2html.py.

                                                   :
    """
    Generates static HTML from given release comparison database file.
    Algorithm: iterates through database, renders Jinja2 templates and saves
    them to static HTML files.
    """
    if not exists(db_name):
        print "\nError: SQLite3 database file does not exsits. Exitting...\n"
        exit()

    conn = sqlite3.connect(db_name)
    c = conn.cursor()

    ## Initialise working directory.
    path = join(work_path, 'static_html')
    if not exists(path):
        makedirs(path)

    global_context = {'db_name': None , 'threshold': threshold,
                                'file_id': None, 'args': [], 'kwargs': None}
    global_context['static_html'] = True
    global_context['base_path'] = work_path.strip('/')

    ## Generate DB list page
    context = global_context.copy()
    db_list_temp = env.get_template('db_list.html')
    context['db_list'] = db_list_with_releases(work_path)
    f = open(join(path, 'index.html'), 'w')
    f.write(db_list_temp.render(context))

    ## Generate ReleaseComparison html pages
    c.execute('''SELECT id, title, statistical_test FROM ReleaseComparison;''')
    releases = c.fetchall()
    rel_summary_temp = env.get_template('release_summary.html')
    dir_summary_temp = env.get_template('directory_summary.html')


    for rel_id, release_title, st_test in releases:
        context = global_context.copy()
        context.update(get_release_summary_stats(c, release_title, st_test, threshold))
        context['release_title'] = release_title
        context['st_test'] = st_test
        create_page([path, release_title, st_test], rel_summary_temp.render(context))

        ## Generate RootFileComparison html pages
        print 'Generating %s (%s) comparison pages...' % (release_title, st_test)
        c.execute('''SELECT id, directory_id FROM RootFileComparison WHERE release_comparison_id = ?;''', (rel_id,))
        for file_id, file_top_dir_id in c.fetchall():
            context['file_id'] = file_id
            context.update(get_directory_summary_stats(c, [], file_id, threshold))
            create_page([path, release_title, st_test, str(file_id)], dir_summary_temp.render(context))

            c.execute('''SELECT id FROM Directory WHERE parent_id=?''', (file_top_dir_id,))
            children_dirs = c.fetchall()

            ## Generate Directory html pages
            def create_dir_pages(c, dir_id, dir_path):
                # Generate Directory page
                c.execute('''SELECT name FROM Directory WHERE id=?''', (dir_id,))
                dir_path.append(c.fetchone()[0])
                context.update(get_directory_summary_stats(c, dir_path, file_id, threshold))
                create_page([path, release_title, st_test, str(file_id)] + dir_path, dir_summary_temp.render(context))
                # TODO: Call for subdirectories

            for children_dir in children_dirs:
                create_dir_pages(c, children_dir[0], [])
        print 'Done.'

---

Variable Documentation

tuple web::dbfile2html::env = Environment(loader=FileSystemLoader('templates'))

Definition at line 18 of file dbfile2html.py.

string web::dbfile2html::help = 'Absolute path to SQLite3 database file.'

Definition at line 22 of file dbfile2html.py.

tuple web::dbfile2html::parser = OptionParser(usage='Usage: %prog --db PATH_TO_DB [options]')

Definition at line 20 of file dbfile2html.py.