Hi, I'm using flask-sqlahcmey and I have a self referential relationship like this:
class FileData(db.Model): id = db.Column(db.Integer, primary_key = True) primary_file_data_id = db.Column(db.Integer, ForeignKey('file_data.id')) is_edited_file = db.Column(db.Boolean, default = False, nullable = False ) edited_datas = db.relationship("FileData", remote_side = [primary_file_data_id], primaryjoin="and_( FileData.id == FileData.primary_file_data_id , FileData.is_edited_file == True )") The intent of the edited_datas is to find the the records where the primary_file_data_id equals the current FileData instance id and where the is_edited_file flag is true. The relationship seems to be functioning correctly, but I'm getting a warning from sqlalchemy: /Users/Victor/Documents/Python/proj/pgp_venv/lib/python2.7/site-packages/sqlalchemy/orm/relationships.py:2085: SAWarning: Non-simple column elements in primary join condition for property FileData.edited_files - consider using remote() annotations to mark the remote side. self._warn_non_column_elements() I think I am using the remote_side keyword properly. Should I be using something else to mark the remote side? If I'm doing everything correclty, is there a way to suppress this (and only this) message? I would rather get this message than miss other warning SA might give me. Thank you for your help, ~Victor -- 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 post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.