cafe-grader-web Commit - r822:f42556ce3209

Gemfile.lock ¶ +1 -1

                 yaml_db
               RUBY VERSION
                  ruby 3.1.0p0
               BUNDLED WITH
-            -    2.3.5
+            +    2.3.3

README.rdoc ¶ +12 -2

                   sudo usermod -a -G rvm $USER
               This is very important.
 . You have to reboot since RVM change a lots of system.
 . If you are using GUI version of Ubuntu, be sure to have Gnome Terminal (or any other terminal you are using) perform login every time. This can be done by mark the check box "Run command as a login shell" in Gnome terminal or by adding --login to bash.
-            - === 3. Install necessary package
+            + === 3. Install necessary package and nodejs
+            +
+            + First, we install required package via apt.
+            +
+            +     cafe@grader:~$ sudo apt install libmysqlclient-dev default-jdk unzip php-cli apache2 dirmngr gnupg apache2-dev
-            -     cafe@grader:~$ sudo apt install libmysqlclient-dev default-jdk unzip nodejs php-cli apache2 dirmngr gnupg apache2-dev
+            + Since nodejs that comes with ubuntu 18.04 is very outdated, we need to install it manually. This follow the method outlined in https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-18-04 under *Installing Node.js with Apt Using a NodeSource PPA*
+            +
+            +     cd ~
+            +     curl -sL https://deb.nodesource.com/setup_17.x -o nodesource_setup.sh
+            +     sudo bash nodesource_setup.sh
+            +     sudo apt install nodejs
+            +
               === 4. Install cafe-grader
               First, ensure that RVM is installed correctly.
                   cafe@grader:~$ rvm

db/migrate/001_create_users.rb ¶ +2 -2

-            - class CreateUsers < ActiveRecord::Migration
+            + class CreateUsers < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :users do |t|
+            +     create_table :users, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :login, :string, :limit => 10
                     t.column :full_name, :string
                     t.column :hashed_password, :string
                     t.column :salt, :string, :limit => 5
                     t.column :alias, :string
                   end

db/migrate/002_create_problems.rb ¶ +2 -2

-            - class CreateProblems < ActiveRecord::Migration
+            + class CreateProblems < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :problems do |t|
+            +     create_table :problems, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string, :limit => 30
                     t.column :full_name, :string
                     t.column :full_score, :integer
                     t.column :date_added, :date
                     t.column :available, :boolean
                   end

db/migrate/003_create_submissions.rb ¶ +2 -2

-            - class CreateSubmissions < ActiveRecord::Migration
+            + class CreateSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :submissions do |t|
+            +     create_table :submissions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :user_id, :integer
                     t.column :problem_id, :integer
                     t.column :language_id, :integer
                     t.column :source, :text
                     t.column :binary, :binary
                     t.column :submitted_at, :datetime

db/migrate/004_create_languages.rb ¶ +2 -2

-            - class CreateLanguages < ActiveRecord::Migration
+            + class CreateLanguages < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :languages do |t|
+            +     create_table :languages, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string, :limit => 10
                     t.column :pretty_name, :string
                   end
                   Language.create(:name => "c", :pretty_name => "C")
                   Language.create(:name => "cpp", :pretty_name => "C++")

db/migrate/005_add_index_to_submissions.rb ¶ +1 -1

-            - class AddIndexToSubmissions < ActiveRecord::Migration
+            + class AddIndexToSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
                   add_index :submissions, [:user_id, :problem_id]
                 end
                 def self.down
                   remove_index :submissions, :column => [:user_id, :problem_id]

db/migrate/006_create_roles.rb ¶ +3 -3

-            - class CreateRoles < ActiveRecord::Migration
+            + class CreateRoles < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :roles do |t|
+            +     create_table :roles, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'name', :string
                   end
-            -     create_table :roles_users, :id => false do |t|
+            +     create_table :roles_users, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'role_id', :integer
                     t.column 'user_id', :integer
                   end
                   add_index :roles_users, :user_id
                 end

db/migrate/007_create_rights.rb ¶ +3 -3

