cafe-grader-web Commit - r879:60919c3675f4

cafe-grader-web

Commit `r879:60919c3675f4` public

parent | child

Description:

tags / problems

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

r879:60919c3675f4 - Thu, 06 Oct 2022 04:34:53 - 13 files changed: 89 inserted, 106 deleted

Gemfile.lock ¶ +4

                     strscan
                   net-pop (0.1.1)
                     digest
                     net-protocol
                     timeout
                   net-protocol (0.1.3)
                     timeout
                   net-smtp (0.3.1)
                     digest
                     net-protocol
                     timeout
                   nio4r (2.5.8)
+            +     nokogiri (1.13.8-x86_64-darwin)
+            +       racc (~> 1.4)
                   nokogiri (1.13.8-x86_64-linux)
                     racc (~> 1.4)
                   popper_js (2.11.6)
                   public_suffix (5.0.0)
                   puma (5.6.5)
                     nio4r (~> 2.0)
                   racc (1.6.0)
                   rack (2.2.4)
                   rack-test (2.0.2)
                     rack (>= 1.3)
                   rails (7.0.4)
                     actioncable (= 7.0.4)
                   sexp_processor (4.16.1)
                   spring (2.1.1)
                   spring-watcher-listen (2.0.1)
                     listen (>= 2.7, < 4.0)
                     spring (>= 1.2, < 3.0)
                   sprockets (4.1.1)
                     concurrent-ruby (~> 1.0)
                     rack (> 1, < 3)
                   sprockets-rails (3.4.2)
                     actionpack (>= 5.2)
                     activesupport (>= 5.2)
                     sprockets (>= 3.0.0)
+            +     sqlite3 (1.5.0-x86_64-darwin)
                   sqlite3 (1.5.0-x86_64-linux)
                   strscan (3.0.4)
                   temple (0.8.2)
                   thor (1.2.1)
                   tilt (2.0.11)
                   timeout (0.3.0)
                   tzinfo (2.0.5)
                     concurrent-ruby (~> 1.0)
                   web-console (4.2.0)
                     actionview (>= 6.0.0)
                     activemodel (>= 6.0.0)
                     bindex (>= 0.4.0)
                     nokogiri (~> 1.6)
                     rubyzip (>= 1.3.0)
                     selenium-webdriver (~> 4.0)
                   websocket (1.2.9)
                   websocket-driver (0.7.5)
                     websocket-extensions (>= 0.1.0)
                   websocket-extensions (0.1.5)
                   xpath (3.2.0)
                     nokogiri (~> 1.8)
                   zeitwerk (2.6.0)
               PLATFORMS
+            +   x86_64-darwin-20
                 x86_64-linux
               DEPENDENCIES
                 ace-rails-ap
                 best_in_place!
                 bootsnap
                 bootstrap (~> 5.2)
                 byebug
                 capybara
                 coffee-rails
                 fuzzy-string-match
                 haml

app/controllers/application_controller.rb ¶ +6 -19

                 before_action :current_user
                 before_action :nav_announcement
                 before_action :unique_visitor_id
                 before_action :active_controller_action
                 SINGLE_USER_MODE_CONF_KEY = 'system.single_user_mode'
                 MULTIPLE_IP_LOGIN_CONF_KEY = 'right.multiple_ip_login'
                 WHITELIST_IGNORE_CONF_KEY = 'right.whitelist_ignore'
                 WHITELIST_IP_CONF_KEY = 'right.whitelist_ip'
                 #report and redirect for unauthorized activities
-            -   def unauthorized_redirect(notice = 'You are not authorized to view the page you requested')
+            +   def unauthorized_redirect(msg = 'You are not authorized to view the page you requested')
-            -     flash[:notice] = notice
+            +     redirect_to login_main_path, alert: msg
-            -     redirect_to login_main_path
                 end
                 # Returns the current logged-in user (if any).
                 def current_user
                   return nil unless session[:user_id]
                   @current_user ||= User.find(session[:user_id])
                 end
                 def nav_announcement
                   @nav_announcement = Announcement.where(on_nav_bar: true)
                 end
                 end
                 def admin_authorization
                   return false unless check_valid_login
                   user = User.includes(:roles).find(session[:user_id])
                   unless user.admin?
                     unauthorized_redirect
                     return false
                   end
                   return true
                 end
