Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from flask import Flask, render_template, json, request
- from flask.ext.mysqldb import MySQL
- from werkzeug import generate_password_hash, check_password_hash
- app = Flask(__name__)
- mysql = MySQL(app)
- # MySQL configurations
- app.config['MYSQL_DATABASE_USER'] = 'root'
- app.config['MYSQL_DATABASE_PASSWORD'] = 'pass'
- app.config['MYSQL_DATABASE_DB'] = 'table'
- app.config['MYSQL_DATABASE_HOST'] = 'localhost'
- mysql.init_app(app)
- @app.route("/")
- def main():
- return render_template('index.html')
- @app.route('/showSignUp')
- def showSignUp():
- return render_template('signup.html')
- @app.route('/signUp', methods = ['POST','GET' ])
- def signUp():
- _phonenumber = request.form['phonenumber']
- _name = request.form['name']
- _password = request.form['password']
- if _phonenumber and _name and _password:
- conn = mysql.connect()
- cursor = conn.cursor()
- _hashed_password = generate_password_hash(_password)
- cursor.callproc('sp_createphoneuser', (_phonenumber,_name,_hashed_password))
- data = cursor.fetchall()
- if len(data) is 0:
- conn.commit()
- return json.dumps({'message':"User created successfully !"})
- else:
- return json.dumps({'error':str(data[0])})
- else:
- return json.dumps({'html':'<span>Enter the required fields</span>'})
- if __name__ == "__main__":
- app.debug = True
- app.run(port=5002)
- File "/home/john/FlaskApp/app.py", line 35, in signUp
- conn = mysql.connect()
- TypeError: 'Connection' object is not callable
- cur = mysql.connection.cursor()
Add Comment
Please, Sign In to add comment