一站式网上办事大厅

from flask import Flask, request, jsonify

from sqlalchemy import create_engine, Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

app = Flask(__name__)

engine = create_engine('sqlite:///service.db')

Base = declarative_base()

Session = sessionmaker(bind=engine)

class User(Base):

__tablename__ = 'users'

id = Column(Integer, primary_key=True)

name = Column(String)

email = Column(String)

@app.route('/login', methods=['POST'])

def login():

data = request.get_json()

username = data['username']

password = data['password']

session = Session()

user = session.query(User).filter_by(name=username).first()

if user and user.password == password:

return jsonify({'status': 'success'})

else:

return jsonify({'status': 'fail'})

if __name__ == '__main__':

Base.metadata.create_all(engine)

app.run(debug=True)

]]>