def get_mapping(domain, mapping_name):
mapping = SqlExtractMapping.by_name(domain, mapping_name)
if not mapping:
mapping = SqlExtractMapping()
mapping.domains = [domain]
mapping.name = mapping_name
return mapping
def get_mapping(domain, mapping_name):
mapping = SqlExtractMapping.by_name(domain, mapping_name)
if not mapping:
mapping = SqlExtractMapping()
mapping.domains = [domain]
mapping.name = mapping_name
return mapping
def get_or_create_mapping(domain, mapping_name, date_range=2):
mapping = SqlExtractMapping.by_name(domain.name, mapping_name)
if not mapping:
mapping = SqlExtractMapping()
mapping.auto_generated = True
mapping.domains = [domain.name]
mapping.name = mapping_name
mapping.active = True
mapping.couch_date_range = date_range
return mapping
def get_or_create_mapping(domain, mapping_name, date_range=2):
mapping = SqlExtractMapping.by_name(domain, mapping_name)
if not mapping:
mapping = SqlExtractMapping()
mapping.auto_generated = True
mapping.domains = [domain]
mapping.name = mapping_name
mapping.active = True
mapping.couch_date_range = date_range
mapping.couch_view_params = {}
mapping.schedule_type = 'hourly'
mapping.schedule_hour = -1
mapping.schedule_day = -1
return mapping
def get_or_create_mapping(domain, mapping_name, date_range=2):
mapping = SqlExtractMapping.by_name(domain, mapping_name)
if not mapping:
mapping = SqlExtractMapping()
mapping.auto_generated = True
mapping.domains = [domain]
mapping.name = mapping_name
mapping.active = True
mapping.couch_date_range = date_range
mapping.couch_view_params = {}
mapping.schedule_type = 'hourly'
mapping.schedule_hour = -1
mapping.schedule_day = -1
return mapping
def create(self):
if not self.name or not self.domains:
raise Exception('Missing name or domains property')
mapping = SqlExtractMapping()
for domain in self.domains:
existing = SqlExtractMapping.by_name(domain, self.name)
if existing:
mapping = existing
break
mapping.active = self.schedule_active
mapping.auto_generated = True
mapping.name = self.name
mapping.domains = self.domains
mapping.couch_view = self.couch_view
mapping.columns = self.columns
self.customize(mapping)
mapping.save()
def edit(request, mapping_id, domain=None, template='ctable/edit_mapping.html'):
if request.method == 'POST':
d = _to_kwargs(request)
if domain and domain not in d['domains']:
d['domains'].append(domain)
mapping = SqlExtractMapping.from_json(d)
if mapping.couch_key_prefix and mapping.couch_key_prefix[0] == '':
mapping.couch_key_prefix = None
# check for unique name
for dom in mapping.domains:
existing = SqlExtractMapping.by_name(dom, mapping.name)
if existing and existing._id != mapping._id:
args = {'domain': dom}
return json_response({'error': _("Mapping with the same name exists "
"in the '%(domain)s' domain.") % args})
mapping.save()
kwargs = {'domain': domain} if domain else {}
return json_response({'redirect': reverse('sql_mappings_list', kwargs=kwargs)})
if mapping_id:
try:
mapping = SqlExtractMapping.get(mapping_id)
except ResourceNotFound:
raise Http404()
else:
mapping = SqlExtractMapping()
return render(request, template, {
'domain': domain,
'mapping': mapping,
'backends': backends()
})
