def populate(self):
product = Product(pid=1,
brand='Dr. Martens',
gender='unisex',
type='boots',
price=189,
image='dr_martens.jpg',
in_cart=0,
quantity=0)
self.repository.data.append(product)
product = Product(pid=2,
brand='Christian Louboutin',
gender='women\'s',
type='high heels',
price=699,
image='louboutin.png',
in_cart=0,
quantity=0)
self.repository.data.append(product)
product = Product(pid=3,
brand='Valentino Garavani',
gender='women\'s',
type='high heels',
price=749,
image='valentino.jpg',
in_cart=0,
quantity=0)
self.repository.data.append(product)
class ProductController():
def __init__(self):
self.product_model = Product()
def get_products(self, limit):
result = []
try:
res = self.product_model.get_all(limit=limit)
for r in res:
result.append({
'id': r.id,
'name': r.name,
'description': r.description,
'qtd': str(r.qtd),
'price': str(r.price),
'image': r.image,
'date_created': r.date_created
})
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {'result': result, 'status': status}
def get_product_by_id(self, product_id):
result = {}
try:
self.product_model.id = product_id
res = self.product_model.get_product_by_id()
result = {
'id': res.id,
'name': res.name,
'description': res.description,
'qtd': str(res.qtd),
'price': str(res.price),
'image': res.image,
'date_created': res.date_created
}
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {'result': result, 'status': status}
def index(self):
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render('home_admin.html',
report={
'users': users[0],
'categories': categories[0],
'products': products[0]
},
last_products=last_products)
def add_list_event(self):
# param : name, yongdo, yang, dec, price, time
pprice = util.check_input(self.lineCost.text())
pyang = util.check_input(self.lineAmount.text())
if (pprice is 0) or (pyang is 0):
QMessageBox.question(self, "입력오류", "입력형식 오류", QMessageBox.Yes)
return
pname = self.comboKind.currentText()
pyongdo = self.comboBuySell.currentText()
pdec = self.textDesc.toPlainText()
# 기존 값 체크가 안 되어 있는 경우
date = datetime.datetime.now()
preDate = date.strftime('%y%m%d')
if self.checkDefault.checkState() == 0:
pTime = self.editTime.dateTime().toString('hhmm')
elif self.checkDefault.checkState() == 2:
pTime = date.strftime('%H%M')
rTime = preDate + pTime
p = Product(name=pname,
yongdo=pyongdo,
yang=pyang,
dec=pdec,
price=pprice,
time=rTime)
global_list_product.append(p)
view = self.listProduct
item = QListWidgetItem(view)
item.setText('(' + str(pTime)[:2] + ':' + str(pTime)[2:] + ') ' +
str(p.name) + '/' + str(p.yongdo))
def index(self):
#return self.render('home_admin.html', data={'username':'******'})
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render('home_admin.html', report={
'users': 0 if not users else users[0],
'categories': 0 if not categories else categories[0],
'products': 0 if not products else products[0]
}, last_products=last_products)
def find(self, product_name):
query = "SELECT * FROM Products WHERE name='{}'".format( product_name )
row = self.execute_query( query )
if row:
p = Product(row[0][0], row[0][1], row[0][2], row[0][3])
return p
return None
def readAll(self):
products = []
query = "SELECT * FROM Products"
rows = self.execute_query( query )
for row in rows:
p = Product(row[0], row[1], row[2], row[3])
products.append( p )
return products
def index(self):
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render(
"home_admin.html",
report={
"users": 0 if not users else users[0],
"categories": 0 if not categories else categories[0],
"products": 0 if not products else products[0]
},
last_products=last_products
)
def __init__(self):
self.product_model = Product()
class ProductController():
def __init__(self):
self.product_model = Product()
def save_product(self, obj):
self.product_model.name = obj['name']
self.product_model.description = obj['description']
self.product_model.qtd = obj['qtd']
self.product_model.price = obj['price']
self.product_model.date_created = datetime.now()
self.product_model.status = 1
self.product_model.category = obj['category']
self.product_model.user_created = obj['user_created']
return self.product_model.save()
def update_product(self, obj):
self.product_model.id = obj['id']
return self.product_model.update(obj)
def get_products(self, limit):
result = []
try:
res = self.product_model.get_all(limit=limit)
for r in res:
result.append({
'id': r.id,
'name': r.name,
'description': r.description,
'qtd': str(r.qtd),
'price': str(r.price),
'image': r.image,
'date_created': r.date_created
})
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {'result': result, 'status': status}
def get_product_by_id(self, product_id):
result = {}
try:
self.product_model.id = product_id
res = self.product_model.get_product_by_id()
result = {
'id': res.id,
'name': res.name,
'description': res.description,
'qtd': str(res.qtd),
'price': str(res.price),
'image': res.image,
'date_created': res.date_created
}
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {'result': result, 'status': status}
finFilePath = "s3a://" + app_conf["s3_conf"]["s3_bucket"] + "/finances-small"
financeDf = spark.read.parquet(finFilePath)
financeDf.printSchema()
accNumPrev4WindowSpec = Window.partitionBy("AccountNumber")\
.orderBy("Date")\
.rowsBetween(-4, 0) # takes the first first 5 rows to window aggregation
financeDf\
.withColumn("Date", to_date(from_unixtime(unix_timestamp("Date", "MM/dd/yyyy"))))\
.withColumn("RollingAvg", avg("Amount").over(accNumPrev4WindowSpec))\
.show(5, False)
productList = [
Product("Thin", "Cell phone", 6000),
Product("Normal", "Tablet", 1500),
Product("Mini", "Tablet", 5500),
Product("Ultra Thin", "Cell phone", 5000),
Product("Very Thin", "Cell phone", 6000),
Product("Big", "Tablet", 2500),
Product("Bendable", "Cell phone", 3000),
Product("Foldable", "Cell phone", 3000),
Product("Pro", "Tablet", 4500),
Product("Pro2", "Tablet", 6500)
]
products = spark.createDataFrame(productList)
products.printSchema()
catRevenueWindowSpec = Window.partitionBy("category")\
productTypeSneakers = ProductType(name="Кроссовки",
parent_type=productTypeShoes)
productTypeBoots = ProductType(name="Ботинки",
parent_type=productTypeShoes)
productTypeTShirtMen = ProductType(name="Мужская футболка",
parent_type=productTypeTShirt)
productTypeTShirtWoman = ProductType(name="Женская футболка",
parent_type=productTypeTShirt)
# Продукты
Sneakers = Product(size=42,
color="Red",
price=4500,
quantity=10,
product_type=productTypeSneakers)
Sneakers1 = Product(size=44,
color="Black",
price=4500,
quantity=10,
product_type=productTypeSneakers)
Boots = Product(size=40,
color="Brown",
price=5500,
quantity=2,
product_type=productTypeBoots)
Boots1 = Product(size=45,
color="Green",
class ProductController:
def __init__(self):
self.product_model = Product()
def save_product(self, obj):
self.product_model.name = obj["name"]
self.product_model.description = obj["description"]
self.product_model.qtd = obj["qtd"]
self.product_model.price = obj["price"]
self.product_model.date_created = datetime.now()
self.product_model.status = 1
self.product_model.category = obj["category"]
self.product_model.user_created = obj["user_created"]
return self.product_model.save()
def update_product(self, obj):
self.product_model.id = obj["id"]
return self.product_model.update(obj)
def get_products(self, limit):
"""
Retorna um dicionário com todos os produtos.
params:
limit -> Define um limite para a query
"""
result = []
try:
res = self.product_model.get_all(limit=limit)
for r in res:
result.append({
"id": r.id,
"name": r.name,
"description": r.description,
"qtd": str(r.qtd),
"price": str(r.price),
"image": r.image,
"date_created": r.date_created,
})
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {"result": result, "status": status}
def get_product_by_id(self, product_id):
result = {}
try:
self.product_model.id = product_id
res = self.product_model.get_product_by_id()
result = {
"id": res.id,
"name": res.name,
"description": res.description,
"qtd": str(res.qtd),
"price": str(res.price),
"image": res.image,
"date_created": res.date_created,
}
status = 200
except Exception as e:
print(e)
result = []
status = 400
finally:
return {"result": result, "status": status}
