search

pine0619 / enpit_omusubi

0 stars 4 forks source link

DBの位置情報カラムをnot nullにする #86

Closed pine0619 closed 3 years ago

pine0619 commented 3 years ago

現在のDBの構造 instagram_link以外のカラムはnot null制約をかけています。

なのでmerge前のデータは一回全部削除する必要がある。

pine0619 commented 3 years ago

migration書き換え後の手順。

  1. docker-compose up -dでコンテナ立ち上げ。
  2. docker-compose exec db psql -U postgresでpostgresに入る。
  3. \c omusubi_developmentでデータベースの切り替え。
  4. DELETE FROM images;でimagesテーブルのデータを削除する。 削除できたら、
  5. docker-compose exec web rails db:migrateでマイグレーションを反映させる。
  6. docker-compose exec web rails db:migrate:statusでupになっていればOK
pine0619 commented 3 years ago

データを入れる手順

  1. docker-compose up -d

  2. docker-compose exec web rails c 以下のデータを入れる。 全部まとめてコピーして、コンソールに貼り付けOK

    新しくデータを入れるときは下に追加していって欲しい！

    Image.create(place_name: "Hally’s Cafe", latitude: 26.245671, longitude: 127.739715, image_path: "hallys_cafe.jpg", category: "food", instagram_link: "https://www.instagram.com/p/CGl2mKdnJqD/?utm_source=ig_web_copy_link")
