Skip to content

Instantly share code, notes, and snippets.

@roblayton
Created June 6, 2015 23:14
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save roblayton/a682299af39b76d8592f to your computer and use it in GitHub Desktop.
Save roblayton/a682299af39b76d8592f to your computer and use it in GitHub Desktop.
Python Flask server for returning names from a MySQL DB
from flask import Flask
from flask import g
from flask import Response
from flask import request
import json
import MySQLdb
app = Flask(__name__)
@app.before_request
def db_connect():
g.conn = MySQLdb.connect(host='192.168.33.10',
user='test',
passwd='password',
db='test')
g.cursor = g.conn.cursor()
@app.after_request
def db_disconnect(response):
g.cursor.close()
g.conn.close()
return response
def query_db(query, args=(), one=False):
g.cursor.execute(query, args)
rv = [dict((g.cursor.description[idx][0], value)
for idx, value in enumerate(row)) for row in g.cursor.fetchall()]
return (rv[0] if rv else None) if one else rv
@app.route("/")
def hello():
return "Hello World!"
@app.route("/names", methods=['GET'])
def names():
result = query_db("SELECT firstname,lastname FROM test.name")
data = json.dumps(result)
resp = Response(data, status=200, mimetype='application/json')
return resp
@app.route("/add", methods=['POST'])
def add():
req_json = request.get_json()
g.cursor.execute("INSERT INTO test.name (firstname, lastname) VALUES (%s,%s)", (req_json['firstname'], req_json['lastname']))
g.conn.commit()
resp = Response("Updated", status=201, mimetype='application/json')
return resp
if __name__ == "__main__":
app.run()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment