register

from flask import Flask, render_template,request,flash,redirect, url_for,logging,session
import hashlib
from flaskext.mysql import MySQL
#from flask_mysql import MySQL
from wtforms import Form,StringField, TextAreaField, validators,PasswordField
from werkzeug.security import generate_password_hash, check_password_hash
from passlib.hash import sha256_crypt

app = Flask(__name__)

mysql =MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD']='1515'
app.config['MYSQL_DATABASE_DB']='hotel'
app.config['MYSQL_DATABASE_HOST']='localhost'
app.config['MYSQL_DATABASE_CURSORCLASS']='DictCursor'

mysql.init_app(app)


class RegisterForm(Form):
    name=StringField('name', [validators.Length(min=5, max=20)])
    username=StringField('username', [validators.Length(min=5, max=20)])
    email=StringField('email', [validators.Length(min=5, max=50)])
    password=PasswordField('password', [
        validators.DataRequired(),
        validators.EqualTo('confirm', message='password do not match')])
    confirm=PasswordField('Confirm password')



#about register
@app.route('/register/', methods=['GET', 'POST'])
def register():
    form = RegisterForm(request.form)
    if request.method == 'POST' and form.validate():
        name = form.name.data
        username = form.username.data
        email = form.email.data
        password = sha256_crypt.encrypt(str(form.password.data))

        #creating curso
        # cursor = mysql.connect.cursor()
        #cursor=db.cursor()
        try:
            conn =mysql.connect()
            cursor =conn.cursor()
            cursor.execute("INSERT INTO user (name, username, email, password) VALUES(%s, %s, %s, %s)",(name, username, email, password))
            conn.commit()
            msg='record successfull added'
        except:
            msg='Fail to add record'

        #cur.close()
            #flash('done your registerd')
            redirect(url_for('new.html'))
        finally:
            return render_template('test.html',msg=msg)


    return render_template('register.html', form=form)

########################################
####Then the Register Form WTForm ######
########################################

{% extends 'layout.html' %}

{% block body %}

        {% from "includes/_formhelpers.html" import render_field %}

        <h1>REGISTER</h1>

            <form method="POST" action="/register/">
              <div class="form-group">
                {{render_field(form.name, class_="form-control")}}
              </div>

               <div class="form-group">
                {{render_field(form.username, class_="form-control")}}
              </div>

               <div class="form-group">
                {{render_field(form.email, class_="form-control")}}
              </div>

               <div class="form-group">
                {{render_field(form.password, class_="form-control")}}
              </div>

               <div class="form-group">
                {{render_field(form.confirm, class_="form-control")}}
              </div>
              <button id="btnLogin" class="btn btn-lg btn-primary btn-block" type="submit">submit</button>
         </form>
        </div>
{%  endblock %}