Hey All, For the line: Customer.mapper.add_property('checkout_history', relation(CheckoutEntry.mapper, t_customer_tours, primaryjoin=Customer.c.cust_id==CustomerTour.c.cust_id, secondaryjoin=and_(CustomerTour.c.start_date <= CheckoutEntry.c.ts_checkout, CoreDb.CustomerTour.c.finish_date >= CheckoutEntry.c.ts_checkout))) it generates the following error:
ArgumentError: No syncrules generated for join criterion customer_tours.start_date <= checkout_trail.ts_checkout AND customer_tours.finish_date >= checkout_trail.ts_checkout It turns out that that property is, well, not what I wanted in the first place (there's no explicit 1:1 relationship between Customer and CustomerTour, amongst other things) but I am pretty curious what a syncrule is, what causes it to be generated (or not generated), and, if I encounter it again, what should I look for? I'm sure it must make sense to /someone/, but as a user I'm left scratching my head :) Cheers, -G ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users