cafe-grader-web Commit - r854:14d6c4fb29b0

cafe-grader-web

Commit `r854:14d6c4fb29b0` public

parent | child

Description:

add model solution

Commit status:

[Not Reviewed]

References:

default

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r854:14d6c4fb29b0 - Fri, 04 Feb 2022 15:55:30 - 12 files changed: 225 inserted, 138 deleted

db/migrate/20220204080936_add_type_to_submission.rb created 644 ¶ +6

@@ -0,0 +1,6
	1	+ class AddTypeToSubmission < ActiveRecord::Migration[7.0]
	2	+ def change
	3	+ add_column :submissions, :tag, :integer, default: 0
	4	+ add_column :problems, :difficulty, :integer
	5	+ end
	6	+ end

app/controllers/application_controller.rb ¶ +11

                     unauthorized_redirect
                     return false
                   end
                   return true
                 end
+            +   #admin always count as every roles
+            +   def role_authorization(roles)
+            +     return false unless check_valid_login
+            +     user = User.find(session[:user_id])
+            +     return true if user.admin?
+            +     roles.each do |r|
+            +       return true if user.has_role?(r)
+            +     end
+            +     unauthorized_redirect
+            +   end
+            +
                 def authorization_by_roles(allowed_roles)
                   return false unless check_valid_login
                   unless @current_user.roles.detect { |role| allowed_roles.member?(role.name) }
                     unauthorized_redirect
                     return false
                   end

app/controllers/main_controller.rb ¶ +1 -1

                     @submission.source = params[:editor_text]
                     @submission.source_filename = "live_edit.#{language.ext}"
                     @submission.language = language
                   end
                   @submission.submitted_at = Time.new.gmtime
-            -     @submission.ip_address = request.remote_ip
+            +     @submission.ip_address = cookies.encrypted[:uuid]
                   if @current_user.admin? == false && GraderConfiguration.time_limit_mode? && @current_user.contest_finished?
                     @submission.errors.add(:base,"The contest is over.")
                     prepare_list_information
                     render :action => 'list' and return
                   end

app/controllers/report_controller.rb ¶ +12 -3

                       return
                     end
                   end
                   return unless @problem
+            +     #model submisssion
+            +     @model_subs = Submission.where(problem: @problem,tag: Submission.tags[:model])
+            +
+            +
+            +     #calculate best submission
                   @by_lang = {} #aggregrate by language
                   range =65
-            -     @histogram = { data: Array.new(range,0), summary: {} }
+            +     #@histogram = { data: Array.new(range,0), summary: {} }
                   @summary = {count: 0, solve: 0, attempt: 0}
                   user = Hash.new(0)
                   Submission.where(problem_id: @problem.id).find_each do |sub|
                     #histogram
                     d = (DateTime.now.in_time_zone - sub.submitted_at) / 24 / 60 / 60
-            -       @histogram[:data][d.to_i] += 1 if d < range
+            +       #@histogram[:data][d.to_i] += 1 if d < range
                     next unless sub.points
                     @summary[:count] += 1
                     user[sub.user_id] = [user[sub.user_id], (sub.points >= @problem.full_score) ? 1 : 0].max
                     lang = Language.find_by_id(sub.language_id)
                         @best[:first] = prop[:first]
                         @best[:first][:lang] = lang
                       end
                     end
                   end
-            -     @histogram[:summary][:max] = [@histogram[:data].max,1].max
+            +     #@histogram[:summary][:max] = [@histogram[:data].max,1].max
                   @summary[:attempt] = user.count
                   user.each_value { |v| @summary[:solve] += 1 if v == 1 }
+            +
+            +
+            +     #for new graph
+            +     @chart_dataset = @problem.get_jschart_history.to_json.html_safe
                 end
                 def stuck #report struggling user,problem
                   # init
                   user,problem = nil
                   solve = true

app/controllers/submissions_controller.rb ¶ +11 -7

               class SubmissionsController < ApplicationController
+            +   before_action :set_submission, only: [:show,:download,:compiler_msg,:rejudge,:set_tag, :edit]
                 before_action :check_valid_login
                 before_action :submission_authorization, only: [:show, :download, :edit]
