root/branches/trivoallan/batch/post_load.php

<?php
error_reporting(E_ALL);
$app = 'main';
$sf_root = dirname(__FILE__).'/..';
include($sf_root.'/test/bootstrap/functional.php');
include($sf_root.'/lib/symfony/vendor/pake/pakeFunction.php');

// initialize database manager
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();
$con = Propel::getConnection();

function _add_tag_for_app($name, $tags)
{
  $app = ApplicationPeer::retrieveBySlug($name);
  if (is_null($app))
  {
    throw new Exception(sprintf('Unknown app %s', $name));
  }
  $app->addTag($tags);
  $app->save();
  pake_echo_action('tags', sprintf('%s for %s', $tags, $app->getName()));
}

function _add_skill_for_person($name, $skills)
{
  $person = sfGuardUserPeer::retrieveByUsername($name);
  if (is_null($person))
  {
    throw new Exception(sprintf('Unknown person %s', $name));
  }
  $person->addSkill($skills);
  $person->save();
  pake_echo_action('skills', sprintf('%s for %s', $skills, $person->getDisplayName()));
}

// Add applications tags
pake_echo_comment('Adding applications tags');
_add_tag_for_app('dotmarks', 'bookmarks, community');
_add_tag_for_app('symfonians-website', 'network, marketplace, community, social, symfony, jobs');
_add_tag_for_app('motilee', 'forum, community');
_add_tag_for_app('symfony-project', 'bookmarks, community');
_add_tag_for_app('games-officer', 'videogames, shop, marketplace');
_add_tag_for_app('splitgames', 'videogames, marketplace, exchange');
_add_tag_for_app('mageneration-com', 'senior, community, blogs, galleries, photo');
_add_tag_for_app('yahoo-bookmarks', 'community, bookmarks, social, share, yahoo');
_add_tag_for_app('askeet', 'questions, answers, social');

// Add people skills
_add_skill_for_person('niko', 'php, symfony, xml, html, css, mysql, flex, flash, ruby, rails');
_add_skill_for_person('mbertier', 'php, symfony, xml, html, css, mysql, python, django');
_add_skill_for_person('francois', 'php, symfony, xml, html, css, mysql, soap, wsdl');
_add_skill_for_person('johndoe', 'php, symfony, xml, html, css');
_add_skill_for_person('fabpot', 'php, symfony, xml, html, css, mysql, postgresql, ruby, rails, python, django');

// Remove default sfGuard plugin "admin" user
pake_echo_comment('User accounts operations');
$admin = sfGuardUserPeer::retrieveByUsername('admin');
$admin->delete();
pake_echo_action('users', sprintf('Deleting %s user account', $admin->getUsername()));

// Make NiKo user as an admin
$niko = sfGuardUserPeer::retrieveByUsername('niko');
$niko->addGroupByName('admin');
pake_echo_action('users', sprintf('Promoting %s as an admin account', $niko->getUsername()));