Image.create(place_name: "麺道くろとん　宜野湾店", latitude: 26.262737, longitude: 127.752032, image_path: "kuroton.jpg", category: "food", instagram_link: "https://www.instagram.com/p/CG30k5anzWr/?utm_source=ig_web_copy_link")
Image.create(place_name: "備瀬フクギの森", latitude: 26.702644, longitude: 127.881007, image_path: "hukugi.jpg", category: "view")
Image.create(place_name: "ライカム", latitude:26.324394485073046 , longitude:127.79606768875558 , image_path: "rycom.jpg", category: "view")
Image.create(place_name: "希望が丘", latitude:26.52406207297499, longitude:127.92155551413141 , image_path: "kibougaoka.jpg", category: "view")
Image.create(place_name: "首里城", latitude:26.218510583729348, longitude:127.71535139693441 , image_path: "kirei_shurijo.jpg", category: "view")
Image.create(place_name: "アメリカンビレッジ", latitude:26.316035523707193, longitude:127.75719936569392, image_path: "mihama.jpg", category: "view")
Image.create(place_name: "ムーンビーチホテル", latitude:26.450684217763918, longitude:127.80232117152032, image_path: "mu-nbi-ti.jpg", category: "view")
Image.create(place_name: "那覇バスターミナル", latitude:26.211208095813436, longitude:127.67653748528804, image_path: "naha_bus_terminal.jpg", category: "view")
Image.create(place_name: "奥武島", latitude:26.130091272895136, longitude:127.7724547525508, image_path: "Ou_Island.jpg", category: "view")
Image.create(place_name: "ローズガーデンカフェ", latitude:26.315980222139096, longitude:127.79689718713848, image_path: "rose_garden.jpg", category: "food")
Image.create(place_name: "ウミカジテラス", latitude:26.176806452010727, longitude:127.64100458287963, image_path: "umikazi.jpg", category: "view")
Image.create(place_name: "浜比嘉島", latitude:26.32194356764346, longitude:127.95883336511329, image_path: "higa.jpg", category: "view")
Image.create(place_name: "海中道路", latitude:26.33341466039478, longitude:127.92240606873355, image_path: "kaityuudouro.jpg", category: "view")
Image.create(place_name: "県民の森", latitude:26.508148807974635, longitude:127.91074967800374, image_path: "kenmin_forest.jpg", category: "view")
Image.create(place_name: "ティーヌ浜ハートロック", latitude: 26.7139169, longitude: 128.0125653, image_path: "heartrock.JPG", category: "view") 
Image.create(place_name: "雨乞嶽展望台", latitude: 26.2140949, longitude: 127.7181127, image_path: "amagoidake.JPG", category: "view")
Image.create(place_name: "万座毛", latitude: 26.5049539, longitude: 127.8479568, image_path: "manzamou.jpg", category: "view")
Image.create(place_name: "聖クララ教会", latitude: 26.2003173934204, longitude: 127.75374599748382, image_path: "seicrara.jpg", category: "view")
Image.create(place_name: "ビストロムトウ", latitude: 26.211615548717894, longitude: 127.67700075515421, image_path: "bistromuto.jpg", category: "food")
Image.create(place_name: "Purecastle珈琲", latitude: 26.159640581062533, longitude: 127.6617559974832, image_path: "purecastle.jpg", category: "food")
Image.create(place_name: "かんなプラス", latitude: 26.3245107, longitude: 127.745927, image_path: "kannnapurasu.jpg", category: "food")
Image.create(place_name: "ライカムタリーズコーヒ", latitude: 26.3150175, longitude: 127.7956564, image_path: "tullys.jpg", category: "food")
Image.create(place_name: "ラルフズ バーガーレストラン", latitude: 26.331769, longitude: 127.7955316, image_path: "ralphs.JPG", category: "food")
Image.create(place_name: "夜麺食堂 松風", latitude: 26.3326048, longitude: 127.7944562, image_path: "matsukaze.JPG", category: "food")
Image.create(place_name: "ライカムライナカフェ", latitude: 26.3142605, longitude: 127.7947002, image_path: "lanai.jpg", category: "food")
Image.create(place_name: "安座間さんさんビーチ", latitude: 26.3245107, longitude: 127.745927, image_path: "azamasansan.jpg", category: "view")
Image.create(place_name: "海洋博公園", latitude: 26.3245107, longitude: 127.745927, image_path: "kaiyouhaku.jpg", category: "view")
Image.create(place_name: "LesTraces", latitude: 26.3245107, longitude: 127.745927, image_path: "LesTraces.jpg", category: "food")
Image.create(place_name: "ピザ喫茶モミザの木", latitude: 26.3245107, longitude: 127.745927, image_path: "momiza.jpg", category: "food")
Image.create(place_name: "道の駅恩納", latitude: 26.3245107, longitude: 127.745927, image_path: "onna.jpg", category: "food")
Image.create(place_name: "サボテン畑　沖縄", latitude: 26.3245107, longitude: 127.745927, image_path: "saboten.jpg", category: "view")
Image.create(place_name: "サンモンテ　宜野湾", latitude: 26.3245107, longitude: 127.745927, image_path: "sunmonte.jpg", category: "food")
Image.create(place_name: "豊見城タコライス", latitude: 26.3245107, longitude: 127.745927, image_path: "tomigusuku_tacorice.jpg", category: "food")
Image.create(place_name: "沖縄手作りジェラート yukuRu", latitude: 26.3245107, longitude: 127.745927, image_path: "yukuru.jpg", category: "food")
Image.create(place_name: "mati-cafe", latitude: 26.2720383, longitude: 127.7252855, image_path: "mati-cafe.jpg", category: "food")
Image.create(place_name: "hawaiian pancake cafe KOA", latitude: 26.1178096, longitude: 127.6603784, image_path: "koa.jpg", category: "food")
Image.create(place_name: "百年古家　大家", latitude: 26.6210011, longitude: 127.961483, image_path: "uhuya.jpg", category: "view")
Image.create(place_name: "那覇クルーズターミナル", latitude: 26.2254798, longitude: 127.6724477, image_path: "cruise.jpg", category: "view")
Image.create(place_name: "今帰仁城跡", latitude: 26.6912841, longitude: 127.9268339, image_path: "nakijin-siro.jpg", category: "view")
Image.create(place_name: "真壁公園", latitude: 26.1092296, longitude: 127.6907561, image_path: "makabe.jpg", category: "view")
Image.create(place_name: "Rimoイーアス沖縄豊崎店", latitude: 26.1577397, longitude: 127.6487884, image_path: "gelato.jpg", category: "food")
Image.create(place_name: "沖縄アウトレットモール あしびなー", latitude: 26.1590994, longitude: 127.656113, image_path: "asibina.jpg", category: "view")
Image.create(place_name: "DMM水族館", latitude: 26.1590994, longitude: 127.656113, image_path: "DMMaquarium.jpg", category: "view")
Naha192839 commented 3 years ago

間違ったデータを削除したいとき、 herokuでコンソールから

rails c

する。 その後、

Image.where(place_name: "削除したい写真の名前")

でその写真のidを確認する。

Image.find(さっき確認したid).destroy

で削除する。