Yes, exactly :) My goal was to set up *read only* relationship. I have no idea if writable one is possible without the secondary table.
On Tuesday, January 28, 2020 at 3:42:36 PM UTC, Simon King wrote: > > So conceptually, an address_id represents a *group* of addresses. A > company can be associated with exactly one group of addresses, and one > group of addresses can be shared by multiple companies. Is that right? > > A normal many-to-many relationship involves an association table. When > you add and remove items to one side or the other of these > relationships, SQLAlchemy will add and delete rows from the > association table. I'd be amazed if SQLAlchemy would be able to figure > out how to add and remove objects from your relationship. Do you need > it to be writable, or would a readonly relationship be good enough? > > Simon > -- *CONFIDENTIAL* This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments. Internet communications are not guaranteed to be secure or virus-free. Revolut does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by Revolut for operational or business reasons. Any opinion or other information in this e-mail or its attachments that does not relate to the business of Revolut is personal to the sender and is not given or endorsed by Revolut. Registered Office: 9th Floor 107 Cheapside, London, EC2V 6DN, United Kingdom. Main Office: 4th Floor, The Columbus Building, 7 Westferry Circus, London, E14 4HD, United Kingdom. Revolut Ltd is authorised and regulated by the Financial Conduct Authority under the Electronic Money Regulations 2011, Firm Reference 900562. Revolut Ltd is an Appointed Representative of Lending Works Ltd (for the activity of “operating an electronic system for lending” only). -- 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/475f4b84-2f7a-44ab-9ca3-1979f4666179%40googlegroups.com.