-            -   before_action :admin_authorization, only: [:rejudge]
+            +   before_action only: [:rejudge, :set_tag] do role_authorization([:ta]) end
                 # GET /submissions
                 # GET /submissions.json
                 # Show problem selection and user's submission of that problem
                 def index
                   @user = @current_user
                   end
                 end
                 # GET /submissions/1
                 # GET /submissions/1.json
                 def show
-            -     @submission = Submission.find(params[:id])
                   #log the viewing
                   user = User.find(session[:user_id])
                   SubmissionViewLog.create(user_id: session[:user_id],submission_id: @submission.id) unless user.admin?
                   @task = @submission.task
                 end
                 def download
-            -     @submission = Submission.find(params[:id])
                   send_data(@submission.source, {:filename => @submission.download_filename, :type => 'text/plain'})
                 end
                 def compiler_msg
-            -     @submission = Submission.find(params[:id])
                   respond_to do |format|
                     format.js
                   end
                 end
                 #on-site new submission on specific problem
                   end
                   render 'edit'
                 end
                 # GET /submissions/1/edit
                 def edit
-            -     @submission = Submission.find(params[:id])
                   @source = @submission.source.to_s
                   @problem = @submission.problem
                   @lang_id = @submission.language.id
                 end
                     format.js
                   end
                 end
                 # GET /submissions/:id/rejudge
                 def rejudge
-            -     @submission = Submission.find(params[:id])
                   @task = @submission.task
                   @task.status_inqueue! if @task
                   respond_to do |format|
                     format.js
                   end
                 end
+            +   def set_tag
+            +     @submission.update(tag: params[:tag])
+            +     redirect_to @submission
+            +   end
+            +
               protected
                 def submission_authorization
                   #admin always has privileged
                   return true if @current_user.admin?
                   return true if @current_user.has_role?('ta') && (['show','download'].include? action_name)
                   #default to NO
                   unauthorized_redirect
                   return false
                 end
+            +   def set_submission
+            +     @submission = Submission.find(params[:id])
+            +   end
+            +
               end

app/models/problem.rb ¶ +22

@@ -21,12 +21,34
21		21
22	scope :available, -> { where(available: true) }	22	scope :available, -> { where(available: true) }
23		23
24	DEFAULT_TIME_LIMIT = 1	24	DEFAULT_TIME_LIMIT = 1
25	DEFAULT_MEMORY_LIMIT = 32	25	DEFAULT_MEMORY_LIMIT = 32
26		26
		27	+ def get_jschart_history
		28	+ start = 4.month.ago.beginning_of_day
		29	+ start_date = start.to_date
		30	+ count = Submission.where(problem: self).where('submitted_at >= ?', start).group('DATE(submitted_at)').count
		31	+ i = 0
		32	+ label = []
		33	+ value = []
		34	+ while (start_date + i < Time.zone.now.to_date)
		35	+ if (start_date+i).day == 1
		36	+ #label << (start_date+i).strftime("%d %b %Y")
		37	+ #label << (start_date+i).strftime("%d")
		38	+ else
		39	+ #label << ' '
		40	+ #label << (start_date+i).strftime("%d")
		41	+ end
		42	+ label << (start_date+i).strftime("%d-%b")
		43	+ value << (count[start_date+i] \|\| 0)
		44	+ i+=1
		45	+ end
		46	+ return {labels: label,datasets: [label:'sub',data: value, backgroundColor: 'rgba(54, 162, 235, 0.2)', borderColor: 'rgb(75, 192, 192)']}
		47	+ end
		48	+
27	def self.available_problems	49	def self.available_problems
28	available.order(date_added: :desc).order(:name)	50	available.order(date_added: :desc).order(:name)
29	#Problem.available.all(:order => "date_added DESC, name ASC")	51	#Problem.available.all(:order => "date_added DESC, name ASC")
30	end	52	end
31		53
32	def self.create_from_import_form_params(params, old_problem=nil)	54	def self.create_from_import_form_params(params, old_problem=nil)

app/models/submission.rb ¶ +2

               class Submission < ActiveRecord::Base
+            +   enum tag: {default: 0, model: 1}, _prefix: true
+            +
                 belongs_to :language
                 belongs_to :problem
                 belongs_to :user
                 before_validation :assign_problem
                 before_validation :assign_language

app/views/report/_task_hof.html.haml ¶ +85 -67

