def get_set_parts(set_id):
params = {'key': API_KEY, 'format': 'json', 'set': set_id}
response = requests.get(PARTS_URL, params)
data = json.loads(response.text)[0]
parts = []
for p in data['parts']:
parts.append(Part(p['part_id'], p['element_id'], p['qty']))
return Set(data['set_id'], data['descr'], parts)
async def post(self, request):
data = await request.post()
part = Part(name=data.get('name'),
country=data.get('country'),
model=data.get('model'))
session.add(part)
session.commit()
return await self.response_200(response_data=session.query(Part))
def add_part_by_form():
data = request.json
part = Part(name=data["name"].capitalize(),
link=data["link"],
image_url=data["image_url"],
price=data["price"])
db.session.add(part)
db.session.commit()
return data
def load_parts(xml_file):
tree = ET.parse(xml_file)
root = tree.getroot()
parts = []
for item in root.findall('ITEM'):
try:
part_id = item.find('ITEMID').text
color_id = item.find('COLOR').text
qty = int(item.find('MINQTY').text)
except:
raise XmlFormatError(item)
if part_id is None or color_id is None or qty is None:
raise XmlFormatError(item)
part = Part(part_id, color_id, qty)
print('loading part', part)
parts.append(part)
return parts
print('Objective value =', solver.Objective().Value())
else:
print('The problem does not have an optimal solution.')
return optimal_listings
def to_var_index(parts, listings, part_index, listing_index):
return len(listings) * part_index + listing_index
def to_listing_index(parts, listings, var_index):
return math.floor(var_index / len(parts))
def to_part_index(parts, listings, var_index):
return var_index % len(parts)
if __name__ == '__main__':
parts = [
Part(3010, 1, 10),
Part(3011, 1, 6),
]
listings = [
Listing(3010, 1, 10, 0.1, '', '', 's1', 301000),
Listing(3011, 1, 10, 0.1, '', '', 's2', 301100)
]
stores = [Store('s1'), Store('s2')]
optimize(parts, listings, stores)
db.session.add_all([category, category1, category2, category3, category4])
db.session.commit()
subcategory = Subcategory(category_id=category.id, name="Toilets")
subcategory1 = Subcategory(category_id=category1.id, name="Engines")
trade = Trade(category_id=category.id, name="Plumber", cost_per_hour=12)
trade1 = Trade(category_id=category1.id, name="Mechanic", cost_per_hour=24)
trade2 = Trade(category_id=category2.id,
name="Appliance Expert",
cost_per_hour=10)
trade3 = Trade(category_id=category3.id, name="Electrician", cost_per_hour=10)
trade4 = Trade(category_id=category4.id, name="Carpenter", cost_per_hour=10)
part = Part(
name="Hammer",
link=
"https://www.walmart.com/ip/Hyper-Tough-16-Ounce-Claw-Hammer-with-Fiberglass-Handle/972830002",
image_url=
"https://i5.walmartimages.com/asr/61b5ab99-2d90-45fe-9952-0932abf84c05_1.e755cf112171a90e30833bd8429a2bad.jpeg?odnWidth=100&odnHeight=100&odnBg=ffffff",
price=14)
part1 = Part(
name="Wrench",
link=
"https://www.walmart.com/ip/8-inch-Adjustable-Wrench-with-Sure-Grip-Handle-UW00015A/17190620",
image_url=
"https://i5.walmartimages.com/asr/959de1ff-d6a9-4876-9256-2b01e2756462_2.9cdc010d9e8ddfc3c1ca7e7a72f7fcb7.jpeg?odnWidth=100&odnHeight=100&odnBg=ffffff",
price=4)
db.session.add_all([
subcategory, subcategory1, trade, trade1, trade2, trade3, trade4, part,
part1
])
db.session.commit()
