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 CommunityTopic();
$ct->setCommunity(Doctrine::getTable('community')->find($cid));
$ct->setMemberId(self::fetchRandomMemberId($cid));
$ct->setName('name');
$ct->setBody('body');
$ct->save();
$ct->free();
$this->logSection('created a community topic', sprintf("%s", $cid));
}
}
}
protected function executeTransaction($conn, $arguments = array(), $options = array())
{
$communities = Doctrine::getTable('Community')->findAll(Doctrine::HYDRATE_ARRAY);
foreach ($communities as $community) {
for ($i = 0; $i < $options['number']; ++$i) {
$ct = new CommunityTopic();
$ct->setCommunityId($community['id']);
$ct->setMemberId(self::fetchRandomMemberId($community['id']));
$ct->setName('name');
$ct->setBody('body');
$ct->save();
$ct->free();
$this->logSection('created a community topic', sprintf("%s", $community['id']));
}
}
}
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;
}
}
$topic = new CommunityTopic();
$topic->setMember($member);
$topic->setCommunity($this->getParentObject());
$topic->setName((string) $xml->title);
$topic->setBody((string) $xml->content);
$topic->save();
return $topic;
}
public function executePost(sfWebRequest $request)
{
try {
$topicId = $request->getParameter('id');
$communityId = $request->getParameter('community_id');
$this->isValidNameAndBody($request->getParameter('name'), $request->getParameter('body'));
if ($topicId) {
$topic = $this->getTargetObject('topic', $topicId);
} else {
$this->forward400If(!$communityId, 'community_id parameter is not specified.');
$topic = new CommunityTopic();
$topic->setMemberId($this->member->getId());
$topic->setCommunityId($communityId);
}
$this->forward400If(!$this->isAllowed($topic->getCommunity(), $this->member, 'add'), 'you are not allowed to create or update topics on this community');
$topic->setName($request['name']);
$topic->setBody($request['body']);
$topic->save();
} catch (opCommunityTopicAPIRuntimeException $e) {
$this->forward400($e->getMessage());
}
$this->topic = $topic;
}
