cafe-grader-web Files · db/migrate/018_add_number_to

cafe-grader-web

Location: cafe-grader-web/db/migrate/018_add_number_to_submissions.rb

Commit Description:

fix schema for source length to 1m

Commit Description:

fix schema for source length to 1m

References:

r732:e07a92cfc790 default

File last commit:

r666:0327c11ce255 default

Show/Diff file:

Action:

            
                    db/migrate/018_add_number_to_submissions.rb
                
             | 32 lines
             | 895 B
             | text/x-ruby 
             | RubyLexer
             | 
      
            History
        
           Show Full History
         |
          Annotation
         | Raw
         |
              
              Download
              
      class AddNumberToSubmissions < ActiveRecord::Migration

        def self.up

          add_column :submissions, :number, :integer

          # add number field for all records

          Submission.reset_column_information

          last_user_id = nil

          last_problem_id = nil

          current_number = 0

          Submission.order('user_id, problem_id, submitted_at').each do |submission|

            if submission.user_id==last_user_id and submission.problem_id==last_problem_id

              current_number += 1

            else

              current_number = 1

            end

            submission.number = current_number

            submission.save

            last_user_id = submission.user_id

            last_problem_id = submission.problem_id

          end

          add_index :submissions, [:user_id, :problem_id, :number], :unique => true

        end

        def self.down

          remove_index :submissions, :column => [:user_id, :problem_id, :number]

          remove_column :submissions, :number

        end

      end

	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

Last Author

				class AddNumberToSubmissions < ActiveRecord::Migration
				def self.up
				add_column :submissions, :number, :integer

				# add number field for all records
				Submission.reset_column_information

				last_user_id = nil
				last_problem_id = nil
				current_number = 0

				Submission.order('user_id, problem_id, submitted_at').each do \|submission\|
				if submission.user_id==last_user_id and submission.problem_id==last_problem_id
				current_number += 1
				else
				current_number = 1
				end
				submission.number = current_number
				submission.save

				last_user_id = submission.user_id
				last_problem_id = submission.problem_id
				end

				add_index :submissions, [:user_id, :problem_id, :number], :unique => true
				end

				def self.down
				remove_index :submissions, :column => [:user_id, :problem_id, :number]
				remove_column :submissions, :number
				end
				end