habtm

CakePHP n to n relation on a third table

Hey all, I have a n...n structure for two tables, makes and models. So far no problem. In a third table (products) like: id make_id model_id ... My problem is creating a view for products of one specifi make inside my ProductsController containing just that's make models: I thought this could work: var $uses = array('Make', 'Model...

CakePHP hasAndBelogsToMany using save() vs. saveAll()

Heyall, I am using a very intrinsic database with a CakePHP application and so far my multi-models views and controllers are working fine. I have a singular table (Entity) that have it's id on several other tables as the Foreign Key entity_id Some tables are one to one relations (Like a Company is one Entity) and some are one to many (...

Has and belongs to many relationship with multiple databases

I have a situation where I have two models, companies and permissions, where companies is in a separate database from my permissions database. This is a has and belongs to many relationship because each company can have many permissions and each permission can belong to many companies. The reason the two databases are split is because ...

Rails Associations, habtm? Polymorphic? Both?

In my Rails app I have three models, Projects, BlogPosts and Images. Projects and BlogPosts can have many linked images and an image can be linked to a Project, a BlogPost or both. What is the best way of setting up the associations to make this work in Rails? ...

CakePHP find() based on HABTM relationship

Hello, I'm working on a CakePHP 1.2 application. I have a model "User" defined with a few HABTM relationships with other tables through a join table. I'm now tasked with finding User information based on the data stored in one of these HABTM tables. Unfortunately, when the query executes, my condition is rejected with an error about a ...

How to edit additional data in HABTM tables?

How do I update additional data in HABTM tables. For Example: I have movies, people and HABTM movies_people tables, but there is additional persontype_id field in movies_people table which indicates role of this person in that particular movie. How do I add/change this value? ...

Is there a RESTful way to configure routes for habtm?

In Rails you can use nested routes to create RESTful routes for has_one and has_many relationships. Examples can be found on the Rails Guides I'd like to ask if there is a good way to configure RESTful routes for habtm relationships? For example if I have a relationship A-habtm-B, my idea is to configure nested routes for A has_many B, ...

Saving HABTM records when not all join table columns are foreign keys

I am trying to update tables with a has and belongs to many (HABTM) relationship. When my join table looked like this: CREATE TABLE IF NOT EXISTS `items_labels` ( `item_id` int(11) NOT NULL, `label_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; I use CakePHP, so I could update the tables with $this->Item->save($data) ...

has_and_belongs_to_many in Rails

Is there anything explicitly wrong with using has_and_belongs_to_many associations in rails instead of has_many :through? I'm aware of these articles describing differences and work arounds, but they are from 2006. From things I've read on SO, it seems like people think that habtm is old and clunky, but what if a simple many to many jo...

HABTM 2 tables 2 different relationships

I have a Service Types table containing id and name of a couple of dozen services. I have a Projects table that has to have a list of Proposed Services, and a list of Accepted Services. I know that I would use HABTM on both sides with a project_service_types table in between. I can't quite figure out what to do when I have 2 different...

Cakephp Tagging - Auto Save new Tags and Tag Relations

I read a lot about tagging in CakePHP but I can't find a "clean" way to save a Post and the Tags to this post. I have all which is necessary the Post Table, Model and Controller, the Tag table, Model and Controller and the posts_tags table. I created the HABTM Associations in the Post and the Tag Model. If I want to save a new post, I w...

ActiveRecord fails to update HABTM relation

I'm using a simple model for user authorisation with two ActiveRecords User and Role User and Role have a HABTM relation to each other. I tried to created a user interface for assigning roles to users with simple checkboxes - just like in Railscasts Episode #17. My problem is that neither User#new nor User#update_attributes use the par...

HABTM association on HABTM join table in CakePHP

I'm trying to save data with following structure: As you can see, there is HABTM association between users and experiences table. And another HABTM between *experiences_users* and tags. I created following form: <?php echo $form->create('Experience', array('action' => 'addClassic'));?> <?php echo $form->input('Experience.date...

HABTM association associated to single table inheritance help!

hi all I have a product model that has many sections and a section can belong to many products. The section model has subclasses as features, standardAccessories and OptionalAccessories in a STI. Each having field title, body, image url and (optionalAccessories) has price. my models are class Product < ActiveRecord::Base has_and...

(Rails, Associations) How do I remove a single HABTM associated item?

Ok, stupid question. How do you remove a HABTM associated item without deleting the item itself? For instance, say I have 3 STUDENTS that are in SCIENCE class together. How do I remove the SCIENCE object from the STUDENTS_CLASSES table without deleting the actual SCIENCE reference? I'm guessing that Student.Classes.first.delete is...

post habtm postlover : how to order posts by number of postlovers?

Hi guys...please help me, i'm really struggling with this... Authors can write post, and authors can love other authors' posts... So posts belong to author (when authors write them), but posts habtm authors (when authors love them). For example i'd like to get posts ordered by number of postlovers and created in the last 24 hours. He...

Rails/AR find where habtm does not include

I have a Rails app with Users, and each user HABTM Roles. I want to select Users without a specific role. I have searchlogic at my disposal, and I'm lost. I've tried using a combination of conditions and joins and includes and what not, but I can't seem to nail it. This works: User.find(:all, :conditions => ['role_id != ?', Role[:admin...

CakePHP HABTM question

Might be a newbie question as I'm trying to see what all these "PHP frameworks" are at my free time. For starters I want to add multiple tags to multiple photos. I have a tags model and mot model (the photos). Snip of mot model: var $hasAndBelongsToMany = array( 'Tag' => array( 'cl...

Saving with HABTM in CakePHP

I am creating multiple associations in one go and there are a few problems when it comes to saving. I have the following code: <?php foreach($userData as $user) { $data = array('User' => array('id' => $user['id']), 'Site' => array('id' => $user['site_id'])); $this->User->save($data); } ?> I have experimented with formatting t...

Can anyone explain to me how the HABTM principle works?

Can anyone explain to me how the (HABTM or many to many) "has and belongs to many" principle works? Say I have a users table and books table and then I have a table users_books where the IDs are. When would I need to actually use this principle and how would it work? ...