fixtures, getReference() ne fonctionne pas

**eliysha** · 19/02/2012, 21h14

bonsoir !
j'ai un souci depuis hier, mais je m'en sors pas. je veux réutiliser les objets créées dans les fixtures mais ça marche pas.
donc dans le userfixtures j'ai

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$user1 = new User();
$user1->setUsername("xxx");
$user1->setUsernameCanonical("xxx");
$user1->setEmail("xxxx@gmail.com");
$user1->setEmailCanonical(xxxx@gmail.com");
$user1->setEnabled(true);
$user1->setLocked(0);
$user1->setExpired(0);
$user1->addRole('ROLE_ADMIN');
$user1->setIsPremium(1);
$user1->setPlainPassword("test");
$user1->setSalt(md5(time()));
$encoder = new MessageDigestPasswordEncoder('sha512');
$password = $encoder->encodePassword('test', $user1->getSalt());
$user1->setPassword($password);
$manager->persist($user1);
$this->addReference('user-1',$user1);

dans robotfixtures

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
$robot1 = new Robot();
$robot1->setName("Optimus prime");
$robot1->setDescription("superbe robot");
$robot1->setPrice(259.99);
$robot1->setSlug($robot1->getName());
$manager->persist($robot1);
$this->addReference('robot-1', $robot1);

puis dans possessFixtures qui est ma table de liaison

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
$possess1 = new RobotPossess();
$possess1->setUser($manager->merge($this->getReference('user-1')));
$possess1->setRobot($manager->merge($this->getReference('robot-1')));
$this->addReference('possess-1',$possess1);
$manager->persist($possess1);

quand je fais ça il ne retrouve pas les références de user-1 et robot-1 du coup ma requête foire avec cette erreur

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

j'ai regardé le fichier log, voici la requête générée, il est normal qu'elle ne fonctionne pas puisqu'il manque le user_id et le robot_id

[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO posseder_robot (robot_id, user_id, created, updated) VALUES (?, ?, ?, ?) ({"1":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"2":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

merci de votre aide, je bloque dessus depuis hier

ah oui je tiens à préciser que ce n'est pas à cause du getOrder, puisque je récupère le user-1 et le robot-1 après leur création et pas avant.

**arnooo999** · 19/02/2012, 22h43

Si tu ne fais pas appel à la méthode flush aucune requete n'est exécuté. c'est plutôt étonnant que tu aies une erreur.
Dans les logs as tu d'autres requêtes exécutée?

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
//userfixtures
...
$manager->persist($user1);
$manager->flush();//$user est persisté et a désormais un id
$this->addReference('user-1',$user1);
 
//robotFixtures
...
 
$manager->persist($robot1);
$manager->flush();
$this->addReference('robot-1', $robot1);
 
//possesFixtures
...
$possess1->setUser($this->getReference('user-1'));//dans mes fixtures je n'ai pas besoin d'ajouter merge
$possess1->setRobot($this->getReference('robot-1'));
$manager->persist($possess1);
$manager->flush();

PS:

utilises la balise code dans tes messages
il y a une extension sluggable pour doctrine
normalement une table de liaison de devrait pas étre mappé à une entité (as-tu vraiment besoin de createdAt et updatedAt?)

**RapotOR** · 20/02/2012, 08h42

Dans tes classes de fixtures, as tu bien utilisé :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
 
     public function getOrder()
    {
        return 1; // ordre d'appel
    }

Par exemple:
User doit avoir 1
Robot doit avoir 2
RobotPossess doit avoir 3 => bah oui les premières références doivent être créées avant!

**eliysha** · 20/02/2012, 10h01

Envoyé par RapotOR

Dans tes classes de fixtures, as tu bien utilisé :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
 
     public function getOrder()
    {
        return 1; // ordre d'appel
    }

Par exemple:
User doit avoir 1
Robot doit avoir 2
RobotPossess doit avoir 3 => bah oui les premières références doivent être créées avant!

oui j'utilise le getOrder, j'ai mis le user en premier, ensuite le robot et enfin RobotPossess

**arnooo999** · 20/02/2012, 10h55

Donc les premieres fixtures sont bien utilisées.
Qu'est ce que ça donnes en ajoutant ça dans PossesFixtures:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
 
$user1=$this->getReference('user-1');
echo "\n\t user1 est de classe",get_class($user1),' son id est ',$user1->getId();
$possess1->setUser($user1);
$possess1->setRobot($this->getReference('robot-1'));
$manager->persist($possess1);
$manager->flush();

à voir également
Est-ce que tout fonctionne si tu désactives ProcessFixtures?
Est-ce qu'il y a des fixtures ou tu utilises le getReference avec succées ?
Est-ce que tu as généré un crud sur PossesFixtures et que celui-ci fonctionne ?
Est-ce que ça peut venir du mapping plutôt que des doctrine fixtures?

Je reste perplexe sur l'entité ProcessFixtures et sur la signification de created et updated.
sur une table de liaison on ne gére finalement que des insert et des delete.
Il y a également une extension Loggable mais je ne sais pas si elle fonctionne pour des relations ManyToMany

**eliysha** · 20/02/2012, 20h37

Envoyé par arnooo999

Donc les premieres fixtures sont bien utilisées.
Qu'est ce que ça donnes en ajoutant ça dans PossesFixtures:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
 
$user1=$this->getReference('user-1');
echo "\n\t user1 est de classe",get_class($user1),' son id est ',$user1->getId();
$possess1->setUser($user1);
$possess1->setRobot($this->getReference('robot-1'));
$manager->persist($possess1);
$manager->flush();

à voir également
Est-ce que tout fonctionne si tu désactives ProcessFixtures?
Est-ce qu'il y a des fixtures ou tu utilises le getReference avec succées ?
Est-ce que tu as généré un crud sur PossesFixtures et que celui-ci fonctionne ?
Est-ce que ça peut venir du mapping plutôt que des doctrine fixtures?

Je reste perplexe sur l'entité ProcessFixtures et sur la signification de created et updated.
sur une table de liaison on ne gére finalement que des insert et des delete.
Il y a également une extension Loggable mais je ne sais pas si elle fonctionne pour des relations ManyToMany

je viens de tester sans les fixtures concernant la table de liaison ça passe nickel
j'ai testé aussi ton astuce avec le echo voici le résultat

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
eliysha:ironbot eliysha$ php app/console doctrine:fixtures:load
  > purging database
  > loading xxxx\UserBundle\DataFixtures\ORM\UserFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\ForumFixtures
  > loading xxxx\MarketBundle\DataFixtures\ORM\RobotFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\CategoryFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\SubForumFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\ArticleFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\TopicFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\CommentFixtures
  > loading xxxx\BlogBundle\DataFixtures\ORM\PostFixtures
  > loading xxxx\MarketBundle\DataFixtures\ORM\CategoryProductFixtures
  > loading xxxx\MarketBundle\DataFixtures\ORM\ProductFixtures
  > loading xxxx\MarketBundle\DataFixtures\ORM\RobotPossessFixtures
 
	 user1 est de classeProxies\IronbotUserBundleEntityUserProxy son id est 1
	 robot 1 est de classeProxies\IronbotMarketBundleEntityRobotProxy son id est 1
                                                                                                      [PDOException]                                                                                        
  SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

dans les autres fixtures je fais seulement addReference, il n y a que celui que je fais le getReference.
pour le created et le updated c'est vrai que c'est pas pertinent dans une table de liaison mais je doute que le problème vienne de la...

**eliysha** · 20/02/2012, 09h51

[quote=arnooo999;6515784]Si tu ne fais pas appel à la méthode flush aucune requete n'est exécuté. c'est plutôt étonnant que tu aies une erreur.
Dans les logs as tu d'autres requêtes exécutée?

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
//userfixtures
...
$manager->persist($user1);
$manager->flush();//$user est persisté et a désormais un id
$this->addReference('user-1',$user1);
 
//robotFixtures
...
 
$manager->persist($robot1);
$manager->flush();
$this->addReference('robot-1', $robot1);
 
//possesFixtures
...
$possess1->setUser($this->getReference('user-1'));//dans mes fixtures je n'ai pas besoin d'ajouter merge
$possess1->setRobot($this->getReference('robot-1'));
$manager->persist($possess1);
$manager->flush();

PS:

utilises la balise code dans tes messages
il y a une extension sluggable pour doctrine
normalement une table de liaison de devrait pas étre mappé à une entité (as-tu vraiment besoin de createdAt et updatedAt?)

merci pour ta réponse, mais je fais déjà le $manager->flush je ne l'ai juste pas mis dans le code que j'ai posté.
ok pour l'extension sluggable, je vais regarder
pour le createdAt et l'updatedAt j'en ai pas vraiment besoin mais je m'étais dit qu'un champ date pourra me servir plus tard.
oui j'ai d'autres requêtes qui s'executent dans le log

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"xxx","2":"xxx","3":"xxxx@gmail.com","4":"xxxxx@gmail.com","5":true,"6":"nxqb7oz8qggsow0g44kg80ks0o48oww","7":"KAKQQJaP+GUuBk0yGvzrnyM4Z+0LZo4SCXuE\/72qcQBT7SvdtZ+21rCsR\/G2NoEY3w3Sbq9OvB8y6ZpQcvOnRA==","8":null,"9":0,"10":false,"11":null,"12":"4daxef9g3hgkg88socw8kwo444sk4888kg8go0csksowsg8cc0","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"xxx","2":"xxx","3":"xxxx@gmail.com","4":"xxxx@gmail.com","5":true,"6":"9bfoqglp14gs4ssg0ss08ksg04k8sc0","7":"aVx796byB5K63nop\/+ZMq7nd8GasmB5hKd8Ik4wo+imzQ4BnjeFBLe0U9NLom9NYLS0WM+H1JwyC+9OYE8MFRw==","8":null,"9":0,"10":false,"11":null,"12":"1rzi5oqu14is0o0sog8c00w0sc4o4c80gos8g88owcckcww8k8","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO user_table (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, locked, expired, expires_at, confirmation_token, password_requested_at, roles, credentials_expired, credentials_expire_at, is_premium) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"ccxxxx","2":"rxxx","3":"xxxxx@gmail.com","4":"xxxxx@gmail.com","5":true,"6":"em4kjxd2tuogwcokgog0o84cwwokwsc","7":"YIcSp3J4kw1I3kvSgtsdxsx9+3ZARVTnBCE+ysrJ6edFSam1Us9dep2+OEx7qG8lUKpe5faad0TUsKp5YJX6Gg==","8":null,"9":0,"10":false,"11":null,"12":"3p1vwci1k3eocgs4000sok4cw4gkcso4go8kw0844cc4wck08s","13":null,"14":["ROLE_ADMIN"],"15":false,"16":null,"17":1}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums (name) VALUES (?) ({"1":"Symfony2"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums (name) VALUES (?) ({"1":"Autres"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus prime","2":"logo.png","3":259.99,"4":"superbe robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-prime"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus II","2":"logo.png","3":359.99,"4":"description du super robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-ii"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Optimus XXL","2":"logo.png","3":559.99,"4":"RAS","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"optimus-xxl"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO robot (name, picture, price, description, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Prime","2":"logo.png","3":59.99,"4":"robot","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"prime"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Applications"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Test"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article_cat (name) VALUES (?) ({"1":"Hardware"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Tutoriaux","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":23,"4":"tutoriaux"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Tutoriaux","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":23,"4":"tutoriaux"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Vos projets","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":24,"4":"vos-projets"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_forums_sub (title, description, forum_id, slug) VALUES (?, ?, ?, ?) ({"1":"Discussions libres","2":"Forum du fonctionnement g\u00e9n\u00e9ral de LegTux.","3":24,"4":"discussions-libres"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"The pool on the roof must have a leak","2":"Zero Cool","3":"Vestibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque. Na. Cras elementum molestie vestibulum. Morbi id quam nisl. Praesent hendrerit, orci sed elementum lobortis.","4":"pool_leak.jpg","5":"pool, leaky, hacked, movie, hacking, symarticle","6":"the-pool-on-the-roof-must-have-a-leak","7":37,"8":{"date":"2011-07-23 06:12:33","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-07-23 06:12:33","timezone_type":3,"timezone":"UTC"}}) [] []

[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"The grid - A digital frontier","2":"Kevin Flynn","3":"Lorem commodo. Vestibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque. Nulla consectetur tempus nisl vitae viverra.","4":"the_grid.jpg","5":"grid, daftpunk, movie, symarticle","6":"the-grid-a-digital-frontier","7":39,"8":{"date":"2011-06-02 18:54:12","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-06-02 18:54:12","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO article (title, author, content, image, tags, slug, category_id, created, updated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"You're either a one or a zero. Alive or dead","2":"Gary Winston","3":"Lorem ipsum dolor sit amet, consectetur adipiscing elittibulum vulputate mauris eget erat congue dapibus imperdiet justo scelerisque.","4":"one_or_zero.jpg","5":"binary, one, zero, alive, dead, !trusting, movie, symarticle","6":"you-re-either-a-one-or-a-zero-alive-or-dead","7":null,"8":{"date":"2011-04-25 15:34:18","timezone_type":3,"timezone":"UTC"},"9":{"date":"2011-04-25 15:34:18","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO forum_topic (title, forum_sub_id) VALUES (?, ?) ({"1":"Probl\u00e8me de cache","2":37}) [] []
[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"symfony","2":"To make a long story short. You can't go wrong by choosing Symfony! And no one has ever been fired for using Symfony.","3":true,"4":46,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"David","2":"To make a long story short. Choosing a framework must not be taken lightly; it is a long-term commitment. Make sure that you make the right selection!","3":true,"4":46,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"Dade","2":"Anything else, mom? You want me to mow the lawn? Oops! I forgot, New York, No grass.","3":true,"4":47,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

[2012-02-18 14:33:59] doctrine.DEBUG: INSERT INTO comment (user, comment, approved, article_id, created, updated) VALUES (?, ?, ?, ?, ?, ?) ({"1":"Gary","2":"Bill Who?","3":true,"4":50,"5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie1","2":null,"3":"e the 1500s, when an unknown printer unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie1"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie 2","2":null,"3":"Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words,","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie-2"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie 3","2":null,"3":"the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie-3"}) [] []
[2012-02-18 14:33:59] doctrine.DEBUG: UPDATE category_product SET parent_id = ? WHERE id = ? ([46,47]) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Domestique","2":null,"3":"when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.  de test","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"domestique"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO category_product (name, parent_id, description, picture, created, updated, slug) VALUES (?, ?, ?, ?, ?, ?, ?) ({"1":"Categorie1","2":null,"3":"e the 1500s, when an unknown printer unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop","4":"logo.png","5":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"6":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"7":"categorie1"}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Lycos","2":"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it ","3":5.9,"4":"icon.png","5":false,"6":"va chercher !!!","7":"x32x2","8":0,"9":0,"10":49,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"lycos","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"Why do we use it","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"bot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"briefing","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"bot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":0,"4":"icon.png","5":false,"6":"Why do we use it","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Irobot II","2":"hich don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true gener","3":18.9,"4":"icon.png","5":false,"6":"Why ?","7":"xxx322","8":0,"9":0,"10":46,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"irobot-ii","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO product (name, description, price, picture, enabled, brief_description, product_code, in_stock, customer_votes, category_id, created, slug, updated, path) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ({"1":"Ibot","2":"hsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in this the first true gener","3":3.9,"4":"icon.png","5":false,"6":"Where does it come from","7":"xxx322","8":0,"9":0,"10":47,"11":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"12":"ibot","13":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"14":null}) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: UPDATE category_product SET parent_id = ? WHERE id = ? ([50,49]) [] []
[2012-02-18 14:33:59] 
doctrine.DEBUG: INSERT INTO posseder_robot (robot_id, user_id, created, updated) VALUES (?, ?, ?, ?) ({"1":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"},"2":{"date":"2012-02-18 14:33:59","timezone_type":3,"timezone":"UTC"}}) [] []

fixtures, getReference() ne fonctionne pas

Doctrine2 PHP

Vue hybride

Discussions similaires

Partager

Partager