from sqlalchemy import create_engine, Column, Integer, String, Float, DECIMAL, Boolean, Enum, Date, DateTime, Time, Text,Table
from sqlalchemy.dialects.mysql import LONGTEXT
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationship,backref
from datetime import date, datetime, time
from sqlalchemy import func, or_, ForeignKey
import enum
import random
# 准备连接数据库信息
HOSTNAME = "127.0.0.1"
PORT = "3306"
DATABASE = "first_sqlclchemy"
USERNAME = "root"
PASSWORD = "root"
# 按照上述格式组织数据库信息
DB_URI = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8".format(username=USERNAME,
password=PASSWORD,
host=HOSTNAME, port=PORT,
db=DATABASE)
# 创建数据库引擎
engine = create_engine(DB_URI)
Base = declarative_base(engine)
session = sessionmaker(engine)()
#需求:OMR层面外键多对多关系实现
#中间表 第3张表
news_tag=Table(
"new_tag",
Base.metadata,
Column("news_id",Integer,ForeignKey("news.id"),primary_key=True),
Column("tag_id",Integer,ForeignKey("tag.id"),primary_key=True)
)
#表1
class News(Base):
__tablename__="news"
id=Column(Integer,primary_key=True,autoincrement=True)
title=Column(String(50),nullable=False)
#添加属性
tags=relationship("Tag",backref="newss",secondary=news_tag)
def __repr__(self):
return "<News(title:{0})>".format(self.title)
#表2
class Tag(Base):
__tablename__="tag"
id=Column(Integer,primary_key=True,autoincrement=True)
name=Column(String(50),nullable=True)
def __repr__(self):
return "<Tag(name:{0})>".format(self.name)
Base.metadata.drop_all()
Base.metadata.create_all()
#添加数据
# new1=News(title="d世界第一")
# new2=News(title="d世界第二")
#
# tag1=Tag(name="要闻")
# tag2=Tag(name="娱乐")
#
# new1.tags.append(tag1)
# new1.tags.append(tag2)
#
# new2.tags.append(tag1)
# new2.tags.append(tag2)
#
# session.add(new1)
# session.add(new2)
#
# session.commit()
#查询数据
new3=session.query(News).first()
print(new3.tags)
老师 你看下我这个数据查询 为什么报错

tags这个属性就是在News这个类里边啊