import sqlite3

def loadSqlInMemory(filename):
    '''
    >>> loadSqlInMemory('fsm.sql') != None
    True

    >>> loadSqlInMemory('payload.sql') != None
    True

    '''
    conn = sqlite3.connect(':memory:')
    script = open(filename).read()
    c = conn.cursor()
    try:
        c.executescript(script)
    except Exception as e:
        print e
    conn.commit()
    c.close()
    return conn

def testView(conn,viewname):
    '''
    >>> conn = loadSqlInMemory('payload.sql')
    >>> testView(loadSqlInMemory('payload.sql'),'payload_test')
    '''
    c = conn.cursor()
    try:
        c.execute('SELECT * FROM '+viewname)
        for row in c.fetchall():
            print row
    except Exception as e:
        print e
    return

if __name__ == '__main__':
    import doctest
    doctest.testmod()