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