OroCRM\Bundle\MagentoBundle\Migrations\Schema\v1_41\AddSyncDates::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	29
Code Lines	22

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	1

<?php
    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);
    }
}