How to pass dynamic amount of optional parameters to Python function

Question

I have a function that is being used with 2 optional parameters offset and limit:

query = db.engine.execute(sql, offset=pagination.offset, limit=pagination.limit)

Is there a way I can pass it a list of dynamic parameters? Something like this:

db.engine.execute(sql, param_obj)

Sunitha · Accepted Answer · 2018-07-09 10:49:23Z

3

You can build the optional parameters as a dict and pass it to the function

param_obj = dict(offset=pagination.offset, limit=pagination.limit)
db.engine.execute(sql, **param_obj)

Or if you really want to pass the optional paraemters as list, you can, but care should be taken to ensure the order of parameters being passed

param_obj = [pagination.offset, pagination.limit]
db.engine.execute(sql, *param_obj)

answered Jul 9, 2018 at 10:49

Sunitha

12.1k2 gold badges23 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1