Allows deleting rows by filtering, by ids or drop columns from the table.
delete(
self,
ids: Optional[List[str]] = None,
delete_all: Optional[bool] = None,
filter: Optional[str] = None,
drop_columns: Optional[List[str]] = None,
name: Optional[str] = None,
**kwargs: Any = {}
) -> None| Name | Type | Description |
|---|---|---|
filter | Optional[str] | Default: NoneProvide a string SQL expression - "{col} {operation} {value}". |
ids | Optional[List[str]] | Default: NoneProvide list of ids to delete from the table. |
drop_columns | Optional[List[str]] | Default: NoneProvide list of columns to drop from the table. |
delete_all | Optional[bool] | Default: NoneIf True, delete all rows from the table. |