Djiango入门(四),使用MySQL数据库

- 日理万妓 2024-04-17 16:30 62阅读 0赞

1.本地环境安装pymysql  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70]  
pip install pymysql

2.项目init.py 引入pymysql  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 1]

import pymysql
    
    pymysql.install_as_MySQLdb()

3.配置项目中settings.py  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 2]

DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.mysql',
            'NAME': 'test',
            'USER': 'root',
            'PASSWORD': '123456',
            'HOST': '127.0.0.1',
            'PORT': '3306',
        }
    }

4.创建模型类  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 3]

from django.db import models
    
    
    # Create your models here.
    
    class BookInfo(models.Model):
        btitle = models.CharField(max_length=20)
        bpub_date = models.DateTimeField(db_column='pub_date')
        bread = models.IntegerField(default=0)
        bcomment = models.IntegerField(default=0)
        isDelete = models.BooleanField(default=True)
    
        class Meta:
            db_table = 'bookInfo'
    
    
    class HerInfo(models.Model):
        hname = models.CharField(max_length=20)
        hgender = models.BooleanField(default=True)
        hcontent = models.CharField(max_length=1000)
        isDelete = models.BooleanField(default=False)
        book = models.ForeignKey(BookInfo,on_delete=models.CASCADE)

5.创建迁移文件  
python manage.py makemigrations  
6.执行迁移  
python manage.py migrate  
7.查看数据库  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 4]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/683c474bc2904c889e5a9af9c3193386.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/6e5a352cafbc4834aa8d1360ccb7c23a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/f2421ffa501e47008fec855ecc6dfc77.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/4d78d999e7204111851cf574093ecb86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzgzMTc2_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/2758ef4bf022472ba842289300594f73.png