如何在Flask Eve中插入有记录和列表的记录?
我正在使用Flask-Eve为我的数据提供一个API。我想用Eve来插入我的记录,这样我就可以得到一个_created属性和其他Eve添加的属性。如何在Flask Eve中插入有记录和列表的记录?
我的两个字段是字典,一个是列表。当我试图将它插入伊娃时,结构似乎变得平坦,失去了一些信息。试图告诉夏娃字典&列表元素给我一个POST错误,说这些字段需要是字典和列表,但他们已经是!请有人可以帮我&告诉我我做错了什么?
我夏娃的conf是这样的:
'myendpoint': { 'allow_unknown': True,
'schema': { 'JobTitle': { 'type': 'string',
'required': True,
'empty': False,
'minlength': 3,
'maxlength': 99 },
'JobDescription': { 'type': 'string',
'required': True,
'empty': False,
'minlength': 32,
'maxlength': 102400 },
},
},
但是当我发布以下结构使用要求:
{
"_id" : ObjectId("56e840686dbf9a5fe069220e"),
"Salary" : {
"OtherPay" : "On Application"
},
"ContactPhone" : "xx",
"JobTypeCodeList" : [
"Public Sector",
"Other"
],
"CompanyName" : "Scc",
"url" : "xx",
"JobTitle" : "xxx",
"WebAdID" : "TA7494725_1_1",
"JobDescription" : "xxxx",
"JobLocation" : {
"DisplayCity" : "BRIDGWATER",
"City" : "BRIDGWATER",
"StateProvince" : "Somerset",
"Country" : "UK",
"PostalCode" : "TA6"
},
"CustomField1" : "Permanent",
"CustomField3" : "FTJOBUKNCSG",
"WebAdManagerEmail" : "xxxx",
"JobType" : "Full",
"ProductID" : "JCPRI0UK"
}
的交行看起来是这样的:
resp = requests.post(url, data = job)
它得到'变平'并丢失信息从列表和列表:
{
"_id" : ObjectId("56e83f5a6dbf9a6395ea559d"),
"Salary" : "OtherPay",
"_updated" : ISODate("2016-03-15T16:59:06Z"),
"ContactPhone" : "xx",
"JobTypeCodeList" : "Public Sector",
"CompanyName" : "Scc",
"url" : "xxx",
"JobTitle" : "xx",
"WebAdID" : "TA7494725_1_1",
"JobDescription" : "xxx",
"JobLocation" : "DisplayCity",
"CustomField1" : "Permanent",
"_created" : ISODate("2016-03-15T16:59:06Z"),
"CustomField3" : "FTJOBUKNCSG",
"_etag" : "55d8d394141652f5dc2892a900aa450403a63d10",
"JobType" : "Full",
"ProductID" : "JCPRI0UK"
}
我试着更新我的模式说有的字典和列表:
'JobTypeCodeList': { 'type': 'list'},
'Salary': { 'type': 'dict'},
'JobLocation': { 'type': 'dict'},
但后来当我在新的记录文章中,我得到一个错误说
{u'Salary': u'must be of dict type', u'JobTypeCodeList': u'must be of list type', u'JobLocation': u'must be of dict type'},
我已经在POST之前验证过type(job.Salary) == dict
等,所以我不知道如何解决这个问题。虽然我可以将记录直接发布到MongoDB中,但绕过夏娃,如果可能的话,我宁愿使用夏娃。
如果这对其他人有用,我最终通过在Eve中发布一个扁平结构来解决此问题,然后使用on_insert和on_update事件循环键并从中构造对象(和列表) 。
这有点复杂,但它诀窍,现在它已经到位,它使用相当透明。我对象通过夏娃加入到MongoDB中现在有嵌入列表和散列,但他们也得到了方便前夕属性,如_created和_updated,而POST和PATCH请求也打不通夏娃的正常模式进行验证。
唯一真正尴尬的是on_insert和on_update发送稍有不同的参数,所以在下面的代码中有很多重复,我还没有重构。
任何字符可被用作标志:我使用两个下划线以指示哪些应该结束了作为一个单一的对象键/值和两个&字符为值应分成的列表。现在我张贴的结构是这样的:
"Salary__OtherPay" : "On Application"
"ContactPhone" : "xx",
"JobTypeCodeList" : "Public Sector&&Other",
"CompanyName" : "Scc",
"url" : "xx",
"JobTitle" : "xxx",
"WebAdID" : "TA7494725_1_1",
"JobDescription" : "xxxx",
"JobLocation__DisplayCity" : "BRIDGWATER",
"JobLocation__City" : "BRIDGWATER",
"JobLocation__StateProvince" : "Somerset",
"JobLocation__Country" : "UK",
"JobLocation__PostalCode" : "TA6"
"CustomField1" : "Permanent",
"CustomField3" : "FTJOBUKNCSG",
"WebAdManagerEmail" : "xxxx",
"JobType" : "Full",
"ProductID" : "JCPRI0UK"
我的夏娃架构已相应更新,以验证这些新的键名的值。然后在后台,我定义低于该检查输入的键/值,并将其转换为对象/列表,并删除原__和& &数据的功能:
import re
def flat_to_complex(items=None, orig=None):
if type(items) is dict: # inserts of new objects
if True: # just to force indentation
objects = {} # hash-based container for each object
lists = {} # hash-based container for each list
for key,value in items.items():
has_object_wildcard = re.search(r'^([^_]+)__', key, re.IGNORECASE)
if bool(has_object_wildcard):
objects[has_object_wildcard.group(1)] = None
elif bool(re.search(r'&&', unicode(value))):
lists[key] = str(value).split('&&')
for list_name, this_list in lists.items():
items[list_name] = this_list
for obj_name in objects:
this_obj = {}
for key,value in items.items():
if key.startswith('{s}__'.format(s=obj_name)):
match = re.search(r'__(.+)$', key)
this_obj[match.group(1)] = value
del(items[key])
objects[obj_name] = this_obj
for obj_name, this_obj in objects.items():
items[obj_name] = this_obj
elif type(items) is list: # updates to existing objects
for idx in range(len(items)):
if type(items[idx]) is dict:
objects = {} # hash-based container for each object
lists = {} # hash-based container for each list
for key,value in items[idx].items():
has_object_wildcard = re.search(r'^([^_]+)__', key, re.IGNORECASE)
if bool(has_object_wildcard):
objects[has_object_wildcard.group(1)] = None
elif bool(re.search(r'&&', unicode(value))):
lists[key] = str(value).split('&&')
for list_name, this_list in lists.items():
items[idx][list_name] = this_list
for obj_name in objects:
this_obj = {}
for key,value in items[idx].items():
if key.startswith('{s}__'.format(s=obj_name)):
match = re.search(r'__(.+)$', key)
this_obj[match.group(1)] = value
del(items[idx][key])
objects[obj_name] = this_obj
for obj_name, this_obj in objects.items():
items[idx][obj_name] = this_obj
然后我就告诉夏娃运行在插入和更新,其功能是该集合:
app.on_insert_myendpoint += flat_to_complex
app.on_update_myendpoint += flat_to_complex
这实现了我所需要的,并在蒙戈所产生的记录是一样的,从上面的问题的一个(与_created和_updated属性)。这显然不是理想的,但它到达那里,一旦到位就很容易。