-            - class CreateRights < ActiveRecord::Migration
+            + class CreateRights < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :rights do |t|
+            +     create_table :rights, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'name', :string
                     t.column 'controller', :string
                     t.column 'action', :string
                   end
-            -     create_table :rights_roles, :id => false do |t|
+            +     create_table :rights_roles, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'right_id', :integer
                     t.column 'role_id', :integer
                   end
                   add_index :rights_roles, :role_id
                 end

db/migrate/008_create_tasks.rb ¶ +2 -2

-            - class CreateTasks < ActiveRecord::Migration
+            + class CreateTasks < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :tasks do |t|
+            +     create_table :tasks, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'submission_id', :integer
                     t.column 'created_at', :datetime
                   end
                 end
                 def self.down

db/migrate/009_add_sessions.rb ¶ +2 -2

-            - class AddSessions < ActiveRecord::Migration
+            + class AddSessions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :sessions do |t|
+            +     create_table :sessions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :session_id, :string
                     t.column :data, :text
                     t.column :updated_at, :datetime
                   end
                   add_index :sessions, :session_id

db/migrate/011_add_language_ext.rb ¶ +1 -1

-            - class AddLanguageExt < ActiveRecord::Migration
+            + class AddLanguageExt < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :languages, :ext, :string, :limit => 10
                   Language.reset_column_information
                   langs = Language.all
                   langs.each do |l|

db/migrate/012_add_email_to_users.rb ¶ +1 -1

-            - class AddEmailToUsers < ActiveRecord::Migration
+            + class AddEmailToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :users, :email, :string
                 end
                 def self.down
                   remove_column :users, :email

db/migrate/013_add_url_to_problem.rb ¶ +1 -1

-            - class AddUrlToProblem < ActiveRecord::Migration
+            + class AddUrlToProblem < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :url, :string
                 end
                 def self.down
                   remove_column :problems, :url

db/migrate/014_create_grader_processes.rb ¶ +2 -2

-            - class CreateGraderProcesses < ActiveRecord::Migration
+            + class CreateGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :grader_processes do |t|
+            +     create_table :grader_processes, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :ip, :string, :limit => 20
                     t.column :pid, :integer
                     t.column :mode, :string
                     t.column :active, :boolean
                     t.timestamps
                   end

db/migrate/015_add_status_to_tasks.rb ¶ +1 -1

-            - class AddStatusToTasks < ActiveRecord::Migration
+            + class AddStatusToTasks < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :tasks, :status, :integer
                   add_column :tasks, :updated_at, :datetime
                   Task.reset_column_information
                   Task.all.each do |task|

db/migrate/016_add_task_to_grader_process.rb ¶ +1 -1

-            - class AddTaskToGraderProcess < ActiveRecord::Migration
+            + class AddTaskToGraderProcess < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :grader_processes, :task_id, :integer
                 end
                 def self.down
                   remove_column :grader_processes, :task_id

db/migrate/017_rename_grader_process_column_ip_to_host.rb ¶ +1 -1

-            - class RenameGraderProcessColumnIpToHost < ActiveRecord::Migration
+            + class RenameGraderProcessColumnIpToHost < ActiveRecord::Migration[4.2]
                 def self.up
                   rename_column :grader_processes, :ip, :host
                 end
                 def self.down
                   rename_column :grader_processes, :host, :ip

db/migrate/018_add_number_to_submissions.rb ¶ +1 -1

-            - class AddNumberToSubmissions < ActiveRecord::Migration
+            + class AddNumberToSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :submissions, :number, :integer
                   # add number field for all records
                   Submission.reset_column_information

db/migrate/019_create_test_requests.rb ¶ +2 -3

-            - class CreateTestRequests < ActiveRecord::Migration
+            + class CreateTestRequests < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :test_requests do |t|
+            +     create_table :test_requests, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :user_id, :integer
                     t.column :problem_id, :integer
                     t.column :submission_id, :integer
                     t.column :input_file_name, :string
                     t.column :output_file_name, :string
                     t.column :running_stat, :string
                     # these are similar to tasks
                     t.column :status, :integer
