Django视图之ORM连表操作一
1 项目路径结构树
2 models创建类
from django.db import models class UserType(models.Model): ''' 用户类型 ''' title = models.CharField(max_length=12) class UserInfo(models.Model): ''' 用户表 ''' name = models.CharField(max_length=16) age = models.IntegerField() ut = models.ForeignKey('UserType')
CharField :char类型
IntegerField: int类型
ForeignKey: 关联表
3 检测app是否注册项目
添加app01
4 初始化数据库
初始化db.sqlite3数据库
1.创建表结构
>>python manage.py makemigrations Migrations for 'app01': app01\migrations\0001_initial.py - Create model UserInfo - Create model UserType - Add field ut to userinfo
2. 初始化数据库
>> python manage.py migrate Operations to perform: Apply all migrations: admin, app01, auth, contenttypes, sessions Running migrations: Applying contenttypes.0001_initial... OK Applying auth.0001_initial... OK Applying admin.0001_initial... OK Applying admin.0002_logentry_remove_auto_add... OK Applying app01.0001_initial... OK Applying contenttypes.0002_remove_content_type_name... OK Applying auth.0002_alter_permission_name_max_length... OK Applying auth.0003_alter_user_email_max_length... OK Applying auth.0004_alter_user_username_opts... OK Applying auth.0005_alter_user_last_login_null... OK Applying auth.0006_require_contenttypes_0002... OK Applying auth.0007_alter_validators_add_error_messages... OK Applying auth.0008_alter_user_username_max_length... OK Applying sessions.0001_initial... OK
5 创建表数据
1) urls映射关系
urlpatterns = [ url(r'^create_data/', views.create_data), ]
2) 创建视图函数
from django.shortcuts import render,redirect,HttpResponse from app01 import models # Create your views here. def create_data(request): '''创建书籍''' #models.UserType.objects.create(title='普通用户') #models.UserType.objects.create(title='白金用户') #models.UserType.objects.create(title='砖石用户') '''创建用户''' #models.UserInfo.objects.create(name='alex',age=32,ut_id=1) #models.UserInfo.objects.create(name='egon',age=42,ut_id=2) #models.UserInfo.objects.create(name='yuan',age=32,ut_id=3) #models.UserInfo.objects.create(name='naza',age=32,ut_id=1) '''获取数据''' result = models.UserInfo.objects.all() for obj in result: print(obj.name,obj.age)
return HttpResponse('...')
''' alex 32 egon 42 yuan 32 naza 32 '''
跨表操作获取数据
result = models.UserInfo.objects.all() for obj in result: print(obj.name,obj.age,obj.ut.title) alex 32 普通用户 egon 42 白金用户 yuan 32 砖石用户 naza 32 普通用户
6 访问初始化数据
http://127.0.0.1:8000/create_data/