@@ -21,97 +21,97
21	word-wrap: break-word;	21	word-wrap: break-word;
22	z-index: 9999;	22	z-index: 9999;
23	overflow: auto;	23	overflow: auto;
24	}	24	}
25		25
26		26
27	- .container	27	+ .container-fluid
		28	+ .row
		29	+ .col-md-8
		30	+ .card
		31	+ .card-body
		32	+ %h2.card-title Submission History
		33	+ %canvas#chart{height: '50px'}
		34	+
		35	+ .col-md-4
		36	+ .card
		37	+ .card-body
		38	+ %h2.card-title General Info
		39	+ .row
		40	+ .col-sm-6
		41	+ Subs
		42	+ .col-sm-6
		43	+ = @summary[:count]
		44	+ .row
		45	+ .col-sm-6
		46	+ Solved/Attempted User
		47	+ .col-sm-6
		48	+ #{@summary[:solve]}/#{@summary[:attempt]} (#{(@summary[:solve]*100.0/@summary[:attempt]).round(1)}%)
28	.row	49	.row
29	.col-md-4	50	.col-md-4
30	- %h2 Overall Stat	51	+ .card
		52	+ .card-body
		53	+ %h2.card-title Model submission
31	%table.table.table-hover	54	%table.table.table-hover
32	%thead	55	%thead
33	%tr	56	%tr
34	- %th	57	+ %th #Sub
35	- %th	58	+ %th Author
36	%tbody	59	%tbody
37	- %tr	60	+ - @model_subs.each do \|sub\|
38	- %td.info_param Submissions
39	- %td= @summary[:count]
40	- %tr
41	- %td.info_param Solved/Attempted User
42	- %td #{@summary[:solve]}/#{@summary[:attempt]} (#{(@summary[:solve]*100.0/@summary[:attempt]).round(1)}%)
43	- - if @best
44	- %tr
45	- %td.info_param Best Runtime
46	- %td
47	- by #{link_to @best[:runtime][:user], stat_user_path(@best[:runtime][:user_id])}
48	- %br
49	- using <span class="text-success">#{@best[:runtime][:lang]}</span>
50	- %br
51	- with <span class="text-success">#{@best[:runtime][:value] * 1000} milliseconds</span>
52	- %br
53	- at submission
54	- = link_to "#" + @best[:runtime][:sub_id].to_s, submission_path(@best[:runtime][:sub_id])
55	-
56	%tr	61	%tr
57	- %td.info_param	62	+ %td= link_to "##{sub.id}", submission_path(sub)
58	- Best Memory Usage	63	+ %td= sub.user.full_name
59	- %sup{ id: "xmem_remark",
60	- style: "position:relative; color: blue;",
61	- data: {toggle: 'tooltip', placement: 'top', animation: 'false', delay: 20},
62	- title: "This counts only for submission with 100% score. Right now, java is excluded from memory usage competition. (Because it always uses 2GB memory...)"}
63	- [?]
64	- %td
65	- by #{link_to @best[:memory][:user], stat_user_path(@best[:memory][:user_id])}
66	- %br
67	- using <span class="text-success">#{@best[:memory][:lang]}</span>
68	- %br
69	- with <span class="text-success">#{number_with_delimiter(@best[:memory][:value])} kbytes </span>
70	- %br
71	- at submission
72	- = link_to "#" + @best[:memory][:sub_id].to_s, submission_path(@best[:memory][:sub_id])
73	-
74	- %tr
75	- %td.info_param Shortest Code
76	- %td
77	- by #{link_to @best[:length][:user], stat_user_path(@best[:length][:user_id])}
78	- %br
79	- using <span class="text-success">#{@best[:length][:lang]}</span>
80	- %br
81	- with <span class="text-success">#{@best[:length][:value]} bytes</span>
82	- %br
83	- at submission
84	- = link_to "#" + @best[:length][:sub_id].to_s, submission_path(@best[:length][:sub_id])
85	-
86	- %tr
87	- %td.info_param First solver
88	- %td
89	- - if @best[:first][:user] != '(NULL)'
90	- #{link_to @best[:first][:user], stat_user_path(@best[:first][:user_id])} is the first solver
91	- %br
92	- using <span class="text-success">#{@best[:first][:lang]}</span>
93	- %br
94	- on <span class="text-success">#{@best[:first][:value]}</span>
95	- %br
96	- at submission
97	- = link_to "#" + @best[:first][:sub_id].to_s, submission_path( @best[:first][:sub_id])
98	- - else
99	- no first solver
100	.col-md-8	64	.col-md-8
101	- if @best	65	- if @best
102	- %h2 By Language	66	+ .card
		67	+ .card-body
		68	+ %h2.card-title Top Submissions
