I have something like the following... class TimestampMixin(object): created_at = db.Column(db.DateTime, default=datetime.datetime.utcnow) modified_at = db.Column(db.DateTime, default=datetime.datetime.utcnow, onupdate=datetime.datetime.utcnow)
class Memo(db.Model, TimestampMixin): __tablename__ = "memos" pk = db.Column(db.Integer, primary_key=True) note = db.Column(db.Text) date = db.Column(db.Date) purpose = db.Column(db.Text) product = db.Column(db.Text) location = db.Column(db.Text) private = db.Column(db.Boolean, default=False, nullable=True) in_person = db.Column(db.Boolean, default=False, nullable=True) rr = db.Column(db.Boolean, default=False, nullable=True) customer_pk = db.Column(db.Integer, db.ForeignKey("customers.pk")) author_pk = db.Column(db.Integer, db.ForeignKey("users.pk")) contact_pk = db.Column(db.Integer, db.ForeignKey("contacts.pk")) r_by_pk = db.Column(db.Integer, db.ForeignKey("users.pk")) recipients = db.relationship("MemoRecipient", backref="memo", cascade="save-update, merge, delete",) comments = db.relationship("MemoComment", backref="memo", cascade="save-update, merge, delete",) reminders = db.relationship("MemoReminder", backref="memo", cascade="save-update, merge, delete",) class MemoRecipient(db.Model): __tablename__ = "memorecipients" pk = db.Column(db.Integer, primary_key=True) memo_pk = db.Column(db.Integer, db.ForeignKey("memos.pk")) user_pk = db.Column(db.Integer, db.ForeignKey("users.pk")) Whenever a Memo is created, it has an author and optionally gets tagged with other users using the MemoRecipient table. I am trying to figure out how to write a query that will give me all the Memos that were authored by (Memo.author_pk) or sent to (MemoRecipient.user_pk) a specific user. I also need to order the results by Memo.modified_at and paginate the results. I'm thinking I need some type of JOIN, I'm just not sure which. Any advice? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/e46936a6-84e7-43df-bbf8-8d86385ed8b7o%40googlegroups.com.