from flask import Flask from mysqlconnection import MySQLConnector app = Flask(__name__) mysql = MySQLConnector('mydb') print mysql.fetch('SELECT * FROM users') app.run(debug=True)
from flask import Flask # import the Connector function from mysqlconnection import MySQLConnector app = Flask(__name__) # connect and store the connection in "mysql" note that you pass the database name to the function mysql = MySQLConnector('mydb') # an example of running a query print mysql.fetch("SELECT * FROM users") app.run(debug=True)
from flask import Flask # import the Connector function from mysqlconnection import MySQLConnector app = Flask(__name__) # connect and store the connection in "mysql" note that you pass the database name to the function mysql = MySQLConnector('mydb') # an example of running a query print mysql.fetch("Select * From users") app.run(debug=True)
from flask import Flask, request, redirect, render_template, session, flash from mysqlconnection import MySQLConnector app = Flask(__name__) app.secret_key = 'Secret' mysql = MySQLConnector('full_friendsdb') friends = mysql.fetch("SELECT * FROM friends") def find_friend(id): for friend in friends: if friend['id'] == int(id): return friend return False @app.route('/', methods=['GET']) def index(): friends = mysql.fetch("SELECT * FROM friends") return render_template('index.html', friends=friends) @app.route('/friends', methods=['POST']) def create(): query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES ('{}', '{}', '{}', NOW(), NOW())".format(request.form['first_name'], request.form['last_name'], request.form['occupation']) print query mysql.run_mysql_query(query) return redirect('/') @app.route('/friends/<id>/edit', methods=['GET']) def edit(id): print id friend = find_friend(id) if friend:
from flask import Flask # import the Connector function from mysqlconnection import MySQLConnector app = Flask(__name__) # connect and store the connection in "mysql" note that you pass the database name to the function mysql = MySQLConnector('mydb1') # an example of running a query print mysql.fetch("Select * From users") app.run(debug=True)