def set_name(course_id, name):
""" Set the name of a course."""
assert isinstance(course_id, int)
assert isinstance(name, str) or isinstance(name, unicode)
run_sql("UPDATE courses SET title = %s WHERE course = %s;", [name, course_id])
key = "course-%s-name" % course_id
MC.delete(key)
def add_perm(uid, course_id, perm):
""" Assign a permission."""
key = "permission-%s-super" % (uid, )
MC.delete(key)
run_sql(
"""INSERT INTO permissions (course, userid, permission)
VALUES (%s, %s, %s) """, (course_id, uid, perm))
def set_name(course_id, name):
""" Set the name of a course."""
assert isinstance(course_id, int)
assert isinstance(name, str) or isinstance(name, unicode)
incr_version()
run_sql("UPDATE courses SET title=%s WHERE course=%s;", (name, course_id))
key = "course-%s-name" % course_id
MC.delete(key)
def set_title(course_id, title):
# type: (int, str) -> None
""" Set the title of a course."""
assert isinstance(course_id, int)
assert isinstance(title, str) or isinstance(title, unicode)
run_sql("UPDATE courses SET description = %s WHERE course = %s;",
[title, course_id])
key = "course-%s-title" % course_id
MC.delete(key)
def delete_perm(uid, group_id, perm):
"""Remove a permission. """
key = "permission-%s-super" % (uid,)
MC.delete(key)
run_sql("""DELETE FROM permissions
WHERE userid=%s
AND course=%s
AND permission=%s""",
[uid, group_id, perm])
def set_title(course_id, title):
""" Set the title of a course."""
assert isinstance(course_id, int)
assert isinstance(title, str) or isinstance(title, unicode)
incr_version()
run_sql("UPDATE courses SET description=%s WHERE course=%s;",
(title, course_id))
key = "course-%s-title" % course_id
MC.delete(key)
def set_title(course_id, title):
""" Set the title of a course."""
assert isinstance(course_id, int)
assert isinstance(title, str) or isinstance(title, unicode)
incr_version()
run_sql("UPDATE courses SET description=%s WHERE course=%s;",
(title, course_id))
key = "course-%s-title" % course_id
MC.delete(key)
def delete_perm(uid, group_id, perm):
"""Remove a permission. """
key = "permission-%s-super" % (uid, )
MC.delete(key)
run_sql(
"""DELETE FROM permissions
WHERE userid=%s
AND course=%s
AND permission=%s""", (uid, group_id, perm))
def incr_version():
""" Increment the course table version."""
key = "coursetable-version"
MC.delete(key)
ret = run_sql("SELECT nextval('courses_version_seq');")
if ret:
MC.set(key, int(ret[0][0]))
return int(ret[0][0])
L.error("Error incrementing Courses version.")
return -1
def incr_version():
""" Increment the course table version."""
key = "coursetable-version"
MC.delete(key)
ret = run_sql("SELECT nextval('courses_version_seq');")
if ret:
MC.set(key, int(ret[0][0]))
return int(ret[0][0])
L.error("Error incrementing Courses version.")
return -1
def incr_version():
""" Increment the user table version.
"""
key = "userstable-version"
MC.delete(key)
ret = run_sql("SELECT nextval('users_version_seq');")
if ret:
MC.set(key, int(ret[0][0]))
return int(ret[0][0])
log(ERROR, "Error incrementing version.")
return -1
def set_active(course_id, active):
""" Set the active flag of a course."""
assert isinstance(course_id, int)
assert isinstance(active, bool)
if active:
val = 1
else:
val = 0
run_sql("UPDATE courses SET active=%s WHERE course=%s;", (val, course_id))
incr_version()
key = "course-%s-active" % course_id
MC.delete(key)
key = "courses-active"
MC.delete(key)
def set_active(course_id, active):
""" Set the active flag of a course."""
assert isinstance(course_id, int)
assert isinstance(active, bool)
if active:
val = 1
else:
val = 0
run_sql("UPDATE courses SET active=%s WHERE course=%s;", (val, course_id))
incr_version()
key = "course-%s-active" % course_id
MC.delete(key)
key = "courses-active"
MC.delete(key)
def create(name, description, owner, coursetype):
""" Add a course to the database."""
res = run_sql("""INSERT INTO courses (title, description, owner, type)
VALUES (%s, %s, %s, %s) RETURNING course;""",
(name, description, owner, coursetype))
incr_version()
key = "courses-active"
MC.delete(key)
key = "courses-all"
MC.delete(key)
if res:
return int(res[0][0])
L.error("create('%s','%s',%d,%d) Fail" % (name, description, owner, coursetype))
return 0
def create(name, description, owner, coursetype):
""" Add a course to the database."""
res = run_sql(
"""INSERT INTO courses (title, description, owner, type)
VALUES (%s, %s, %s, %s) RETURNING course;""",
(name, description, owner, coursetype))
incr_version()
key = "courses-active"
MC.delete(key)
key = "courses-all"
MC.delete(key)
if res:
return int(res[0][0])
L.error("create('%s','%s',%d,%d) Fail" %
(name, description, owner, coursetype))
return 0
def create(name, description, owner, coursetype):
""" Add a course to the database."""
conn = dbpool.begin()
conn.run_sql("""INSERT INTO courses (title, description, owner, type)
VALUES (%s, %s, %s, %s);""",
(name, description, owner, coursetype))
res = conn.run_sql("SELECT currval('courses_course_seq')")
dbpool.commit(conn)
incr_version()
key = "courses-active"
MC.delete(key)
key = "courses-all"
MC.delete(key)
if res:
return int(res[0][0])
log(ERROR,
"create('%s','%s',%d,%d) Fail" % (name, description, owner, coursetype))
return 0
def set_active(course_id, active):
""" Set the active flag of a course.
:param course_id: the course to alter
:type course_id: int
:param active: whether the course is active or not
:type active: bool
"""
assert isinstance(course_id, int)
assert isinstance(active, bool)
if active:
val = 1
else:
val = 0
run_sql("UPDATE courses SET active = %s WHERE course = %s;", [val, course_id])
key = "course-%s-active" % course_id
MC.delete(key)
key = "courses-active"
MC.delete(key)
def add_perm(uid, course_id, perm):
""" Assign a permission."""
key = "permission-%s-super" % (uid,)
MC.delete(key)
run_sql("""INSERT INTO permissions (course, userid, permission)
VALUES (%s, %s, %s) """, [course_id, uid, perm])
