def start_element_mit(name, attrs): from mitdining.models import Category, MenuItem, Store, OptionPrice, StoreCategory global current_category, current_store print 'Start element:', name, attrs if name == 'item': # store menu item detail = option_prices(attrs['price']) if 'market' in attrs['price'].lower(): m = MenuItem(name=attrs['name'], price=-1, description=attrs['description'], category=current_category) m.save() elif len(detail)>1: m = MenuItem(name=attrs['name'], price=-2, description=attrs['description'], category=current_category) m.save() o = OptionPrice(item=m, option_one=detail[0], price_one=detail[1], option_two=detail[2], price_two=detail[3]) o.save() else: m = MenuItem(name=attrs['name'], price=strip_dollar(attrs['price']), description=attrs['description'], category=current_category) m.save() elif name == 'category': # category # create category c = Category(name=attrs['name']) if 'description' in attrs: c.description=attrs['description'] c.store = current_store c.save() current_category = c elif name == 'menu': s = Store(name=attrs['store'], store_category=StoreCategory.objects.get(name='House Dining')) s.save() current_store = s
import restaurant from legals.models import Store, Category, MenuItem, OptionPrice s = restaurant.models.Store.objects.get(id=1) s_new = Store(name=s.name, address=s.address, city=s.city, state=s.state, phone=s.phone) s_new.save() cats = restaurant.models.Category.objects.filter(store=s) for c in cats: newc = Category(name=c.name, description=c.description) newc.save() # get old items items = c.menuitem_set.all() for i in items: # create new items m = MenuItem(name=i.name, price=i.price, description=i.description, category=newc) m.save() # if it has multiple price if i.price == -2: p = i.optionprice_set.all()[0] o = OptionPrice(item=m, option_one=p.option_one, price_one=p.price_one, option_two=p.option_two, price_two=p.price_two) o.save()
m.save() m = MenuItem.objects.get(name="Filet Mignon 8 oz.") m.price = 28.95 m.save() m = MenuItem.objects.get(name="Oven Roasted Herbed Chicken") m.description = "sweet potato mashed, broccoli and lemon butter sauce" m.price = 18.95 m.save() try: c = Category.objects.get(name="Completely Legal") except Category.DoesNotExist: c = Category(name="Completely Legal", description="Chef Inspired Dinners") c.save() try: MenuItem.objects.get(name="Legal's Signature Crab Cakes (Combo)") except MenuItem.DoesNotExist: m = MenuItem(name="Legal's Signature Crab Cakes (Combo)", description="one crab cake, grilled shrimp and scallops; jumbo lump crab, mustard sauce, seasaonal salad (contains nuts)", price=26.95, category=c) m.save() try: MenuItem.objects.get(name="Legal's Signature Crab Cakes (Dinner)") except MenuItem.DoesNotExist: m = MenuItem(name="Legal's Signature Crab Cakes (Dinner)", description="two crab cakes; jumbo lump crab, mustard sauce, seasaonal salad (contains nuts)", price=27.95, category=c) m.save() try: MenuItem.objects.get(name="Double Stuffed Baked Shrimp") except MenuItem.DoesNotExist: