cafe-grader-web Commit - r528:dfe79b5eef35

cafe-grader-web

Commit `r528:dfe79b5eef35` public

parent | child

Description:

NOT WORKING add submission view log

Commit status:

[Not Reviewed]

References:

algo

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r528:dfe79b5eef35 - Thu, 27 Aug 2015 13:31:02 - 7 files changed: 137 inserted, 28 deleted

app/models/submission_view_logs.rb created 644 ¶ +3

@@ -0,0 +1,3
	1	+ class SubmissionViewLogs < ActiveRecord::Base
	2	+ attr_accessible :submission_id, :user_id
	3	+ end

app/views/report/cheat_scruntinize.html.haml created 644 ¶ +82

@@ -0,0 +1,82
	1	+ - content_for :header do
	2	+ = stylesheet_link_tag 'tablesorter-theme.cafe'
	3	+ = javascript_include_tag 'local_jquery'
	4	+
	5	+ %script{:type=>"text/javascript"}
	6	+ $(function () {
	7	+ $('#since_datetime').datetimepicker({ showButtonPanel: true, dateFormat: "yy-mm-dd", controlType: "slider"} );
	8	+ $('#until_datetime').datetimepicker({ showButtonPanel: true, dateFormat: "yy-mm-dd", controlType: "slider"} );
	9	+ $('#my_table').tablesorter({widthFixed: true, widgets: ['zebra']});
	10	+ $('#my_table2').tablesorter({widthFixed: true, widgets: ['zebra']});
	11	+ $('#sub_table').tablesorter({widthFixed: true, widgets: ['zebra']});
	12	+ });
	13	+
	14	+ %h1 Login status
	15	+
	16	+ =render partial: 'report_menu'
	17	+
	18	+
	19	+ = form_tag({session: :url }) do
	20	+ .submitbox
	21	+ %table
	22	+ %tr
	23	+ %td{colspan: 6, style: 'font-weight: bold'}= 'Query login & submit in the range'
	24	+ %tr
	25	+ %td{style: 'width: 120px; font-weight: bold'}= 'Login date range'
	26	+ %td{align: 'right'} since:
	27	+ %td= text_field_tag 'since_datetime', @since_time
	28	+ %tr
	29	+ %td
	30	+ %td{align: 'right'} until:
	31	+ %td= text_field_tag 'until_datetime', @until_time
	32	+ %tr
	33	+ %td
	34	+ %td
	35	+ %td Blank mean no condition
	36	+ %tr
	37	+ %td{style: 'width: 120px; font-weight: bold'}= "ID"
	38	+ %td{colspan: 2}= text_field_tag 'SID', @sid, size: 40
	39	+ %tr
	40	+ %td
	41	+ %td
	42	+ %td= submit_tag 'query'
	43	+
	44	+
	45	+ %h2 Logs
	46	+
	47	+ - if @sid
	48	+ %table
	49	+ %tbody
	50	+ - @sid.each do \|id\|
	51	+ - user = User.where("login = ?",id).first
	52	+ %tr
	53	+ //%td= link_to id, controller: :user, action: :profile, id: id
	54	+ %td= link_to id, "https://www.nattee.net/java/users/profile/#{user.id}"
	55	+ %td= user.full_name
	56	+
	57	+ //%table.tablesorter-cafe#my_table
	58	+ %table.info
	59	+ %thead
	60	+ %tr.info-head
	61	+ %th Time
	62	+ %th Action
	63	+ %th IP
	64	+ %th login
	65	+ %th name
	66	+ %th problem
	67	+ %th score
	68	+ %tbody
	69	+ - if @logs
	70	+ - @logs.each do \|l\|
	71	+ %tr{class: cycle('info-even','info-odd')}
	72	+ %td= l[:submitted_at].strftime "%Y.%b.%d %H:%M:%S"
	73	+ //%td= l[:id] == -1 ? "LOGIN" : link_to("submit #{l[:id]}", controller: 'graders' , action: 'submission', id: l[:id])
	74	+ %td= l[:id] == -1 ? "LOGIN" : link_to( "submit #{l[:id]}", "https://www.nattee.net/java/graders/submission/#{l[:id]}")
	75	+ %td= l[:ip_address]
	76	+ //%td= link_to l[:login], controller: 'users', action: 'profile', id: l[:id]
	77	+ %td= link_to( l[:login], "https://www.nattee.net/java/users/profile/#{l.user_id}")
	78	+ %td= l[:full_name]
	79	+ %td= l[:id] == -1 ? "" : l.problem.name
	80	+ %td= l[:id] == -1 ? "" : l.points * 100/ l.problem.full_score
	81	+
	82	+

db/migrate/20150827131927_create_submission_view_logs.rb created 644 ¶ +10

