public function load($id) { $result=HypertableConnection::query("SELECT * FROM tweet ". "WHERE ROW='$id'"); if (!$result or !count($result->cells)) return null; $tweet=new Tweet(); $tweet->setId($id); $tweet->setTimestamp($result->cells[0]->key->timestamp); $tweet->setMessage($result->cells[0]->value); return $tweet; }
public function load($id) { $result=HypertableConnection::query("SELECT * FROM profile ". "WHERE ROW='$id'"); if (!$result or !count($result->cells)) return null; $profile=new Profile(); $profile->setId($id); $profile->setDisplayName($result->cells[1]->value); $profile->setPasswordMd5($result->cells[2]->value); $profile->setEmail($result->cells[3]->value); $profile->setAvatar($result->cells[4]->value); $profile->setLocation($result->cells[5]->value); $profile->setWebpage($result->cells[6]->value); $profile->setBio($result->cells[7]->value); return $profile; }
public function getFollowStream($cutoff_time, $limit) { $a=array(); $id=$this->_id; if ($cutoff_time) $t="AND TIMESTAMP < '". HypertableConnection::format_timestamp_ns($cutoff_time)."' "; else $t=''; $result=HypertableConnection::query("SELECT follow_stream FROM user ". "WHERE ROW='$id' $t CELL_LIMIT $limit"); if (!$result or !count($result->cells)) return $a; foreach ($result->cells as $cell) { array_push($a, TweetTable::load($cell->value)); } $this->_cutoff=$result->cells[count($result->cells)-1]->key->timestamp; return $a; }