1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
import os
from flask import Flask
from flask import render_template, request
from flask_sqlalchemy import SQLAlchemy
from flask_restful import Resource, Api
from marshmallow_sqlalchemy import ModelSchema
app = Flask(__name__)
app.config.update({
'SQLALCHEMY_DATABASE_URI': os.environ['DATABASE_URL'],
'SQLALCHEMY_TRACK_MODIFICATIONS': False
})
db = SQLAlchemy(app)
api = Api(app)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80))
email = db.Column(db.String(120), unique=True)
def __init__(self, name, email):
self.name = name
self.email = email
def __repr__(self):
return '<Name %r>' % self.name
class UserSchema(ModelSchema):
class Meta:
model = User
class UserResource(Resource):
def get(self, user_id):
user = User.query.get(user_id)
return UserSchema().dump(user)
def put(self, user_id):
user = User.query.get(user_id)
UserSchema().load(request.form, instance=user, session=db.session)
db.session.commit()
return 'updated'
def delete(self, user_id):
user = User.query.get(user_id)
db.session.delete(user)
db.session.commit()
class UserListResource(Resource):
def get(self):
users = User.query.all()
return UserSchema(many=True).dump(users)
def post(self):
user = UserSchema().load(request.form, session=db.session).data
db.session.add(user)
db.session.commit()
return 'created'
@app.route('/')
def home():
return render_template('index.html')
@app.route('/robots.txt')
def robots():
res = app.make_response('User-agent: *\nAllow: /')
res.mimetype = 'text/plain'
return res
api.add_resource(UserListResource, '/users/')
api.add_resource(UserResource, '/users/<user_id>/')
if __name__ == '__main__':
app.run(host='0.0.0.0', debug=True)
|
