Python and SQLite: insert into table
Not a direct answer, but here is a function to insert a row with column-value pairs into sqlite table:
def sqlite_insert(conn, table, row): cols = ', '.join('"{}"'.format(col) for col in row.keys()) vals = ', '.join(':{}'.format(col) for col in row.keys()) sql = 'INSERT INTO "{0}" ({1}) VALUES ({2})'.format(table, cols, vals) conn.cursor().execute(sql, row) conn.commit()
Example of use:
sqlite_insert(conn, 'stocks', { 'created_at': '2016-04-17', 'type': 'BUY', 'amount': 500, 'price': 45.00})
Note, that table name and column names should be validated beforehand.