def create():
mysql = connectToMySQL("friendsdb")
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']
}
new_friend_id = mysql.query_db(query, data)
return redirect('/')
def index():
mysql = connectToMySQL("emailvalidationdb")
all_emails = mysql.query_db("SELECT * FROM emails")
return render_template("index.html", emails=all_emails)
def delete_review(id):
mysql = connectToMySQL("majorrater")
data = {"id": id}
query = "DELETE FROM reviews where id = %(id)s"
mysql.query_db(query, data)
return redirect("/")
def unlike_quote(p_id):
mysql = connectToMySQL(SCHEMA)
query = "DELETE FROM users_likes_quotes WHERE users_id = %(uid)s AND quotes_id = %(pid)s"
data = {'uid': session['user_id'], 'pid': p_id}
mysql.query_db(query, data)
return redirect("/dash")
def login_register():
mysql = connectToMySQL('private_wall')
users = mysql.query_db('SELECT * FROM users;')
print(users)
return render_template('log_reg_page.html')
def all():
db = connectToMySQL(SCHEMA)
query = "SELECT * FROM locations;"
location_list = db.query_db(query)
return location_list
def users():
mysql = connectToMySQL('semi-restful_users')
friends = mysql.query_db('SELECT * FROM friends;')
return render_template("index.html", all_friends = friends)
def all_users():
db = connectToMySQL('users')
user_list = db.query_db('SELECT * FROM users;')
return render_template("index.html", user_list = user_list)
def delete_user(num):
mysql = connectToMySQL('user')
delete_this_user = mysql.query_db("DELETE FROM users WHERE (`user_id` =" +
num + ");")
return redirect('/')
def edit_user(num):
mysql = connectToMySQL('user')
this_user = mysql.query_db("SELECT * FROM users WHERE user_id =" + num +
";")
print(this_user)
return render_template('update.html', user_info=this_user[0])
def show_user(num):
mysql = connectToMySQL('user')
one_user = mysql.query_db("SELECT * FROM users WHERE user_id =" + num +
";")
print(one_user)
return render_template('one_user.html', user_info=one_user[0])
def index():
mysql = connectToMySQL('user')
users = mysql.query_db('SELECT * FROM users;')
print(users)
return render_template('index.html', all_users=users)
def create():
mysql = connectToMySQL('somethingnew')
email_verify = mysql.query_db("SELECT email FROM user;")
passStrength = 0
query = "INSERT INTO user (first_name,last_name,email,password_hash) VALUES (%(first_name)s, %(last_name)s, %(email)s, %(password)s);"
hidden = {
'password': request.form['password'],
'password_confirm': request.form['password_confirm']
}
if hidden['password']:
pw_hash = bcrypt.generate_password_hash(hidden['password'])
else:
flash('Password must be at least 8 characters long!', 'password')
return redirect('/')
data = {
'password': pw_hash,
'email': request.form['email'],
'first_name': request.form['first_name'],
'last_name': request.form['last_name']
}
password = request.form['password']
for email in email_verify:
if email['email'] == data['email']:
flash("Email already exists!", 'email')
if len(data['email']) < 1:
flash("Email cannot be blank!", 'email')
elif not EMAIL_REGEX.match(data['email']):
flash("Invalid Email Address!", 'email')
if len(data['first_name']) < 1:
flash("Name cannot be blank!", 'first_name')
elif len(data['first_name']) <= 2:
flash("Name must be 2+ characters", 'first_name')
if len(data['last_name']) < 1:
flash("Name cannot be blank!", 'last_name')
elif len(data['last_name']) <= 2:
flash("Name must be 2+ characters", 'last_name')
if hidden['password'] != hidden['password_confirm']:
flash('Passwords do not match!', 'password')
passFlash = []
if (len(password) >= 8): #tests if password is at least of length 8
passStrength += 1
else:
passFlash.append(
['Password should be at least 8 characters long!', 'password'])
if (re.compile(r'.*[A-Z].*[A-Z]').match(password)
): #tests for at least 2 capital letters
passStrength += 1
else:
passFlash.append(
["Password should contain one capital letter", 'password'])
if (re.compile(r'.*[!@#$&*]').match(password)
): #tests for at least one special character
passStrength += 1
else:
passFlash.append(
["Password should contain one special character", 'password'])
if (re.compile(r'.*[0-9].*[0-9]').match(
hidden['password'])): #tests for at least 2 digits
passStrength += 1
else:
passFlash.append(
["Password should contain at least two digits", 'password'])
if (re.compile(r'.*[a-z].*[a-z].*[a-z]').match(
hidden['password'])): #tests for at least 3 lower case letters
passStrength += 1
else:
passFlash.append([
"Password should contatin at least 3 lower case letters",
'password'
])
if passStrength < 3:
for flashed in passFlash:
flash(flashed[0], flashed[1])
if '_flashes' in session.keys():
return redirect("/")
else:
mysql = connectToMySQL('somethingnew')
new_user_id = mysql.query_db(query, data)
session['user_id'] = new_user_id
session['first_name'] = data['first_name']
flash("You have successfully registered!", 'home')
return redirect('/home')
def like_tweet(tweet_id):
mysql = connectToMySQL(database)
query = "INSERT INTO liked_tweets (user_id, tweet_id) VALUES (%(user_id)s, %(tweet_id)s)"
data = {'user_id': session['user_id'], 'tweet_id': tweet_id}
mysql.query_db(query, data)
return redirect("/success")
def index():
mysql = connectToMySQL("friendsdb")
all_friends = mysql.query_db("SELECT * FROM friends")
print("Fetched all friends", all_friends)
return render_template('index.html', friends=all_friends)
def index():
mysql = connectToMySQL(db_name)
query = "SELECT * from friends;"
query_result = mysql.query_db(query)
return render_template('index.html', friends=query_result)
def validate_reg():
is_valid = True
if len(request.form['fname']) < 2:
is_valid = False
flash("Please enter a valid name.")
if len(request.form['fname']) > 20:
is_valid = False
flash("First name is too long. Name must be less than 20 characters.")
elif not (request.form['fname']).isalpha():
is_valid = False
flash("Please enter letters (a-z) only.")
if len(request.form['lname']) < 2:
is_valid = False
flash("Please enter a valid last name")
if len(request.form['lname']) > 20:
is_valid = False
flash("Last name is too long. Name must be less than 20 characters.")
elif not (request.form['lname']).isalpha():
is_valid = False
flash("Please enter letters (a-z) only.")
if len(request.form['email']) < 2:
is_valid = False
flash("Please enter a valid email address.")
if len(request.form['email']) > 20:
is_valid = False
flash("Email address is too long.")
elif not EMAIL_REGEX.match(request.form['email']):
is_valid = False
flash('Invalid email address.')
if len(request.form['password']) == '':
is_valid = False
flash("Password cannot be blank")
elif len(request.form['password']) < 8:
is_valid = False
flash("Password must be at least 8 characters.")
if len(request.form['password']) > 20:
is_valid = False
flash("Password must not exceed 20 characters.")
if len(request.form['confirm_password']) == '':
is_valid = False
flash('Please confirm password')
elif request.form['confirm_password'] != request.form['password']:
is_valid = False
flash('Passwords do not match.')
mysql = connectToMySQL("login")
query = "SELECT * FROM users WHERE email = %(em)s;"
data = {"em": request.form["email"]}
result = mysql.query_db(query, data)
if len(result) > 0:
is_valid = False
flash("Email already taken. If already registered, try logging in.")
if not is_valid:
return redirect("/")
else:
pw_hash = bcrypt.generate_password_hash(request.form['password'])
print(pw_hash)
mysql = connectToMySQL("login")
query = "INSERT INTO users (first_name, last_name, email, password, created_at, updated_at) VALUES (%(fn)s, %(ln)s, %(em)s, %(password_hash)s, NOW(), NOW());"
data = {
"fn": request.form['fname'],
"ln": request.form['lname'],
"em": request.form['email'],
"password_hash": pw_hash,
}
db = connectToMySQL('login')
id = mysql.query_db(query, data)
print(id)
return redirect('/success')
def destroy(id):
db = connectToMySQL('users')
query = 'DELETE FROM users WHERE id = %(id)s;'
data ={'id': int(id)}
db.query_db(query,data)
return redirect('/users')
def home():
mysql = connectToMySQL('semirestful')
query = 'SELECT * FROM users'
result = mysql.query_db(query)
return render_template('home.html', userallinfo=result)
def users():
mysql = connectToMySQL("flask_users")
users = mysql.query_db("SELECT * FROM users WHERE deleted IS NULL;")
print(users)
return render_template("users.html", user_data = { 'user_list': users })
def deleteuser(userid):
mysql = connectToMySQL('semirestful')
query = 'DELETE FROM users WHERE id=%(id)s;'
data = {'id': userid}
result = mysql.query_db(query, data)
return redirect('/users')
def recieve():
query = "SELECT * FROM posts JOIN users ON posts.sender_id = users.id ORDER BY posts.created_at DESC"
posts = connectToMySQL('private_wall').query_db(query)
print(posts)
return render_template("main_wall.html", posts = posts)
def success():
mysql = connectToMySQL('email_data')
the_emails = mysql.query_db('SELECT * FROM emails;')
return render_template('success.html', emaildata = the_emails)
def like_quote(p_id):
mysql = connectToMySQL(SCHEMA)
query = "INSERT INTO users_likes_quotes (users_id, quotes_id, created_at, updated_at) VALUES (%(uid)s, %(pid)s, NOW(), NOW());"
data = {'uid': session['user_id'], 'pid': p_id}
mysql.query_db(query, data)
return redirect("/dash")
from flask import Flask, render_template, request, redirect, flash, session
from mysqlconnection import connectToMySQL
import re
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
name_regex = re.compile(r'^[a-zA-Z]+$')
mysql = connectToMySQL('users_flask')
app = Flask(__name__)
app.secret_key = "Secretusers"
@app.route('/')
@app.route('/users')
def index():
query = f"SELECT * FROM users;"
users = mysql.query_db(query)
return render_template("userindex.html", users = users)
@app.route('/users/new')
def new():
return render_template("newuser.html")
@app.route('/users/create', methods = ['POST'])
def create():
first_name = request.form['first_name']
last_name = request.form['last_name']
email = request.form['email']
if len(first_name) < 2:
flash(u"The first name should be two or more characters long.", 'first_name')
def users_new():
valid = True
if len(request.form['first_name']) < 2:
flash("First name must be longer")
valid = False
if len(request.form['last_name']) < 2:
flash("Last name must be longer")
valid = False
if len(request.form['username']) < 3:
flash("Username must be longer")
valid = False
if not EMAIL_REGEX.match(request.form['email']):
flash("Email must be valid")
valid = False
if len(request.form['password']) < 8:
flash("Password must be at least 8 characters")
valid = False
if INVALID_PASSWORD_REGEX.match(request.form['password']):
flash(
"Password must have at least one uppercase character and at least one number"
)
valid = False
if request.form['password'] != request.form['confirm']:
flash("Passwords must match")
valid = False
mysql = connectToMySQL(SCHEMA)
query = 'SELECT id FROM users WHERE username=%(username)s;'
data = {'username': request.form['username']}
existing_username = mysql.query_db(query, data)
if existing_username:
flash("Username already in use")
valid = False
mysql = connectToMySQL(SCHEMA)
query = 'SELECT id FROM users WHERE email=%(email)s;'
data = {'email': request.form['email']}
existing_email = mysql.query_db(query, data)
if existing_email:
flash("Email already in use")
valid = False
if not valid:
return redirect('/')
pw_hash = bcrypt.generate_password_hash(request.form['password'])
mysql = connectToMySQL(SCHEMA)
query = "INSERT INTO users (first_name, last_name, email, username, pw_hash, created_at, updated_at) VALUES (%(first)s, %(last)s, %(mail)s, %(un)s, %(pw)s, NOW(), NOW());"
data = {
'first': request.form['first_name'],
'last': request.form['last_name'],
'mail': request.form['email'],
'un': request.form['username'],
'pw': pw_hash
}
user_id = mysql.query_db(query, data)
session['user_id'] = user_id
return redirect('/dash')
def register():
mysql = connectToMySQL("email_registration")
users = mysql.query_db("SELECT * FROM users;")
print(users)
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
PW_REGEX = re.compile(
r'^.*(?=.{8,10})(?=.*[a-zA-Z])(?=.*?[A-Z])(?=.*\d)[a-zA-Z0-9!@£$%^&*()_+={}?:~\[\]]+$'
)
firstName = request.form['first_name']
lastName = request.form['last_name']
email = request.form['email']
password = request.form['password']
conPassword = request.form['passwordConfirm']
isValid = True
if len(firstName) <= 0:
isValid = False
flash('Please enter a first name', 'name')
if not firstName.isalpha():
isValid = False
flash('Please enter a first name using only alphabetic characters',
'name')
if len(lastName) <= 0:
isValid = False
flash('Please enter a last name', 'name')
if not lastName.isalpha():
isValid = False
flash('Please enter a last name using only alphabetic characters',
'name')
if len(email) <= 3:
isValid = False
flash('Please enter an email address', 'email')
if not EMAIL_REGEX.match(request.form['email']):
isValid = False
flash("Invalid email address!", 'email')
if not PW_REGEX.match(request.form['password']):
isValid = False
flash(
"Invalid password! Minimum 8 characters, 1 number, and 1 special character",
'password')
if len(password) <= 4:
isValid = False
flash('Please enter a valid password (minimum 5 characters)',
'password')
if not password == conPassword:
isValid = False
flash('Password doesnt match confirm password', 'password')
if isValid == True:
mysql = connectToMySQL("email_registration")
query = "INSERT INTO users (first_name, last_name, email, password) VALUES (%(fname)s, %(lname)s, %(email)s, %(pw)s);"
data = {
"fname": firstName,
"lname": lastName,
"email": email,
"pw": password
}
new_user_id = mysql.query_db(query, data)
mysql = connectToMySQL("email_registration")
users = mysql.query_db("SELECT * FROM users;")
print(users)
flash('Success!')
return redirect('/')
else:
return redirect('/')
from flask import Flask, flash, redirect, render_template, request, url_for, session
from mysqlconnection import connectToMySQL
import re
app = Flask(__name__, template_folder="templates")
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
app.secret_key = 'randomstring'
mysql = connectToMySQL('emailvalidationdb')
@app.route('/', methods=['GET'])
def index():
mysql = connectToMySQL("emailvalidationdb")
all_emails = mysql.query_db("SELECT * FROM emails")
return render_template("index.html", emails=all_emails)
@app.route('/email', methods=['POST'])
def create():
email = request.form['email']
mysql = connectToMySQL("emailvalidationdb")
query = "SELECT * FROM emails WHERE email = some_email"
data = {'some_email': request.form['email']}
email = request.form['email']
if len(email) < 1:
flash("Email cannot be blank!", 'error')
return redirect('/')
if mysql.query_db(query, data):
mysql = connectToMySQL("emailvalidationdb")
flash("Email already in use!", 'error')
return redirect('/')
def index():
mysql = connectToMySQL("email_registration")
users = mysql.query_db("SELECT * FROM users;")
print(users)
return render_template("index.html", all_users=users)
from flask import Flask, render_template, redirect, request
from mysqlconnection import connectToMySQL
mysql = connectToMySQL('friendsdb')
print("all the users", mysql.query_db("SELECT * FROM friends;"))
app=Flask(__name__)
@app.route('/')
def index():
mysql = connectToMySQL("friendsdb")
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():
mysql = connectToMySQL("friendsdb")
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']
}
new_friend_id = mysql.query_db(query, data)
return redirect('/')
from flask import Flask, render_template, redirect, request
from mysqlconnection import connectToMySQL
mysql = connectToMySQL('friendsdb')
print("all the users", mysql.query_db("SELECT * FROM friends;"))
app = Flask(__name__)
@app.route('/')
def index():
mysql = connectToMySQL("friendsdb")
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():
mysql = connectToMySQL("friendsdb")
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']
}
new_friend_id = mysql.query_db(query, data)
return redirect('/')
def index():
mysql = connectToMySQL("friendsdb")
all_friends = mysql.query_db("SELECT * FROM friends")
print("Fetched all friends", all_friends)
return render_template('index.html', friends=all_friends)
from flask import Flask, render_template, request, session, redirect, flash
from flask_bcrypt import Bcrypt
from mysqlconnection import connectToMySQL
import re
app = Flask(__name__)
bcrypt = Bcrypt(app)
app.secret_key = 'whatsecret?'
EMAIL_REGEX = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
mysql = connectToMySQL('sti')
@app.route("/")
def index():
if 'Fname' not in session:
session['Fname'] = ""
if 'lname' not in session:
session['Lname'] = ""
if 'Mail' not in session:
session['Mail'] = ""
return render_template("index.html",
Fname=session['Fname'],
Lname=session['Lname'],
Email=session['Mail'])
@app.route('/create', methods=['POST'])
def create():
if len(request.form['Fname']) < 2:
flash("First Name cannot be blank!")
return redirect("/")