Created
September 2, 2020 04:56
-
-
Save DevopsVlogger/7cf6e2246d48dd17796259f7dbcc9376 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import os | |
| from flask import Flask | |
| from flaskext.mysql import MySQL # For newer versions of flask-mysql | |
| # from flask.ext.mysql import MySQL # For older versions of flask-mysql | |
| app = Flask(__name__) | |
| mysql = MySQL() | |
| mysql_database_host = 'MYSQL_DATABASE_HOST' in os.environ and os.environ['MYSQL_DATABASE_HOST'] or 'localhost' | |
| # MySQL configurations | |
| app.config['MYSQL_DATABASE_USER'] = 'db_user' | |
| app.config['MYSQL_DATABASE_PASSWORD'] = 'Passw0rd' | |
| app.config['MYSQL_DATABASE_DB'] = 'employee_db' | |
| app.config['MYSQL_DATABASE_HOST'] = mysql_database_host | |
| mysql.init_app(app) | |
| conn = mysql.connect() | |
| cursor = conn.cursor() | |
| @app.route("/") | |
| def main(): | |
| return "Welcome!" | |
| @app.route('/how are you') | |
| def hello(): | |
| return 'I am good, how about you?' | |
| @app.route('/read from database') | |
| def read(): | |
| cursor.execute("SELECT * FROM employees") | |
| row = cursor.fetchone() | |
| result = [] | |
| while row is not None: | |
| result.append(row[0]) | |
| row = cursor.fetchone() | |
| return ",".join(result) | |
| if __name__ == "__main__": | |
| app.run() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment