DBToFile::createAndStore() - Code Metrics - Inspection of "Comanda per passar la taula exchange_history de la..." - alexbonavila/LaravelMarketInformation - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 942037...e7ceff )

by Alex

created 2016-05-24 16:27 UTC

DBToFile::createAndStore() A

↳ Parent: DBToFile

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	7
rs	9.4285
cc	1
eloc	4
nc	1
nop	3

<?php

namespace App\Console\Commands;

use DB;
use Illuminate\Console\Command;
use SoapBox\Formatter\Formatter;

/**
 * Class DBToFile
 * @package App\Console\Commands
 */
class DBToFile extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'file_creator:create';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Create files from DB and transform him';

    /**
     * Create a new command instance.
     *
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $exchange_history = $this->getDataFromBD();

        for($i=0; $i<count($exchange_history); $i++)
for ($i=0; $i<count($array); $i++) { // calls count() on each iteration
}

// Better
for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once
}
        {
            $company_history = $exchange_history[$i];

            $this->transformData($company_history);
        }

    }

    /**
     * @param $company_history
     */
    public function transformData($company_history)
    {
        $name_file = $company_history->symbol;

        $this->createAndStore($company_history, "json", $name_file);

        $company_history=json_encode($company_history);

        $formatter = Formatter::make($company_history, Formatter::JSON);

        $csv   = $formatter->toCsv();
        $xml   = $formatter->toXml();
        $yaml  = $formatter->toYaml();

        $this->createAndStore($csv, "csv", $name_file);

        $this->createAndStore($xml, "xml", $name_file);

        $this->createAndStore($yaml, "yaml", $name_file);

    }

    /**
     * @param $to_store
     * @param $extension_file
     * @param $name_file
     */
    public function createAndStore($to_store, $extension_file, $name_file)
    {
        $myfile = fopen("public/historic_info_files/".$extension_file."/".$name_file.".".$extension_file, "w");
        //$myfile = fopen("public/historic_info_files/testfile.txt", "w");

        fwrite($myfile, json_encode($to_store));
        fclose($myfile);
    }

    /**
     * @return array|static[]
     */
    public function getDataFromBD()
    {
        $company_history = DB::table('exchange_history')->get();

        return $company_history;
    }
    
    
    
}


1			<?php
2
3			namespace App\Console\Commands;
4
5			use DB;
6			use Illuminate\Console\Command;
7			use SoapBox\Formatter\Formatter;
8
9			/**
10			* Class DBToFile
11			* @package App\Console\Commands
12			*/
13			class DBToFile extends Command
14			{
15			/**
16			* The name and signature of the console command.
17			*
18			* @var string
19			*/
20			protected $signature = 'file_creator:create';
21
22			/**
23			* The console command description.
24			*
25			* @var string
26			*/
27			protected $description = 'Create files from DB and transform him';
28
29			/**
30			* Create a new command instance.
31			*
32			*/
33			public function __construct()
34			{
35			parent::__construct();
36			}
37
38			/**
39			* Execute the console command.
40			*
41			* @return mixed
42			*/
43			public function handle()
44			{
45			$exchange_history = $this->getDataFromBD();
46
47			for($i=0; $i<count($exchange_history); $i++)
			0 ignored issues – show Performance Best Practice introduced 2016-05-24 16:36 UTC by Report Bug Copy Issue Report It seems like you are calling the size function `count()` as part of the test condition. You might want to compute the size beforehand, and not on each iteration. 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: for ($i=0; $i<count($array); $i++) { // calls count() on each iteration } // Better for ($i=0, $c=count($array); $i<$c; $i++) { // calls count() just once } Loading history...
48			{
49			$company_history = $exchange_history[$i];
50
51			$this->transformData($company_history);
52			}
53
54			}
55
56			/**
57			* @param $company_history
58			*/
59			public function transformData($company_history)
60			{
61			$name_file = $company_history->symbol;
62
63			$this->createAndStore($company_history, "json", $name_file);
64
65			$company_history=json_encode($company_history);
66
67			$formatter = Formatter::make($company_history, Formatter::JSON);
68
69			$csv = $formatter->toCsv();
70			$xml = $formatter->toXml();
71			$yaml = $formatter->toYaml();
72
73			$this->createAndStore($csv, "csv", $name_file);
74
75			$this->createAndStore($xml, "xml", $name_file);
76
77			$this->createAndStore($yaml, "yaml", $name_file);
78
79			}
80
81			/**
82			* @param $to_store
83			* @param $extension_file
84			* @param $name_file
85			*/
86			public function createAndStore($to_store, $extension_file, $name_file)
87			{
88			$myfile = fopen("public/historic_info_files/".$extension_file."/".$name_file.".".$extension_file, "w");
89			//$myfile = fopen("public/historic_info_files/testfile.txt", "w");
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-24 16:36 UTC by Report Bug Copy Issue Report `59%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
90			fwrite($myfile, json_encode($to_store));
91			fclose($myfile);
92			}
93
94			/**
95			* @return array\|static[]
96			*/
97			public function getDataFromBD()
98			{
99			$company_history = DB::table('exchange_history')->get();
100
101			return $company_history;
102			}
103
104
105
106			}
107

alexbonavila / LaravelMarketInformation

Push — master ( 942037...e7ceff )

DBToFile::createAndStore() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like