import sqlite3
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import Column, Integer, String
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite:///englishcourse', convert_unicode=True)
#engine = create_engine('sqlite:////dbhandler/englishcourse', convert_unicode=True)
db_session = scoped_session(sessionmaker(autocommit=False,
                                         autoflush=False,
                                         bind=engine))
Base = declarative_base()
Base.query = db_session.query_property()

class User(Base):
    __tablename__ = 'tbl_user'
    id = Column(Integer, primary_key=True)
    name = Column(String(50), unique=True)
    email = Column(String(200), unique=True)
    grade = Column(String(50), unique=True)
    category = Column(String(50), unique=True)
    username = Column(String(50), unique=True)
    password = Column(String(50), unique=True)

    def __init__(self, name=None, email=None,grade=None,
                 category=None,username=None,password=None):
        self.name = name
        self.email = email
        self.grade = grade
        self.category = category
        self.username = username
        self.password = password

    def __repr__(self):
        return '<User %r>' % (self.name)

#Base.metadata.create_all(bind=engine)

andres = User ('andres lastname','andres@colegiocarrasquilla.com',
             '1102','student','andres','abc123')
db_session.add(andres)
db_session.commit

print(User.query.all())