酒蔵名の読み仮名をひらがなに統一する

[y2naranja]

現在の画面上、

• 新規登録画面上は当該欄のラベルはひらがな
• 更新画面上は同ラベルはカタカナ
  （データもカタカナで入っている）

どちらかに統一した方が良い

可読性を考えると、ひらがなの方が良いのではないかと思います。

[nichesuch]

ひらがなで統一させるスクリプトを作るので、今は追加分だけひらがなで入れておいてくれればOKです。

[JQinglong]

「づ」、「ゔ」にも対応したバージョンのスクリプトです。
$ mongodb
use データベース名

の後で実行します。

db.breweries.find({$and: [{kana: {$exists: true}}, {kana: {$ne: null}}, {kana: {$ne: ''}}]}).forEach(function(row) {
row.kana = row.kana.replace("ア","あ");
row.kana = row.kana.replace("イ","い");
row.kana = row.kana.replace("ウ","う");
row.kana = row.kana.replace("エ","え");
row.kana = row.kana.replace("オ","お");
row.kana = row.kana.replace("カ","か");
row.kana = row.kana.replace("キ","き");
row.kana = row.kana.replace("ク","く");
row.kana = row.kana.replace("ケ","け");
row.kana = row.kana.replace("コ","こ");
row.kana = row.kana.replace("サ","さ");
row.kana = row.kana.replace("シ","し");
row.kana = row.kana.replace("ス","す");
row.kana = row.kana.replace("セ","せ");
row.kana = row.kana.replace("ソ","そ");
row.kana = row.kana.replace("タ","た");
row.kana = row.kana.replace("チ","ち");
row.kana = row.kana.replace("ツ","つ");
row.kana = row.kana.replace("テ","て");
row.kana = row.kana.replace("ト","と");
row.kana = row.kana.replace("ナ","な");
row.kana = row.kana.replace("ニ","に");
row.kana = row.kana.replace("ヌ","ぬ");
row.kana = row.kana.replace("ネ","ね");
row.kana = row.kana.replace("ノ","の");
row.kana = row.kana.replace("ハ","は");
row.kana = row.kana.replace("ヒ","ひ");
row.kana = row.kana.replace("フ","ふ");
row.kana = row.kana.replace("ヘ","へ");
row.kana = row.kana.replace("ホ","ほ");
row.kana = row.kana.replace("マ","ま");
row.kana = row.kana.replace("ミ","み");
row.kana = row.kana.replace("ム","む");
row.kana = row.kana.replace("メ","め");
row.kana = row.kana.replace("モ","も");
row.kana = row.kana.replace("ヤ","や");
row.kana = row.kana.replace("ユ","ゆ");
row.kana = row.kana.replace("ヨ","よ");
row.kana = row.kana.replace("ラ","ら");
row.kana = row.kana.replace("リ","り");
row.kana = row.kana.replace("ル","る");
row.kana = row.kana.replace("レ","れ");
row.kana = row.kana.replace("ロ","ろ");
row.kana = row.kana.replace("ワ","わ");
row.kana = row.kana.replace("ヰ","ゐ");
row.kana = row.kana.replace("ヱ","ゑ");
row.kana = row.kana.replace("ヲ","を");
row.kana = row.kana.replace("ン","ん");
row.kana = row.kana.replace("ガ","が");
row.kana = row.kana.replace("ギ","ぎ");
row.kana = row.kana.replace("グ","ぐ");
row.kana = row.kana.replace("ゲ","げ");
row.kana = row.kana.replace("ゴ","ご");
row.kana = row.kana.replace("ザ","ざ");
row.kana = row.kana.replace("ジ","じ");
row.kana = row.kana.replace("ズ","ず");
row.kana = row.kana.replace("ゼ","ぜ");
row.kana = row.kana.replace("ゾ","ぞ");
row.kana = row.kana.replace("ダ","だ");
row.kana = row.kana.replace("ヂ","ぢ");
row.kana = row.kana.replace("ヅ","づ");
row.kana = row.kana.replace("デ","で");
row.kana = row.kana.replace("ド","ど");
row.kana = row.kana.replace("バ","ば");
row.kana = row.kana.replace("ビ","び");
row.kana = row.kana.replace("ブ","ぶ");
row.kana = row.kana.replace("ベ","べ");
row.kana = row.kana.replace("ボ","ぼ");
row.kana = row.kana.replace("パ","ぱ");
row.kana = row.kana.replace("ピ","ぴ");
row.kana = row.kana.replace("プ","ぷ");
row.kana = row.kana.replace("ペ","ぺ");
row.kana = row.kana.replace("ポ","ぽ");
row.kana = row.kana.replace("ヴ","ゔ");
row.kana = row.kana.replace("ァ","ぁ");
row.kana = row.kana.replace("ィ","ぃ");
row.kana = row.kana.replace("ゥ","ぅ");
row.kana = row.kana.replace("ェ","ぇ");
row.kana = row.kana.replace("ォ","ぉ");
row.kana = row.kana.replace("ッ","っ");
row.kana = row.kana.replace("ャ","ゃ");
row.kana = row.kana.replace("ュ","ゅ");
row.kana = row.kana.replace("ョ","ょ");
row.kana = row.kana.replace("ｱ","あ");
row.kana = row.kana.replace("ｲ","い");
row.kana = row.kana.replace("ｳ","う");
row.kana = row.kana.replace("ｴ","え");
row.kana = row.kana.replace("ｵ","お");
row.kana = row.kana.replace("ｶ","か");
row.kana = row.kana.replace("ｷ","き");
row.kana = row.kana.replace("ｸ","く");
row.kana = row.kana.replace("ｹ","け");
row.kana = row.kana.replace("ｺ","こ");
row.kana = row.kana.replace("ｻ","さ");
row.kana = row.kana.replace("ｼ","し");
row.kana = row.kana.replace("ｽ","す");
row.kana = row.kana.replace("ｾ","せ");
row.kana = row.kana.replace("ｿ","そ");
row.kana = row.kana.replace("ﾀ","た");
row.kana = row.kana.replace("ﾁ","ち");
row.kana = row.kana.replace("ﾂ","つ");
row.kana = row.kana.replace("ﾃ","て");
row.kana = row.kana.replace("ﾄ","と");
row.kana = row.kana.replace("ﾅ","な");
row.kana = row.kana.replace("ﾆ","に");
row.kana = row.kana.replace("ﾇ","ぬ");
row.kana = row.kana.replace("ﾈ","ね");
row.kana = row.kana.replace("ﾉ","の");
row.kana = row.kana.replace("ﾊ","は");
row.kana = row.kana.replace("ﾋ","ひ");
row.kana = row.kana.replace("ﾌ","ふ");
row.kana = row.kana.replace("ﾍ","へ");
row.kana = row.kana.replace("ﾎ","ほ");
row.kana = row.kana.replace("ﾏ","ま");
row.kana = row.kana.replace("ﾐ","み");
row.kana = row.kana.replace("ﾑ","む");
row.kana = row.kana.replace("ﾒ","め");
row.kana = row.kana.replace("ﾓ","も");
row.kana = row.kana.replace("ﾔ","や");
row.kana = row.kana.replace("ﾕ","ゆ");
row.kana = row.kana.replace("ﾖ","よ");
row.kana = row.kana.replace("ﾗ","ら");
row.kana = row.kana.replace("ﾘ","り");
row.kana = row.kana.replace("ﾙ","る");
row.kana = row.kana.replace("ﾚ","れ");
row.kana = row.kana.replace("ﾛ","ろ");
row.kana = row.kana.replace("ﾜ","わ");
row.kana = row.kana.replace("ｦ","を");
row.kana = row.kana.replace("ﾝ","ん");
row.kana = row.kana.replace("ｶﾞ","が");
row.kana = row.kana.replace("ｷﾞ","ぎ");
row.kana = row.kana.replace("ｸﾞ","ぐ");
row.kana = row.kana.replace("ｹﾞ","げ");
row.kana = row.kana.replace("ｺﾞ","ご");
row.kana = row.kana.replace("ｻﾞ","ざ");
row.kana = row.kana.replace("ｼﾞ","じ");
row.kana = row.kana.replace("ｽﾞ","ず");
row.kana = row.kana.replace("ｾﾞ","ぜ");
row.kana = row.kana.replace("ｿﾞ","ぞ");
row.kana = row.kana.replace("ﾀﾞ","だ");
row.kana = row.kana.replace("ﾁﾞ","ぢ");
row.kana = row.kana.replace("ﾂﾞ","づ");
row.kana = row.kana.replace("ﾃﾞ","で");
row.kana = row.kana.replace("ﾄﾞ","ど");
row.kana = row.kana.replace("ﾊﾞ","ば");
row.kana = row.kana.replace("ﾋﾞ","び");
row.kana = row.kana.replace("ﾌﾞ","ぶ");
row.kana = row.kana.replace("ﾍﾞ","べ");
row.kana = row.kana.replace("ﾎﾞ","ぼ");
row.kana = row.kana.replace("ﾊﾟ","ぱ");
row.kana = row.kana.replace("ﾋﾟ","ぴ");
row.kana = row.kana.replace("ﾌﾟ","ぷ");
row.kana = row.kana.replace("ﾍﾟ","ぺ");
row.kana = row.kana.replace("ﾎﾟ","ぽ");
row.kana = row.kana.replace("ｳﾞ","ゔ");
row.kana = row.kana.replace("ｧ","ぁ");
row.kana = row.kana.replace("ｨ","ぃ");
row.kana = row.kana.replace("ｩ","ぅ");
row.kana = row.kana.replace("ｪ","ぇ");
row.kana = row.kana.replace("ｫ","ぉ");
row.kana = row.kana.replace("ｯ","っ");
row.kana = row.kana.replace("ｬ","ゃ");
row.kana = row.kana.replace("ｭ","ゅ");
row.kana = row.kana.replace("ｮ","ょ");
row.kana = row.kana.replace("ｰ","ー");
db.breweries.save(row);
});

