質問編集履歴
2
全体的に修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -22,557 +22,17 @@
|
|
22
22
|
|
23
23
|
```php
|
24
24
|
|
25
|
-
ech
|
25
|
+
$users_lock = $dbh[0]->prepare("SELECT * FROM ".$users_table."WHERE ID = ? LOCK IN SHARE MODE");
|
26
26
|
|
27
|
-
$ins
|
27
|
+
$site_configs_lock = $dbh[0]->prepare("SELECT * FROM ".$site_configs_table." WHERE ID = ? LOCK IN SHARE MODE");
|
28
28
|
|
29
|
-
(
|
29
|
+
$synonyms_lock = $dbh[2]->prepare("SELECT * FROM ".$synonyms_table." WHERE ID = ? LOCK IN SHARE MODE");
|
30
30
|
|
31
|
-
|
31
|
+
$suggest_words_lock = $dbh[2]->prepare("SELECT * FROM ".$suggest_words_table." WHERE ID = ? LOCK IN SHARE MODE");
|
32
32
|
|
33
|
-
|
33
|
+
$categories_lock = $dbh[2]->prepare("SELECT * FROM ".$categories_table." WHERE ID = ? LOCK IN SHARE MODE");
|
34
34
|
|
35
|
-
passwd,
|
36
|
-
|
37
|
-
authority,
|
38
|
-
|
39
|
-
created,
|
40
|
-
|
41
|
-
modified
|
42
|
-
|
43
|
-
)
|
44
|
-
|
45
|
-
VALUES
|
46
|
-
|
47
|
-
(
|
48
|
-
|
49
|
-
'ASシステム管理',
|
50
|
-
|
51
|
-
'as_system',
|
52
|
-
|
53
|
-
'cd6736d1ad6f1d61a85f29be8684343a040fecb3',
|
54
|
-
|
55
|
-
99,
|
56
|
-
|
57
|
-
cast(now() as datetime),
|
58
|
-
|
59
|
-
cast(now() as datetime)
|
60
|
-
|
61
|
-
),
|
62
|
-
|
63
|
-
(
|
64
|
-
|
65
|
-
'BTMシステム管理',
|
66
|
-
|
67
|
-
'btm_system',
|
68
|
-
|
69
|
-
'cd6736d1ad6f1d61a85f29be8684343a040fecb3',
|
70
|
-
|
71
|
-
99,
|
72
|
-
|
73
|
-
cast(now() as datetime),
|
74
|
-
|
75
|
-
cast(now() as datetime)
|
76
|
-
|
77
|
-
),
|
78
|
-
|
79
|
-
(
|
80
|
-
|
81
|
-
'DSシステム管理',
|
82
|
-
|
83
|
-
'ds_system',
|
84
|
-
|
85
|
-
'cd6736d1ad6f1d61a85f29be8684343a040fecb3',
|
86
|
-
|
87
|
-
99,
|
88
|
-
|
89
|
-
cast(now() as datetime),
|
90
|
-
|
91
|
-
cast(now() as datetime)
|
92
|
-
|
93
|
-
)";
|
94
|
-
|
95
|
-
echo $insert_users.'<br>';
|
96
|
-
|
97
|
-
|
98
|
-
|
99
|
-
// // usersアップデート
|
100
|
-
|
101
|
-
// echo "usersアップデート準備";
|
102
|
-
|
103
|
-
// $update_users = "UPDATE ".$users_table."
|
104
|
-
|
105
|
-
// SET
|
106
|
-
|
107
|
-
|
108
|
-
|
109
|
-
|
110
|
-
|
111
|
-
|
112
|
-
|
113
|
-
|
114
|
-
|
115
|
-
// echo $update_users.'<br>';
|
116
|
-
|
117
|
-
|
118
|
-
|
119
|
-
// レコード数カウント
|
120
|
-
|
121
|
-
$sql_users = "SELECT * FROM ".$users_table;
|
122
|
-
|
123
|
-
$res_users = $dbh[0]->query($sql_users);
|
124
|
-
|
125
|
-
$row_users = $res_users->rowCount();
|
126
|
-
|
127
|
-
|
128
|
-
|
129
|
-
// 実行
|
130
|
-
|
131
|
-
if ($row_users === 0) {
|
132
|
-
|
133
|
-
$insert_users_check = $dbh[0]->query($insert_users);
|
134
|
-
|
135
|
-
if (!$insert_users_check) {
|
136
|
-
|
137
|
-
throw new Exception('user:インサート失敗');
|
138
|
-
|
139
|
-
}
|
140
|
-
|
141
|
-
}
|
142
|
-
|
143
|
-
else {
|
144
|
-
|
145
|
-
// $update_start_users = $dbh[0]->prepare($update_users);
|
146
|
-
|
147
|
-
// if (!$update_start_users) {
|
148
|
-
|
149
|
-
// throw new Exception('users:アップデート準備失敗');
|
150
|
-
|
151
|
-
// }
|
152
|
-
|
153
|
-
}
|
154
|
-
|
155
|
-
|
156
|
-
|
157
|
-
echo"site_configsインサート開始";
|
158
|
-
|
159
|
-
$insert_site_configs = "INSERT INTO ".$site_configs_table."
|
160
|
-
|
161
|
-
(
|
162
|
-
|
163
|
-
site_url,
|
164
|
-
|
165
|
-
site_name,
|
166
|
-
|
167
|
-
wrt_user_id,
|
168
|
-
|
169
|
-
created,
|
170
|
-
|
171
|
-
modified
|
172
|
-
|
173
|
-
)
|
174
|
-
|
175
|
-
VALUES
|
176
|
-
|
177
|
-
(
|
178
|
-
|
179
|
-
'CCI',
|
180
|
-
|
181
|
-
'CCIホーム',
|
182
|
-
|
183
|
-
99,
|
184
|
-
|
185
|
-
cast(now() as datetime),
|
186
|
-
|
187
|
-
cast(now() as datetime)
|
188
|
-
|
189
|
-
)";
|
190
|
-
|
191
|
-
echo $insert_site_configs.'<br>';
|
192
|
-
|
193
|
-
|
194
|
-
|
195
|
-
echo "site_configsアップデート準備";
|
196
|
-
|
197
|
-
$update_site_configs = "UPDATE ".$site_configs_table."
|
198
|
-
|
199
|
-
SET
|
200
|
-
|
201
|
-
site_url = 'CCI',
|
202
|
-
|
203
|
-
site_name = 'CCIホーム',
|
204
|
-
|
205
|
-
wrt_user_id = 99,
|
206
|
-
|
207
|
-
created = cast(now() as datetime),
|
208
|
-
|
209
|
-
modified = cast(now() as datetime)
|
210
|
-
|
211
|
-
WHERE id = 1";
|
212
|
-
|
213
|
-
|
214
|
-
|
215
|
-
// レコード数カウント
|
216
|
-
|
217
|
-
$sql_site_configs = "SELECT * FROM ".$site_configs_table;
|
218
|
-
|
219
|
-
$res_site_configs = $dbh[0]->query($sql_site_configs);
|
220
|
-
|
221
|
-
$row_site_configs = $res_site_configs->rowCount();
|
222
|
-
|
223
|
-
|
224
|
-
|
225
|
-
// 実行
|
226
|
-
|
227
|
-
if ($row_site_configs === 0) {
|
228
|
-
|
229
|
-
$insert_site_configs_check = $dbh[0]->query($insert_site_configs);
|
230
|
-
|
231
|
-
if (!$insert_site_configs_check) {
|
232
|
-
|
233
|
-
throw new Exception('site_configs:インサート失敗');
|
234
|
-
|
235
|
-
}
|
236
|
-
|
237
|
-
}
|
238
|
-
|
239
|
-
else {
|
240
|
-
|
241
|
-
$update_start_site_configs = $dbh[0]->prepare($update_site_configs);
|
242
|
-
|
243
|
-
if (!$update_start_site_configs) {
|
244
|
-
|
245
|
-
throw new Exception('site_configs:アップデート準備失敗');
|
246
|
-
|
247
|
-
}
|
248
|
-
|
249
|
-
}
|
250
|
-
|
251
|
-
|
252
|
-
|
253
|
-
|
254
|
-
|
255
|
-
echo "synonymsインサート準備";
|
256
|
-
|
257
|
-
$insert_synonyms = "INSERT INTO ".$synonyms_table."
|
258
|
-
|
259
|
-
(
|
260
|
-
|
261
|
-
synonym1,
|
262
|
-
|
263
|
-
synonym2,
|
264
|
-
|
265
|
-
synonym3,
|
266
|
-
|
267
|
-
synonym4,
|
268
|
-
|
269
|
-
synonym5
|
270
|
-
|
271
|
-
)
|
272
|
-
|
273
|
-
VALUES
|
274
|
-
|
275
|
-
(
|
276
|
-
|
277
|
-
:synonym1,
|
278
|
-
|
279
|
-
:synonym2,
|
280
|
-
|
281
|
-
:synonym3,
|
282
|
-
|
283
|
-
:synonym4,
|
284
|
-
|
285
|
-
:synonym5
|
286
|
-
|
287
|
-
)";
|
288
|
-
|
289
|
-
echo $insert_synonyms.'<br>';
|
290
|
-
|
291
|
-
$insert_start_synonyms = $dbh[2]->prepare($insert_synonyms);
|
292
|
-
|
293
|
-
if (!$insert_start_synonyms) {
|
294
|
-
|
295
|
-
throw new Exception('synonyms:インサート準備失敗');
|
296
|
-
|
297
|
-
}
|
298
|
-
|
299
|
-
|
300
|
-
|
301
|
-
echo "synonymsアップデート準備";
|
302
|
-
|
303
|
-
$update_synonyms = "UPDATE ".$synonyms_table."
|
304
|
-
|
305
|
-
SET
|
306
|
-
|
307
|
-
synonym1 = :synonym1,
|
308
|
-
|
309
|
-
synonym2 = :synonym2,
|
310
|
-
|
311
|
-
synonym3 = :synonym3,
|
312
|
-
|
313
|
-
synonym4 = :synonym4,
|
314
|
-
|
315
|
-
synonym5 = :synonym5
|
316
|
-
|
317
|
-
WHERE id = :id";
|
318
|
-
|
319
|
-
echo $update_synonyms.'<br>';
|
320
|
-
|
321
|
-
$update_start_synonyms = $dbh[2]->prepare($update_synonyms);
|
322
|
-
|
323
|
-
if (!$update_start_synonyms) {
|
324
|
-
|
325
|
-
throw new Exception('synonyms:アップデート準備失敗');
|
326
|
-
|
327
|
-
}
|
328
|
-
|
329
|
-
|
330
|
-
|
331
|
-
echo "suggest_wordsインサート準備";
|
332
|
-
|
333
|
-
$insert_suggest_words = "INSERT INTO ".$suggest_words_table."
|
334
|
-
|
335
|
-
(
|
336
|
-
|
337
|
-
suggest1,
|
338
|
-
|
339
|
-
suggest2,
|
340
|
-
|
341
|
-
suggest3,
|
342
|
-
|
343
|
-
kana1,
|
344
|
-
|
345
|
-
kana2,
|
346
|
-
|
347
|
-
kana3
|
348
|
-
|
349
|
-
)
|
350
|
-
|
351
|
-
VALUES
|
352
|
-
|
353
|
-
(
|
354
|
-
|
355
|
-
:suggest1,
|
356
|
-
|
357
|
-
:suggest2,
|
358
|
-
|
359
|
-
:suggest3,
|
360
|
-
|
361
|
-
:kana1,
|
362
|
-
|
363
|
-
:kana2,
|
364
|
-
|
365
|
-
:kana3
|
366
|
-
|
367
|
-
)";
|
368
|
-
|
369
|
-
echo $insert_suggest_words.'<br>';
|
370
|
-
|
371
|
-
$insert_start_suggest_words = $dbh[2]->prepare($insert_suggest_words);
|
372
|
-
|
373
|
-
if (!$insert_start_suggest_words) {
|
374
|
-
|
375
|
-
throw new Exception('suggest_words:インサート準備失敗');
|
376
|
-
|
377
|
-
}
|
378
|
-
|
379
|
-
|
380
|
-
|
381
|
-
echo "suggest_wordsアップデート準備";
|
382
|
-
|
383
|
-
$update_suggest_words = "UPDATE ".$suggest_words_table."
|
384
|
-
|
385
|
-
SET
|
386
|
-
|
387
|
-
suggest1 = :suggest1,
|
388
|
-
|
389
|
-
suggest2 = :suggest2,
|
390
|
-
|
391
|
-
suggest3 = :suggest3,
|
392
|
-
|
393
|
-
kana1 = :kana1,
|
394
|
-
|
395
|
-
kana2 = :kana2,
|
396
|
-
|
397
|
-
kana3 = :kana3
|
398
|
-
|
399
|
-
WHERE id = :id";
|
400
|
-
|
401
|
-
echo $update_suggest_words.'<br>';
|
402
|
-
|
403
|
-
$update_start_suggest_words = $dbh[2]->prepare($update_suggest_words);
|
404
|
-
|
405
|
-
if (!$update_start_suggest_words) {
|
406
|
-
|
407
|
-
throw new Exception('suggest_words:アップデート準備失敗');
|
408
|
-
|
409
|
-
}
|
410
|
-
|
411
|
-
|
412
|
-
|
413
|
-
echo "categoriesインサート準備";
|
414
|
-
|
415
|
-
$insert_categories = "INSERT INTO ".$categories_table."
|
416
|
-
|
417
|
-
(
|
418
|
-
|
419
|
-
site_id,
|
420
|
-
|
421
|
-
name,
|
422
|
-
|
423
|
-
pass,
|
424
|
-
|
425
|
-
sort,
|
426
|
-
|
427
|
-
level,
|
428
|
-
|
429
|
-
color,
|
430
|
-
|
431
|
-
user_id,
|
432
|
-
|
433
|
-
created
|
434
|
-
|
435
|
-
)
|
436
|
-
|
437
|
-
VALUES
|
438
|
-
|
439
|
-
(
|
440
|
-
|
441
|
-
:site_id,
|
442
|
-
|
443
|
-
:name,
|
444
|
-
|
445
|
-
:pass,
|
446
|
-
|
447
|
-
:sort,
|
448
|
-
|
449
|
-
:level,
|
450
|
-
|
451
|
-
:color,
|
452
|
-
|
453
|
-
:user_id,
|
454
|
-
|
455
|
-
cast(now() as datetime)
|
456
|
-
|
457
|
-
)";
|
458
|
-
|
459
|
-
echo $insert_categories.'<br>';
|
460
|
-
|
461
|
-
$insert_start_categories = $dbh[2]->prepare($insert_categories);
|
462
|
-
|
463
|
-
if (!$insert_start_categories) {
|
464
|
-
|
465
|
-
throw new Exception('categories:インサート準備失敗');
|
466
|
-
|
467
|
-
}
|
468
|
-
|
469
|
-
|
470
|
-
|
471
|
-
echo "categoriesアップデート準備";
|
472
|
-
|
473
|
-
$update_categories = "UPDATE ".$categories_table."
|
474
|
-
|
475
|
-
SET
|
476
|
-
|
477
|
-
site_id = :site_id,
|
478
|
-
|
479
|
-
name = :name,
|
480
|
-
|
481
|
-
pass = :pass,
|
482
|
-
|
483
|
-
sort = :sort,
|
484
|
-
|
485
|
-
level = :level,
|
486
|
-
|
487
|
-
color = :color,
|
488
|
-
|
489
|
-
user_id = :user_id,
|
490
|
-
|
491
|
-
created = cast(now() as datetime)
|
492
|
-
|
493
|
-
WHERE id = :id";
|
494
|
-
|
495
|
-
echo $update_categories.'<br>';
|
496
|
-
|
497
|
-
$update_start_categories = $dbh[2]->prepare($update_categories);
|
498
|
-
|
499
|
-
if (!$update_start_categories) {
|
500
|
-
|
501
|
-
throw new Exception('categories:アップデート準備失敗');
|
502
|
-
|
503
|
-
}
|
504
|
-
|
505
|
-
|
506
|
-
|
507
|
-
echo "categories_linksインサート準備";
|
508
|
-
|
509
|
-
$
|
35
|
+
$categories_links_lock = $dbh[2]->prepare("SELECT * FROM ".$categories_links_table." WHERE ID = ? LOCK IN SHARE MODE");
|
510
|
-
|
511
|
-
(
|
512
|
-
|
513
|
-
categories_id,
|
514
|
-
|
515
|
-
name,
|
516
|
-
|
517
|
-
url,
|
518
|
-
|
519
|
-
created
|
520
|
-
|
521
|
-
)
|
522
|
-
|
523
|
-
VALUES
|
524
|
-
|
525
|
-
(
|
526
|
-
|
527
|
-
:categories_id,
|
528
|
-
|
529
|
-
:name,
|
530
|
-
|
531
|
-
:url,
|
532
|
-
|
533
|
-
cast(now() as datetime)
|
534
|
-
|
535
|
-
)";
|
536
|
-
|
537
|
-
echo $insert_categories_links.'<br>';
|
538
|
-
|
539
|
-
$insert_start_categories_links = $dbh[2]->prepare($insert_categories_links);
|
540
|
-
|
541
|
-
if (!$insert_start_categories_links) {
|
542
|
-
|
543
|
-
throw new Exception('categories_links:インサート準備失敗');
|
544
|
-
|
545
|
-
}
|
546
|
-
|
547
|
-
|
548
|
-
|
549
|
-
echo "categories_linksアップデート準備";
|
550
|
-
|
551
|
-
$update_categories_links = "UPDATE ".$categories_links_table."
|
552
|
-
|
553
|
-
SET
|
554
|
-
|
555
|
-
categories_id = :categories_id,
|
556
|
-
|
557
|
-
name = :name,
|
558
|
-
|
559
|
-
url = :url,
|
560
|
-
|
561
|
-
created = cast(now() as datetime)
|
562
|
-
|
563
|
-
WHERE id = :id";
|
564
|
-
|
565
|
-
echo $update_categories_links.'<br>';
|
566
|
-
|
567
|
-
$update_start_categories_links = $dbh[2]->prepare($update_categories_links);
|
568
|
-
|
569
|
-
if (!$update_start_categories_links) {
|
570
|
-
|
571
|
-
throw new Exception('categories_links:アップデート準備失敗');
|
572
|
-
|
573
|
-
}
|
574
|
-
|
575
|
-
|
576
36
|
|
577
37
|
.
|
578
38
|
|
1
コード編集
test
CHANGED
File without changes
|
test
CHANGED
@@ -22,130 +22,6 @@
|
|
22
22
|
|
23
23
|
```php
|
24
24
|
|
25
|
-
<?php
|
26
|
-
|
27
|
-
// DB情報
|
28
|
-
|
29
|
-
$dbh_admin = null;
|
30
|
-
|
31
|
-
$dbh_common = null;
|
32
|
-
|
33
|
-
$dbh_front = null;
|
34
|
-
|
35
|
-
$db_admin = "sbiccicms_admin_local_auto";
|
36
|
-
|
37
|
-
$db_common = "sbiccicms_common_local_auto";
|
38
|
-
|
39
|
-
$db_front = "sbiccicms_front_local_auto";
|
40
|
-
|
41
|
-
$user = 'root';
|
42
|
-
|
43
|
-
$pass = '';
|
44
|
-
|
45
|
-
|
46
|
-
|
47
|
-
// URlファイルパス取得
|
48
|
-
|
49
|
-
$get_dir = __FILE__;
|
50
|
-
|
51
|
-
$get_dir_path = dirname($get_dir);
|
52
|
-
|
53
|
-
$csv_synonyms = glob($get_dir_path.'/csv/同義語マスタ_200421.csv');
|
54
|
-
|
55
|
-
$csv_suggest_words = glob($get_dir_path.'/csv/サジェストマスタ_200421.csv');
|
56
|
-
|
57
|
-
$csv_category_colors = glob($get_dir_path.'/categoris/category_colors.csv');
|
58
|
-
|
59
|
-
$csv_categories = glob($get_dir_path.'/categoris/categories.csv');
|
60
|
-
|
61
|
-
$csv_categories_links = glob($get_dir_path.'/categoris/categories_links.csv');
|
62
|
-
|
63
|
-
|
64
|
-
|
65
|
-
// 使用テーブル
|
66
|
-
|
67
|
-
$users_table = "users";
|
68
|
-
|
69
|
-
$site_configs_table = "site_configs";
|
70
|
-
|
71
|
-
$synonyms_table = "synonyms";
|
72
|
-
|
73
|
-
$suggest_words_table = "suggest_words";
|
74
|
-
|
75
|
-
$categories_table = "categories";
|
76
|
-
|
77
|
-
$categories_links_table = "categories_links";
|
78
|
-
|
79
|
-
|
80
|
-
|
81
|
-
|
82
|
-
|
83
|
-
|
84
|
-
|
85
|
-
try {
|
86
|
-
|
87
|
-
// DB接続
|
88
|
-
|
89
|
-
$dbh_admin = new PDO('mysql:host=127.0.0.1; dbname='.$db_admin.';charset=utf8', $user, $pass);
|
90
|
-
|
91
|
-
$dbh_common = new PDO('mysql:host=127.0.0.1; dbname='.$db_common.';charset=utf8', $user, $pass);
|
92
|
-
|
93
|
-
$dbh_front = new PDO('mysql:host=127.0.0.1; dbname='.$db_front.';charset=utf8', $user, $pass);
|
94
|
-
|
95
|
-
$dbh[] = $dbh_admin;
|
96
|
-
|
97
|
-
$dbh[] = $dbh_common;
|
98
|
-
|
99
|
-
$dbh[] = $dbh_front;
|
100
|
-
|
101
|
-
$dbh_count = count($dbh);
|
102
|
-
|
103
|
-
|
104
|
-
|
105
|
-
for ( $i = 0; $i < $dbh_count; $i++) {
|
106
|
-
|
107
|
-
// オートコミットオフ
|
108
|
-
|
109
|
-
$dbh[$i]->query("SET AUTOCOMMIT=0");
|
110
|
-
|
111
|
-
|
112
|
-
|
113
|
-
// 静的プレースホルダを指定
|
114
|
-
|
115
|
-
$dbh[$i]->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
|
116
|
-
|
117
|
-
|
118
|
-
|
119
|
-
//例外処理を投げる(スロー)ようにする
|
120
|
-
|
121
|
-
$dbh[$i]->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
122
|
-
|
123
|
-
|
124
|
-
|
125
|
-
// トランザクション開始
|
126
|
-
|
127
|
-
$dbh[$i]->beginTransaction();
|
128
|
-
|
129
|
-
}
|
130
|
-
|
131
|
-
|
132
|
-
|
133
|
-
// 共有ロック
|
134
|
-
|
135
|
-
$users_lock = $dbh[0]->prepare("SELECT * FROM ".$users_table. "WHERE ID = ? LOCK IN SHARE MODE");
|
136
|
-
|
137
|
-
$site_configs_lock = $dbh[0]->prepare("SELECT * FROM ".$site_configs_table. "WHERE ID = ? LOCK IN SHARE MODE");
|
138
|
-
|
139
|
-
$synonyms_lock = $dbh[2]->prepare("SELECT * FROM ".$synonyms_table." WHERE ID = ? LOCK IN SHARE MODE");
|
140
|
-
|
141
|
-
$suggest_words_lock = $dbh[2]->prepare("SELECT * FROM ".$suggest_words_table." WHERE ID = ? LOCK IN SHARE MODE");
|
142
|
-
|
143
|
-
$categories_lock = $dbh[2]->prepare("SELECT * FROM ".$categories_table." WHERE ID = ? LOCK IN SHARE MODE");
|
144
|
-
|
145
|
-
$categories_links_lock = $dbh[2]->prepare("SELECT * FROM ".$categories_links_table." WHERE ID = ? LOCK IN SHARE MODE");
|
146
|
-
|
147
|
-
|
148
|
-
|
149
25
|
echo "usersインサート開始";
|
150
26
|
|
151
27
|
$insert_users = "INSERT INTO ".$users_table."
|