Insert a python dict like object to a sqlite3 table

smart_insert.py

def smart_insert(db, table, dic, cols=None):
    """
    eg: smart_insert(db, 'employee', {'name': 'Peter', 'age': 18})
    """
    cur = db.cursor()
    if not cols:
        cols = dic.keys()
    columns = ', '.join(cols)
    placeholders = ', '.join('?' * len(cols))
    sql = 'INSERT INTO {} ({}) VALUES ({})'.format(table, columns,
                                                   placeholders)
    cur.execute(sql, [dic[i] for i in cols])