php.activerecord

Naming in PHP-AR is tricky, hope this give you some light: http://pastie.org/1628683

edit: forgot the sql schema http://pastie.org/1628705

Hi,

Thanks for your effort. You seem to have missed my point: i cannot rename the database. This will break things:

but i cannot rename my tables and/or column names or things will break

Getting it to work using the default <object>_id mapping was no problem at all :-)

I do hope one of the developers is reading this, as i can imagine i will not be the only person who cannot rename his database.

I even considered using a view, but it's less of a hassle just to start using Doctrine2

Assume you're using MySQL.
I can not execute this with phpmyadmin:

CREATE TABLE `huis_tref` (
  `house_id` int(11) NOT NULL,
  `keyword_id` int(11) NOT NULL,
  KEY `huis_id` (`huis_id`),
  KEY `keyword_id` (`keyword_id`)
)

It produce error: Key column 'huis_id' doesn't exist in table
So, I've changed the sql chema to test your problem.

That might be because you have to write:

CREATE TABLE `huis_tref` (
  `huis_id` int(11) NOT NULL,
  `keyword_id` int(11) NOT NULL,
  KEY `huis_id` (`huis_id`),
  KEY `keyword_id` (`keyword_id`)
)

Notice the name of the first column.

My fault, I was just copy and paste sql schema that you've provided.
So, can you show me your current working sql with those 3 tables(huizen, trefwoorden, huis_tref) ?

No, my fault, the original pastie was incorrect. Below is the sql with which it works (only the join-table, the others are correct):

CREATE TABLE `huis_tref` (
  `house_id` int(11) NOT NULL,
  `keyword_id` int(11) NOT NULL,
  KEY `house_id` (`house_id`),
  KEY `keyword_id` (`keyword_id`)
)

Below is the sql with which it doesn't work:

CREATE TABLE `huis_tref` (
  `huis_id` int(11) NOT NULL,
  `keyword_id` int(11) NOT NULL,
  KEY `huis_id` (`huis_id`),
  KEY `keyword_id` (`keyword_id`)
)

Using this sql PHP-AR still tries to use house_id when referencing Keyword->houses

here you go : http://pastie.org/1629282

Thanks, i'm not at home now so can't access the code, but have you also tried it the other way around?

$keyword = Keyword::find('first');        
var_dump($keyword->houses);

Not yet, I'll let you know.

Try this http://pastie.org/1629660

Note: tested under WinXP

Wow, this soo works! Totally awesome!

I would've never figured out to use an array as the value for the through key.

Thanks a ton! It works perfectly on Ubuntu Linux ;-)

I believe that's what's forum for ;)

Hi,

When i tried to rename one of the columns from the joining table, it wouldn't work anymore, since it was looking again for the <class>_id column.

The modified sql is here : http://pastie.org/1643143
I renamed 'keyword_id' to 'tref_id'

Tried several approaches, but the query keeps coming up as

SELECT `trefwoorden`.* FROM `trefwoorden` INNER JOIN `huis_tref` ON(`trefwoorden`.id = `huis_tref`.keyword_id) WHERE `huizen_nummer`=?

I'm affraid I can't help you this time. I think this is a HasAndBelongsToMany (Relationship.php line 556) and it it's not finish yet (Relationship.php line 552).

For now, this is the only think pop up my mind:

$join = 'INNER JOIN `huis_tref` ON(`trefwoorden`.id = `huis_tref`.tref_id)';
$house = Keyword::all(array(
    'joins' => $join,
    'conditions' => 'huis_id=1'
));
print_r($house);

I gathered as much. I wish i could contribute the HasAndBelongsToMany class, but alas, my knowledge doesn't reach that far.

Your suggestion for a join is elegant and easily implementable. Thank you.