app/DoctrineMigrations/Version20201218044542.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. /*
  6. * This file is part of EC-CUBE
  7. *
  8. * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  9. *
  10. * http://www.ec-cube.co.jp/
  11. *
  12. * For the full copyright and license information, please view the LICENSE
  13. * file that was distributed with this source code.
  14. */
  16. namespace DoctrineMigrations;
  18. use Doctrine\DBAL\Schema\Schema;
  19. use Doctrine\Migrations\AbstractMigration;
  21. /**
  22. * Auto-generated Migration: Please modify to your needs!
  23. */
  24. final class Version20201218044542 extends AbstractMigration
  25. {
  26. public function up(Schema $schema): void
  27. {
  28. $pointExists = $this->connection->fetchOne("SELECT COUNT(*) FROM dtb_csv WHERE csv_type_id = 2 AND field_name = 'point'");
  30. if ($pointExists == 0) {
  31. $sortNo = $this->connection->fetchOne('SELECT MAX(sort_no) + 1 FROM dtb_csv WHERE csv_type_id = 2');
  32. $this->addSql("INSERT INTO dtb_csv (
  33. csv_type_id, creator_id, entity_name, field_name, disp_name, sort_no, enabled, create_date, update_date, discriminator_type
  34. ) VALUES (
  35. 2, null, ?, 'point', 'ポイント', $sortNo, false, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'csv'
  36. )",
  37. ['Eccube\\\\Entity\\\\Customer']);
  38. }
  39. }
  41. public function down(Schema $schema): void
  42. {
  43. // this down() migration is auto-generated, please modify it to your needs
  44. }
  45. }