# 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()
