Re: n-to-n relationship howto

[Hartwig, Thomas]

Ok, I found the solution. I have seen that Torque does generate the 
methods getABs() in both BaseA and BaseB which returns the approbiate 
collection which then contains the methods getA() and getB().

Thomas

Hartwig, Thomas wrote:
Hello,

I'm sure there are a lot of users already needed a n-to-n relationship 
solution. Does Torque support this with a useable modell or do I have to 
implement this. I have looked thru the docs but all I found was: 1-to-n

Schema suggestion with a n-to-n relation, but this is not enough I'm 
afraid:

    <table name="A" description="Table">
        <column name="id"
            autoIncrement="true"
            required="true"
            primaryKey="true"
            type="BIGINT"/>
    </table>
    <table name="B" description="Table">
        <column name="id"
            autoIncrement="true"
            required="true"
            primaryKey="true"
            type="BIGINT"/>
    </table>
    <table name="A_B" description="Table">
        <column name="id"
            autoIncrement="true"
            required="true"
            primaryKey="true"
            type="BIGINT"/>
        <column
            name="A_id"
            type="BIGINT"/>
        <column
            name="B_id"
            type="BIGINT"/>
        <foreign-key foreignTable="A">
            <reference
                local="A_id"
                foreign="id"/>
        </foreign-key>
        <foreign-key foreignTable="B">
            <reference
                local="B_id"
                foreign="id"/>
        </foreign-key>
    </table>
Thanks for attention
Greetings
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Firma Thomas Hartwig                        Telefon: 030-69599727
Software & IT-Service Spezialisten                www.crapoud.com
Boppstr. 11                                     Fax: 030-69599726
D-10967 Berlin                              GnuPG/PGP: 0xC51B523B
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]