help with jsonrpc

[Trevor Overman]

So I'm trying to connect an android application to my web2py website back end database by using json remote procedure calls.
Currently, I am trying to make a simple test function to remotely add entries in the db.
Additionally, I am running on GAE.

What I have right now is:

db.py

db.define_table('testing',
    Field('number_sum','string'),
)

default.py

def call():
    return service()

@service.jsonrpc
def test_add(a,b):
    sum = a+b
    db.testing.insert(numer_sum=sum)
    return a+b

when I run the following in terminal,
curl http://domain/app/default/call/run/test_add?a=3&b=4

I receive an "Object does not exist" error.
Any help would be appreciated!

-Trevor

[Anthony]

db.testing.insert(numer_sum=sum)

Shouldn't the above be number_sum?

[Trevor Overman]

ah you're right.. x.x...
unfortunately, I am still receiving the same error.
Another thing, when I try accessing the url with a specific port, ex. http://domain:port/app/default/call/run/test_add?a=3&b=4 GAE is sending me a timeout error. hmm...

[Jonathan Lundell]

Change 'run' to 'jsonrpc', since that's how you declared test_add. But curl isn't going to create a jsonrpc request for you, so that part won't work.

If you want the curl request to work (with /run/), you need @service.run rather than @service.jsonrpc.

[Trevor Overman]

Finally got things working. For anyone out there reading this, I fixed the problem by utilizing urlfetch in GAE.

@service.jsonrpc
def test_add(a,b):
    number_sum = a+b
    db.testing.insert(number_sum=number_sum)
    return a+b

def test():
    from gluon.contrib.simplejsonrpc import ServerProxy
    from google.appengine.api import urlfetch
    URL = "http://www.conex.us/conexus/default/call/jsonrpc"
    urlfetch.set_default_fetch_deadline(60)
    service = ServerProxy(URL, verbose=True)
    test = service.test_add(1, 2)
    return test

Anyway, thanks for the help! :)

[Dave S]

On Saturday, March 1, 2014 4:34:42 PM UTC-8, Trevor Overman wrote:

Finally got things working. For anyone out there reading this, I fixed the problem by utilizing urlfetch in GAE.

Works with curl, or works with your Android app?

In either case, thanks for the update!

/dps