def search_sites():
if current_user.role != "administrator":
flash('Acesso não permitido a rota especificada!', 'danger')
return redirect(url_for("index"))
sites_database = database.list("sites")
stackexchange = StackExchange(100, None)
pages_sites = stackexchange.sites()
if sites_database:
for page in pages_sites:
for site in page["items"]:
site_object = Site(site)
site_json = site_object.get_as_json()
for site_database in sites_database:
if site_json["site"]["api_parameter"] == site_database["site"]["api_parameter"]:
#site_update = {**site_database, **site_json}
site_update = site_json
database.update("sites", site_database, site_update)
break
if site_update == None or "":
database.create("sites", site_object)
break
else:
for page in pages_sites:
for site in page["items"]:
try:
site_object = Site(site)
database.create("sites", site_object)
except:
continue
return redirect(url_for('view_sites'))
def create_learning_object(index_list_results, index_result, name_site, api_site):
list_results = []
list_sites_api = []
update_results = []
cache_user = []
global cache_app_after_login
index_user = None
for x in range(len(cache_app_after_login)):
if current_user.email == cache_app_after_login[x][0]:
cache_user = cache_app_after_login[x]
index_user = x
break
if cache_user:
list_results = cache_user[1]
list_sites_api = cache_user[2]
update_results = cache_user[3]
save_item = list_results[index_list_results][index_result]
#verificar se já esta no banco de dados e impedir de incluir novamente
learning_object = LearningObject(save_item, name_site, api_site)
learning_object_json = learning_object.get_as_json()
print(learning_object_json)
item_db = database.filter_by('learning_objects', {"general.identifier": learning_object_json['general']['identifier'][1]})
if not item_db:
database.create("learning_objects", learning_object)
update_results[index_list_results][index_result] = 1
cache_user[3] = update_results
cache_app_after_login[index_user] = cache_user
return render_template("results_search_api.html", list_results=list_results, list_sites_api=list_sites_api, update_results=update_results)
else:
database.update("learning_objects", item_db[0])
return render_template("results_search_api.html", list_results=list_results, list_sites_api=list_sites_api, update_results=update_results)
def register():
if not current_user.is_authenticated:
form = RegisterForm()
if form.validate_on_submit():
name = form.name.data
email = form.email.data
password = form.password.data
confirm_password = form.confirm_password.data
query = database.filter_by('users', {"email": email})
if not query:
if password == confirm_password:
user = User(name, email, password, "standard", SEARCH_LIMIT)
database.create("users", user)
flash('Conta registrada com sucesso!', 'success')
return redirect(url_for("login"))
else:
flash('A senha de confirmação está incorreta!', 'danger')
return render_template('register.html', form=form)
else:
flash('Email já cadastrado!', 'danger')
return render_template('register.html', form=form)
return render_template('register.html', form=form)
else:
flash('Você já está logado no sistema!', 'info')
return redirect(url_for("index"))
def product_form():
if(request.method == "POST"):
first_name = request.form.get("name")
last_name = request.form.get("last_name")
create(name, price. category, description)
form = ProductForm()
return render_template("form_example.html", form=form)
def prod_review():
if request.method == "POST":
name = request.form.get("name")
product_name = request.form.get("product_name")
review = request.form.get("review")
create(name, product_name, review)
form = ProductReviewForm()
return render_template("review.html", form=form)
def product_form():
if request.method == "POST":
name = request.form.get("name")
price = request.form.get("price")
description = request.form.get("description")
category = request.form.get("category")
quantity = request.form.get("quantity")
unique_tag = request.form.get("unique_tag")
create(name, price, description, category, quantity, unique_tag)
form = ProductForm()
return render_template("form_example.html", form=form)
def product_form():
if request.method == "POST":
p_Name = request.form.get("name")
p_Price = request.form.get("price")
p_Category = request.form.get("category")
p_Description = request.form.get("description")
create(p_Name, p_Price, p_Category, p_Description)
form = ProductForm()
return render_template("form_example.html", form=form)
def create_product():
product_data = request.json
new_id = create(product_data.get("name"), product_data.get("price"),
product_data.get("category"),
product_data.get("description"))
return {"ok": True, "message": "Success", "new_id": new_id}
def create_user():
user_data = request.json
new_id = create(
user_data.get("first_name"),
user_data.get("last_name"),
user_data.get("hobbies"),
)
return {'ok': True, "message": "success", 'new_id': new_id}
def product_form():
if request.method == "POST":
p_Name = request.form.get("name")
p_Price = request.form.get("price")
p_Description = request.form.get("description")
p_Category = request.form.get("category")
p_Quantitiy = request.form.get("quantity")
p_Tag = request.form.get("unique_tag")
create(p_Name, p_Price, p_Description, p_Category, p_Quantitiy, p_Tag)
form = ProductForm()
#rerender form on successful submission
if form.validate_on_submit():
return redirect(url_for('product_form'))
return render_template("form_example.html", form=form)
def create_product():
product_data = request.json
new_id = create(
product_data.get("name"), #find the key "name" and set value
product_data.get("price"),
product_data.get("category"),
product_data.get("description"))
#this is returned as a JSON first, then converted to a python dictionary
return {"ok": True, "message": "Success", "new_id": new_id}
def create_user():
user_data = request.json
new_user = create(
user_data.get("first_name"),
user_data.get("last_name"),
user_data.get("job_title"),
)
return {"ok": True, "message": "Success", "new_user": new_user}
def create_user():
user_data = request.json
new_id = create(
user_data.get("name"),
user_data.get("last name"),
user_data.get("hobbies"),
)
return {"ok": True, "message": "Success", "new_id": new_id}
def submitPost():
"""
Handle requests to the /submitpost route
Allows users to post items
"""
form = ItemForm()
print('User Id', get_current_user())
if form.validate_on_submit():
itemID = db.session.query(db.func.max(Items.itemID)).scalar() + 1
cost = form.cost.data * 100 # All money will be dealt with as integers for easy storage. All items price in cents
new_item = Items(name=form.name.data, category=form.category.data,
description=form.description.data, cost=cost,
itemID=itemID, postedDate=strftime("%Y-%m-%d", gmtime()),
userID=get_current_user(), sold=False)
create(new_item)
return redirect('/listing')
# load make_post template
return render_template('make_post.html', form=form, title='Submit Post') #, get_username=get_username)
def create_users():
users_data = request.json
new_id = create(
users_data.get("first_name"),
users_data.get("last_name"),
users_data.get("position"),
users_data.get("department")
)
return {"ok": True, "message": "Success", "new_id": new_id}
def register():
"""
Handle requests to the /register route
Add an User to the database through the registration form
"""
form = RegistrationForm()
if form.validate_on_submit():
userID = db.session.query(db.func.max(Users.userID)).scalar() + 1
new_user = Users(fname=form.first_name.data,
lname=form.last_name.data,
email=form.email.data,
password=form.password.data,
address=form.address.data,
userID=userID,
birthdate=form.date.data)
create(new_user)
return redirect('/login')
# load registration template
return render_template('registration_page.html',
form=form,
title='Register')
# -*- encoding: utf-8 -*-
import string
from random import choice
from app.database import SuperSaver, create
for x in range(200):
create(SuperSaver(
''.join([ choice(string.uppercase+string.digits) for x in range(6) ])
))
from microservice.rpc import ServiceCollector
from app.services.thing import ThingService
from app.services.greeting import GreetingService
from app.services.websockettest import WebsocketTestService
from app import database
import logging
logger = logging.getLogger(__name__)
logger.addHandler(logging.StreamHandler())
logger.setLevel(logging.DEBUG)
if __name__ == "__main__":
database.create()
loop = asyncio.get_event_loop()
collector = ServiceCollector(loop=loop)
# Add your services here
collector.add_service(GreetingService())
collector.add_service(ThingService())
collector.add_service(WebsocketTestService())
loop.run_until_complete(collector.run())
try:
loop.run_forever()
except KeyboardInterrupt as e:
logger.debug("Caught keyboard interrupt")
finally:
def test_create(self):
with self.app.app_context():
create()
# -*- encoding: utf-8 -*-
import string
from random import choice
from app.database import SuperSaver, create
for x in range(200):
create(
SuperSaver(''.join(
[choice(string.uppercase + string.digits) for x in range(6)])))
def createdb():
database.create()
def createdb():
database.create()
