Any #python or #sqlalchemy people out there know if there's a easier way to do this:

a = session.query(Object).filter(Object.id == id).one_or_none()
if not a:
a = Object(id=id, **kwargs)

#do something with a, which was either the already existing object, or a new object created

one thing I would love for python is to be able to say
if not s := some_query(args):
stuff if the query fails
else:
stuff if the query succeeds and you have s assigned

#python #walrus #walrusoperator