On 6/4/07, Iļja Ketris <[EMAIL PROTECTED]> wrote: > On 6/4/07, John Siracusa <[EMAIL PROTECTED]> wrote: >> If it's there's a real foreign key constraint in the database, the Loader >> make a foreign key in the RDBO class. > > How is this possible? SQLite doesn't support foreign keys
It does, sort of. There are many examples in the RDBO test suite. Look at t/db-object-loader.t and search for SQLite: http://search.cpan.org/src/JSIRACUSA/Rose-DB-Object-0.764/t/db-object-loader.t CREATE TABLE products ( ... vendor_id INT REFERENCES vendors (id), ... ); > and there is no mention of them in my schema, which is roughly not more than > > Create Table user (user Integer Primary Key Autoincrement Not Null, realname > text); > Create Table collection (user Integer References user(user), collection > text, Primary Key (user, collection)); That "... Integer References user(user)" part creates a foreign key in SQLite. That's what the Loader is picking up. -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
