A mailing list for Phing user discussions

Capistrano | 2 Oct 2008 18:47

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 2008 22:45

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 2008 22:59

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 2008 00:52

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 2008 03:20

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 2008 04:28

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 2008 06:20

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 2008 08:44

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 2008 19:10

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 2008 19:21

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)

Group

gmane.comp.php.phing.user.

Advertisement

Project Web Page

A mailing list for Phing user discussions

Search Archive

Page

1 | 2 | 3 | 4 | 5

Articles in period: 46

October 2008

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

Quien sabe si sera verdad, suena un poco a truco... (8 Mar 2011)
Pager offset question (24 Aug 2009)
Does anybody understand MySQL? (23 Jul 2009)
Finding those slow queries (21 Jul 2009)
[propel-dev] DB Migrations Architecture (18 Jul 2009)
Building objects from schema, error when encountering TEXT column. (8 Jul 2009)
5.3 Coding Standards (2 Jul 2009)
[propel] Question about clearInstancePool() (30 Jun 2009)
PHP 5.3 Due out Thursday. Namespaces? (23 Jun 2009)
Propel does not perform update (23 Apr 2009)
Joins with multiple conditions (14 Apr 2009)
Joins with multiple conditions (14 Apr 2009)
best practice - creating object over multiple tables (13 Apr 2009)
Joins with multiple conditions (2 Apr 2009)
Joins with multiple conditions (2 Apr 2009)
Refreshing objects (2 Apr 2009)
Archiving records (2 Apr 2009)
PHP 5.3 and Propel (26 Mar 2009)
php|architect Webinar on Propel this Friday (24 Mar 2009)
problems with select especific fields v1.3 (19 Mar 2009)
problems with select especific fields v1.3 (19 Mar 2009)

Archives

1	March 2011
1	August 2009
23	July 2009
6	June 2009
13	April 2009
50	March 2009
36	February 2009
48	January 2009
27	December 2008
57	November 2008
46	October 2008
51	September 2008
44	August 2008
98	July 2008
52	June 2008
58	May 2008
55	April 2008
73	March 2008
79	February 2008
132	January 2008
228	December 2007
189	November 2007
127	October 2007
68	September 2007
91	August 2007
64	July 2007
135	June 2007
77	May 2007
77	April 2007
79	March 2007
66	February 2007
61	January 2007
52	December 2006
99	November 2006
70	October 2006
101	September 2006
81	August 2006
78	July 2006
110	June 2006
1	January 2004

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template