Re: Fetch DB values and execute in script

[howesc]

i'm not exactly sure what you are trying to do here based on the description above, so i'm gonna take a guess and see if i can point you in a helpful direction....

so i use a settings table as well....i like to put it's contents in memcache to save database reads.  my settings pretty rarely change, and are only about 10 rows so i do something like:

settings = cache.ram('db_settings', lambda: db(db.settings.id>0).select().as_dict(), time_expire=3600)

note that i use as_dict() since rows objects are not serializable into memcache.

so then i might:

def controller_method():
  settings = cache.ram('db_settings', lambda: db(db.settings.id>0).select().as_dict(), time_expire=3600)
  result = do_something(settings, request.vars.data)
  db.results.insert(data=result)
  return dict(result=result)

def do_something(settings, data)
 ...
 return result

On Thursday, July 26, 2012 9:32:00 AM UTC-7, Douglas McCormick Jr. wrote:

Hi Everyone,

I have values stored in a web2py table (db.settings) that I'd like to pass into python functions to later on (via some processing) get results.  Here's an example

<db.settings>

==========================

| db.settings.id  |  db.settings.key  |

| ----------------------|------------------------- | 

|    1                 |    abc                 |

| ----------------------|--------------------------|

<somepythonscript.py>

========================

def do_something(data):

   ...

   x = something_with_json_fetching(data)

   return x

I want to grab the "db.settings.key" and push it into my python function "do_something" to return the "x" results back to the html.

The next step (doesn't needed to be answered in this question) I'd like to push the x results (which is JSON) into a database table entry...I'm working on that part, I think I know what to do there.

Can anyone help me out?

Thanks,

-Doug Jr.