# import database_operations as dbop # from pprint import PrettyPrinter # import os # import sys # import uuid # p = PrettyPrinter() App = Flask(__name__) App.config['MYSQL_USER'] = '******' App.config['MYSQL_PASSWORD'] = '' App.config['MYSQL_DB'] = 'expense' App.config['MYSQL_CURSORCLASS'] = 'DictCursor' App.config['MYSQL_HOST'] = 'localhost' App.config['MAX_CONTENT_LENGTH'] = 16 * 1024 * 1024 # App.config['UPLOAD_FOLDER'] = "static/uploads" mysql = MySQL(App) App.secret_key = 'any random string' @App.route('/', methods=['GET']) def login_view(): return render_template('app/index.html') @App.route('/home', methods=['GET']) def homepage_view(): if 'username' in session: return render_template('app/home.html') else: return redirect('/')
import ConfigParser from flask import Flask, jsonify, request, MySQLdb from flask_mysqldb import MySQL mysql = MySQL() application = Flask(__name__) application.config['MYSQL_DATABASE_USER'] = '******' application.config['MYSQL_DATABASE_PASSWORD'] = '******' application.config['MYSQL_DATABASE_DB'] = 'mybank_eascorp' application.config['MYSQL_DATABASE_HOST'] = 'mysql.storage.cloud.wso2.com' mysql.init_app(application) # Read config file config = ConfigParser.ConfigParser() config.read('bankDB.conf') @application.route('/') def users(): # Open database connection with username= "******", password= "******" and database= "pythonTest" db = MySQLdb.connect("localhost", "root", "password", "pythonTest") # Prepare a cursor object using cursor() method cursor = db.cursor() # Execute SQL query using execute() method. # Table: rooms with attributes "roomID" cursor.execute("SELECT roomID FROM rooms") # Fetch a single row using fetchone() method. data = cursor.fetchall()
from flask_mysqldb import MySQL from flaskext.mysql import MySQL from functools import wraps import hashlib from flask_httpauth import HTTPDigestAuth from bson import json_util import json from flask.json import JSONEncoder from datetime import date, datetime, timedelta import time 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)
"Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8", "DNT": "1", "Connection": "close", "Upgrade-Insecure-Requests": "1" } web = Flask(__name__) web.secret_key = 'Prabhat' web.config['MYSQL_USER'] = '******' web.config['MYSQL_PASSWORD'] = '' web.config['MYSQL_DB'] = 'movies2watch' web.config['MYSQL_HOST'] = 'localhost' mysql = MySQL(web) @web.route('/') def Home(): def Output(): output = [] mname = [] names = [] mimg = [] mdesc = [] msource = "https://www.metacritic.com/browse/movies/score/metascore/all/filtered?sort=desc" mreq = requests.get(msource, headers=headers) msoup = BeautifulSoup(mreq.content, features="lxml")
from flask_mysqldb import MySQL MYSQL_HOST = '192.168.0.178' MYSQL_USER = '******' MYSQL_PASSWORD = '******' MYSQL_DB = 'flaskdb' MYSQL_CURSORCLASS = 'DictCursor' # init MYSQL mysql = MySQL()
from flask import Flask, request, jsonify, render_template from flask_mysqldb import MySQL from werkzeug.security import generate_password_hash, check_password_hash import datetime import locale locale.setlocale(locale.LC_TIME, 'es_ES.UTF8') app = Flask(__name__) app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'SBC' app.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(app) #############Views################## @app.route('/') def index(): return render_template('index.html',data = getDataDashboard()) def getDataDashboard(): data = {} cur = mysql.connection.cursor() cur.execute('''SELECT COUNT(ID_Asistente) AS Total_Asistentes FROM ASISTENTE''') rv = cur.fetchone() data.update(rv) cur.execute('''SELECT COUNT(*) AS Total_Accesos FROM HISTORIAL''') rv = cur.fetchone() data.update(rv)
from flask_mysqldb import MySQL, MySQLdb from flask_bcrypt import bcrypt from PIL import Image import time, datetime, json import numpy as np import cgi import cgitb goliatApp = Flask(__name__) goliatApp.config['MYSQL_HOST'] = 'localhost' goliatApp.config['MYSQL_USER'] = '******' goliatApp.config['MYSQL_PASSWORD'] = '******' goliatApp.config['MYSQL_DB'] = 'goliat' goliatApp.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(goliatApp) @goliatApp.route('/') def index(): return render_template("login.html") @goliatApp.route('/register', methods=["GET", "POST"]) def register(): if request.method == 'GET': return render_template("register.html") else: nombres = request.form['nombresUsua'] apellidos = request.form['apellidosUsua'] numeroCel = request.form['numeroCelUsua'] trabajo = request.form['trabajoUsua']
from passlib.hash import sha256_crypt from functools import wraps # from sqlalchemy import create_engine # from flask_sqlalchemy import SQLAlchemy from sqlalchemy.orm import sessionmaker from jinja2 import Environment, PackageLoader, select_autoescape #main = Blueprint('main', __name__, template_folder='templates') from flask_mysqldb import MySQL #app = Flask(__name__) app = Flask(__name__, static_url_path='/static', template_folder='templates') #app.config.from_object('config.Config') #app.config.from_pyfile('config.py') db = MySQL(app) #mod = Blueprint('site', __name__, template_folder='templates') # @main.route('/') # def index(): # return "Main" # from flask import Flask # from flask_mysqldb import MySQL # if __name__ == '__main__': # main creation
def __init__(self): self.mysql = MySQL(app)
from flask import Flask, request, render_template, redirect, session, url_for, jsonify, abort, Response from flask_mysqldb import MySQL from wtforms import Form, StringField, PasswordField, validators from passlib.hash import sha256_crypt from functools import wraps myapp = Flask(__name__) myapp.config['MYSQL_HOST'] = 'localhost' myapp.config['MYSQL_USER'] = '******' myapp.config['MYSQL_PASSWORD'] = '******' myapp.config['MYSQL_DB'] = 'flask' myapp.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(myapp) def is_logged_in(f): @wraps(f) def wrap(*args, **kwargs): if 'logged_in' in session: return f(*args, **kwargs) else: return redirect(url_for('login')) return wrap class RegisterForm(Form): name = StringField('Name', [validators.Length(min=1, max=50)]) username = StringField('Username', [validators.Length(min=4, max=25)])
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')
from flask import Flask, request, render_template, redirect #pip3 install flask-mysqldb from flask_mysqldb import MySQL import sys app = Flask(__name__) #configuring db app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'url' app.config['MYSQL_PORT'] = 3308 mysql = MySQL(app) #sending our app db configuration to mysql counter = 4000 #counter is used to send a numeric value to our b62 algo to get back a unique combination,i.e. short url #method for encoding our long url def conv(num): BASE_ALPH = tuple( "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz") BASE_LEN = len(BASE_ALPH) if not num: return BASE_ALPH[0] encoding = ""
from flask import Flask, render_template, request from flask_mysqldb import MySQL from flask import jsonify app = Flask(__name__) app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_HOST'] = 'localhost' app.config['MYSQL_DB'] = 'web_ise' mysql = MySQL(app) #for the route test @app.route('/api/', methods=['GET', 'POST']) def index(): cur = mysql.connection.cursor() cur.execute("select * from users ") d = cur.fetchall() print(d) cur.close() return jsonify(d) @app.route('/api/userdet', methods=['GET', 'POST']) def userdef(): return 'ok' @app.route('/api/user', methods=['GET', 'POST']) def usercall(): cur = mysql.connection.cursor() cur.execute("select * from users where uname='tonydbs'")
game1 = Game('Super Mario', 'Action', 'SNT') game2 = Game('Pokemon Gold', 'RPG', 'GBA') games = [game1, game2] app = Flask(__name__) """ This is a sample web app. Never, never define secrete key in your source code... """ app.secret_key = "xvZkad019002863kajdh3hflskjgadçjeubdk" app.config['MYSQL_HOST'] = "0.0.0.0" app.config['MYSQL_USER'] = "******" app.config['MYSQL_PASSWORD'] = "******" app.config['MYSQL_DB'] = "jogoteca" app.config['MYSQL_PORT'] = 3306 db = MySQL(app=app) game_dao = GameDao(db=db) @app.route('/') def index(): return render_template("games.html", title=page_title, games=games) @app.route('/new') def new_game(): if 'logged_user' not in session or session['logged_user'] is None: return redirect(url_for('login', next_page=url_for('new_game'))) return render_template('new_game.html', title=page_title)
from flask import Flask,Markup #importing markup to wrap html content in it and then pass to flash meassgae from flask import render_template,url_for,request,session,redirect,flash from flask_mysqldb import MySQL import MySQLdb.cursors from datetime import datetime,date app = Flask(__name__) app.config['SECRET_KEY']='SECREt' #configure app to connect to MYSQL DB app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'lms' app.config['MYSQL_HOST'] = 'localhost' mysql = MySQL(app) #creating db instance #index page of the web app @app.route('/',methods=['GET','POST']) def home(): return render_template("home.html") #User Login Route @app.route('/login',methods=['GET','POST']) def login(): if request.method=="POST": name=request.form['username'] pwd=request.form['password'] #checking for empty fields if name=="": flash("Login Unsucessful! Username can't be empty",'danger') return redirect(url_for('login')) elif pwd=="":
from flask import Flask, render_template, request, redirect, url_for, session from flask_mysqldb import MySQL salononclick2 = Flask(__name__) salononclick2.config['MYSQL_HOST'] = '10.1.1.61' salononclick2.config['MYSQL_PORT'] = 3308 salononclick2.config['MYSQL_USER'] = '******' salononclick2.config['MYSQL_PASSWORD'] = '******' salononclick2.config['MYSQL_DB'] = 'asma' mysql = MySQL(salononclick2) @salononclick2.route('/') def home(): return render_template('index.html') @salononclick2.route('/contactus') def contactus(): return render_template('contact.html') @salononclick2.route('/aboutus') def aboutus(): return render_template('about.html') @salononclick2.route('/pricing') def pricing(): return render_template('pricing.html')
import unittest import time from copy import deepcopy from flask_mysqldb import MySQL from .app import app VALID_CREDENTIALS = base64.b64encode('{}:{}'.format( app.config['BASIC_AUTH_USERNAME'], app.config['BASIC_AUTH_PASSWORD']).encode()).decode('utf-8') HEADERS = { 'Authorization': f'BASIC {VALID_CREDENTIALS}', 'Content-Type': 'application/json' } db = MySQL() with app.app_context(): with db.connection.cursor() as cursor: cursor.execute( '''SELECT id, country, city, currency, amount FROM deposits LIMIT 1''' ) res = cursor.fetchone() RANDOM_ROW = dict(zip(['id', 'country', 'city', 'currency', 'amount'], res)) # TODO set up and tear down db with data for proper testing class TestListDeposits(unittest.TestCase): def test_get_no_auth(self):
from flask import Flask, redirect from flask_mysqldb import MySQL import os redirection = Flask(__name__) redirection.config['MYSQL_USER'] = os.getenv('MYSQL_USER') redirection.config['MYSQL_PASSWORD'] = os.getenv('MYSQL_PASSWORD') redirection.config['MYSQL_HOST'] = os.getenv('MYSQL_HOST') redirection.config['MYSQL_DB'] = os.getenv('MYSQL_DB') redirection.config['MYSQL_CURSORCLASS'] = 'DictCursor' mysql = MySQL(redirection) def get_url(tiny_url): tiny_id = tiny_url.split('/')[-1] cur = mysql.connection.cursor() query="select url from url where tiny_key={};".format(tiny_id) cur.execute(query) response = cur.fetchone() mysql.connection.commit() cur.close() return response['url'] @redirection.route('/s/<tinyid>') def redirect_it(tinyid): full_url = get_url(tinyid) print(full_url) return redirect(full_url) if __name__ == '__main__':
program = Flask(__name__) #database connection program.config['MYSQL_HOST'] = 'localhost' program.config['MYSQL_USER'] = '******' program.config['MYSQL_PASSWORD'] = '' program.config['MYSQL_DB'] = 'program_db' #to skip any error may occure program.config['SQLALCHEMY_TRACK_MODIFICATIONS']= False program.config['SQLALCHEMY_DATABASE_URI']= 'program_db.sql' #call the database mysql = MySQL(program) @app.route('/program_db/', methods=['GET', 'POST']) def index(): return render_template('index.html', msg='Welcome') def index(): #check if the data in database if request.method == 'POST' and 'user_id' in request.form and 'user_pass' in request.form: user_id = request.form['user_id'] user_pass = request.form['user_pass'] #check on databse cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor) cursor.execute('SELECT * FROM users WHERE user_id = %s AND user_pass = %s', (user_id, user_pass)) users = cursor.fetchone()
import timeit import datetime from flask_mail import Mail, Message import os from wtforms.fields.html5 import EmailField #-*-coding:utf-8-*- app = Flask(__name__) app.secret_key = os.urandom(24) app.config['UPLOADED_PHOTOS_DEST'] = 'static/image/product' photos = UploadSet('photos', IMAGES) configure_uploads(app, photos) # MySQL YAPILANDIRMASI mysql = MySQL() app.config['MYSQL_HOST'] = '127.0.0.1' app.config['MYSQL_USER'] = '******' app.config['MYSQL_PASSWORD'] = '******' app.config['MYSQL_DB'] = 'mekaya' app.config['MYSQL_CURSORCLASS'] = 'DictCursor' # Bu MySQL sınıfıyla kullanmak için uygulamayı başlat mysql.init_app(app) def is_logged_in(f): @wraps(f) def wrap(*args, **kwargs): if 'logged_in' in session: return f(*args, *kwargs)
import hashlib import random from datetime import date import html App = Flask(__name__) App.config['SECRET_KEY'] = "abcdef12356AAFF" App.config['MYSQL_HOST'] = '127.0.0.1' App.config['MYSQL_USER'] = '******' App.config['MYSQL_PASSWORD'] = '' App.config['MYSQL_DB'] = 'quiz_system_db' conn = MySQL (App) @App.route("/") @App.route("/index") @App.route("/home") def index(): return render_template("index.html", title = "Home") @App.route("/login", methods = ["GET", "POST"]) def login(): if check_login(): return redirect(session.get("role")) if request.form: email = secure(request.form["email"])
from flask_mysqldb import MySQL from flaskext.mysql import MySQL from functools import wraps import hashlib import bcrypt from eve import Eve 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!"
application.config['MYSQL_USER'] = '******' application.config['MYSQL_PASSWORD'] = '******' application.config['MYSQL_DB'] = 'schedulerapp' application.config['MYSQL_CURSORCLASS'] = 'DictCursor' """ # Config MySQL AWS RDS application.config['SECRET_KEY'] = os.urandom(24).encode('hex') application.config['MYSQL_HOST'] = 'aa168k8g4t45xqt.cx1fprjct8eq.us-west-2.rds.amazonaws.com' application.config['MYSQL_USER'] = '******' # [WARNING]: must change database password for final delivery application.config['MYSQL_PASSWORD'] = '******' application.config['MYSQL_DB'] = 'schedulerapp' application.config['MYSQL_CURSORCLASS'] = 'DictCursor' """ # Initialize MySQL mysql = MySQL(application) # Home page template @application.route('/') def index(): return render_template('home.html') # About page template @application.route('/about') def about(): return render_template('about.html') # Class for registration form format class RegisterForm(Form): name = StringField('Name', [validators.Length(min=1, max=50)]) username = StringField('Username', [validators.Length(min=4, max=25)])
#!/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
from flask import Flask from flask_mysqldb import MySQL db = Flask(__name__) mysql = MySQL(db) class dbschema: db.config['MYSQL_HOST'] = 'localhost' db.config['MYSQL_USER'] = '******' db.config['MYSQL_PASSWORD'] = '******' def createdb(self): try: with db.app_context(): cursor = mysql.connection.cursor() cursor.execute("create database if not exists mydb") mysql.connection.commit() cursor.close() except Exception as e: print(e) def createtable(self, dbname, tablename): try: with db.app_context(): cursor = mysql.connection.cursor() cursor.execute(f"use {dbname}") cursor.execute( f"create table if not exists {tablename} (testid varchar(10))" ) mysql.connection.commit()