protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'])->getConnection(); $t = new Twitter(sfConfig::get('twitter_username'), sfConfig::get('twitter_password')); $needs = NeedPeer::retrieveAllNeeds($connection); foreach ($needs as $need) { $message = 'People, @' . $need->getAuthor() . ' needs ' . $need->getDescription() . ' ' . $need->getTimeframe() . ', please help!'; $t->updateStatus($message); } }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'])->getConnection(); $t = new Twitter(sfConfig::get('twitter_username'), sfConfig::get('twitter_password')); $last_message = RawMessagePeer::getLastMessage($connection); $since = null; if ($last_message) { $since = $last_message->getMessageId(); } $messages = $t->getMentionsReplies($since); foreach ($messages as $message) { $rawmessage = RawMessagePeer::saveMessage($message, $connection); if ($rawmessage instanceof RawMessage) { $need = NeedPeer::convertMessage($rawmessage, $con); } else { var_dump($rawmessage); } } }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'])->getConnection(); $t = new Twitter(sfConfig::get('twitter_username'), sfConfig::get('twitter_password')); $last_dm = RawDmPeer::getLastDM($connection); $since = null; if ($last_dm) { $since = $last_dm->getDmId(); } $dms = $t->getDirectMessages($since); foreach ($dms as $dm) { $rawdm = RawDmPeer::saveDirectMessage($dm, $connection); if ($rawdm instanceof RawDm) { $need = NeedPeer::convertDirectMessage($rawdm, $connection); } else { var_dump($rawdm); } } }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = NeedPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setAuthor($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setDescription($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setTimeframe($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setLocation($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setCreatedAt($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setUpdatedAt($arr[$keys[6]]); } }
public function executeUpdate(sfWebRequest $request) { $this->needs = NeedPeer::retrieveLatestNeeds(); }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(NeedPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(NeedPeer::DATABASE_NAME); $criteria->add(NeedPeer::ID, $pks, Criteria::IN); $objs = NeedPeer::doSelect($criteria, $con); } return $objs; }