sqlite.execute(dbname, sql, parameters)

Execute a SQL statement and return the number of rows modified. The execute function should be used for insert, update, delete, and DDL statements.

Example

sqlite.execute('testdb', 'create table foo(x integer, y varchar(255))')
sqlite.execute('testdb', 'insert into foo values(?,?)', 123, 'abc')
sqlite.execute('testdb', 'drop table foo')