protected function getListAllTeamDashboard($sqlQuery)
{
$tab = QueryExecutor::execute($sqlQuery);
$ret = array();
for ($i = 0; $i < count($tab); $i++) {
$ret[$i] = $this->readRowAllTeamDashboard($tab[$i]);
}
return $ret;
}
/**
* Get row
*
* @return ChallengeResponsesMySql
*/
protected function getRowResponse($sqlQuery)
{
$tab = QueryExecutor::execute($sqlQuery);
if (count($tab) == 0) {
return null;
}
return $this->readRowResponse($tab[0]);
}
public static function executeInsert($sqlQuery)
{
global $logger;
$result = QueryExecutor::executeUpdate($sqlQuery);
$logger->debug("Execute Update Result: " . print_r($result, true));
$lastInsertedId = mysql_insert_id();
$logger->debug("Execute Insert Result: '{$lastInsertedId}'");
return $lastInsertedId;
}
protected function getListUsers($sqlQuery)
{
$tab = QueryExecutor::execute($sqlQuery);
$ret = array();
for ($i = 0; $i < count($tab); $i++) {
$ret[$i] = $this->readUserRow($tab[$i]);
}
return $ret;
}
protected function getStudentClassScoreList($sqlQuery)
{
$tab = QueryExecutor::execute($sqlQuery);
$ret = array();
for ($i = 0; $i < count($tab); $i++) {
$ret[$i] = $this->readStudentClassScoreRow($tab[$i]);
}
return $ret;
}
public function getLastTemporadaOfSerie($idSerie)
{
$sql = 'SELECT MAX(temporada) temporada FROM vod WHERE id_serie = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->set($idSerie);
$tab = QueryExecutor::execute($sqlQuery);
if (count($tab) == 0) {
return null;
}
return $tab[0]['temporada'];
}
/**
* Insert row to table
*/
protected function executeInsert($sqlQuery)
{
return QueryExecutor::executeInsert($sqlQuery);
}
public static function executeInsert($sqlQuery)
{
QueryExecutor::executeUpdate($sqlQuery);
return mysql_insert_id();
}
function getFields($table)
{
$sql = 'DESC ' . $table;
return QueryExecutor::execute(new SqlQuery($sql));
}
protected function getStudentScoreList($sqlQuery)
{
$tab = QueryExecutor::execute($sqlQuery);
return $tab;
}
private function registerFilters()
{
$command = $this->register('filters');
// set description
$command->setDescription('Returns possible filters for query');
// set arguments
$command->setDefinition(array(new InputOption('filters', null, InputOption::VALUE_REQUIRED, 'Formatted filters: filter1=value1,value2;filter2=value3,value4'), new InputArgument('query', InputArgument::REQUIRED, 'Query')));
// set action
$command->setCode(function (InputInterface $input, OutputInterface $output) {
// get argument id
$query = $input->getArgument('query');
$setting = SettingsStorage::getInstance();
$code = $setting->getById('code');
$key = $setting->getById('key');
if (empty($code)) {
$code = 1;
} else {
$code = (int) $code['value'];
}
if (empty($key)) {
$output->writeln("Allegro web api key not set, use 'config key XXXXXX' to configure");
return;
} else {
$key = $key['value'];
}
$filters = $input->getOption('filters');
$api = new AllegroApi($key, $code);
// returns filters
foreach (QueryExecutor::getFilters($api, $query, $filters) as $filter) {
$output->writeln(sprintf("<info>%-30s</info>\t%-30s\n%s\n", "<info>{$filter['name']} " . ($filter['range'] ? '=[min,max]' : '') . "</info>", $filter['description'], implode(', ', array_map(function ($item) {
return "{$item['value']} - '{$item['name']}'";
}, $filter['values']))));
}
});
}
<?php
/**
* Arquivo de instalação, deve ser deletado após o uso
*
*/
/**
* Include do arquivo de configuração
*/
require 'config.php';
/**
* Criação da tabela e populando o banco
*/
$arquivo = file_get_contents('extras/sql.sql');
$arquivo = explode(';', $arquivo);
foreach ($arquivo as $linha) {
QueryExecutor::executeSimpleQuery($linha);
}
/**
* Retorno
*/
echo 'Parabéns! Instalação efetuada com sucesso!<br /><br /><a href="' . blog_url . '">Ir para página inicial</a>';
public static function executeInsert($sqlQuery)
{
QueryExecutor::executeUpdate($sqlQuery);
return mysqli_insert_id(ConnectionFactory::getConnection());
}
function getFields($table)
{
$sql = 'DESC ' . $table;
$rettab = array();
$r = 0;
$origtab = QueryExecutor::execute(new SqlQuery($sql));
for ($i = 0; $i < count($origtab); $i++) {
$fieldname = $origtab[$i][0];
$row = $origtab[$i];
switch ($fieldname) {
case 'rid':
break;
case 'is_deleted':
break;
case 'create_epoch':
break;
case 'delete_epoch':
break;
default:
$rettab[$r++] = $row;
break;
}
}
return $rettab;
}
