Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [Symfony] Doctrine i left joiny
Forum PHP.pl > Forum > PHP > Frameworki
blackroger
5.05.2011, 14:02:39
witam. jest sobie takie cos:

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


Przy zrzucie na toArray:

[PHP] pobierz, plaintext 
  1. Array
  2. (
  3.     [0] => Array
  4.         (
  5.             [t_id] => 7
  6.             [f_menu] => 10
  7.             [f_article_type] => 
  8.             [f_user] => 
  9.             [t_latitude] => 
  10.             [t_longitude] => 
  11.             [t_position] => 7
  12.             [d_created_at] => 2011-05-05 13:47:01
  13.             [d_modified_at] => 
  14.             [Translation] => Array
  15.                 (
  16.                     [pl] => Array
  17.                         (
  18.                             [t_id] => 7
  19.                             [t_title] => 
  20.                             [e_content] => 
  21.                         )
  22.  
  23.                 )
  24.  
  25.             [Gallery] => Array
  26.                 (//i tu jest pusto chociaz zapytanie zwraca wyniki
  27.                 )
  28.  
  29.         )
  30.  
  31. )
[PHP] pobierz, plaintext





Zapytanie z debuggera:
[SQL] pobierz, plaintext 
  1. 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
5.05.2011, 14:08:39
Dodaj:

Kod
->select( 'g.column' )
blackroger
5.05.2011, 16:52:40
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....
janek9
5.05.2011, 17:20:54
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
5.05.2011, 17:30:56
nadal nic....

zauważyłem ponadto że to zapytanie:

[PHP] pobierz, plaintext 
  1.  
  2. return Doctrine_Core::getTable('Article')->createQuery('a')
  3.                                                  ->leftJoin('a.Translation t')
  4.                                                  ->leftJoin('a.Gallery g')
  5.                                                  ->leftJoin('g.Translation t2')
  6.                                                  ->where('t.lang = ?', $lang)
  7.                                                  ->addWhere('a.f_menu = ?', $this->getTId())
  8.                                                  ->addWhere('t2.lang = ?', $lang)
  9.                                                  ->orderBy('a.t_position')
  10.                                                  ->execute();
[PHP] pobierz, plaintext


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

[PHP] pobierz, plaintext 
  1.  
  2. #
  3.  
  4. 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
  5. 0.00s, "doctrine" connection
  6. #
  7.  
  8. 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
  9. 0.00s, "doctrine" connection
  10.  
  11. ....
  12. ...
  13. .
  14. .
  15. .
  16. powyższe zapytanie jeszcze kilka razy....tak jakby dla kazdego article
  17.  
[PHP] pobierz, plaintext


janek9
5.05.2011, 17:43:46
najlepiej będzie jak podasz zawartość pliku schema.yml.

Wtedy pomyślimy dalej.
blackroger
5.05.2011, 17:58:16
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 smile.gif
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.