cloudflare / cloudflare/sqlalchemy-clickhouse

Cannot Query - AttributeError

Open
#22 6 comments 11 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
325
Forks
101
PR merge metrics
No merged PRs in 30d

Description

When I try to return the table names or execute a query, I get an error
(this is with the sql alchemy version 1.2.7)

**Code**
> import sqlalchemy as sa
>engine = sa.create_engine('clickhouse://localhost:8123/')
>engine.table_names()

**Issue**
```
Traceback (most recent call last):
File "", line 1, in
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2139, in table_names
return self.dialect.get_table_names(conn, schema)
File "", line 2, in get_table_names
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 42, in cache
return fn(self, con, *args, **kw)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy_clickhouse-0.1.3.post0-py3.6.egg/sqlalchemy_clickhouse/base.py", line 285, in get_table_names
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1416, in _handle_dbapi_exception
util.reraise(*exc_info)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy_clickhouse-0.1.3.post0-py3.6.egg/sqlalchemy_clickhouse/connector.py", line 209, in execute
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy_clickhouse-0.1.3.post0-py3.6.egg/sqlalchemy_clickhouse/connector.py", line 342, in _process_response
File "/home//anaconda3/lib/python3.6/site-packages/sqlalchemy_clickhouse-0.1.3.post0-py3.6.egg/sqlalchemy_clickhouse/connector.py", line 342, in
AttributeError: 'str' object has no attribute 'db_type'
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.