@@ -0,0 +1,10
	1	+ class CreateSubmissionViewLogs < ActiveRecord::Migration
	2	+ def change
	3	+ create_table :submission_view_logs do \|t\|
	4	+ t.integer :user_id
	5	+ t.integer :submission_id
	6	+
	7	+ t.timestamps
	8	+ end
	9	+ end
	10	+ end

spec/models/submission_view_logs_spec.rb created 644 ¶ +5

@@ -0,0 +1,5
	1	+ require 'spec_helper'
	2	+
	3	+ describe SubmissionViewLogs do
	4	+ pending "add some examples to (or delete) #{__FILE__}"
	5	+ end

Gemfile.lock ¶ +1 -1

                   activeresource (3.2.21)
                     activemodel (= 3.2.21)
                     activesupport (= 3.2.21)
                   activesupport (3.2.21)
                     i18n (~> 0.6, >= 0.6.4)
                     multi_json (~> 1.0)
                   arel (3.0.3)
                   best_in_place (3.0.3)
                     actionpack (>= 3.2)
                     railties (>= 3.2)
                   builder (3.0.4)
                   coffee-rails (3.2.2)
                     coffee-script (>= 2.2.0)
                     railties (~> 3.2.0)
                   coffee-script (2.3.0)
                     coffee-script-source
                     execjs
                   coffee-script-source (1.9.0)
                   diff-lcs (1.2.5)
                   dynamic_form (1.1.4)
                   erubis (2.7.0)
                   execjs (2.3.0)
                   haml (4.0.6)
                     tilt
                   hike (1.2.3)
                   i18n (0.7.0)
                   in_place_editing (1.2.0)
                   journey (1.0.4)
                   jquery-rails (3.1.2)
                     railties (>= 3.0, < 5.0)
                     thor (>= 0.14, < 2.0)
                   jquery-tablesorter (1.13.4)
                     railties (>= 3.1, < 5)
                   jquery-timepicker-addon-rails (1.4.1)
                     railties (>= 3.1)
                   jquery-ui-rails (4.0.3)
                     jquery-rails
                     railties (>= 3.1.0)
                   jquery-ui-sass-rails (4.0.3.0)
                     jquery-rails
                     jquery-ui-rails (= 4.0.3)
                     railties (>= 3.1.0)
                   json (1.8.2)
                   mail (2.5.4)
                     mime-types (~> 1.16)
                     treetop (~> 1.4.8)
                   mime-types (1.25.1)
                   multi_json (1.10.1)
-            -     mysql2 (0.3.17)
+            +     mysql2 (0.3.20)
                   polyglot (0.3.5)
                   power_assert (0.2.2)
                   prototype-rails (3.2.1)
                     rails (~> 3.2)
                   rack (1.4.5)
                   rack-cache (1.2)
                     rack (>= 0.4)
                   rack-ssl (1.3.4)
                     rack
                   rack-test (0.6.3)
                     rack (>= 1.0)
                   rails (3.2.21)
                     actionmailer (= 3.2.21)
                     actionpack (= 3.2.21)
                     activerecord (= 3.2.21)
                     activeresource (= 3.2.21)
                     activesupport (= 3.2.21)
                     bundler (~> 1.0)
                     railties (= 3.2.21)
                   railties (3.2.21)
                     actionpack (= 3.2.21)
                     activesupport (= 3.2.21)
                     rack-ssl (~> 1.3.2)
                     rake (>= 0.8.7)
                     rdoc (~> 3.4)
                     thor (>= 0.14.6, < 2.0)
                   rake (10.4.2)
                   rdiscount (2.1.8)
                   rdoc (3.12.2)
                     json (~> 1.4)
                   rouge (1.8.0)
                   rspec-collection_matchers (1.1.2)
                     rspec-expectations (>= 2.99.0.beta1)
                   rspec-core (2.99.2)
                   rspec-expectations (2.99.2)
                     diff-lcs (>= 1.1.3, < 2.0)
                   rspec-mocks (2.99.3)
                   rspec-rails (2.99.0)
                     actionpack (>= 3.0)
                     activemodel (>= 3.0)
                     activesupport (>= 3.0)
                     railties (>= 3.0)
                     rspec-collection_matchers
                     rspec-core (~> 2.99.0)
                     rspec-expectations (~> 2.99.0)
                     rspec-mocks (~> 2.99.0)
                   sass (3.4.11)
                   sass-rails (3.2.6)

