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()