Beispiel #1
0
def syncAssignment(gradesourceId, taId):
    conn = MySQLdb.connect(host = "localhost", user = "******", passwd = "root", db = "ta")
    cursor = conn.cursor()

    sql = """SELECT sc.*, st.gs_name
             FROM scores sc
             LEFT JOIN students st ON st.id = sc.student_id
             WHERE assignment_id = '%s'
             AND st.dropped = 0
             """ % taId
    cursor.execute(sql)

    scores = {}
    while True:
        row = fetchOneAssoc(cursor)
        if row == None:
            break
        print colored(row['score'], 'green'), row['gs_name']
        scores[row['gs_name']] = row['score']

    g = Gradesource('qpleple', getpass())
    g.importScores(scores, gradesourceId, gradesourceName = True)

    cursor.close()
    conn.commit()
    conn.close()
Beispiel #2
0
def temp(csvPath, col):
  config = utils.getConfig()
  reader = csv.reader(open(csvPath, 'rU'), delimiter=',')
  data = [{'name': "{0[0]}, {0[1]}".format(row), 'score': row[col], 'pid': row[2]} for row in reader if row[col] not in [0, '0', '-', '']]
  utils.check("Data: ", data)

  g = Gradesource(config['gradesourceLogin'], config['gradesourcePasswd'])
  g.importScoresBy(data, 'pid')
Beispiel #3
0
def uploadClickerScores(csvPath, col):
  config = utils.getConfig()

  reader = csv.reader(open(csvPath, 'rU'), delimiter=',')
  # Fields: 0:LN, 1:FN, 2:id, >2:scores
  data = [{'name': '%s, %s' % (row[0], row[1]), 'score': row[col], 'pid': row[2]} for row in reader if row[col] not in [0, '0', '-', '']]
  utils.check("Clicker data: ", data)

  g = Gradesource(config['gradesourceLogin'], config['gradesourcePasswd'])
  g.importScoresBy(data, 'pid')
Beispiel #4
0
def uploadMoodleQuizScores():
  config = utils.getConfig()

  m = Moodle(config['moodleLogin'], config['moodlePasswd'])
  _, scores = m.getScores(config['moodleCourseId'])
  # Fields: 0:FN, 1:LN, 2:pid, 3:inst, 4:dpt, 5:email, 6:total, 7:score
  data = [{'name': '%s, %s' % (row[1], row[0]), 'score': row[7], 'pid': row[2], 'email': row[5]} for row in scores if row[7] not in [0, '0', '-', '']]
  
  utils.check("Moodle data: ", data)

  g = Gradesource(config['gradesourceLogin'], config['gradesourcePasswd'])
  g.importScoresBy(data, 'pid')
Beispiel #5
0
def importGradesourceNamesInMySQL(mysqlClassId):
  config = utils.getConfig()
  g = Gradesource(config['gradesourceLogin'], config['gradesourcePasswd'])
  infos = g.studentsInfo()
  
  db = torndb.Connection("localhost", "ta", user = "******", password = "******")
  for name, info in infos.items():
    sql = "SELECT id FROM students WHERE gs_name = %s AND pid = %s AND email = %s"
    if not db.get(sql, name, info['pid'], info['email']):
      sql = "INSERT INTO students (gs_name, pid, email, class_id) VALUES (%s, %s, %s, %s)"
      db.execute(sql, name, info['pid'], info['email'], mysqlClassId)
      cprint("%s not found, inserting" % name, 'green')
    else:
      print "%s found, doing nothing" % name
Beispiel #6
0
def getFeedback(reportId, column):
  gradesource = Gradesource('quentin', getpass('Gradesource password: '******'Emails', emails)

  moodle = Moodle('qpleple', getpass('Moodle password: '******'Feedback', feedback)
  
  GSnames = gradesource.matchNames(feedback.keys(), emails.keys())
  
  data = {}
  for name, content in feedback.items():
    # print '%s %s %s' % (name, colored(email, 'blue'), colored(content, 'green'))
    # answer = raw_input()
    data[name] = {
      'email': emails[GSnames[name]],
      'feedback': content,
    }
    
  utils.check('Feedback', data)
  
  return data
Beispiel #7
0
# -*- coding: utf-8 -*-

import re, sys, csv, pickle
from termcolor import colored, cprint
from gradesource import Gradesource
import utils

# Read the CSV files for grades
csvPath = sys.argv[1]
lines = list(csv.reader(open(csvPath, 'rU'), delimiter = ','))
first_line = lines[0]
# ignore 1st line and lines starting by '#' (unregistered clickers)
lines = [l for l in lines[1:] if l[0][0] != '#']

# Ask for the column to pick in theh file
for col, title in enumerate(first_line):
  print colored(col, 'green') + ' ' + title
pid_col   = int(raw_input(colored('PID column ? ', 'green')))
score_col = int(raw_input(colored('Score column ? ', 'green')))

# Keep only lines with non-zero score
lines = [l for l in lines if l[score_col] not in [0, '0', '-', '']]
data  = [{'score': l[score_col], 'pid': l[pid_col]} for l in lines]

# Ask for the assessment to upload the grade
config = utils.getConfig()
g = Gradesource(config['gradesourceLogin'], config['gradesourcePasswd'])
g.importScoresBy(data, 'pid')