2023-10-23 00:13:06 +08:00
|
|
|
|
1.linux数据库操作
|
|
|
|
|
|
mysql -uroot -p
|
|
|
|
|
|
数据库密码：123456
|
|
|
|
|
|
创建数据表
|
|
|
|
|
|
数据库名：food_db
|
|
|
|
|
|
CREATE DATABASE `food_db` DEFAULT CHARACTER SET = `utf8mb4`;
|
|
|
|
|
|
查看表
|
|
|
|
|
|
show databases;
|
|
|
|
|
|
进入数据表
|
|
|
|
|
|
use food_db;
|
|
|
|
|
|
接着在粘贴建表语句，如下：
|
|
|
|
|
|
create TABLE `user` (
|
|
|
|
|
|
`uid` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户uid',
|
|
|
|
|
|
`nickname` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
|
|
|
|
|
|
`mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
|
|
|
|
|
|
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱地址',
|
|
|
|
|
|
`sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1：男 2：女 0：没填写',
|
|
|
|
|
|
`avatar` varchar(64) NOT NULL DEFAULT '' COMMENT '头像',
|
|
|
|
|
|
`login_name` varchar(20) NOT NULL DEFAULT '' COMMENT '登录用户名',
|
|
|
|
|
|
`login_pwd` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码',
|
|
|
|
|
|
`login_salt` varchar(32) NOT NULL DEFAULT '' COMMENT '登录密码的随机加密秘钥',
|
|
|
|
|
|
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1：有效 0：无效',
|
|
|
|
|
|
`updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新时间',
|
|
|
|
|
|
`created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
|
|
|
|
|
|
PRIMARY KEY (`uid`),
|
|
|
|
|
|
UNIQUE KEY `login_name` (`login_name`)
|
|
|
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表（管理员）';
|
|
|
|
|
|
|
|
|
|
|
|
2.使用flask-sqlacodegen扩展快速生成ORM model
|
|
|
|
|
|
在orderr目录下输入
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:~renjianbo0118mysql*&;@127.0.0.1/food_db" --tables deviceinfo --outfile "common/models/member/DeviceInfo.py" --flask
|
|
|
|
|
|
|
2023-10-23 00:29:29 +08:00
|
|
|
|
自动生成modles
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables membermiya --outfile "common/models/member/Membermiya.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables member --outfile "common/models/member/Member.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables oauth_member_bind --outfile "common/models/member/Oauth_member_bind.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables mendianusertwo --outfile "common/models/Mendianusertwo.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables mendianuserinfo --outfile "common/models/member/Mendianuserinfo.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:123456@127.0.0.1/food_db" --tables deviceinfo --outfile "common/models/member/DeviceInfo.py" --flask
|
|
|
|
|
|
flask-sqlacodegen " mysql://root:~renjianbo0118mysql*&;@127.0.0.1/food_db" --tables deviceinfo --outfile "common/models/member/DeviceInfo.py" --flask
|
|
|
|
|
|
|
|
|
|
|
|
|
2023-10-23 00:13:06 +08:00
|
|
|
|
3.修改自动生成的model中的db变量 (很重要)
|
|
|
|
|
|
from application import db
|
