/** * @param WeLearn_DTO_IDTO $dto * @return void */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { $dto->setId($this->_createSegmentoId($dto->getArea()->getId() . '__' . $dto->getDescricao())); $this->_cf->insert($dto->getId(), $dto->toCassandra()); $this->_segmentosEmAreaCF->insert($dto->getArea()->getId(), array($dto->getId() => '')); $dto->setPersistido(true); }
/** * @param WeLearn_DTO_IDTO $dto * @return void */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { $enqueteUUID = CassandraUtil::import($dto->getEnquete()->getId()); $alternativaUUID = CassandraUtil::import($dto->getAlternativa()->getId()); $dto->setDataVoto(time()); $this->_cf->insert($enqueteUUID->bytes, $dto->toCassandra()); $this->_votosPorAlternativaCF->insert($alternativaUUID->bytes, array($dto->getVotante()->getId() => $dto->getDataVoto())); $dto->setPersistido(true); }
/** * @param WeLearn_DTO_IDTO $dto * @return void */ protected function _atualizar(WeLearn_DTO_IDTO $dto) { $UUID = UUID::import($dto->getId())->bytes; $this->_cf->insert($UUID, $dto->toCassandra()); $usuarioId = $dto->getDestinatario()->getId(); $this->_notificacoesNovasPorUsuarioCF->remove($usuarioId, array($UUID)); if ($dto->getStatus() === WeLearn_Notificacoes_StatusNotificacao::NOVO) { $this->_notificacoesNovasPorUsuarioCF->insert($usuarioId, array($UUID => '')); } }
/** * @param WeLearn_DTO_IDTO $dto * @return void */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { if (!$dto->getId()) { $UUID = UUID::mint(); $dto->setId($UUID->string); } else { $UUID = CassandraUtil::import($dto->getId()); } $avaliacaoUUID = CassandraUtil::import($dto->getAvaliacaoId()); $this->_cf->insert($UUID->bytes, $dto->toCassandra()); $this->_questaoPorAvaliacaoCF->insert($avaliacaoUUID->bytes, array($UUID->bytes => '')); $dto->setPersistido(true); }
/** * @param WeLearn_Cursos_Curso $curso * @param array $novasPosicoes */ public function atualizarPosicao(WeLearn_Cursos_Curso $curso, array $novasPosicoes) { $posicoes = array(); $rows = array(); foreach ($novasPosicoes as $posicao => $id) { $UUID = UUID::import($id)->bytes; $posicoes[$posicao] = $UUID; $rows[$UUID] = array('nroOrdem' => $posicao); } $cursoUUID = UUID::import($curso->getId())->bytes; $this->_cf->batch_insert($rows); $this->_moduloPorCursoCF->remove($cursoUUID); $this->_moduloPorCursoCF->insert($cursoUUID, $posicoes); }
/** * Updates a row. * * @param string $key the row to update the columns in * @param mixed $columns array(column_name => column_value) the columns to update * @param int $timestamp the timestamp to use for this insertion. Leaving this as null will * result in a timestamp being generated for you * @param int $ttl time to live for the columns; after ttl seconds they will be deleted * @param cassandra_ConsistencyLevel $writeConsistencyLevel affects the guaranteed * number of nodes that must respond before the operation returns * * @return int the timestamp for the operation */ public function update($key, array $columns, $timestamp = null, $ttl = null, $writeConsistencyLevel = null) { if (empty($this->_columnFamily)) { $this->init(); } return $this->_columnFamily->insert($key, $columns, $timestamp, $ttl, $writeConsistencyLevel); }
/** * @param WeLearn_DTO_IDTO $dto * @return boolean */ protected function _atualizar(WeLearn_DTO_IDTO $dto) { $UUID = CassandraUtil::import($dto->getId()); $cursoUUID = CassandraUtil::import($dto->getCurso()->getId()); $dadosAntigos = $this->_cf->get($UUID->bytes, array('status', 'situacao')); $statusAntigo = (int) $dadosAntigos['status']; $situacaoAntiga = (int) $dadosAntigos['situacao']; $this->_cf->insert($UUID->bytes, $dto->toCassandra()); if ($statusAntigo != $dto->getStatus()) { if ($dto->getStatus() == WeLearn_Cursos_Enquetes_StatusEnquete::ATIVA) { $this->_enquetePorStatusInativoCF->remove($cursoUUID->bytes, array($UUID->bytes)); $this->_enquetePorStatusAtivoCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); } else { $this->_enquetePorStatusAtivoCF->remove($cursoUUID->bytes, array($UUID->bytes)); $this->_enquetePorStatusInativoCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); } } if ($situacaoAntiga != $dto->getSituacao()) { if ($dto->getSituacao() == WeLearn_Cursos_Enquetes_SituacaoEnquete::ABERTA) { $this->_enquetePorSituacaoFechadoCF->remove($cursoUUID->bytes, array($UUID->bytes)); $this->_enquetePorSituacaoAbertoCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); } else { $this->_enquetePorSituacaoAbertoCF->remove($cursoUUID->bytes, array($UUID->bytes)); $this->_enquetePorSituacaoFechadoCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); } } }
/** * @param WeLearn_Cursos_Conteudo_ControleAula $controleAula */ public function salvar(WeLearn_Cursos_Conteudo_ControleAula &$controleAula) { $CFKey = $controleAula->getParticipacaoCurso()->getCFKey(); $this->_cf->insert($CFKey, $controleAula->toCassandra()); if (!$controleAula->isPersistido()) { $controleAula->setPersistido(true); } }
/** * @param WeLearn_DTO_IDTO $dto * @return boolean */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { $dto->setId($dto->getNomeUsuario()); //Id = Nome de usuário $dto->setSenha(md5($dto->getSenha())); //Senha necessita ser encriptada. $dto->setDataCadastro(time()); $this->_cf->insert($dto->getId(), $dto->toCassandra()); //Adiciona o index do email para verificação no cadastro de usuarios $indexEmail = array('usuarioId' => $dto->getId()); $this->_emailUsuarioCF->insert($dto->getEmail(), $indexEmail); //Salva a configuração padrão do usuário recem cadastrado. if ($dto->getConfiguracao()) { $this->salvarConfiguracao($dto->getConfiguracao()); } get_instance()->db->insert($this->_mysql_tbl_name, $dto->toMySQL()); $dto->setPersistido(true); }
/** * @param WeLearn_DTO_IDTO $dto * @return boolean */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { $this->_cf->insert($dto->getId(), $dto->toCassandra()); $this->_controleAvaliacaoPorParticipacaoCF->insert($dto->getParticipacaoCurso()->getId(), array($dto->getAvaliacao()->getModulo()->getNroOrdem() => $dto->getId())); if (count($dto->getRespostas()) > 0) { $this->_respostasAvaliacaoCF->insert($dto->getId(), $dto->respostasToCassandra()); } $dto->setPersistido(true); }
/** * @param WeLearn_DTO_IDTO $dto * @return boolean */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { $UUID = UUID::mint(); $paginaUUID = CassandraUtil::import($dto->getPagina()->getId()); $dto->setId($UUID->string); $dto->setDataEnvio(time()); $this->_cf->insert($UUID->bytes, $dto->toCassandra()); $this->_comentarioPorPaginaCF->insert($paginaUUID->bytes, array($UUID->bytes => '')); $dto->setPersistido(true); }
/** * @param WeLearn_DTO_IDTO $dto * @return void */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { if (!$dto->getId()) { $UUID = UUID::mint(); $dto->setId($UUID->string); } else { $UUID = CassandraUtil::import($dto->getId()); } $dto->setDataInclusao(time()); $this->_cf->insert($UUID->bytes, $dto->toCassandra()); if ($dto instanceof WeLearn_Cursos_Recursos_RecursoRestrito) { $aulaUUID = CassandraUtil::import($dto->getAula()->getId()); $this->_recursosRestritosCF->insert($aulaUUID->bytes, array($UUID->bytes => '')); } elseif ($dto instanceof WeLearn_Cursos_Recursos_RecursoGeral) { $cursoUUID = CassandraUtil::import($dto->getCurso()->getId()); $this->_recursosGeraisCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); } else { throw new WeLearn_Base_Exception('A classe inserida tem que derivar de WeLearn_Cursos_Recursos_Recurso.'); } $dto->setPersistido(true); }
protected function setValue($key, $value, $expire = 0) { $this->cache[$key] = $value; $cf = new ColumnFamily($this->cassandra, $this->config['column_family']); $str = json_encode($value); if ($expire > 0) { try { $seconds = $expire - time(); // __data key set as C* requires a field, note: max TTL can only be 630720000 seconds $cf->insert($key, array('__data' => $str), null, $seconds); } catch (\Exception $e) { return false; } } else { try { // __data key set as C* requires a field $cf->insert($key, array('__data' => $str)); } catch (\Exception $e) { return false; } } return true; }
/** * @param WeLearn_DTO_IDTO $dto * @return boolean */ protected function _adicionar(WeLearn_DTO_IDTO &$dto) { if (!$dto->getId()) { $UUID = UUID::mint(); $dto->setId($UUID->string); } else { $UUID = UUID::import($dto->getId()); } $cursoUUID = UUID::import($dto->getCurso()->getId()); $this->_cf->insert($UUID->bytes, $dto->toCassandra()); $this->_certificadosPorCursoCF->insert($cursoUUID->bytes, array($UUID->bytes => '')); $this->alterarAtivo($dto); $dto->setPersistido(true); }
/** * @param WeLearn_Cursos_Conteudo_Aula $aula * @param array $novasPosicoes */ public function atualizarPosicoes(WeLearn_Cursos_Conteudo_Aula $aula, array $novasPosicoes) { $posicoes = array(); $rows = array(); foreach ($novasPosicoes as $posicao => $id) { $UUID = UUID::import($id)->bytes; $posicoes[$posicao] = $UUID; $rows[$UUID] = array('nroOrdem' => $posicao); } $aulaUUID = UUID::import($aula->getId())->bytes; $this->_cf->batch_insert($rows); $this->_paginaPorAulaCF->remove($aulaUUID); $this->_paginaPorAulaCF->insert($aulaUUID, $posicoes); }
/** * @param string $usuarioId * @param array $listaDeRS * @return void */ private function _salvarListaDeRS($usuarioId, array $listaDeRS) { if (empty($listaDeRS)) { return; } $batchListaRS = array(); $listaRSKeys = array(); foreach ($listaDeRS as $RS) { $rsUIID = UUID::mint(); $RS->setId($rsUIID->string); $batchListaRS[$rsUIID->bytes] = $RS->toCassandra(); $listaRSKeys[$rsUIID->bytes] = ''; $RS->setPersistido(true); } $this->_RSCF->batch_insert($batchListaRS); $this->_RSPorUsuarioCF->insert($usuarioId, $listaRSKeys); }
* http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ /** * PHP Template. * Author: Sheetal Patil. Sun Microsystems, Inc. */ session_start(); require_once "../etc/config.php"; require_once '../etc/phpcassa_config.php'; $friends = Users_Controller::getInstance(); $person = $_REQUEST['person']; $friend = $_REQUEST['friend']; $cf = new ColumnFamily($conn, 'PERSON_PERSON'); $index_exp_person = CassandraUtil::create_index_expression('Person_username', $person); $index_exp_friends = CassandraUtil::create_index_expression('friends_username', $friend); $index_clause = CassandraUtil::create_index_clause(array($index_exp_person, $index_exp_friends)); $rows = $cf->get_indexed_slices($index_clause); foreach ($rows as $key => $col) { $cf->insert($col['id'], array('is_accepted' => 1)); } $_SESSION["friendshipreqs"] = $friends->numFriendshipRequests($person, $conn); $incomingRequests = $friends->incomingRequests($person, $conn); $friendCloud = $friends->getFriendCloud($person, $conn); echo "friendship requests (" . $_SESSION["friendshipreqs"] . ")\n"; echo $friendCloud . "\n" . $incomingRequests;
public function test_get_indexed_slices() { $indexed_cf = new ColumnFamily($this->pool, 'Indexed1'); $indexed_cf->truncate(); $columns = array('birthdate' => 1); foreach (range(1, 3) as $i) { $indexed_cf->insert('key' . $i, $columns); } $expr = CassandraUtil::create_index_expression($column_name = 'birthdate', $value = 1); $clause = CassandraUtil::create_index_clause(array($expr), 10000); $result = $indexed_cf->get_indexed_slices($clause); $count = 0; foreach ($result as $key => $cols) { $count++; self::assertEqual($columns, $cols); self::assertEqual($key, "key{$count}"); } self::assertEqual($count, 3); # Insert and remove a matching row at the beginning $indexed_cf->insert('key0', $columns); $indexed_cf->remove('key0'); # Insert and remove a matching row at the end $indexed_cf->insert('key4', $columns); $indexed_cf->remove('key4'); # Remove a matching row from the middle $indexed_cf->remove('key2'); $result = $indexed_cf->get_indexed_slices($clause); $count = 0; foreach ($result as $key => $cols) { $count++; self::assertTrue($key == "key1" || $key == "key3"); } self::assertEqual($count, 2); $indexed_cf->truncate(); $keys = array(); foreach (range(1, 1000) as $i) { $indexed_cf->insert("key{$i}", $columns); if ($i % 50 != 0) { $indexed_cf->remove("key{$i}"); } else { $keys[] = "key{$i}"; } } $count = 0; foreach ($result as $key => $cols) { $count++; self::assertTrue(in_array($key, $keys)); unset($keys[$key]); } self::assertEqual($count, 20); $indexed_cf->truncate(); }
while ($row = mysql_fetch_array($result)) { $column_family->insert($row['commentid'], array('commentid' => $row['commentid'], 'username' => $row['username'], 'socialeventid' => $row['socialeventid'], 'comments' => $row['comments'], 'ratings' => $row['ratings'], 'created_at' => $row['created_at'], 'updated_at' => $row['updated_at'])); } $query1 = "select * from SOCIALEVENTTAG_SOCIALEVENT"; $result = mysql_query($query1); $count = mysql_num_rows($result); $column_family = new ColumnFamily($conn, 'SOCIALEVENTTAG_SOCIALEVENT'); $i = 1; while ($row = mysql_fetch_array($result)) { $column_family->insert($i, array('id' => $i, 'socialeventtagid' => $row['socialeventtagid'], 'socialeventid' => $row['socialeventid'])); $i = $i + 1; } $query1 = "select * from PERSON_SOCIALEVENT"; $result = mysql_query($query1); $count = mysql_num_rows($result); $column_family = new ColumnFamily($conn, 'PERSON_SOCIALEVENT'); $i = 1; while ($row = mysql_fetch_array($result)) { $column_family->insert($i, array('id' => $i, 'username' => $row['username'], 'socialeventid' => $row['socialeventid'])); $i = $i + 1; } $query1 = "select * from PERSON_PERSON"; $result = mysql_query($query1); $count = mysql_num_rows($result); $column_family = new ColumnFamily($conn, 'PERSON_PERSON'); $i = 1; while ($row = mysql_fetch_array($result)) { $column_family->insert($i, array('id' => $i, 'Person_username' => $row['Person_username'], 'friends_username' => $row['friends_username'], 'is_accepted' => $row['is_accepted'])); $i = $i + 1; } mysql_close($dbcon);
public function test_get_indexed_slices() { $indexed_cf = new ColumnFamily($this->client, 'Indexed1'); $columns = array('birthdate' => 1); foreach (range(1, 3) as $i) { $indexed_cf->insert('key' . $i, $columns); } $expr = CassandraUtil::create_index_expression($column_name = 'birthdate', $value = 1); $clause = CassandraUtil::create_index_clause(array($expr)); $result = $indexed_cf->get_indexed_slices($clause); self::assertEqual(count($result), 3); foreach (range(1, 3) as $i) { self::assertEqual($result['key' . $i], $columns); } $indexed_cf->truncate(); }
$tmp_uname = $column['username']; if (!isset($_SESSION["uname"]) && $tmp_uname == $username) { $unattend = true; // show unattend button if user is already registered. } $attendeeList = $attendeeList . " " . '<a href="users.php?username='******'">' . $tmp_uname . '</a><br />'; } unset($listqueryresult); if (isset($_POST['commentsratingsubmit'])) { $insertSql = new ColumnFamily($conn, 'COMMENTS_RATING'); $commentid = exec("python /usr/pysnowflakeclient/pysnowflakeclient/__init__.py"); $insertSql->insert($commentid, array('commentid' => $commentid, 'username' => $username, 'socialeventid' => $se, 'comments' => $comments, 'ratings' => $rating, 'created_at' => time())); } else { if (isset($_POST['editcommentsratingsubmit']) && isset($_POST['editingcid'])) { $cf = new ColumnFamily($conn, 'COMMENTS_RATING'); $cf->insert($cid, array('comments' => $editcomments, 'ratings' => $rating, 'updated_at' => time())); } } $commentsrating = new ColumnFamily($conn, 'COMMENTS_RATING'); $index_exp = CassandraUtil::create_index_expression('socialeventid', $se); $index_clause = CassandraUtil::create_index_clause(array($index_exp)); $commentsratingResult = $commentsrating->get_indexed_slices($index_clause); ob_start(); foreach ($commentsratingResult as $key => $row1) { $tmp_commentid = $row1['commentid']; $tmp_uname = $row1['username']; $tmp_uname_comments = $row1['comments']; $tmp_uname_rating = $row1['ratings']; $tmp_uname_created_at = trim($events->formatdatetime($dateFormat, $row1['created_at'])); $tmp_uname_updated_at = trim($events->formatdatetime($dateFormat, $row1['updated_at'])); require "../views/commentsRating.php";
/** * @param WeLearn_Usuarios_Usuario $usuario * @param WeLearn_Cursos_Curso $paraCurso */ public function convidar(WeLearn_Usuarios_Usuario $usuario, WeLearn_Cursos_Curso $paraCurso) { $cursoUUID = UUID::import($paraCurso->getId()); $this->_convitesGerenciadorPorCursoCF->insert($cursoUUID->bytes, array($usuario->getId() => '')); $this->_cursoDao->salvarConviteGerenciador($usuario, $paraCurso); }
} } if ($image_name != "") { // 5. Determine the image id. $pos = strpos($image_name, '.'); $img_ext = substr($image_name, $pos, strlen($image_name)); $modified_image_name = "P" . $userid . $img_ext; $resourcedir = '/tmp/'; $imagethumb = "P" . $userid . "T" . $img_ext; $user_image_location = $resourcedir . $modified_image_name; if (!move_uploaded_file($_FILES['user_image']['tmp_name'], $user_image_location)) { throw new Exception("Error moving uploaded file to {$user_image_location}"); } // 6. Generate the thumbnails. $thumb_location = $resourcedir . $imagethumb; ImageUtil::createThumb($user_image_location, $thumb_location, 120, 120); // 7. Store the image. $fs = FileSystem::getInstance(); if (!$fs->create($user_image_location, "NO_OP", "NO_OP")) { error_log("Error copying image " . $user_image_location); } if (!$fs->create($thumb_location, "NO_OP", "NO_OP")) { error_log("Error copying thumb " . $thumb_location); } unlink($user_image_location); unlink($thumb_location); // 8. Update the DB. $cf = new ColumnFamily($conn, 'PERSON'); $cf->insert($userid, array('imageurl' => $modified_image_name, 'imagethumburl' => $imagethumb)); } header("Location:users.php?username=" . $username);
*/ session_start(); require_once "../etc/config.php"; require_once '../etc/phpcassa_config.php'; $friends = Users_Controller::getInstance(); $person = $_REQUEST['person']; $friend = $_REQUEST['friend']; $frnd = $_REQUEST['frnd']; $user = $_REQUEST['query']; $flag = $_REQUEST['flag']; $cf = new ColumnFamily($conn, 'PERSON_PERSON'); $index_exp1 = CassandraUtil::create_index_expression('Person_username', $friend); $index_exp2 = CassandraUtil::create_index_expression('friends_username', $person); if ($flag == "add") { $personid = exec("python /usr/pysnowflakeclient/pysnowflakeclient/__init__.py"); $cf->insert($personid, array('id' => $personid, 'Person_username' => $friend, 'friends_username' => $person, 'is_accepted' => 0)); } else { if ($flag == "delete") { $index_exp3 = CassandraUtil::create_index_expression('is_accepted', 0); $index_clause = CassandraUtil::create_index_clause(array($index_exp1, $index_exp2, $index_exp3)); $result = $cf->get_indexed_slices($index_clause); foreach ($result as $key => $col) { $cf->remove($col["id"]); } } else { if ($flag == "frnd") { $index_exp3 = CassandraUtil::create_index_expression('is_accepted', 1); $index_clause = CassandraUtil::create_index_clause(array($index_exp1, $index_exp2, $index_exp3)); $result = $cf->get_indexed_slices($index_clause); foreach ($result as $key => $col) { $cf->remove($col["id"]);
$_SESSION[$k_passwd] = $passwd; unset($error); $logged_in = true; $sub = new ColumnFamily($conn, CF_SUBSCRIPTIONS); $sub_info = $sub->get($system_info["subscription"]); } } catch (Exception $e) { } } if($logged_in) { if($request == "reboot") { // Ajax callback if($system_info["flag_allow_web_reset"] == 0) { echo "That system cannot be reset from the web"; } else { try { $sys->insert($system, array("control" => "reset")); echo "Reboot is in progress"; } catch (Exception $e) { echo "An error occured"; } } exit; } if($request == "xfer") { ob_start('ob_gzhandler'); require_helper("bandwidth"); $start = strtotime($sub_info["start"]); $monthly_start = $start_of_year = strtotime(date("Y-01-01")); $daily_start = $days_ago = strtotime("30 days ago"); $hourly_start = $hours_ago = strtotime("24 hours ago"); if($start > $monthly_start) {
throw new Exception("Error moving uploaded file to {$upload_literature_location}"); } if (!isset($fs)) { $fs = FileSystem::getInstance(); } if (!$fs->create($upload_literature_location, "NO_OP", "NO_OP")) { error_log("Error copying literature " . $upload_literature_location); } unlink($upload_literature_location); } // 11. Update the image names back to the database. // Note: this update is in it's own transaction, after the images are // properly stored. It is a single statement transaction and with autocommit // on, we do not need to start and commit. if (isset($_POST['addeventsubmit'])) { $updatese = new ColumnFamily($conn, 'SOCIALEVENT'); $updatese->insert($eventid, array('imageurl' => $modified_image_name, 'imagethumburl' => $imagethumb, 'literatureurl' => $modified_literature_name)); } else { if (isset($_POST['addeventsubmitupdate'])) { $updatese = new ColumnFamily($conn, 'SOCIALEVENT'); $updatese->insert($evid, array('imageurl' => $modified_image_name, 'imagethumburl' => $imagethumb, 'literatureurl' => $modified_literature_name)); } } // 12. Redirect the results. if (isset($_POST['addeventsubmit'])) { header("Location:events.php?socialEventID=" . $eventid); } else { if (isset($_POST['addeventsubmitupdate'])) { header("Location:events.php?socialEventID=" . $evid); } }
} else { $data[$column_key_name][$column_name] = $column_value; } } $no_column++; } $no_scf++; } try { if (!empty($key)) { if (count($data) > 0) { if (isset($_POST['mode']) && $_POST['mode'] == 'edit') { $column_family->remove($key); } $time_start = microtime(true); $column_family->insert($key, $data); $time_end = microtime(true); // Insert successful if (isset($_POST['mode']) && $_POST['mode'] == 'insert') { $vw_vars['success_message'] = displaySuccessMessage('insert_row', array('query_time' => getQueryTime($time_start, $time_end))); } else { $vw_vars['success_message'] = displaySuccessMessage('edit_row', array('key' => $key, 'query_time' => getQueryTime($time_start, $time_end))); } } else { $vw_vars['error_message'] = displayErrorMessage('insert_row_incomplete_fields'); } } else { $vw_vars['info_message'] = displayInfoMessage('insert_row_not_empty'); } } catch (Exception $e) { $vw_vars['error_message'] = displayErrormessage('insert_row', array('message' => $e->getMessage()));
public function test_initial_connection_failure() { $servers = array('localhost', 'foobar'); $pool = new ConnectionPool(self::$KS, $servers); $pool->fill(); $stats = $pool->stats(); self::assertEqual($stats['created'], 5); self::assertTrue($stats['failed'] == 5 || $stats['failed'] == 4); $cf = new ColumnFamily($pool, self::$CF); foreach (range(1, 50) as $i) { $cf->insert('key', array('c' => 'v')); } $pool->dispose(); $servers = array('barfoo', 'foobar'); try { $pool = new ConnectionPool(self::$KS, $servers); $pool->fill(); self::assertTrue(false); } catch (NoServerAvailable $ex) { } }
$index_exp_event = CassandraUtil::create_index_expression('socialeventid', $se); $index_exp_uname = CassandraUtil::create_index_expression('username', $username); $index_clause = CassandraUtil::create_index_clause(array($index_exp_event, $index_exp_uname)); $result = $checkuserIfAttending->get_indexed_slices($index_clause); $row['count'] = 0; foreach ($result as $key => $column) { $row['count'] += 1; } $userExists = $row['count']; if ($userExists <= 0) { /* $insertuser = "******"; $connection->exec($insertuser); */ $insertuser = new ColumnFamily($conn, 'PERSON_SOCIALEVENT'); $id = exec("python /usr/pysnowflakeclient/pysnowflakeclient/__init__.py"); $insertuser->insert($id, array('id' => $id, 'username' => $username, 'socialeventid' => $se)); } } if (!isset($connection)) { // If connection not there, we're read-only. $connection = DBConnection::getInstance(); } /* $listquery = "select username from PERSON_SOCIALEVENT ". "where socialeventid = '$se' and username = '******' ". "union select username from PERSON_SOCIALEVENT ". "where socialeventid = '$se' limit 20"; $listqueryresult = $connection->query($listquery); */ $listquery = new ColumnFamily($conn, 'PERSON_SOCIALEVENT'); $index_exp_event = CassandraUtil::create_index_expression('socialeventid', $se);