search

shari-sushi / V-Kara-Lists

Vカラ（Vtuber歌枠把握アプリ）
MIT License
16 stars 4 forks source link

入力ミスへの対応 #244

Open shari-sushi opened 3 months ago

shari-sushi commented 3 months ago

「曲全部入れ終わったあとに、ひもづける動画間違えたことに気づいた」

の際、全部消して、違う動画に入れ直してもらうのはハードルが高い。

ということで、以下２つのissueのやる意義が強まった。

shari-sushi commented 3 months ago
なお自分でミスって自分で開発者権力使って直してた

### 修正範囲把握 ```sql mysql> select * from karaokes where movie_url = "www.youtube.com/watch?v=9rY0x96c2dg" order by karaoke_id asc; +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | karaoke_id | movie_url | sing_start | song_name | karaoke_inputter_id | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | 323 | www.youtube.com/watch?v=9rY0x96c2dg | 00:15:25 | BlueSunnyFish | secret | | 324 | www.youtube.com/watch?v=9rY0x96c2dg | 00:19:22 | Star of the Deep | secret | | 325 | www.youtube.com/watch?v=9rY0x96c2dg | 00:31:15 | BluePride | secret | | 327 | www.youtube.com/watch?v=9rY0x96c2dg | 00:39:15 | Swimmy | secret | | 328 | www.youtube.com/watch?v=9rY0x96c2dg | 00:43:48 | DANCE is the answer | secret | | 329 | www.youtube.com/watch?v=9rY0x96c2dg | 00:50:51 | Another World | secret | | 367 | www.youtube.com/watch?v=9rY0x96c2dg | 00:15:10 | 独りんぼエンヴィー | secret | | 368 | www.youtube.com/watch?v=9rY0x96c2dg | 00:19:57 | えれくとりっく・えんじぇぅ(1フレーズ) | secret | | 369 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:00 | ワールドイズマイン(1フレーズ) | secret | | 370 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:06 | ヴァンパイア(1フレーズ) | secret | | 371 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:09 | みくみくにしてあげる♪(1フレーズ) | secret | | 372 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:15 | ダブルラリアット(1フレーズ) | secret | | 373 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:18 | ハッピーシンセサイザ(1フレーズ) | secret | | 374 | www.youtube.com/watch?v=9rY0x96c2dg | 00:21:00 | 1925(1フレーズ) | secret | | 375 | www.youtube.com/watch?v=9rY0x96c2dg | 00:22:31 | 炉心融解(部分) | secret | | 376 | www.youtube.com/watch?v=9rY0x96c2dg | 00:23:25 | magnet(部分) | secret | | 377 | www.youtube.com/watch?v=9rY0x96c2dg | 00:25:25 | 夢喰い白黒バク | secret | | 378 | www.youtube.com/watch?v=9rY0x96c2dg | 00:32:02 | ロキ | secret | | 379 | www.youtube.com/watch?v=9rY0x96c2dg | 00:38:58 | ドレミファロンド(部分) | secret | | 380 | www.youtube.com/watch?v=9rY0x96c2dg | 00:44:52 | ファッキン・フライデー | secret | | 381 | www.youtube.com/watch?v=9rY0x96c2dg | 00:50:10 | 夜明けと蛍 | secret | | 382 | www.youtube.com/watch?v=9rY0x96c2dg | 00:56:35 | エイリアンエイリアン | secret | | 383 | www.youtube.com/watch?v=9rY0x96c2dg | 01:01:23 | ネトゲ廃人シュプレヒコール | secret | | 384 | www.youtube.com/watch?v=9rY0x96c2dg | 01:13:29 | 少女レイ(部分) | secret | | 385 | www.youtube.com/watch?v=9rY0x96c2dg | 01:14:01 | 深海少女(部分) | secret | | 386 | www.youtube.com/watch?v=9rY0x96c2dg | 01:19:39 | ベノム | secret | | 387 | www.youtube.com/watch?v=9rY0x96c2dg | 01:27:05 | 吉原ラメント | secret | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ 27 rows in set (0.00 sec) ``` __where句が正しいことを確認__ ```sql mysql> select * from karaokes where movie_url = "www.youtube.com/watch?v=9rY0x96c2dg" AND karaoke_id >= 367 order by karaoke_id asc; +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | karaoke_id | movie_url | sing_start | song_name | karaoke_inputter_id | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | 367 | www.youtube.com/watch?v=9rY0x96c2dg | 00:15:10 | 独りんぼエンヴィー | secret | | 368 | www.youtube.com/watch?v=9rY0x96c2dg | 00:19:57 | えれくとりっく・えんじぇぅ(1フレーズ) | secret | | 369 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:00 | ワールドイズマイン(1フレーズ) | secret | | 370 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:06 | ヴァンパイア(1フレーズ) | secret | | 371 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:09 | みくみくにしてあげる♪(1フレーズ) | secret | | 372 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:15 | ダブルラリアット(1フレーズ) | secret | | 373 | www.youtube.com/watch?v=9rY0x96c2dg | 00:20:18 | ハッピーシンセサイザ(1フレーズ) | secret | | 374 | www.youtube.com/watch?v=9rY0x96c2dg | 00:21:00 | 1925(1フレーズ) | secret | | 375 | www.youtube.com/watch?v=9rY0x96c2dg | 00:22:31 | 炉心融解(部分) | secret | | 376 | www.youtube.com/watch?v=9rY0x96c2dg | 00:23:25 | magnet(部分) | secret | | 377 | www.youtube.com/watch?v=9rY0x96c2dg | 00:25:25 | 夢喰い白黒バク | secret | | 378 | www.youtube.com/watch?v=9rY0x96c2dg | 00:32:02 | ロキ | secret | | 379 | www.youtube.com/watch?v=9rY0x96c2dg | 00:38:58 | ドレミファロンド(部分) | secret | | 380 | www.youtube.com/watch?v=9rY0x96c2dg | 00:44:52 | ファッキン・フライデー | secret | | 381 | www.youtube.com/watch?v=9rY0x96c2dg | 00:50:10 | 夜明けと蛍 | secret | | 382 | www.youtube.com/watch?v=9rY0x96c2dg | 00:56:35 | エイリアンエイリアン | secret | | 383 | www.youtube.com/watch?v=9rY0x96c2dg | 01:01:23 | ネトゲ廃人シュプレヒコール | secret | | 384 | www.youtube.com/watch?v=9rY0x96c2dg | 01:13:29 | 少女レイ(部分) | secret | | 385 | www.youtube.com/watch?v=9rY0x96c2dg | 01:14:01 | 深海少女(部分) | secret | | 386 | www.youtube.com/watch?v=9rY0x96c2dg | 01:19:39 | ベノム | secret | | 387 | www.youtube.com/watch?v=9rY0x96c2dg | 01:27:05 | 吉原ラメント | secret | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ 21 rows in set (0.00 sec) ``` ### 更新実行 ```sql > update karaokes set movie_url="www.youtube.com/watch?v=C6D-4JnsU_g" where movie_url = "www.youtube.com/watch?v=9rY0x96c2dg" AND karaoke_id >= 367; Query OK, 21 rows affected (0.01 sec) Rows matched: 21 Changed: 21 Warnings: 0 ``` 21行だから大丈夫そう ### 結果確認 ```sql > select * from karaokes where movie_url = "www.youtube.com/watch?v=9rY0x96c2dg" order by karaoke_id asc; +------------+-------------------------------------+------------+---------------------+---------------------+ | karaoke_id | movie_url | sing_start | song_name | karaoke_inputter_id | +------------+-------------------------------------+------------+---------------------+---------------------+ | 323 | www.youtube.com/watch?v=9rY0x96c2dg | 00:15:25 | BlueSunnyFish | secret | | 324 | www.youtube.com/watch?v=9rY0x96c2dg | 00:19:22 | Star of the Deep | secret | | 325 | www.youtube.com/watch?v=9rY0x96c2dg | 00:31:15 | BluePride | secret | | 327 | www.youtube.com/watch?v=9rY0x96c2dg | 00:39:15 | Swimmy | secret | | 328 | www.youtube.com/watch?v=9rY0x96c2dg | 00:43:48 | DANCE is the answer | secret | | 329 | www.youtube.com/watch?v=9rY0x96c2dg | 00:50:51 | Another World | secret | +------------+-------------------------------------+------------+---------------------+---------------------+ 6 rows in set (0.00 sec) ``` ```sql > > select * from karaokes where movie_url = "www.youtube.com/watch?v=C6D-4JnsU_g" order by karaoke_id desc; +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | karaoke_id | movie_url | sing_start | song_name | karaoke_inputter_id | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ | 387 | www.youtube.com/watch?v=C6D-4JnsU_g | 01:27:05 | 吉原ラメント | secret | | 386 | www.youtube.com/watch?v=C6D-4JnsU_g | 01:19:39 | ベノム | secret | | 385 | www.youtube.com/watch?v=C6D-4JnsU_g | 01:14:01 | 深海少女(部分) | secret | | 384 | www.youtube.com/watch?v=C6D-4JnsU_g | 01:13:29 | 少女レイ(部分) | secret | | 383 | www.youtube.com/watch?v=C6D-4JnsU_g | 01:01:23 | ネトゲ廃人シュプレヒコール | secret | | 382 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:56:35 | エイリアンエイリアン | secret | | 381 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:50:10 | 夜明けと蛍 | secret | | 380 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:44:52 | ファッキン・フライデー | secret | | 379 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:38:58 | ドレミファロンド(部分) | secret | | 378 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:32:02 | ロキ | secret | | 377 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:25:25 | 夢喰い白黒バク | secret | | 376 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:23:25 | magnet(部分) | secret | | 375 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:22:31 | 炉心融解(部分) | secret | | 374 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:21:00 | 1925(1フレーズ) | secret | | 373 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:20:18 | ハッピーシンセサイザ(1フレーズ) | secret | | 372 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:20:15 | ダブルラリアット(1フレーズ) | secret | | 371 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:20:09 | みくみくにしてあげる♪(1フレーズ) | secret | | 370 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:20:06 | ヴァンパイア(1フレーズ) | secret | | 369 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:20:00 | ワールドイズマイン(1フレーズ) | secret | | 368 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:19:57 | えれくとりっく・えんじぇぅ(1フレーズ) | secret | | 367 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:15:10 | 独りんぼエンヴィー | secret | | 366 | www.youtube.com/watch?v=C6D-4JnsU_g | 00:08:10 | 千本桜 | secret | +------------+-------------------------------------+------------+--------------------------------------------------------+---------------------+ 22 rows in set (0.00 sec) ``` ふぅ…