Making the transition to Symfony 1.2 and Doctrine all at once was never going to be easy. As Doctrine is the future of symfony and I have a distinct Propel addiction, the following steps (based on the early stages of the excellent Jobeet tutorial) will take no time at all and can be practised often to help cement the process in mind until it’s second nature.

This is no substitute for (and will make little sense without first reading) the Jobeet tutorial, nor the documentation. This is just my daily-Symfony-quick-setup-zen-cheatsheet. I hope in time to be doing this one-handed in my sleep while vaccuuming the stairs. Copy+Paste strictly out of bounds.

If you choose to use this and repeat it often, you’ll have setup your web server config’ on your development setup ready to run this, so those steps are omitted.

Posted here in a bit of a rush to respond to Jwage‘s request , I hope they live up to expectation, and that someone finds them useful. I am bound to have made some errors, some omissions or not been concise enough, please let me know.

Create The Project

• mkdir <path_to_local dev>\newsymfonytest
• cd <path_to_local dev>\newsymfonytest

From now on<path_to_local dev>\newsymfonytest is your <project> directory

• php <path_to_symfony>\data\bin\symfony generate:project newsymfonytest
  • Note that this creates an absolute path to Symfony in <project>/config/ProjectConfiguration.class.php which you should update.
• copy the sf folder from <path_to_symfony>\data\web\ into <project>/web or alias it in your server configuration Alias /sf “<path_to_symfony>\data\web\sf”

• Now Symfony is linked from your current location, the <project> root, test local access to Command-Line Interface with php symfony cc
• Check the application has been created by visiting in browser

Setup Doctrine Database

• Replace the setup function in <project>/config/ProjectConfiguration.class.php

public function setup()
{
  $this->enablePlugins(array('sfDoctrinePlugin'));
  $this->disablePlugins(array('sfPropelPlugin'));
}

• Publish any plugin assets: php symfony plugin:publish-assets
• Clear the Cache php symfony cc
• Remove Propel structure, create Doctrine structure:
  • rm config/propel.ini
  • rm config/schema.yml
  • rm config/databases.yml
  • mkdir config/doctrine
• create database in MySQL: mysqladmin -u root -p create newsymfonytest
• << enter password when prompted or omit -p if you have no password set (shame on you!) >>
• setup the YAML schema in <project>/config/doctrine/schema.yml

Here’s my sample schema.yml, lifted from the Jobeet tutorial:

# config/doctrine/schema.yml
SampleCategory:
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string(255), notnull: true, unique: true }

SampleItem:
  actAs: { Timestampable: ~ }
  columns:
    category_id:  { type: integer, notnull: true }
    type:         { type: string(255) }
    is_activated: { type: boolean, notnull: true, default: 0 }
    email:        { type: string(255), notnull: true }
    expires_at:   { type: timestamp, notnull: true }
  relations:
    SampleCategory: { onDelete: CASCADE, local: category_id, foreign: id, foreignAlias: SampleItems }

•  Generate a new Databases.yml:

php symfony configure:database –name=doctrine –class=sfDoctrineDatabase “mysql:host=localhost;dbname=newsymfonytest” <mysqluser> <mysqlpass>

Build!!!

• php symfony doctrine:build-model
• php symfony doctrine:build-sql
• php symfony doctrine:insert-sql
• php symfony doctrine:build-forms

Add Sample Data

Create fixture files:

Here’s my sample <project>data/fixtures/categories.yml, again lifted from the Jobeet tutorial:

SampleCategory:
  design:
    name: Design
  programming:
    name: Programming
  manager:
    name: Manager
  administrator:
    name: Administrator

Here’s my sample <project>data/fixtures/items.yml, curiously similar to one from the Jobeet tutorial I’ve said so little about.

SampleItem:
  job_sensio_labs:
    SampleCategory: programming
    type:         full-time
    is_activated: true
    email:        job@example.com
    expires_at:   '2010-10-10'

• Populate with php symfony doctrine:data-load

Generate first app

• php symfony generate:app –escaping-strategy=on –csrf-secret=1sTh15r34l1y53cur3 frontend
• Visit the site root you set up in your server configuration in your browser

Generate first module

• Then, using the format:

  "php symfony doctrine:generate-module --with-show --non-verbose-templates <appname> <modulename> <modelname>"

php symfony doctrine:generate-module –with-show –non-verbose-templates frontend sample SampleItem

• Visit the module in your browser
• Rinse and repeat