app/controllers/graders_controller.rb ¶ +2

                   redirect_to :action => 'list'
                 end
                 def clear_terminated
                   GraderProcess.find_terminated_graders.each do |p|
                     p.destroy
                   end
                   redirect_to :action => 'list'
                 end
                 def clear_all
                   GraderProcess.find(:all).each do |p|
                     p.destroy
                   end
                   redirect_to :action => 'list'
                 end
                 def view
                   if params[:type]=='Task'
                     redirect_to :action => 'task', :id => params[:id]
                   else
                     redirect_to :action => 'test_request', :id => params[:id]
                   end
                 end
                 def test_request
                   @test_request = TestRequest.find(params[:id])
                 end
                 def task
                   @task = Task.find(params[:id])
                 end
                 def submission
                   @submission = Submission.find(params[:id])
                   formatter = Rouge::Formatters::HTML.new(css_class: 'highlight', line_numbers: true )
                   lexer = case @submission.language.name
                     when "c"      then Rouge::Lexers::C.new
                     when "cpp"    then Rouge::Lexers::Cpp.new
                     when "pas"    then Rouge::Lexers::Pas.new
                     when "ruby"   then Rouge::Lexers::Ruby.new
                     when "python" then Rouge::Lexers::Python.new
                     when "java"   then Rouge::Lexers::Java.new
                     when "php"    then Rouge::Lexers::PHP.new
                   end
                   @formatted_code = formatter.format(lexer.lex(@submission.source))
                   @css_style = Rouge::Themes::ThankfulEyes.render(scope: '.highlight')
+            +     SubmissionLogView.create(user_id: user.id,submission_id: @submission.id)
+            +
                 end
                 # various grader controls
                 def stop
                   grader_proc = GraderProcess.find(params[:id])
                   GraderScript.stop_grader(grader_proc.pid)
                   flash[:notice] = 'Grader stopped.  It may not disappear now, but it should disappear shortly.'
                   redirect_to :action => 'list'
                 end
                 def stop_all
                   GraderScript.stop_graders(GraderProcess.find_running_graders +
                                             GraderProcess.find_stalled_process)
                   flash[:notice] = 'Graders stopped.  They may not disappear now, but they should disappear shortly.'
                   redirect_to :action => 'list'
                 end
                 def start_grading
                   GraderScript.start_grader('grading')
                   flash[:notice] = '2 graders in grading env started, one for grading queue tasks, another for grading test request'
                   redirect_to :action => 'list'
                 end
                 def start_exam
                   GraderScript.start_grader('exam')
                   flash[:notice] = '2 graders in grading env started, one for grading queue tasks, another for grading test request'
                   redirect_to :action => 'list'
                 end
               end

db/schema.rb ¶ +34 -27

               # encoding: UTF-8
               # 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
               # database schema. If you need to create the application database on another
               # system, you should be using db:schema:load, not running all the migrations
               # from scratch. The latter is a flawed and unsustainable approach (the more migrations
               # you'll amass, the slower it'll run and the greater likelihood for issues).
               #
               # It's strongly recommended to check this file into your version control system.
-            - ActiveRecord::Schema.define(:version => 20150618085823) do
+            + ActiveRecord::Schema.define(:version => 20150827131927) do
                 create_table "announcements", :force => true do |t|
                   t.string   "author"
-            -     t.text     "body"
+            +     t.text     "body",         :limit => 16777215
                   t.boolean  "published"
-            -     t.datetime "created_at",                      :null => false
+            +     t.datetime "created_at",                                          :null => false
-            -     t.datetime "updated_at",                      :null => false
+            +     t.datetime "updated_at",                                          :null => false
-            -     t.boolean  "frontpage",    :default => false
+            +     t.boolean  "frontpage",                        :default => false
-            -     t.boolean  "contest_only", :default => false
+            +     t.boolean  "contest_only",                     :default => false
                   t.string   "title"
                   t.string   "notes"
                 end
                 create_table "contests", :force => true 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, :force => true do |t|
                   t.integer "contest_id"
                   t.integer "problem_id"
                 end
                 create_table "contests_users", :id => false, :force => true do |t|
                   t.integer "contest_id"
                   t.integer "user_id"
                 end
                 create_table "countries", :force => true do |t|
                   t.string   "name"
                   t.datetime "created_at", :null => false
                   t.datetime "updated_at", :null => false
                 end
                 create_table "descriptions", :force => true do |t|
-            -     t.text     "body"
+            +     t.text     "body",       :limit => 16777215
                   t.boolean  "markdowned"
-            -     t.datetime "created_at", :null => false
+            +     t.datetime "created_at",                     :null => false
-            -     t.datetime "updated_at", :null => false
+            +     t.datetime "updated_at",                     :null => false
                 end
                 create_table "grader_configurations", :force => true do |t|
                   t.string   "key"
                   t.string   "value_type"
                   t.string   "value"
