http://stereointeractive.com/blog Development Blog Sun, 11 May 2008 17:39:06 +0000 http://backend.userland.com/rss092 en It's easy to create transactions with Propel. This can be very useful when you are deleting rows from your database from multiple tables, and want to do an "all or nothing" approach so that things don't get messy. http://stereointeractive.com/blog/2008/02/29/propel-transactions-with-symfony/ svnX is a great mac GUI for svn repositories. A lot of our svn servers are accessed via non-standard ports for security, and a limitation of the svn+ssh syntax is that you can't specify a non-standard port in the address name. To get around this in the command line, you ... http://stereointeractive.com/blog/2008/02/09/using-svnx-with-svnssh-on-a-non-standard-port/ Here is a way to do left join on two columns in a table that both were foreign keys in the same table using Propel. This might happen if for example you have a table with a parent_id and a child_id in a nested set that both refer to the ... http://stereointeractive.com/blog/2008/01/24/propel-criteria-left-join-using-addjoin-and-addalias-to-join-a-table-twice/ I've found the best way to install symfony on Leopard is to use the version from SVN. I find this is easy to do, and easy to update in the future. Here is a cheat sheet for those looking to get up and running with symfony on their Mac running ... http://stereointeractive.com/blog/2008/01/24/installing-symfony-on-leopard/ Mac OS 10.5 Leopard ships with Apache2 and SVN. However, if you want to keep a local svn repository and not use an external svn server (only really useful if you have projects which you will be the only developer), you have to set up the repository yourself. Here is ... http://stereointeractive.com/blog/2008/01/21/svn-apache2-os-x-leopard-105/ Loading data from fixtures can be extremely useful to pre-populate your database so you have something to test and code with. I frequently use the propel-load-data task in two ways, the first when altering the schema, and the second to add some new data on top of whats in the ... http://stereointeractive.com/blog/2008/01/14/symfony-propel-load-data/ I'm sure this happened to a lot of us, but I started out with my Windows Boot Camp partition about 5GB. My only intention was to use it to test out our web sites in multiple windows browsers. However, after installing all of the Windows XP updates, service packs, VMware ... http://stereointeractive.com/blog/2008/01/11/resize-a-boot-camp-partition-for-use-with-vmware-fusion/ Propel's use of the Criteria class has many unknown features documented deep within the propel API. One of my favorites is setDistinct(), which will add the DISTINCT keyword into the start of your query. This is very useful when you want to create a select menu that presents a list ... http://stereointeractive.com/blog/2007/12/13/propel-set-distinct-setdistinct/ Symfony allows you to dish off the responsibility of sending an email to another module/action when necessary, which can be great because it can utilize the "view" aspect of the framework so you can store your email formatting (plain text or HTML) as a template just like you would for ... http://stereointeractive.com/blog/2007/11/16/sending-email-within-symfony/ If you accidentally remove a directory from your version-controlled project and try to commit, you will probably get an error similar to this. To fix it, try and remember *not* to remove or move any version-controlled file from the filesystem directly, but rather use the "svn mv" or "svn rm" ... http://stereointeractive.com/blog/2007/11/12/svn-cant-commit-working-copy-is-missing-or-not-locked/