def test_listings_by_account(self):
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
listing_id = db.create_listing('Potatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 100)
listing_id = db.create_listing('Watermelons', 1, 'Some form of description', 5, '*****@*****.**', 'pounds')
self.assertEqual(listing_id, 101)
listing_id = db.create_listing('Potatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 102)
test_listing = db.find_listing(100)
self.assertIsNotNone(test_listing)
test_listing = db.find_listing(101)
self.assertIsNotNone(test_listing)
test_listing = db.find_listing(102)
self.assertIsNotNone(test_listing)
test_listings = db.listings_by_account('*****@*****.**')
self.assertEqual(test_listings[0][0], 100)
self.assertEqual(test_listings[1][0], 101)
def test_render_feed(self):
db.create_account('*****@*****.**', 'First', 'Last', 'password')
db.create_account('*****@*****.**', 'First', 'Last', 'password')
db.create_listing('Potatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
db.create_listing('Bananas', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
db.create_listing('Tomatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
db.create_listing('Apples', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
resp = self.client.get(url_for('render_feed'))
self.assertTrue(b'Potatoes' in resp.data)
self.assertTrue(b'Tomatoes' in resp.data)
self.assertTrue(b'Bananas' in resp.data)
self.assertTrue(b'Apples' in resp.data)
def test_all_accounts(self):
for i in range(1, 11):
row_count = db.create_account('test{0}@example.com'.format(i), 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('test{0}@example.com'.format(i))
self.assertIsNotNone(test_account)
def test_create_account(self):
account_form = AccountForm()
account_form.email.data = '*****@*****.**'
account_form.first_name.data = 'First'
account_form.last_name.data = 'Last'
account_form.password.data = 'password'
account_form.confirm.data = 'password'
print(account_form)
db.create_account(account_form.email.data, account_form.first_name.data, account_form.last_name.data,
account_form.password.data)
account = Account(account_form.email.data)
self.assertTrue(login_user(account))
resp = self.client.get(url_for('create_account'))
self.assertTrue(b'Create a new account' in resp.data)
def test_fetch_feed(self):
test_account = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertIsNotNone(test_account)
listing_id = db.create_listing('Potatoes', 0, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 100)
listing_id = db.create_listing('Watermelons', 5, 'Some form of description', 5, '*****@*****.**', 'pounds')
self.assertEqual(listing_id, 101)
listing_id = db.create_listing('Potatoes', 0, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 102)
test_listing = db.find_listing(100)
self.assertIsNotNone(test_listing)
test_listing = db.find_listing(101)
self.assertIsNotNone(test_listing)
test_listing = db.find_listing(102)
self.assertIsNotNone(test_listing)
test_feed = db.fetch_feed(6)
self.assertIsNotNone(test_feed)
self.assertEqual(test_feed[0][0], 101)
def test_create_account(self):
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
self.assertEqual(test_account['first_name'], 'First')
self.assertEqual(test_account['last_name'], 'Last')
def create_account_ui():
while True:
name = input("Enter username: "******"Name already taken!")
else:
break
while True:
password = input("Enter password: "******"Confirm password: "******"Passwords do not match!")
else:
break
db.create_account(name, password)
print("Account created! Please proceed by logging in.")
return
def create(args):
logging.basicConfig(filename='log.log', level=logging.DEBUG)
logging.debug('创建')
username = args['username']
password = args['password']
if not re.search('^[a-zA-Z]{1}\w*$', username):
return {'code': 204, 'err': "username format is not correct!"}
if not re.search('^[a-zA-Z]{1}\w*$', password):
return {'code': 205, 'err': "password format is not correct!"}
if db.load_by_username(username):
return {'code': 201, 'err': "user already exists!"}
port = str(13000 + db.calc_count())
mode = "aes-256-cfb"
logging.debug('username:%s, password:%s, port:%s, mode:%s', \
username, password, port, mode)
os.system("sh startss.sh " + port + " " + password + " " + mode)
db.create_account(username, password, port, mode)
return {'code': 200, 'err': "success"}
def test_get_id_from_email(self):
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
test_id = db.get_id_from_email('*****@*****.**')
self.assertIsNotNone(test_id)
self.assertEqual(test_id, 100)
def test_find_password(self):
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
test_password = db.find_password('*****@*****.**')
self.assertIsNotNone(test_password)
self.assertEqual(test_account['password'], 'password')
def test_find_listing(self):
row_count = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('*****@*****.**')
self.assertIsNotNone(test_account)
listing_id = db.create_listing('Potatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 100)
test_listing = db.find_listing(100)
print(test_listing)
self.assertIsNotNone(test_listing)
def test_all_listings(self):
for i in range(1, 11):
row_count = db.create_account('test{0}@example.com'.format(i), 'First', 'Last', 'password')
self.assertEqual(row_count, 1)
test_account = db.find_account('test{0}@example.com'.format(i))
self.assertIsNotNone(test_account)
listing_id = db.create_listing('Potatoes', 4, 'Basic description', 5,
'test{0}@example.com'.format(i), 'pounds')
print(listing_id)
self.assertEqual(listing_id, 99+i)
test_listing = db.find_listing(99 + i)
print(test_listing)
self.assertIsNotNone(test_listing)
def test_create_listing(self):
test_account = db.create_account('*****@*****.**', 'First', 'Last', 'password')
self.assertIsNotNone(test_account)
listing_id = db.create_listing('Potatoes', 5, 'Some form of description', 5, '*****@*****.**', 'grams')
self.assertEqual(listing_id, 100)
test_listing = db.find_listing(100)
self.assertIsNotNone(test_listing)
self.assertEqual(test_listing['name'], 'Potatoes')
self.assertEqual(test_listing['quantity'], 5)
self.assertEqual(test_listing['description'], 'Some form of description')
self.assertEqual(test_listing['price'], 5)
self.assertEqual(test_listing['account_email'], '*****@*****.**')
self.assertEqual(test_listing['unit'], 'grams')
def post(self):
username = self.get_argument('username').lower()
password = self.get_argument('password')
password_again = self.get_argument('password_rep')
if password != password_again:
error = u'?activity=register&error=' + tornado.escape.url_escape("Passwords don't match")
self.redirect('/' + error)
if not db.username_available(username):
error = u'?activity=register&error=' + tornado.escape.url_escape("This username has been taken")
self.redirect('/' + error)
else:
user_id = db.create_account(username, password)
if user_id is not None:
json = tornado.escape.json_encode({'userid': user_id})
self.set_secure_cookie('skillbook_user', str(user_id), expires_days=90)
self.redirect('/settings')
else:
self.redirect('/')
def post(self):
messages = self.messages.copy()
username = self.get_argument('username').lower()
password = self.get_argument('password')
password_again = self.get_argument('password_rep')
if password != password_again:
messages['register_error'] = 'Passwords don\'t match'
self.render('auth.html', **messages)
elif not db.username_available(username):
messages['register_error'] = 'This username has been taken'
self.render('auth.html', **messages)
else:
user_id = db.create_account(username, password)
if user_id is not None:
self.set_current_user(user_id)
self.redirect('/settings')
else:
self.redirect('/')
def create(cls, first_name, last_name, email, password):
new_account = db.create_account({
'first_name':
first_name,
'last_name':
last_name,
'email':
email,
'password_hash':
generate_password_hash(password)
})
if new_account is not None:
self = cls()
self.first_name = new_account['first_name']
self.last_name = new_account['last_name']
self.email = new_account['email']
self.password_hash = new_account['password_hash']
self.is_superuser = new_account['is_superuser']
return self
else:
return None
def create_account():
account_form = AccountForm()
if account_form.validate_on_submit():
account = db.find_account(account_form.email.data)
if account is not None:
flash("Account {} already exists".format(account_form.email.data))
else:
rowcount = db.create_account(account_form.email.data,
account_form.first_name.data,
account_form.last_name.data,
account_form.password.data)
if rowcount == 1:
flash("Account {} created".format(account_form.email.data))
account = Account(account_form.email.data)
login_user(account)
return redirect(url_for('render_feed'))
else:
flash("New member not created")
return render_template('account-form.html',
form=account_form,
mode='create')
def intents(intent, r, ex, score):
montante = ent(r)[0]
conta = ent(r)[1]
dest = ent(r)[2]
nome = ent(r)[3]
small_talk = s_talk()
# Certeza do reconhecimento no intent
if score > 0.5:
# Tratamento dos intents regulares
if intent in small_talk:
table(intent)
elif intent in "DizerNome":
# Se não reconhecer o nome
if nome == "":
global nome_
nome_ = ex
else:
nome_ = nome
print("ChatBanco: Bem-vindo " + nome_.title() +
". Que posso fazer por si?\n")
elif intent in "AbrirConta":
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
elif conta != "":
create_account(conta, 0, nome_)
print("ChatBanco: Abri uma conta " + conta + " em nome de " +
nome_.title() + " com 0€.\n")
else:
print(
"ChatBanco: Que tipo de conta deseja abrir (corrente/poupança)?\n"
)
elif intent in "TipoConta":
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
else:
create_account(conta, 0, nome_)
print("ChatBanco: Abri uma conta " + conta + " em nome de " +
nome_.title() + " com 0€.\n")
elif intent in 'SaberSaldo':
'''
SELECT DISTINCT conta.id, tipo, montante, utilizador_id
FROM utilizador, conta
WHERE utilizador_id =
(SELECT utilizador.id
FROM utilizador, conta
WHERE nome LIKE "Pedro");
'''
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
else:
sal = saber_saldo(nome_)
print("ChatBanco: Tem " + str(sal) + "€ na Conta.\n")
elif intent in 'TransferirDinheiro':
'''
UPDATE conta
SET montante = 50
WHERE utilizador_id =
(SELECT utilizador.id
FROM utilizador, conta
WHERE nome = "Pedro");
UPDATE conta
SET montante = 100
WHERE utilizador_id =
(SELECT utilizador.id
FROM utilizador, conta
WHERE nome = "Carlos");
'''
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
else:
sal1 = int(saber_saldo(nome_))
sal2 = int(saber_saldo(dest))
if sal1 >= int(montante.split(' ', 1)[0]):
sal1 = sal1 - int(montante.split(' ', 1)[0])
atualizar_valores(nome, sal1)
print("ChatBanco: Tem agora " + str(sal1) +
"€ na Conta.\n")
sal2 = sal2 + int(montante.split(' ', 1)[0])
atualizar_valores(dest, sal2)
else:
print("Não tem dinheiro suficiente na Conta.\n")
elif intent in 'LevantarDinheiro':
'''
UPDATE conta
SET montante = 50
WHERE utilizador_id =
(SELECT utilizador.id
FROM utilizador, conta
WHERE nome = "Pedro");
'''
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
else:
sal = int(saber_saldo(nome_))
if sal >= int(montante.split(' ', 1)[0]):
montante = sal - int(montante.split(' ', 1)[0])
atualizar_valores(nome, montante)
print("ChatBanco: Tem agora " + str(montante) +
"€ na Conta.\n")
else:
print("Não tem dinheiro suficiente na Conta.\n")
elif intent in 'FazerDepósito':
'''
UPDATE conta
SET montante = 50
WHERE utilizador_id =
(SELECT utilizador.id
FROM utilizador, conta
WHERE nome = "Pedro");
'''
if nome_ == "":
print("ChatBanco: Diga-me o seu nome, por favor.\n")
else:
sal = int(saber_saldo(nome_))
montante = int(montante.split(' ', 1)[0]) + sal
atualizar_valores(nome, montante)
print("ChatBanco: Tem agora " + str(montante) +
"€ na Conta.\n")
else:
print("ChatBanco: Desculpe, não percebi.\n")
def test_find_account(self):
db.create_account('*****@*****.**', 'First', 'Last', 'password')
resp = self.client.get(url_for('find_account', email='*****@*****.**'))
self.assertTrue(b"First's listings" in resp.data, "Could not find profile page")
def signup():
form = SignupForm()
if form.validate_on_submit():
create_account(form)
return render_template('success.html')
return render_template('signup.html', title='Sign Up', form=form)
def login_test_user():
db.create_account('*****@*****.**', 'First', 'Last', 'password')
account = Account('*****@*****.**')
return login_user(account)