What are some good Python ORM solutions? [closed]

by

If you’re looking for lightweight and are already familiar with django-style declarative models, check out peewee:
https://github.com/coleifer/peewee

Example:

import datetime
from peewee import *

class Blog(Model):
    name = CharField()

class Entry(Model):
    blog = ForeignKeyField(Blog)
    title = CharField()
    body = TextField()
    pub_date = DateTimeField(default=datetime.datetime.now)

# query it like django
Entry.filter(blog__name="Some great blog")

# or programmatically for finer-grained control
Entry.select().join(Blog).where(Blog.name == 'Some awesome blog')

Check the docs for more examples.

More Related Contents:

  1. Filter by property
  2. Using only the DB part of Django
  3. SQL Alchemy ORM returning a single column, how to avoid common post processing
  4. Efficiently updating database using SQLAlchemy ORM
  5. Use Django ORM as standalone [duplicate]
  6. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  7. SQLAlchemy ManyToMany secondary table with additional fields
  8. Bulk insert with SQLAlchemy ORM
  9. How can I verify Column data types in the SQLAlchemy ORM?
  10. What is choice_set in this Django app tutorial?
  11. How do you join two tables on a foreign key field using django ORM?
  12. SQLAlchemy: engine, connection and session difference
  13. sqlalchemy: create relations but without foreign key constraint in db?
  14. How do i cast char to integer while querying in django ORM?
  15. How to make an Inner Join in django?
  16. SQLAlchemy: how to filter date field?
  17. flask-sqlalchemy or sqlalchemy
  18. How to update sqlalchemy orm object by a python dict
  19. Is possible to mapping view with class using mapper in SqlAlchemy?
  20. How to store a dictionary on a Django Model?
  21. SQLALchemy dynamic filter_by
  22. SQLAlchemy ordering by count on a many to many relationship
  23. multiprocessing.Pool: When to use apply, apply_async or map?
  24. Automatic contrast and brightness adjustment of a color photo of a sheet of paper with OpenCV
  25. “RuntimeError: Make sure the Graphviz executables are on your system’s path” after installing Graphviz 2.38
  26. Python decompressing gzip chunk-by-chunk
  27. Removing multiple keys from a dictionary safely
  28. Difference between np.int, np.int_, int, and np.int_t in cython?
  29. How can I print and display subprocess stdout and stderr output without distortion?
  30. Understanding Multiprocessing: Shared Memory Management, Locks and Queues in Python

Leave a Comment