Does SQLAlchemy have an equivalent of Django’s get_or_create?

by

Following the solution of @WoLpH, this is the code that worked for me (simple version):

def get_or_create(session, model, **kwargs):
    instance = session.query(model).filter_by(**kwargs).first()
    if instance:
        return instance
    else:
        instance = model(**kwargs)
        session.add(instance)
        session.commit()
        return instance

With this, I’m able to get_or_create any object of my model.

Suppose my model object is :

class Country(Base):
    __tablename__ = 'countries'
    id = Column(Integer, primary_key=True)
    name = Column(String, unique=True)

To get or create my object I write :

myCountry = get_or_create(session, Country, name=countryName)

More Related Contents:

  1. What is related_name used for?
  2. Using django for CLI tool
  3. django html template can’t find static css and js files
  4. Executing multiple statements with Postgresql via SQLAlchemy does not persist changes
  5. memory-efficient built-in SqlAlchemy iterator/generator?
  6. How do I include image files in Django templates?
  7. Bulk Insert A Pandas DataFrame Using SQLAlchemy
  8. difference between filter with multiple arguments and chain filter in django
  9. Adding a user to a group in django
  10. django installation: cannot use pip to install django on linux(ubuntu)
  11. Django Blob Model Field
  12. Django URL Redirect
  13. Import Error: No module named django
  14. Fatal Python error: init_fs_encoding: failed to get the Python codec of the filesystem encoding, when trying to start uwsgi
  15. django import error – No module named core.management
  16. Meaning of leading underscore in list of tuples used to define choice fields?
  17. -bash: ./manage.py: Permission denied
  18. Easiest way to rename a model using Django/South?
  19. CSRF verification failed. Request aborted
  20. How to use jinja2 as a templating engine in Django 1.8
  21. SQLAlchemy Joinedload filter column
  22. SQLAlchemy func.count on boolean column
  23. no module named urllib.parse (How should I install it?)
  24. How to remove a field from the parent Form in a subclass?
  25. pandas to_sql all columns as nvarchar
  26. Remove non-ASCII characters from a string using python / django
  27. Django Tastypie: How to Authenticate with API Key
  28. Deploying Django to Heroku (Psycopg2 Error)
  29. Using SimpleXMLTreeBuilder in elementtree
  30. add column to SQLAlchemy Table

Leave a Comment