Python Flask REST API Query Parameter GET Request

Python Flask REST API Query Parameter GET Request

--

-- Table structure for table `user`

--

CREATE TABLE `user` (

  `id` int(11) NOT NULL,

  `username` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--

-- Dumping data for table `user`

--

INSERT INTO `user` (`id`, `username`, `password`) VALUES

(1, 'tutorial101', 'pbkdf2:sha256:150000$KxxiGerN$4c37a656baa0034035a6be2cd698b5da8b036ae63eef3ab0b08b9c18b9765648');

--

-- Indexes for dumped tables

--

--

-- Indexes for table `user`

--

ALTER TABLE `user`

  ADD PRIMARY KEY (`id`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `user`

--

ALTER TABLE `user`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

http://127.0.0.1:5000/user?id=1
app.py

 
#app.py
from flask import Flask, jsonify, request
from flask_mysqldb import MySQL,MySQLdb #pip install flask-mysqldb https://github.com/alexferl/flask-mysqldb
from werkzeug.security import generate_password_hash, check_password_hash

app = Flask(__name__)
  
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'root'
app.config['MYSQL_PASSWORD'] = ''
app.config['MYSQL_DB'] = 'testingdb'
app.config['MYSQL_CURSORCLASS'] = 'DictCursor'
mysql = MySQL(app) 
 
@app.route('/')
def home():
    passhash = generate_password_hash('cairocoders')
    print(passhash)
    return 'Homepage'

@app.route('/user') 
def get_user():
	cursor = None;
	id = request.args.get('id')
	if id:
		cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor)
		cursor.execute("SELECT * FROM user WHERE id=%s", id)
		row = cursor.fetchone()
		resp = jsonify(row)
		resp.status_code = 200
		cursor.close() 
		return resp
	else:
		resp = jsonify('User "id" not found in query string')
		resp.status_code = 500
		return resp

if __name__ == "__main__":
    app.run()