m160721_073703_insert_default_news.php
3.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php
use yii\db\Migration;
use thread\modules\news\News as ParentModule;
/**
* Class m160721_073703_insert_default_news
*
* @author FilamentV <vortex.filament@gmail.com>
* @copyright (c), Thread
*/
class m160721_073703_insert_default_news extends Migration
{
/**
* @var string
*/
public $tableNewsGroup = '{{%news_group}}';
/**
* @var string
*/
public $tableNewsGroupLang = '{{%news_group_lang}}';
/**
* @var string
*/
public $tableNewsArticle = '{{%news_article}}';
/**
* @var string
*/
public $tableNewsArticleLang = '{{%news_article_lang}}';
/**
*
*/
public function init()
{
$this->db = ParentModule::getDb();
parent::init();
}
/**
*
*/
public function safeUp()
{
/** Insert news_group */
$this->batchInsert(
$this->tableNewsGroup,
[
'id',
'alias',
'created_at',
'updated_at',
'published',
'deleted',
],
[
[
'id' => 1,
'alias' => 'test',
'created_at' => time(),
'updated_at' => time(),
'published' => '1',
'deleted' => '0',
],
]
);
/** Insert news_group_lang */
$this->batchInsert(
$this->tableNewsGroupLang,
[
'rid',
'lang',
'title',
],
[
[
'rid' => 1,
'lang' => 'en-EN',
'title' => 'Test group',
],
]
);
/** Insert news_article */
$this->batchInsert(
$this->tableNewsArticle,
[
'id',
'group_id',
'alias',
'image_link',
'published_time',
'created_at',
'updated_at',
'published',
'deleted',
],
[
[
'id' => 1,
'group_id' => 1,
'alias' => 'news1',
'image_link' => '',
'published_time' => time(),
'created_at' => time(),
'updated_at' => time(),
'published' => '1',
'deleted' => '0',
],
]
);
/** Insert news_article_lang */
$this->batchInsert(
$this->tableNewsArticleLang,
[
'rid',
'lang',
'title',
'description',
'content',
],
[
[
'rid' => 1,
'lang' => 'en-EN',
'title' => 'Тест новость',
'description' => 'Тест новость description',
'content' => 'Тест новость content'
],
]
);
}
public function safeDown()
{
//TODO:: m160721_073703_insert_default_news
}
}