Capistrano | 2 Oct 18:47 2008
Picon

Works procedures


I would like to work with procedures in propel, but i don't find refereces
about this.
So can you help me about this "problem"?
I create any procedures for my tabels ,  how to do for to use this
procedures in my classes? Propel create automatically this procedures if I
put in scheme.xml?
I'm sorry for my English, I'm learning yet.
--

-- 
View this message in context: http://www.nabble.com/Works-procedures-tp19783123p19783123.html
Sent from the propel - users mailing list archive at Nabble.com.
Hans Lellelid | 2 Oct 22:45 2008
Picon

Re: Works procedures

You would need to use custom SQL to use stored procedures from Propel. 
See:
http://propel.phpdb.org/trac/wiki/Users/Documentation/1.3/BasicCRUD#UsingCustomSQL

Hans

On Thu, 2 Oct 2008 09:47:05 -0700 (PDT), Capistrano
<diogo.capistrano <at> gmail.com> wrote:
> 
> I would like to work with procedures in propel, but i don't find
refereces
> about this.
> So can you help me about this "problem"?
> I create any procedures for my tabels ,  how to do for to use this
> procedures in my classes? Propel create automatically this procedures if
I
> put in scheme.xml?
> I'm sorry for my English, I'm learning yet.
> --
> View this message in context:
> http://www.nabble.com/Works-procedures-tp19783123p19783123.html
> Sent from the propel - users mailing list archive at Nabble.com.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe <at> propel.tigris.org
> For additional commands, e-mail: users-help <at> propel.tigris.org
Capistrano | 2 Oct 22:59 2008
Picon

Re: Works procedures


If I want my Peer class to use procedure for insert data in database? Propel
create it automatically?

Example:
public function save(){
   $sql = "PROCEDURE INSERT";
   ...
}

Hans Lellelid wrote:
> 
> You would need to use custom SQL to use stored procedures from Propel. 
> See:
> http://propel.phpdb.org/trac/wiki/Users/Documentation/1.3/BasicCRUD#UsingCustomSQL
> 
> Hans
> 
> On Thu, 2 Oct 2008 09:47:05 -0700 (PDT), Capistrano
> <diogo.capistrano <at> gmail.com> wrote:
>> 
>> I would like to work with procedures in propel, but i don't find
> refereces
>> about this.
>> So can you help me about this "problem"?
>> I create any procedures for my tabels ,  how to do for to use this
>> procedures in my classes? Propel create automatically this procedures if
> I
>> put in scheme.xml?
>> I'm sorry for my English, I'm learning yet.
(Continue reading)

Hans Lellelid | 3 Oct 00:52 2008
Picon

Re: Works procedures

No... You would have to put that in your subclass.

Hans

On Oct 2, 2008, at 16:59, Capistrano <diogo.capistrano <at> gmail.com> wrote:

>
> If I want my Peer class to use procedure for insert data in  
> database? Propel
> create it automatically?
>
> Example:
> public function save(){
>   $sql = "PROCEDURE INSERT";
>   ...
> }
>
> Hans Lellelid wrote:
>>
>> You would need to use custom SQL to use stored procedures from  
>> Propel.
>> See:
>> http://propel.phpdb.org/trac/wiki/Users/Documentation/1.3/BasicCRUD#UsingCustomSQL
>>
>> Hans
>>
>> On Thu, 2 Oct 2008 09:47:05 -0700 (PDT), Capistrano
>> <diogo.capistrano <at> gmail.com> wrote:
>>>
>>> I would like to work with procedures in propel, but i don't find
(Continue reading)

Daum | 8 Oct 03:20 2008
Picon

Left join getting added twice?

Hi All-

Since it formats a bit better on a forum, here is the link: 
http://www.symfony-project.org/forum/index.php/t/16067/

A sample of the query produces if i do all the aliasing and all the joins is 
this:
SELECT catalyst.ID, catalyst.STOCK_ID, catalyst.NAME, catalyst.WEIGHTING, 
catalyst.IS_SYSTEMIC, catalyst.RANKING, catalyst.PROBABILITY, 
catalyst.IS_BULL, catalyst.CONVICTION, catalyst.CONSENSUS, 
catalyst.START_DATE, catalyst.END_DATE, catalyst.TIER_1, catalyst.TIER_2, 
catalyst.TIER_3, catalyst.TIER_4, catalyst.TIER_5, catalyst.TIER_6, 
catalyst.TIER_7, catalyst.TIER_8, catalyst.TIER_9, catalyst.TIER_10 FROM 
catalyst LEFT JOIN network ON (catalyst.TIER_1=network.NETWORK_ID) LEFT JOIN 
network network2 ON (catalyst.TIER_2=network2.NETWORK_ID) LEFT JOIN network 
network3 ON (catalyst.TIER_3=network3.NETWORK_ID) LEFT JOIN network network4 
ON (catalyst.TIER_4=network4.NETWORK_ID) LEFT JOIN network network5 ON 
(catalyst.TIER_5=network5.NETWORK_ID) LEFT JOIN network network6 ON 
(catalyst.TIER_6=network6.NETWORK_ID) LEFT JOIN network network7 ON 
(catalyst.TIER_7=network7.NETWORK_ID) LEFT JOIN network network8 ON 
(catalyst.TIER_8=network8.NETWORK_ID) LEFT JOIN network network9 ON 
(catalyst.TIER_9=network9.NETWORK_ID) LEFT JOIN network network10 ON 
(catalyst.TIER_10=network10.NETWORK_ID) LEFT JOIN network ON 
(catalyst.TIER_1=network.NETWORK_ID) LEFT JOIN network network2 ON 
(catalyst.TIER_2=network2.NETWORK_ID) LEFT JOIN network network3 ON 
(catalyst.TIER_3=network3.NETWORK_ID) LEFT JOIN network network4 ON 
(catalyst.TIER_4=network4.NETWORK_ID) LEFT JOIN network network5 ON 
(catalyst.TIER_5=network5.NETWORK_ID) LEFT JOIN network network6 ON 
(catalyst.TIER_6=network6.NETWORK_ID) LEFT JOIN network network7 ON 
(catalyst.TIER_7=network7.NETWORK_ID) LEFT JOIN network network8 ON 
(Continue reading)

