Model User表

# model.py
from flask import flask
from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root@localhost/test'
db = SQLAlchemy(app)

class User(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	username = db.Column(db.String(32), unique=True)
	password = db.Column(db.String(32))

	def __init__(self, username, password):
		self.username = username
		self.password = password

	def add(self):
		try:
			db.session.add(self)
			db.session.commit()
		except Exception as e:
			db.session.rollback()
			return e
		finally:
			return 0
	def isExisted(self):
		temUser = User.query.filter_by(username=self.username, password=self.password).first()
		if temUser is None:
			return 0
		else:
			return 1