public function insert(SimpleXMLElement $xml)
 {
     $member = Doctrine::getTable('Member')->find($this->getMemberIdByUrl((string) $xml->author->uri));
     if (!$member) {
         return false;
     }
     if ($this->member) {
         $acl = $this->getCollectionAcl($this->getParentObject(), $this->member);
         if (!$acl || !$acl->isAllowed($this->member->id, null, 'add')) {
             return false;
         }
     }
     $gd = $xml->children(opGDataDocument::NAMESPACE);
     if (!$gd) {
         return false;
     }
     $when = $gd->when[0]->attributes();
     $where = $gd->where[0]->attributes();
     $event = new CommunityEvent();
     $event->setMember($member);
     $event->setCommunity($this->getParentObject());
     $event->setName((string) $xml->title);
     $event->setBody((string) $xml->content);
     $event->setOpenDate((string) $when['startTime']);
     $event->setOpenDateComment('');
     $event->setArea((string) $when['valueString']);
     $event->save();
     return $event;
 }
  protected function execute($arguments = array(), $options = array())
  {
    $databaseManager = new sfDatabaseManager($this->configuration);
    $this->conn = $databaseManager->getDatabase('doctrine')->getDoctrineConnection();

    $sql = 'SELECT id FROM community';
    $where = array();
    if ( $options['cmin'] && $options['cmax']  && $options['cmin'] <= $options['cmax'])
    {
        $sql .= ' WHERE id BETWEEN ? AND ?';
        $where = array(intval($options['cmin']),intval($options['cmax']));
    }
    $commuIds = $this->conn->fetchColumn($sql, $where);
    foreach ($commuIds as $cid)
    {
      for ($i=0; $i < $options['number']; ++$i)
      {
        $ct = new CommunityEvent();
        $ct->setCommunityId($cid);
        $ct->setMemberId(self::fetchRandomMemberId($cid));
        $ct->setName('name');
        $ct->setBody('body');
        $ct->save();
        $ct->free();
        $this->logSection('created a community event', sprintf("%s", $cid));
      }
    }
  }