-            -     t.datetime "created_at",  :null => false
+            +     t.datetime "created_at",                      :null => false
-            -     t.datetime "updated_at",  :null => false
+            +     t.datetime "updated_at",                      :null => false
-            -     t.text     "description"
+            +     t.text     "description", :limit => 16777215
                 end
                 create_table "grader_processes", :force => true do |t|
                   t.string   "host",       :limit => 20
                   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"
                 end
                 add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid"
                 create_table "languages", :force => true do |t|
                   t.string "name",        :limit => 10
                   t.string "pretty_name"
                   t.string "ext",         :limit => 10
                   t.string "common_ext"
                 end
                 create_table "logins", :force => true do |t|
                   t.integer  "user_id"
                   t.string   "ip_address"
                   t.datetime "created_at", :null => false
                   t.datetime "updated_at", :null => false
                 end
                 create_table "messages", :force => true do |t|
                   t.integer  "sender_id"
                   t.integer  "receiver_id"
                   t.integer  "replying_message_id"
-            -     t.text     "body"
+            +     t.text     "body",                :limit => 16777215
                   t.boolean  "replied"
-            -     t.datetime "created_at",          :null => false
+            +     t.datetime "created_at",                              :null => false
-            -     t.datetime "updated_at",          :null => false
+            +     t.datetime "updated_at",                              :null => false
                 end
                 create_table "problems", :force => true do |t|
                   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"
                 end
                 create_table "rights", :force => true do |t|
                   t.string "name"
                   t.string "controller"
                   t.string "action"
                 end
                 create_table "rights_roles", :id => false, :force => true do |t|
                   t.integer "right_id"
                   t.integer "role_id"
                 end
                 add_index "rights_roles", ["role_id"], :name => "index_rights_roles_on_role_id"
                 create_table "roles", :force => true do |t|
                   t.string "name"
                 end
                 create_table "roles_users", :id => false, :force => true do |t|
                   t.integer "role_id"
                   t.integer "user_id"
                 end
                 add_index "roles_users", ["user_id"], :name => "index_roles_users_on_user_id"
                 create_table "sessions", :force => true do |t|
                   t.string   "session_id"
-            -     t.text     "data"
+            +     t.text     "data",       :limit => 16777215
                   t.datetime "updated_at"
                 end
                 add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
                 add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
                 create_table "sites", :force => true 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", :force => true 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", :force => true do |t|
                   t.integer  "user_id"
                   t.integer  "problem_id"
                   t.integer  "language_id"
-            -     t.text     "source"
+            +     t.text     "source",                :limit => 16777215
                   t.binary   "binary"
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text     "compiler_message"
+            +     t.text     "compiler_message",      :limit => 16777215
                   t.datetime "graded_at"
                   t.integer  "points"
-            -     t.text     "grader_comment"
+            +     t.text     "grader_comment",        :limit => 16777215
                   t.integer  "number"
                   t.string   "source_filename"
                   t.float    "max_runtime"
                   t.integer  "peak_memory"
                   t.integer  "effective_code_length"
                   t.string   "ip_address"
                 end
                 add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true
                 add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id"
                 create_table "tasks", :force => true do |t|
                   t.integer  "submission_id"
                   t.datetime "created_at"
                   t.integer  "status"
                   t.datetime "updated_at"
                 end
                 create_table "test_pairs", :force => true do |t|
                   t.integer  "problem_id"
-            -     t.text     "input",      :limit => 16777215
+            +     t.text     "input",      :limit => 2147483647
-            -     t.text     "solution",   :limit => 16777215
+            +     t.text     "solution",   :limit => 2147483647
-            -     t.datetime "created_at",                     :null => false
+            +     t.datetime "created_at",                       :null => false
-            -     t.datetime "updated_at",                     :null => false
+            +     t.datetime "updated_at",                       :null => false
                 end
                 create_table "test_requests", :force => true 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 "updated_at",                           :null => false
                   t.datetime "submitted_at"
                   t.datetime "compiled_at"
-            -     t.text     "compiler_message"
+            +     t.text     "compiler_message", :limit => 16777215
                   t.datetime "graded_at"
                   t.string   "grader_comment"
-            -     t.datetime "created_at",       :null => false
+            +     t.datetime "created_at",                           :null => false
                   t.float    "running_time"
                   t.string   "exit_status"
                   t.integer  "memory_usage"
                 end
                 add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"
                 create_table "user_contest_stats", :force => true 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", :force => true 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"
                 end
                 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
               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

r528:dfe79b5eef35 - Thu, 27 Aug 2015 13:31:02 - 7 files changed: 137 inserted, 28 deleted

Sign in to your account

Commit r528:dfe79b5eef35 public

Author

r528:dfe79b5eef35 - Thu, 27 Aug 2015 13:31:02 - 7 files changed: 137 inserted, 28 deleted

Commit `r528:dfe79b5eef35` public