public static function reInitData() { static::cleanUp(); $totalCnt = 0; $offset = 0; $stat = array(); while (true) { $res = Location\Name\LocationTable::getList(array('select' => array('NAME', 'LOCATION_ID', 'TID' => 'LOCATION.TYPE_ID'), 'filter' => array('=LOCATION.TYPE.CODE' => array('CITY', 'VILLAGE', 'STREET'), '=LANGUAGE_ID' => 'ru'), 'limit' => self::STEP_SIZE, 'offset' => $offset)); $cnt = 0; while ($item = $res->fetch()) { if (strlen($item['NAME'])) { $words = static::parseQuery($item['NAME']); foreach ($words as $k => &$word) { try { static::add(array('WORD' => $word, 'TYPE_ID' => $item['TID'], 'LOCATION_ID' => $item['LOCATION_ID'])); } catch (\Bitrix\Main\DB\SqlQueryException $e) { // duplicate or smth } } $stat['W_' . count($words)] += 1; //_print_r($words); } $cnt++; $totalCnt++; } if (!$cnt) { break; } $offset += self::STEP_SIZE; } _print_r('Total: ' . $totalCnt); _print_r($stat); }
foreach ($data as $key => $val) { $cur_symbol = $val['Symbol']; array_push($symbols_array[$cur_symbol], $val); } _print_r($symbols_array, false); //------------------------------------- //------------------------------------- // find the open, heigh, low, & closing of the day $data_day = array(); foreach ($symbols_array as $key => $val) { $heigh_array = array(); $low_array = array(); foreach ($val as $kk => $vv) { $heigh_array[] = $vv['Heigh']; $low_array[] = $vv['Low']; } // _print_r($heigh_array,false); // _print_r($low_array,false); $date = explode(' ', $val[0]['Datetime']); $data_day[] = array('Symbol' => $val[0]['Symbol'], 'Open' => $val[0]['Open'], 'Heigh' => max($heigh_array), 'Low' => min($low_array), 'Closing' => $val[count($val) - 1]['Closing'], 'Datetime' => $val[0]['Datetime'], 'Range_start' => $date[0] . ' ' . $config['range_start'], 'Range_end' => $date[0] . ' ' . $config['range_end']); } _print_r($data_day, false); //---------------------------------- //--------------------------------------------------- // insert into day table $db->insert_day($config['db']['day_table'], $data_day); //--------------------------------------------------- //--------------------------------------------------- // delete data from the day table according to the settings $db->del($config['db']['day_table'], $config['day_table_range']); //---------------------------------------------------
$cur_symbol = $val['Symbol']; array_push($symbols_array[$cur_symbol], $val); } // _print_r($symbols_array,false); //------------------------------------- //------------------------------------- // find the open, heigh, low, & closing of the range $data_range = array(); foreach ($symbols_array as $key => $val) { $heigh_array = array(); $low_array = array(); foreach ($val as $kk => $vv) { $heigh_array[] = $vv['Heigh']; $low_array[] = $vv['Low']; } // _print_r($heigh_array,false); // _print_r($low_array,false); $date = explode(' ', $val[0]['Datetime']); $data_range[] = array('Symbol' => $val[0]['Symbol'], 'Open' => $val[0]['Open'], 'Heigh' => max($heigh_array), 'Low' => min($low_array), 'Closing' => $val[count($val) - 1]['Closing'], 'Datetime' => $val[0]['Datetime'], 'Range_start' => $date[0] . ' ' . $config['range_start'], 'Range_end' => $date[0] . ' ' . $config['range_end']); } _print_r($data_range, false); // die; //---------------------------------- //--------------------------------------------------- // insert into day table $db->insert_range($config['db']['range_table'], $data_range); //--------------------------------------------------- //--------------------------------------------------- // delete data from the range table according to the settings $db->del($config['db']['range_table'], $config['range_table_range']); //---------------------------------------------------
public function aws_log($id) { $aws_logs = $this->ranking_data_model->get_('aws_logs', array('id' => $id)); $aws_log = reset($aws_logs); if (!empty($aws_log->params)) { $aws_log->params = json_decode($aws_log->params); } if (!empty($aws_log->result)) { $aws_log->result = json_decode($aws_log->result); if (!empty($aws_log->result->Messages)) { foreach ($aws_log->result->Messages as &$message) { if (!empty($message->Body)) { if ($body_decoded = base64_decode($message->Body)) { $message->Body = $body_decoded; } } } } } _print_r($aws_log); }
<?php require_once 'Database.php'; function _print_r($var) { echo '<pre>'; print_r($var); echo '</pre>'; } //$users = Database::getInstance()->select('users' , array('users=>''username' , 'password'), array('username' , '=' , 'alex'))->_print_r(); //$users = Database::getInstance()->insert('users' , array( 'username' => 'ishan', // 'password' => 'password')); //$users = Database::getInstance()->select('users')->_print_r(); $users = Database::getInstance()->select_multiple(array('users', 'info'), array('*'), array('users' => 'id', '=', 'info' => 'userid')); //$users = Database::getInstance()->select('users' , array('*') , array('username' , '=' , 'ishan') ); //$name = $users->username; _print_r($users->results()); //how to use //use query //query('select * from ? where ? = ?' , array('foo' , 'foo1' , 'bar1')); // insert into foo ('foo1' , 'foo2') values('bar1' , 'bar2') //insert('users' , array('foo1' => 'bar1' , 'foo2' => 'bar2')); // delete from foo where foo1 = bar1 //delete('foo' , array('foo1' , '=' , 'bar1')) //update foo set foo1 = bar1 where foo2 = bar2 //update('foo' , array('foo1' => 'bar1') , array('foo2' ,'=' , 'bar2'))