from flask import Flask,jsonify, render_template, request, url_for
from SimpleXMLRPCServer import SimpleXMLRPCServer
import os
import sys
import subprocess
import string
import xmlrpclib
import json

app = Flask(__name__)

HOST = '190.186.246.60'
PORT = 8169
DB = 'iTiendaV8'
USER = 'admin'
PASS = 'admin'
url = 'http://%s:%d/xmlrpc/' % (HOST,PORT)
common_proxy = xmlrpclib.ServerProxy(url+'common')
object_proxy = xmlrpclib.ServerProxy(url+'object')
UID = common_proxy.login(DB,USER,PASS)
print UID

def execute(*args):
    return object_proxy.execute(DB,UID,PASS,*args)

@app.route('/api/itienda/productos/<int:cantidad>', methods=['POST'])
def conexion(cantidad):
    productos = []
    # sale_ok
    args = [('active', '=', True),('qty_available','<=',cantidad)]
    ids = execute('product.product', 'search', args)
    fields = ['default_code','qty_available']
    productos = execute('product.product', 'read',ids, fields)
    return json.dumps(productos)

if __name__ == "__main__":
	app.run()