def signUp():
if request.method == 'POST':
# getting and sanatizing email
email = request.form.get("email")
email = sec.sanitize(
email,
characters=
'abcdefghijklomnopqrstuvwxyzABCDEFGHIJKLMNOPQRTUVWXYZ1234567890@.')
# checking if account with email already exists
Base = declarative_base()
engine = create_engine('sqlite:///mainDatabase.db',
poolclass=SingletonThreadPool)
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
s = DBSession()
try:
s.query(database.Account).filter(
database.Account.email == email).one()
accountAlreadyExists = True
except:
accountAlreadyExists = False
if not accountAlreadyExists:
# getting form variables, generating salt, and sanatizing the retreived variables
password = request.form.get("password")
name = request.form.get("name")
group = request.form.get("group")
print(name, group)
name = sec.sanitize(name)
group = sec.sanitize(group)
print(name, group)
salt = str(random.randint(10000, 99999))
# hashing password with salt
hashed_password = hashlib.sha512(
password.encode('utf-8') + salt.encode('utf-8')).hexdigest()
# uploading account to database
new_person = database.Account(name=name,
password=hashed_password,
salt=int(salt),
email=email,
group=group)
s.add(new_person)
s.commit()
# updating session variables and logging in
session['admin'] = False
session['name'] = name
session['group'] = group
session['logged_in'] = True
# redirecting to home
return jsonify('home')
elif accountAlreadyExists:
# if account already exists redirecting to login page
return jsonify('login')
def test_pop_client(self):
account_config = {
"user_name": "foo@localhost",
"password": "******",
"protocol": "pop3",
"hostname": "localhost:{0}".format(SpamCanPOPTest.server_port),
"smtp_host": "localhost"
}
account = database.Account(account_config)
mail_handler = MailUtil()
protocol_handler = mail_handler.request(account)
count = protocol_handler.get_stats()
protocol_handler.disconnect()
self.assert_(count == 1)
def add_account():
error = ""
account_config = {}
account_config["user_name"] = request.forms.get('user_name')
account_config["password"] = request.forms.get('password')
account_config["hostname"] = request.forms.get('hostname')
account_config["protocol"] = request.forms.get('protocol')
account_config["smtp_host"] = request.forms.get('smtp_host')
account = database.Account(account_config)
try:
protocol_handler = mail_handler.request(account)
protocol_handler.disconnect()
except Exception as e:
error = "Connection error ({0})".format(e)
else:
db.add_account(account_config)
accounts = db.fetch_all()
redirect("/?error={0}".format(error))
async def syncdiscord(bot, thing: extradiscord.discord.Message, arguments):
"""Crea un nuovo account usando il tuo ID di Discord.
Sintassi: `{symbol}syncdiscord`"""
# Set status to typing
await status_typing(bot, thing)
# Check the command syntax
if len(arguments) != 0:
await display_help(bot, thing, syncdiscord)
return
# Open a new database session
session = database.Session()
# Check if the user already exists
user = session.query(database.Account).filter_by(id=thing.author.id).first()
if user is not None:
await answer(bot, thing, "⚠ L'account è già stato registrato.")
return
# Create a new user
user = database.Account(id=thing.author.id)
session.add(user)
session.commit()
# Notify the sender
await answer(bot, thing, "✅ Account registrato con successo!")