App\Console\Commands\DBToFile

Complexity

Total Complexity

6

Size/Duplication

Total Lines	94
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	handle()	0	12	2
A	transformData()	0	21	1
A	createAndStore()	0	7	1
A	getDataFromBD()	0	6	1

<?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++)

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.

        {
            $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");

59% of this comment could be valid code. Did you maybe forget this after debugging?

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

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

        return $company_history;
    }
    
    
    
}