-            -       t.column :updated_at, :datetime
                     # these are intentionally similar to submissions
                     t.column :submitted_at, :datetime
                     t.column :compiled_at, :datetime
                     t.column :compiler_message, :string
                     t.column :graded_at, :datetime

db/migrate/021_change_compiler_message_type_test_request.rb ¶ +1 -1

-            - class ChangeCompilerMessageTypeTestRequest < ActiveRecord::Migration
+            + class ChangeCompilerMessageTypeTestRequest < ActiveRecord::Migration[4.2]
                 def self.up
                   change_column :test_requests, :compiler_message, :text
                 end
                 def self.down
                   change_column :test_requests, :compiler_message, :string

db/migrate/022_create_configurations.rb ¶ +2 -2

-            - class CreateConfigurations < ActiveRecord::Migration
+            + class CreateConfigurations < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :configurations do |t|
+            +     create_table :configurations, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :key, :string
                     t.column :value_type, :string
                     t.column :value, :string
                     t.timestamps
                   end
                 end

db/migrate/023_add_runstat_columns_to_test_request.rb ¶ +1 -1

-            - class AddRunstatColumnsToTestRequest < ActiveRecord::Migration
+            + class AddRunstatColumnsToTestRequest < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :test_requests, :running_time, :float
                   add_column :test_requests, :exit_status, :string
                   add_column :test_requests, :memory_usage, :integer
                 end

db/migrate/024_create_sites.rb ¶ +2 -2

-            - class CreateSites < ActiveRecord::Migration
+            + class CreateSites < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :sites do |t|
+            +     create_table :sites, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name
                     t.boolean :started
                     t.datetime :start_time
                     t.timestamps
                   end

db/migrate/025_add_site_to_user_and_add_default_site.rb ¶ +1 -1

-            - class AddSiteToUserAndAddDefaultSite < ActiveRecord::Migration
+            + class AddSiteToUserAndAddDefaultSite < ActiveRecord::Migration[4.2]
                 def self.up
                   default_site = Site.new({:name => 'default',
                                             :started => false})
                   default_site.save!
                   add_column :users, :site_id, :integer

db/migrate/026_add_body_to_problems.rb ¶ +1 -1

-            - class AddBodyToProblems < ActiveRecord::Migration
+            + class AddBodyToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :body, :text
                 end
                 def self.down
                   remove_column :problems, :body

db/migrate/027_create_descriptions.rb ¶ +2 -2

-            - class CreateDescriptions < ActiveRecord::Migration
+            + class CreateDescriptions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :descriptions do |t|
+            +     create_table :descriptions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :body, :text
                     t.column :markdowned, :boolean
                     t.timestamps
                   end
                 end

db/migrate/028_refactor_problem_body_to_description.rb ¶ +1 -1

-            - class RefactorProblemBodyToDescription < ActiveRecord::Migration
+            + class RefactorProblemBodyToDescription < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :description_id, :integer
                   Problem.reset_column_information
                   Problem.all.each do |problem|
                     if problem.body!=nil

db/migrate/029_add_test_allowed_to_problems.rb ¶ +1 -1

-            - class AddTestAllowedToProblems < ActiveRecord::Migration
+            + class AddTestAllowedToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :test_allowed, :boolean
                   Problem.reset_column_information
                   Problem.all.each do |problem|
                     problem.test_allowed = true

db/migrate/030_create_announcements.rb ¶ +2 -2

-            - class CreateAnnouncements < ActiveRecord::Migration
+            + class CreateAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :announcements do |t|
+            +     create_table :announcements, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :author
                     t.text :body
                     t.boolean :published
                     t.timestamps
                   end

db/migrate/031_add_supports_for_output_only_problems.rb ¶ +1 -1

-            - class AddSupportsForOutputOnlyProblems < ActiveRecord::Migration
+            + class AddSupportsForOutputOnlyProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :submissions, :source_filename, :string
                   add_column :problems, :output_only, :boolean
                 end
                 def self.down

db/migrate/032_create_messages.rb ¶ +2 -2