-            -   #admin always count as every roles
+            +   def authorization_by_roles(allowed_roles)
-            -   def role_authorization(roles)
                   return false unless check_valid_login
-            -     user = User.find(session[:user_id])
+            +     return true if @current_user.admin?
-            -     return true if user.admin?
                   roles.each do |r|
-            -       return true if user.has_role?(r)
+            +       return true if @current_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
-            -   end
                 def testcase_authorization
                   #admin always has privileged
-            -     if @current_user.admin?
+            +     return true if @current_user.admin?
-            -       return true
-            -     end
                   unauthorized_redirect unless GraderConfiguration["right.view_testcase"]
                 end
                 def unique_visitor_id
                   unless cookies.encrypted[:uuid]
                     value = SecureRandom.uuid
                     cookies.encrypted[:uuid] = { value: value, expires: 20.year }
                   end
                 end
                 protected

app/controllers/login_controller.rb ¶ +5 -7

               class LoginController < ApplicationController
                 @@authenticators = []
+            +
                 def index
                   # show login screen
                   reset_session
                   redirect_to :controller => 'main', :action => 'login'
                 end
                 def login
                   user = get_authenticated_user(params[:login], params[:password])
                   unless user
-            -       flash[:notice] = 'Wrong password'
+            +       redirect_to login_main_path, alert: 'Wrong password'
-            -       redirect_to :controller => 'main', :action => 'login'
                     return
                   end
                   if (!GraderConfiguration['right.bypass_agreement']) and (!params[:accept_agree]) and !user.admin?
-            -       flash[:notice] = 'You must accept the agreement before logging in'
+            +       redirect_to login_main_path, alert: 'You must accept the agreement before logging in'
-            -       redirect_to :controller => 'main', :action => 'login'
                     return
                   end
                   #store uuid when login
                   if user.last_ip.nil?
                     user.last_ip = cookies.encrypted[:uuid]
                   else
                     if user.last_ip != cookies.encrypted[:uuid]
                       user.last_ip =cookies.encrypted[:uuid]
                       #log different login
                     end
                   end
                   Login.create(user_id: user.id, ip_address: cookies.encrypted[:uuid])
                   redirect_to :controller => 'main', :action => 'list'
                 end
                 def site_login
                   begin
                     site = Site.find(params[:login][:site_id])
                   rescue ActiveRecord::RecordNotFound
                     site = nil
                   end
                   if site==nil
-            -       flash[:notice] = 'Wrong site'
+            +       flash[:alert] = 'Wrong site'
                     redirect_to :controller => 'main', :action => 'login'  and return
                   end
                   if (site.password) and (site.password == params[:login][:password])
                     session[:site_id] = site.id
                     redirect_to :controller => 'site', :action => 'index'
                   else
-            -       flash[:notice] = 'Wrong site password'
+            +       flash[:alert] = 'Wrong site password'
                     redirect_to :controller => 'site', :action => 'login'
                   end
                 end
                 def logout
                   redirect_to root_path
                 end
                 def self.add_authenticator(authenticator)
                   @@authenticators << authenticator
                 end

app/controllers/main_controller.rb ¶ +2 -3

                                                  :confirm_contest_start]
                 # to prevent log in box to be shown when user logged out of the
                 # system only in some tab
                 prepend_before_action :reject_announcement_refresh_when_logged_out,
                                       :only => [:announcements]
                 before_action :authenticate_by_ip_address, :only => [:list]
                 #reset login, clear session
                 #front page
                 def login
-            -     saved_notice = flash[:notice]
+            +     #saved_notice = flash[:notice]
-            -     reset_session
+            +     #flash[:notice] = saved_notice
-            -     flash.now[:notice] = saved_notice
                   @remote_ip = request.remote_ip
                   # EXPERIMENT:
                   # Hide login if in single user mode and the url does not
                   # explicitly specify /login
                   #
                   # logger.info "PATH: #{request.path}"
                   # if GraderConfiguration['system.single_user_mode'] and
                   #     request.path!='/main/login'
                   #   @hidelogin = true
                   # end

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

               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 only: [:rejudge, :set_tag] do role_authorization([:ta]) end
