翻了很多例子都是使用的经典模式,实在不习惯:
import databases
database = databases.Database(DATABASE_URL)
metadata = sqlalchemy.MetaData()
notes = sqlalchemy.Table(
"notes",
metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("text", sqlalchemy.String),
sqlalchemy.Column("completed", sqlalchemy.Boolean),
)
engine = sqlalchemy.create_engine(
DATABASE_URL, connect_args={"check_same_thread": False}
)
metadata.create_all(engine)
await database.connect()
query = notes.select()
return await database.fetch_all(query)
请问怎么转成这种 ORM 模式,进行数据库操作呢?
from db.base_class import Base
class User(Base):
user_id = Column(String(32), primary_key=True, index=True)
name = Column(String(32))