OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_41\AddSyncDates

Complexity

Total Complexity

1

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes	2
Bugs	1	Features	1

1 Method

Rating	Name	Duplication	Size	Complexity
B	up()	0	29	1

<?php

namespace OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_41;

use Doctrine\DBAL\Schema\Schema;

use Oro\Bundle\MigrationBundle\Migration\Migration;
use Oro\Bundle\MigrationBundle\Migration\ParametrizedSqlMigrationQuery;
use Oro\Bundle\MigrationBundle\Migration\QueryBag;

class AddSyncDates implements Migration
{
    /**
     * {@inheritdoc}
     */
    public function up(Schema $schema, QueryBag $queries)
    {
        $table = $schema->getTable('orocrm_magento_order');
        $table->addColumn('imported_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);
        $table->addColumn('synced_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);

        $updateDates = 'UPDATE orocrm_magento_order SET imported_at = created_at, synced_at = updated_at';
        $updateDatesQuery = new ParametrizedSqlMigrationQuery();
        $updateDatesQuery->addSql($updateDates);
        $queries->addPostQuery($updateDatesQuery);

        $table = $schema->getTable('orocrm_magento_customer');
        $table->addColumn('imported_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);
        $table->addColumn('synced_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);

        $updateDates = 'UPDATE orocrm_magento_customer SET imported_at = created_at, synced_at = updated_at';
        $updateDatesQuery = new ParametrizedSqlMigrationQuery();
        $updateDatesQuery->addSql($updateDates);
        $queries->addPostQuery($updateDatesQuery);

        $table = $schema->getTable('orocrm_magento_cart');
        $table->addColumn('imported_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);
        $table->addColumn('synced_at', 'datetime', ['notnull' => false, 'comment' => '(DC2Type:datetime)']);

        $updateDates = 'UPDATE orocrm_magento_cart SET imported_at = createdat, synced_at = updatedat';
        $updateDatesQuery = new ParametrizedSqlMigrationQuery();
        $updateDatesQuery->addSql($updateDates);
        $queries->addPostQuery($updateDatesQuery);
    }
}