Example #1
0
def drawingRegister():
    object_list = helpers.get_csv()
    return render_template('drawingRegister.html', object_list=object_list)
import statistics as st

# miscellanous functions
import helpers as hp

# hash of hash.
# the first indice is the time difference between two
# coordinated objects. the second one is referring to a
# session. if a session refered by i has a value of 5, it
# means that it has 5 correlated objects with a predecessor at
# exactly i times steps behind.
session_sequences = {}
# keeps track of the number of events taken into account for one
# session in order to normalize
session_norm = {}
for file_path in hp.get_csv():
# iterating over the files (sessions)
    session_id = hp.get_id(file_path)
    # The Id in an integer
    session_id = int(session_id)
    session_norm[session_id] = 0
    # the name of the session is used as a table name in the
    # database
    session_name = hp.get_name(file_path)
    # array of arrays, stores for each coordinated object the
    # list of timespans between student switches
    event_time_differences = []

    con = lite.connect('mysteries.db')
    with con:
        cur = con.cursor()
import sqlite3 as lite
import csv
import helpers as hp

# List of actions taken into account in the analysis
auth_actions = hp.auth_actions
# Objects that doesn't have an id
no_id_array = hp.no_id_array


for file_path in hp.get_csv():
# iterating over the logs files. each log file corresponds to
# a team solving a problem. A team solving a problem is called
# a session

    # extracting the id and the name of the "sessions" 
    session_id = hp.get_id(file_path)
    session_name = hp.get_name(file_path)

    con = lite.connect('mysteries.db')
    with con:
    # Cleaning and initializing the database.
        cur = con.cursor()
        try:
            cur.execute("\
                DROP TABLE %s;\
            " % (session_name))
        except:
            print("Table %s could not be dropped, not created yet"\
                    % (session_name))
        # Each tuple in database corresponds to an action