Azure Cosmos DB Cassandra API

[nekinie]

Is your feature request related to a problem? Please describe. I am unable to use migrate with an Azure Cosmos DB using the Cassandra API for three reasons:

• Azure Cosmos DB with the Cassandra API dose not support the truncate command
• Azure Cosmos DB with the Cassandra API uses port 10350, gocql is unable to connect when appending the port to the host, the documented port query string paramater is not implemented
• Azure Cosmos DB with the Cassandra API uses SSL and the only way I have been enable to get gocql to connect, is to set SslOpts to a pointer of a empty gocql.SslOptions struct

Describe the solution you'd like I'm unsure if the Cassandra database integration should be changed, or if a dedicated Cosmos DB with Cassandra API database integration should be added

[dhui]

Related PR: https://github.com/golang-migrate/migrate/pull/285

[nekinie]

I think the problem with adding a Cosmos specific integration, is that you would end up with a bunch of them due to Cosmos supporting multiple interfaces. If people here are comfortable with a cosmos-cql integration, I would be happy to submit a PR.