1.pycharm 连接postgresql 数据库
安装postgresql数据库,记住数据库的用户和密码,在pycharm中的datebase中选择new datebase ,配置postgresql,测试连接是否成功
在pycharm 文件选项打开preferences,找到project interperter,选择你本机的python位置,添加psycopg2和psycopg2-binary,django,pycharm会自己下载。
2.在setting.py中配置,INSTALLED_APPS和MIDDLEWARE,创建的默认项目一般不需要修改
若是新增app 则在INSTALLED_APPS中新增 字段 'yourappname',
3. 创建模型,给数据库建表,修改models.py
# -*- coding: utf-8 -*- from __future__ import unicode_literals from django.db import models # Create your models here. class Publisher(models.Model): name = models.CharField(max_length=30) address = models.CharField(max_length=50) city = models.CharField(max_length=60) state_province = models.CharField(max_length=30) country = models.CharField(max_length=50) website = models.URLField() class Author(models.Model): first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=40) email = models.EmailField() class Book(models.Model): title = models.CharField(max_length=100) authors = models.ManyToManyField(Author) publisher = models.ForeignKey(Publisher) publication_date = models.DateField()
在pycharm终端中输入python manage.py makemigrations website
随后输入python manage.py sqlmigrate website 0001可以看到生成的sql语句
随后输入python manage.py migrate创建数据库表