[Symfony] Doctrine i left joiny Opcje

[blackroger]

witam. jest sobie takie cos:

[PHP] pobierz, plaintext 
return Doctrine_Core::getTable('Article')->createQuery('a')
                                                 ->leftJoin('a.Translation t')
                                                 ->leftJoin('a.Gallery g')
                                                 ->leftJoin('g.Translation t2')
                                                 ->where('t.lang = ?', $lang)
                                                 ->addWhere('a.f_menu = ?', $this->getTId())
                                                 ->addWhere('t2.lang = ?', $lang)
                                                 ->orderBy('a.t_position')
                                                 ->execute();
[PHP] pobierz, plaintext 

Przy zrzucie na toArray:

[PHP] pobierz, plaintext 
Array
(
    [0] => Array
        (
            [t_id] => 7
            [f_menu] => 10
            [f_article_type] => 
            [f_user] => 
            [t_latitude] => 
            [t_longitude] => 
            [t_position] => 7
            [d_created_at] => 2011-05-05 13:47:01
            [d_modified_at] => 
            [Translation] => Array
                (
                    [pl] => Array
                        (
                            [t_id] => 7
                            [t_title] => 
                            [e_content] => 
                        )
 
                )
 
            [Gallery] => Array
                (//i tu jest pusto chociaz zapytanie zwraca wyniki
                )
 
        )
 
)
[PHP] pobierz, plaintext 

Zapytanie z debuggera:

[SQL] pobierz, plaintext 
SELECT a.t_id AS a__t_id, a.f_menu AS a__f_menu, a.f_article_type AS a__f_article_type, a.f_user AS a__f_user, a.t_latitude AS a__t_latitude, a.t_longitude AS a__t_longitude, a.t_position AS a__t_position, a.d_created_at AS a__d_created_at, a.d_modified_at AS a__d_modified_at, a2.t_id AS a2__t_id, a2.t_title AS a2__t_title, a2.e_content AS a2__e_content, a2.lang AS a2__lang, a2.slug AS a2__slug, g.t_id AS g__t_id, g.t_filename AS g__t_filename, g.t_extension AS g__t_extension, g.f_gallery_type AS g__f_gallery_type, g.f_menu AS g__f_menu, g.f_article AS g__f_article, g.f_comment AS g__f_comment, g.f_news AS g__f_news, g.t_path AS g__t_path, g.t_size AS g__t_size, g.t_x_size AS g__t_x_size, g.t_y_size AS g__t_y_size, g.t_position AS g__t_position, g.d_created_at AS g__d_created_at, g.d_modified_at AS g__d_modified_at, g2.t_id AS g2__t_id, g2.t_desc AS g2__t_desc, g2.t_tip AS g2__t_tip, g2.lang AS g2__lang, g2.slug AS g2__slug FROM article a LEFT JOIN article_translation a2 ON a.t_id = a2.t_id LEFT JOIN gallery g ON a.t_id = g.f_article LEFT JOIN gallery_translation g2 ON g.t_id = g2.t_id WHERE (a2.lang = 'pl' AND a.f_menu = '10' AND g2.lang = 'pl') ORDER BY a.t_position
[SQL] pobierz, plaintext 

Co robię nie tak że Doctrine nie widzi tej tabeli gallery?

[webdice]

Dodaj:

Kod

->select( 'g.column' )

[blackroger]

hmmm....to nic nie dało :/
W sumie zawsze mnie to męczyło....Można wziąć relację jeden do wielu w tą stronę w Doctrine w ogóle?

teraz chcę żeby to szło tak: article(1)->Gallery(wiele)
bo tak chodzi bez zarzutu gallery->article....problem jest w drugą stronę....zastanawiam się jakby wyglądała prezentacja tego w obiekcie, bo wywołując powiedzmy article->getGallery() zwracałoby wszystkie zdjęcia z galerii. hmm....

z tego co widzę takie pobranie obiektów może być tylko wtedy gdy wywołanie będzie jednoznaczne....tzn....getGallery() zwróci tylko i wyłącznie jeden obiekt....

Ten post edytował blackroger 5.05.2011, 17:22:06

[janek9]

może tak? :

CODE

return Doctrine_Query::create()
->select(a.*,g.*,t.*,t2.*)
->from(Article a)
->leftJoin('a.Translation t')
->leftJoin('a.Gallery g')
->leftJoin('g.Translation t2')
->where('t.lang = ?', $lang)
->addWhere('a.f_menu = ?', $this->getTId())
->addWhere('t2.lang = ?', $lang)
->orderBy('a.t_position')
->execute();

