Unique rows with auto increment - doctrine-user

Message from discussion Unique rows with auto increment

Matt Hulse

More options 16 May, 04:32

From: Matt Hulse <matt.hu...@gmail.com>

Date: Thu, 15 May 2008 20:32:01 -0700 (PDT)

Local: Fri 16 May 2008 04:32

Subject: Re: Unique rows with auto increment

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

Jon, thanks for the response.

I explored listeners and hooks and here is what I came up with:

public function preInsert($event)
{
//if a record with this controller and action exists,
// don't create a new one
$table = Doctrine::getTable("Permission");
$permission = $table->findByDql("controller = ? and action = ?",
array($this->controller, $this->action));
if($permission[0]->exists()) {
//echo "Already exists.";
$this->id = $permission[0]->id;
$event->skipOperation();
}
}

This code seems to do what I need and duplicate permissions are not
created. There is a problem though when I try to create permissions
with relation to the user table.

$user = new User();
$user->Permissions[0]->controller = "account";
$user->Permissions[0]->action = "create";
$user->save();

This code generates a new entry for my associative table between users
and permissions as expected, but now permission_id is always null,
even for the initial insert. Do I need to change something in the
user model?

Any ideas?

Thanks,

Matt

On May 15, 5:49 pm, "Jonathan Wage" <jonw...@gmail.com> wrote:

> That would work or you could do it with a preSave() record listener
> possibly. Read up on listeners and you will probably find what you want.

> - Jon

> On Thu, May 15, 2008 at 5:22 PM, Matt Hulse <matt.hu...@gmail.com> wrote:

> > I have a permissions table which has two fields, page and action. I
> > don't want duplicate permission entries but that's what I'm getting
> > since Doctrine wants an auto increment id field. How do you handle
> > this kind of thing?

> > I would really like to setup something like a singleton where I create
> > a new permission object and when I save, if an entry with the same
> > page and action already exists, it returns that entry, otherwise it
> > creates a new entry and returns it.

> > $permission = new Permission();
> > $permission->page = 'accounts';
> > $permission->action='create';
> > $permission->save(); //permission id = 3

> > $permission = new Permission();
> > $permission->page = 'accounts';
> > $permission->action='delete';
> > $permission->save();//permission id = 4

> > $permission = new Permission();
> > $permission->page = 'accounts';
> > $permission->action='create';
> > $permission->save();//permission id = 3

> > I would like to implement this in a way that will allow me to use
> > something like $permission->merge($_POST). Does this imply overriding
> > save?

> > I appreciate any suggestions. Thanks in advance.

> > Matt

> --
> Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

Reply to author Forward