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)