Advertisement
Guest User

Untitled

a guest
May 27th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.53 KB | None | 0 0
  1. public function actionDb(){
  2.         ini_set("max_execution_time", 0);
  3.         //phpinfo();
  4.         //exit;
  5.  
  6.         echo "Start";
  7.         echo '<br />';
  8.  
  9.         //delete from element where 1;
  10.         //delete from passport_dz where 1;
  11.         //delete from element_action where 1;
  12.  
  13.         $sql = "SET FOREIGN_KEY_CHECKS=0";
  14.         Yii::app()->db->createCommand($sql)->execute();
  15.  
  16.  
  17.  
  18.  
  19.         //$sql = "delete from element_action where 1";
  20.         //Yii::app()->db->createCommand($sql)->query();
  21.  
  22.         //$sql = "delete from element where 1";
  23.         //Yii::app()->db->createCommand($sql)->query();
  24.  
  25.         //$sql = "delete from passport_dz where 1";
  26.         //Yii::app()->db->createCommand($sql)->query();
  27.  
  28.         $sql = "delete from qrcode  where 1";
  29.         Yii::app()->db->createCommand($sql)->query();
  30.  
  31.         $sql = "delete from object_action_photo  where 1";
  32.         Yii::app()->db->createCommand($sql)->query();
  33.         $sql = "delete from object_action where 1";
  34.         Yii::app()->db->createCommand($sql)->query();
  35.  
  36.         $sql = "delete from object where 1";
  37.         Yii::app()->db->createCommand($sql)->query();
  38.  
  39.  
  40.         //phpinfo();
  41.         //$dir = $_SERVER['DOCUMENT_ROOT'];
  42.         //$dir = Yii::getPathOfAlias('webroot');
  43.  
  44.         $dir = Yii::getPathOfAlias('application');
  45.  
  46.         //dd($dir);
  47.  
  48.         //exec("$dir/yiic load et");
  49.         //system("$dir/yiic load et");
  50.  
  51.         system("$dir/yiic load om");
  52.         system("$dir/yiic load oa");
  53.         system("$dir/yiic load f");
  54.  
  55.         system("$dir/yiic load om1");
  56.         system("$dir/yiic load om2");
  57.  
  58.         //$sql = "SET FOREIGN_KEY_CHECKS=1";
  59.         //Yii::app()->db->createCommand($sql)->execute();
  60.  
  61.  
  62.         echo "Stop";
  63.         echo '<br />';
  64.  
  65.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement