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)
