django 学习之路

离线添加数据库

• ?

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

  # 启动django import os import sys import django   base_dir = os.path.dirname(os.path.dirname(os.path.abspath(__file__))) sys.path.append(base_dir)   os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'day06.settings') django.setup()  # 伪造让django启动   from web import models from utils.encrypt import md5   models.Administrator.objects.create(username='root', password=md5("root"), mobile="1888888889")

  　　

顶端导航

• html文件
  ?

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

  <div class="nav">         <div class="logo-area left">             <a href="{% url 'home' %}">                 <span style="font-size: 18px;">NB的管理平台 </span>             </a>         </div>         <div class="right-menu right clearfix">               <div class="user-info right">                 <a href="#" class="avatar" style="text-decoration: none;">                     <span style="color: white;margin-right: 5px;">{{ request.nb_user.name }}</span>                     <img class="img-circle" style="width: 35px;height: 35px;" src="{% static 'images/default.png' %}">                 </a>                   <div class="more-info">                     <a href="{% url 'logout' %}" class="more-item">注销1</a>                     <a href="{% url 'logout' %}" class="more-item">注销2</a>                     <a href="{% url 'logout' %}" class="more-item">注销3</a>                     <a href="{% url 'logout' %}" class="more-item">注销</a>                 </div>             </div>         </div>     </div>

• css文件

  .nav .right-menu .user-info {
      padding: 0 30px 0 10px;
      height: 48px;
      position: relative;
  }
  
  /* hover 鼠标经过出现*/
  .nav .right-menu .user-info:hover .avatar {
      background-color: #337ab7;
  }
  
  .nav .right-menu .user-info .avatar {
      display: inline-block;
      padding: 0 10px;
      height: 48px;
  }
  
  .nav .right-menu .user-info .avatar img {
      /* margin-top: 2px;*/
  }
  
  .nav .right-menu .user-info .more-info {
      display: none;
      position: absolute;
      top: 48px;
      right: 20px;
      border: 1px solid rgba(0, 0, 0, .15);
      -webkit-box-shadow: 0 6px 12px rgba(0, 0, 0, .175);
      box-shadow: 0 6px 12px rgba(0, 0, 0, .175);
      background-color: #fff;
      color: #333;
      z-index: 1002;
  }
  
  .nav .right-menu .user-info:hover .more-info {
      display: block;
  }
  
  .nav .right-menu .user-info .more-info .more-item {
      display: block;
      min-width: 160px;
      padding: 0 15px;
      line-height: 35px;
      text-decoration: none;
      color: #000000;
  
  }
  
  .nav .right-menu .user-info .more-info .more-item:hover {
      background-color: #f1f0f0;
  }

展示效果：   

 前端路径导航点击直接跳转

text_list = [] 

# 将级别text和别名存储在text_list
text_list.append([user_permission_dict[current_name]['text'], current_name])

menu_name = current_name
while user_permission_dict[menu_name]['parent']:
      menu_name = user_permission_dict[menu_name]['parent']
      text = user_permission_dict[menu_name]['text']
      text_list.append([text, menu_name])

text_list.append(["首页", "home"])

text_list.reverse()  # 列表反转

中间件

 {#  路径导航#}
{% if request.nb_user.text_list %}
        <ol class="breadcrumb">
              {% for text in request.nb_user.text_list %}
                  {#  获取级别《路径》text和别名《转换成url》#}
                  {% if text.1 %}
                        <li><a href="{% url text.1 %}">{{ text.0 }}</a></li>
                  {% else %}
                        <li><a>{{ text.0 }}</a></li>
                  {% endif %}

                {% endfor %}
          </ol>
{% endif %}

 

　　手机号验证的3种方式：

• ?

  1 2 3 4 5 6

  # forms验证 mobile = forms.CharField(         label="手机号",         required=True,         validators=[RegexValidator(r'^1\d{10}$', '手机格式错误'), ]     )

• ?

  1 2 3 4 5 6 7 8

  # forms验证方法： def clean_mobile():     mobile = self.cleaned_data['mobile']     import re     from django.core.exceptions import ValidationError     if not re.match(r'^\d{11}$',mobile):         raise ValidationError("格式错误")     return mobile

• ?

  1 2 3

  # models.py表类中 mobile = models.CharField(verbose_name="手机号", max_length=11, db_index=True,                               validators=[RegexValidator(r'^\d{11}$', '手机号格式错误'), ])

 serialize() 前端直接取form表单的data，包含csrf_token

• ?

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

  <form class="form-horizontal" id="addForm">     {% csrf_token %}     {% for field in form %}         <div class="form-group">             <label class="col-sm-2 control-label">{{ field.label }}</label>             <div class="col-sm-10" style="position: relative;margin-bottom: 25px">                 {{ field }}                 <span class="error-message" >{{ field.errors.0 }}</span>             </div>         </div>     {% endfor %} </form>       $.ajax({     url: "{% url 'customer_charge_add' pk=pk %}",     type: 'POST',     data: $("#addForm").serialize(),     dataType: "JSON",     success: function (res) {         console.log(res);         if (res.status) {             window.location.reload();         } else {             $.each(res.detail, function (k, v) {                 $("#id_" + k).next().text(v[0]);             })         }     } })

   事务（上下文操作） -> 原子性操作

• （多用在交易记录，需要操作两个或多个表，要成功都成功，要失败都失败）

•  
  ?

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

  from django.db import transaction try:     # 事务，上下文管理。     with transaction.atomic():         # 1.对当前操作的客户进行更新操作，账户余额：增加、减少 + 锁         cus_object = models.Customer.objects.filter(id=pk, active=1).select_for_update().first()           if charge_type == 2 and cus_object.balance < amount:             return JsonResponse(                 {'status': False, 'detail': {"amount": ["余额不足，账户总余额只有:{}".format(cus_object.balance)]}})         elif amount <= 0:             return JsonResponse({'status': False, 'detail': {"amount": ["金额不能小于等于0"]}})           if charge_type == 1:             cus_object.balance = cus_object.balance + amount         else:             cus_object.balance = cus_object.balance - amount         cus_object.save()           # 2.交易记录         form.instance.customer = cus_object         form.instance.creator_id = request.nb_user.id         form.save()   except Exception as e:     return JsonResponse({'status': False, 'detail': {"amount": ["操作失败"]

　　锁 

• 数据库排他锁 elect_for_update()   锁和事务结合使用，事务结束释放锁，再进行下一个事务
• ?

  1 2	# 1.对当前操作的客户进行更新操作，账户余额：增加、减少 + 锁s cus_object = models.Customer.objects.filter(id=pk, active=1).select_for_update().first()