3,765
回編集
差分
編集の要約なし
[[category:memo|{{PAGENAME}}]]
== DB接続情報==
$ heroku pg:credentials:url --app アプリケーション名
== herokuのタイムゾーン変更==
$ heroku run bash
~ $ date 確認
Sun Feb 24 08:21:11 JST 2019
== heroku postgresql タイムゾーン設定==
$ heroku pg:credentials:url --app shrxxxxx-xxx-xxx データベース名確認
$ heroku pg:psql
heroku pg:psql -c "\d clients"
== シーケンス確認==
heroku pg:psql -c "select * from clients_id_seq"
heroku pg:psql -c "\copy journals (journal_number,date,schedule_id,client_id,debit,debit_money,description_id,etc,credit,credit_money,user_id,jiin_id,account_id,created_at,updated_at) from '/home/shudo/kg_siwakemeisai_date.csv' with csv"
== backup==
heroku pg:backups:capture --app app_name
heroku pg:backups -a app_name
heroku pg:backups restore bxxx -a アプリ名
アプリ間でデータを移行する % heroku pg:copy shrieking-asylum-92472::DATABASE_URL DATABASE_URL -a tepnote ▸ WARNING: Destructive action ▸ This command will remove all data from DATABASE ▸ Data from PINK will then be transferred to DATABASE ▸ To proceed, type tepnote or re-run this command with --confirm tepnote > tepnote Starting copy of PINK to DATABASE... done Copying... done == CSV書き出し==
$ heroku pg:psql -c "\copy (select * from schedules where jiin_id = 2) TO kougen_schedules.csv WITH CSV HEADER"
または
== Hobby Dev Free から Hobby Basic $9.00 に移行したとき データの移し方==
heroku pg:copy SOURCE TARGET
$ heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_color_URL
$ heroku logs --tail
== データベースへ列の追加など==
$ heroku run rails db:migrate
== SELECTした結果でUPDATEする==
$ heroku pg:psql -c "update kaimyous set ie_id = clients.ie_id from clients where kaimyous.client_id = clients.id and kaimyous.jiin_id = 1 and kaimyous.ie_id is null"