Django入门-配置Django1.x环境

1、安装

 

 

 备注：pymysql也要安装

2、创建项目

django-admin startproject mysite

python manage.py startapp app01

添加项目

 

 

 

 

3、修改基本配置

3.1微调参数

 

 

 

 

 

 

 

 

 

 

STATICFILES_DIRS = (
    os.path.join(BASE_DIR,'static'),
)

 

3.2设置数据库

注册应用

 

 

 

 注释上面的默认设置

创建数据库后，修改为如下代码示例 

DATABASES = {

    'default': {

    'ENGINE': 'django.db.backends.mysql',

    'NAME':'s4db70db',

    'USER': 'dever',

    'PASSWORD': 'dever1234',

    'HOST': '192.168.56.33',

    'PORT': '3306',

    }

}

调整参数

 设计表

 

 

from django.db import models

# Create your models here.
#
# class Foo(models.Model):
#     caption = models.CharField(max_length=16)

class UserType(models.Model):
    """
    y用户类型
    """
    title = models.CharField(max_length=32)
    # fo = models.ForeignKey('Foo')

class UserInfo(models.Model):
    """
    用户表
    """
    name = models.CharField(max_length=16)
    age = models.IntegerField()
    ut = models.ForeignKey('UserType')

表结构同步到数据库

 

 

 单表的常用操作

 

####创建数据
    # models.UserType.objects.create(title='普通用户')
    # models.UserType.objects.create(title='高级用户')
    # models.UserType.objects.create(title='VIP用户')
    # models.UserType.objects.create(title='VVIP用户')
    # models.UserInfo.objects.create(name='如花',age=18,ut_id=1)
    # models.UserInfo.objects.create(name='铁锤',age=18,ut_id=2)
    # models.UserInfo.objects.create(name='旺财',age=18,ut_id=2)
    # models.UserInfo.objects.create(name='小强',age=18,ut_id=3)
    # models.UserInfo.objects.create(name='方块',age=18,ut_id=3)
    # models.UserInfo.objects.create(name='烧饼',age=18,ut_id=1)
    # models.UserInfo.objects.create(name='小蘑菇',age=18,ut_id=4)

    ###获取 ##  里面是query对象  外面是query列表
    # result = models.UserInfo.objects.all()
    # for obj in result:
    #     print(obj.name,obj.age,obj.ut_id,obj.ut.title)

    #UserInfo  ut是外键 --  正向操作
    # obj = models.UserInfo.objects.all().first()
    # print(obj.name,obj.age,obj.ut.title)

    ###UserType 表明小写_set.all()    --- 反向操作
    # obj = models.UserType.objects.all().first()
    # print('用户类型',obj.title,obj.id)
    # for row in obj.userinfo_set.all():
    #     print(row.name,row.age)
    # print("db test end")

    # result = models.UserType.objects.all()
    # for item in result:
    #     # print(item.title,item.userinfo_set.all())
    #     print(item.title,item.userinfo_set.filter(name='如花'))

    # result =  models.UserInfo.objects.all().values('id','name')
    # ##result  变为字典
    # for row in result:
    #     print(row)

    result =  models.UserInfo.objects.all().values_list('id','name')
    ##result 元组
    for row in result:
        print(row)

    # ###数据库获取多数据时
    # 1、[obj,obj,obj,]
    # models.UserInfo.objects.all()
    # models.UserInfo.objects.filter(ut_id__gt=1)

    # 2.[{id:1,name:fd}，{id:1,name:fd},{id:1,name:fd},]
    # models.UserInfo.objects.all().values('id','name')
    # models.UserInfo.objects.filter(id__gt=1).values('id','name')
    #
    # 3.[(1,fd)，(2,fd)]
    # models.UserInfo.objects.all().values_list('id','name')
    # models.UserInfo.objects.filter(id__gt=1).values_list('id','name')


    print("db test end")
    return  HttpResponse('test ok ')

 

 

3.3 创建超级用户

 

 

python manage.py createsuperuser

 

 

 

 

 

 

3.4 配置服务器ip访问

manage.py runserver 0.0.0.0:8000