103	%table.table.table-hover	69	%table.table.table-hover
104	%thead	70	%thead
105	%tr	71	%tr
106	%th Language	72	%th Language
107	%th Best runtime (ms)	73	%th Best runtime (ms)
108	%th Best memory (kbytes)	74	%th Best memory (kbytes)
109	%th Shortest Code (bytes)	75	%th Shortest Code (bytes)
110	%th First solver	76	%th First solver
111	%tbody	77	%tbody
		78	+ %tr.bg-warning
		79	+ %td
		80	+ Overall
		81	+ %td
		82	+ by #{link_to @best[:runtime][:user], stat_user_path(@best[:runtime][:user_id])}
		83	+ %br
		84	+ using <span class="text-success">#{@best[:runtime][:lang]}</span>
		85	+ %br
		86	+ with <span class="text-success">#{@best[:runtime][:value] * 1000} milliseconds</span>
		87	+ %br= link_to "#" + @best[:runtime][:sub_id].to_s, submission_path(@best[:runtime][:sub_id])
		88	+ %td
		89	+ by #{link_to @best[:memory][:user], stat_user_path(@best[:memory][:user_id])}
		90	+ %br
		91	+ using <span class="text-success">#{@best[:memory][:lang]}</span>
		92	+ %br
		93	+ with <span class="text-success">#{number_with_delimiter(@best[:memory][:value])} kbytes </span>
		94	+ %br= link_to "#" + @best[:memory][:sub_id].to_s, submission_path(@best[:memory][:sub_id])
		95	+ %td
		96	+ by #{link_to @best[:length][:user], stat_user_path(@best[:length][:user_id])}
		97	+ %br
		98	+ using <span class="text-success">#{@best[:length][:lang]}</span>
		99	+ %br
		100	+ with <span class="text-success">#{@best[:length][:value]} bytes</span>
		101	+ %br= link_to "#" + @best[:length][:sub_id].to_s, submission_path(@best[:length][:sub_id])
		102	+ %td
		103	+ - if @best[:first][:user] != '(NULL)'
		104	+ #{link_to @best[:first][:user], stat_user_path(@best[:first][:user_id])} is the first solver
		105	+ %br
		106	+ using <span class="text-success">#{@best[:first][:lang]}</span>
		107	+ %br
		108	+ on <span class="text-success">#{@best[:first][:value]}</span>
		109	+ %br= link_to "#" + @best[:first][:sub_id].to_s, submission_path( @best[:first][:sub_id])
		110	+ - else
		111	+ no first solver
112	- @by_lang.each do \|lang,value\|	112	- @by_lang.each do \|lang,value\|
113	%tr	113	%tr
114	%td= lang	114	%td= lang
115	%td	115	%td
116	= link_to value[:runtime][:user], stat_user_path(value[:runtime][:user_id])	116	= link_to value[:runtime][:user], stat_user_path(value[:runtime][:user_id])
117	%br	117	%br
@@ -131,6 +131,24
131	- if value[:first][:user] != '(NULL)' #TODO: i know... this is wrong...	131	- if value[:first][:user] != '(NULL)' #TODO: i know... this is wrong...
132	= link_to value[:first][:user], stat_user_path(value[:first][:user_id])	132	= link_to value[:first][:user], stat_user_path(value[:first][:user_id])
133	%br	133	%br
134	= "#{value[:first][:value]} @"	134	= "#{value[:first][:value]} @"
135	= link_to "#" + value[:first][:sub_id].to_s, submission_path( value[:first][:sub_id])	135	= link_to "#" + value[:first][:sub_id].to_s, submission_path( value[:first][:sub_id])
136		136
		137	+ %script{src:"https://cdn.jsdelivr.net/npm/chart.js"}
		138	+ :javascript
		139	+ data = #{@chart_dataset}
		140	+ config = {
		141	+ type: 'bar',
		142	+ data: data,
		143	+ options: {
		144	+ plugins: {
		145	+ legend: {
		146	+ display: false
		147	+ },
		148	+ },
		149	+ }
		150	+ }
		151	+ Chart.defaults.font.size = 15
		152	+ //Chart.defaults.font.family = 'Sarabun Light'
		153	+ chart = new Chart($('#chart'),config)
		154	+

