def to_sql_values(self): if self._is_dyn_date(): start_date, end_date = get_daterange_start_end_dates( self.value['operator'], *self.value['operand']) return { get_INFilter_element_bindparam(self.filter['slug'], i): str(v) for i, v in enumerate([start_date, end_date]) } elif self._is_empty() or self._is_exists(): if self.filter.get('datatype') in [ DATA_TYPE_DATE, DATA_TYPE_DATETIME ]: # Both == '' and != '' do not work for dates in postgres so the expression should only be for NULL # checks that get added later. Hence don't return any comparison for value here return {} else: return { self.filter['slug']: '', } elif self._is_list(): # Array params work like IN bind params return { get_INFilter_element_bindparam(self.filter['slug'], i): v for i, v in enumerate(self.value['operand']) } else: return {self.filter['slug']: self.value['operand']}
def to_sql_values(self): if self.show_all or self.is_null: return {} return { get_INFilter_element_bindparam(self.filter.slug, i): val.value for i, val in enumerate(self.value) }
def to_sql_values(self): if self.show_all: return {} return { get_INFilter_element_bindparam(self.filter.slug, i): val for i, val in enumerate([None] if self.show_none else self.value) }
def to_sql_values(self): if self.show_all or self.is_null: return {} return { get_INFilter_element_bindparam(self.filter.slug, i): val.value for i, val in enumerate(self.value) }
def clean_IN_filter_value(filter_values, filter_value_name): if filter_value_name in filter_values: for i, val in enumerate(filter_values[filter_value_name]): filter_values[get_INFilter_element_bindparam(filter_value_name, i)] = val del filter_values[filter_value_name] return filter_values
def to_sql_values(self): if self._is_dyn_date(): start_date, end_date = get_daterange_start_end_dates(self.value['operator'], *self.value['operand']) return { get_INFilter_element_bindparam(self.filter.slug, i): str(v) for i, v in enumerate([start_date, end_date]) } elif self._is_null(): return {} elif self._is_list(): # Array params work like IN bind params return { get_INFilter_element_bindparam(self.filter.slug, i): v for i, v in enumerate(self.value['operand']) } else: return {self.filter.slug: self.value['operand']}
def to_sql_values(self): if self._is_dyn_date(): start_date, end_date = get_daterange_start_end_dates(self.value['operator'], *self.value['operand']) return { get_INFilter_element_bindparam(self.filter.slug, i): str(v) for i, v in enumerate([start_date, end_date]) } elif self._is_null(): return {} elif self._is_list(): # Array params work like IN bind params return { get_INFilter_element_bindparam(self.filter.slug, i): v for i, v in enumerate(self.value['operand']) } else: return {self.filter.slug: self.value['operand']}
def update_config(config): try: group = Group.get('daa2641cf722f8397207c9041bfe5cb3') users = group.users except ResourceNotFound: users = [] config.update({'users': users}) config.update(dict({get_INFilter_element_bindparam('owner_id', idx): val for idx, val in enumerate(users, 0)}))
def to_sql_values(self): if self.show_all or self.is_null: return {} case_ids = self._get_case_ids() values = { get_INFilter_element_bindparam(self.filter['slug'], i): val.value for i, val in enumerate(case_ids) } return values
def to_sql_values(self): if self.show_all: return {} values = { get_INFilter_element_bindparam(self.filter['slug'], i): val for i, val in enumerate([None] if self.show_none else self.value) } if self._ancestor_filter: values.update(self._ancestor_filter.sql_value()) return values
def update_config(config): try: group = Group.get('daa2641cf722f8397207c9041bfe5cb3') users = group.users except ResourceNotFound: users = [] config.update({'users': users}) config.update( dict({ get_INFilter_element_bindparam('owner_id', idx): val for idx, val in enumerate(users, 0) }))
def to_sql_values(self): if self.show_all: return {} values = { get_INFilter_element_bindparam(self.filter['slug'], i): val.value for i, val in enumerate(self._get_value_without_nulls()) } if self.is_null: values[get_null_empty_value_bindparam(self.filter['slug'])] = '' if self._ancestor_filter: values.update(self._ancestor_filter.sql_value()) return values
def clean_IN_filter_value(filter_values, filter_value_name): if filter_value_name in filter_values: for i, val in enumerate(filter_values[filter_value_name]): filter_values[get_INFilter_element_bindparam(filter_value_name, i)] = val del filter_values[filter_value_name] return filter_values