最新版 |
編集中の文章 |
1行目: |
1行目: |
| | | |
| [[category:memo|{{PAGENAME}}]] | | [[category:memo|{{PAGENAME}}]] |
− | == sendgrid設定 ==
| |
− | [https://www.bokukoko.info/entry/2020/12/07/080000 参考]
| |
| | | |
| == DB接続情報 == | | == DB接続情報 == |
64行目: |
62行目: |
| heroku pg:backups restore bxxx -a アプリ名 | | heroku pg:backups restore bxxx -a アプリ名 |
| | | |
− | == アプリ間でデータを移行する ==
| + | アプリ間でデータを移行する |
| % heroku pg:copy shrieking-asylum-92472::DATABASE_URL DATABASE_URL -a tepnote | | % heroku pg:copy shrieking-asylum-92472::DATABASE_URL DATABASE_URL -a tepnote |
| ▸ WARNING: Destructive action | | ▸ WARNING: Destructive action |
88行目: |
86行目: |
| $ heroku pg:promote HEROKU_POSTGRESQL_color_URL 新しいデータベースをプロモートする | | $ heroku pg:promote HEROKU_POSTGRESQL_color_URL 新しいデータベースをプロモートする |
| $ heroku pg:info 確認 | | $ heroku pg:info 確認 |
− | == データベース操作 ==
| + | |
− | $ heroku pg:psql -c "SELECT * FROM users"
| |
| $ heroku pg:psql -c "UPDATE clients SET nusi = true WHERE id = " | | $ heroku pg:psql -c "UPDATE clients SET nusi = true WHERE id = " |
| $ heroku pg:psql -c "DELETE FROM products WHERE price = 10" | | $ heroku pg:psql -c "DELETE FROM products WHERE price = 10" |
| | | |
− | $ heroku pg:psql
| |
− | =>
| |
− | INSERT INTO holidays (holiday, title, created_at, updated_at) VALUES
| |
− | ('2021-1-1','元日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-1-11', '成人の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-2-11', '建国記念の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-2-23', '天皇誕生日', '2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-3-20', '春分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-4-29', '昭和の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-5-3', '憲法記念日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-5-4', 'みどりの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-5-5', 'こどもの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-7-22', '海の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-7-23', 'スポーツの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-8-8', '山の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-8-9', '休日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-9-20', '敬老の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-9-23', '秋分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-11-3', '文化の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2021-11-23','勤労感謝の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-1-1', '元日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-1-10', '成人の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-2-11', '建国記念の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-2-23', '天皇誕生日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-3-21', '春分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-4-29', '昭和の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-5-3', '憲法記念日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-5-4', 'みどりの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-5-5', 'こどもの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-7-18', '海の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-8-11', '山の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-9-19', '敬老の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-9-23', '秋分の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-10-10','スポーツの日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-11-3', '文化の日','2021-06-15 18:46:45','2021-06-15 18:46:45'),
| |
− | ('2022-11-23','勤労感謝の日','2021-06-15 18:46:45','2021-06-15 18:46:45');
| |
− |
| |
− | == ローカルのテーブルをCSVで書き出しHEROKUのテーブルにコピーする ==
| |
− | =# COPY descriptions(content,user_id,jiin_id,account_id,created_at,updated_at,money) TO '/Users/jq/environment/table_data/descriptions.csv';
| |
− |
| |
− | heroku pg:psql -c "select setval ('descriptions_id_seq', 1, false)" ←シーケンスのリセット
| |
− |
| |
− | heroku pg:psql -c "\COPY descriptions(content,user_id,jiin_id,account_id,created_at,updated_at,money) FROM '/Users/jq/environment/table_data/descriptions.csv'"
| |
− |
| |
− | == ログ ==
| |
| $ heroku logs --tail | | $ heroku logs --tail |
| | | |