3,728
回編集
差分
Tep3-onk
,→db:rollback
[[category:memo|{{PAGENAME}}]]
{{Font color}}
== generate ==
% 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 ==
=# update clients_old set ie_id = 6000 where ie_id = 2090 and jiin_id > 1;
== 親テーブルie_id 子テーブルie_id 差分削除 ==
% diff aa_clients_id_ie_id.csv bb_clients_old_ie_id.csv > diff.csv
=== insert ===
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>
=== insert エラー ===
% rails db:migrate:up VERSION=
{{font color||yellow|後で本番環境も変更}}
不要
=# delete from clients_old where id in (4028,3911,3912,2998,3007,4359);
=# 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;
エラーのとき
== 参考 ==
<nowiki>=# delete from clients_old where id ie_id in (97721,
22,
23,
27,
30,
34,
35,
41,
43,
45,
48,
49,
52,
53,
62,
64,
66,
68,
69,
79,
80,
97,
98,
100,
104,