Google Groups Home
Help | Sign in
Symfony-fr
Home
+ new post
Pages
Files
About this group
Join this group
Afficher requête MySQL générée par Propel
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
eax  
View profile
  More options Dec 10 2007, 9:15 am
From: eax <sylvain.del...@gmail.com>
Date: Mon, 10 Dec 2007 06:15:02 -0800 (PST)
Local: Mon, Dec 10 2007 9:15 am
Subject: Afficher requête MySQL générée par Propel
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Bonjour

J'ai une requete faite via propel :

$c = new Criteria();
$c->add(LiensUsersGroupesPeer :: ID_USER, $this->getAttribute('id'));
$this->groupes = LiensUsersGroupesPeer :: doSelect($c);

J'aimrais avoir un aperçu de cette requête faite au format MySQL, j'ai
entendu parler d'une méthode toString() mais je ne sais pas comment
faire.

Merci

Sylvain


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Nicolas Perriault  
View profile
 (1 user)  More options Dec 10 2007, 9:24 am
From: "Nicolas Perriault" <nperria...@clever-age.com>
Date: Mon, 10 Dec 2007 15:24:55 +0100
Local: Mon, Dec 10 2007 9:24 am
Subject: Re: [symfony-fr] Afficher requête MySQL générée par Propel
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
On 12/10/07, eax <sylvain.del...@gmail.com> wrote:

> J'aimrais avoir un aperçu de cette requête faite au format MySQL, j'ai
> entendu parler d'une méthode toString() mais je ne sais pas comment
> faire.

echo $criteria->toString() mais ça sera incomplet. Le mieux est de
regarder tes logs symfony en mode dev :)

++

--
Nicolas Perriault    http://www.clever-age.com
Clever Age - conseil en architecture technique
GSM: +33 6 60 92 08 67  Tél: +33 1 53 34 66 10


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
pborreli@gmail.com  
View profile
 (1 user)  More options Dec 10 2007, 9:41 am
From: "pborr...@gmail.com" <pborr...@gmail.com>
Date: Mon, 10 Dec 2007 06:41:13 -0800 (PST)
Local: Mon, Dec 10 2007 9:41 am
Subject: Re: Afficher requête MySQL générée par Propel
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Salut,

Tu peux faire :

$c = new Criteria();
$c->add(LiensUsersGroupesPeer :: ID_USER, $this->getAttribute('id'));
$this->conn = Propel::getConnection();
$this->groupes = LiensUsersGroupesPeer :: doSelect($c,$this->conn);
echo $conn->getLastExecutedQuery();

Bon courage,
Pascal
SQLI Oujda/Maroc

On 10 déc, 14:15, eax <sylvain.del...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
eax  
View profile
  More options Dec 10 2007, 9:49 am
From: eax <sylvain.del...@gmail.com>
Date: Mon, 10 Dec 2007 06:49:15 -0800 (PST)
Local: Mon, Dec 10 2007 9:49 am
Subject: Re: Afficher requête MySQL générée par Propel
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Ok, je vous remercie pour vos réponses, je vais tester ça

Sylvain

On 10 déc, 15:41, "pborr...@gmail.com" <pborr...@gmail.com> wrote:


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Nicolas Perriault  
View profile
  More options Dec 10 2007, 9:59 am
From: "Nicolas Perriault" <nperria...@clever-age.com>
Date: Mon, 10 Dec 2007 15:59:20 +0100
Local: Mon, Dec 10 2007 9:59 am
Subject: Re: [symfony-fr] Re: Afficher requête MySQL générée par Propel
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
On 12/10/07, eax <sylvain.del...@gmail.com> wrote:

> Ok, je vous remercie pour vos réponses, je vais tester ça

Effectivement, Propel::getConnection()->getLastExecutedQuery() est une
belle découverte pour moi, merci :)

++

--
Nicolas Perriault    http://www.clever-age.com
Clever Age - conseil en architecture technique
GSM: +33 6 60 92 08 67  Tél: +33 1 53 34 66 10


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google