注册

sqlalchemy.exc.DatabaseError: (dmPython.DatabaseError) [CODE:-70028]Create SOCKET connection failure

sportzhang 2024/10/10 601 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Ubuntu 22.04.4 LTS
【CPU】:x86_64
【问题描述】*:使用 dmPython.connect(
user=self.user,
password=self.password,
server=self.server,
port=self.port,
),连接成功。使用SQLAlchemy框架时候,版本如下:
SQLAlchemy 2.0.31
sqlalchemy_dm_dialect 2.0.0

使用如下代码运行报错
from sqlalchemy import create_engine, Column, Integer, String, Boolean, DateTime, func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import Session
from sqlalchemy.orm import sessionmaker
from typing import Optional

DATABASE_URL = 'dm+dmPython://SYSDBA:SYSDBA@8.149.119.65:5236'
engine = create_engine(DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
Base = declarative_base()

class User(Base):
tablename = "auth_users"
id = Column(Integer, primary_key=True, index=True)
name = Column(String(150), unique=True, index=True)
email = Column(String(255), unique=True, index=True)
password = Column(String(100))
verified_at = Column(DateTime, nullable=True, default=None)
updated_at = Column(DateTime, nullable=True, default=None, onupdate=datetime.now)
created_at = Column(DateTime, nullable=False, server_default=func.now())

Base.metadata.create_all(bind=engine)

报错如下:
sqlalchemy.exc.DatabaseError: (dmPython.DatabaseError) [CODE:-70028]Create SOCKET connection failure

回答 0
暂无回答
扫一扫
联系客服