Daum | 8 Oct 04:28 2008
Picon

Re: Left join getting added twice?

It seems that if i don't specify the type of join, then it works, but if i 
specify right inner or left it has the same problem with the repeats.
Daum
Chris Petersen | 8 Oct 06:20 2008
Picon

RE: Re: Left join getting added twice?

Daum,

I haven't looked at your Propel code but I have experienced this issue. You need to either specify all of your
join types or none of your join types. If your code has both then update the ones that don't with the default
join type (CRITERIA::JOIN).

Chris Petersen

-----Original Message-----
From: Daum [mailto:matttah <at> gmail.com]
Sent: Wednesday, 8 October 2008 1:28 PM
To: users <at> propel.tigris.org
Subject: [propel] Re: Left join getting added twice?

It seems that if i don't specify the type of join, then it works, but if i
specify right inner or left it has the same problem with the repeats.
Daum

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe <at> propel.tigris.org
For additional commands, e-mail: users-help <at> propel.tigris.org

The information in this email is confidential and may be privileged or subject to copyright. It is intended
for the exclusive use of the addressee(s). If you are not an addressee, please do not copy, distribute or
otherwise act on the email. If you have received the email in error, please contact the sender immediately
and delete the email. The unauthorised use of this email may result in liability for breach of
confidentiality, privilege or copyright.
Daum | 8 Oct 08:44 2008
Picon

Re: Re: Left join getting added twice?

Chris-
i've specified each time i do the add Join.  The weird thing is if i specifiy 
it adds it twice, if i doesn't it doesn't.
Daum

On Wednesday 08 October 2008, Chris Petersen wrote:
> Daum,
>
> I haven't looked at your Propel code but I have experienced this issue. You
> need to either specify all of your join types or none of your join types.
> If your code has both then update the ones that don't with the default join
> type (CRITERIA::JOIN).
>
> Chris Petersen
>
> -----Original Message-----
> From: Daum [mailto:matttah <at> gmail.com]
> Sent: Wednesday, 8 October 2008 1:28 PM
> To: users <at> propel.tigris.org
> Subject: [propel] Re: Left join getting added twice?
>
> It seems that if i don't specify the type of join, then it works, but if i
> specify right inner or left it has the same problem with the repeats.
> Daum
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe <at> propel.tigris.org
> For additional commands, e-mail: users-help <at> propel.tigris.org
>
>
(Continue reading)

Daum | 8 Oct 19:10 2008
Picon

Re: Re: Left join getting added twice?

Sorry to clear up what that last email was about.  Each time I do the joins I 
am specifying left join.  If i do all the $c->addJoin... but without 
specifying any special type of join then it executes a regular join properly 
and correctly.  

Does maybe the criteria class do a join somewhere that I don't see?
Daum

On Wednesday 08 October 2008, Daum wrote:
> Chris-
> i've specified each time i do the add Join.  The weird thing is if i
> specifiy it adds it twice, if i doesn't it doesn't.
> Daum
>
> On Wednesday 08 October 2008, Chris Petersen wrote:
> > Daum,
> >
> > I haven't looked at your Propel code but I have experienced this issue.
> > You need to either specify all of your join types or none of your join
> > types. If your code has both then update the ones that don't with the
> > default join type (CRITERIA::JOIN).
> >
> > Chris Petersen
> >
> > -----Original Message-----
> > From: Daum [mailto:matttah <at> gmail.com]
> > Sent: Wednesday, 8 October 2008 1:28 PM
> > To: users <at> propel.tigris.org
> > Subject: [propel] Re: Left join getting added twice?
> >
(Continue reading)

Hans Lellelid | 8 Oct 19:21 2008
Picon

Re: Re: Left join getting added twice?

Hi --

Yeah, I'm assuming there is some logic inside the createSelectSql() that is
causing the JOINs to get added twice.  I'm a bit surprised at this -- and
we should definitely add a unit test to test for this if this is indeed a
bug.  I assume you're using latest (1.3.0) version of Propel?

Hans

On Wed, 8 Oct 2008 13:10:30 -0400, Daum <matttah <at> gmail.com> wrote:
> Sorry to clear up what that last email was about.  Each time I do the
joins
> I
> am specifying left join.  If i do all the $c->addJoin... but without
> specifying any special type of join then it executes a regular join
> properly
> and correctly.
> 
> Does maybe the criteria class do a join somewhere that I don't see?
> Daum
> 
> On Wednesday 08 October 2008, Daum wrote:
>> Chris-
>> i've specified each time i do the add Join.  The weird thing is if i
>> specifiy it adds it twice, if i doesn't it doesn't.
>> Daum
>>
>> On Wednesday 08 October 2008, Chris Petersen wrote:
>> > Daum,
>> >
(Continue reading)


Gmane