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() })