在資料庫django中用特殊字符定義特定數字的最佳方法是什么

我對 Django 模型欄位有特定要求，本質上我想創建這種型別的系列：

0025-0007

基本上是 4 個整數欄位，一個字符，然后是 4 個整數欄位，隨著數字的變化，我不需要自動遞增，Django 中是否有可用的東西來處理這些欄位，最好是自動驗證的東西？

@login_required
def close_lead(request):
    if request.method == 'POST':

        deal_form = NewDealForm(request.POST)

        if deal_form.is_valid():
            deal_form.save()
            id = request.GET.get('project_id', '')
            obj = Leads.objects.get(project_id=id)
            obj.status = "Closed"
            obj.save(update_fields=['status'])
            ## Changing the Forecast Table Entry
            forecast = LeadEntry.objects.filter(lead_id=id)
            for i in forecast:
                m = i
                m.stage = "Deal"
                m.save(update_fields=['stage'])
            messages.success(request, 'You have successfully updated the status from open to Close')
            return HttpResponseRedirect(reverse('dashboard'))

        else:
            messages.error(request, 'Error updating your Form')

    id = request.GET.get('project_id', '')
    keys = Leads.objects.select_related().get(project_id=id)
    form_dict = {'project_id': keys.project_id,
                     'agent': keys.agent,
                     'client': keys.point_of_contact,
                     'company': keys.company,
                     'service': keys.services,
                     'licenses': keys.expected_licenses,
                     'country_d': keys.country
                     }

    form = NewDealForm(initial=form_dict)

    return render(request,
                  "account/close_lead.html",
                  {'form': form})

## HTML 
{% extends "base.html" %}
{% load crispy_forms_tags %}
{% load static %}
{% block title %}Close Lead{% endblock %}
{% block content %}


  <h1>Close a Lead</h1>
<div class="Myform">
  <form method="post" id="close-lead">
      {% csrf_token %}
      <div class="row">
           <div class="col-sm-6">
            <div class="form-row">
              <div class="form-group col-md-6">
                  {{ form.project_id|as_crispy_field }}
                  {{ form.agent|as_crispy_field }}
                  {{ form.sales_order|as_crispy_field }}
              </div>
            </div>

            <div class="form-row">
              <div class="form-group col-md-6">
                  {{ form.company|as_crispy_field }}
                  {{ form.country_d|as_crispy_field }}
              </div>
              <div class="form-group col-md-6">
                  {{ form.client|as_crispy_field }}

              </div>
            </div>
            <div class="form-row">
              <div class="form-group col-md-6">
                  {{ form.service|as_crispy_field }}
                  {{ form.revenue|as_crispy_field }}
                  {{ form.comments|as_crispy_field }}
              </div>
              <div class="form-group col-md-6">
                  {{ form.licenses|as_crispy_field }}

              </div>
            </div>


           </div>
      </div>
      <input type="submit" value="Create Deal">
  </form>



{% endblock %}

uj5u.com熱心網友回復：

您可以定義一個驗證器并使用 aCharField和 a RegexValidator[Django-doc]：

from django.db import models
from django.core.validators import RegexValidator

class MyModel(models.Model):
    my_field = models.CharField(
        max_length=9,
        validators=[RegexValidator(r'\d{4}.\d{4}', 'The value should be four digits, a character and four digits')]
    )

如果四位數字之間的分隔符始終是連字符，請r'\d{4}-\d{4}'改用。

標籤：姜戈 数据库 django 模型 模型

上一篇：SQL查詢（至少）

下一篇：使用OracleSQLDeveloper匯出資料庫