在数据库中定义具有特殊字符的特定数字的最佳方法是什么 django

Question

我对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 %}

Answer 1

您可以定义一个验证器，并使用CharField和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}'。