Skip to content

マイグレーション

飯野博勝 edited this page Sep 17, 2017 · 1 revision

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

' Tasks: TOP => db:fixtures:load (See full trace by running task with --trace) hirokatsu:/workspace (master) $ hirokatsu:/workspace (master) $ rails dbconsole SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables authors fan_s reviews users
authors_books memos schema_migrations sqlite> quit ...> ; Error: near "quit": syntax error sqlite> .quit hirokatsu:
/workspace (master) $
Clone this wiki locally