def show(id):
mysql = connectToMySQL('users_schema')
query = "SELECT * FROM users WHERE id=%(id)s;"
data = {"id": int(id)}
user = mysql.query_db(query, data)
print(user)
return render_template("readone.html", user=user[0])
def index():
mysql = connectToMySQL(
'users_schema') # call the function, passing in the name of our db
users = mysql.query_db(
'SELECT * FROM users;'
) # call the query_db function, pass in the query as a string
# print(users)
return render_template("readall.html", all_users=users)
def home():
mysql = connectToMySQL('beam')
query = "SELECT first_name, last_name FROM users WHERE user_id = %(id)s"
data = {'id': session['user_id']}
result = mysql.query_db(query, data)
if result:
user_data = result[0]
return render_template('index.html', user_data=user_data)
def add_friend_to_db():
mysql = connectToMySQL('users_schema')
print(request.form)
query = "INSERT INTO users (first_name, last_name, email, uploaded_at)VALUES (%(fname)s, %(lname)s, %(email)s, %(NOW())s);"
data = {
"fname": request.form['fname'],
"lname": request.form['lname'],
"email": request.form['email']
}
mysql.query_db(query, data)
return redirect('/users')
def update(id):
mysql = connectToMySQL('users_schema')
print(request.form)
query = "UPDATE users SET first_name = %(first_name)s, last_name = %(last_name)s, email = %(email)s WHERE id = %(id)s;"
data = {
"first_name": request.form['fname'],
"last_name": request.form['lname'],
"email": request.form['email'],
"id": int(id)
}
mysql.query_db(query, data)
return redirect('/users')
def regis():
#validation
is_valid = True
if not EMAIL_REGEX.match(request.form['email']):
is_valid = False
flash("pleaes use a valid email address")
if len(request.form['first_name']) < 1:
is_valid = False
flash("please enter more than 1 character")
if len(request.form['last_name']) < 2:
is_valid = False
flash('please enter more than 2 characters')
if len(request.form['email']) < 3:
is_valid = False
flash("please enter more than 3 characters")
if request.form['password'] != request.form['c_password']:
is_valid = False
flash("passwords must match")
if not is_valid:
return redirect("/")
else:
## save to database
mysql = connectToMySQL('beam')
query = "INSERT into users(first_name, last_name, email, password, c_password, created_at, updated_at) VALUES(%(fn)s, %(ln)s, %(em)s, %(ps)s, %(cp)s, NOW(), NOW())"
hashed_pw = bcrypt.generate_password_hash(request.form['password'])
data = {
'fn': request.form['first_name'],
'ln': request.form['last_name'],
'em': request.form['email'],
'ps': request.form['password'],
'cp': request.form['c_password'],
}
results = mysql.query_db(
query, data) #[false, empytlist[], primary_key number ]
if results:
session['user_id'] = results
return redirect("/success")
def login():
is_valid = True
if len(request.form['email']) < 1:
is_valid = False
flash("Not valid email")
mysql = connectToMySQL('beam')
query = " SELECT * FROM users WHERE email = %(em)s"
data = {"em": request.form['email']}
result = mysql.query_db(query, data)
if result:
user_data = result[0]
bcrypt.check_password_hash(user_data['password'],
request.form['password'])
session['user_id'] = user_data['user_id']
return redirect("/success")
else:
is_valid = False
if not is_valid:
flash("email does not exist or invalid password")
return redirect("/")
from flask import Flask, render_template, redirect, request, session
from mysqlconnect import connectToMySQL
app = Flask(__name__)
app.secret_key = "HELLO"
mysql = connectToMySQL('lead_gen_business')
@app.route('/')
def index():
if 'query' in session:
print("")
else:
session['query'] = "SELECT CONCAT(clients.first_name, ' ', clients.last_name) AS 'name', COUNT(leads.leads_id) AS 'num_leads' from clients LEFT JOIN sites on sites.client_id = clients.client_id LEFT JOIN leads on leads.site_id = sites.site_id GROUP BY clients.client_id ORDER BY num_leads DESC"
session['all_clients'] = mysql.query_db(session['query'])
# start_date ="2011-01-01"
# end_date = "2015-03-25"
# session['query'] = f"SELECT CONCAT(clients.first_name, ' ', clients.last_name) AS 'name', COUNT(leads.leads_id) AS 'num_leads' from clients LEFT JOIN sites on sites.client_id = clients.client_id LEFT JOIN leads on leads.site_id = sites.site_id WHERE leads.registered_datetime >= DATE_FORMAT('{start_date}', '%Y') AND leads.registered_datetime <= DATE_FORMAT('{end_date}', '%Y') GROUP BY clients.client_id ORDER BY num_leads DESC"
print(session['query'])
return render_template("index.html", clients=session['all_clients'])
@app.route('/time', methods=['POST'])
def time():
print(request.form['start_date'])
print(type(request.form['start_date']))
start_date = request.form['start_date']
end_date = request.form['end_date']
session['query'] = f"SELECT CONCAT(clients.first_name, ' ', clients.last_name) AS 'name', COUNT(leads.leads_id) AS 'num_leads' from clients LEFT JOIN sites on sites.client_id = clients.client_id LEFT JOIN leads on leads.site_id = sites.site_id WHERE leads.registered_datetime >= DATE_FORMAT('{start_date}', '%Y') AND leads.registered_datetime <= DATE_FORMAT('{end_date}', '%Y') GROUP BY clients.client_id ORDER BY num_leads DESC"
# print(session['all_clients'])
return redirect('/')
if __name__ == "__main__":
app.run(debug=True)
def landing_page():
mysql = connectToMySQL('beam')
return render_template("login.html")
from flask import Flask, render_template, redirect, session, flash, request
from mysqlconnect import connectToMySQL
import re
app = Flask(__name__)
app.secret_key = "ThisIsSecret!"
mysql = connectToMySQL('email_list')
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
@app.route('/')
def index():
session['emails'] = mysql.query_db("SELECT * FROM emails;")
return render_template("index.html")
@app.route('/process', methods=['POST'])
def process():
if len(request.form['email']) < 1:
flash("Email cannot be blank!")
return redirect('/')
elif not EMAIL_REGEX.match(request.form['email']):
flash("Invalid Email Address!")
return redirect('/')
else:
for round in session['emails']:
if round['email'] == request.form['email']:
flash("The email is already taken")
return redirect('/')
else:
flash(
def delete(id):
mysql = connectToMySQL('users_schema')
query = "DELETE FROM users WHERE id=%(id)s;"
data = {"id": int(id)}
mysql.query_db(query, data)
return redirect("/users")
def edit(id):
mysql = connectToMySQL('users_schema')
query = "SELECT * FROM users WHERE id=%(id)s;"
data = {"id": int(id)}
user = mysql.query_db(query, data)
return render_template('edit.html', user=user[0])
from flask import Flask, render_template, request, session, redirect
from mysqlconnect import connectToMySQL
app = Flask(__name__)
app.secret_key = "hello"
mysql = connectToMySQL('friendsdb')
@app.route('/')
def index():
all_friends = mysql.query_db("SELECT * FROM friends")
print("Fetched all friends", all_friends)
return render_template('index.html', friends=all_friends)
@app.route('/create_friend', methods=['POST'])
def create():
query = "INSERT INTO friends (first_name, last_name, occupation, created_at, updated_at) VALUES (%(first_name)s, %(last_name)s, %(occupation)s, NOW(), NOW());"
data = {
'first_name': request.form['first_name'],
'last_name': request.form['last_name'],
'occupation': request.form['occupation']
}
mysql.query_db(query, data)
return redirect('/')
if __name__ == "__main__":
app.run(debug=True)
