def post(self):
with session_scope():
sip = generalsip_dao.list()
form = FormGeneralSIP(obj=sip)
if form.validate_on_submit():
form.populate_obj(sip)
generalsip_dao.edit(sip)
return redirect(url_for("q_generalsip.GeneralSIP:get"))
def list(self, unused_request):
""" Return to product list.
"""
products = models.list()
items = []
for ProductModel in products:
items.append(
ProductGetMessage(id=ProductModel.key.id(),
code=ProductModel.code,
name=ProductModel.name,
created_date=ProductModel.created_date))
return ProductCollectionMessage(items=items)
def init():
try:
for m in models.list():
print(str(m))
print(str(m.query.filter_by(id=1).first()))
except OperationalError as oe:
print(oe)
s(10)
init()
except Exception as e:
print("DB ERROR: ", e)
print("initDB now!")
import create_db as create_db
create_db
print("initDB DONE")
def list(self, unused_request):
""" Return to product list.
"""
products = models.list()
items = []
for ProductModel in products:
items.append(
ProductGetMessage(
id=ProductModel.key.id(),
code=ProductModel.code,
name=ProductModel.name,
created_date=ProductModel.created_date))
return ProductCollectionMessage(items=items)
def list(self, unused_request):
""" Return the list of suppliers.
"""
suppliers = models.list()
items = []
for supplierModel in suppliers:
items.append(
SupplierGetMessage(id=supplierModel.key.id(),
name=supplierModel.name,
email=supplierModel.email,
phone=supplierModel.phone,
location=supplierModel.location,
created_date=supplierModel.created_date))
return SupplierCollectionMessage(items=items)
def list(self, unused_request):
""" Return the list of suppliers.
"""
suppliers = models.list()
items = []
for supplierModel in suppliers:
items.append(
SupplierGetMessage(
id=supplierModel.key.id(),
name=supplierModel.name,
email=supplierModel.email,
phone=supplierModel.phone,
location=supplierModel.location,
created_date=supplierModel.created_date))
return SupplierCollectionMessage(items=items)
def list(self, unused_request):
""" Get all customers.
"""
# Get list
customers = models.list()
# Transport model to message
items = []
for customerModel in customers:
items.append(
CustomerGetMessage(id=customerModel.key.id(),
name=customerModel.name,
email=customerModel.email,
phone=customerModel.phone,
location=customerModel.location,
created_date=customerModel.created_date))
# Return
return CustomerCollectionMessage(items=items)
def list(self, unused_request):
""" Endpoint method aims to list all stock items.
"""
stockItems = models.list()
items = []
for stockItem in stockItems:
product = stockItem.product.get()
items.append(
StockGetMessage(id=stockItem.key.id(),
product=ProductGetMessage(
id=product.key.id(),
code=product.code,
name=product.name,
created_date=product.created_date
),
quantity=stockItem.quantity))
return StockCollectionMessage(items=items)
def list(self, unused_request):
"""Retornar a lista de produtos cadastrados.
"""
logging.debug('Executando endpoint para obter a lista de produtos cadastrados')
#Obter a lista de produtos cadastrados
products = models.list()
#Declarando lista e convertendo model para message
items = []
for ProductModel in products:
items.append(
ProductGetMessage(
id = ProductModel.key.id(),
code = ProductModel.code,
name = ProductModel.name,
created_date = ProductModel.created_date))
#Retornando produtos
return ProductCollectionMessage(items=items)
def list(self, unused_request):
""" Get all customers.
"""
# Get list
customers = models.list()
# Transport model to message
items = []
for customerModel in customers:
items.append(
CustomerGetMessage(
id=customerModel.key.id(),
name=customerModel.name,
email=customerModel.email,
phone=customerModel.phone,
location=customerModel.location,
created_date=customerModel.created_date))
# Return
return CustomerCollectionMessage(items=items)
def list(self, unused_request):
"""Retornar a lista de produtos cadastrados.
"""
logging.debug(
'Executando endpoint para obter a lista de produtos cadastrados')
#Obter a lista de produtos cadastrados
products = models.list()
#Declarando lista e convertendo model para message
items = []
for ProductModel in products:
items.append(
ProductGetMessage(id=ProductModel.key.id(),
code=ProductModel.code,
name=ProductModel.name,
created_date=ProductModel.created_date))
#Retornando produtos
return ProductCollectionMessage(items=items)
def list(self, unused_request):
""" Return to the list of clients.
"""
sales = models.list()
items = []
for saleModel in sales:
# Get entities children
customerModel = saleModel.customer.get()
productModel = saleModel.product.get()
# Add to list
items.append(
SaleGetMessage(
id=saleModel.key.id(),
customer=customer.CustomerGetMessage(
id=customerModel.key.id(),
name=customerModel.name,
email=customerModel.email,
phone=customerModel.phone,
location=customerModel.location,
created_date=customerModel.created_date
),
product=product.ProductGetMessage(
id=productModel.key.id(),
code=productModel.code,
name=productModel.name,
created_date=productModel.created_date
),
quantity=saleModel.quantity,
sale_date=saleModel.sale_date,
amount=saleModel.amount,
fare=saleModel.fare,
net_total=saleModel.net_total,
track_code=saleModel.track_code,
created_date=saleModel.created_date))
return SaleCollectionMessage(items=items)
def list(self, unused_request):
"""Retornar a lista de compras realizadas pelo usuário.
"""
logging.debug(
'Executando endpoint para obter uma compra de produto no estoque da loja'
)
#Obter lista de compras cadastradas para a loja
purchases = models.list()
#Declarando lista e convertendo model para message
items = []
for purchaseModel in purchases:
items.append(
PurchaseGetMessage(
id=purchaseModel.key.id(),
supplier=purchaseModel.supplier,
product=product.ProductGetMessage(
id=purchaseModel.product.key.id(),
code=purchaseModel.product.code,
name=purchaseModel.product.name,
created_date=purchaseModel.product.created_date),
quantity=purchaseModel.quantity,
purchase_date=purchaseModel.purchase_date,
received_date=purchaseModel.received_date,
cost=purchaseModel.cost,
total_cost=purchaseModel.total_cost,
exchange_dollar=purchaseModel.exchange_dollar,
cost_dollar=purchaseModel.cost_dollar,
total_cost_dollar=purchaseModel.total_cost_dollar,
shipping_cost=purchaseModel.shipping_cost,
track_code=purchaseModel.track_code,
invoice=purchaseModel.invoice,
payment_date=purchaseModel.payment_date,
purchase_link=purchaseModel.purchase_link,
created_date=purchaseModel.created_date))
#Retornando compras
return PurchaseCollectionMessage(items=items)
def list(self, unused_request):
"""Retornar a lista de compras realizadas pelo usuário.
"""
logging.debug('Executando endpoint para obter uma compra de produto no estoque da loja')
#Obter lista de compras cadastradas para a loja
purchases = models.list()
#Declarando lista e convertendo model para message
items = []
for purchaseModel in purchases:
items.append(
PurchaseGetMessage(
id = purchaseModel.key.id(),
supplier = purchaseModel.supplier,
product = product.ProductGetMessage(
id = purchaseModel.product.key.id(),
code = purchaseModel.product.code,
name = purchaseModel.product.name,
created_date = purchaseModel.product.created_date
),
quantity = purchaseModel.quantity,
purchase_date = purchaseModel.purchase_date,
received_date = purchaseModel.received_date,
cost = purchaseModel.cost,
total_cost = purchaseModel.total_cost,
exchange_dollar = purchaseModel.exchange_dollar,
cost_dollar = purchaseModel.cost_dollar,
total_cost_dollar = purchaseModel.total_cost_dollar,
shipping_cost = purchaseModel.shipping_cost,
track_code = purchaseModel.track_code,
invoice = purchaseModel.invoice,
payment_date = purchaseModel.payment_date,
purchase_link = purchaseModel.purchase_link,
created_date = purchaseModel.created_date))
#Retornando compras
return PurchaseCollectionMessage(items=items)
def list(self, unused_request):
""" Return the purchases list.
"""
purchases = models.list()
items = []
for purchaseModel in purchases:
product = purchaseModel.product.get()
supplier = purchaseModel.supplier.get()
items.append(
PurchaseGetMessage(
id=purchaseModel.key.id(),
supplier=supplierMessages.SupplierGetMessage(
id=supplier.key.id(),
name=supplier.name,
created_date=supplier.created_date),
product=productMessages.ProductGetMessage(
id=product.key.id(),
code=product.code,
name=product.name,
created_date=product.created_date),
quantity=purchaseModel.quantity,
purchase_date=purchaseModel.purchase_date,
received_date=purchaseModel.received_date,
cost=purchaseModel.cost,
total_cost=purchaseModel.total_cost,
exchange_dollar=purchaseModel.exchange_dollar,
cost_dollar=purchaseModel.cost_dollar,
total_cost_dollar=purchaseModel.total_cost_dollar,
shipping_cost=purchaseModel.shipping_cost,
track_code=purchaseModel.track_code,
invoice=purchaseModel.invoice,
payment_date=purchaseModel.payment_date,
purchase_link=purchaseModel.purchase_link,
created_date=purchaseModel.created_date))
return PurchaseCollectionMessage(items=items)
def list(self, unused_request):
"""Retornar a lista de fornecedores cadastrados.
"""
logging.debug('Executando endpoint para obter a lista de fornecedores cadastrados')
#Obter a lista de fornecedores cadastrados
suppliers = models.list()
#Declarando lista e convertendo model para message
items = []
for supplierModel in suppliers:
items.append(
SupplierGetMessage(
id = supplierModel.key.id(),
name = supplierModel.name,
email = supplierModel.email,
phone = supplierModel.phone,
location = supplierModel.location,
created_date = supplierModel.created_date))
#Retornando fornecedores
return SupplierCollectionMessage(items=items)
def list(self, unused_request):
""" Return to the list of clients.
"""
sales = models.list()
items = []
for saleModel in sales:
# Get entities children
customerModel = saleModel.customer.get()
productModel = saleModel.product.get()
# Add to list
items.append(
SaleGetMessage(id=saleModel.key.id(),
customer=customer.CustomerGetMessage(
id=customerModel.key.id(),
name=customerModel.name,
email=customerModel.email,
phone=customerModel.phone,
location=customerModel.location,
created_date=customerModel.created_date),
product=product.ProductGetMessage(
id=productModel.key.id(),
code=productModel.code,
name=productModel.name,
created_date=productModel.created_date),
quantity=saleModel.quantity,
sale_date=saleModel.sale_date,
amount=saleModel.amount,
fare=saleModel.fare,
net_total=saleModel.net_total,
track_code=saleModel.track_code,
created_date=saleModel.created_date))
return SaleCollectionMessage(items=items)
def get(self):
with session_scope():
sip = convertToSIPToDict(generalsip_dao.list())
form = FormGeneralSIP(obj=sip)
return render_template('generalsip.html', form=form)
def index(self):
with session_scope():
meetme = meetme_dao.list()
return render_template('meetme.html', meetme=meetme)
def index(self):
with session_scope():
meetme = meetme_dao.list()
return render_template('meetme.html', meetme=meetme)
