def do_login():
username = request.form["username"]
access_phrase = request.form["access_phrase"]
database.access_db()
result = database.login(username, access_phrase)
if result in ["new", "login"]:
session['username'] = username
session["result"] = result
return redirect(url_for("main"))
h = krampus18.init("login")
with h.tag("html"):
krampus18.header("login")
with h.tag("body"):
with h.tag("h1"):
h.content("Could not login " + username + ".")
h.tag2("br")
if result == "phrase":
h.content("The access phrase did not match.")
if result == "name":
h.content("The name was not valid.")
if result == "error":
h.content("The database connection failed.")
with h.tag("p"):
with h.tag("a", href="/"):
h.content("Back")
return krampus18.get_html()
def terminarJornada(self, widget):
'''Finalizar la jornada
Comprueba si la contrasena introducida corresponde al camarero que ha iniciado sesion,
recorre la lista de mesas que hay cambiando el estado de cada una de ellas a Disponible,
por ultimo recarga el panel lateral de las mesas y cierra la ventana generada'''
user = self.lblHCamarero.get_text()
password = self.jornadaPwd.get_text()
if len(password):
fila = database.login(user, password)
if str(fila[0]) != 'None' and str(fila[1]) != 'None':
i = 1
for mesa in self.mesas:
database.ocuparMesa("Disponible", str(i))
i = i + 1
self.cargaMesas()
self.lblAviso.set_markup(
"<span color='white'><b>Jornada finalizada</b></span>")
print('Mesas liberadas con exito')
self.cerrarJornada(widget)
else:
self.lblError.set_text("Password no valida")
self.abrirError(widget)
else:
self.lblError.set_text("Debe introducir su password")
self.abrirError(widget)
def login():
username = ""
errors = {}
global user
if request.method == "POST":
username = request.form.get("username").strip()
if not username:
errors["username"] = "******"
password = request.form.get("password").strip()
if not password:
errors["password"] = "******"
if len(errors) == 0:
with database.connect() as conn:
tmp = database.login(conn, username, password)
if tmp == -1:
errors["username"] = username + " does not exist"
elif tmp == -2:
errors["password"] = "******"
else:
user = User(tmp[0][0], tmp[0][1], tmp[0][2], tmp[0][3])
print("Successfully Logged In!")
return redirect("/")
return render_template("login.html",
username=username,
errors=errors,
tab="login",
user=user)
def searchCourse():
get_data = request.get_json()
uid = get_data.get("id")
year = int(get_data.get("year"))
userData = database.login(uid)
jsonCourse = []
mark = []
credit = []
if (year < userData[0][6] or year > userData[0][6] + 4):
return jsonify(code=500, msg="年份输入错误")
else:
userCourse = database.searchCourse(year, uid)
for row in userCourse:
result = {}
result["course_date"] = row[0]
result["course_mark"] = row[1]
result["course_name"] = row[2]
result["course_credit"] = row[3]
jsonCourse.append(result)
mark.append(row[1])
credit.append(row[3])
# 计算学生加权平均成绩
total = round(
sum([mark[i] * credit[i] for i in range(len(mark))]) / sum(credit),
1)
return jsonify([jsonCourse, total])
def login(data):
try:
username = data["username"]
password = data["password"]
except KeyError:
emit('Error', {"message": "Login fields missing", "show": "true"})
return
#check if user exists
if (not db.get_user(username)):
emit('login_response', 'failure')
emit('Error', {"message": "This user does not exist.", "show": "true"})
return
return
password = hashlib.md5(bytes(password, 'utf-8'))
password = password.hexdigest()
# DATABASE: get password from username
correct_password = db.login(username)
if (password == correct_password):
emit('login_response', username)
else:
emit('login_response', 'failure')
emit('Error', {"message": "Incorrect password", "show": "true"})
def login():
"""Allows user to login into an existing account
Returns:
(str): The uid of the logged in user, None if login failed
(bool): True if user is priviledged, False if user is not priviledged,
None if login failed
"""
print("To return to the main screen, type `/back`")
while (True):
print("Enter: ID")
login_values = request_input(expected_len=1, logout_allowed=False)
if not login_values:
continue
if login_values[0] == "/back":
return None, None
# Attempt to login
login_success = db.login(*login_values, get_password())
if login_success:
# Check if user is privileged
is_privileged = db.check_privilege(login_values[0])
return login_values[0], is_privileged
else:
print(
"Please try again\n") # db.login handles some messaging before
def auth(self, login, password):
meta = database.login(login, password)
if not resp:
return "ERROR"
else:
token = make_token(get_id(login))
return token
def login():
username = input("Valid username: "******"Valid password: "******"Invalid username or password, please try again")
def login():
if request.form['id'] == None or request.form['pw'] == None:
abort(400)
result = DB.login(request.form['id'], request.form['pw'])
if result != None:
session['id'], session['name'], session['auth'] = result
flash('로그인되었습니다')
return redirect(url_for('main'))
else:
flash('로그인에 실패했습니다')
return redirect(url_for('main'))
def login():
get_data = request.get_json()
print(get_data)
uid = get_data.get("id")
password = get_data.get("password")
info = database.login(uid)
print(info)
if not all([uid, password]):
return jsonify(code=0, msg="参数不完整")
if uid == info[0][0] and password == info[0][1]:
return jsonify(code=200, msg="登陆成功", root=info[0][7])
else:
return jsonify(code=400, msg="登录失败 ")
def login():
details = request.form.to_dict()
# print(details)
user = details['username']
password = details['password']
response = {'status': 'failure'}
uid = db.login(user, password)
if (uid):
response['status'] = 'success'
response['userId'] = uid
return jsonify(response)
def logged():
imgs = db.getPublicImages()
if request.method == 'POST':
if db.login(request.form['username'], request.form['password']):
print('Logged in')
session['username'] = request.form['username']
session['insession'] = True
print("In session")
if 'username' in session:
user = session['username']
insess = True
else:
user = ''
insess = False
return render_template('index.html', username=user, sess=insess, imgs=imgs)
def login():
if request.method == 'GET':
return render_template('index.html')
elif request.method == 'POST':
f = request.form
if database.login(f['username'], f['password']):
session['username'] = f['username']
user = database.get_user(f['username'])
if user[2]: # user is staff
return render_template('staff-dashboard.html')
else:
return redirect('/search-books/')
else:
return render_template('index.html', login_error='Invalid username and password')
else:
return 'wtf!'
def login():
username = get_username()
if username:
return redirect(url_for("index"))
if request.method == "GET":
return render_template("login.html")
else:
username = request.form["username"]
password = request.form["password"]
if db.login(username, hash(password)):
session["username"] = username
return redirect(url_for("index"))
return render_template("login.html",
error="Invalid Username or Password")
def login():
print(request.get_data())
data = request.get_data()
jsondata = json.loads(data)
email = jsondata["email"]
password = jsondata["password"]
returndata = database.login(email, password)
if returndata == -1:
print("ユーザーが見つからない")
return "/USER/"
elif returndata == -2:
print("パスワードが違う")
return "/PASS/"
else:
print(returndata)
return returndata
def register():
get_data = request.get_json()
uid = get_data.get("id")
password = get_data.get("password")
age = get_data.get("age")
sex = get_data.get("sex")
telephone = get_data.get("telephone")
class_id = get_data.get("class_id")
root = get_data.get("root")
enter_time = get_data.get("enter_time")
info = database.login(uid)
if not all(
[uid, password, age, sex, telephone, class_id, enter_time, root]):
return jsonify(code=0, msg="参数不完整")
if info:
return jsonify(code=500, msg="用户已注册")
else:
database.registe(uid, password, age, sex, telephone, class_id,
enter_time, root)
return jsonify(code=200, msg="注册成功")
def login():
if "logged in" not in SESSION:
pass
elif SESSION["logged in"]:
flash("You are already logged in")
return redirect(url_for('view_profile'))
if request.method == 'GET':
return render_template('login.html')
username = request.form['username']
password = request.form['password']
login_successfully = db.login(username, password)
if not login_successfully[0]:
flash(login_successfully[1])
return redirect(url_for('create_profile'))
SESSION["logged in"] = True
SESSION["user"] = username
flash("Welcome {}".format(username))
return redirect(url_for('view_profile'))
def login(lang="en/"):
if request.method == 'GET':
return render_page("login.html", lang)
else:
user = request.form['user']
password = request.form['password']
hash = database.login(user, password)
if hash == None:
lang_errors = {
"en/": u"Incorrect login information!",
"et/": u"Sisselogimine ebaõnnestus!"
}
return render_page("login.html",
lang,
user=user,
error=lang_errors[lang])
resp = make_response(redirect('/' if lang == "en/" else "/et/"))
resp.set_cookie('user', user)
resp.set_cookie('password_hash', hash)
return resp
def login(self, widget, data=None):
'''Inicio de sesion
Recoge los datos introducidos por el usuario y llama al metodo necesario
para buscar en la base de datos, si el resultado de la busqueda es
distinto a None inicia sesion abriendo la aplicaicon'''
user = self.loginUser.get_text()
password = self.loginPwd.get_text()
if len(user) > 0 and len(password):
fila = database.login(user, password)
if str(fila[0]) != 'None' and str(fila[1]) != 'None':
self.venlogin.hide()
self.venprincipal.show()
print("Iniciando sesion")
self.lblHCamarero.set_text(user)
else:
self.lblError.set_text("Usuario o password no encontrado")
self.abrirError(widget)
print("Error en el inicio de sesion")
else:
self.lblError.set_text("Debe cubrir todos los campos")
self.abrirError(widget)
def award():
get_data = request.get_json()
uid = get_data.get("id")
year = int(get_data.get("year"))
userData = database.login(uid)
jsonAward = []
if (year < userData[0][6] or year > userData[0][6] + 4):
return jsonify(code=500, msg="年份输入错误")
else:
userAward = database.award(year, uid)
print(userAward)
for row in userAward:
result = {}
result["award_time"] = row[0].strftime("%Y-%m-%d") # 处理时间转换格式
result["award_name"] = row[1]
if (row[2] == 0):
result["mark"] = -row[3]
else:
result["mark"] = row[3]
jsonAward.append(result)
return jsonify(jsonAward)
def post(self, request):
if not request.data:
return Response(json.dumps(
{'Error': "Please provide username/password"}),
status=401)
username = request.data['username']
password = request.data['password']
user = login(email=username, password=password, con=db_connection)
if user:
payload = {'id': user.id}
jwt_token = {
'token': jwt.encode(payload, "SECRET_KEY").decode("utf-8")
}
print('success')
return Response(jwt_token,
status=200,
content_type="application/json")
else:
return Response({'Error': "Invalid crefdentials"},
status=401,
content_type="application/json")
def userInfo():
global a
get_data = request.args['userid']
info = database.login(get_data)
jsonCollege = []
for row in info:
result = {}
result['id'] = row[0]
result['password'] = row[1]
result['age'] = row[2]
result['sex'] = row[3]
result['telephone'] = row[4]
result['class_id'] = row[5]
result['entry_time'] = row[6]
jsonCollege.append(result)
print(jsonCollege[0]['class_id'])
userInfo = database.userInfo(jsonCollege[0]['class_id'])
for row in userInfo:
a = {}
a['class_name'] = row[0]
a['major_name'] = row[1]
a['college_name'] = row[2]
js = [dict(jsonCollege[0], **a)]
return jsonify(js)
logging.add_log(0, "Managed to read login")
else:
print("error: 3 - problem getting login info")
exit(2)
libfap.fap_init()
active_socket = connection.connect(server_address, server_port, login)
active_socket_file = connection.create_socket_file(active_socket)
if -1 == active_socket_file:
logging.add_log(2, "Did not managed to create socket file")
keep_running = False
else:
logging.add_log(0, "Managed to connect to server and create socket file")
active_database_connection = database.login()
if active_database_connection is -1:
keep_running = False
keepalive_time = time.time()
current_time = time.time()
glider_id_array = database.get_glider_ids(active_database_connection)
towingplane_id_array = database.get_tow_plane_ids(active_database_connection)
while keep_running: # loop untill we want to Exit
try:
current_time = time.time()
libfap.fap_tnc2_to_kiss.argtypes = [c_char_p, c_uint, c_uint, c_char_p, c_uint]
libfap.fap_tnc2_to_kiss.restype = c_int
libfap.fap_ax25_to_tnc2.argtypes = [c_char_p, c_uint, c_char_p, c_uint]
libfap.fap_ax25_to_tnc2.restype = c_int
libfap.fap_tnc2_to_ax25.argtypes = [c_char_p, c_uint, c_char_p, c_uint]
libfap.fap_tnc2_to_ax25.restype = c_int
libfap.fap_free.argtypes = [POINTER(fap_packet_t)]
libfap.fap_init()
#logging.add_log(0, "Testar en simple log")
#logging.add_log(1, "Testar en small error log")
#logging.add_log(2, "Testar en big error log")
#logging.log_packet("Testar en log_packet")
DBCon = database.login()
#Setup test environment
#database.add_pilot(DBCon, 1, 'JockTori')
#database.add_pilot(DBCon, 2, 'Nicole')
#database.add_pilot(DBCon, 3, 'Micke')
#database.add_pilot(DBCon, 4, 'Conraaaado')
#database.add_glider(DBCon, 'UDP', '0xAAAAAA')
#database.add_glider(DBCon, 'APM', '0xAAAAAB')
#database.add_glider(DBCon, 'UCM', '0xAAAAAC')
#database.add_glider(DBCon, 'UPU', '0xAAAAAD')
#database.add_tow_plane(DBCon, 'TAP', '0xBBBBBA')
#database.add_tow_plane(DBCon, 'TUC', '0xBBBBBB')
#database.add_tow_plane(DBCon, 'TEM', '0xBBBBBC')
Glider_id = 'AAABBC'
def connect(self, *_):
usr = self.CGTWLEUsername.text()
pwd = self.CGTWLEPassword.text()
database.login(usr, pwd)
self.refreshUI()
def test_login_wrong_password(self):
logged_user = database.login('Barney', '421')
self.assertFalse(logged_user)
def test_login(self):
logged_user = database.login('Barney', '420')
self.assertEqual(logged_user.get_username(), 'Barney')
def test_login(self):
self.assertTrue(db.login("1", "p"))
self.assertFalse(db.login("1", "not_password"))
self.assertFalse(db.login("5", "p"))
print("""
create: Create a new account
login: Login into already existing account
quit: Exit application
""")
option = input(">> ")
if option.lower() == "create":
user = input("Enter full name: ")
pin = input("Enter desired pin: ")
rand = random.randint(10000000, 99999999)
database.create(user, pin, rand)
elif option.lower() == "login":
ref = database.login()
input("Press enter to continue")
while True:
print("""
balance: Check balances
deposit: Deposit money in to bank
withdraw: Withdraw money from the bank
take: Take out a loan
pay: Pay back loan
exit: log out of account
""")
choice = input(">> ")
def clientTick(client):
print("Server tick thread started for client")
HEADERSIZE = 10
while True:
if client.disconnect:
print("%s SERVER user %s disconnected" %
(datetime.datetime.now(), repr(client.username)))
break
full_msg = b''
new_msg = True
while True:
try:
client_connection = client.connection
buf = client_connection.recv(2048)
if new_msg:
try:
msglen = int(buf[:HEADERSIZE])
except ValueError:
print("client disconnect error")
# happens when client disconnects
break
new_msg = False
full_msg += buf
except ConnectionResetError:
print("%s SERVER user %s connecton reset error" %
(datetime.datetime.now(), repr(client.username)))
break
download_size = len(full_msg) - HEADERSIZE
if download_size == msglen:
if download_size > 100000:
print("%s SERVER received large message (%s)" %
(datetime.datetime.now(),
str(download_size / 1000000) + "MB"))
try:
incomingdata = pickle.loads(full_msg[HEADERSIZE:])
except EOFError:
print("%s SERVER user %s disconnected" %
(datetime.datetime.now(), repr(client.username)))
break
new_msg = True
full_msg = b""
if not client.authorized:
if "login-attempt" == incomingdata[0]:
print("%s SERVER user %s login attempt" %
(datetime.datetime.now(), repr(incomingdata[1])))
username = incomingdata[1]
password = incomingdata[2]
login = (database.login(username, password))
online_users = database.getOnlineUsers()
if username in online_users:
print("%s SERVER user %s already logged in" %
(datetime.datetime.now(),
repr(incomingdata[1])))
sendToClient(client_connection,
("login-success", False, None))
else:
if login:
key = generateKey()
client.key = key
client.username = username
sendToClient(client_connection,
("login-success", True, key))
client.authorized = True
print("%s SERVER user %s logged in" %
(datetime.datetime.now(),
repr(incomingdata[1])))
database.updateUserStatus(username, "ONLINE")
else:
sendToClient(client_connection,
("login-success", False, None))
print("%s SERVER user %s wrong password" %
(datetime.datetime.now(),
repr(incomingdata[1])))
else:
if "request-scripts" == incomingdata[1]:
print("%s SERVER user %s request scripts" %
(datetime.datetime.now(), repr(client.username)))
if incomingdata[0] == client.key:
print("%s SERVER sending scripts to user %s" %
(datetime.datetime.now(),
repr(client.username)))
amount = incomingdata[2]
filter = incomingdata[3]
if filter == "ups":
data = database.getScripts(amount, "ups")
sendToClient(client_connection,
("scripts-return", data,
settings.music_types))
elif filter == "latest posts":
data = database.getScripts(
amount, "timecreated")
sendToClient(client_connection,
("scripts-return", data,
settings.music_types))
elif filter == "recently added":
data = database.getScripts(
amount, "timegathered")
sendToClient(client_connection,
("scripts-return", data,
settings.music_types))
elif filter == "comments":
data = database.getScripts(
amount, "num_comments")
sendToClient(client_connection,
("scripts-return", data,
settings.music_types))
pass
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "edit-script" == incomingdata[1]:
scriptno = incomingdata[2]
print("%s SERVER user %s request to edit script %s" %
(datetime.datetime.now(), repr(
client.username), scriptno))
if incomingdata[0] == client.key:
script_status = database.getScriptStatus(scriptno)
if script_status == "RAW":
print(
"%s SERVER allowing user %s to edit script %s"
% (datetime.datetime.now(),
repr(client.username), scriptno))
client.editingScript = scriptno
database.updateScriptStatus(
"EDITING", client.username, scriptno)
sendToClient(
client.connection,
('edit-script-success', True, scriptno))
sendToAllClients(
('script-status-update', scriptno,
"EDITING", client.username))
print(
"%s SERVER sending all clients (%s) status update for %s"
%
(datetime.datetime.now(),
len(getAllClientConnections()), scriptno))
elif script_status == "EDITING":
print(
"%s SERVER refusing user %s to edit script %s"
% (datetime.datetime.now(),
repr(client.username), scriptno))
sendToClient(
client.connection,
('edit-script-success', False, scriptno))
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "upload-video" == incomingdata[1]:
if incomingdata[0] == client.key:
scriptno = incomingdata[2]
video_generator_payload = incomingdata[3]
script_status = database.getScriptStatus(scriptno)
if script_status == "EDITING":
if scriptno == client.editingScript:
print(
"%s SERVER allowing user %s to upload script number %s"
% (datetime.datetime.now(),
repr(client.username), scriptno))
if database.uploadVid(
video_generator_payload, scriptno):
database.updateScriptStatus(
"COMPLETE", client.username,
scriptno)
sendToClient(client_connection,
('script-upload-success',
True, scriptno))
client.scriptsComplete.append(scriptno)
client.editingScript = None
else:
sendToClient(client_connection,
('script-upload-success',
False, scriptno))
sendToAllClients(
('script-status-update', scriptno,
"COMPLETE", client.username))
else:
print(
"%s SERVER user %s script number %s does not match what client is editing %s"
% (datetime.datetime.now(),
repr(client.username), scriptno,
client.editingScript))
else:
print("%s SERVER user %s script status is %s" %
(datetime.datetime.now(),
repr(client.username), script_status))
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "quit-editing" == incomingdata[1]:
if incomingdata[0] == client.key:
scriptno = incomingdata[2]
if client.editingScript == scriptno:
database.updateScriptStatus(
"RAW", None, scriptno)
print("%s SERVER user %s quit editing %s" %
(datetime.datetime.now(),
repr(client.username), scriptno))
sendToAllClients(('script-status-update',
scriptno, "RAW", None))
client.editingScript = None
else:
print(
"%s SERVER user %s not editing script %s" %
(datetime.datetime.now(),
repr(client.username), scriptno))
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "flag-scripts" == incomingdata[1]:
if incomingdata[0] == client.key:
scriptno = incomingdata[2]
flagtype = incomingdata[3]
database.updateScriptStatus(
flagtype, client.username, scriptno)
print(
"%s SERVER user %s flagging script %s as %s" %
(datetime.datetime.now(), repr(
client.username), scriptno, flagtype))
sendToAllClients(('script-status-update', scriptno,
flagtype, client.username))
client.editingScript = None
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "add-script" == incomingdata[1]:
if incomingdata[0] == client.key:
url = incomingdata[2]
try:
post = reddit.getPostByUrl(url)
if post is not None:
print("%s SERVER user %s added script %s" %
(datetime.datetime.now(),
repr(client.username),
post.submission_id))
database.addSubmission(post)
sendToClient(client_connection,
('add-script-success', True,
"Successfully added script"))
else:
print(
"%s SERVER user %s attempted to add script that already exists"
% (datetime.datetime.now(),
repr(client.username)))
sendToClient(
client_connection,
('add-script-success', False,
"Script already in database"))
except Exception as e:
print(
"%s SERVER user %s error attempting to add script %s"
% (datetime.datetime.now(),
repr(client.username), url))
sendToClient(client_connection, (
'add-script-success', False,
"An error occured trying to add the script"
))
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
elif "PING" == incomingdata[1]:
if incomingdata[0] == client.key:
client.lastPing = datetime.datetime.now()
print("%s SERVER sending PONG to %s" %
(datetime.datetime.now(),
repr(client.username)))
sendToClient(client.connection, ('PONG', ))
else:
print("%s SERVER user %s key does not match up" %
(datetime.datetime.now(),
repr(client.username)))
if (datetime.datetime.now().minute -
client.lastPing.minute) > 2:
print(
"%s SERVER no PING from %s in 2 minutes. Disconnecting"
% (datetime.datetime.now(), repr(client.username)))
client.disconnect = True
print("%s SERVER Thread shutting down" % datetime.datetime.now())
client.disconnect = True
break
def login(self):
i = login([self.user.text, self.pw.text])
if len(i) > 1:
muncul(i)
SM.current = i[0]
import sys
import os
sys.path.insert(0, os.path.abspath("libraries"))
import database
print database.list_users()
print database.login('test', 'test')
val = False
if not any(char in SpecialSym for char in password):
print('Password should have at least one of the symbols $@#')
val = False
if val:
return val
def main():
passwd = password
if (password_check(passwd)):
database.add_user(username, password)
print('Account created')
else:
print("Invalid Password !!")
if __name__ == '__main__':
main()
elif choice == 2:
database.login()
print("Login succees")
break
elif choice == 3:
break
print("////////////////////////////")
print(" Thank you ")
print("////////////////////////////")
