WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py



                    item.commission = snapdealitem.commission
                if snapdealitem.serviceTax is not None:
                    item.serviceTax = snapdealitem.serviceTax
                item.suppressPriceFeed =snapdealitem.suppressPriceFeed
                item.suppressInventoryFeed =snapdealitem.suppressInventoryFeed 
 
                item.maxNlc = snapdealitem.maxNlc
                item.skuAtSnapdeal = snapdealitem.skuAtSnapdeal
                item.supc = snapdealitem.supc
                item.updatedOn = datetime.datetime.now()    
                session.commit()
                return True

    except:
        return False
 
def get_snapdeal_item(itemid):
    item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==itemid).first()
 
    return item
              
def get_all_snapdeal_items():
    items = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).all()
 
    return items
 
def get_snapdeal_items(offset,limit):
    return session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).offset(offset).limit(limit).all()
 

    snapdeal_item = SnapdealItem.get_by(skuAtSnapdeal=sku)
    if snapdeal_item is not None: 
        item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==snapdeal_item.item_id).first()
    else:
        return None    
 
    return item
    
    
 
    

Rev 9581	Rev 9595
Line 2151...	Line 2151...
2151	`item.commission = snapdealitem.commission`	2151	`item.commission = snapdealitem.commission`
2152	`if snapdealitem.serviceTax is not None:`	2152	`if snapdealitem.serviceTax is not None:`
2153	`item.serviceTax = snapdealitem.serviceTax`	2153	`item.serviceTax = snapdealitem.serviceTax`
2154	`item.suppressPriceFeed =snapdealitem.suppressPriceFeed`	2154	`item.suppressPriceFeed =snapdealitem.suppressPriceFeed`
2155	`item.suppressInventoryFeed =snapdealitem.suppressInventoryFeed`	2155	`item.suppressInventoryFeed =snapdealitem.suppressInventoryFeed`
2156	`if snapdealitem.maxNlc is not None:`	-
2157	`item.maxNlc = snapdealitem.maxNlc`	2156	`item.maxNlc = snapdealitem.maxNlc`
2158	`item.skuAtSnapdeal = snapdealitem.skuAtSnapdeal`	2157	`item.skuAtSnapdeal = snapdealitem.skuAtSnapdeal`
2159	`item.supc = snapdealitem.supc`	2158	`item.supc = snapdealitem.supc`
2160	`item.updatedOn = datetime.datetime.now()`	2159	`item.updatedOn = datetime.datetime.now()`
2161	`session.commit()`	2160	`session.commit()`
2162	`return True`	2161	`return True`
Line 2164...	Line 2163...
2164	`except:`	2163	`except:`
2165	`return False`	2164	`return False`
2166		2165
2167	`def get_snapdeal_item(itemid):`	2166	`def get_snapdeal_item(itemid):`
2168	`item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==itemid).first()`	2167	`item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==itemid).first()`
2169	`print item`	-
2170	`return item`	2168	`return item`
2171		2169
2172	`def get_all_snapdeal_items():`	2170	`def get_all_snapdeal_items():`
2173	`items = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).all()`	2171	`items = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).all()`
2174	`print items`	-
2175	`return items`	2172	`return items`
2176		2173
2177	`def get_snapdeal_items(offset,limit):`	2174	`def get_snapdeal_items(offset,limit):`
2178	`return session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).offset(offset).limit(limit).all()`	2175	`return session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).offset(offset).limit(limit).all()`
2179		2176
Line 2224...	Line 2221...
2224	`snapdeal_item = SnapdealItem.get_by(skuAtSnapdeal=sku)`	2221	`snapdeal_item = SnapdealItem.get_by(skuAtSnapdeal=sku)`
2225	`if snapdeal_item is not None:`	2222	`if snapdeal_item is not None:`
2226	`item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==snapdeal_item.item_id).first()`	2223	`item = session.query(SnapdealItem,Item).join((Item,SnapdealItem.item_id==Item.id)).filter(SnapdealItem.item_id==snapdeal_item.item_id).first()`
2227	`else:`	2224	`else:`
2228	`return None`	2225	`return None`
2229	`print item`	-
2230	`return item`	2226	`return item`
2231		2227
2232		2228
2233		2229
2234		2230

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py – Rev 9581 → 9595