app/views/report/problem_hof.html.haml ¶ +2 -2

               - unless params[:id]
                 /=render partial: 'all_time_hof'
                 Please select a problem.
               - else
                 %h1 [#{Problem.find(params[:id]).name}] #{Problem.find(params[:id]).full_name}
-            -   %h2 Submission History
+            +   -# %h2 Submission History
-            -   =render partial: 'application/bar_graph', locals: { histogram: @histogram }
+            +   -# =render partial: 'application/bar_graph', locals: { histogram: @histogram }
                 =render partial: 'task_hof'

app/views/submissions/show.html.haml ¶ +15 -3

                       %tr
                         %td.text-right
                           %strong Compiler result
                         %td
                           %button.btn.btn-info.btn-xs{type: 'button', data: {toggle: 'modal', target: '#compiler'}}
                             view
+            +         %tr
+            +           %td.text-right
+            +             %strong Grading Task Status
+            +           %td
+            +             = @task.status_str if @task
+            +             - if session[:admin]
+            +               = link_to "rejudge", rejudge_submission_path, data: {remote: true}, class: 'btn btn-info btn-xs'
                       - if session[:admin]
                         %tr
                           %td.text-right
                             %strong IP
                           %td #{@submission.ip_address}
                         %tr
                           %td.text-right
-            -             %strong Grading Task Status
+            +               %strong Model solution
                           %td
-            -             = @task.status_str if @task
+            +               - if @submission.tag_model?
+            +                 YES
                               - if session[:admin]
-            -               = link_to "rejudge", rejudge_submission_path, data: {remote: true}, class: 'btn btn-info btn-xs'
+            +                   = link_to "remove model status", set_tag_submission_path(@submission, tag: :default), class: 'btn btn-warning btn-xs'
+            +               - else
+            +                 No
+            +                 - if session[:admin]
+            +                   = link_to "set as model solution", set_tag_submission_path(@submission, tag: :model), class: 'btn btn-success btn-xs'
               .modal.fade#compiler{tabindex: -1,role: 'dialog'}
                 .modal-dialog.modal-lg{role:'document'}
                   .modal-content
                     .modal-header

config/routes.rb ¶ +1

                 resources :submissions do
                   member do
                     get 'download'
                     get 'compiler_msg'
                     get 'rejudge'
+            +       get 'set_tag'
                   end
                   collection do
                     get 'prob/:problem_id', to: 'submissions#index', as: 'problem'
                     get 'direct_edit_problem/:problem_id(/:user_id)', to: 'submissions#direct_edit_problem', as: 'direct_edit_problem'
                     get 'get_latest_submission_status/:uid/:pid', to: 'submissions#get_latest_submission_status', as: 'get_latest_submission_status'
                   end

db/schema.rb ¶ +57 -55

               # This file is auto-generated from the current state of the database. Instead
               # of editing this file, please use the migrations feature of Active Record to
               # incrementally modify your database, and then regenerate this schema definition.
               #
-            - # Note that this schema.rb definition is the authoritative source for your
+            + # This file is the source Rails uses to define your schema when running `bin/rails
-            - # database schema. If you need to create the application database on another
+            + # db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
-            - # system, you should be using db:schema:load, not running all the migrations
+            + # be faster and is potentially less error prone than running all of your
-            - # from scratch. The latter is a flawed and unsustainable approach (the more migrations
+            + # migrations from scratch. Old migrations may fail to apply correctly if those
-            - # you'll amass, the slower it'll run and the greater likelihood for issues).
+            + # migrations use external dependencies or application code.
               #
               # It's strongly recommended that you check this file into your version control system.
-            - ActiveRecord::Schema.define(version: 2021_08_09_105935) do
+            + ActiveRecord::Schema.define(version: 2022_02_04_080936) do
-            -   create_table "announcements", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "announcements", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "author"
-            -     t.text "body", limit: 16777215
+            +     t.text "body"
                   t.boolean "published"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.boolean "frontpage", default: false
                   t.boolean "contest_only", default: false
                   t.string "title"
                   t.string "notes"
                   t.boolean "on_nav_bar", default: false
                 end
-            -   create_table "contests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "contests", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "title"
                   t.boolean "enabled"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.string "name"
                 end
-            -   create_table "contests_problems", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "contests_problems", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "contest_id"
                   t.integer "problem_id"
                 end
-            -   create_table "contests_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "contests_users", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "contest_id"
                   t.integer "user_id"
                 end
-            -   create_table "countries", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "countries", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "name"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "descriptions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "descriptions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
-            -     t.text "body", limit: 16777215
+            +     t.text "body"
                   t.boolean "markdowned"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "grader_configurations", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "grader_configurations", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "key"
                   t.string "value_type"
                   t.string "value"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
-            -     t.text "description", limit: 16777215
+            +     t.text "description"
                 end
-            -   create_table "grader_processes", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "grader_processes", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "host"
                   t.integer "pid"
                   t.string "mode"
                   t.boolean "active"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.integer "task_id"
                   t.string "task_type"
                   t.boolean "terminated"
                   t.index ["host", "pid"], name: "index_grader_processes_on_ip_and_pid"
                 end
-            -   create_table "groups", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "groups", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.string "name"
                   t.string "description"
                   t.boolean "enabled", default: true
                 end
-            -   create_table "groups_problems", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "groups_problems", id: false, charset: "latin1", force: :cascade do |t|
                   t.integer "problem_id", null: false
                   t.integer "group_id", null: false
                   t.index ["group_id", "problem_id"], name: "index_groups_problems_on_group_id_and_problem_id"
                 end
-            -   create_table "groups_users", options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "groups_users", charset: "latin1", force: :cascade do |t|
                   t.integer "group_id", null: false
                   t.integer "user_id", null: false
                   t.index ["user_id", "group_id"], name: "index_groups_users_on_user_id_and_group_id"
                 end
-            -   create_table "heart_beats", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "heart_beats", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.string "ip_address"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.string "status"
                   t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
                 end
-            -   create_table "languages", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "languages", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "name", limit: 10
                   t.string "pretty_name"
                   t.string "ext", limit: 10
                   t.string "common_ext"
                 end
-            -   create_table "logins", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "logins", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.string "ip_address"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.index ["user_id"], name: "index_logins_on_user_id"
                 end
-            -   create_table "messages", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "messages", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "sender_id"
                   t.integer "receiver_id"
                   t.integer "replying_message_id"
-            -     t.text "body", limit: 16777215
+            +     t.text "body"
                   t.boolean "replied"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "problems", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "problems", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
-            -     t.string "name", limit: 100
+            +     t.string "name", limit: 30
                   t.string "full_name"
                   t.integer "full_score"
                   t.date "date_added"
                   t.boolean "available"
                   t.string "url"
                   t.integer "description_id"
                   t.boolean "test_allowed"
                   t.boolean "output_only"
                   t.string "description_filename"
                   t.boolean "view_testcase"
+            +     t.integer "difficulty"
                 end
-            -   create_table "problems_tags", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "problems_tags", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.integer "problem_id"
                   t.integer "tag_id"
                   t.index ["problem_id", "tag_id"], name: "index_problems_tags_on_problem_id_and_tag_id", unique: true
                   t.index ["problem_id"], name: "index_problems_tags_on_problem_id"
                   t.index ["tag_id"], name: "index_problems_tags_on_tag_id"
                 end
-            -   create_table "rights", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "rights", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "name"
                   t.string "controller"
                   t.string "action"
                 end
-            -   create_table "rights_roles", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "rights_roles", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "right_id"
                   t.integer "role_id"
                   t.index ["role_id"], name: "index_rights_roles_on_role_id"
                 end
-            -   create_table "roles", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "roles", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "name"
                 end
-            -   create_table "roles_users", id: false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "roles_users", id: false, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "role_id"
                   t.integer "user_id"
                   t.index ["user_id"], name: "index_roles_users_on_user_id"
                 end
-            -   create_table "sessions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "sessions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "session_id"
-            -     t.text "data", limit: 16777215
+            +     t.text "data"
                   t.datetime "updated_at"
                   t.index ["session_id"], name: "index_sessions_on_session_id"
                   t.index ["updated_at"], name: "index_sessions_on_updated_at"
                 end
-            -   create_table "sites", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "sites", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "name"
                   t.boolean "started"
                   t.datetime "start_time"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.integer "country_id"
                   t.string "password"
                 end
-            -   create_table "submission_view_logs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "submission_view_logs", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.integer "submission_id"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "submissions", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "submissions", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.integer "problem_id"
                   t.integer "language_id"
-            -     t.text "source", limit: 16777215
+            +     t.text "source", size: :medium
                   t.binary "binary"
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text "compiler_message", limit: 16777215
+            +     t.text "compiler_message"
                   t.datetime "graded_at"
                   t.integer "points"
-            -     t.text "grader_comment", limit: 16777215
+            +     t.text "grader_comment"
                   t.integer "number"
                   t.string "source_filename"
                   t.float "max_runtime"
                   t.integer "peak_memory"
                   t.integer "effective_code_length"
                   t.string "ip_address"
+            +     t.integer "tag", default: 0
                   t.index ["submitted_at"], name: "index_submissions_on_submitted_at"
                   t.index ["user_id", "problem_id", "number"], name: "index_submissions_on_user_id_and_problem_id_and_number", unique: true
                   t.index ["user_id", "problem_id"], name: "index_submissions_on_user_id_and_problem_id"
                 end
-            -   create_table "tags", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "tags", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.string "name", null: false
                   t.text "description"
                   t.boolean "public"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "tasks", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "tasks", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "submission_id"
                   t.datetime "created_at"
                   t.integer "status"
                   t.datetime "updated_at"
                   t.index ["status"], name: "index_tasks_on_status"
                   t.index ["submission_id"], name: "index_tasks_on_submission_id"
                 end
-            -   create_table "test_pairs", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "test_pairs", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "problem_id"
-            -     t.text "input", limit: 4294967295
+            +     t.text "input", size: :medium
-            -     t.text "solution", limit: 4294967295
+            +     t.text "solution", size: :medium
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                 end
-            -   create_table "test_requests", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "test_requests", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.integer "problem_id"
                   t.integer "submission_id"
                   t.string "input_file_name"
                   t.string "output_file_name"
                   t.string "running_stat"
                   t.integer "status"
                   t.datetime "updated_at", null: false
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text "compiler_message", limit: 16777215
+            +     t.text "compiler_message"
                   t.datetime "graded_at"
                   t.string "grader_comment"
                   t.datetime "created_at", null: false
                   t.float "running_time"
                   t.string "exit_status"
                   t.integer "memory_usage"
                   t.index ["user_id", "problem_id"], name: "index_test_requests_on_user_id_and_problem_id"
                 end
-            -   create_table "testcases", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=latin1", force: :cascade do |t|
+            +   create_table "testcases", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.integer "problem_id"
                   t.integer "num"
                   t.integer "group"
                   t.integer "score"
-            -     t.text "input", limit: 4294967295
+            +     t.text "input", size: :long
-            -     t.text "sol", limit: 4294967295
+            +     t.text "sol", size: :long
-            -     t.datetime "created_at", null: false
+            +     t.datetime "created_at"
-            -     t.datetime "updated_at", null: false
+            +     t.datetime "updated_at"
                   t.index ["problem_id"], name: "index_testcases_on_problem_id"
                 end
-            -   create_table "user_contest_stats", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "user_contest_stats", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.integer "user_id"
                   t.datetime "started_at"
                   t.datetime "created_at", null: false
                   t.datetime "updated_at", null: false
                   t.boolean "forced_logout"
                 end
-            -   create_table "users", id: :integer, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|
+            +   create_table "users", id: :integer, charset: "utf8", collation: "utf8_unicode_ci", force: :cascade do |t|
                   t.string "login", limit: 50
                   t.string "full_name"
                   t.string "hashed_password"
                   t.string "salt", limit: 5
                   t.string "alias"
                   t.string "email"
                   t.integer "site_id"
                   t.integer "country_id"
                   t.boolean "activated", default: false
                   t.datetime "created_at"
                   t.datetime "updated_at"
-            -     t.string "section"
                   t.boolean "enabled", default: true
                   t.string "remark"
                   t.string "last_ip"
+            +     t.string "section"
                   t.integer "default_language"
                   t.index ["login"], name: "index_users_on_login", unique: true
                 end
                 add_foreign_key "problems_tags", "problems"
                 add_foreign_key "problems_tags", "tags"

Write
Preview

You need to be logged in to leave comments. Login now

	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 r854:14d6c4fb29b0 public

Author

r854:14d6c4fb29b0 - Fri, 04 Feb 2022 15:55:30 - 12 files changed: 225 inserted, 138 deleted

Commit `r854:14d6c4fb29b0` public