This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » development » Miscellaneous » Propel help for beginners - version 1
Re: Propel help for beginners - version 1 [message #57385 is a reply to message #30399 ] Thu, 31 July 2008 09:36 Go to previous messageGo to next message
volod  is currently offline volod
Messages: 85
Registered: June 2008
Member
Hello,

looks good. Do you plan to extend to support JOINs?


Vladimir Bilyov Websites development and support, Design, SEO
Re: Propel help for beginners - version 1 [message #57400 is a reply to message #30399 ] Thu, 31 July 2008 12:47 Go to previous messageGo to next message
halfer  is currently offline halfer
Messages: 9535
Registered: January 2006
Location: West Midlands, UK
Faithful Member
Hi volod

I did plan to support other things, but I'm really finding it difficult to find the time for it. Perhaps someone else would like to have a go at implementing something? The code is available on a link in this thread (or if someone asks for it, I will make a new tarball, in case the existing one is out of date).


Remember Palestine
Re: Propel help for beginners - version 1 [message #57507 is a reply to message #57400 ] Fri, 01 August 2008 06:37 Go to previous messageGo to next message
n_shukla2000
Messages: 32
Registered: February 2008
Member
Fabulous !!!!!!
looks very useful great job ! Very Happy
Re: Propel help for beginners - version 1 [message #58674 is a reply to message #30399 ] Thu, 14 August 2008 13:02 Go to previous messageGo to next message
benhaines  is currently offline benhaines
Messages: 62
Registered: August 2006
Location: London
Member
This is one of the most useful tools for Symfony!! Halfer... for this and so many other issues you've helped me fix through the forum. Thank you!
Re: Propel help for beginners - version 1 [message #58675 is a reply to message #30399 ] Thu, 14 August 2008 13:04 Go to previous messageGo to next message
halfer  is currently offline halfer
Messages: 9535
Registered: January 2006
Location: West Midlands, UK
Faithful Member
Very welcome Very Happy


Remember Palestine
icon14.gif  Re: Propel help for beginners - version 1 [message #70352 is a reply to message #30399 ] Tue, 20 January 2009 19:46 Go to previous messageGo to next message
matmar10  is currently offline matmar10
Messages: 11
Registered: May 2008
Junior Member
WOW! Many kudos!!! Great tool--keep up the good work Cool
Re: Propel help for beginners - version 1 [message #73944 is a reply to message #30399 ] Tue, 03 March 2009 14:24 Go to previous messageGo to next message
halfer  is currently offline halfer
Messages: 9535
Registered: January 2006
Location: West Midlands, UK
Faithful Member
Following on from some interest in extending this tool, I have today re-snapshotted the project to ensure all my last changes and tweaks are included! The tarball is here:

http://propel.jondh.me.uk/propel-gen.tar.bz2

Should anyone else wish to work on this, it would be wise to ping this thread, so work can be co-ordinated between interested contributors.


Remember Palestine
Re: Propel help for beginners - version 1 [message #85570 is a reply to message #30399 ] Mon, 21 September 2009 04:59 Go to previous messageGo to next message
lkrubner  is currently offline lkrubner
Messages: 297
Registered: July 2008
Location: Virginia, USA
Faithful Member
Problem.

I tried this SQL:

SELECT sf_guard_user.username, sf_guard_user_profile.first_name, sf_guard_user_profile.last_name 
FROM sf_guard_user LEFT JOIN sf_guard_user_profile
ON sf_guard_user.id = sf_guard_user_profile.user_id
WHERE sf_guard_user.id = 1


It gave me this:

$c = new Criteria();
$crit0 = $c->getNewCriterion(SfGuardUserPeer::ID, 1);

// Perform  at level 0 ($crit0 )


// Remember to change the peer class here for the correct one in your model
$c->add($crit0);
$result = TablePeer::doSelect($c);

// This loop will of course need to be edited to work
foreach ($result as $obj)
{
	//$val = $obj->getValue();
}



That doesn't seem right, does it?



Symfony Experts offers answers: http://www.symfonyexperts.com/
Re: Propel help for beginners - version 1 [message #85626 is a reply to message #85570 ] Tue, 22 September 2009 12:50 Go to previous messageGo to next message
halfer  is currently offline halfer
Messages: 9535
Registered: January 2006
Location: West Midlands, UK
Faithful Member
The problem there is that it doesn't understand sql keywords ("SELECT", "WHERE", "JOIN" etc) and it only works with one table. The initial idea was just to help users code complex nested WHERE clauses, as per the demo clause.

I have no time to maintain it, but I've left it up for interest, and I believe people are still using it. I've had one or two people express interest in working on it - adding multiple table and join support - but not received donations of code yet!


Remember Palestine
Re: Propel help for beginners - version 1 [message #98325 is a reply to message #85626 ] Fri, 30 April 2010 20:23 Go to previous messageGo to next message
lkrubner  is currently offline lkrubner
Messages: 297
Registered: July 2008
Location: Virginia, USA
Faithful Member
Is there a sense that at this point everyone is switching to Doctrine? Otherwise it would make sense to people like me to continue to support projects that help improve the analysis of SQL -> Propel code.



Symfony Experts offers answers: http://www.symfonyexperts.com/
Re: Propel help for beginners - version 1 [message #98381 is a reply to message #98325 ] Sun, 02 May 2010 16:27 Go to previous messageGo to next message
xplo  is currently offline xplo
Messages: 428
Registered: September 2008
Faithful Member
Well not everyone is switching to doctrine Smile
but it s true that for new project that even use propel, propel new modelCriteria made the old criteria useless.
Re: Propel help for beginners - version 1 [message #98493 is a reply to message #30399 ] Tue, 04 May 2010 13:18 Go to previous message
halfer  is currently offline halfer
Messages: 9535
Registered: January 2006
Location: West Midlands, UK
Faithful Member
@lkrubner - there are still Propel 1.2 users about! However I should think many have upgraded to 1.4 and are awaiting 1.5 - it's just that we've not had time, and probably won't for a good while. It works, performance is OK, and no security issues have crept in - hence we won't be given the time to upgrade to 1.3+.

Doctrine is certainly flavour of the month, especially with Symfony 2 having gone in that direction, but Propel will stick around. It might be an idea to start developing for Doctrine, and offering Propel variants if there is demand from the userbase.


Remember Palestine
Previous Topic:Developer needed for Symfony server migration and application development [Project-based]
Next Topic:What license should I choose?
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software