def list():
if request.method == 'POST':
task = request.form["task"]
name = request.form["name"]
taskData = session.query(Task).all()
engine.connect()
# if user exist, do not store in users table.
# otherwise insert into the table.
user_id = _searchUserNumber(name)
if (not _isUserExist(name)):
session.add(Users(id=user_id, name=name))
session.commit()
session.add(
Task(task_id=len(taskData) + 1,
task=task,
isdone=False,
user_id=user_id))
session.commit()
else:
session.add(
Task(task_id=len(taskData) + 1,
task=task,
isdone=False,
user_id=user_id))
session.commit()
session.rollback()
return redirect('http://localhost:8080/')
else:
return _get()
def __init__(self, my_ip):
self.binary_flag = ''
self.connection_type = ''
self.ip = my_ip # ip to send to client when transferring data
self.port = 0 # port to send
self.last_file_position = 0
users = Users(ORIGINAL_DIR.replace('\\%s' % FILE_DIR, ''))
self.user_data = users.get_users_pass()
self.command_dict = {
'USER': self.user_check,
#'FEAT': self.get_features, haven't implemented opts
'SYST': self.syst_command,
'CWD': self.cwd,
'PWD': self.pwd,
'DELE': self.delete,
'TYPE': self.set_binary_flag,
'PASV': self.passive_connection,
'LIST': self.list_command,
'PORT': self.active_connection,
'HELP': self.help_command,
'RETR': self.retrieve_file,
'CDUP': self.cwd,
'SIZE': self.return_size,
'REST': self.reset_transfer,
'RNFR': self.rename,
'STOR': self.store_something
}
def createUser(login_session):
newUser = Users(name=login_session['username'],
email=login_session['email'])
session.add(newUser)
session.commit()
user = session.query(Users).filter_by(email=login_session['email']).one()
return user.id
def register():
user = Users()
user.name = request.get_json()['name']
user.username = request.get_json()['username']
user.email = request.get_json()['email']
user.password = bcrypt.generate_password_hash(
request.get_json()['password']).decode('utf-8')
try:
session.add(user)
session.commit()
except:
error = {
'response': 500,
'name': user.name,
'username': user.username,
'email': user.email
}
return error # You don't really need jsonify anymore
result = {
'response': 200,
'name': user.name,
'username': user.username,
'email': user.email
}
return jsonify(result)
def addUser():
args = request.json
new_user = Users(username=args['username'], permission=args['permission'])
db_session.add(new_user)
db_session.commit()
resp = jsonify(success=True)
return resp
def register(): # 注册
if request.method == 'POST':
data = json.loads(request.get_data().decode('utf-8'))
res = Login.pwd(data['pwd'])
if res != "true":
return jsonify(
success = True,
data = res
)
else:
db.session.commit()
user = Users.query.filter(Users.id == data['name']).first()
if user is None:
user = Users(id = data['name'],pwd = data['pwd'])
db.session.add(user)
db.session.commit()
user = Relationship(id = data['name'],books = '')
db.session.add(user)
db.session.commit()
return jsonify(
success = True,
data = "Register Successfully!"
)
else:
return jsonify(
success = True,
data = "This Account has been Existed!"
)
else:
return render_template("register.html")
def getUserInfo(self, comic_id, user):
ui = self.getSession().query(Users).filter(Users.id == int(user)).filter(Users.comic_id == int(comic_id)).first()
if ui is None:
#Build user/comic record.
record = Users()
record.id = user
record.comic_id = comic_id
self.getSession().add(record)
logging.debug(u"User Info: {0}".format(ui))
return ui
def create_user():
if request.method == "POST":
user = Users(username=request.form["uname"],
email=request.form["email"],
phone=request.form["pnumber"],
password=request.form["password"])
db.session.add(user)
db.session.commit()
return redirect(url_for('home'))
return render_template('signup.html')
def setup():
db.drop_all()
db.create_all()
user = Users(username='******', email=environ.get('EMAIL_ADDRESS'))
user.password = environ.get('PASSWORD')
db.session.add(Tags(name='flask'))
db.session.add(Tags(name='biology'))
db.session.add(Tags(name='chemistry'))
db.session.add(user)
db.session.commit()
def new_user():
username = request.json.get('username')
password = request.json.get('password')
if username is None or password is None:
abort(400) # missing arguments
if db.session.query(Users).filter_by(
username=username).first() is not None:
abort(400) # existing user
user = Users(username=username)
user.hash_password(password)
db.session.add(user)
db.session.commit()
return jsonify({'username': user.username}), 201
def singup():
register_form = Registration()
if register_form.validate_on_submit():
email = register_form.mail.data
name = register_form.nickname.data
password = register_form.password.data
existing_user = Users.query.filter_by(mail=email).first()
if existing_user:
abort(400)
user = Users(name=name, mail=email)
user.set_password(password)
db.session.add(user)
db.session.commit()
return redirect(url_for('homepage'))
return render_template('singup.html', form=register_form)
def usersignup():
form = SignupForm()
if request.method == 'POST':
if form.validate() == False:
return render_template('usersignup.html', form=form)
else:
newuser = Users(form.first_name.data, form.last_name.data,
form.email.data, form.password.data)
db.session.add(newuser)
db.session.commit()
return "User SignUp Success!" ##Change to more suitable page
elif request.method == 'GET':
return render_template('usersignup.html', form=form)
def register():
if session.get('logged_in'):
flash("Already logged in!")
return
if request.method == 'POST':
user = Users(request.form['username'], request.form['password'])
db.session.add(user)
global_chat = Chats.query.get(1)
global_chat.users.append(user)
try:
db.session.commit()
except:
flash('A user with that username already exists')
return render_template('register.html')
print('\nRecord was successfully added\n')
return redirect(url_for('index'))
return render_template('register.html')
def register():
session['logged_in'] = False
if request.method == 'POST':
username = request.form['username']
password = hashlib.md5(request.form['password'].encode()).hexdigest()
if Users.query.filter_by(username=username).first():
flash('The username is already taken. Please choose another one.')
return render_template('register.html', form=request.form)
else:
new = Users(username='******'.format(username),
password='******'.format(password))
db.session.add(new)
db.session.commit()
flash('You are registered.')
session['logged_in'] = True
session['username'] = username
return redirect(url_for('index'))
return render_template('register.html', form=request.form)
def __init__(self, **kwargs):
super(DatabaseUsers, self).__init__(**kwargs)
self.users = Users(ORIGINAL_DIR)
self.user_pass = self.users.get_users_pass()
self.layout = GridLayout(cols=1, size_hint_y=None)
self.layout.bind(minimum_height=self.layout.setter('height'))
for user, password in self.user_pass:
self.user_button = OptionsButton(text='user: %s, pass: %s' %
(user, password),
size_hint_y=None,
user=user,
password=password)
self.user_button.bind(font_size=lambda x: self.width / 4)
self.user_button.bind(
on_press=self.user_button.dropdown_options.open)
self.layout.add_widget(self.user_button)
self.add_widget(self.layout)
def signup():
if request.method == 'POST':
post_email = request.form['email']
post_ign = request.form['ign']
post_password = request.form['password']
post_confirm_password = request.form['confirm_password']
if post_password == post_confirm_password:
# TODO: Need to check if email exists already
new_user = Users(email=post_email,
password=util.hash_password(post_password),
ign=post_ign)
db.session.add(new_user)
db.session.commit()
return redirect('/signin')
elif post_password != post_confirm_password:
pass_list = [post_password, post_confirm_password]
return render_template('signup.html', pass_list=pass_list)
else:
return render_template('signup.html')
def create_sample_records():
df = pd.read_csv(TRIAL_CSV, sep=",")
df = record_to_int(df)
for index, row in df.iterrows():
new_user = Users(email=row['IGN'] + '@test2.com',
password=hash_password(TEST_ACCOUNT_PASSWORD),
ign=f'__{row["IGN"]}__')
db.session.add(new_user)
new_record = MapRecords(users=new_user,
map1=row['map1'],
map2=row['map2'],
map3=row['map3'],
map4=row['map4'],
map5=row['map5'],
map6=row['map6'],
map7=row['map7'],
map8=row['map8'])
db.session.add(new_record)
db.session.commit()
print('{} Added user record for ign: {}'.format(
index + 1, f'__{row["IGN"]}__'))
print('Created sample records')
def signup():
form = RegisterForm()
login_form = LoginForm()
if form.validate_on_submit():
if form.password.data == form.confirm_password.data:
hashed_password = generate_password_hash(form.password.data,
method='sha256')
new_user = Users(username=form.username.data,
email=form.email.data,
password=hashed_password)
try:
db.session.add(new_user)
db.session.commit()
flash("User {} has been created!".format(
str(form.username.data)))
return render_template('login.html', form=login_form)
#return '<h1>' + form.username.data + ' ' + form.email.data + ' ' + form.password.data + '</h1>'
except IntegrityError as error:
flash("User already exists. Please login instead")
error = "Error"
return render_template('signup.html', form=form, flash=flash)
SECRET_KEY='secret!',
SQLALCHEMY_DATABASE_URI=db_url,
SQLALCHEMY_TRACK_MODIFICATIONS=True,
)
socketio = SocketIO(app)
db.init_app(app)
if not database_exists(db_url):
create_database(db_url)
db.create_all(app=app)
# One person test case
with app.app_context():
chat = Chats()
user = Users("ng", "thing")
user2 = Users("wu", "thing")
user3 = Users("chou", "thing")
user4 = Users("xu", "thing")
chat.users.append(user)
chat.users.append(user2)
chat.users.append(user3)
chat.users.append(user4)
db.session.add(chat)
db.session.add(user)
db.session.add(user2)
db.session.add(user3)
db.session.add(user4)
db.session.commit()
message = Messages("waassap", user.id, chat.id)
db.session.add(message)
from kivy.uix.scrollview import ScrollView
from kivy.uix.gridlayout import GridLayout
from kivy.core.window import Window
from kivy.uix.dropdown import DropDown
from test_server import Server
from database import Users
import threading
import os
import socket
ORIGINAL_DIR = os.getcwd()
users = Users(os.getcwd())
class OptionsButton(Button):
def __init__(self, **kwargs):
super(OptionsButton, self).__init__(**kwargs)
self.dropdown_options = DropDown()
self.password = kwargs['password']
self.user = kwargs['user']
remove_button = Button(text='Remove User', size_hint_y=None, height=44)
remove_button.bind(
on_release=lambda btn: self.dropdown_options.select(btn))
remove_button.color = (1, 1, 1, 1)
remove_button.background_color = (1, 0, 0, 1)
self.dropdown_options.add_widget(remove_button)
async def process_callback_button(callback_query: types.CallbackQuery):
if callback_query.data.split(' ')[0] == 'add_approve':
if not check_user(int(callback_query.data.split(' ')[1])):
user = Users(user_id=callback_query.data.split(' ')[1],
firstname=callback_query.data.split(' ')[2],
role="user")
session.add(user)
session.commit()
await bot.send_message(
callback_query.data.split(' ')[1], u'Доступ предоставлен!!!')
await bot.send_message(
callback_query.data.split(' ')[1], u'Нажмите /help')
await bot.send_message(
callback_query.from_user.id,
u'Доступ предоставлен пользователю %s (id:%s)!!!' %
(str(callback_query.data.split(' ')[1]),
callback_query.data.split(' ')[2]))
else:
await bot.send_message(callback_query.from_user.id,
"Пользователь уже добавлен")
elif callback_query.data.split(' ')[0] == 'add_decline':
await bot.send_message(
callback_query.data.split(' ')[1], u'Отказано в доступе!!!')
elif callback_query.data.split(' ')[0] == 'ssh_approve':
if check_add_ssh_pub() == 'True\n':
await bot.send_message(
get_admins_id(), u'SSH ключ пользователя %s (id:%s) добавлен' %
(callback_query.data.split(' ')[2],
callback_query.data.split(' ')[1]))
await bot.send_message(
callback_query.data.split(' ')[1],
u'Ваш ключ добавлен и Вам предоставлен доступ')
await bot.send_message(
callback_query.data.split(' ')[1],
"Адресс для подключения к серверу: 93.157.232.12: порт: 42069."
)
else:
await bot.send_message(get_admins_id(), u'Ключ не верный')
await bot.send_message(
callback_query.data.split(' ')[1], u'Ключ не верный')
elif callback_query.data.split(' ')[0] == 'ssh_decline':
await bot.send_message(
get_admins_id(),
u'Пользователю %s (id:%s) отказано в добавлении SSH Ключа' %
(callback_query.data.split(' ')[2],
callback_query.data.split(' ')[1]))
await bot.send_message(
callback_query.data.split(' ')[1],
u'Вам отказано в добавлении SSH Ключа')
elif callback_query.data.split(' ')[0] == 'del':
id_del = callback_query.data.split(' ')[1]
user_del = callback_query.data.split(' ')[2]
#ua.del_user(id_del)
session.query(Users).filter(Users.firstname == user_del).delete()
session.commit()
await bot.send_message(
get_admins_id(),
u'Пользователь %s (id:%s) - УДАЛЕН' % (user_del, id_del))
await bot.send_message(
id_del, u'Пользователь %s (id:%s) - УДАЛЕН' % (user_del, id_del))
from flask import request, jsonify, Flask, Blueprint
from cryptography.fernet import Fernet
from flask_jwt_extended import jwt_required, get_jwt_identity, JWTManager
from database import Users
from api import auth
user = Users()
User = Blueprint('user', __name__)
f = Fernet("ZmDfcTF7_60GrrY167zsiPd67pEvs0aGOv2oasOM1Pg=")
@User.route('/signin', methods=['GET', 'POST'])
def SignIn():
data = request.get_json()
print("Email:", data['email'])
print("Password:", data['password'])
login_data = user.signin(data)
if (login_data):
pwd = f.decrypt(login_data['UserPassword'].encode()).decode()
if pwd == data['password']:
access_token = auth.authenticate(login_data)
return jsonify({
'access_token': access_token,
'msg': 'Login Successful.',
'status': True
})
else:
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database import Base, Categories, Items, Users
engine = create_engine('sqlite:///itemcatalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Create dummy user
User1 = Users(name="Robo Barista", email="*****@*****.**")
session.add(User1)
session.commit()
# Categories for the catalog
soccer = Categories(name="Soccer", user_id=1)
session.add(soccer)
session.commit()
basketball = Categories(name="Basketball", user_id=1)
session.add(basketball)
session.commit()
baseball = Categories(name="Baseball", user_id=1)
session.add(baseball)
session.commit()
frisbee = Categories(name="Frisbee", user_id=1)
session.add(frisbee)
session.commit()
