M230223152730UpdateQimallCrontabTask.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M230223152730UpdateQimallCrontabTask
  6. */
  7. class M230223152730UpdateQimallCrontabTask extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = "UPDATE `qimall_crontab_task` SET `rule` = '0 */10 * * * *' WHERE `command` = 'issue-coupons/issue-coupons/send';";
  16. $sql .= "UPDATE `qimall_crontab_task` SET `rule` = '0 */30 * * * *' WHERE `command` = 'draw/index/exchange';";
  17. $this->execute($sql);
  18. }catch (\Exception $e){
  19. }
  20. }
  21. /**
  22. * {@inheritdoc}
  23. */
  24. public function safeDown()
  25. {
  26. echo "M230223152730UpdateQimallCrontabTask cannot be reverted.\n";
  27. return false;
  28. }
  29. /*
  30. // Use up()/down() to run migration code without a transaction.
  31. public function up()
  32. {
  33. }
  34. public function down()
  35. {
  36. echo "M230223152730UpdateQimallCrontabTask cannot be reverted.\n";
  37. return false;
  38. }
  39. */
  40. }