SQLAlchemy get or create

get_or_create.py

def get_or_create(session, model, defaults=None, **kwargs):
	"""
	Get or create a model instance while preserving integrity.
	"""
	try:
		return session.query(model).filter_by(**kwargs).one(), False
	except NoResultFound:
		if defaults is not None:
			kwargs.update(defaults)
		try:
			with session.begin_nested():
				instance = model(**kwargs)
				session.add(instance)
				return instance, True
		except IntegrityError:
			return session.query(model).filter_by(**kwargs).one(), False