'Return information on a database table
:param tableName: name of table
:return: array of name/type info'

def tableInfo(self, tableName):

    sql_results = self.select(u'PRAGMA    table_info(`{0}`)'.format(tableName))
    columns = {}
    for column in sql_results:
        columns[column['name']] = {u'type': column['type']}
    return columns
