Problem connecting to CrateDB Cloud

[amotl]

Problem

@matkuliak reported at crate/cratedb-guide#86 (comment) that influxio might not be ready to connect to CrateDB Cloud just yet.

Observations

When using an SQLAlchemy URL like [1], influxio will still connect using an URL like [2].

[1] crate://admin:[email protected]:4200/testdrive/demo?ssl=true
[2] crate://admin:[email protected]:4200/?schema=testdrive

Thoughts

The flaw is probably located here.

influxio/influxio/adapter.py

Lines 276 to 282 in 9df60e6

	# Special handling for SQLite and CrateDB databases.
	self.dburi = str(url.with_query(None))
	if url.scheme == "crate":
	url = url.with_path("")
	if self.database:
	url = url.with_query({"schema": self.database})
	self.dburi = str(url)

[amotl]

The problem has been fixed.

• Fix CrateDB Cloud connectivity #126