convert into doctrine

Question

SELECT id, forename, surname, created 
FROM name n 
WHERE created = (SELECT MAX(created) 
                          FROM name 
                          GROUP BY id 
                          HAVING id = n.id);

schema.yml:

    id:
      type: integer(4)
      fixed: false
      unsigned: true
      primary: true
      autoincrement: true
  lcreated:
      type: timestamp(25)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
  forname/surname:
      type: integer(4)
      fixed: false
      unsigned: true
      primary: false
      notnull: true
      autoincrement: false

I do have a extra table for forname and surname!

How can I convert this into doctrine 1.2?

Do you have schema.yml file? You should show it also – Sergii Stotskyi Jul 23 '12 at 11:42 — Sergii Stotskyi, Jul 23 '12 at 11:42
I updated my post with schema.yml – craphunter Jul 23 '12 at 11:54 — craphunter, Jul 23 '12 at 11:54

score 0 · Answer 1 · answered Jul 23 '12 at 11:54

Try this one:

$query = Doctrine_Query::create()
  ->from('Name m')
  ->where('m.created = (SELECT MAX(gn.created) 
                          FROM Name gn
                          GROUP BY gn.id 
                          HAVING m.id = gn.id)');

Link to the documentation

convert into doctrine

1 Answers1