viadanna

from openedx.core.djangoapps.course_groups.models import CohortMembership

from common.djangoapps.course_modes.models import CourseMode
from opaque_keys.edx.keys import CourseKey
from common.djangoapps.student.models import CourseEnrollment
from django.contrib.auth import get_user_model


def enroll(username='edx', course_key='course-v1:edX+DemoX+Demo_Course'):
    user = get_user_model().objects.get(username=username)

viadanna

Periodic Reports Workshop

Welcome to the workshop. Here we'll get a hands-on approach on creating periodic reports on a sandbox provided by OpenCraft.

Sandbox Instructions

1. Register an account on the provided sandbox

https://lilac-periodic-reports.opencraft.hosting

viadanna

ALTER TABLE social_auth_usersocialauth MODIFY uid VARCHAR(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL

"""
# Confirming issue
from social_django.models import UserSocialAuth
>>> UserSocialAuth.objects.select_related("user").get(provider="edx-oauth2", uid="test1")
<UserSocialAuth: test1>
>>> UserSocialAuth.objects.select_related("user").get(provider="edx-oauth2", uid="TEST1")
<UserSocialAuth: test1>