+            +   before_action only: [:rejudge, :set_tag] do authorization_by_roles([:ta]) end
                 # GET /submissions
                 # GET /submissions.json
                 # Show problem selection and user's submission of that problem
                 def index
                   @user = @current_user
                   @problems = @user.available_problems
                   if params[:problem_id]==nil
                     @problem = nil
                     @submissions = nil
                   else

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

                   @tag = Tag.new
                 end
                 # GET /tags/1/edit
                 def edit
                 end
                 # POST /tags
                 def create
                   @tag = Tag.new(tag_params)
                   if @tag.save
-            -       redirect_to @tag, notice: 'Tag was successfully created.'
+            +       redirect_to tags_path, notice: 'Tag was successfully created.'
                   else
                     render :new
                   end
                 end
                 # PATCH/PUT /tags/1
                 def update
                   if @tag.update(tag_params)
                     redirect_to @tag, notice: 'Tag was successfully updated.'
                   else
                     render :edit
                   end

app/views/groups/index.html.haml ¶ +1 -1

                   %tr
                     %th Name
                     %th Description
                     %th Enabled?
                     %th
                 %tbody
                   - @groups.each do |group|
                     %tr{:class => "#{(group.enabled?) ? "success" : "danger"}", id: "group-#{group.id}"}
                       %td= group.name
                       %td= group.description
                       %td= toggle_button(group.enabled?, toggle_group_path(group), "group-enabled-#{group.id}", block: ' ')
                       %td
-            -           = link_to 'Edit members and problems', group, class: 'btn btn-secondary btn-sm'
+            +           = link_to 'Edit members and problems', group, class: 'btn btn-info btn-sm'
                         = link_to 'Destroy', group, :method => :delete, :data => { :confirm => 'Are you sure?' }, class: 'btn btn-danger btn-sm'
               %br

app/views/layouts/_header.html.haml ¶ +1 -1

                     %ul.navbar-nav
                       %li.nav-item
                         %a.nav-link{href: help_main_path}
                           %span.mi.mi-bs.md-18 help
                       %li.nav-item
                         %a.nav-link{href: messages_path}
                           %span.mi.mi-bs.md-18 chat
                       - if GraderConfiguration['system.user_setting_enabled']
                         %li.nav-item
                           %a.nav-link{href: profile_users_path}
                             %span.mi.mi-bs.md-18 settings
                       %li.nav-item
-            -           %a.nav-link{href: login_main_path}
+            +           %a.nav-link{href: logout_main_path}
                           %span.mi.mi-bs.md-18 exit_to_app
                           = @current_user.full_name
               :javascript
                 $('.active-with-children').each( (index,obj) => {
                   if ($(obj).siblings('.dropdown-menu').has('.active').length > 0) {
                     $(obj).addClass('active')
                   }
                 } )

app/views/main/_login_box.html.haml ¶ +2 -3

               .card
                 .card-body
                   .card-title
                     %h3= GraderConfiguration['ui.front.welcome_message']
                   - if !@hidelogin
                     .card-subtitle=t 'login.message'
                     - if flash[:notice]
-            -         %hr/
+            +         .alert.alert-danger
-            -         %b= flash[:notice]
+            +           = flash[:notice]
-            -         %hr/
                     .card
                       .card-body{ style: "background: #eeeeff;"}
                         = form_with url: login_login_path do |f|
                           .mb-3
                             = f.label :login, "Login", class: 'form-label'
                             = f.text_field :login, class: 'form-control'
                           .mb-3
                             = f.label :password, "Password", class: 'form-label'
                             = f.password_field :password, class: 'form-control'
                           - unless GraderConfiguration['right.bypass_agreement']
                             .col-sm-offset-3.col-sm-9

app/views/tags/_form.html.haml ¶ +5 -20

