def mutate(self, info, **args):
current_user = User.find_by_email(get_jwt_identity())
provider = Provider(description=args.get("description"),
organization=current_user.organization)
provider.save()
return CreateProvider(provider=provider)
def read_product():
if user_validate():
products = []
providers = []
if request.args.get('name'):
rows = persistence.read(
'SELECT * FROM PRODUCTS WHERE NAME LIKE "%{}%"'.format(
request.args.get('name').strip()))
else:
rows = persistence.read('SELECT * FROM PRODUCTS')
for product in rows:
provider = persistence.read_one(
'SELECT * FROM PROVIDERS WHERE ID={}'.format(product[5]))
products.append(
Product(id=product[0],
name=product[1],
gross_price=locale.currency(product[2],
grouping=True,
symbol=True),
net_price=locale.currency(product[3],
grouping=True,
symbol=True),
profit_percentage='{:.2%}'.format(product[4]),
provider=Provider(id=provider[0],
name=provider[1],
cnpj=provider[2])))
rows = persistence.read('SELECT * FROM PROVIDERS')
for provider in rows:
providers.append(
Provider(id=provider[0],
name=provider[1],
cnpj=provider[2],
email=provider[3]))
if not products:
flash('Não foi encontrado nenhum produto.')
flash('warning')
return render_template('products.html',
products=products,
providers=providers)
else:
return redirect(url_for('login'))
def install_local_providers():
for class_name in local_providers.__all__:
provider_class = getattr(local_providers, class_name)
db_provider = get_provider_by_local_class(class_name)
if not db_provider:
provider = Provider()
provider.name = provider_class.name
provider.localClass = class_name
provider.isActive = False
db.session.add(provider)
db.session.commit()
def getShows(self, json_data):
shows = list()
if not json_data:
return shows
try:
data = None
if isinstance(json_data, str):
data = json.loads(json_data)
else:
data = json_data
if not data["results"]:
return shows
for result in data["results"]:
show = Show()
show.Id = result["id"]
show.ImageUrl = result["picture"]
show.Title = result["name"]
if not result["locations"]:
shows.append(show.dict())
return shows
show.Provider = Provider(
result["locations"][0]["id"],
result["locations"][0]["display_name"],
result["locations"][0]["url"],
result["locations"][0]["icon"]).dict()
if not result["external_ids"]:
shows.append(show.dict())
return shows
if result["external_ids"]["imdb"]:
show.ExternalLinks.append(
ExternalLink(
result["external_ids"]["imdb"]["id"], "IMDB",
result["external_ids"]["imdb"]["url"]).dict())
if result["external_ids"]["tmdb"]:
show.ExternalLinks.append(
ExternalLink(
result["external_ids"]["tmdb"]["id"], "TMDB",
result["external_ids"]["tmdb"]["url"]).dict())
if result["external_ids"]["wiki_data"]:
show.ExternalLinks.append(
ExternalLink(
result["external_ids"]["wiki_data"]["id"], "WIKI",
result["external_ids"]["wiki_data"]["url"]).dict())
shows.append(show.dict())
return shows
except Exception as ex:
self.logger.error("Exception while parsing Shows: {}".format(ex))
return shows
def read_provider():
if user_validate():
providers = []
if request.args.get('name'):
rows = persistence.read(
'SELECT * FROM PROVIDERS WHERE NAME LIKE "%{}%"'.format(
request.args.get('name').strip()))
else:
rows = persistence.read('SELECT * FROM PROVIDERS')
for provider in rows:
providers.append(
Provider(id=provider[0],
name=provider[1],
cnpj=provider[2],
email=provider[3]))
if not providers:
flash('Não foi encontrado nenhum fornecedor.')
flash('warning')
return render_template('providers.html', providers=providers)
else:
return redirect(url_for('login'))
from models.provider import Provider
pr = Provider(1111, "TechTrends", "Barranquilla", True, False)
# Confirm expected data
pr.Change_Name("ComputersCo")
assert pr.Provider_Name == "ComputersCo"
assert pr.Show_data(
) == "Provider_ID 1111\nProvider_Name ComputersCo\nProvider_Address Barranquilla\nLocal_Company True\nQuality_Cert False"
def insertProvider(_name, _cnpj):
name = (_name.get())
cnpj = (_cnpj.get())
provider = Provider(0, name, cnpj)
p.insertProvider(provider)
print("Fornecedor {}, cadastrado com sucesso!".format(provider.name))