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

                   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)

app/controllers/graders_controller.rb ¶ +2

                     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])

db/schema.rb ¶ +34 -27

               # 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.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"
                 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"
                 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"
                   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"
                   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"
                   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