def delete(self, table, where):
(sql, values) = sqldelete(table, where)<EOL>return self.execute(sql, values)<EOL>
Delete matching records. Returns the number of rows deleted.
See sqlwhere for where clause.

>>> import getpass
>>> s = DB(dbname='test', user=getpass.getuser(), host='localhost',
... password='')
>>> s.execute('drop table if exists t2')
>>> s.execute('create table t2 (id int, name text)')
>>> s.insert('t2', {'id': 1, 'name': 'Toto'})
>>> s.insert('t2', {'id': 2, 'name': 'Tata'})
>>> s.select('t2')
[{'id': 1, 'name': 'Toto'}, {'id': 2, 'name': 'Tata'}]
>>> s.delete('t2', {'id': 1})
1
>>> s.select('t2')
[{'id': 2, 'name': 'Tata'}]