db.breweries.find({$and: [{kana: {$exists: true}}, {kana: {$ne: null}}, {kana: {$ne: ''}}]}).forEach(function(row) {
row.kana = row.kana.replace("かﾞ","が");
row.kana = row.kana.replace("きﾞ","ぎ");
row.kana = row.kana.replace("くﾞ","ぐ");
row.kana = row.kana.replace("けﾞ","げ");
row.kana = row.kana.replace("こﾞ","ご");
row.kana = row.kana.replace("さﾞ","ざ");
row.kana = row.kana.replace("しﾞ","じ");
row.kana = row.kana.replace("すﾞ","ず");
row.kana = row.kana.replace("せﾞ","ぜ");
row.kana = row.kana.replace("そﾞ","ぞ");
row.kana = row.kana.replace("たﾞ","だ");
row.kana = row.kana.replace("ちﾞ","ぢ");
row.kana = row.kana.replace("つﾞ","づ");
row.kana = row.kana.replace("てﾞ","で");
row.kana = row.kana.replace("とﾞ","ど");
row.kana = row.kana.replace("はﾞ","ば");
row.kana = row.kana.replace("ひﾞ","び");
row.kana = row.kana.replace("ふﾞ","ぶ");
row.kana = row.kana.replace("へﾞ","べ");
row.kana = row.kana.replace("ほﾞ","ぼ");
row.kana = row.kana.replace("はﾟ","ぱ");
row.kana = row.kana.replace("ひﾟ","ぴ");
row.kana = row.kana.replace("ふﾟ","ぷ");
row.kana = row.kana.replace("へﾟ","ぺ");
row.kana = row.kana.replace("ほﾟ","ぽ");
row.kana = row.kana.replace("うﾞ","ゔ");
db.breweries.save(row);
});

[shinjima2]

APIたたいて最新の酒蔵情報を確認したところ、ふりがなは、ひらがなに統一されていましたのでcloseですね。
https://docs.google.com/spreadsheets/d/1sbYP_nIy8TR4hwRKhgiJ7DRiSsRAcom0IO4_76oH1QY/edit?usp=sharing（私がCloseしても良かった？）

[nichesuch]

@shinjima2 確認ありがとうございます！