@@ -1,22 +1,7
1	- = form_for @tag do \|f\|	1	+ = simple_form_for @tag do \|f\|
2	- - if @tag.errors.any?
3	- #error_explanation
4	- %h2= "#{pluralize(@tag.errors.count, "error")} prohibited this tag from being saved:"
5	- %ul
6	- - @tag.errors.full_messages.each do \|msg\|
7	- %li= msg
8	-
9	.row	2	.row
10	.col-md-6	3	.col-md-6
11	- .form-group.field	4	+ = f.input :name
12	- = f.label :name	5	+ = f.input :description
13	- = f.text_field :name, class: 'form-control'	6	+ = f.input :public
14	- .form-group.field	7	+ = f.submit 'Save', class: 'btn btn-primary'
15	- = f.label :description
16	- = f.text_area :description, class: 'form-control'
17	- .form-group.field
18	- = f.label :public
19	- = f.text_field :public, class: 'form-control'
20	- .actions
21	- = f.submit 'Save', class: 'btn btn-primary'
22	- .col-md-6

app/views/tags/index.html.haml ¶ +3 -3

                     %th Description
                     %th Public
                     %th
                     %th
                     %th
                 %tbody
                   - @tags.each do |tag|
                     %tr
                       %td= tag.name
                       %td= tag.description
                       %td= tag.public
-            -         %td= link_to 'Show', tag
+            +         %td= link_to 'Show', tag, class: 'btn btn-info'
-            -         %td= link_to 'Edit', edit_tag_path(tag)
+            +         %td= link_to 'Edit', edit_tag_path(tag), class: 'btn btn-info'
-            -         %td= link_to 'Destroy', tag, :method => :delete, :data => { :confirm => 'Are you sure?' }
+            +         %td= button_to 'Destroy', tag, :method => :delete, :data => { :confirm => 'Are you sure?' }, class: 'btn btn-danger'
               %br

app/views/user_admin/index.html.haml ¶ +2 -2

                   %th
                   %th
                 - for user in @users
                   %tr
                     %td= link_to user.login, stat_user_path(user)
                     %td= user.full_name
                     %td= user.email
                     %td= user.remark
                     %td= toggle_button(user.activated?, toggle_activate_user_path(user),"toggle_activate_user_#{user.id}")
                     %td= toggle_button(user.enabled?, toggle_enable_user_path(user),"toggle_enable_user_#{user.id}")
                     %td= user.last_ip
                     %td= link_to 'Clear IP', {:action => 'clear_last_ip', :id => user, :page=>params[:page]}, :confirm => 'This will reset last logging in ip of the user, are you sure?', class: 'btn btn-secondary btn-sm btn-block'
-            -       %td= link_to 'Show', {:action => 'show', :id => user}, class: 'btn btn-secondary btn-sm btn-block'
+            +       %td= link_to 'Show', {:action => 'show', :id => user}, class: 'btn btn-info btn-sm btn-block'
-            -       %td= link_to 'Edit', {:action => 'edit', :id => user}, class: 'btn btn-secondary btn-sm btn-block'
+            +       %td= link_to 'Edit', {:action => 'edit', :id => user}, class: 'btn btn-info btn-sm btn-block'
                     %td= link_to 'Destroy', {action: :destroy, id: user}, data: {confirm: 'Are you sure?'}, method: :delete, class: 'btn btn-danger btn-sm btn-block'
               %br/
               = link_to '+ New user', { :action => 'new' }, { class: 'btn btn-success '}
               = link_to '+ New list of users', { :action => 'new_list' }, { class: 'btn btn-success '}
               :javascript
                 $(document).on('import-map-loaded',(e) => {
                   $('.datatable').DataTable({
                     'pageLength': 50
                   });
                 })

db/schema.rb ¶ +56 -45

               # of editing this file, please use the migrations feature of Active Record to
               # incrementally modify your database, and then regenerate this schema definition.
               #
               # This file is the source Rails uses to define your schema when running `bin/rails
               # db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to
               # be faster and is potentially less error prone than running all of your
               # migrations from scratch. Old migrations may fail to apply correctly if those
               # migrations use external dependencies or application code.
               #
               # It's strongly recommended that you check this file into your version control system.
               ActiveRecord::Schema[7.0].define(version: 2022_09_27_074644) do
