{"id":193,"date":"2017-10-23T09:56:42","date_gmt":"2017-10-23T07:56:42","guid":{"rendered":"https:\/\/numa-bord.com\/miniblog\/?p=193"},"modified":"2017-10-23T09:56:42","modified_gmt":"2017-10-23T07:56:42","slug":"symfony-obtenir-enregistrement-aleatoire-doctrine","status":"publish","type":"post","link":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/","title":{"rendered":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine"},"content":{"rendered":"

Doctrine ne permet pas par d\u00e9faut d’obtenir un enregistrement al\u00e9atoire, ce qui est pourtant en principe tr\u00e8s simple avec mysql. Par contre il est possible de faire une requ\u00eate native et de demander a doctrine de \u00ab\u00a0mapper\u00a0\u00bb les r\u00e9sultats. Il devient alors facile de r\u00e9cup\u00e9rer notre enregistrement al\u00e9atoire sous le format habituel (entit\u00e9 doctrine). Voici ci-dessous la m\u00e9thode d’un repository permettant de la faire.<\/p>\n

class<\/span> ExempleRepository extends<\/span> \\Doctrine\\ORM\\EntityRepository {<\/span>
\n
\n    public<\/span> function<\/span> findRandom(<\/span>)<\/span> {<\/span>
\n        $rsm<\/span> =<\/span> new<\/span> \\Doctrine\\ORM\\Query\\ResultSetMappingBuilder(<\/span>$this<\/span>-><\/span>getEntityManager<\/span>(<\/span>)<\/span>)<\/span>;<\/span>
\n        $rsm<\/span>-><\/span>addRootEntityFromClassMetadata<\/span>(<\/span>\\AppBundle\\Entity\\Exemple::<\/span>class<\/span>,<\/span> 'exemple'<\/span>)<\/span>;<\/span>
\n        $sql<\/span> =<\/span> "SELECT * FROM exemple ORDER BY RAND() LIMIT 1"<\/span>;<\/span>
\n        return<\/span> $this<\/span>-><\/span>getEntityManager<\/span>(<\/span>)<\/span>-><\/span>createNativeQuery<\/span>(<\/span>$sql<\/span>,<\/span> $rsm<\/span>)<\/span>-><\/span>getOneOrNullResult<\/span>(<\/span>)<\/span>;<\/span>
\n    }<\/span>
\n
\n}<\/span><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Doctrine ne permet pas par d\u00e9faut d’obtenir un enregistrement al\u00e9atoire, ce qui est pourtant en principe tr\u00e8s simple avec mysql. Par contre il est possible de faire une requ\u00eate native et de demander a doctrine de \u00ab\u00a0mapper\u00a0\u00bb les r\u00e9sultats. Il devient alors facile de r\u00e9cup\u00e9rer notre enregistrement al\u00e9atoire sous le format habituel (entit\u00e9 doctrine). Voici […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,4,3],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","category-developpement","category-doctrine","category-symfony"],"acf":[],"yoast_head":"\nSymfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"og:description\" content=\"Doctrine ne permet pas par d\u00e9faut d’obtenir un enregistrement al\u00e9atoire, ce qui est pourtant en principe tr\u00e8s simple avec mysql. Par contre il est possible de faire une requ\u00eate native et de demander a doctrine de \u00ab\u00a0mapper\u00a0\u00bb les r\u00e9sultats. Il devient alors facile de r\u00e9cup\u00e9rer notre enregistrement al\u00e9atoire sous le format habituel (entit\u00e9 doctrine). Voici […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\" \/>\n<meta property=\"og:site_name\" content=\"Pense b\u00eate d'un d\u00e9veloppeur web\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-23T07:56:42+00:00\" \/>\n<meta name=\"author\" content=\"Numa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Numa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\"},\"author\":{\"name\":\"Numa\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"headline\":\"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine\",\"datePublished\":\"2017-10-23T07:56:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\"},\"wordCount\":128,\"commentCount\":0,\"articleSection\":[\"D\u00e9veloppement\",\"Doctrine\",\"Symfony\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\",\"name\":\"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web\",\"isPartOf\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\"},\"datePublished\":\"2017-10-23T07:56:42+00:00\",\"author\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\"},\"breadcrumb\":{\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/numa-bord.com\/miniblog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#website\",\"url\":\"https:\/\/numa-bord.com\/miniblog\/\",\"name\":\"Pense b\u00eate d'un d\u00e9veloppeur web\",\"description\":\"(php, javascript, Symfony, Wordpress....)\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e\",\"name\":\"Numa\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g\",\"caption\":\"Numa\"},\"url\":\"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/","og_locale":"fr_FR","og_type":"article","og_title":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web","og_description":"Doctrine ne permet pas par d\u00e9faut d’obtenir un enregistrement al\u00e9atoire, ce qui est pourtant en principe tr\u00e8s simple avec mysql. Par contre il est possible de faire une requ\u00eate native et de demander a doctrine de \u00ab\u00a0mapper\u00a0\u00bb les r\u00e9sultats. Il devient alors facile de r\u00e9cup\u00e9rer notre enregistrement al\u00e9atoire sous le format habituel (entit\u00e9 doctrine). Voici […]","og_url":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/","og_site_name":"Pense b\u00eate d'un d\u00e9veloppeur web","article_published_time":"2017-10-23T07:56:42+00:00","author":"Numa","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Numa","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#article","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/"},"author":{"name":"Numa","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"headline":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine","datePublished":"2017-10-23T07:56:42+00:00","mainEntityOfPage":{"@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/"},"wordCount":128,"commentCount":0,"articleSection":["D\u00e9veloppement","Doctrine","Symfony"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/","url":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/","name":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine - Pense b\u00eate d'un d\u00e9veloppeur web","isPartOf":{"@id":"https:\/\/numa-bord.com\/miniblog\/#website"},"datePublished":"2017-10-23T07:56:42+00:00","author":{"@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e"},"breadcrumb":{"@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/numa-bord.com\/miniblog\/symfony-obtenir-enregistrement-aleatoire-doctrine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/numa-bord.com\/miniblog\/"},{"@type":"ListItem","position":2,"name":"Symfony : Obtenir un enregistrement al\u00e9atoire avec doctrine"}]},{"@type":"WebSite","@id":"https:\/\/numa-bord.com\/miniblog\/#website","url":"https:\/\/numa-bord.com\/miniblog\/","name":"Pense b\u00eate d'un d\u00e9veloppeur web","description":"(php, javascript, Symfony, Wordpress....)","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/numa-bord.com\/miniblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/numa-bord.com\/miniblog\/#\/schema\/person\/f9d00acd1703f17e5a6895283eb46a7e","name":"Numa","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f21d1af4658a7106211915940584534c1e0b3eef3f12eb67a697686cad70b64a?s=96&d=mm&r=g","caption":"Numa"},"url":"https:\/\/numa-bord.com\/miniblog\/author\/negonner\/"}]}},"_links":{"self":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":4,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/posts\/193\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/numa-bord.com\/miniblog\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}