def execute(self, sql, parameters=None):
"""
Execute an SQL command or query
:param sql: A (unicode) string that contains the SQL command or query. If you would like to
use parameters, please use a question mark ``?`` at the location where the
parameter shall be inserted.
:param parameters: An iterable of parameter values. The number of values must match
the number of parameters in the SQL string.
:return: The ``Cursor`` object to allow chaining of operations.
"""
self.rowcount = -1
self._assert_valid()
self.impl.prepare(sql)
if parameters:
buffer = make_parameter_set(self.impl)
buffer.add_set(parameters)
buffer.flush()
self.impl.execute()
self.rowcount = self.impl.get_row_count()
cpp_result_set = self.impl.get_result_set()
if cpp_result_set:
self.result_set = make_row_based_result_set(cpp_result_set)
else:
self.result_set = None
return self
def _execute(self):
self.impl.execute()
self.rowcount = self.impl.get_row_count()
cpp_result_set = self.impl.get_result_set()
if cpp_result_set:
self.result_set = make_row_based_result_set(cpp_result_set)
else:
self.result_set = None
return self
def execute(self, sql, parameters=None):
"""Execute an SQL query"""
self._assert_valid()
self.impl.prepare(sql)
if parameters:
buffer = make_parameter_set(self.impl)
buffer.add_set(parameters)
buffer.flush()
self.impl.execute()
self.rowcount = self.impl.get_row_count()
cpp_result_set = self.impl.get_result_set()
if cpp_result_set:
self.result_set = make_row_based_result_set(cpp_result_set)
else:
self.result_set = None
return self
def execute(self, sql, parameters=None):
"""Execute an SQL query"""
self._assert_valid()
self.impl.prepare(sql)
if parameters:
buffer = make_parameter_set(self.impl)
buffer.add_set(parameters)
buffer.flush()
self.impl.execute()
self.rowcount = self.impl.get_row_count()
cpp_result_set = self.impl.get_result_set()
if cpp_result_set:
self.result_set = make_row_based_result_set(cpp_result_set)
else:
self.result_set = None
return self
