def hello():
query = "SELECT 'Hello_World';"
db = MySQL()
with db.cursor(dictionary=True) as cursor:
cursor.execute(query)
rv = cursor.fetchone()
return rv
import shortuuid
#Inicializar app
app = Flask(__name__)
#Endpoint
endpoint = 'http://www.short.url'
#Conexion a MySQL
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = '******'
app.config['MYSQL_PASSWORD'] = ''
app.config['MYSQL_DATABASE'] = 'short_url'
#Iniciar DB
mysql = MySQL(app)
##Llave para flash
app.secret_key = 'C1v3S3cr3t'
#Rutas
@app.route('/', methods=['GET'])
def inicio():
try:
return render_template('index.html'), 200
except:
return render_template('404.html'), 404
#Ruta enlace corto
from flask import Flask
from flask_mysql_connector import MySQL
app = Flask(__name__)
MySQL.init_app(app)
@app.route("/")
def hello():
query = "SELECT 'Hello_World';"
db = MySQL()
with db.cursor(dictionary=True) as cursor:
cursor.execute(query)
rv = cursor.fetchone()
return rv
MYSQL_USER = os.getenv("MYSQL_USER", "root") # admin
MYSQL_PASSWORD = os.getenv("MYSQL_PASSWORD", "root") # dopdatabaseroot
MYSQL_DATABASE = os.getenv("MYSQL_DATABASE", "test_db")
# Setup
app = Flask(__name__)
app.config['SECRET_KEY'] = 'secret!'
CORS(app)
socketio = SocketIO(app, cors_allowed_origins="*")
# MySQL Config
app.config['MYSQL_HOST'] = MYSQL_HOST
app.config['MYSQL_USER'] = MYSQL_USER
app.config['MYSQL_PASSWORD'] = MYSQL_PASSWORD
app.config['MYSQL_DATABASE'] = MYSQL_DATABASE
db = MySQL(app)
# Kafka
TOPIC = "testtopic"
producer = KafkaProducer(
bootstrap_servers=['{}:9092'.format(KAFKA_HOST)],
value_serializer=lambda x: json.dumps(x).encode('utf-8'))
@app.route('/api/')
def home():
log("HOME")
# Pip package utils
num = add(1, 2)
# DB
from flask import Flask, render_template, request, jsonify, url_for, redirect
from db_learning import MyDB
import logging
from logging import FileHandler
from flask_mysql_connector import MySQL
from flask_cors import CORS, cross_origin
app = Flask(__name__)
CORS(app)
app.config['MYSQL_HOST'] = 'ms2'
app.config['MYSQL_USER'] = '******'
app.config['MYSQL_PASSWORD'] = '******'
app.config['MYSQL_DB'] = 'learning3'
cur = MySQL(app)
# setting logger
app.logger.setLevel("INFO")
for h in app.logger.handlers:
app.logger.removeHandler(h)
handler = FileHandler("backend.log")
handler.setLevel("INFO")
formatter = logging.Formatter(
'%(asctime)s :: %(levelname)s :: %(threadName)s :: %(message)s')
handler.setFormatter(formatter)
app.logger.addHandler(handler)
print(app.logger.handlers)
logging.getLogger("werkzeug").addHandler(handler)
# logger set
from flask import Flask, render_template, request, redirect, url_for, flash
from flask_mysql_connector import MySQL
app = Flask(__name__)
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = '******'
app.config['MYSQL_PASSWORD'] = '******'
app.config['MYSQL_DATABASE'] = 'tallermvc1'
app.config['MYSQL_PORT'] = '3307'
mysql = MySQL(app)
mysql = MySQL()
mysql.init_app(app)
app.secret_key = "mysecretkey"
@app.route('/')
def Index():
cur = mysql.connection.cursor()
cur.execute('SELECT * FROM persona')
data = cur.fetchall()
cur.close()
return render_template('index.html', persona = data)
@app.route('/add_persona', methods=['POST'])
def add_persona():
import sys
from flask import Flask
sys.path.append('../')
from flask_mysql_connector import MySQL, Params
app = Flask(__name__)
app.config[Params.MYSQL_USER] = 'root'
app.config[Params.MYSQL_DATABASE] = 'sys'
mysql = MySQL(app, ctx_key="num1")
mysql2 = MySQL(app, ctx_key="num2")
EXAMPLE_SQL = 'select * from sys.user_summary'
@app.route('/')
def new_cursor():
cur = mysql.new_cursor(dictionary=True)
cur.execute(EXAMPLE_SQL)
output = cur.fetchall()
response = app.response_class(response=str(output),
status=200,
mimetype='application/json')
return response
@app.route('/connection')
def connection():
conn = mysql2.connection
cur = conn.cursor()
