How to make a nested query with an Entity that doesn't really exist (many-to-many)

Posted by Calou on Stack Overflow See other posts from Stack Overflow or by Calou
Published on 2010-12-31T10:30:27Z Indexed on 2010/12/31 10:54 UTC
Read the original article Hit count: 214

Filed under:

many-to-many

|

nested

|

doctrine2

|

dql

Hi everyone,

I'm new with Doctrine2 so my question can be easy to answer (I hope so). First of all, here the SQL query that I'd want :

SELECT * FROM Document WHERE id NOT IN (SELECT document_id FROM Documents_Folders)

Pretty simple isn't it ? The porblem is that my table 'Documents_Folders' is not an entity. In fact, it was create because I have a many-to-many relation between my entities 'Document' and 'Folder'.

I tried several queries, but none worked.

Thanks.

© Stack Overflow or respective owner

Related posts about many-to-many

Self referencing symmetrical Hibernate Map Table using @ManyToMany

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following class public class ElementBean { private String link; private Set<ElementBean> connections; } I need to create a map table where elements are mapped to each other in a many-to-many symmetrical relationship. @ManyToMany(targetEntity=ElementBean.class) @JoinTable( … >>> More
Django ManyToMany join query

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm sure this is really simple, but I can't for the life of me find any documentation explaining how to do this. How do I get the results of a ManyToMany field inside a join as opposed to doing this: {% for tag in article.tags.all %} Which results in an extra query? What I'd like to do is fetch… >>> More
django ManyToMany through help

as seen on Stack Overflow - Search for 'Stack Overflow'
Hay I've got a question about relationships. I want to Users to have Friendships. So a User can be a friend with another User. I'm assuming i'll need to use the ManyToManyField, through a Friendship table. But i cannot get it to work. Any ideas? Here are my models. class User(models.Model): … >>> More
Limiting choices from an intermediary ManyToMany junction table in Django

as seen on Stack Overflow - Search for 'Stack Overflow'
Background I've created three Django models—Inventory, SalesOrder, and Invoice—to model items in inventory, sales orders for those items, and invoices for a particular sales order. Each sales order can have multiple items, so I've used an intermediary junction table—SalesOrderItems—using the through… >>> More
What's best practice to check if an object is part of a ManyToMany relationship in Django

as seen on Stack Overflow - Search for 'Stack Overflow'
from an instance of Site with a ManyToMany relationship to Kiosk, i'd like to check if a Kiosk object is part of the relationship. I could do self.apps.get(id=app_id).exists() and check if True or self.apps.get(id=app_id) and catch the ObjectDoesNotExist error or self.apps.filter(id=app_id)… >>> More

Related posts about nested

Nested class or not nested class?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have class A and list of A objects. A has a function f that should be executed every X seconds (for the first instance every 1 second, for the seconds instance every 5 seconds, etc.). I have a scheduler class that is responsible to execute the functions at the correct time. What i thought to do… >>> More
Nested class - calling the nested class from the parent class

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class whereby a method calls a nested class. I want to access the parent class properties from within the nested class. public class ParentClass { private x; private y; private z; something.something = new ChildClass public class ChildClass { need to get x, y and z; } } How do I… >>> More
How Do I Prevent Rails From Treating Updated Nested Attributes Differently From New Nested Attribute

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using rails3 beta3 and couchdb via couchrest. I am not using active record. I want to add multiple "Sections" to a "Guide" and add and remove sections dynamically via a little javascript. I have looked at all the screencasts by Ryan Bates and they have helped immensely. The only difference… >>> More
Created nested model setting a property on nested model before save

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two models a Company and a User the Company has_many :users and the User belongs_to :company. I have a form such as: <%= form_for @company, data: {toggle: :validator}, novalidate: "novalidate", html: {role: :form} do |f| %> company fields Then in there I have <%= f.fields_for… >>> More
Sorting deeply nested attributes in Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to drag and drag App model which is nested under Category model. http://railscasts.com/episodes/196-nested-model-form-part-1 's the Railscast I've tried to follow. Category controller def move params[:apps].each_with_index do |id, index| Category.last.apps.update(['position=… >>> More