def alterar_item(): idAnuncio = session.anuncio['id'] ## Faz Uploads das imagens e retorna Ids imagens = imagem_upload(idAnuncio) body = dict(title=session.anuncio['title'], price=session.anuncio['price'], available_quantity=session.anuncio['available_quantity'], shipping=session.anuncio['frete'], attributes=session.anuncio['attributes'], pictures=imagens, ) #### Buscar Variações #### variacao = buscar_variacao(idAnuncio,imagens) bodyvariacao = dict(title=session.anuncio['title'], shipping=session.anuncio['frete'], attributes=session.anuncio['attributes'], variations=variacao, ) listing_type_id = dict(id=session.anuncio['listing_type_id']) description = session.anuncio['description'] item_args = "items/%s" %(session.anuncio['item_id']) descricao_args = "%s/description" %(item_args) tipo_args = "%s/listing_type" %(item_args) if session.ACCESS_TOKEN: from meli import Meli meli = Meli(client_id=CLIENT_ID,client_secret=CLIENT_SECRET, access_token=session.ACCESS_TOKEN, refresh_token=session.REFRESH_TOKEN) if session.anuncio['forma'] == 'Multiplos': item = meli.put(item_args, bodyvariacao, {'access_token':session.ACCESS_TOKEN}) else: item = meli.put(item_args, body, {'access_token':session.ACCESS_TOKEN}) desc = meli.put(descricao_args,description, {'access_token':session.ACCESS_TOKEN}) tipo = meli.post(tipo_args, listing_type_id, {'access_token':session.ACCESS_TOKEN}) if item.status_code != 200 or desc.status_code != 200: status = 'Falha na Atualização do Item : item:%s Descrição:%s' %(item,desc) else: status = 'Anuncio Atualizado com Sucesso....' else: status = 'Antes Faça o Login....' item = '' response.flash = status response.js = "$('#anunciospublicar').get(0).reload()" return
def atualizar_ean(): rows = db(Anuncios.id > 0).select() for row in rows: atributos = [] buscaAtributos = db(Anuncios_Atributos.anuncio == row.id).select() for atributo in buscaAtributos: atributo_id = Atributos(atributo.atributo).atributo_id atributos.append(dict(id=atributo_id, value_name=atributo.valor)) if atributos: body = dict(attributes=atributos) item_id = Anuncios[int(row.id)].item_id item_args = "items/%s" % (item_id) if session.ACCESS_TOKEN: from meli import Meli meli = Meli(client_id=CLIENT_ID, client_secret=CLIENT_SECRET, access_token=session.ACCESS_TOKEN, refresh_token=session.REFRESH_TOKEN) item = meli.put(item_args, body, {'access_token': session.ACCESS_TOKEN}) if item.status_code != 200: status = 'Falha na Atualização do Item : item:%s Descrição:%s Tipo:%s' % ( item, desc, tipo) else: status = 'Anuncio Atualizado com Sucesso....' else: status = 'Antes Faça o Login....' item = ''
def sincronizar_preco(): if session.ACCESS_TOKEN: from meli import Meli meli = Meli(client_id=CLIENT_ID, client_secret=CLIENT_SECRET, access_token=session.ACCESS_TOKEN, refresh_token=session.REFRESH_TOKEN) anuncios = db(Anuncios.status == 'active').select() #anuncios = db(Anuncios.id == 841).select() #anuncios = db(Anuncios.forma == 'Multiplos').select() for anuncio in anuncios: if anuncio['item_id']: if anuncio['forma'] == 'Multiplos': body = dict(variations=buscar_variacao_preco( anuncio['id'], anuncio['preco'])) else: body = dict(price=float(anuncio['preco'])) item_args = "items/%s" % (anuncio['item_id']) item = meli.put(item_args, body, {'access_token': session.ACCESS_TOKEN}) if item.status_code != 200: print '%s - %s - %s' % (anuncio['item_id'], anuncio['id'], item) session.flash = 'Preços Atualizado com Sucesso' else: session.flash = 'Antes Faça o Login....' response.js = "location.reload(true)" return
def main(): meli = Meli(client_id=CLIENT_ID, client_secret=CLIENT_SECRET, access_token=ACCESS_TOKEN, refresh_token=REFRESH_TOKEN) body = {"title": "oculos edicao especial!", "price": 1000} response = meli.put("/items/ITEM_+ID", body, {'access_token': meli.access_token}) print response.content
def anunciar_item(): idAnuncio = session.anuncio['id'] ## Faz Uploads das imagens e retorna Ids imagens = imagem_upload(idAnuncio) #### Buscar Variações #### variacao = buscar_variacao(idAnuncio,imagens) body = dict(title=session.anuncio['title'], category_id=session.anuncio['category_id'], price=session.anuncio['price'], currency_id=session.anuncio['currency_id'], available_quantity=session.anuncio['available_quantity'], buying_mode=session.anuncio['buying_mode'], listing_type_id=session.anuncio['listing_type_id'], condition=session.anuncio['condition'], warranty=session.anuncio['warranty'], description=session.anuncio['description'], shipping=session.anuncio['frete'], pictures=imagens, variations = variacao, ) bodyAtributo = dict(attributes=session.anuncio['attributes']) if session.ACCESS_TOKEN: from meli import Meli meli = Meli(client_id=CLIENT_ID,client_secret=CLIENT_SECRET, access_token=session.ACCESS_TOKEN, refresh_token=session.REFRESH_TOKEN) item = meli.post("/items", body, {'access_token':session.ACCESS_TOKEN}) else: status = 'Antes Faça o Login....' item = '' import json if item.status_code == 201: status = 'Anunciado com Sucesso....' ### Salvando item_id no banco de dados xitem = json.loads(item.content) Anuncios[int(idAnuncio)] = dict(item_id=xitem['id']) ### Salvando Atributos no ML atrib_args = "items/%s" %(xitem['id']) atrib = meli.put(atrib_args, bodyAtributo, {'access_token':session.ACCESS_TOKEN}) if atrib.status_code != 200: status = 'Falha na Atualização do Item : item:%s ' %(atrib) else: status = 'Falha na Atualização do Item : item:%s ' %(item) response.flash = status response.js = "$('#anunciospublicar').get(0).reload()" return
def atualizar_estoque(): anuncios = db(Anuncios.id > 0).select() for anuncio in anuncios: estoque = sugerido(anuncio)['estoque'] Anuncios[anuncio.id] = dict(estoque=estoque) form = FORM.confirm('Atualizar Estoque', {'Voltar': URL('default', 'index')}) if form.accepted: if session.ACCESS_TOKEN: from meli import Meli meli = Meli(client_id=CLIENT_ID, client_secret=CLIENT_SECRET, access_token=session.ACCESS_TOKEN, refresh_token=session.REFRESH_TOKEN) anuncios = db(Anuncios.id > 0).select() #anuncios = db(Anuncios.forma == 'Multiplos').select() for anuncio in anuncios: if anuncio['item_id']: variacao = [] if anuncio['forma'] == 'Multiplos': body = dict( variations=buscar_variacao_estoque(anuncio['id'])) else: body = dict( available_quantity=float(anuncio['estoque'])) item_args = "items/%s" % (anuncio['item_id']) item = meli.put(item_args, body, {'access_token': session.ACCESS_TOKEN}) if item.status_code != 200: print '%s - %s - %s' % (anuncio['item_id'], anuncio['id'], item) response.flash = 'Estoque Atualizado com Sucesso....' else: status = 'Antes Faça o Login....' return dict(form=form)
class MeliTest(unittest.TestCase): def setUp(self): self.CLIENT_ID = "123" self.CLIENT_SECRET = "a secret" self.ACCESS_TOKEN = "a access_token" self.REFRESH_TOKEN = "a refresh_token" self.NEW_ACCESS_TOKEN = "a new access_token" self.NEW_REFRESH_TOKEN = "a new refresh_token" self.meli = Meli(client_id=self.CLIENT_ID, client_secret=self.CLIENT_SECRET, access_token=self.ACCESS_TOKEN, refresh_token=self.REFRESH_TOKEN) #constructor tests def testClientId(self): self.assertEqual(self.meli.client_id, self.CLIENT_ID) def testClientSecret(self): self.assertEqual(self.meli.client_secret, self.CLIENT_SECRET) def testAccessToken(self): self.assertEqual(self.meli.access_token, self.ACCESS_TOKEN) def testRefreshToken(self): self.assertEqual(self.meli.refresh_token, self.REFRESH_TOKEN) #auth_url tests def testAuthUrl(self): callback = "http://test.com/callback" self.assertTrue(re.search("^http", self.meli.auth_url(redirect_URI=callback))) self.assertTrue(re.search("^https\:\/\/auth.mercadolibre.com\/authorization", self.meli.auth_url(redirect_URI=callback))) self.assertTrue(re.search("redirect_uri", self.meli.auth_url(redirect_URI=callback))) self.assertTrue(re.search(self.CLIENT_ID,self.meli.auth_url(redirect_URI=callback))) self.assertTrue(re.search("response_type", self.meli.auth_url(redirect_URI=callback))) #Mock requests def mockGet(url, path=None, params={},headers={}, data=None, body=None): response = requests.Response() if re.search("/users/me", url): if "access_token" in params: response.status_code = 200 else: response.status_code = 403 elif re.search("/authorization", url): response.status_code = 200 else: response.status_code = 200 return response def mockPost(url, path=None, body=None, params={},headers={}, data=None): response = requests.Response() if re.search("/oauth/token", url): if "grant_type" not in params or "client_id" not in params or "client_secret" not in params: response.status_code = 403 else: if re.search("grant_type=authorization_code", params): content = {'access_token' : 'a access_token', 'refresh_token' : 'a refresh_token'} elif re.search("grant_type=refresh_token", params): content = {'access_token' : 'a new access_token', 'refresh_token' : 'a new refresh_token'} response._content = json.dumps(content) response.status_code = 200 else: if "access_token" in params: response.status_code = 200 else: response.status_code = 403 return response def mockPut(url, path=None, body=None, params={},headers={}, data=None): response = requests.Response() if "access_token" in params: response.status_code = 200 else: response.status_code = 403 return response def mockDelete(url, path=None, params={},headers={}, data=None, body=None): response = requests.Response() if "access_token" in params: response.status_code = 200 else: response.status_code = 403 return response requests.get = mockGet requests.post = mockPost requests.put = mockPut requests.delete = mockDelete #requests tests def testGet(self): response = self.meli.get(path="/items/test1") self.assertEqual(response.status_code, requests.codes.ok) def testPost(self): body = {"condition":"new", "warranty":"60 dias", "currency_id":"BRL", "accepts_mercadopago":True, "description":"Lindo Ray_Ban_Original_Wayfarer", "listing_type_id":"bronze", "title":"oculos Ray Ban Aviador Que Troca As Lentes Lancamento!", "available_quantity":64, "price":289, "subtitle":"Acompanha 3 Pares De Lentes!! Compra 100% Segura", "buying_mode":"buy_it_now", "category_id":"MLB5125", "pictures":[{"source":"http://upload.wikimedia.org/wikipedia/commons/f/fd/Ray_Ban_Original_Wayfarer.jpg"}, {"source":"http://en.wikipedia.org/wiki/File:Teashades.gif"}] } response = self.meli.post(path="/items",body=body,params={'access_token' : self.meli.access_token}) self.assertEqual(response.status_code, requests.codes.ok) def testPut(self): body = {"title":"oculos edicao especial!", "price":1000 } response = self.meli.put(path="/items/test1",body=body,params={'access_token' : self.meli.access_token}) self.assertEqual(response.status_code, requests.codes.ok) def testDelete(self): response = self.meli.delete(path="/questions/123",params={'access_token' : self.meli.access_token}) self.assertEqual(response.status_code, requests.codes.ok) def testWithoutAccessToken(self): response = self.meli.get(path="/users/me") self.assertEqual(response.status_code, requests.codes.forbidden) def testWithAccessToken(self): response = self.meli.get(path="/users/me",params={'access_token' : self.meli.access_token}) self.assertEqual(response.status_code, requests.codes.ok) #auth tests def testAuthorize(self): self.meli.access_token = None self.meli.refresh_token = None response = self.meli.authorize(code="a code from get param", redirect_URI="A redirect Uri") self.assertEqual(self.meli.access_token, self.ACCESS_TOKEN) self.assertEqual(self.meli.refresh_token, self.REFRESH_TOKEN) def testDoRefreshToken(self): response = self.meli.get_refresh_token() self.assertEqual(self.meli.access_token, self.NEW_ACCESS_TOKEN) self.assertEqual(self.meli.refresh_token, self.NEW_REFRESH_TOKEN)
def main(): meli = Meli(client_id=CLIENT_ID,client_secret=CLIENT_SECRET, access_token=ACCESS_TOKEN, refresh_token=REFRESH_TOKEN) body = {"title":"oculos edicao especial!", "price":1000 } response = meli.put("/items/ITEM_+ID", body, {'access_token':meli.access_token}) print response.content