def _execute_python(self,
operation: str,
parameters: parameters_type = None) -> 'Cursor':
"""
Execute operation with Python based statement preparation.
Args:
operation: the query you want to execute
parameters: an optional iterable containing arguments for the operation.
Returns:
the cursor object itself
Raises:
OperationalError: if the execution failed
"""
self._check_connection()
self.description = None # which will be set later in fetchall
self.connection.cleanup_result()
splitted = strip_split_and_clean(operation)
if len(splitted) == 0:
raise ProgrammingError("Empty query")
if len(splitted) > 1:
raise ProgrammingError("Multiple queries in one execute() call")
formatted = format_query(operation, parameters)
self.connection.result, self.rowcount = self.connection.query(
formatted, make_result=True)
self.connection.total_changes += self.rowcount
self._set_description()
return self
def executescript(self, sql_script: str) -> None:
"""
This is a nonstandard convenience and SQLite compatibility method for executing multiple SQL statements at once.
It issues a COMMIT statement first, then executes the SQL script it gets as a parameter.
Args:
sql_script: A string containing one or more SQL statements, split by ;
Raises:
Error: If the previous call to .execute*() did not produce any result set or no call was issued yet.
"""
self._check_connection()
if not isinstance(sql_script, str):
raise ValueError("script argument must be unicode.")
for query in strip_split_and_clean(sql_script):
self.execute(query)
def execute(self,
operation: str,
parameters: Optional[Iterable] = None) -> 'Cursor':
"""
Execute operation
Args:
operation: the query you want to execute
parameters: an optional iterable containing arguments for the operation.
Returns:
the cursor object itself
Raises:
OperationalError: if the execution failed
"""
self._check_connection()
self.description = None # which will be set later in fetchall
self._fetch_generator = None
if self.result:
self.connection.lowlevel.cleanup_result(
self.result) # type: ignore
self.result = None
splitted = strip_split_and_clean(operation)
if len(splitted) == 0:
raise ProgrammingError("Empty query")
if len(splitted) > 1:
raise ProgrammingError("Multiple queries in one execute() call")
formatted = format_query(operation, parameters)
self.result, self.rowcount = self.connection.lowlevel.query(
formatted, make_result=True) # type: ignore
self.connection.total_changes += self.rowcount
self._set_description()
return self