命令行

rake db：*****

script/generate model task name:string priority:integer

script/generate migration add_description_to_task description:string

script/generate migration remove_description_from_task description:string

數(shù)據(jù)類型

引用

# :string, :text, :integer, :float,:decimal, :datetime, :timestamp, :time, :date,

# :binary, :boolean

與db有關(guān)的rake任務(wù)

db:charset 檢索當(dāng)前環(huán)境下數(shù)據(jù)庫的字符設(shè)置

db:collation 檢索當(dāng)前環(huán)境下數(shù)據(jù)庫的校對

db:create 用config\database.yml中的定義創(chuàng)建當(dāng)前 RAILS_ENV 項目環(huán)境下的數(shù)據(jù)庫

db:create:all 用config\database.yml中的定義創(chuàng)建所有數(shù)據(jù)庫

db:drop 刪除當(dāng)前 RAILS_ENV項目環(huán)境中的數(shù)據(jù)庫

db:drop:all 刪除所有在 config\database.yml中定義的數(shù)據(jù)庫

db:reset 從db\schema.rb中為當(dāng)前環(huán)境重建數(shù)據(jù)庫（先刪后建）.

db:rollback 回滾(清華出版社一本SQLSERVER書的名詞[很奇怪為什么不直接用滾回])數(shù)據(jù)庫到前一個版本. 指定回滾到哪一步要用 STEP=n 參數(shù)

db:version 檢索當(dāng)前模式下的版本

備份數(shù)據(jù)庫

rake db:backup:create 根據(jù)database.yml的信息備份數(shù)據(jù)庫

rake db:backup:destroy 默認(rèn)刪除一天前的備份數(shù)據(jù)

rake db:backup:rebuild 默認(rèn)恢復(fù)最新的備份數(shù)據(jù)

注意：這里設(shè)置的備份目錄是db的backup目錄揖膜，可以修改

添加索引

引用

add_index :acls, ["action_id","group_id"],:unique=>true

add_index :acls, :action_id

drop all tables 刪除全部表

rake db:migrate VERSION=0

指定恢復(fù)/刪除：

rake db:migrate:down/up VERSION = version_of_migrati

定義數(shù)字精確度

t.integer :total_price, :precision=>8,:scale=>2,:default=>0

========================================================================================================================================================

rake db:abort_if_pending_migrations? # Raises an error if there are pending migrations

rake db:charset? ? ? ? ? ? ? ? ? ? ? # Retrieves the charset for the current environment's database

rake db:collation? ? ? ? ? ? ? ? ? ? # Retrieves the collation for the current environment's database

rake db:create? ? ? ? ? ? ? ? ? ? ? # Create the database defined in config/database.yml for the current RAILS_ENV

rake db:create:all? ? ? ? ? ? ? ? ? # Create all the local databases defined in config/database.yml

rake db:drop? ? ? ? ? ? ? ? ? ? ? ? # Drops the database for the current RAILS_ENV

rake db:drop:all? ? ? ? ? ? ? ? ? ? # Drops all the local databases defined in config/database.yml

rake db:fixtures:identify? ? ? ? ? ? # Search for a fixture given a LABEL or ID.

rake db:fixtures:load? ? ? ? ? ? ? ? # Load fixtures into the current environment's database.

rake db:migrate? ? ? ? ? ? ? ? ? ? ? # Migrate the database through scripts in db/migrate.

rake db:migrate:down? ? ? ? ? ? ? ? # Runs the "down" for a given migration VERSION.

rake db:migrate:redo? ? ? ? ? ? ? ? # Rollbacks the database one migration and re migrate up.

rake db:migrate:reset? ? ? ? ? ? ? ? # Resets your database using your migrations for the current environment

rake db:migrate:up? ? ? ? ? ? ? ? ? # Runs the "up" for a given migration VERSION.

rake db:reset? ? ? ? ? ? ? ? ? ? ? ? # Drops and recreates the database from db/schema.rb for the current environment.

rake db:rollback? ? ? ? ? ? ? ? ? ? # Rolls the schema back to the previous version.

rake db:schema:dump? ? ? ? ? ? ? ? ? # Create a db/schema.rb file that can be portably used against any DB supported by AR

rake db:schema:load? ? ? ? ? ? ? ? ? # Load a schema.rb file into the database

rake db:sessions:clear? ? ? ? ? ? ? # Clear the sessions table

rake db:sessions:create? ? ? ? ? ? ? # Creates a sessions migration for use with CGI::Session::ActiveRecordStore

rake db:structure:dump? ? ? ? ? ? ? # Dump the database structure to a SQL file

rake db:test:clone? ? ? ? ? ? ? ? ? # Recreate the test database from the current environment's database schema

rake db:test:clone_structure? ? ? ? # Recreate the test databases from the development structure

rake db:test:load? ? ? ? ? ? ? ? ? ? # Recreate the test database from the current schema.rb

rake db:test:prepare? ? ? ? ? ? ? ? # Check for pending migrations and load the test schema

rake db:test:purge? ? ? ? ? ? ? ? ? # Empty the test database

rake db:version? ? ? ? ? ? ? ? ? ? ? # Retrieves the current schema version number

rake doc:app? ? ? ? ? ? ? ? ? ? ? ? # Build the app HTML Files

rake doc:clobber_app? ? ? ? ? ? ? ? # Remove rdoc products

rake doc:clobber_plugins? ? ? ? ? ? # Remove plugin documentation

rake doc:clobber_rails? ? ? ? ? ? ? # Remove rdoc products

rake doc:guides? ? ? ? ? ? ? ? ? ? ? # Generate Rails guides

rake doc:plugins? ? ? ? ? ? ? ? ? ? # Generate documentation for all installed plugins

rake doc:rails? ? ? ? ? ? ? ? ? ? ? # Build the rails HTML Files

rake doc:reapp? ? ? ? ? ? ? ? ? ? ? # Force a rebuild of the RDOC files

rake doc:rerails? ? ? ? ? ? ? ? ? ? # Force a rebuild of the RDOC files

rake gems? ? ? ? ? ? ? ? ? ? ? ? ? ? # List the gems that this rails application depends on

rake gems:build? ? ? ? ? ? ? ? ? ? ? # Build any native extensions for unpacked gems

rake gems:install? ? ? ? ? ? ? ? ? ? # Installs all required gems for this application.

rake gems:refresh_specs? ? ? ? ? ? ? # Regenerate gem specifications in correct format.

rake gems:unpack? ? ? ? ? ? ? ? ? ? # Unpacks the specified gem into vendor/gems.

rake gems:unpack:dependencies? ? ? ? # Unpacks the specified gems and its dependencies into vendor/gems

rake log:clear? ? ? ? ? ? ? ? ? ? ? # Truncates all *.log files in log/ to zero bytes

rake notes? ? ? ? ? ? ? ? ? ? ? ? ? # Enumerate all annotations

rake notes:custom? ? ? ? ? ? ? ? ? ? # Enumerate a custom annotation, specify with ANNOTATION=WTFHAX

rake notes:fixme? ? ? ? ? ? ? ? ? ? # Enumerate all FIXME annotations

rake notes:optimize? ? ? ? ? ? ? ? ? # Enumerate all OPTIMIZE annotations

rake notes:todo? ? ? ? ? ? ? ? ? ? ? # Enumerate all TODO annotations

rake rails:freeze:edge? ? ? ? ? ? ? # Lock to latest Edge Rails, for a specific release use RELEASE=1.2.0

rake rails:freeze:gems? ? ? ? ? ? ? # Lock this application to the current gems (by unpacking them into vendor/rails)

rake rails:unfreeze? ? ? ? ? ? ? ? ? # Unlock this application from freeze of gems or edge and return to a fluid use of system gems

rake rails:update? ? ? ? ? ? ? ? ? ? # Update both configs, scripts and public/javascripts from Rails

rake rails:update:configs? ? ? ? ? ? # Update config/boot.rb from your current rails install

rake rails:update:javascripts? ? ? ? # Update your javascripts from your current rails install

rake rails:update:scripts? ? ? ? ? ? # Add new scripts to the application script/ directory

rake routes? ? ? ? ? ? ? ? ? ? ? ? ? # Print out all defined routes in match order, with names.

rake secret? ? ? ? ? ? ? ? ? ? ? ? ? # Generate a crytographically secure secret key.

rake stats? ? ? ? ? ? ? ? ? ? ? ? ? # Report code statistics (KLOCs, etc) from the application

rake test? ? ? ? ? ? ? ? ? ? ? ? ? ? # Run all unit, functional and integration tests

rake test:benchmark? ? ? ? ? ? ? ? ? # Run tests for benchmarkdb:test:prepare / Benchmark the performance tests

rake test:functionals? ? ? ? ? ? ? ? # Run tests for functionalsdb:test:prepare / Run the functional tests in test/functional

rake test:integration? ? ? ? ? ? ? ? # Run tests for integrationdb:test:prepare / Run the integration tests in test/integration

rake test:plugins? ? ? ? ? ? ? ? ? ? # Run tests for pluginsenvironment / Run the plugin tests in vendor/plugins/*/**/test (or specify with PLUGIN=name)

rake test:profile? ? ? ? ? ? ? ? ? ? # Run tests for profiledb:test:prepare / Profile the performance tests

rake test:recent? ? ? ? ? ? ? ? ? ? # Run tests for recentdb:test:prepare / Test recent changes

rake test:uncommitted? ? ? ? ? ? ? ? # Run tests for uncommitteddb:test:prepare / Test changes since last checkin (only Subversion and Git)

rake test:units? ? ? ? ? ? ? ? ? ? ? # Run tests for unitsdb:test:prepare / Run the unit tests in test/unit

rake time:zones:all? ? ? ? ? ? ? ? ? # Displays names of all time zones recognized by the Rails TimeZone class, grouped by offset.

rake time:zones:local? ? ? ? ? ? ? ? # Displays names of time zones recognized by the Rails TimeZone class with the same offset as the system local time

rake time:zones:us? ? ? ? ? ? ? ? ? # Displays names of US time zones recognized by the Rails TimeZone class, grouped by offset.

rake tmp:cache:clear? ? ? ? ? ? ? ? # Clears all files and directories in tmp/cache

rake tmp:clear? ? ? ? ? ? ? ? ? ? ? # Clear session, cache, and socket files from tmp/

rake tmp:create? ? ? ? ? ? ? ? ? ? ? # Creates tmp directories for sessions, cache, and sockets

rake tmp:pids:clear? ? ? ? ? ? ? ? ? # Clears all files in tmp/pids

rake tmp:sessions:clear? ? ? ? ? ? ? # Clears all files in tmp/sessions

rake tmp:sockets:clear? ? ? ? ? ? ? # Clears all files in tmp/sockets