Cannot compile DropTable and CreateTable queries

[canopytax]

Cannot compile DropTable and CreateTable queries

[denisdubovitskiy]

@nhumrich yeah, I've taken a closer look to the code of connection.py and decided to create my first GitHub PR ;-) #94
Please take a look at that

This PR is related to the following issue #59

[nhumrich]

This has been merged and is in version 0.25.0

[nhumrich]

I dont run migrations in asyncio. So this has never been supported. This repo doesn't currently support everything sqlalchemy supports, only a subset. It looks like DropTable isnt "compiled", but rather an orm feature.
I would accept a PR to support this, but since its a feature I dont use, I dont have the time to work on this myself.

[denisdubovitskiy]

So, any ideas about how to create and drop tables between test cases? Is it really possible or we need to apply migrations to the database first?

The only solution I know is to manually iterate over the list of tables and create/drop them compiling the statements:

DropTable(table).compile(dialect=postgresql.dialect())

[nhumrich]

So, looking at this error a second time, it looks like the issue might be that droptable compiled doesn't have any params. compiled.params == None. So, maybe this is a fixable bug. Might be worth adding a none check to connection.py line 60. Would you have time to take a look at this, and maybe add a test case for it?