Seeking Expert Assistance: Migrating a Learning Management System (LMS) With Video Upload Features to Deta.sh Bases and Drives

[realmranshuman]

What Do I Need Help With?

I am trying to migrate my project from a SQLite database to Deta and I am having trouble figuring out how to use Deta's Drive to upload videos while maintaining the folder structure. Could someone please provide guidance on this? I am able to use Deta's Bases, but I am unfamiliar with using the Drive feature. Any help would be greatly appreciated. Thanks!

@app.post("/upload-video/")
async def uploadVideoPost (request: Request, title: str = Form(...), description: str = Form(...), file: UploadFile = File(...)):
    email = request.session.get('email')
    result = db.get(email)
    user = result['user_details']
    user_course = user['course']

    # Use the user's course if the user is a teacher,
    course = user_course

    # Get the base file name and file extension
    base_name, file_extension = os.path.splitext(file.filename)

    # Set the initial file path
    file_path = "static/uploads/" + course + "/" + file.filename

    # Set the thumbnail folder path
    thumbnail_folder = "static/uploads/" + course + "/thumbnail"

    # Set the initial file name
    new_filename = file.filename

    # Set the initial thumbnail image name
    new_thumbnail_name = base_name + "-thumbnail" + file_extension

    # Set the initial counter to 1
    counter = 1

    # Loop until we find a filename that does not exist yet
    while os.path.exists(file_path):
        # Increment the counter
        counter += 1

        # Generate the new filename
        new_filename = base_name + " (" + str(counter) + ")" + file_extension

        # Update the file path
        file_path = "static/uploads/" + course + "/" + new_filename

        # Generate the new thumbnail image name
        new_thumbnail_name = base_name + " (" + str(counter) + ")" + file_extension

        # Update the thumbnail image path
        thumbnail_path = os.path.join(thumbnail_folder, new_thumbnail_name)

    # Create the thumbnail folder if it does not exist
    if not os.path.exists(thumbnail_folder):
        os.makedirs(thumbnail_folder)

    # Save the uploaded file to the specified folder
    with open(file_path, "wb") as f:
        f.write(file.file.read())

    # Generate the thumbnail image using MoviePy
    video = mpy.VideoFileClip(file_path)
    thumbnail_filename = os.path.splitext(new_filename)[0] + '.jpg'
    thumbnail_path = os.path.join(thumbnail_folder, thumbnail_filename)
    thumbnail = video.save_frame(thumbnail_path, t='00:00:01')
    video.close()

    # Execute an INSERT statement to add the file path to the database
    # Open a connection to the database
    try:
        db.insert({"key": title,"video": {"title": title, "description": description,"course": course, "file_path": file_path, "thumbnail_path": thumbnail_path,}})
    except Exception as e:
        # If a unique constraint error occurs, return a redirect response with a message
        request.session["message"] = 'A video with the same title already exists. Make sure that you are uploading the right video. If yes, please change the title.'
        return RedirectResponse("/upload-video/", status_code=status.HTTP_302_FOUND)

    # return {"filename": file.filename, "file_path": file_path}
    return RedirectResponse(f"/{course}/course-videos/", status_code=status.HTTP_302_FOUND)

The Modified Code That I Wrote Which Doesn't Work:

@app.post("/upload-video/")
async def uploadVideoPost (request: Request, title: str = Form(...), description: str = Form(...), file: UploadFile = File(...)):
    email = request.session.get('email')
    result = db.get(email)
    user = result['user_details']
    user_course = user['course']

    # Use the user's course if the user is a teacher,
    course = user_course

    # Get the base file name and file extension
    base_name, file_extension = os.path.splitext(file.filename)

    # Set the thumbnail folder path
    thumbnail_folder = "static/uploads/" + course + "/thumbnail"

    # Set the initial file name
    new_filename = file.filename

    # Set the initial thumbnail image name
    new_thumbnail_name = base_name + "-thumbnail" + file_extension
    # Set the initial file path
    file_path = f"static/uploads/{course}/{new_filename}"

    # Generate the thumbnail image using MoviePy
    video = mpy.VideoFileClip(file_path)
    thumbnail_filename = os.path.splitext(new_filename)[0] + '.jpg'
    thumbnail_path = os.path.join(thumbnail_folder, thumbnail_filename)
    thumbnail = video.save_frame(thumbnail_path, t='00:00:01')
    video.close()

    # Set the initial counter to 1
    counter = 1

    # Loop until we find a filename that does not exist yet
    while drive.get(file_path):
        # Increment the counter
        counter += 1

        # Generate the new filename
        new_filename = base_name + " (" + str(counter) + ")" + file_extension

        # Update the file path
        file_path = "static/uploads/" + course + "/" + new_filename

        # Generate the new thumbnail image name
        new_thumbnail_name = base_name + " (" + str(counter) + ")" + file_extension

        # Update the thumbnail image path
        thumbnail_path = os.path.join(thumbnail_folder, new_thumbnail_name)

    # Save the uploaded file to a buffer
    buffer = file.file.read()

    # Set the file path for Deta's Drive
    file_path = f"static/uploads/{course}/{new_filename}"

    # Save the file to Deta's Drive
    drive.put(file_path, buffer, content_type=file.content_type)

    # Generate the thumbnail image using MoviePy, but save it to a buffer instead of a local file
    thumbnail_buffer = video.save_frame(thumbnail_path, t='00:00:01')

    # Set the thumbnail file path for Deta's Drive
    thumbnail_path = os.path.join(thumbnail_folder, thumbnail_filename)

    # Save the thumbnail image to Deta's Drive
    drive.put(thumbnail_path, thumbnail_buffer, content_type='image/jpeg')

    # Create the thumbnail folder if it does not exist
    if not drive.get(thumbnail_folder):
        drive.put(thumbnail_folder)

    # Execute an INSERT statement to add the file path to the database
    # Open a connection to the database
    try:
        db.insert({"key": title,"video": {"title": title, "description": description,"course": course, "file_path": file_path, "thumbnail_path": thumbnail_path,}})
    except Exception as e:
        # If a unique constraint error occurs, return a redirect response with a message
        request.session["message"] = 'A video with the same title already exists. Make sure that you are uploading the right video. If yes, please change the title.'
        return RedirectResponse("/upload-video/", status_code=status.HTTP_302_FOUND)

    # return {"filename": file.filename, "file_path": file_path}
    return RedirectResponse(f"/{course}/course-videos/", status_code=status.HTTP_302_FOUND)

What errors do I get /What Problems Do I have?

• 413: File entity too large (I am trying to upload a video which is just 35 MB)
• The video doesn't get uploaded to the drive.
• The folder structure isn't created
• I can't iterate through the files or files in a specific folder

My Project Link:

• Main Branch: LMS Using FastAPI And SQLite
• Deta.sh Version Branch: LMS Using FastAPI And SQLite