import sqlite3
import logging
logger = logging.getLogger(__name__)

import common
'''

'''

def newdb(name):
    '''
    create a brand new database
    >>> c = newdb(':memory:')
    '''
    assert isinstance(name,str)
    conn = common.newdb(name)
    sql = open('curses.sql').read()
    conn.executescript(sql)
    conn.commit()
    return conn

def getFrame(conn,name):
    '''
    >>> conn = newdb(':memory:')
    >>> getFrame(conn,'oak')
    ()
    '''
    assert isinstance(name,str)
    cursor = conn.cursor()
    sql = 'SELECT val FROM constant WHERE name=\'%s\'' % name
    logger.debug(sql)
    valLst = [val for (val,) in cursor.execute(sql)]
    return valLst

if __name__ == '__main__':
    import doctest
    logging.basicConfig(filename='common.log',level=logging.DEBUG)
    doctest.testmod()