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())