Django中的神奇的下劃線(單下劃線和雙下劃線)
- 跨表(別人的表)用雙下劃線,單表(自己的表)就用單下劃線
-
刷新瀏覽器(效果圖)
image.png
image.png
image.png
image.png
image.png
-
元組
image.png
image.png
image.png
image.png
-
代碼(過程)修改的目錄
image.png
- models.py
from django.db import models
# Create your models here.
# class Foo(models.Model):
# name = models.CharField(max_length=1)
# 公司
class Business(models.Model):
# id
caption = models.CharField(max_length=32)
code = models.CharField(max_length=32,null=True,default="SA")
# fk = models.ForeignKey('Foo')
# 主機(jī)
class Host(models.Model):
nid = models.AutoField(primary_key=True)
hostname = models.CharField(max_length=32,db_index=True)
# GenericIPAddressField(Field)字符串類型哗魂，Django Admin以及ModelForm中提供驗(yàn)證 Ipv4和Ipv6
ip = models.GenericIPAddressField(protocol="ipv4",db_index=True)
port = models.IntegerField()
b = models.ForeignKey(to="Business", to_field='id')
- views.py
from django.shortcuts import render,HttpResponse
from app01 import models
# Create your views here.
def business(request):
# 獲取用戶數(shù)據(jù)
v1 = models.Business.objects.all()
# QuerySet
# [obj(id,caption,code),obj(id,caption,code),obj(id,caption,code)]
v2 = models.Business.objects.all().values('id','caption')
# QuerySet
# [{'id':1,'caption':'運(yùn)維部'},{...},{...},]
v3 = models.Business.objects.all().values_list('id', 'caption')
# QuerySet
# [(1,運(yùn)維部),(2,開發(fā))]
return render(request, 'business.html', {'v1': v1, 'v2': v2, 'v3':v3})
def host(request):
# 獲取主機(jī)
v1 = models.Host.objects.filter(nid__gt=0)
# for row in v1:
# sep='\t'字段之間有間隔
# print(row.nid,row.hostname,row.ip,row.port,row.b_id,row.b.caption,row.b.code,row.b.id,sep='\t')
# print(row.b.fk.name)
v2 = models.Host.objects.filter(nid__gt=0).values('nid','hostname','b_id','b__caption')
# print(v2)
for row in v2:
print(row['nid'],row['hostname'], row['b_id'], row['b__caption'])
v3 = models.Host.objects.filter(nid__gt=0).values_list('nid', 'hostname', 'b_id', 'b__caption')
return render(request, 'host.html', {'v1': v1, 'v2':v2, 'v3':v3})
- host.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<h1>業(yè)務(wù)線列表(對象)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>IP</th>
<th>端口</th>
<!--<th>業(yè)務(wù)線ID</th>-->
<th>業(yè)務(wù)線名稱</th>
<!--<th>業(yè)務(wù)線編碼</th>-->
</tr>
</thead>
<tbody>
{% for row in v1 %}
<tr hid="{{ row.nid }}" bid="{{ row.b_id }}">
<!--<td>{{ row.nid }}</td>-->
<td>{{ row.hostname }}</td>
<td>{{ row.ip }}</td>
<td>{{ row.port }}</td>
<!--<td>{{ row.b_id }}</td>-->
<td>{{ row.b.caption }}</td>
<!--<td>{{ row.b.code }}</td>-->
</tr>
{% endfor %}
</tbody>
</table>
<h1>業(yè)務(wù)線列表(字典)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>業(yè)務(wù)線名稱</th>
</tr>
</thead>
<tbody>
{% for row in v2 %}
<tr hid="{{ row.nid }}" bid="{{ row.b_id }}">
<td>{{ row.hostname }}</td>
<td>{{ row.b__caption }}</td>
</tr>
{% endfor %}
</tbody>
</table>
<h1>業(yè)務(wù)線列表(元組)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>業(yè)務(wù)線名稱</th>
</tr>
</thead>
<tbody>
{% for row in v3 %}
<tr hid="{{ row.0 }}" bid="{{ row.2 }}">
<td>{{ row.1 }}</td>
<td>{{ row.3 }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</body>
</html>
image.png
- host.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<h1>主機(jī)列表(對象)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>IP</th>
<th>端口</th>
<!--<th>業(yè)務(wù)線ID</th>-->
<th>業(yè)務(wù)線名稱</th>
<!--<th>業(yè)務(wù)線編碼</th>-->
</tr>
</thead>
<tbody>
{% for row in v1 %}
<tr hid="{{ row.nid }}" bid="{{ row.b_id }}">
<!--<td>{{ row.nid }}</td>-->
<td>{{ row.hostname }}</td>
<td>{{ row.ip }}</td>
<td>{{ row.port }}</td>
<!--<td>{{ row.b_id }}</td>-->
<td>{{ row.b.caption }}</td>
<!--<td>{{ row.b.code }}</td>-->
</tr>
{% endfor %}
</tbody>
</table>
<h1>主機(jī)列表(字典)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>業(yè)務(wù)線名稱</th>
</tr>
</thead>
<tbody>
{% for row in v2 %}
<tr hid="{{ row.nid }}" bid="{{ row.b_id }}">
<td>{{ row.hostname }}</td>
<td>{{ row.b__caption }}</td>
</tr>
{% endfor %}
</tbody>
</table>
<h1>主機(jī)列表(元組)</h1>
<table border="1">
<thead>
<tr>
<!--<th>主機(jī)ID</th>-->
<th>主機(jī)名</th>
<th>業(yè)務(wù)線名稱</th>
</tr>
</thead>
<tbody>
{% for row in v3 %}
<tr hid="{{ row.0 }}" bid="{{ row.2 }}">
<td>{{ row.1 }}</td>
<td>{{ row.3 }}</td>
</tr>
{% endfor %}
</tbody>
</table>
</body>
</html>
