#routes/user.py
from bottle import Bottle, redirect
from controllers.login import checkLogged

import bottle
bottle.BaseRequest.MEMFILE_MAX = 1024 * 1024

app = Bottle()

@app.route('/')
def index():
    if checkLogged.call():
        from controllers.dashboard.user import get
        return get.call()
    else:
        redirect('/')

@app.route('/', method='post')
def index():
    if checkLogged.call():
        from controllers.dashboard.user import create
        return create.call()
    else:
        redirect('/')

#controllers/dashboard/user/create.py
import uuid, base64
from bottle import request, redirect
from models.userdb import createdb

def call():
    name = request.forms.getunicode('name')
    thumb = request.forms.getunicode('thumb')
    datetime = request.forms.getunicode('datetime')
    email = request.forms.getunicode('email')
    password = request.forms.getunicode('password')
    password = password.encode("utf-8")
    password = base64.b64encode(password)
    edit = request.forms.getunicode('editid')
    content = request.forms.getunicode('content')
    role = request.forms.getunicode('role')
    entries = request.forms.getunicode('entries')

    if not edit:
        id = uuid.uuid4().hex
    else:
        id = edit

    createdb.call(name, thumb, datetime, email, password, content, id, role, entries, edit)

    return redirect('/dashboard/user')

#models/userdb/createdb.py
import setConnection

def call(name, thumb, datetime, email, password, content, id, role, entries, edit):
    cursor, connection = setConnection.call()

    if not edit:
        sql = "INSERT INTO users VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)"
        cursor.execute(sql, (name, thumb, datetime, email, password, content, id, role, entries))
    else:
       pass

    connection.commit()
    cursor.close()

<!--views/dashboard/user.tpl-->
<link rel='stylesheet' href='/static/styles/post.css' />
<script src="/static/scripts/ckeditor/ckeditor.js"></script>
<script src="/static/scripts/video.js"></script>

<style>
.Main .content form .wrapper{
    margin-top:5px;
    display: grid;
    grid-template-columns: 13% 15% 22% 22% auto 15%;
}
</style>

<section class='Main'>
    <div class='content'>
        <form action='/dashboard/user' method='post' >
            %if 'edit' in data:
            
            %else:
            <input type='text' name='name' placeholder='ឈ្មោះ' required />
            <textarea name="content" id="editor" ></textarea>
            <div class='wrapper'>
                <select name='role'>
                    <option>Author</option>
                    <option>Admin</option>
                </select>
                <input type='text' name='thumb' required placeholder="​រូប​តំណាង" />
                <input type='datetime-local' value='' name='datetime' required />
                <input type='email' name='email' required placeholder="Email" />
                <input type='password' name='password' required placeholder="password" />
                <input type='hidden' name='editid' value='' />
                <input type='submit' value='ចុះ​ផ្សាយ' />
            </div>
            <input name='entries' value='' type='hidden' />
            %end
        </form>

        <div class='form'>
            <select name='type'>
                <option>YouTube</option>
                <option>YouTubePlaylist</option>
                <option>Facebook</option>
                <option>OK</option>
                <option>Dailymotion</option>
                <option>Vimeo</option>
            </select>
            <input name='id' type='text' placeholder="អត្តសញ្ញាណវីដេអូ" required />
            <select name='ending'>
                <option>ចប់​ហើយ</option>
                <option>មិន​ទាន់ចប់</option>
            </select>
            <input onclick='genJson()' type="button" value="បញ្ចូល​វីដេអូ" />
        </div>

        <table class='viddata'></table>
        
        %if 'edit' in data:
            <script>
                var entries = JSON.parse('{{!data["item"][6]}}')
            </script>
        %end

        <script>
        if(entries.length > 0){

            let html = ``
            for(let v in entries){
                episode += 1
                html += `<tr>`
                html += `<td title="Delete" onClick="deleteRow(event)" class="episode">${episode}</td>`
                html += `<td class="td${episode}">${entries[v].type}</td>`
                html += `<td class="td${episode}">${entries[v].id}</td>`
                html += `<td class="td${episode}">${entries[v].ending}</td>`
                html += `</tr>`
            }

            if($('.viddata').html() === ''){
                $('.viddata').append('<tr>')
                $('.viddata').append('<th>ភាគ/លុប</th>')
                $('.viddata').append('<th>ប្រភេទ​</th>')
                $('.viddata').append('<th>អត្តសញ្ញាណ​</th>')
                $('.viddata').append('<th>ចប់ឬ​នៅ?</th>')
                $('.viddata').append('</tr>')
            }

            $('.viddata').append(`${html}`)

        }
        </script>

        <script src="/static/scripts/ckeditor/config.js"></script>
    </div>
</section>

GitHub: https://github.com/Sokhavuth/REST-API

Vercel: https://rest-api-zeta.vercel.app