def __init__(self,
table,
whereclause,
bind=None,
returning=None,
order_by=None,
limit=None,
offset=None,
**kwargs):
Delete.__init__(self, table, whereclause, bind, returning, **kwargs)
self._order_by_clause = ClauseList(*util.to_list(order_by) or [])
self._limit = limit
self._offset = offset
def test_connection_query(connection):
password = "******"
statement = Delete(User).where(User.name == 'John').where(User.password == password)
connection.execute(statement)
assert len(xray_recorder.current_segment().subsegments) == 1
sql_meta = xray_recorder.current_segment().subsegments[0].sql
assert sql_meta['sanitized_query'].startswith('DELETE FROM users')
assert sql_meta['url'] == 'sqlite:///:memory:'
assert password not in sql_meta['sanitized_query']
def get_children(self, column_collections=True, **kwargs):
children = Delete.get_children(column_collections, **kwargs)
return children + [self._order_by_clause]
def __init__(self, table, whereclause, bind=None, returning=None,
order_by=None, limit=None, offset=None, **kwargs):
Delete.__init__(self, table, whereclause, bind, returning, **kwargs)
self._order_by_clause = ClauseList(*util.to_list(order_by) or [])
self._limit = limit
self._offset = offset
def get_children(self, column_collections=True, **kwargs):
children = Delete.get_children(column_collections, **kwargs)
return children + [self._order_by_clause]
async def cleanup() -> None:
print("cleanup: Start.")
async with async_session.begin() as session:
await session.execute(Delete(TrackPoint))
await session.execute(Delete(User))
print("cleanup: Stop.")
