Re: has_a with complex primary keys

[prev] [thread] [next] [Date index for 2004/10/08]

From: Ricardo SIGNES
Subject: Re: has_a with complex primary keys
Date: 21:13 on 08 Oct 2004
--wchHw8dVAp53YPj8
Content-Type: multipart/mixed; boundary="BRE3mIcgqKzpedwo"
Content-Disposition: inline


--BRE3mIcgqKzpedwo
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Thanks to a private email, I felt goaded on to make the errors I'm
getting clearer.

I've made a -very- simple test for this, which I've attached.  The db is
a SQLite database made with a recent DBD::SQLite.  The results of the
test are as follows:

 ok 1 - use RJBS::Batch;
 ok 2 - The object isa RJBS::Batch
 ok 3 - got 1
 ok 4 - three units in batch 1
 ok 5 - first stringifies correctly
 Can't deflate unitid: 1 is not a RJBS::Unit at
 /usr/local/lib/perl5/site_perl/5.8.5/Class/DBI/Relationship/HasMany.pm
 line 118
 1..5
 # Looks like your test died just after 5.

This bears out the results I got on my Win32 machine using the more
complex tables (with the same kind of structure) and Class::DBI::MSSQL.

Just to make sure I'm not an idiot as far as data-loading goes, here's
what dbish has to say about the table from which it should be pulling
its data:

 @> SELECT * FROM test WHERE batchid=3D1 AND unitid=3D1;
 batchid,unitid,testid
 1,1,1
 [1 rows of 3 fields returned]
 @>=20

--=20
rjbs

--BRE3mIcgqKzpedwo
Content-Type: application/x-tar-gz
Content-Disposition: attachment; filename="cdbi-cpk.tar.gz"
Content-Transfer-Encoding: base64

H4sIAAAAAAAAA+2a34vjVBTHc3Oadqewj0NfL2WhLczsJv0JHbrszFqX0d1lnR0fFpGStulM
nDadSVJnBhHx2X9mH3wQnxR8EB9UEMQHBREFQZFFRF3wwXty09/YmWWn3R3nfCA5uTcnJ6e5
/Z4k3DSadXu1sb93TZkfuqBUKEhblFbP5qWVKIZu5Iyirhf1kqIbWTS8MMecBvQ833Q5V9w3
6t4sP+HWas3Y3/8hfXtOaPTHv1m/2qzP5xx4PYr5/H+Mv5EfjH+hVMoWc2L8cwXDUPhCLuIF
H//7r9y2fYu3um7H9HlOiSiMKTfE9VCUxIQriIWNtJlySi7D+4qmHinwASThPfVIfXwGiRPn
mnciscTyMnvX9M162/Itz8clenOrur5d5dvrG7erHHt4um76jV27yTfvbldvVbdWeM+x/dE2
uo22721t3lnfesBfrj4YHN0/qu+dyaS0aGJtmSm207SOvIO2UEHN7PndoF1Dr5qBa21HlZka
QaYYBpfIWKbYc4pMZ2UmMoJZGaFXzcA16jDyIosmEgnWCZIKQgUrdSytoGsqr9E0MpcxGDxS
4B/4G/4QGwRB/G9RI6qiglhUsTBViYu+ODxUhPofwc/wPXwDX8Kn8JG4Vz981rkSBDFOLMIY
i0Ti0sJSYEG9JC2LBVaFqLSqJi2LBJYBSKuq0jKG9/84fKjAY/gdfoEf4Tv4Gr4QFeBj0UkQ
xHOKFgesBNoSGtAuAdYBLYaGaVHAKqBpEBSBCBqmAWAJ0FQ0qsbQMLz/R+ETBf6EX+EHcff/
XDQIgjg3LGnBvV1l0XCLMU1uqeLOH26JbrklNtVwK7z/R+EzBf6C3+An+Ba+Eg2CIM4Zsah8
FWAxTb4LsFhEvgSwGMi3ABZT5eM/i7Hw+X8w/9O26/OaA3yS+b98IY/zPznhTvN/C2Bs/Lde
2rg/hz/BE41/UVxCI28YWRr/RTA9/hs4W3B1v3N255g9/6vruUJ2MP5Zsa0bhXxJp/nfRbBv
NvbMHYvj0JfLwdivxXuexeumWB0cpm+2Tc8rl1/Y2MysxeMjbqvXG13HsRq+3XXSSfE3Ksu5
5HKz7pgdqxJ8UJBc6TlNqyXXUwGCyat0MpifSoq9E9HbvY7jpe+5dsd0j3nlOqYTzmVlpmLt
ml6tYzrHaZwi89A7Jfe/Ktop4f6sr/TzybT+ty3PP1P5n6j/fK441H8O638hJ9xI/wtgXP84
9ifLH72eRv3y+FD8OMc+1H4/9Azp92fV+xP5E2GxDpgD32EZCMpEauJE0jkMeCFrxrT+8bcv
Wv/6iP4LUv950v8iGNc/jv3J+kevp9G/PD7UP4pvqP9+6JP1n5mMd0rhD52DpwWsIqNPC1gX
LobyJQP9+8Ftvz2Pc5yk/5JhTHz/mzeyWdL/IgjEjn/6cvlO17V4yunW9tumkxLqwl2e79qN
sCYcmq5jOzue2LVRvbV5l7/FRXetu5dOjkhNiJm/HY93jvkV+f1ZhY89qLuWCGm9aaUNVLDt
mRhAuq5MabbR2R/uXr0++GYuVamkVrixwpM7XZ8bWEDwjDfCh3/ePyBoi31hHK9htsVoS7d+
lJyI4u+6lsXl0bYTfjg3CHsl+L6vIq33mv76MGLQJSJZByJS0rhmJIVp2a7nB5fO2bFbtuXx
Rtd1RbFsHw8yDQuPjCmqITanEw26+4lmMdHDLpeHdh352SGe8wIVLIIgCIIgCIIgCIIgCIIg
CIIgCIIgCIIgpvgXB+tANQBQAAA=

--BRE3mIcgqKzpedwo--

--wchHw8dVAp53YPj8
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQFBZwMT5IEwYcR13KMRAkA7AJ93DtfOANkO2tz994r/cSqbn8DmoQCgmonA
u721v3FUtYKCQOdEIfLy19s=
=8HjV
-----END PGP SIGNATURE-----

--wchHw8dVAp53YPj8--

has_a with complex primary keys
Ricardo SIGNES 19:08 on 08 Oct 2004

Re: has_a with complex primary keys
Ricardo SIGNES 21:13 on 08 Oct 2004

Re: has_a with complex primary keys
Y00R0B0T 21:55 on 08 Oct 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52