I have been trying to figure out how Torque (3.0 dev) handles object (=table) references.
The situation I have in mind is when you delete a record from database through the BaseXXXPeer.doDelete- method. What happens to the related records? Do I have to first delete all related records and then the "main" record. For example, if I delete a course, do I have to delete all bookings to that course "by hand", or does Torque handle this? As I understands so far, I have to delete related records by hand. The table structure and XML schema are as follows (simplified): Table structure: CREATE TABLE course ( id INTEGER NOT NULL, short_name VARCHAR (40), description MEDIUMTEXT, duration INTEGER, PRIMARY KEY(id) ); CREATE TABLE booking ( id INTEGER NOT NULL, course_id INTEGER, trainees INTEGER, information MEDIUMTEXT, PRIMARY KEY(id), FOREIGN KEY (course_id) REFERENCES course (id) ); XML schema: <table idMethod="idbroker" name="course"> <column name="id" required="true" primaryKey="true" type="INTEGER"/> <column name="short_name" size="40" type="VARCHAR"/> <column name="description" type="LONGVARCHAR"/> <column name="duration" type="INTEGER"/> </table > <table idMethod="idbroker" name="booking"> <column name="id" required="true" primaryKey="true" type="INTEGER"/> <column name="course_id" type="INTEGER"/> <column name="trainees" type="INTEGER"/> <column name="information" type="LONGVARCHAR"/> <foreign-key foreignTable="course"> <reference local="course_id" foreign="id"/> </foreign-key> </table > Thanks! - Tatu v. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
