mjj88_.py

from flask import Flask, render_template
from flask_mail import Mail
import sqlite3 as sql
from sqlalchemy import create_engine
from flask_sqlalchemy import SQLAlchemy
from flask_security import Security, SQLAlchemyUserDatastore, \
    UserMixin, RoleMixin, login_required
from sqlalchemy.orm import sessionmaker
from sqlalchemy.sql import select
import mysql.connector as sql

app = Flask(__name__)

app.config['DEBUG'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SECRET_KEY'] = 'super-secret'
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://sql8130559:b4AmN8EzZB@:3306/sql8130559?charset=utf8'
app.config['SECURITY_REGISTERABLE'] = True
# After 'Create app'
app.config['MAIL_SERVER'] = 'smtp.yandex.com'
app.config['MAIL_PORT'] = 465
app.config['MAIL_USE_SSL'] = True
app.config['MAIL_USERNAME'] = ''
app.config['MAIL_PASSWORD'] = 'e58d'
app.config['SECURITY_EMAIL_SENDER'] = 'mo'
mail = Mail(app)

# Create database connection object
db = SQLAlchemy(app)

# Define models
roles_users = db.Table('roles_users',
        db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
        db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))

class Role(db.Model, RoleMixin):
    id = db.Column(db.Integer(), primary_key=True)
    name = db.Column(db.String(80), unique=True)
    description = db.Column(db.String(255))

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(255), unique=True)
    password = db.Column(db.String(255))
    active = db.Column(db.Boolean())
    confirmed_at = db.Column(db.DateTime())
    roles = db.relationship('Role', secondary=roles_users,
                            backref=db.backref('users', lazy='dynamic'))



#create db connection
# create a Session

# Setup Flask-Security
user_datastore = SQLAlchemyUserDatastore(db, User, Role)
security = Security(app, user_datastore)
engine = create_engine('mysql://sql8130559:b4AmN8EzZB@:3306/sql8130559?charset=utf8')
con = engine.connect()
# Create a user to test with
@app.before_first_request
# def create_user():
    # db.create_all()
    # user_datastore.create_user(email='mon', password='password')
    # db.session.commit()
# Views
@app.route('/')
@login_required
def home():
    return render_template('index.html')





@app.route("/topgroups")
@login_required
def topgroups():
    result = con.execute('select * from do_1 where AddDate < "2016-08-09" limit 50')

    return render_template("base.html", result = result)
    con.close()


@app.route("/sorted")
def sorted():


    return render_template("index.html", rows = rows)   

# @app.route("/home")
# def home():
    # con = sql.connect("C:\\Users\\win10\\YandexDisk\\apps\\flask\\new_file.sqlite")
    # con.row_factory = sql.Row

    # cur = con.cursor()
    # cur.execute("SELECT * from do_1")
    # rows = cur.fetchall();

    # return render_template("index.html", rows = rows, )
    # return hometitle

if __name__ == "__main__":
    app.run(debug=True)

Thank you!!