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
