Re: create and insert

[prev] [thread] [next] [Date index for 2005/01/20]

From: Perrin Harkins
Subject: Re: create and insert
Date: 18:46 on 20 Jan 2005

On Thu, 2005-01-20 at 17:24 +0100, Hartmaier Alexander wrote:
> This is the definition im my NAC::Interface class:
> __PACKAGE__->set_sql('from_scan', 'SELECT fk_device, port, name, snmpid, snmpid_rtt, type, speed, mtu, ipaddr, ipnetmask, description FROM nacadm.scaninterface WHERE port = ?');

I have to agree with Jay that I don't understand why you aren't using a
normal search() call here.

> I have also defined the sequence of my oracle db:
> __PACKAGE__->sequence('seq_interface');
> I is not needed that Class::DBI gets a value from the sequence,
> because an oracle trigger is defined for every table to do this.

I think you're not understanding how Class::DBI works.  It is not
possible to have a Class::DBI object without a primary key.  It has no
facilities for creating temporary objects in memory that are not in the
database.  Any time you create() an object it immediately gets inserted
into the database, before you even get the object reference back,
specifically so that it will have a primary key.

- Perrin

(message missing)

create and insert
Hartmaier Alexander 16:00 on 20 Jan 2005

Re: create and insert
Dana Hudes 16:06 on 20 Jan 2005

Re: create and insert
Hartmaier Alexander 16:24 on 20 Jan 2005

Re: create and insert
Jay Strauss 17:45 on 20 Jan 2005

Re: create and insert
Perrin Harkins 18:46 on 20 Jan 2005

Re: create and insert
Jay Strauss 19:33 on 20 Jan 2005

Re: create and insert
Perrin Harkins 19:51 on 20 Jan 2005

Re: create and insert
Jay Strauss 17:39 on 20 Jan 2005

Re: create and insert
Peter Speltz 17:53 on 20 Jan 2005

Re: create and insert
Peter Speltz 18:06 on 20 Jan 2005

Re: create and insert
Hartmaier Alexander 09:40 on 21 Jan 2005

Re: create and insert
Jay Strauss 15:41 on 21 Jan 2005

Re: create and insert
Perrin Harkins 19:35 on 21 Jan 2005

Re: create and insert
Peter Speltz 05:50 on 22 Jan 2005

Re: create and insert
Perrin Harkins 17:19 on 22 Jan 2005

Re: create and insert
Peter Speltz 17:43 on 22 Jan 2005

Re: create and insert
Perrin Harkins 19:09 on 22 Jan 2005

Re: create and insert
Peter Speltz 22:22 on 22 Jan 2005

Re: create and insert
Perrin Harkins 00:18 on 23 Jan 2005

Re: create and insert
Hartmaier Alexander 14:07 on 24 Jan 2005

Re: create and insert
William McKee 16:15 on 24 Jan 2005

Re: create and insert
Peter Speltz 16:28 on 24 Jan 2005

Re: create and insert
Hartmaier Alexander 16:38 on 24 Jan 2005