def connection():
conn = MySQL.connect(host='127.0.0.1',
user='******',
passwd='1234',
db='homemade')
c = conn.cursor()
return c, conn
def conection():
conn = MySQL.connect(host="localhost",
user="******",
passwd="arnav123",
db="flaskapp")
c = conn.cursor()
return c, conn
def get_conn(self):
if self._conn:
self._conn.ping()
return self._conn
try:
self._conn = DB.connect(**self._db_conf)
except Exception as e:
raise e
return self._conn
app = Flask(__name__)
#DATABASE PART
mysql = MySQL()
app.secret_key = 'rootpasswordgiven'
app.config['MYSQL_DATABASE_USER'] = '******'
app.config['MYSQL_DATABASE_PASSWORD'] = '******'
app.config['MYSQL_DATABASE_DB'] = 'soteria1'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)
#MONGOPART
app.config["MONGO_URI"] = "mongodb://localhost:27017/test"
mongo = PyMongo(app)
conn = mysql.connect()
cursor = conn.cursor()
def sendMail(user_name, user_email, user_acc, user_key):
mail = Mail()
app.config["MAIL_SERVER"] = "smtp.gmail.com"
app.config["MAIL_PORT"] = 465
app.config["MAIL_USE_SSL"] = True
app.config["MAIL_USERNAME"] = '******'
app.config["MAIL_PASSWORD"] = '******'
mail.init_app(app)
email = user_email
msg = Message("Account Created",
sender="Projectsoteria-support",
recipients=[email])
from dateutil.relativedelta import relativedelta
from api_tiprank import analysts
mysql = MySQL()
app = Flask(__name__)
app.config['MYSQL_DATABASE_USER'] = '******'
app.config['MYSQL_DATABASE_PASSWORD'] = '******'
app.config['MYSQL_DATABASE_DB'] = 'Classify_Prod'
app.config['MYSQL_DATABASE_HOST'] = 'kibot-data.cgbzucciybhz.us-east-1.rds.amazonaws.com'
mysql.init_app(app)
cnx = mysql.connect()
cur = cnx.cursor()
api = Api(app)
# -------------------------------------------Authentication---------------------------------------------------------
def calculate_hash(api_key):
"""
@return: A hashkey for use to authenticate agains the API.
"""
salt = "jdalakh2"
return hashlib.md5(salt + api_key).hexdigest()
from datetime import date, datetime, timedelta
import time
from dateutil.relativedelta import relativedelta
# from api_authenticate import require_app_key
mysql = MySQL()
app = Flask(__name__)
app.config['MYSQL_DATABASE_USER'] = '******'
app.config['MYSQL_DATABASE_PASSWORD'] = '******'
app.config['MYSQL_DATABASE_DB'] = 'mengjiao'
app.config[
'MYSQL_DATABASE_HOST'] = 'kibot-data.cgbzucciybhz.us-east-1.rds.amazonaws.com'
mysql.init_app(app)
cnx = mysql.connect()
cur = cnx.cursor()
api = Api(app)
picture_base_url = "https://trstorage1.blob.core.windows.net/expert-pictures/"
analysts = Blueprint('analysts', __name__)
@analysts.route('/analysts', methods=['GET'])
# @app.route('/analysts', methods = ['GET'])
# @require_app_key
def get_analysts():
cur.execute("SELECT * FROM tr_Analyst LIMIT 1000")
resultSet = cur.fetchall()
from eve.auth import BasicAuth
from flask import current_app as app1
mysql = MySQL()
app = Flask(__name__)
app.config['MYSQL_DATABASE_USER'] = '******'
app.config['MYSQL_DATABASE_PASSWORD'] = '******'
app.config['MYSQL_DATABASE_DB'] = 'mengjiao'
app.config['MYSQL_DATABASE_HOST'] = 'kibot-data.cgbzucciybhz.us-east-1.rds.amazonaws.com'
mysql.init_app(app)
cur = mysql.connect().cursor()
api = Api(app)
@app.route('/')
def index():
return "Welcome!"
# API Key for anthenticate
# api_key = request.headers.get('APIKEY')
# 1
def check_auth(username, password):
'''
Created on 2016年3月20日
@author: henry.zhao
'''
from flask import Flask
from flask_mysqldb import MySQL
app = Flask(__name__)
mysql = MySQL(app)
db = mysql.connect(host="localhost", user="******", passwd="123456",db="flask_web", charset="utf8")
db.autocommit(True)
def getUser():
cur=mysql.connection.cursor()
try:
sql="INSERT INTO user (id, name,password) VALUES ('5', '*****@*****.**', 'very-secret')"
ret = cur.execute(sql)
except mysql.IntegrityError:
pass
return "OK"
if __name__ == '__main__':
getUser()
for i in range(0, 5):
file = "audio" + str(i) + ".TextGrid"
os.remove(file)
except:
pass
dict2[0] = r1
dict2[1] = r2
dict2[2] = r3
dict2[3] = r4
dict2[4] = r5
dict2[5] = r6
mydb = MySQL.connect(host="localhost",
user="******",
passwd="admin",
database="smart_c_bot")
mycursor = mydb.cursor(MySQLdb.cursors.DictCursor)
@app.route(
"/") # the first function to be called as soon as the application starts
def homepage():
return render_template('homepage.html')
@app.route("/dashboard", methods=['GET', 'POST'])
def dashboard():
if ('user' in session):
return render_template('dashboard.html')
