def test_drop_table_compile():
statement = ddl.DropTable('foo', database='bar', must_exist=True)
query = statement.compile()
expected = "DROP TABLE bar.`foo`"
assert query == expected
statement = ddl.DropTable('foo', database='bar', must_exist=False)
query = statement.compile()
expected = "DROP TABLE IF EXISTS bar.`foo`"
assert query == expected
def drop_table_or_view(self, name, database=None, force=False):
"""
Drop a Spark table or view
Parameters
----------
name : string
database : string, default None (optional)
force : boolean, default False
Database may throw exception if table does not exist
Examples
--------
>>> table = 'my_table'
>>> db = 'operations'
>>> con.drop_table_or_view(table, db, force=True) # doctest: +SKIP
"""
statement = ddl.DropTable(name,
database=database,
must_exist=not force)
self._execute(statement.compile())