-            - class CreateMessages < ActiveRecord::Migration
+            + class CreateMessages < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :messages do |t|
+            +     create_table :messages, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column "sender_id", :integer
                     t.column "receiver_id", :integer
                     t.column "replying_message_id", :integer
                     t.column "body", :text
                     t.column "replied", :boolean   # this is for efficiency

db/migrate/033_add_task_type_to_grader_processes.rb ¶ +1 -1

-            - class AddTaskTypeToGraderProcesses < ActiveRecord::Migration
+            + class AddTaskTypeToGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column 'grader_processes', 'task_type', :string
                 end
                 def self.down
                   remove_column 'grader_processes', 'task_type'

db/migrate/034_create_countries.rb ¶ +2 -2

-            - class CreateCountries < ActiveRecord::Migration
+            + class CreateCountries < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :countries do |t|
+            +     create_table :countries, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string
                     t.timestamps
                   end
                 end
                 def self.down

db/migrate/035_add_country_to_sites_and_users.rb ¶ +1 -1

-            - class AddCountryToSitesAndUsers < ActiveRecord::Migration
+            + class AddCountryToSitesAndUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column 'sites', 'country_id', :integer
                   add_column 'sites', 'password', :string
                   add_column 'users', 'country_id', :integer
                 end

db/migrate/20081107145815_add_frontpage_flag_to_announcement.rb ¶ +1 -1

-            - class AddFrontpageFlagToAnnouncement < ActiveRecord::Migration
+            + class AddFrontpageFlagToAnnouncement < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, "frontpage", :boolean, :default => 0
                 end
                 def self.down
                   remove_column :announcements, "frontpage"

db/migrate/20081204122651_add_activated_to_users.rb ¶ +1 -1

-            - class AddActivatedToUsers < ActiveRecord::Migration
+            + class AddActivatedToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :users, :activated, :boolean, :default => 0
                   User.reset_column_information
                   User.all.each do |user|

db/migrate/20081210021333_add_timestamps_to_users.rb ¶ +1 -1

-            - class AddTimestampsToUsers < ActiveRecord::Migration
+            + class AddTimestampsToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_timestamps :users
                 end
                 def self.down
                   remove_timestamps :users

db/migrate/20081215012843_change_user_login_string_limit.rb ¶ +1 -1

-            - class ChangeUserLoginStringLimit < ActiveRecord::Migration
+            + class ChangeUserLoginStringLimit < ActiveRecord::Migration[4.2]
                 def self.up
                   execute "ALTER TABLE `users` CHANGE `login` `login` VARCHAR( 50 )"
                 end
                 def self.down
                   # don't have to revert

db/migrate/20090206145016_add_contest_flag_to_announcements.rb ¶ +1 -1

-            - class AddContestFlagToAnnouncements < ActiveRecord::Migration
+            + class AddContestFlagToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :contest_only, :boolean, :default => false
                 end
                 def self.down
                   remove_column :announcements, :contest_only

db/migrate/20090416235658_add_common_ext_to_languages.rb ¶ +1 -1

-            - class AddCommonExtToLanguages < ActiveRecord::Migration
+            + class AddCommonExtToLanguages < ActiveRecord::Migration[4.2]
                 def self.up
                   # language.common_ext is a comma-separated list of common file
                   # extensions.
                   add_column :languages, :common_ext, :string
                   # updating table information

db/migrate/20090426131044_add_terminated_to_grader_processes.rb ¶ +1 -1

-            - class AddTerminatedToGraderProcesses < ActiveRecord::Migration
+            + class AddTerminatedToGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :grader_processes, :terminated, :boolean
                 end
                 def self.down
                   remove_column :grader_processes, :terminated

db/migrate/20090815171610_add_title_to_announcements.rb ¶ +1 -1

-            - class AddTitleToAnnouncements < ActiveRecord::Migration
+            + class AddTitleToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :title, :string
                 end
                 def self.down
                   remove_column :announcements, :title

db/migrate/20100113094740_create_test_pairs.rb ¶ +2 -2

-            - class CreateTestPairs < ActiveRecord::Migration
+            + class CreateTestPairs < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :test_pairs do |t|
+            +     create_table :test_pairs, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :problem_id
                     t.text :input
                     t.text :solution
                     t.timestamps
                   end

