Guest User

Untitled

a guest
Nov 18th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. Base = declarative_base(cls=Base)
  2. class Training(Entity, Base):
  3. id = Column(BigInteger, Sequence('training_id_seq', start=1, increment=1))
  4. meet = Column(Integer, primary_key=True, default=Constants.DefaultInteger)
  5. trdate = Column(Date, primary_key=True)
  6. hrno = Column(String, primary_key=True)
  7. sptime = Column(DateTime, primary_key=True)
  8. part = Column(String, nullable=True)
  9. partno = Column(String, nullable=True)
  10.  
  11. app = Flask('rest-api', template_folder='../templates', static_folder='../static')
  12. CORS(app)
  13.  
  14. @app.errorhandler(InvalidUsage)
  15. def handle_invalid_usage(error):
  16. response = jsonify(error.to_dict())
  17. response.status_code = error.status_code
  18. return response
  19.  
  20.  
  21. if __name__ == "__main__":
  22. app.config['SQLALCHEMY_DATABASE_URI'] = ServerConstants.FUNDAMENTAL_DB
  23. app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
  24. app.register_blueprint(training_api)
  25. app.run(host=ServerConstants.host, port=ServerConstants.port, debug=ServerConstants.debug,
  26. ssl_context=('cert.pem', 'key.pem'))
  27.  
  28. training_api = Blueprint('training_api', __name__)
  29.  
  30. @training_api.route("/training/get", methods=['GET'])
  31. def get_training():
  32. **session = Connector.Session()**
  33.  
  34. query = session.query(Training)
  35. query = order_by_latest(query, Training)
  36. query = add_pagination(request, query)
  37. trainings = query.all()
  38.  
  39. **session.close()**
  40.  
  41. return respond_with_json({'trainings': [t.toDict() for t in trainings]})
  42.  
  43. from sqlalchemy.orm import sessionmaker
  44. from tools import ServerConstants
  45.  
  46. Session = sessionmaker(bind=ServerConstants.ENGINE)
  47.  
  48. db = SQLAlchemy(app)
  49. db.session.query(Training)
  50. ...
  51.  
  52. session.connection()
Add Comment
Please, Sign In to add comment