from typing import List, Dict import simplejson as json from flask import Flask, request, Response, redirect from flask import render_template from flaskext.mysql import MySQL from pymysql.cursors import DictCursor app = Flask(__name__) mysql = MySQL(cursorclass=DictCursor) app.config['MYSQL_DATABASE_HOST'] = 'db' app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_PORT'] = 3306 app.config['MYSQL_DATABASE_DB'] = 'mlbPlayers' mysql.init_app(app) @app.route('/', methods=['GET']) def index(): user = {'username': '******'} cursor = mysql.get_db().cursor() cursor.execute('SELECT * FROM mlb_players') result = cursor.fetchall() return render_template('index.html', title='Home', user=user, Names=result) @app.route('/view/<string:Name>', methods=['GET']) def record_view(Name): cursor = mysql.get_db().cursor() cursor.execute('SELECT * FROM mlb_players WHERE Name =%s', Name)
from flaskext.mysql import MySQL other_module_path = r"C:\Python27\ArcGIS10.3\Lib\site-packages" sys.path.append(other_module_path) from wtforms import Form, StringField, TextAreaField, PasswordField, validators from passlib.hash import sha256_crypt from functools import wraps app = Flask(__name__) # Config MySQL app.config['MYSQL_DATABASE_HOST'] = 'localhost' app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'myflaskapp' mysql = MySQL() mysql.init_app(app) # Index @app.route('/') def index(): return render_template('home.html') # About @app.route('/about') def about(): return render_template('about.html') # Articles
from flask import Flask, jsonify, request from flaskext.mysql import MySQL import datetime from ReplaceDB import handleHourly, clientSummary, localSummary from RetrieveDB import dailyAll, daily, weekly, monthly, yearly, localAreaSummary from pymysql.cursors import DictCursor import json import ast mysql = MySQL() app = Flask(__name__) # MySQL configurations app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'analytics' app.config['MYSQL_DATABASE_HOST'] = 'localhost' mysql = MySQL(app, cursorclass=DictCursor) db = mysql.connect() @app.route('/getreport', methods=['GET', 'POST']) def getreport(): #from client req = request.json print str(req), type(req), "\n" if "duration" not in req: print "duration not in req" return jsonify({ 'StatusCode': '400',
from flask import Flask, render_template,redirect, json, request,jsonify from flaskext.mysql import MySQL from flask_cors import CORS, cross_origin app = Flask(__name__) CORS(app, origins='*') mysql = MySQL(app) # MySQL configurations app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'api_flask' app.config['MYSQL_DATABASE_HOST'] = 'localhost' mysql.init_app(app) @app.route('/') def index(): gold = 1 silver = 2 con=mysql.connect() cursor=con.cursor() cursor.callproc('ListaIndex',(gold,)) an_gold = cursor.fetchall() cursor.callproc('ListaIndex',(silver,)) an_silver = cursor.fetchall() return render_template("index.html", golds = an_gold, silvers = an_silver) @app.route('/api/list', methods=['GET']) def list(): cat = request.args.get("categoria")
import os # settingup the app app = Flask(__name__) # config app.config['DEBUG'] = True app.config['SECRET_KEY'] = os.urandom(24) # MYSQL configurations app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'green_renter_db' app.config['MYSQL_DATABASE_HOST'] = 'localhost' flaskmysql = MySQL() flaskmysql.init_app(app) def connect_db(flaskmysql): """from werkzeug.security import generate_password_hash, check_password_hash connecting to the database :param flaskmysql: :return: """ con = flaskmysql.connect() return con def get_db(flaskmysql): if not hasattr(g, 'mysql_db'):
def config(app): with open("./hertzmedia.config") as config: for line in config: configName = line[0:line.index("=")].strip() config = line[line.index("=") + 1:len(line)].strip() if (config.startswith("(int)")): config = config[5:] app.config[configName] = int(config) else: app.config[configName] = config config(app) db = MySQL() db.init_app(app) # requestParser setup postParser = reqparse.RequestParser() postParser.add_argument("title", type=str, help="the title 20 letters max", required=True) postParser.add_argument("text", type=str, help="the posted text", required=True) postParser.add_argument("file", type=str, help="optional file", required=False) allowUserParser = reqparse.RequestParser()
def create_app(test_config=None): # create and configure the app app = Flask(__name__, instance_relative_config=True) app.config['MYSQL_DATABASE_HOST'] = 'localhost' app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'tododb' mysql = MySQL(app) mysql.init_app(app) # ensure the instance folder exists try: os.makedirs(app.instance_path) except OSError: pass #MODEL STRATS HERE def get_from_db(name): conn=mysql.connect() cur=conn.cursor() cur.execute("SELECT work FROM todolisttable WHERE name = %s",(name)) data=cur.fetchall() data1=[A[0] for A in data] conn.commit() if len(data1) == 0 : return None return data1 def get_todos_by_name(name): try: return get_from_db(name) except: return None def add_in_list(name,work): conn=mysql.connect() cur = conn.cursor() cur.execute("INSERT INTO todolisttable(name, work) VALUES (%s, %s)", (name, work)) conn.commit() #mysql.connection.commit() #cur.close() return def verify_before_add(name,work): return add_in_list(name,work) #MODELS ENDS HERE #...............................................................................................................# #CONTROLLER STARTS HERE @app.route('/add_todo') def add_todo(): name=request.args.get('name') work=request.args.get('work') verify_before_add(name,work) return 'ADDED SUCCESFULLY' # a simple page that list my todos @app.route('/todos') def todos(): name = request.args.get('name') dolist = get_todos_by_name(name) if dolist!=None : return render_template('todo_view.html',worklist = dolist) else : return render_template('404.html'),404 #...................................................................................................................# return app
from ioSpaces.MyCustomNamespace import sio, MyCustomNamespace from flaskext.mysql import MySQL import pymysql from configs.database import dbConfig sio = socketio.Server(async_mode = 'eventlet') app = Flask(__name__) app.wsgi_app = socketio.Middleware(sio, app.wsgi_app) app.config['SECRET_KEY'] = 'secret!' app.config['JSON_SORT_KEYS'] = False for key,val in dbConfig.items(): app.config[key] = val mysql = MySQL( cursorclass = pymysql.cursors.DictCursor ) mysql.init_app(app) mysql.connect() mysql_cursor = mysql.get_db().cursor() @app.route("/") def hello(): from model.UserModel import UserModel dbmodel = UserModel(app) data = dbmodel.user_list() return jsonify({'code': 200, 'message': '', 'data': data}) # return render_template('index.html') sio.register_namespace(MyCustomNamespace('/test'))
from flask import Flask, render_template, json, request from flaskext.mysql import MySQL #from werkzeug import generate_password_hash, check_password_hash app = Flask(__name__) alex = MySQL() # MySQL configurations app.config['MYSQL_DATABASE_USER'] = '******' app.config['MYSQL_DATABASE_PASSWORD'] = '******' app.config['MYSQL_DATABASE_DB'] = 'Bucketlist' app.config['MYSQL_DATABASE_HOST'] = 'localhost' alex.init_app(app) conn = alex.connect() cursor = conn.cursor() cursor.callproc('sp_createUser', ("name", "email", "password")) data = cursor.fetchall() if len(data) is 0: conn.commit() return json.dumps({'message': 'User created successfully !'}) else: return json.dumps({'error': str(data[0])}) @app.route("/") def main(): return render_template("index.html")
def create_app(): mysql = MySQL() app = Flask(__name__) app.secret_key = 'webtechproject' app_data = { "name": "Disease Identification Using Images", "description": "Flask application for WT-2 Project", "author": "Harsh Garg, Gaurav Peswani, Hardik Mahipal Surana", "html_title": "Home", "project_name": "Disease Identification Using Images", "keywords": "flask, webapp, machine learning" } app.config["MYSQL_DATABASE_USER"] = '******' app.config["MYSQL_DATABASE_PASSWORD"] = '******' app.config["MYSQL_DATABASE_DB"] = "leafDiseaseIdentification" app.config["MYSQL_DATABASE_HOST"] = "localhost" mysql.init_app(app) photos = UploadSet('photos', IMAGES) app.config['UPLOADED_PHOTOS_DEST'] = './static/' configure_uploads(app, photos) @app.route('/') def index(): return render_template('index.html', app_data=app_data) @app.route("/login", methods=["GET", "POST"]) def login(): if (request.method == "GET"): return render_template("login.html") elif (request.method == "POST"): POST_USERNAME = str(request.form["username"]) POST_PASSWORD = str(request.form["password"]) print(POST_USERNAME) print(POST_PASSWORD) session["username"] = POST_USERNAME query = "SELECT name from register where username='******'" print("query is ", query) conn = mysql.connect() cursor = conn.cursor() res = cursor.execute(query) data = cursor.fetchall() print("data for details of user is ", data) nameOfUser = data[0][0] session["nameOfUser"] = nameOfUser print("session['username'] is ", session["username"]) # Make DB query to see if User with 'email' and 'acc_type' # has the same password as in the DB. result = models.loginCheck(mysql, POST_USERNAME, POST_PASSWORD) # if (result=="Error"): # flash("Error") print("result is ", result) if (result == True): return redirect(url_for("classify_tomato")) else: flash('wrong password!') return redirect(url_for("login")) else: flash("Error") @app.route('/b1') def b1(): return render_template('b1.html', app_data=app_data) # # getting our trained model from a file we created earlier model = pickle.load(open("./model/model.pkl", "rb"), encoding='utf-8') @app.route("/register", methods=["GET", "POST"]) def register_user(): if (request.method == "GET"): # print("nameList is ",nameList) # print("emailList is ",emailList) # print("usernamesList is ",usernamesList) # print("passwordList is ",passwordList) return render_template("register.html", title="Patient") elif (request.method == "POST"): newUserDict = { "name": str(request.form["name"]), "email": str(request.form["email"]), "username": str(request.form["username"]), "password": str(request.form["password"]), } if not models.isExistingUser(mysql, newUserDict["username"]): # nameList.append(newUserDict["name"]) # emailList.append(newUserDict["email"]) # usernamesList.append(newUserDict["username"]) # passwordList.append(newUserDict["password"]) res = models.insertNewUser(mysql, newUserDict) if (res == True): return redirect(url_for("login")) else: return redirect(url_for("register")) else: return redirect(url_for("login")) @app.route('/predict', methods=['POST']) def predict(): #grabbing a set of wine features from the request's body feature_array = json.loads(request.data)['feature_array'] # feature_array = request.get_json()['feature_array'] #our model rates the wine based on the input array prediction = model.predict([feature_array]).tolist() #preparing a response object and storing the model's predictions response = {} response['predictions'] = prediction #sending our response object back as json return jsonify(response) # getting our trained model from a file we created earlier # model = pickle.load(open("./model/data/model_info/alexnet_trained_model.pkl","rb"), encoding='utf-8') @app.route('/classify_tomato', methods=['GET', 'POST']) def classify_tomato(): if request.method == 'POST' and 'photo' in request.files: filename = photos.save(request.files['photo']) result = predict_disease('./static/' + filename) return render_template('result.html', app_data={"result": result}) return render_template('upload.html', app_data=app_data, name=session["nameOfUser"]) @app.route('/logout', methods=["GET", "POST"]) def logout(): print("Inside logout") if (request.method == "GET" and request.args.get("logout", "", type=int) == 1): try: session.pop("username") except KeyError: pass try: session.pop("nameOfUser") except: pass return redirect(url_for("login")) return render_template("login.html") # @app.route('/getDetailsOfUser', methods=['GET','POST']) # def getDetailsOfUser(): # if(request.method == 'GET'): # # res = models.getDetailsOfUser(mysql,session["username"]) # query = "SELECT name from register where username='******'" # print("query is ",query) # conn = mysql.connect() # cursor = conn.cursor() # res = cursor.execute(query) # data = cursor.fetchall() # print("data for details of user is ",data) # nameOfUser = data[0][0] # return render_template("register.html",title="Patient") @app.route('/fetch_multistage', methods=['GET']) def fetch_multistage(): print(request.files) FILES_LOC = "/home/harshgarg/Desktop/7thSem/WebTech-Project/WT-2/code/flaskr/static/text_for_msd/" if request.method == 'GET': if request.args.get("image", "", type=int) == 1: FILE_NAME = "images.json" elif request.args.get("link", "", type=int) == 1: FILE_NAME = "links.json" else: FILE_NAME = "content.json" file_ = open(FILES_LOC + FILE_NAME, 'r') res = file_.read() # print(res, type(res)) return res return "Invalid fetch" return app
__author__ = 'agrimasthana' from flask import Flask, request, jsonify from flaskext.mysql import MySQL from flask_api import status from os import system app = Flask(__name__) mySql = MySQL() config = {} execfile("settings.conf", config) app.config['MYSQL_DATABASE_USER'] = config['user'] app.config['MYSQL_DATABASE_PASSWORD'] = config['password'] app.config['MYSQL_DATABASE_DB'] = config['database'] app.config['MYSQL_DATABASE_HOST'] = config['host'] mySql.init_app(app) conn = mySql.connect() @app.route("/led", methods=['POST']) def led(): print(request) _message = request.json['message'] try: cursor = conn.cursor() cursor.execute("insert into Messages(message) values (%s)", _message) conn.commit() system('python ledbadge.py effect=left speed=5 "'+_message+'"') cursor.close() except conn.IntegrityError:
from flask import Flask, render_template, request, url_for, redirect from flaskext.mysql import MySQL from os import path, makedirs from werkzeug.utils import secure_filename from database import * app = Flask(__name__) bd = MySQL() bd.init_app(app) upload_dir = ('static') makedirs(upload_dir, exist_ok=True) # verificar se o funcionário está logado type 1 = gerente / type 0 = vendedor login_type = None login_name = None @app.route('/') def home(erro=None): conn = bd.connect() cursor = conn.cursor() vips = show_vips(cursor) cursor.close() conn.close() return render_template('index.html') @app.route('/cadastro_carro') def insercao(erro=None): if login_type: return render_template('inserir.html', erro=erro, logado=login_type)
from flask import Flask, render_template, request, json, redirect, session, flash from flaskext.mysql import MySQL from werkzeug.security import generate_password_hash, check_password_hash app = Flask(__name__) app.secret_key = 'why would I tell you my secret key?' mysql = MySQL() # # # # # # # # app.config[ 'MYSQL_DATABASE_USER'] = '******' # Create my MySQL Object named mysql # app.config[ 'MYSQL_DATABASE_PASSWORD'] = '******' # # app.config[ 'MYSQL_DATABASE_DB'] = 'what' # MySQL configurations (Todo move to config.file) # app.config[ 'MYSQL_DATABASE_HOST'] = 'localhost' # # mysql.init_app(app) # Start MySQL Application inside Flask # # # # # # # # # # # # # Function endpoints Frontpage # # # # # # # # #When user hits signup DO:: @app.route('/test') def test(): return render_template('test.html') @app.route('/') def index(): return render_template('test.html')
from flask import Flask,session,render_template,request,jsonify, redirect,url_for import main #importing package to connect flask to mysql database from flaskext.mysql import MySQL #flask app nlpsql = Flask(__name__) nlpsql.secret_key = 'nlpsql key' mysql = MySQL(nlpsql) #Database Configuration nlpsql.config['MYSQL_DATABASE_USER'] = '******' nlpsql.config['MYSQL_DATABASE_PASSWORD'] = '******' nlpsql.config['MYSQL_DATABASE_DB'] = 'nlpproj' nlpsql.config['MYSQL_DATABASE_HOST'] = 'localhost' #start flask app mysql.init_app(nlpsql) #route for home @nlpsql.route('/') def home(): if 'error' in session: error=session['error'] session.pop('error',None) else: error=''
# coding:utf-8 ''' Created on 19/1/2015 @author: PC30 ''' from flaskext.mysql import MySQL #importar mysql from flask import Flask #esta se importa manualmente mysql = MySQL() #llamando a mysql app = Flask(__name__) #instanciando a flask app.config['MYSQL_DATABASE_USER'] = '******' #nombre de usuario app.config['MYSQL_DATABASE_PASSWORD'] = '******' #contrase�a de ususario app.config['MYSQL_DATABASE_DB'] = 'sisventas' #nombre de la base de datos app.config['MYSQL_DATABASE_HOST'] = 'localhost' #servidor donde se encuantra mysql.init_app(app) con = mysql.connect().cursor() #se hace la coneccion IMPORTANTE!!! con.execute(" select * from cliente ") #se hace la consulta report = con.fetchall( ) #funcion que hace que extrae todo desde la base de datos print report con = mysql.connect().cursor() #se hace la coneccion IMPORTANTE!!! con.execute(" select * from producto ") #se hace la consulta reportt = con.fetchall( ) #funcion que hace que extrae todo desde la base de datos print reportt