Thursday, 19 September 2013

Kohana 3.3: ORM è _load_with äëÿ òàáëèö èç ðàçíûõ áàç

Kohana 3.3: ORM è _load_with äëÿ òàáëèö èç ðàçíûõ áàç

Ñóùåñòâóåò äâå ìîäåëè äëÿ òàáëèö èç ðàçíûõ áàç (äîïóñòèì db_1.tbl_1 è
db_2.tbl_2). Â îáåèõ ìîäåëÿõ, åñòåñòâåííî, óêàçàíû $_db_group. Â ïåðâîé
ìîäåëè íàñòðîåíà ñâÿçü "ìíîãî ê îäíîìó".
Ïðè ïîïûòêå óêàçàòü â ïåðâîé ìîäåëè $_load_with ïî÷åìó-òî ôîðìèðóåòñÿ
ïðèìåðíî òàêîé çàïðîñ:
SELECT `tbl_1`.*, `tbl_2`.*
FROM `tbl_1` LEFT JOIN `tbl_2` ON (`tbl_1`.`method` = `tbl_2`.`id`)
âìåñòî:
SELECT `tbl_1`.*, `tbl_2`.*
FROM `db_1`.`tbl_1` LEFT JOIN `db_2`.`tbl_2` ON (`tbl_1`.`method` =
`tbl_2`.`id`)
Ïðè ýòîì áåç $_load_with ñâÿçü ðàáîòàåò íîðìàëüíî.
×òî íóæíî ó÷åñòü, ÷òîáû èñïîëüçóÿ $_load_with ïîëó÷èòü çàïðîñ êàê âî
âòîðîì ïðèìåðå?

No comments:

Post a Comment