500 Response When Triggering Wildcard in List NotImplementedError

[meksor]

The error is thrown here:

ixmp4/ixmp4/db/filters.py

Line 363 in c243743

raise NotImplementedError("Filter by list with wildcard is not implemented")

and should probably be a custom Ixmp4Error to produce a 404 response.

[danielhuppmann]

Looks like I implemented that a while ago because the "expanded" filter had to be either __in for a list or __like for a string.

Would it make sense to do do something like

  _value = []
  for v in value:
      if "*" in v:
          _value.add(<get list that matches v  on the "upstream" repository>)
      else:
           _value.append(v)
   return dict(name__in=_value)

But I'm not sure what's an efficient way to implement <get list that matches v>.

[meksor]

The best way I can think of implementing this is by making a second in_() filter function like this one:

ixmp4/ixmp4/db/filters.py

Lines 18 to 21 in c243743

	def in_(
	c: db.typing_column[in_Type], v: Iterable[in_Type] | db.BindParameter[in_Type]
	) -> db.BinaryExpression[bool]:
	return c.in_(v)

Which parses the list if values (i guess this only works for strings) and builds a complex sql query from the list.
The best way to build the query is probably by filtering out all entries containing wildcards and building a query like:

SELECT ... FROM table WHERE
column IN ("no wildcard", "simple name", "single model")
OR 
column LIKE "wildcard %query"
OR 
column LIKE "Model %";