-            -   create_table "active_storage_attachments", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+            +   create_table "active_storage_attachments", charset: "latin1", force: :cascade do |t|
                   t.string "name", null: false
                   t.string "record_type", null: false
                   t.bigint "record_id", null: false
                   t.bigint "blob_id", null: false
                   t.datetime "created_at", null: false
                   t.index ["blob_id"], name: "index_active_storage_attachments_on_blob_id"
                   t.index ["record_type", "record_id", "name", "blob_id"], name: "index_active_storage_attachments_uniqueness", unique: true
                 end
-            -   create_table "active_storage_blobs", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+            +   create_table "active_storage_blobs", charset: "latin1", force: :cascade do |t|
                   t.string "key", null: false
                   t.string "filename", null: false
                   t.string "content_type"
                   t.text "metadata"
                   t.string "service_name", null: false
                   t.bigint "byte_size", null: false
                   t.string "checksum"
                   t.datetime "created_at", null: false
                   t.index ["key"], name: "index_active_storage_blobs_on_key", unique: true
                 end
-            -   create_table "active_storage_variant_records", charset: "utf8mb4", collation: "utf8mb4_0900_ai_ci", force: :cascade do |t|
+            +   create_table "active_storage_variant_records", charset: "latin1", force: :cascade do |t|
                   t.bigint "blob_id", null: false
                   t.string "variation_digest", null: false
                   t.index ["blob_id", "variation_digest"], name: "index_active_storage_variant_records_uniqueness", unique: true
                 end
-            -   create_table "announcements", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "announcements", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "author"
-            -     t.text "body"
+            +     t.text "body", size: :medium
                   t.boolean "published"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, 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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "contests", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "title"
                   t.boolean "enabled"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                   t.string "name"
                 end
-            -   create_table "contests_problems", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "contests_problems", id: false, charset: "utf8", force: :cascade do |t|
                   t.integer "contest_id"
                   t.integer "problem_id"
                 end
-            -   create_table "contests_users", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "contests_users", id: false, charset: "utf8", force: :cascade do |t|
                   t.integer "contest_id"
                   t.integer "user_id"
                 end
-            -   create_table "countries", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "countries", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "name"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "descriptions", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "descriptions", id: :integer, charset: "utf8", force: :cascade do |t|
-            -     t.text "body"
+            +     t.text "body", size: :medium
                   t.boolean "markdowned"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "grader_configurations", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "grader_configurations", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "key"
                   t.string "value_type"
                   t.string "value"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
-            -     t.text "description"
+            +     t.text "description", size: :medium
                 end
-            -   create_table "grader_processes", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "grader_processes", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "host"
                   t.integer "pid"
                   t.string "mode"
                   t.boolean "active"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, 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_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", 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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "heart_beats", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.integer "user_id"
                   t.string "ip_address"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                   t.string "status"
                   t.index ["updated_at"], name: "index_heart_beats_on_updated_at"
                 end
-            -   create_table "languages", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "languages", id: :integer, charset: "utf8", 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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "logins", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.integer "user_id"
                   t.string "ip_address"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                   t.index ["user_id"], name: "index_logins_on_user_id"
                 end
-            -   create_table "messages", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "messages", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.integer "sender_id"
                   t.integer "receiver_id"
                   t.integer "replying_message_id"
-            -     t.text "body"
+            +     t.text "body", size: :medium
                   t.boolean "replied"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "problems", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "problems", id: :bigint, default: nil, charset: "utf8", force: :cascade do |t|
-            -     t.string "name", limit: 30
+            +     t.string "name", limit: 100
                   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"
                   t.text "description"
                   t.boolean "markdown"
                 end
-            -   create_table "problems_tags", id: :integer, charset: "latin1", force: :cascade do |t|
+            +   create_table "problems_tags", id: :bigint, default: nil, charset: "latin1", force: :cascade do |t|
-            -     t.integer "problem_id"
+            +     t.bigint "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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "rights", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "name"
                   t.string "controller"
                   t.string "action"
                 end
-            -   create_table "rights_roles", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "rights_roles", id: false, charset: "utf8", 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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "roles", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "name"
                 end
-            -   create_table "roles_users", id: false, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "roles_users", id: false, charset: "utf8", 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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "sessions", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "session_id"
-            -     t.text "data"
+            +     t.text "data", size: :medium
                   t.datetime "updated_at", precision: nil
                   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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "sites", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.string "name"
                   t.boolean "started"
                   t.datetime "start_time", precision: nil
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                   t.integer "country_id"
                   t.string "password"
                 end
