Conditions | 3 |
Paths | 6 |
Total Lines | 26 |
Code Lines | 15 |
Lines | 0 |
Ratio | 0 % |
Changes | 3 | ||
Bugs | 0 | Features | 0 |
1 | <?php |
||
71 | public function handle() |
||
72 | { |
||
73 | $table='companies'; |
||
74 | |||
75 | DB::table($table)->truncate(); |
||
76 | |||
77 | $symbols_nasdq= '{"SymbolsNASDAQ":["AAL","AAPL","ADBE","ADI","ADP","ADSK","AKAM","ALXN","AMAT","AMGN","AMZN","ATVI","BBBY","BIDU","BIIB","BMRN","CA","CELG","CERN","CHKP","CHTR","CMCSA","COST","CSCO","CSX","CTRP","CTSH","CTXS","DISCA","DISCK","DISH","DLTR","EA","EBAY","ENDP","ESRX","EXPE","FAST","FB","FISV","FOX","FOXA","GILD","GOOG","HSIC","INCY","INTC","INTU","ILMN","ISRG","JD","KHC","LBTYA","LBTYK","LLTC","LMCA","LRCX","LVNTA","MAR","MAT","MDLZ","MNST","MSFT","MU","MXIM","MYL","NCLH","NFLX","NTAP","NVDA","NXPI","ORLY","PAYX","PCAR","PCLN","PYPL","QCOM","QVCA","REGN","ROST","SBAC","SBUX","SIRI","SNDK","SRCL","STX","SWKS","SYMC","TMUS","TSCO","TSLA","TRIP","TXN","ULTA","VIAB","VOD","VRSK","VRTX","WBA","WDC","WFM","XLNX","YHOO"]}'; |
||
78 | |||
79 | $symbols_nasdq = json_decode($symbols_nasdq); |
||
80 | |||
81 | $symbols = $symbols_nasdq->SymbolsNASDAQ; |
||
82 | |||
83 | for($i=0; $i<count($symbols); $i++){ |
||
|
|||
84 | try{ |
||
85 | $symbol=$symbols[$i]; |
||
86 | $data=$this->http_calls->getCompanies($symbol); |
||
87 | $this->db_functions->storeCompanies($data); |
||
88 | $this->progress_control->progressControl($i); |
||
89 | |||
90 | }catch(Exception $e){ |
||
91 | |||
92 | } |
||
93 | } |
||
94 | Cache::tags('companies')->flush(); |
||
95 | echo("100% Table companies fed\n"); |
||
96 | } |
||
97 | } |
If the size of the collection does not change during the iteration, it is generally a good practice to compute it beforehand, and not on each iteration: