Skip to content

Instantly share code, notes, and snippets.

@carlcrott
Created November 14, 2012 23:45
Show Gist options
  • Save carlcrott/4075661 to your computer and use it in GitHub Desktop.
Save carlcrott/4075661 to your computer and use it in GitHub Desktop.
successful migration
pecan@pecan32:~/pecan$ sudo ./robs.sh
--2012-11-14 17:36:42-- http://isda.ncsa.illinois.edu/~kooper/EBI/betydump.sql
Resolving isda.ncsa.illinois.edu (isda.ncsa.illinois.edu)... 141.142.227.9
Connecting to isda.ncsa.illinois.edu (isda.ncsa.illinois.edu)|141.142.227.9|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 44965804 (43M) [text/plain]
Saving to: `betydump.sql'
100%[======================================>] 44,965,804 2.26M/s in 44s
2012-11-14 17:37:26 (993 KB/s) - `betydump.sql' saved [44965804/44965804]
WARNING: 'require 'rake/rdoctask'' is deprecated. Please use 'require 'rdoc/task' (in RDoc 2.4.2+)' instead.
at /usr/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/rdoctask.rb
DEPRECATION WARNING: Rake tasks in vendor/plugins/restful-authentication/tasks are deprecated. Use lib/tasks instead. (called from /usr/lib/ruby/gems/1.8/gems/rails-2.3.11/lib/tasks/rails.rb:10)
== AddYieldsViewExample: migrating ===========================================
-- execute(" create view yieldsview as select yields.id as yield_id, yields.citation_id, yields.site_id, sites.sitename as site, sites.lat as lat, sites.lon as lon, species.scientificname as sp, citations.author as author, citations.year as cityear, treatments.name as trt, date, month(date) as month, year(date) as year, mean, n, statname, stat, yields.notes, users.name as user, yields.checked as checked, yields.access_level as access_level, yields.user_id as user_id from yields join sites on yields.site_id = sites.id join species on yields.specie_id = species.id join citations on yields.citation_id = citations.id join treatments on yields.treatment_id = treatments.id join users on yields.user_id = users.id;\n")
-> 0.0016s
== AddYieldsViewExample: migrated (0.0020s) ==================================
== RemoveParentIdAndContainerIdFromDbfiles: migrating ========================
-- remove_column(:dbfiles, :parent_id)
-> 0.0070s
-- remove_column(:dbfiles, :container_id)
-> 0.0059s
== RemoveParentIdAndContainerIdFromDbfiles: migrated (0.0134s) ===============
== AddParentIdToPfts: migrating ==============================================
-- add_column(:pfts, :parent_id, :integer)
-> 0.0110s
== AddParentIdToPfts: migrated (0.0146s) =====================================
== AddModelTypeToModels: migrating ===========================================
-- add_column(:models, :model_type, :string)
-> 0.0061s
== AddModelTypeToModels: migrated (0.0299s) ==================================
== AddAdvancedEditToWorkflows: migrating =====================================
-- add_column(:workflows, :advanced_edit, :boolean, {:default=>false})
-> 0.0054s
== AddAdvancedEditToWorkflows: migrated (0.0057s) ============================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment