开发工具
1.PyCharm
2.mysql
新建项目
设计/创建表
1.app -》models
from django.db import models
# 创建表名
class Department(models.Model):
""" 部门表 """
title = models.CharField(max_length=32, verbose_name='标题')
class Employee(models.Model):
""" 员工表 """
gender_choices = (
(1, "男"),
(2, "女")
)
name = models.CharField(max_length=32, verbose_name='姓名')
password = models.CharField(max_length=64, verbose_name='密码')
age = models.IntegerField(verbose_name='年龄')
gender = models.IntegerField(choices=gender_choices, verbose_name='性别')
salary = models.FloatField(verbose_name='薪资', default=0)
create_time = models.DateTimeField(auto_now_add=True, verbose_name='入职时间')
# 级联删除,如果部门删除了 该条记录同时删除
# department = models.ForeignKey(to="Department",to_field="id",on_delete=models.CASCADE,verbose_name='部门id')
# to:与某个表关联 to_field:与表中那一列又关联 如果部门删除 部门ID 制空
department = models.ForeignKey(to="Department", to_field="id", null=True, blank=True, on_delete=models.SET_NULL,
verbose_name='部门id')
在Mysql 生成表
1.点击新建项目 -》工具栏 -》运行 manage.py
- 输入数据库迁移命令 python manage.py makemigrations
- 输入数据库生成 python manage.py migrate