cloudflare / cloudflare/sqlalchemy-clickhouse

create table issue use sqlalchemy-clickhouse

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

Description

engine = create_engine('clickhouse://default:@localhost/test',encoding='utf-8',echo=True)
Base = declarative_base()
class Users(Base):
**tablename** = 'users'
id = Column(Integer,primary_key=True)
name = Column(String(32))
password = Column(String(64))
engine = Engine()
Base.metadata.create_all(engine)
traceback like this:
Exception: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 45 (line 3, col 13): NOT NULL,
name VARCHAR(32),
password VARCHAR(64),
PRIMARY KEY (id)

I want create table use python code like this, but can't create it ,so what could i do to create it.
thanks

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.