3,728
回編集
差分
→db:rollback
% rails generate scaffold Other user:references note:references client:references name:string yomi:string client_name:boolean line:integer memo:text generation:string
% rails generate scaffold List user:references note:references content:string line:integer
$ rails generate scaffold Post content:text user:references picture:string
$ rails db:migrate:up VERSION=20200504051127
% rails db:migrate:reset
== postgres ==
== 親テーブルie_id 子テーブルie_id 差分削除 ==
% diff aa_clients_id_ie_id.csv bb_clients_old_ie_id.csv > diff.csv
=== insert ===
=# update clients_old set nusi = false where id = 3703;</nowiki>
== {{font color||yellow|移動本番でも}} ==
update clients_old set nusi = true where id = 523;
delete from clients_old where id = 845;
<nowiki>update clients_old set ie_id = 1264 where id = 515;
update clients_old set ie_id = 1264 where id = 1463;
update clients_old set nusi = false where id = 515;</nowiki>
delete from clients_old where id = 217;
update clients_old set nusi = false where id = 218;
update clients_old set ie_id = 204 where id = 218;
delete from clients_old where id = 811;
update clients_old set nusi = true where id = 1792;
delete from clients_old where id = 810;
delete from clients_old where ie_id = 22653;
<nowiki>delete from clients_old where ie_id = 22653;
DELETE 3
tep5_development=# insert into others
(
id, name, yomi, client_id, client_name, user_id, note_id, created_at, updated_at, memo, line, generation
)
select
id, name, yomi, ie_id, nusi, user_id, jiin_id, created_at, updated_at, memo, each_order, generation
from
clients_old;
INSERT 0 4747</nowiki>
=== 指定行を作る ===
;
UPDATE 3066</nowiki>
=== 作業テーブル削除 ===
<nowiki>tep5_development=# drop table clients_old ;
DROP TABLE
tep5_development=# drop table jq_clients ;
DROP TABLE
tep5_development=# drop table users_old ;
DROP TABLE</nowiki>
== ローカル ==
== 同期 ==
除外するファイルをまとめる
<nowiki>exclude-file.txt
$ bundle install --without test development
{{font color||yellow|database.yml username:などを確認する （2箇所）}} {{font color||yellow|migrationファイルがダブったときは削除}} $ rails db:migrate:status RAILS_ENV=production
$ rails db:create RAILS_ENV=production
または
$ rails db:reset RAILS_ENV=production
または
$ rails db:drop RAILS_ENV=production
または
=# drop database mydb;
エラーのとき
5158,
6053)
DELETE 307</nowiki>