gpt4 book ai didi

python - 在 Django 数据库中查找电话号码后添加其他字段

转载 作者:行者123 更新时间:2023-12-01 08:18:43 26 4
gpt4 key购买 nike

我正在构建一个应用程序来查找数据库中的每个电话号码。如果有任何重复项,我想获取第一个找到的电话号码作为该电话号码的主记录,然后对于重复信息(姓名、位置),获取这些字段中的每一个,并将其添加到主记录电话中数字字段(名称、位置),以分号分隔。

检查找到的主电话号码记录的重复信息后,结果如下所示:

Name                      Location               Phone number
Helene,Sandra New Yok, Boston 000-000

请在下面找到我的型号:

class Document(models.Model):
name = models.CharField(null=True, max_length=254, blank=True)
location = models.CharField(null=True, max_length=254, blank=True)
phone_number = models.CharField(null=True, max_length=254, blank=True)

我对实现上述目标有点迷失。任何帮助将不胜感激。

以下是我迄今为止尝试过的:(不起作用)

 from django.shortcuts import render
from .models import Document

def index(request):
search_number = list(Document.objects.order_by('-created').values("phone_number").distinct().order_by()) # Dictionary list of all numbers sorted by creation data without duplicate

for x in search_number:
try:
look_up = Document.objects.values("phone_number")
list_in_dba = look_up.phone_number
x in list_in_dba['phone_number']
print("Yes")
except:
print("No")

return render(request, 'snippets/index.html')

最佳答案

我会从这样的事情开始。

## this will get you all document records that have a duplicate phone-number 
## and also group them by phone-number.
duplicate_phone_numbers = Document.objects.values('phone_number').\
annotate(total_items=Count('phone_number')).order_by('-total_items').filter(total_items__gt=1)

for entry in duplicate_phone_numbers:
records = Document.objects.filter(phone_number=entry.get('phone_number')
## unsure whether you want to just output the info here or
## update the actual record
all_names = ''
all_locations = ''
for x in records:
all_names += x.name + ";"
all_locations += x.location + ";"
print all_names, all_locations, entry.get('phone_number')
# to update the actual record
record = records[0]
record.name = all_names
record.location = all_locations
record.save()

关于python - 在 Django 数据库中查找电话号码后添加其他字段,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/54817674/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com