Problems With Deletion

Question

Problems With Deletion

dasfisch May '13

Created May '13	Last Reply May '13	Replies 3	Views 456	Votes 0

dasfisch 5.1k

May '13

I am trying to do something similar to the results of this post (https://forum.phalcon.io/discussion/183/insert-and-delete-multiple-related-records), but I am having troubles making this work, as well as just getting deletion to work normally.

```foreach($deletable as $single) { $user = UserProjects::findFirst(array( 'conditions' => 'user_id=?0 and project_id=?1 and is_stakeholder=1', 'bind' => array( $single, $project->id ) ));

var_dump($user->delete());
exit;



This throws me a PDOException. I ran some code to show me the queries being generated, and for some reason I am getting: DELETE FROM `users_projects` WHERE. There is nothing getting appended to the end of the query.

I have ensured that I am getting a result from the initial findFirst, but, after that, nothing happens. Any ideas? I'm on Phalcon 0.9.1.

Phalcon · Answer 1 · 2013-05-20T14:06:29-07:00

Phalcon
98.9k

May '13

Does UserProjects have a primary key?

dasfisch · Answer 2 · 2013-05-20T14:10:48-07:00

dasfisch
5.1k

May '13

It does not. It is a pivot table. Sorry. Forgot to mention that.

Phalcon · Answer 3 · 2013-05-20T14:22:07-07:00

Since the SQL is dinamically generated, the ORM cannot delete a record if a primary key is not available.

dasfisch · Answer 4 · 2013-05-21T06:59:21-07:00

So, I take there is no way to delete from pivot tables, aside from creating the query yourself? If that's the case, that's fine.

Phalcon · Answer 5 · 2013-05-21T07:26:05-07:00

You can do something like:

$user->getConnection->delete("user_projects", "user_id=? and project_id=? and is_stakeholder=1", array($singe, $project->id));