db/migrate/20100124040107_add_description_to_config.rb ¶ +1 -1

-            - class AddDescriptionToConfig < ActiveRecord::Migration
+            + class AddDescriptionToConfig < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :configurations, :description, :text
                 end
                 def self.down
                   remove_column :configurations, :description

db/migrate/20100124054458_create_user_contest_stats.rb ¶ +2 -2

-            - class CreateUserContestStats < ActiveRecord::Migration
+            + class CreateUserContestStats < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :user_contest_stats do |t|
+            +     create_table :user_contest_stats, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :user_id
                     t.timestamp :started_at
                     t.timestamps
                   end
                 end

db/migrate/20100129041917_change_input_solution_field_limit_in_test_pair.rb ¶ +1 -1

-            - class ChangeInputSolutionFieldLimitInTestPair < ActiveRecord::Migration
+            + class ChangeInputSolutionFieldLimitInTestPair < ActiveRecord::Migration[4.2]
                 def self.up
                   change_column :test_pairs, :input, :text, :limit => 1.megabytes
                   change_column :test_pairs, :solution, :text, :limit => 1.megabytes
                 end
                 def self.down

db/migrate/20100216105730_create_contests.rb ¶ +2 -2

-            - class CreateContests < ActiveRecord::Migration
+            + class CreateContests < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests do |t|
+            +     create_table :contests, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :title
                     t.boolean :enabled
                     t.timestamps
                   end
                 end

db/migrate/20100216162324_create_contests_users_join_table.rb ¶ +2 -2

-            - class CreateContestsUsersJoinTable < ActiveRecord::Migration
+            + class CreateContestsUsersJoinTable < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests_users, :id => false do |t|
+            +     create_table :contests_users, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :contest_id
                     t.integer :user_id
                   end
                 end
                 def self.down

db/migrate/20100216162940_create_contests_problems_join_table.rb ¶ +2 -2

-            - class CreateContestsProblemsJoinTable < ActiveRecord::Migration
+            + class CreateContestsProblemsJoinTable < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests_problems, :id => false do |t|
+            +     create_table :contests_problems, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :contest_id
                     t.integer :problem_id
                   end
                 end
                 def self.down

db/migrate/20100219014840_add_description_filename_to_problems.rb ¶ +1 -1

-            - class AddDescriptionFilenameToProblems < ActiveRecord::Migration
+            + class AddDescriptionFilenameToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :description_filename, :string
                 end
                 def self.down
                   remove_column :problems, :description_filename

db/migrate/20100303095700_add_name_to_contests.rb ¶ +1 -1

-            - class AddNameToContests < ActiveRecord::Migration
+            + class AddNameToContests < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :contests, :name, :string
                 end
                 def self.down
                   remove_column :contests, :name

db/migrate/20100328123325_add_forced_logout_to_user_contest_stat.rb ¶ +1 -1

-            - class AddForcedLogoutToUserContestStat < ActiveRecord::Migration
+            + class AddForcedLogoutToUserContestStat < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :user_contest_stats, :forced_logout, :boolean
                 end
                 def self.down
                   remove_column :user_contest_stats, :forced_logout, :boolean

db/migrate/20100506163112_add_notes_to_announcements.rb ¶ +1 -1

-            - class AddNotesToAnnouncements < ActiveRecord::Migration
+            + class AddNotesToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :notes, :string
                 end
                 def self.down
                   remove_column :announcements, :notes

db/migrate/20121001033508_rename_configurations_to_grader_configurations.rb ¶ +1 -1

-            - class RenameConfigurationsToGraderConfigurations < ActiveRecord::Migration
+            + class RenameConfigurationsToGraderConfigurations < ActiveRecord::Migration[4.2]
                 def change
                   rename_table 'configurations', 'grader_configurations'
                 end
               end

db/migrate/20140823031747_add_more_detail_to_submission.rb ¶ +1 -1

-            - class AddMoreDetailToSubmission < ActiveRecord::Migration
+            + class AddMoreDetailToSubmission < ActiveRecord::Migration[4.2]
                 def change
                   add_column :submissions, :max_runtime, :float
                   add_column :submissions, :peak_memory, :integer
                   add_column :submissions, :effective_code_length, :integer
                 end
               end

