Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. doctrine:
  2. dbal:
  3. default_connection: default
  4. connections:
  5. default:
  6. driver: pdo_mysql
  7. host: "%database_host%"
  8. port: "%database_port%"
  9. dbname: "%database_name%"
  10. user: "%database_user%"
  11. password: "%database_password%"
  12. charset: UTF8
  13. dbsync:
  14. driver: pdo_mysql
  15. host: "%database_sync_host%"
  16. port: "%database_sync_port%"
  17. dbname: "%database_sync_name%"
  18. user: "%database_sync_user%"
  19. password: "%database_sync_password%"
  20. charset: UTF8
  21.  
  22. orm:
  23. auto_generate_proxy_classes: "%kernel.debug%"
  24. naming_strategy: doctrine.orm.naming_strategy.underscore
  25. auto_mapping: true
  26.  
  27. ...->getManager()->getConnection('dbsync');
  28.  
  29. <?php
  30. namespace EntBundleService;
  31.  
  32. use DoctrineORMEntityManager;
  33. use EntBundleEntityUserUser;
  34.  
  35. class MajUsers {
  36.  
  37. private $em;
  38.  
  39. /**
  40. * @param EntityManager $em
  41. */
  42. public function __construct(EntityManager $em)
  43. {
  44. $this->em = $em;
  45. }
  46.  
  47. public function runUpdate()
  48. {
  49. $conn = $this->em->getManager('dbsync')->getConnection('dbsync');
  50. $personnels_sync = $conn->fetchAll("SELECT * FROM xxxxx WHERE etat = 1 AND login !='' ORDER BY xxx, yyyyLIMIT 10");
  51. .....
  52. .....
  53. }
  54. }
  55.  
  56. ent.maj_users:
  57. class: EntBundleServiceMajUsers
  58. arguments:
  59. - '@doctrine.orm.entity_manager'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement