我在学习PYTHON时,想用MODEL生成数据库。提示Process finished with exit code 0
但是数据库没有生成表信息。
问题是没有生成数据库
代码如下:
"# * coding:utf-8 *"
from sqlalchemy.ext.declarative import declarative_base #建父类
from sqlalchemy.dialects.mysql import BIGINT,TINYINT,DATETIME,DATE,TEXT,VARCHAR #导入数据类型
from sqlalchemy import Column #字段
Base = declarative_base()
class Empolyee(Base):
tablename="employee"
id = Column(BIGINT,primary_key=True )
name = Column(VARCHAR(50),nullable=False)
sex = Column(TINYINT,nullable=False)
birthday = Column(DATE,nullable=False)
info = Column(TEXT(200),nullable=True)
edu = Column(VARCHAR(50),nullable=False)
phone =Column(VARCHAR(11),nullable=False,unique=True)
email = Column(VARCHAR(50),nullable=False,unique=True)
face = Column(VARCHAR(50),nullable=False)
creatAt = Column(DATETIME,nullable=True)
updateAt = Column(DATETIME,nullable=True)
class Emp_hobby(Base):
tablename="emp_hobby"
id = Column(TINYINT,primary_key=True)
emp_id = Column(TINYINT,nullable=False)
hobbyid = Column(TINYINT,nullable=False)
creatAt = Column(DATETIME,nullable=True)
updateAt = Column(DATETIME,nullable=True)
if name == "main":
import mysql.connector #导入联接驱动
from sqlalchemy import create_engine #导入数据引擎
mysql_configs = dict(
db_host="127.0.0.1",
db_name="crud",
db_port=3306,
db_user="root",
db_pwd="root"
)
engine = create_engine(
'mysql+mysqlconnector://{db_user}:{db_pwd}@{db_host}:{db_port}/{db_name}?charset=uft8'.format(
**mysql_configs
),
encoding="utf-8",
echo=True
)
metadata = Base.metadata
metadata.create_all(engine)
print("create ok!")
D:\Python\Python310\python.exe D:/Python/PycharmProjects/crud/app/models.py
Process finished with exit code 0