-            -   create_table "submission_view_logs", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "solutions", charset: "latin1", force: :cascade do |t|
+            +     t.string "solution"
+            +     t.bigint "problem_id"
+            +     t.bigint "submission_id"
+            +     t.integer "type"
+            +     t.index ["problem_id"], name: "index_solutions_on_problem_id"
+            +     t.index ["submission_id"], name: "index_solutions_on_submission_id"
+            +   end
+            +
+            +   create_table "submission_view_logs", id: :integer, charset: "latin1", force: :cascade do |t|
                   t.integer "user_id"
                   t.integer "submission_id"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "submissions", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "submissions", id: :bigint, default: nil, charset: "utf8", force: :cascade do |t|
                   t.integer "user_id"
                   t.integer "problem_id"
                   t.integer "language_id"
                   t.text "source", size: :medium
                   t.binary "binary"
                   t.datetime "submitted_at", precision: nil
                   t.datetime "compiled_at", precision: nil
-            -     t.text "compiler_message"
+            +     t.text "compiler_message", size: :medium
                   t.datetime "graded_at", precision: nil
                   t.integer "points"
-            -     t.text "grader_comment"
+            +     t.text "grader_comment", size: :medium
                   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, charset: "latin1", force: :cascade do |t|
                   t.string "name", null: false
                   t.text "description"
                   t.boolean "public"
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "tasks", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "tasks", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.integer "submission_id"
                   t.datetime "created_at", precision: nil
                   t.integer "status"
                   t.datetime "updated_at", precision: nil
                   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, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "test_pairs", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.integer "problem_id"
-            -     t.text "input", size: :medium
+            +     t.text "input", size: :long
-            -     t.text "solution", size: :medium
+            +     t.text "solution", size: :long
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                 end
-            -   create_table "test_requests", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "test_requests", id: :integer, charset: "utf8", 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", precision: nil, null: false
                   t.datetime "submitted_at", precision: nil
                   t.datetime "compiled_at", precision: nil
-            -     t.text "compiler_message"
+            +     t.text "compiler_message", size: :medium
                   t.datetime "graded_at", precision: nil
                   t.string "grader_comment"
                   t.datetime "created_at", precision: nil, 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, charset: "latin1", force: :cascade do |t|
                   t.integer "problem_id"
                   t.integer "num"
                   t.integer "group"
                   t.integer "score"
                   t.text "input", size: :long
                   t.text "sol", size: :long
-            -     t.datetime "created_at", precision: nil
+            +     t.datetime "created_at", precision: nil, null: false
-            -     t.datetime "updated_at", precision: nil
+            +     t.datetime "updated_at", precision: nil, null: false
                   t.index ["problem_id"], name: "index_testcases_on_problem_id"
                 end
-            -   create_table "user_contest_stats", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "user_contest_stats", id: :integer, charset: "utf8", force: :cascade do |t|
                   t.integer "user_id"
                   t.datetime "started_at", precision: nil
                   t.datetime "created_at", precision: nil, null: false
                   t.datetime "updated_at", precision: nil, null: false
                   t.boolean "forced_logout"
                 end
-            -   create_table "users", id: :integer, charset: "utf8mb3", collation: "utf8mb3_unicode_ci", force: :cascade do |t|
+            +   create_table "users", id: :integer, charset: "utf8", 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", precision: nil
                   t.datetime "updated_at", precision: nil
+            +     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 "active_storage_attachments", "active_storage_blobs", column: "blob_id"
                 add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id"
                 add_foreign_key "problems_tags", "problems"
                 add_foreign_key "problems_tags", "tags"
+            +   add_foreign_key "solutions", "problems"
+            +   add_foreign_key "solutions", "submissions"
               end

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

Author

r879:60919c3675f4 - Thu, 06 Oct 2022 04:34:53 - 13 files changed: 89 inserted, 106 deleted

Sign in to your account

Commit r879:60919c3675f4 public

Author

r879:60919c3675f4 - Thu, 06 Oct 2022 04:34:53 - 13 files changed: 89 inserted, 106 deleted

Commit `r879:60919c3675f4` public