def test():
'''
Directly, URL don't open any page. That's intermediate URL for
processing data, reveived from HTML-forms
'''
try:
variables.my_email_error[0], variables.my_password_error[
0] = None, None
if current_user.is_authenticated:
return redirect(url_for('render_table'))
form = register_form()
if form.validate_on_submit():
password = hash.hashing(register_form().password.data)
email = register_form().email.data
user_info_to_db = users(email=register_form().email.data,
user_password=password)
db.session.add(user_info_to_db)
db.session.commit()
email = users.query.filter_by(email=form.email.data).first()
login_user(email, remember=register_form().remember.data)
flash(f'accounted created for {register_form().email.data}')
return redirect(url_for('tg_autentification'))
# put errors in variables. That's not "musthave", but it's more comfortable in my case for me
if form.email.errors:
for error in form.email.errors:
variables.my_email_error[0] = error
if form.password.errors:
for error in form.password.errors:
variables.my_password_error[0] = error
# have finished to put
return redirect(url_for('errors'))
except Exception as ex:
config_file.ex_catcher(current_user.id, "test", ex)
return redirect(url_for('dope_shit', ex=ex))
def register():
if request.method == "POST":
pass1 = request.form.get("pass1")
pass2 = request.form.get("pass2")
# ensure both passwords are same
if pass1 != pass2:
return render_template("error.html", title = "error", message = "The passwords you entered, Do not match!")
# to encrypt password
hash = pwd_context.encrypt(pass1)
u = users(request.form.get("name"), request.form.get("roll"),request.form.get("email"), request.form.get("username"), hash, 0, 0)
db.session.add(u)
try:
db.session.commit()
except:
return render_template("error.html", title = "error", message = "Username exist! or Something went Wrong.. Can't add you to database! ")
# loging in the user
session["user_id"] = u.id
# redirect user to start page
return redirect(url_for("start"))
else:
return render_template( 'register.html', title='Sign Up', year= datetime.datetime.now().year)
def post(self):
login = users()
content = request.get_json()
login.email = content.get("email")
password = bytes(str(content.get("password")), encoding='utf-8')
respuesta = login.get_user()
if (respuesta):
password_db = bytes(respuesta[0][4], 'utf-8')
nombres = respuesta[0][1]
if bcrypt.checkpw(password, password_db):
encoded_jwt = jwt.encode(
{
'exp':
datetime.datetime.utcnow() +
datetime.timedelta(hours=24),
'id':
respuesta[0][0],
'email':
respuesta[0][3]
},
KEY_TOKEN_AUTH,
algorithm='HS256')
return jsonify({
"Status": "Login exitoso",
"token": str(encoded_jwt),
'name': respuesta[0][1],
'img': respuesta[0][5],
'surname': respuesta[0][2],
'activated': respuesta[0][6]
})
return jsonify({"Status": "Login incorrecto 22"}), 400
else:
return jsonify({"Status": "Login incorrecto 11"}), 500
def register():
if session["user_type"] != 3:
flash("Apenas usuários de nível elevado podem acessar essa página!",
"error")
return redirect(url_for('home'))
if request.method == "POST":
search = users.query.filter_by(login=request.form["login"]).first()
if search is not None:
flash("Login já existente na base de dados!", "error")
return redirect(url_for('register'))
user = users(name=request.form["name"].upper(),
login=request.form["login"],
email=request.form["email"],
password=request.form["password"],
site=request.form["aonde"].upper(),
level=request.form["level"],
active=1,
created_at=dt.now(),
updated_at=dt.now())
db.session.add(user)
db.session.commit()
flash("Usuário cadastrado com sucesso!", "success")
unidades = sites.query.filter_by(ativo=1).order_by(sites.unidade.asc())
return render_template("register.html", unidades=unidades)
else:
unidades = sites.query.filter_by(ativo=1).order_by(sites.unidade.asc())
return render_template("register.html", unidades=unidades)
def reg():
check_email = users.query.filter(users.email == request.form['email']).first()
messages = dict()
generate = generate_password_hash(request.form['password'])
try:
if len(request.form['full_name'])<3:
messages['full_name'] = 'Your name is too short'
if len(request.form['password'])<6:
messages['password'] = '******'
if request.form['password'] != request.form['verify_password']:
messages['verify_password'] = '******'
if not validate_email(request.form['email']):
messages['email'] = 'Email is not valid'
if check_email and check_email.email == request.form['email']:
messages['email'] = 'Email already exists'
if len(messages) > 0:
return redirect(url_for('signup', messages=json.dumps(messages)))
new_user = users(full_name = request.form['full_name'],email= request.form['email'], password = generate ,role_id = 2)
db.session.add(new_user)
db.session.commit()
return redirect(url_for('login'))
except:
pass
return(redirect(url_for('signup',messages=json.dumps(messages))))
def post(self):
profile = users()
content = request.get_json()
profile.id = int(content.get("user"))
profile.img = content.get("img")
answer = profile.save_picture()
return jsonify({'img': profile.img}), 200
def handle_register():
body = request.get_json()
if body is None:
raise APIException(
"You need to specify the request body as a json object",
status_code=400)
if 'firstname' not in body and 'lastname' not in body:
raise APIException("You need to specify the first name and last name",
status_code=400)
if 'password' not in body and 'email' not in body:
raise APIException("You need to specify the password and email",
status_code=400)
if 'firstname' not in body:
raise APIException('You need to specify the first name',
status_code=400)
if 'lastname' not in body:
raise APIException('You need to specify the last name',
status_code=400)
if 'password' not in body:
raise APIException('You need to specify the password', status_code=400)
if 'email' not in body:
raise APIException('You need to specify the email', status_code=400)
db.session.add(
users(email=body['email'],
firstname=body['firstname'],
lastname=body['lastname'],
password=sha256(body['password']),
admin=0))
db.session.commit()
return jsonify({'register': 'success', 'msg': 'Successfully Registered'})
def get(self, id):
profile = users()
profile.id = int(id)
answer = profile.bring_profile()
if (answer):
return jsonify(answer), 200
return jsonify(), 400
def regiser():
if request.method == 'POST':
content = request.get_json()
username = content['username']
password = base64.b64encode(content['password'])
email = content['email']
if db.session.query(
models.users).filter_by(username=username).scalar() is not None:
status = 1
message = 'Username already exists'
response = {'status': status, 'message': message, 'username': username}
return jsonify(response)
else:
status = 0
message = 'Success'
if db.session.query(
models.users).filter_by(email=email).scalar() is not None:
status = 1
message = 'Email address already exists'
response = {'status': status, 'message': message, 'username': username}
return jsonify(response)
else:
status = 0
message = 'Success'
register_user = models.users(username=username,
password=password,
email=email)
db.session.add(register_user)
db.session.commit()
message = {'status': status, 'message': message, 'username': username}
return jsonify(message)
def createaccount():
if request.method == 'POST':
if 5 > len(
request.form.get('username')
) > 12: # if the length of the inputted username is lesser than 5 and greater than 12 (characters)
return render_template(
'createaccount.html',
error='username must be between 5 and 12 characters'
) # account will not be created with said username and user is prompted to input a shorter/longer username
elif models.users.query.filter(
models.users.username == request.form.get('username')).first(
): # if the username already exists in the db
return render_template(
'createaccount.html', error='username already in use'
) # account will not be created and user is prompted to use a different username
elif len(request.form.get('password')) < 7: #
return render_template(
'createaccount.html',
error='password must be a minimum of 7 characters')
else:
user_info = models.users(
username=request.form.get(
'username'), # takes username from form
password=generate_password_hash(
request.form.get('password'), salt_length=10
), # takes password inputted in form and salts and hashes it for encryption
gamesWon=0,
gamesLost=0)
db.session.add(user_info)
db.session.commit()
return render_template('createaccount.html')
def post(self):
Rp = users()
content = request.get_json()
Rp.id = content.get('id')
answer = Rp.reportG()
if (answer):
return jsonify(answer), 200
return jsonify(), 400
def post(self):
profile = users()
content = request.get_json()
profile.id = int(content.get("id"))
profile.name = content.get("name")
profile.surname = content.get("surname")
answer = profile.edit_name()
return jsonify({'name': profile.name, 'surname': profile.surname}), 200
def submitRegistration():
special_char = re.compile('[@_!#$%^&*()<>?/\|}{~:]')
email_char = re.compile(r'^[a-zA-Z0-9.+_-]+@[a-zA-Z0-9._-]+\.[a-zA-Z]+$')
is_valid = True
if len(request.form['first_name']) < 1:
is_valid = False
flash("Must enter first name")
if len(request.form['last_name']) < 1:
is_valid = False
flash("Must enter last name")
if len(request.form['pw']) < 5:
is_valid = False
flash("Password must be more than 5 characters")
if special_char.search(request.form['pw']) == None:
is_valid = False
flash("Password must contain a special character")
if any(char.isdigit() for char in request.form['pw']) == False:
is_valid = False
flash("Password must contain a number")
if request.form['pw'] != request.form['c_pw']:
is_valid = False
flash("Passwords must match")
if special_char.search(request.form['first_name']) != None:
is_valid = False
flash("First name cannot contain special characters")
if special_char.search(request.form['last_name']) != None:
is_valid = False
flash("Last name cannot contain special characters")
if any(char.isdigit() for char in request.form['first_name']) == True:
is_valid = False
flash("First name cannot contain a number")
if any(char.isdigit() for char in request.form['last_name']) == True:
is_valid = False
flash("Last name cannot contain a number")
if len(request.form['email']) < 1:
is_valid = False
flash("Must enter email")
elif not email_char.match(request.form['email']):
is_valid = False
flash("Incorrect format for email")
for user in users.query.all():
if request.form['email'] == user.email:
is_valid = False
flash("Email is already registered")
if is_valid:
pwd_hash = bcrypt.generate_password_hash(request.form["pw"])
newUser = users(first_name=request.form["first_name"],
last_name=request.form["last_name"],
email=request.form["email"],
password=pwd_hash)
db.session.add(newUser)
db.session.commit()
session["loggedInUserID"] = newUser.id
return redirect('/resetHome')
return redirect('/register')
def clean2(self):
cleaned_data = super(Form_connection, self).clean()
username = self.cleaned_data.get('username')
password = self.cleaned_data.get('password')
if not users(Name=username, password=password):
raise forms.ValidationError("Wrong Login or Password or Both")
return self.cleaned_data
def sign_up(message=None):
if request.method == 'POST':
if 'SignUp' in request.form:
if not request.form['email'] or not request.form[
'username'] or not request.form[
'password'] or not request.form[
'DOB'] or not request.form['passwordconfirm']:
flash('Please enter all the fields', 'error')
else:
x = users.query.filter_by(
username=request.form['username']).first()
if request.form['password'] != request.form['passwordconfirm']:
message = 'Passwords Don\'t Match'
if x is None:
img = request.files['profile_pic']
img.save(secure_filename(img.filename))
os.system("mv " + secure_filename(img.filename) +
" ./static/")
user = users(email=request.form['email'],
username=request.form['username'],
password=request.form['password'],
DOB=request.form['DOB'],
profile_pic_url=secure_filename(img.filename),
name=request.form['name'],
bio=request.form['bio'])
user_friends = friends(username=request.form['username'])
DB.session.add(user)
DB.session.add(user_friends)
DB.session.commit()
return redirect(
url_for('app_blueprint.profile_page',
username=request.form['username']))
else:
message = 'Username already taken'
elif 'SignIn' in request.form:
if request.form['username'] is '':
message = "Please Enter Username"
elif not request.form['password']:
message = "Please Enter Password"
else:
x = users.query.filter_by(
username=request.form['username']).first()
if x is None:
message = "Incorrect Username"
elif request.form['password'] is None:
message = 'Please Enter Password'
elif str(x.password) == str(
request.form['password']) and x is not None:
return redirect(
url_for('app_blueprint.profile_page',
username=request.form['username']))
elif str(x.password) != str(request.form['password']):
message = "Incorrect Password"
return render_template('home.html', message=message)
def post(self):
content = request.get_json()
recover = users()
recover.email = content.get('email')
recover.code = random.randint(1000000000, 9999999999)
respuesta = recover.send_email_recover()
if (respuesta):
RecuperarContrasena(recover.email, recover.code)
return jsonify(), 200
return jsonify(), 400
def load_users(user_filename):
for i, row in enumerate(open(user_filename)):
if row[0]!='i':
row = row.rstrip()
user_id, username, password, first_name, last_name, age, nationality, picture_url, email, role, auto_scratch, home_country, fb_user_id, fb_access_token= row.split(",")
user = users(username=username, password=password, first_name=first_name, last_name=last_name,
age=age, nationality=nationality, picture_url=picture_url, email=email, role=role, auto_scratch=auto_scratch, home_country=home_country, fb_user_id=fb_user_id, fb_access_token=fb_access_token)
db.session.add(user)
db.session.commit()
def get(self, id):
recover = users()
recover.code = str(id)
check = recover.check_code()
if check:
if check == 'valid':
return jsonify({'codestatus': True, 'code': recover.code}), 200
else:
return jsonify({'codestatus': False}), 200
else:
return jsonify(), 404
def register():
messages = dict()
res = users.query.filter(
users.username == request.form['username']).first()
if not res:
res = users.query.filter(users.email == request.form['email']).first()
try:
if res and res.username == request.form['username']:
messages['username'] = '******'
if len(request.form['username']) < 1:
messages['username'] = '******'
if res and res.email == request.form['email']:
messages['email'] = 'Email already exists!'
if len(request.form['password']) < 8:
messages['password'] = '******'
if len(request.form['password']) < 1:
messages['password'] = '******'
if request.form['password'] != request.form['confpass']:
messages['confpass'] = '******'
if not validate_email(request.form['email']):
messages['email'] = 'Email is not valid'
if len(messages) > 0:
return redirect(url_for('reg', messages=json.dumps(messages)))
user = users(username=request.form['username'],
email=request.form['email'],
password=request.form['password'])
# user.set_password('P@ssw0rd')
db.session.add(user)
db.session.commit()
if request.form.get('exampleRadios') == 'Seller':
user_role = role_user(user_id=user.id, role_id=2)
db.session.add(user_role)
db.session.commit()
elif request.form.get('exampleRadios') == 'Buyer':
user_role = role_user(user_id=user.id, role_id=3)
db.session.add(user_role)
db.session.commit()
return redirect(url_for('login'))
except exc.IntegrityError as e:
db.session().rollback()
return redirect(url_for('reg', messages=json.dumps(messages)))
def new_user():
if request.method == 'GET':
mm = m.users.query.all()
dm = [i.to_dict(i) for i in mm]
return jsonify(dm)
if request.method == 'POST':
req = request.get_json(force=True)
u = m.users(id=req.get('id'),
name=req.get('name'),
nickname=req.get('nickname'),
language_code=req.get('language_code'),
is_bot=req.get('is_bot'))
u.add()
return str(u.id)
def post(self):
profile = users()
content = request.get_json()
password = content.get('password')
validatepassword = content.get('validatepassword')
if (password == validatepassword):
salt = bcrypt.gensalt()
profile.password = bcrypt.hashpw(
bytes(str(password), encoding='utf-8'), salt)
profile.id = content.get('id')
answer = profile.change_password()
return jsonify(), 200
else:
return jsonify(), 400
def connection(request):
if request.POST:
form = Form_connection(request.POST)
if form.is_valid():
username = form.cleaned_data["username"]
password = form.cleaned_data["password"]
user = users(Name=username, password=password)
if user:
login(request, user)
#return HttpResponse("You are now connected")
else:
return render(request, 'vine/connection.html', {'form': form})
else:
form = Form_connection()
return render(request, 'vine/connection.html', {'form': form})
def handle_message(event):
user_id = event.source.user_id
profile = line_bot_api.get_profile(user_id)
insert_data = users(userid=user_id, display_name=profile.display_name)
insert_data.new_user()
if event.message.text == 'timeline':
# flex = t.main()
flex = tl.make_json()
with open ('tmp.txt', 'w', encoding='utf-8') as f:
f.write(flex)
parsed_json = json.loads(flex)
message = FlexSendMessage(
alt_text='timeline_sample',
contents=parsed_json,
)
line_bot_api.reply_message(event.reply_token, message)
def home_view(request):
if request.method == "GET":
form = SignUp_form()
return render(request, 'home.html', {'form': form})
else:
form = SignUp_form(request.POST)
if form.is_valid():
name = form.cleaned_data['name']
email = form.cleaned_data['email']
username = form.cleaned_data['username']
password = form.cleaned_data['password']
if len(username) >= 4 and len(password) >= 5:
password = make_password(password)
new_user = users(name=name,
email=email,
username=username,
password=password)
send_mail(
'Welcome Onboard',
'Welcome to the great world of instagram clone where you can post like and comment instantaneously!',
'*****@*****.**',
[email],
fail_silently=False,
)
new_user.save()
success_msg = 'Email sent to your email address!'
return render(request, 'login.html', {'success': success_msg})
else:
error_msg = 'Name or password is too short!'
return render(request, 'home.html', {'error': error_msg})
else:
error_msg = form.errors
new_error = ""
for error in error_msg:
new_error = new_error + " " + error
for msg in error_msg[error]:
new_error = new_error + ":" + msg + " "
print new_error
form = SignUp_form()
return render(request, 'home.html', {
'form': form,
'error': new_error
})
def init_users():
users_table = users()
fnames = ["Jill", "Jack", "Bob", "John"]
lnames = ["Batman", "Robin", "Brown", "Something'Clever"]
emails = ["*****@*****.**", "*****@*****.**", "*****@*****.**", "*****@*****.**"]
address1s = ["12 hotdog ln", "44 basic road", "32 east 2nd st"]
address2s = ["apartment 2", "apartment 3", "apartment 4"]
cities = ["new york city", "boston", "atlanta", "portland"]
states = ["new york", "massachussetts", "georgia", "oregon"]
phones = ["999-999-9999", "222-222-2222", "333-333-3333", "444-444-4444"]
passwords = ['1234', 'qwer', 'asdf', 'zxcv']
passwords = [bcrypt.hashpw(x.encode('utf-8'), bcrypt.gensalt()) for x in passwords]
test_data = [fnames, lnames, emails, address1s, address2s, cities, states, phones, passwords]
for x in range(25):
test_user = []
for test_vals in test_data:
test_user.append( test_vals[ rand.randint(0, len(test_vals) - 1) ])
users_table.insert(test_user)
def post(self):
content = request.get_json()
recover = users()
password = content.get('password')
validatepassword = content.get('validatepassword')
if (password == validatepassword):
password = content.get('password')
salt = bcrypt.gensalt()
recover.password = bcrypt.hashpw(
bytes(str(password), encoding='utf-8'), salt)
recover.code = content.get('code')
check = recover.modification_pass()
if check:
return jsonify({"modifi": True}), 200
else:
return jsonify({"modifi": False}), 400
else:
return jsonify(), 400
def handle_follow(event):
user_id = event.source.user_id
# if user_id != 'U1967dc58bc86ac7a20849717ea7c1b69':
# line_bot_api.reply_message (event.reply_token , TextSendMessage (text = "您沒有權限喔！"))
# return 0
profile = line_bot_api.get_profile(user_id)
print ("user_id = " + user_id)
print(profile.display_name)
print("======")
newcoming_text = profile.display_name + " 您好，\n歡迎使用芥菜種會專管小幫手，請使用手機操作下方服務選單說明。"
newcoming_text2 = "如在操作上有問題或仍無法解決您的疑問，請直接私訊社工，感謝您的耐心。"
text = [TextSendMessage (text = newcoming_text) , TextSendMessage (text = newcoming_text2)]
insert_data = users(
userid=user_id,
display_name=profile.display_name)
insert_data.new_user()
line_bot_api.link_rich_menu_to_user (user_id , "richmenu-8190b65e54fd3261bbd9d33dc951d1fe")
line_bot_api.reply_message(event.reply_token, text )
def post(self):
content = request.get_json()
name = content.get("name")
surname = content.get("surname")
email = content.get("email")
password = content.get("password")
validatepassword = content.get("validatepassword")
register = users()
if password == validatepassword:
salt = bcrypt.gensalt()
register.password = bcrypt.hashpw(
bytes(str(password), encoding='utf-8'), salt)
register.name = name
register.surname = surname
register.email = email
register.code = random.randint(1000000000, 9999999999)
ActivarCuenta(register.email, register.code)
respuesta = register.create_user()
return jsonify(), 200
return jsonify(), 500
def post(self):
UUID = str(uuid.uuid4())
data = request.json
user = models.users(id=UUID,
email=data["email"],
first_name=data["first_name"],
last_name=data["last_name"],
current_question=0)
db.session.add(user)
db.session.commit()
user_return = models.users.query.filter_by(id=UUID).first()
return {
'timeLeft': timeLeft(user_return.created),
'first_name': user_return.first_name,
'last_name': user_return.last_name,
# frontend needs UUID to redirect to get question
'UUID': user_return.id
}
import re
check = 1
start = time.time()
change = 0
object_count = []
object_tracker = 0
fp = open('/Volumes/MAC1/users/users.txt','r')
obj = 'UserObj'+ str(change)
for line in fp:
line = line.split('\t')
obj = users()
obj.userid = int(line[0])
obj.username = line[1]
obj.friendcount = int(line[2])
obj.followercount = int(line[3])
obj.statuscount = int(line[4])
obj.Favoritecount = int(line[5])
obj.account_age = line[6]
line[7] = re.sub('[^A-Za-z0-9]+',' ',line[7]).strip()
obj.location = line[7]
object_count.append(obj)
object_tracker = object_tracker + 1
if object_tracker == 604:
from app import db
from models import users
from models import friendships
from models import bestFriends
#creating the database
db.create_all()
#insert some users
db.session.add(users("Alex", "*****@*****.**", "900102030", "passwordAlex"))
db.session.add(users("Carlos", "*****@*****.**", "900102030", "passwordCarlos"))
db.session.add(users("Pedro", "*****@*****.**", "900102030", "passwordPedro"))
db.session.add(users("Jorge", "*****@*****.**", "900102030", "passwordJorge"))
db.session.add(users("Juan", "*****@*****.**", "900102030", "passwordJuan"))
db.session.add(users("Julia", "*****@*****.**", "900102030", "passwordJulia"))
db.session.add(users("Ana", "*****@*****.**", "900102030", "passwordAna"))
#insert some friendships
db.session.add(friendships(3, 4, "Pedro", "Jorge"))
db.session.add(friendships(1, 2, "Alex", "Carlos"))
db.session.add(friendships(3, 6, "Pedro", "Julia"))
db.session.add(friendships(1, 5, "Alex", "Juan"))
db.session.add(friendships(1, 6, "Alex", "Julia"))
db.session.add(friendships(5, 6, "Juan", "Julia"))
#insert some bestFriends
import os
import re
check = 1
start = time.time()
change = 0
object_count = []
object_tracker = 0
fp = open('/Volumes/MAC1/users/users.txt', 'r')
obj = 'UserObj' + str(change)
for line in fp:
line = line.split('\t')
obj = users()
obj.userid = int(line[0])
obj.username = line[1]
obj.friendcount = int(line[2])
obj.followercount = int(line[3])
obj.statuscount = int(line[4])
obj.Favoritecount = int(line[5])
obj.account_age = line[6]
line[7] = re.sub('[^A-Za-z0-9]+', ' ', line[7]).strip()
obj.location = line[7]
object_count.append(obj)
object_tracker = object_tracker + 1
if object_tracker == 604:
print 'Entering 604 objects'
#coding:utf8
import web
import models
import json
import tools.show_result as sr
urls=(
'/list','get_users_list',
'/create','create_users',
'/(\d+)','manage_users',
'/login','users_login',
'/get_user_name/(\d+)','get_user_name',
)
users=models.users()
"""获取用户真实姓名，用户编码列表"""
class get_users_list:
def GET(self):
try:
params=web.input()
page=params.page if hasattr(params, 'page') else 1
perpage = 10
offset = (int(page) - 1) * perpage
return json.dumps(users.get_users_list_paged(offset,perpage),ensure_ascii=False)
except:
return sr.show_result_fail()
