マイグレーション - HirokatsuIino/scaffolding_books3 GitHub Wiki
rails generate migration CreateJoinTableAuthorBook author book bin/rake generate migration CreateJoinTableAuthorBook author book bin/rake generate scaffold user username: string password_ digest: string email: string dm: boolean roles: string reviews_ count: integer bin/rake generate scaffold author user: references name: string birth: date address: text ctype: string photo: binary bin/rake generate scaffold review book: references user: references status: integer body: text bin/rake generate scaffold fan_ comment author_ no: integer name: string body: text deleted: boolean bin/rake generate model memo memoable: references{ polymorphic}
rails db: migrate bin/rake db:migrate
<マイグレーションログ> rails generate migration CreateJoinTableAuthorBook author book rails generate scaffold user username: string password_ digest: string email: string dm: boolean roles: string reviews_ count: integer rails generate scaffold author user: references name: string birth: date address: text ctype: string photo: binary rails generate scaffold review book: references user: references status: integer body: text rails generate scaffold fan_ comment author_ no: integer name: string body: text deleted: boolean rails generate model memo memoable: references{ polymorphic}
hirokatsu:/workspace (master) $ rails generate migration CreateJoinTableAuthorBook author book
Running via Spring preloader in process 4979
invoke active_record
identical db/migrate/20170917050047_create_join_table_author_book.rb
hirokatsu:/workspace (master) $ rails generate scaffold user username: string password_ digest: string email: string dm: boolean roles: string reviews_ count: integer
Running via Spring preloader in process 4990
invoke active_record
identical db/migrate/20170917050223_create_users.rb
identical app/models/user.rb
invoke test_unit
identical test/models/user_test.rb
identical test/fixtures/users.yml
invoke resource_route
route resources :users
invoke scaffold_controller
identical app/controllers/users_controller.rb
invoke erb
exist app/views/users
identical app/views/users/index.html.erb
identical app/views/users/edit.html.erb
identical app/views/users/show.html.erb
identical app/views/users/new.html.erb
identical app/views/users/_form.html.erb
invoke test_unit
identical test/controllers/users_controller_test.rb
invoke helper
identical app/helpers/users_helper.rb
invoke test_unit
invoke jbuilder
identical app/views/users/index.json.jbuilder
identical app/views/users/show.json.jbuilder
identical app/views/users/user.json.jbuilder
invoke assets
invoke coffee
identical app/assets/javascripts/users.coffee
invoke scss
identical app/assets/stylesheets/users.scss
invoke scss
identical app/assets/stylesheets/scaffolds.scss
hirokatsu:/workspace (master) $ rails generate scaffold author user: references name: string birth: date address: text ctype: string photo: binary
Running via Spring preloader in process 5001
invoke active_record
identical db/migrate/20170917050224_create_authors.rb
identical app/models/author.rb
invoke test_unit
identical test/models/author_test.rb
identical test/fixtures/authors.yml
invoke resource_route
route resources :authors
invoke scaffold_controller
identical app/controllers/authors_controller.rb
invoke erb
exist app/views/authors
identical app/views/authors/index.html.erb
identical app/views/authors/edit.html.erb
identical app/views/authors/show.html.erb
identical app/views/authors/new.html.erb
identical app/views/authors/_form.html.erb
invoke test_unit
identical test/controllers/authors_controller_test.rb
invoke helper
identical app/helpers/authors_helper.rb
invoke test_unit
invoke jbuilder
identical app/views/authors/index.json.jbuilder
identical app/views/authors/show.json.jbuilder
identical app/views/authors/_author.json.jbuilder
invoke assets
invoke coffee
identical app/assets/javascripts/authors.coffee
invoke scss
identical app/assets/stylesheets/authors.scss
invoke scss
identical app/assets/stylesheets/scaffolds.scss
hirokatsu:/workspace (master) $ rails generate scaffold review book: references user: references status: integer body: text
Running via Spring preloader in process 5012
invoke active_record
identical db/migrate/20170917050225_create_reviews.rb
identical app/models/review.rb
invoke test_unit
identical test/models/review_test.rb
identical test/fixtures/reviews.yml
invoke resource_route
route resources :reviews
invoke scaffold_controller
identical app/controllers/reviews_controller.rb
invoke erb
exist app/views/reviews
identical app/views/reviews/index.html.erb
identical app/views/reviews/edit.html.erb
identical app/views/reviews/show.html.erb
identical app/views/reviews/new.html.erb
identical app/views/reviews/form.html.erb
invoke test_unit
identical test/controllers/reviews_controller_test.rb
invoke helper
identical app/helpers/reviews_helper.rb
invoke test_unit
invoke jbuilder
identical app/views/reviews/index.json.jbuilder
identical app/views/reviews/show.json.jbuilder
identical app/views/reviews/review.json.jbuilder
invoke assets
invoke coffee
identical app/assets/javascripts/reviews.coffee
invoke scss
identical app/assets/stylesheets/reviews.scss
invoke scss
identical app/assets/stylesheets/scaffolds.scss
hirokatsu:~/workspace (master) $ rails generate scaffold fan comment author no: integer name: string body: text deleted: boolean
Running via Spring preloader in process 5023
invoke active_record
identical db/migrate/20170917050226_create_fan_s.rb
identical app/models/fan.rb
invoke test_unit
identical test/models/fan__test.rb
identical test/fixtures/fan_s.yml
invoke resource_route
route resources :fan_s
invoke scaffold_controller
identical app/controllers/fan_s_controller.rb
invoke erb
exist app/views/fan_s
identical app/views/fan_s/index.html.erb
identical app/views/fan_s/edit.html.erb
identical app/views/fan_s/show.html.erb
identical app/views/fan_s/new.html.erb
identical app/views/fan_s/_form.html.erb
invoke test_unit
identical test/controllers/fan_s_controller_test.rb
invoke helper
identical app/helpers/fan_s_helper.rb
invoke test_unit
invoke jbuilder
identical app/views/fan_s/index.json.jbuilder
identical app/views/fan_s/show.json.jbuilder
identical app/views/fan_s/fan.json.jbuilder
invoke assets
invoke coffee
identical app/assets/javascripts/fan_s.coffee
invoke scss
identical app/assets/stylesheets/fan_s.scss
invoke scss
identical app/assets/stylesheets/scaffolds.scss
hirokatsu:/workspace (master) $ rails generate model memo memoable: references{ polymorphic}
Running via Spring preloader in process 5034
invoke active_record
conflict db/migrate/20170917071938_create_memos.rb
Another migration is already named create_memos: /home/ubuntu/workspace/db/migrate/20170917050227_create_memos.rb. Use --force to replace this migration or --skip to ignore conflicted file.
hirokatsu:/workspace (master) $
hirokatsu:/workspace (master) $
hirokatsu:/workspace (master) $
hirokatsu:/workspace (master) $
hirokatsu:/workspace (master) $ bin/rake db:migrate
Running via Spring preloader in process 5057
hirokatsu:~/workspace (master) $ rails db:fixtures:load
Error: Command 'db:fixtures:load' not recognized
Did you mean: $ rake db:fixtures:load
?
Usage: rails COMMAND [ARGS]
The most common rails commands are: generate Generate new code (short-cut alias: "g") console Start the Rails console (short-cut alias: "c") server Start the Rails server (short-cut alias: "s") dbconsole Start a console for the database specified in config/database.yml (short-cut alias: "db") new Create a new Rails application. "rails new my_app" creates a new application called MyApp in "./my_app"
In addition to those, there are: destroy Undo code generated with "generate" (short-cut alias: "d") plugin new Generates skeleton for developing a Rails plugin runner Run a piece of code in the application environment (short-cut alias: "r")
All commands can be run with -h (or --help) for more information.
hirokatsu:/workspace (master) $ bin/rake db:fixtures:load
Running via Spring preloader in process 5079
rake aborted!
ActiveRecord::StatementInvalid: SQLite3::ConstraintException: NOT NULL constraint failed: fan_s.created_at: INSERT INTO "fan_s" ("comment", "author_", "no", "integer", "name", "string", "body", "text", "deleted", "boolean") VALUES ('MyString', 'MyString', 'MyString', 'MyString', 'MyString', 'MyString', 'MyString', 'MyString', 'MyString', 'MyString')
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in step' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in
block in each'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in loop' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in
each'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in map' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in
block in execute'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:95:in prepare' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in
execute'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in block in execute' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:472:in
block in log'
/usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/notifications/instrumenter.rb:20:in instrument' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:466:in
log'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in execute' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:302:in
insert_fixture'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:534:in block (5 levels) in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:533:in
each'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:533:in block (4 levels) in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:532:in
each'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:532:in block (3 levels) in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:524:in
each'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:524:in block (2 levels) in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
block in transaction'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/transaction.rb:184:in within_new_transaction' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in
transaction'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:523:in block in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:276:in
disable_referential_integrity'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:508:in create_fixtures' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/railties/databases.rake:206:in
block (3 levels) in <top (required)>'
/usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in
block in load'
/usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in
load'
-e:1:in <main>' SQLite3::ConstraintException: NOT NULL constraint failed: fan_s.created_at /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in
step'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:108:in block in each' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in
loop'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/statement.rb:107:in each' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in
map'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:152:in block in execute' /usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:95:in
prepare'
/usr/local/rvm/gems/ruby-2.3.4/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in execute' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in
block in execute'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:472:in block in log' /usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/notifications/instrumenter.rb:20:in
instrument'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:466:in log' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in
execute'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:302:in insert_fixture' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:534:in
block (5 levels) in create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:533:in each' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:533:in
block (4 levels) in create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:532:in each' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:532:in
block (3 levels) in create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:524:in each' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:524:in
block (2 levels) in create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in block in transaction' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/transaction.rb:184:in
within_new_transaction'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in transaction' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:523:in
block in create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract_adapter.rb:276:in disable_referential_integrity' /usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/fixtures.rb:508:in
create_fixtures'
/usr/local/rvm/gems/ruby-2.3.4/gems/activerecord-4.2.5/lib/active_record/railties/databases.rake:206:in block (3 levels) in <top (required)>' /usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in
load'
/usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in block in load' /usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:240:in
load_dependency'
/usr/local/rvm/gems/ruby-2.3.4/gems/activesupport-4.2.5/lib/active_support/dependencies.rb:268:in load' -e:1:in
authors_books memos schema_migrations sqlite> quit ...> ; Error: near "quit": syntax error sqlite> .quit hirokatsu: