def getMysqlConnection(): mysql = MySQL(app) app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'ema' app.config['MYSQL_HOST'] = 'localhost' mysql.init_app(app) connection = mysql.connect cursor = connection.cursor() return cursor, connection
def create_app(): _app = Flask(__name__) mysql = MySQL() mysql.init_app(_app) _app.secret_key = SECRET_KEY _app.config['JWT_ACCESS_TOKEN_EXPIRES'] = ACCESS_TIMEOUT _app.config['JWT_REFRESH_TOKEN_EXPIRES'] = REFRESH_TIMEOUT _app.register_blueprint(bp) return _app
def init_app(app): """Register database functions with the Flask app. This is called by the application factory. """ # MySQL configurations app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'learningdb' app.config['MYSQL_HOST'] = 'localhost' print("in init db") global mysql mysql = MySQL() mysql.init_app(app)
def initialize(): app = Flask(__name__) app.secret_key = 'okboomer' app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'energy' mysql = MySQL() mysql.init_app(app) blacklist = set() return app, mysql, blacklist
def create_api(): """ create_api Create the flask app with every config needed for the website :return: Flask Application :rtype: Flask App """ app = Flask(__name__) api = Api(app) db = MySQL() app.config.from_object(Config) db.init_app(app) initialize_routes(api) CORS(app) Mail(app) return app
class DataBase: db = None _app = None def __init__(self): self.init_db() @property def connection(self): with self._app.app_context(): return self.db.connect def init_db(self): self.db = MySQL() self._app = Flask(__name__) self._app.config['MYSQL_HOST'] = '127.0.0.1' self._app.config['MYSQL_PORT'] = 3307 self._app.config['MYSQL_USER'] = '******' self._app.config['MYSQL_PASSWORD'] = '******' self._app.config['MYSQL_DB'] = 'nr_db' self._app.config['MYSQL_CURSORCLASS'] = 'DictCursor' self.db.init_app(self._app)
import tensorflow from Talk import ask app = Flask(__name__) app.secret_key = os.urandom(24) # Config MySQL mysql = MySQL() app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '' app.config['MYSQL_DB'] = 'sslchat' app.config['MYSQL_CURSORCLASS'] = 'DictCursor' # Initialize the app for use with this MySQL class mysql.init_app(app) @app.route('/') def index(): cur = mysql.connection.cursor() result = cur.execute("SELECT * FROM users WHERE username=%s", ["Om"]) data = cur.fetchone() session['logged_in'] = True session['uid'] = 0 session['s_name'] = 'User' uid = session['uid'] session['name'] = 'Bot' session['lid'] = 1
#!/usr/bin/env python # -*- coding: utf-8 -*- from Benevole import Benevole from flask import Flask from flask import render_template from flask import request from flask_mysqldb import MySQL from hashlib import md5 app = Flask(__name__) mysql = MySQL() app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'rfid_lanets' mysql.init_app(app) authorize = False username = None liste_benevole = [] @app.route('/') def index(): return render_template('login.html') @app.route('/login', methods=['GET','POST']) def login(): if request.method == 'POST': authorization = authentification(request.form['username'], request.form['password']) if authorization: global authorize authorize = authorization global username
nikoleRoute = NikoleRoute() accountingRoute = AccountingRoute() userRoute = UserRoute() #Flask Configuration app = Flask(__name__) CORS(app) #MySQL Configuration app.config['MYSQL_HOST'] = constants.MYSQL_HOST app.config['MYSQL_PORT'] = constants.MYSQL_PORT app.config['MYSQL_USER'] = constants.MYSQL_USER app.config['MYSQL_PASSWORD'] = constants.MYSQL_PASS app.config['MYSQL_DB'] = constants.MYSQL_DB mySQL.init_app(app) #Celery Configuration app.config['CELERY_RESULT_BACKEND'] = constants.REDIS_URL app.config['CELERY_BROKER_URL'] = constants.REDIS_URL celery = util.make_celery(app) ## -- CONTAS -- ## @app.route('/dashboard/api/v1.0/account/insert', methods=['POST']) def insert_account(): return Response(accountRoute.insert_account(request), mimetype='application/json')
# System imports import re, json # Package imports import bleach from flask import render_template, redirect, request, session from flask_mysqldb import MySQL from werkzeug import generate_password_hash, check_password_hash from app import application mysql = MySQL() mysql.init_app(application) @application.route('/') @application.route('/index') def index(): # If user is logged in, redirect to feed if session.get('user'): return redirect('/feed') # Else present with Login/Register options return render_template('index.html') @application.route('/register', methods=['GET', 'POST']) def register(): title = "Tweeter - Register" if request.method == "GET": return render_template('register.html', title=title) elif request.method == "POST": try:
from flask_mysqldb import MySQL from flask_jwt_extended import ( JWTManager, jwt_required, create_access_token, jwt_refresh_token_required, create_refresh_token, get_jwt_identity ) from flaskblog import app db = MySQL() db.init_app(app) jwt = JWTManager(app)
from flask import Flask, jsonify, request from flask_mysqldb import MySQL from models import * app = Flask(__name__) sql = MySQL() app.config["MYSQL_USER"] = "******" app.config["MYSQL_PASSWORD"] = "******" app.config["MYSQL_DB"] = "tatoeba" app.config["MYSQL_HOST"] = "localhost" sql.init_app(app) @app.route("/contributions") def contributions(): cursor = sql.connection.cursor() cursor.execute("SELECT * FROM contributions ORDER BY datetime DESC") result = cursor.fetchall() contributions = [] for row in result: contribution = Contribution(row) cursor.execute("SELECT * FROM users WHERE id = %d" % row[7]) contribution.user = User(cursor.fetchall()[0]) contributions.append(contribution.dict()) return jsonify(contributions) @app.route("/sentences")
def create_db(self): db = MySQL() db.init_app(self.app) return db
import json from flask import request from flask import send_file from flask import Response from flask import make_response dbs = MySQL() app = Flask(__name__) app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'users' app.config['MYSQL_HOST'] = '104.155.53.22' dbs.init_app(app) @app.route("/") def test(): conn = dbs.connection.cursor() conn.execute("select * from Users") return str(conn.fetchall()) @app.route("/getEvents") def getEvents(): conn = dbs.connection.cursor() conn.execute("select * from Events where eventDate > CURDATE()") headers = [header[0] for header in conn.description] resultSet = conn.fetchall()
from flask import Flask from flask_sqlalchemy import SQLAlchemy from flask_mysqldb import MySQL app5 = Flask(__name__) app5.config['MYSQL_DATABASE_USER'] = '******' app5.config['MYSQL_DATABASE_PASSWORD'] = '******' app5.config['MYSQL_DATABASE_DB'] = 'LibraryDB' app5.config['MYSQL_DATABASE_HOST'] = 'localhost' app5.config['MYSQL_DATABASE_PORT'] = 8889 mysql = MySQL() mysql.init_app(app5) conn = mysql.connect() cursor = conn.cursor() #endpoint for search @app.route('/search2', methods=['GET', 'POST']) def search(): if request.method == "POST": book = request.form['name'] # search by first or last name cursor.execute( "SELECT first_name, last_name from Users WHERE first_name LIKE %s OR last_name LIKE %s", (book, book)) conn.commit() data = cursor.fetchall() # all in the search box will return all the tuples if len(data) == 0 and book == 'all':
"""Author: Grant Miller <*****@*****.**> Purpose: run the following and followers portion of Skitter""" from pprint import pprint from flask_mysqldb import MySQL from flask import Flask from flask import request APP = Flask(__name__) MYSQLDB = MySQL() APP.config['MYSQL_USER'] = '******' APP.config['MYSQL_PASSWORD'] = '******' APP.config['MYSQL_DB'] = 'Skitter' APP.config['MYSQL_HOST'] = '172.18.0.2' MYSQLDB.init_app(APP) @APP.route("/searchUsers", methods=['GET']) def users(): """Searches the database for users that match the GET parameter""" username = request.args.get('query') cur = MYSQLDB.connection.cursor() username = username + "%" cur.execute("SELECT userid FROM Users WHERE username LIKE %s;", (username,)) data = cur.fetchall() pprint(data) final = ""
class DBController: def __init__(self): self.__mysql = MySQL() self.__mysql.init_app(app) def add_user(self, uname): fetch_sql = "SELECT * FROM users WHERE u_name = '{}'".format(uname) cursor = self.__mysql.connection.cursor() cursor.execute(fetch_sql) data = cursor.fetchall() if len(data) == 0: insert_sql = "INSERT INTO users VALUES (DEFAULT, '{}')".format( uname) cursor.execute(insert_sql) self.__mysql.connection.commit() def check_if_user_full(self, threshold): fetch_sql = "SELECT count(u_id) FROM users" cursor = self.__mysql.connection.cursor() cursor.execute(fetch_sql) data = cursor.fetchone() if data is not None: return True if data[0] >= threshold else False def get_user_id(self, uname): fetch_sql = "SELECT * FROM users WHERE u_name = '{}'".format(uname) cursor = self.__mysql.connection.cursor() cursor.execute(fetch_sql) data = cursor.fetchone() return None if data is None else data[0] def record_user_click(self, uid, pid, qry, duration): click_score = 0 if duration >= 5 and duration < 15: click_score = 1 else: click_score = 2 insert_sql = "INSERT INTO rel_scores VALUES ({}, '{}', '{}', {}, DEFAULT) ON DUPLICATE KEY UPDATE click_score = {}".format( uid, pid, qry, click_score, click_score) cursor = self.__mysql.connection.cursor() cursor.execute(insert_sql) self.__mysql.connection.commit() def record_user_rel_sel(self, uid, pid, qry, rel): rel_score = 0 if rel == 0 else 2 insert_sql = "INSERT INTO rel_scores VALUES ({}, '{}', '{}', DEFAULT, {}) ON DUPLICATE KEY UPDATE rel_score = {}".format( uid, pid, qry, rel_score, rel_score) cursor = self.__mysql.connection.cursor() cursor.execute(insert_sql) self.__mysql.connection.commit() def get_user_rel_scores(self, uid, query, pid=None): if pid is None: fetch_sql = "SELECT p_id, rel_score + click_score AS score FROM rel_scores WHERE u_id = {} AND qry = '{}'".format( uid, query) cursor = self.__mysql.connection.cursor() cursor.execute(fetch_sql) data = cursor.fetchall() return None if len(data) == 0 else data else: fetch_sql = "SELECT rel_score + click_score AS score FROM rel_scores WHERE u_id = {} AND p_id = '{}' AND qry = '{}'".format( uid, pid, query) cursor = self.__mysql.connection.cursor() cursor.execute(fetch_sql) data = cursor.fetchone() return None if data is None else data[0]