作者:秋天的紫丁香 | 来源:互联网 | 2023-05-18 07:11
1.pycharm连接postgresql数据库安装postgresql数据库,记住数据库的用户和密码,在pycharm中的datebase中选择newdatebase,配置pos
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创建数据库表