from flask import render_template, redirect, request, jsonify
from flask_babel import gettext
from flask_login import login_user, current_user,  logout_user, login_required
from flask import current_app as k2
from flask import Blueprint, json
from flask_sqlalchemy import SQLAlchemy


#bliueprint
k2test = Blueprint('k2test', __name__, template_folder='templates', static_folder='static')

#component routes
@k2test.route('/new')
def new_component():    
    db = k2.extensions['sqlalchemy'].db
    connection = db.engine.connect()
    query = db.text("SELECT email, login FROM k2users")
    result = connection.execute(query).fetchall()
    rows = [dict(email=row.email, login=row.login) for row in result]
    # Перетворення результату на JSON
    json_result = json.dumps(rows)
    return json_result

@k2test.route('/new2')
def new_component2():
    return render_template('new2.html')
    
@k2test.route('/new3')
def new_component3():
    return jsonify({'data': 'page new3'})
   
@k2test.route('/new4')
def new_component4():
    return jsonify({'data': 'page new4'})

# menu items for admin
@k2test.route('/menu-admin-items')
def menu_items():
    data = [
        {
            'title': 'Test items',
            'icon': {'icon': 'mdi-chart-timeline-variant'},
            'children': [
                {'title': 'Test 3', 'to': 'k2test-new3'},
                {'title': 'Test 4', 'to': 'k2test-new4'},
                {'title': 'Test 5', 'to': 'k2test-new5'},
                {'title': 'Test 6', 'to': 'k2test-new6'},
                {'title': 'Test 7', 'to': 'k2test-new7'}
            ],
        }

    ]
    return data