db/migrate/20140826095949_create_logins.rb ¶ +2 -2

-            - class CreateLogins < ActiveRecord::Migration
+            + class CreateLogins < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :logins do |t|
+            +     create_table :logins, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :user_id
                     t.string :ip_address
                     t.timestamps
                   end
                 end

db/migrate/20140913060729_add_section_to_users.rb ¶ +1 -1

-            - class AddSectionToUsers < ActiveRecord::Migration
+            + class AddSectionToUsers < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :section, :string
                 end
               end

db/migrate/20140917150629_add_ip_to_submissions.rb ¶ +1 -1

-            - class AddIpToSubmissions < ActiveRecord::Migration
+            + class AddIpToSubmissions < ActiveRecord::Migration[4.2]
                 def change
                   add_column :submissions, :ip_address, :string
                 end
               end

db/migrate/20150203153534_add_more_to_users.rb ¶ +1 -1

-            - class AddMoreToUsers < ActiveRecord::Migration
+            + class AddMoreToUsers < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :enabled, :boolean, default: 1
                   add_column :users, :remark, :string
                 end
               end

db/migrate/20150503164846_change_userid_on_login.rb ¶ +1 -1

-            - class ChangeUseridOnLogin < ActiveRecord::Migration
+            + class ChangeUseridOnLogin < ActiveRecord::Migration[4.2]
                 def up
                   change_column :logins, :user_id, :integer
                 end
                 def down
                   change_column :logins, :user_id, :string

db/migrate/20150827131927_create_submission_view_logs.rb ¶ +2 -2

-            - class CreateSubmissionViewLogs < ActiveRecord::Migration
+            + class CreateSubmissionViewLogs < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :submission_view_logs do |t|
+            +     create_table :submission_view_logs, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :user_id
                     t.integer :submission_id
                     t.timestamps
                   end
                 end

db/migrate/20150827133841_add_last_ip_to_user.rb ¶ +1 -1

-            - class AddLastIpToUser < ActiveRecord::Migration
+            + class AddLastIpToUser < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :last_ip, :string
                 end
               end

db/migrate/20150914090545_create_heart_beats.rb ¶ +2 -2

-            - class CreateHeartBeats < ActiveRecord::Migration
+            + class CreateHeartBeats < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :heart_beats do |t|
+            +     create_table :heart_beats, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'user_id',:integer
                     t.column 'ip_address',:string
                     t.timestamps
                   end
                 end

db/migrate/20150914155101_add_status_to_heart_beat.rb ¶ +1 -1

-            - class AddStatusToHeartBeat < ActiveRecord::Migration
+            + class AddStatusToHeartBeat < ActiveRecord::Migration[4.2]
                 def change
                   add_column :heart_beats, :status, :string
                 end
               end

db/migrate/20150914223258_add_more_config.rb ¶ +1 -1

-            - class AddMoreConfig < ActiveRecord::Migration
+            + class AddMoreConfig < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.bypass_agreement', value_type: 'boolean', value:'true', description:'When false, a check box to accept license agreement appear at login and the user must click accept'
                 end
                 def down

db/migrate/20150916054105_update_heart_beat.rb ¶ +1 -1

-            - class UpdateHeartBeat < ActiveRecord::Migration
+            + class UpdateHeartBeat < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.heartbeat_response', value_type: 'string', value:'OK', description:'Heart beat response text'
                   add_index :heart_beats, :updated_at
                 end
                 def down

db/migrate/20161008050135_modify_grader_process.rb ¶ +1 -1

-            - class ModifyGraderProcess < ActiveRecord::Migration
+            + class ModifyGraderProcess < ActiveRecord::Migration[4.2]
                 def up
                   change_column :grader_processes, :host, :string
                 end
                 def down
                   change_column :grader_processes, :host, :string, limit: 20

db/migrate/20161014091417_create_testcases.rb ¶ +2 -2

