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