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
