sqlalchemy+postgresql 建表不成功换 mysql 是可以

[holinhot]

database.py

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker


SQLALCHEMY_DATABASE_URL = "postgresql+psycopg2://postgres:123@localhost/cms"
#SQLALCHEMY_DATABASE_URL = "mysql://root@localhost/cms"



engine = create_engine(SQLALCHEMY_DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)

Base = declarative_base()

models.py

from sqlalchemy import Boolean, Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship

from .database import Base


class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True, index=True)
email = Column(String(15), unique=True, index=True)
hashed_password = Column(String(15))
is_active = Column(Boolean, default=True)

items = relationship("Item", back_populates="owner")


class Item(Base):
__tablename__ = "items"

id = Column(Integer, primary_key=True, index=True)
title = Column(String(15), index=True)
description = Column(String(15), index=True)
owner_id = Column(Integer, ForeignKey("users.id"))

owner = relationship("User", back_populates="items")


db.py
from sql_app import models
from sql_app.database import engine


def init_db():
models.Base.metadata.create_all(bind=engine)

init_db()

[holinhot]

真是奇怪了，执行了很多遍我看 postgresql 里根本没有表啊，同样的代码换成 mysql 是可以建表成功

[holinhot]

结贴，navicat 的锅，不知为何在 navicat 中不管怎么刷新，还是重连都不显示 postgresql 里的表。pgAdmin 没问题

[holinhot]

https://blog.csdn.net/YueYingGuang/article/details/104014159

[zzl22100048]

navicat 版本低了吧