[blackroger]

nadal nic....

zauważyłem ponadto że to zapytanie:

[PHP] pobierz, plaintext 
 
return Doctrine_Core::getTable('Article')->createQuery('a')
                                                 ->leftJoin('a.Translation t')
                                                 ->leftJoin('a.Gallery g')
                                                 ->leftJoin('g.Translation t2')
                                                 ->where('t.lang = ?', $lang)
                                                 ->addWhere('a.f_menu = ?', $this->getTId())
                                                 ->addWhere('t2.lang = ?', $lang)
                                                 ->orderBy('a.t_position')
                                                 ->execute();
[PHP] pobierz, plaintext 

wykonuje 6 zapytań.....coś jest nie tak....

[PHP] pobierz, plaintext 
 
#
 
SELECT a.t_id AS a__t_id, a.f_menu AS a__f_menu, a.f_article_type AS a__f_article_type, a.f_user AS a__f_user, a.t_latitude AS a__t_latitude, a.t_longitude AS a__t_longitude, a.t_position AS a__t_position, a.d_created_at AS a__d_created_at, a.d_modified_at AS a__d_modified_at, a2.t_id AS a2__t_id, a2.t_title AS a2__t_title, a2.e_content AS a2__e_content, a2.lang AS a2__lang, a2.slug AS a2__slug, g.t_id AS g__t_id, g.t_filename AS g__t_filename, g.t_extension AS g__t_extension, g.f_gallery_type AS g__f_gallery_type, g.f_menu AS g__f_menu, g.f_article AS g__f_article, g.f_comment AS g__f_comment, g.f_news AS g__f_news, g.t_path AS g__t_path, g.t_size AS g__t_size, g.t_x_size AS g__t_x_size, g.t_y_size AS g__t_y_size, g.t_position AS g__t_position, g.d_created_at AS g__d_created_at, g.d_modified_at AS g__d_modified_at, g2.t_id AS g2__t_id, g2.t_desc AS g2__t_desc, g2.t_tip AS g2__t_tip, g2.lang AS g2__lang, g2.slug AS g2__slug FROM article a LEFT JOIN article_translation a2 ON a.t_id = a2.t_id LEFT JOIN gallery g ON a.t_id = g.f_article LEFT JOIN gallery_translation g2 ON g.t_id = g2.t_id WHERE (a2.lang = 'pl' AND a.f_menu = '10' AND g2.lang = 'pl') ORDER BY a.t_position
0.00s, "doctrine" connection
#
 
SELECT g.t_id AS g__t_id, g.t_filename AS g__t_filename, g.t_extension AS g__t_extension, g.f_gallery_type AS g__f_gallery_type, g.f_menu AS g__f_menu, g.f_article AS g__f_article, g.f_comment AS g__f_comment, g.f_news AS g__f_news, g.t_path AS g__t_path, g.t_size AS g__t_size, g.t_x_size AS g__t_x_size, g.t_y_size AS g__t_y_size, g.t_position AS g__t_position, g.d_created_at AS g__d_created_at, g.d_modified_at AS g__d_modified_at, g2.t_id AS g2__t_id, g2.t_desc AS g2__t_desc, g2.t_tip AS g2__t_tip, g2.lang AS g2__lang, g2.slug AS g2__slug FROM gallery g LEFT JOIN gallery_translation g2 ON g.t_id = g2.t_id WHERE (g2.lang = 'pl' AND g.f_article = '7') ORDER BY g.t_position
0.00s, "doctrine" connection
 
....
...
.
.
.
powyższe zapytanie jeszcze kilka razy....tak jakby dla kazdego article
 
[PHP] pobierz, plaintext 

[janek9]

najlepiej będzie jak podasz zawartość pliku schema.yml.

Wtedy pomyślimy dalej.

Ten post edytował janek9 5.05.2011, 17:44:05

[blackroger]

Dobra przepraszam wszystkich za zamieszanie....wszystko działa. Okazało się, że w klasie Article mam nadpisaną metodę getGallery, która z automatu pobierała elementy Gallery i mieszała....w każdym bądź razie teraz wszystko ładnie działa

Ten post edytował blackroger 5.05.2011, 18:34:38