Re: $obj->delete doesn't remove from the DB

[prev] [thread] [next] [Date index for 2004/06/19]

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

On Fri, Jun 18, 2004 at 17:48:08 +0300, Yuval Kogman wrote:

> blah blah blah

Anyway, I think it's not my fault.

The $link object I was trying to delete has two has_a. When It's asked
to delete itself, the SQL being sent to the server has these fields,
which are the primary keys of the link table, matched against the
stringified value of the objects which the link has.

In my specific example I have a machine called saturn, on which Oracle
is installed, and I would like to say that's no longer the case, so I
look up the link where $saturn->id and $oracle->id are the primary key,
and i delete that link. DBI->trace says this is what happens:

 T  <- finish=3D 1 at ContextualFetch.pm line 88
      Binding parameters: DELETE
FROM   machine_has_db
WHERE  machine=3D'saturn' AND db=3D'Oracle'


Am I missing something obvious I should not be doing?

--=20
 ()  Yuval Kogman <nothingmuch@xxxxxxxx.xxx> 0xEBD27418  perl hacker &
 /\  kung foo master: /me climbs a brick wall with his fingers: neeyah!


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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFA1KkpVCwRwOvSdBgRArUMAKDDKyIZPbLg8OUDsPScP+NvMy97OQCfXFHD
0RZSPL+JPE+B/wmVK1UogXI=
=xca8
-----END PGP SIGNATURE-----

--GID0FwUMdk1T2AWN--