Python Web框架(URL/VIEWS/ORM)

url(r'^login/',views.login)

url(r'^index-(\d+).html',views.index)
url(r'^index-(?P<nid>\d+)-(?P<uid>\d+).html',views.detail)
def detail(request,*args,**kwargs):
pass

url(r'^login/',views.login,name='login_01')
url(r'^login/(\d+)',views.login,name='login_01')
模板内容：
{% "login_01" %}
{% "login_01" 3 %}

需要导入inclue:
from django.conf.urls import include, url
url(r'^cmdb/',include("app01.urls"))

request.POST.get()    ##获取单个文本值
request.POST.getlist()    ##获取多个问本值
request.FILES.get()    ##获取上传文件内容 <input type='file' name='file_name'>
obj = request.FILES.get('file_name')
path = os.path.join('upload', obj.name)
f = open(path, mode="wb")
for i in obj.chunks():
f.write(i)
f.close()

FBV:function based views
CBV:class based views

from django.db import models

# Create your models here.
class UserInfo(models.Model):
##隐含创建id列，主键自增
username=models.CharField(max_length=32)
password=models.CharField(max_length=64)

from cmdb import models
def orm(request):
models.UserInfo.objects.create(
username='root',password='123')
return HttpResponse('orm')
或者
obj=models.UserInfo(username='root',password='123')
obj.save()

result=models.UserInfo.objects.all()
for row in result:
print(row.id,row.username,row.password)
result=models.UserInfo.objects.filter(username='root')

a.列表形式
v1=models.UserInfo.objects.all()

html渲染方式：
{% for row in v1 %}
{{row.id}}-{{row.username}}-{{row.code}}
{% endfor %}

b.字典形式

v2=models.UserInfo.objects.all().values('id','username')
html渲染方式：
{% for row in v2 %}
{{row.id}}-{{row.username}}}
{% endfor %}
c.元组形式
v3=models.UserInfo.objects.all().value_list('id','username')
html渲染方式：
{% for row in v3 %}
{{row.0}}-{{row.1}}
{% endfor %}
return render(request,'index.html',{'v1':v1,'v2':v2,'v3':v3})

models.UserInfo.objects.filter(username='root').delete()

models.UserInfo.objects.filter(username='root').update(password='222')

b=models.ForeignKey(to="UserInfo",to_field='id')

字符串    models.CharField    字符串字段，不必须设置max_length参数
models.EmailField
models.IPAddressField IPV4
models.GenericIPAddressField IPV4和IPv6
models.TextField
数字    models.FloadField
models.IntegerField
models.BigIntegerField
models.Decimal    十进制小数类型，必须指定整数位max_digits和小数位max_places
models.SmallInteger    

时间    models.DateField    日期类型，对于auto_time=now，每次更新都会更新这个时间;auto_now_add则只是第一次创建添加，之后更新不在改变
models.DateTimeField
models.TimeField
二进制    models.BinaryField    
布尔    models.BoolenField    布尔类型=tinyint(1),不能为空，Blank=True
models.NullBoolenField    允许为空的布尔类型

自增    models.AutoField    自增列=int(11) 默认自动创建id自增主键，如果显示设置自增列必须设置其为主键
其他类型    models.ImageField    图片
models.FilePathField    文件    
models.ForeignKey("参考主键表",to_field='主键表列')

null:    DB是否可以为空
default:    默认值
primary_key:    主键,primary_key=True
db_column:    列名
db_index:    索引，db_index=True
unique:    唯一索引,unique=True
unique_for_date:    
unique_for_month:
unique_for_year:
choices:    django admin中显示下拉框，避免连表查询
auto_now:    更新时自动生成
auto_now_add:    创建时自动生成
blank:    django admin表示是否为空
verbose_name:    django admin显示字段中文
editable:    django admin控制是否被编辑
error_message:    django admin自定义报错信息
help_text:    django admin帮助信息
validators:    django admin自定义错误信息

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
}
}
其他支持的数据源配置：

'django.db.backends.postgresql_psycopg2'
'django.db.backends.mysql'
'django.db.backends.sqlite3'
'django.db.backends.oracle'

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'mydatabase',
'USER': 'mydatabaseuser',
'PASSWORD': 'mypassword',
'HOST': '127.0.0.1',
'PORT': '5432',
}
}

INSTALLED_APPS = (
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'cmdb',
)    

python manage.py makemigrations
Migrations for 'cmdb':
0001_initial.py:
- Create model UserInfo

python manage.py migrate
Operations to perform:
Synchronize unmigrated apps: messages, staticfiles
Apply all migrations: cmdb, sessions, auth, admin, contenttypes
Synchronizing apps without migrations:
Creating tables...
Running deferred SQL...
Installing custom SQL...
Running migrations:
Rendering model states... DONE
Applying cmdb.0001_initial... OK

$.ajax({
url:'/host'
type:"POST"
data:{'k1':123,'k2':"root"},
success:function(data){

})

}