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')