-            - class CreateTestcases < ActiveRecord::Migration
+            + class CreateTestcases < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :testcases do |t|
+            +     create_table :testcases, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.references :problem
                     t.integer :num
                     t.integer :group
                     t.integer :score
                     t.text :input
                     t.text :sol

db/migrate/20161031063337_add_config_view_test.rb ¶ +1 -1

-            - class AddConfigViewTest < ActiveRecord::Migration
+            + class AddConfigViewTest < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.view_testcase', value_type: 'boolean', value:'true', description:'When true, any user can view/download test data'
                   #uglily and dirtily and shamelessly check other config and inifialize
                   GraderConfiguration.where(key: 'right.user_hall_of_fame').first_or_create(value_type: 'boolean', value: 'false',
                                                                                             description: 'If true, any user can access hall of fame page.')
                   GraderConfiguration.where(key: 'right.multiple_ip_login').first_or_create(value_type: 'boolean', value: 'false',

db/migrate/20170123162543_change_testcase_size.rb ¶ +1 -1

-            - class ChangeTestcaseSize < ActiveRecord::Migration
+            + class ChangeTestcaseSize < ActiveRecord::Migration[4.2]
                 def change
                   change_column :testcases, :input, :text, :limit => 4294967295
                   change_column :testcases, :sol, :text, :limit => 4294967295
                 end
               end

db/migrate/20170124024527_add_view_testcase_to_problem.rb ¶ +1 -1

-            - class AddViewTestcaseToProblem < ActiveRecord::Migration
+            + class AddViewTestcaseToProblem < ActiveRecord::Migration[4.2]
                 def change
                   add_column :problems, :view_testcase, :bool
                 end
               end

db/migrate/20170310110146_add_index_to_task.rb ¶ +1 -1

-            - class AddIndexToTask < ActiveRecord::Migration
+            + class AddIndexToTask < ActiveRecord::Migration[4.2]
                 def change
                   add_index :tasks, :submission_id
                 end
               end

db/migrate/20170427070345_add_heart_beat_full.rb ¶ +1 -1

-            - class AddHeartBeatFull < ActiveRecord::Migration
+            + class AddHeartBeatFull < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.heartbeat_response_full', value_type: 'string', value:'RESTART', description:'Heart beat response text when user got full score (set this value to the empty string to disable this feature)'
                 end
                 def down

db/migrate/20170911091143_create_groups.rb ¶ +4 -4

-            - class CreateGroups < ActiveRecord::Migration
+            + class CreateGroups < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :groups do |t|
+            +     create_table :groups, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name
                     t.string :description
                   end
-            -     create_join_table :groups, :users do |t|
+            +     create_join_table :groups, :users, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     # t.index [:group_id, :user_id]
                     t.index [:user_id, :group_id]
                   end
-            -     create_join_table :problems, :groups do |t|
+            +     create_join_table :problems, :groups, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     # t.index [:problem_id, :group_id]
                     t.index [:group_id, :problem_id]
                   end
                   reversible do |change|
                     change.up do

db/migrate/20170914150545_create_tags.rb ¶ +2 -2

-            - class CreateTags < ActiveRecord::Migration
+            + class CreateTags < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :tags do |t|
+            +     create_table :tags, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name, null: false
                     t.text :description
                     t.boolean :public
                     t.timestamps null: false
                   end

db/migrate/20170914150742_create_problem_tags.rb ¶ +2 -2

-            - class CreateProblemTags < ActiveRecord::Migration
+            + class CreateProblemTags < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :problems_tags do |t|
+            +     create_table :problems_tags, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.references :problem, index: true, foreign_key: true
                     t.references :tag, index: true, foreign_key: true
                     t.index [:problem_id,:tag_id], unique: true
                   end
                 end

Sign in to your account

Author

r822:f42556ce3209 - Sat, 15 Jan 2022 14:03:59 - 77 files changed: 120 inserted, 111 deleted

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository permissions settings

Sign in to your account

Commit r822:f42556ce3209 public

Author

r822:f42556ce3209 - Sat, 15 Jan 2022 14:03:59 - 77 files changed: 120 inserted, 111 deleted

Commit `r822:f42556ce3209` public