import os
from flask import Flask, render_template
from flask_script import Manager
from flask_bootstrap import Bootstrap
from flask_login import LoginManager
from flask_wtf import Form
from wtforms import StringField, PasswordField, BooleanField, SubmitField, IntegerField, DecimalField, FileField
from wtforms.validators import Required, Length, Email, Regexp, EqualTo
from flask_sqlalchemy import SQLAlchemy

basedir=os.path.abspath(os.path.dirname(__file__))

app=Flask(__name__)
app.config['SECRET_KEY']='Monchi'
app.config['SQLALCHEMY_DATABASE_URI']= 'sqlite:///'+os.path.join(basedir, 'data.sqlite')
app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN']=True
db=SQLAlchemy(app)
bootstrap=Bootstrap(app)
manager=Manager(app)


#this is the table inside the database, but the tablename has been changed.
class User(db.Model):
    __tablename__='users'
    id=db.Column(db.Integer, primary_key=True)
    email=db.Column(db.String(64), unique=True, index=True)
    password=db.Column(db.String(128))

class RegistrationForm(Form):
    email=StringField('email', validators=[Required(),Length(1,10)])
    #areacode=IntegerField(validators=[Required()])
    password=PasswordField(validators=[Required(), Length(1,10)])
    submit=SubmitField('register')

    def validate_email(self, field):
        if User.query.filter_by(email=field.data).first():
            raise ValidationError('Email already registerrred')


# class buttonform(Form):
#   button=BooleanField()
#   decimal=DecimalField()
#   image=FileField()

@app.route('/', methods=['GET', 'POST'])
def register():
    form=RegistrationForm()
    #form2=buttonform()
    if form.validate_on_submit():
        user=User(email=form.email.data, password=form.password.data)
        # if user is None:
        # user=User(email=form.email.data, password=form.password.data)
        db.session.add(user)


    return render_template('login.html', form2=form)


if __name__=='__main__':
    db.drop_all()
    db.create_all()
    manager.run()