[web2py] SQLForm.factory and Ajax function

I have a drop-down menu created from a field in my DB using SQLForm.factory. How can I assign an Ajax function to the onchange event of the drop-down menu? The drop-down menu is created from a table called "cities" by: form = SQLFORM.factory(Field('City', requires=IS_IN_DB(db, 'cities.id', '%(na

[web2py] Re: keep shared objects permanently in RAM: Is it possible ?

cache.ram() with an high expire time, or redis with the contrib module will make that possible. Obviously the "BIG chunk of information" needs to be serialized (Written to cache) and deserialized (Read from Cache), so don't go too far in "too big" (<5mb) . On Feb 6, 1:06 am, Bruno Rocha wrote:

[web2py] Re: DAL Connection String

in gluon/dal.py you can find this def __init__(self, uri='sqlite://dummy.db', pool_size=0, folder=None, db_codec='UTF-8', check_reserved=None, migrate=True, fake_migrate=False, migrate_enabled=True, fake_migrate_all=False,

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

I'm talking about ~16G... Just investigating if it makes sense (if it is possible) to reimplement a Java EE application in Python... I guess that I should re post this question in WSGI group On Mon, Feb 6, 2012 at 9:41 AM, Niphlod wrote: > cache.ram() with an high expire time, or redis with

[web2py] Re: keep shared objects permanently in RAM: Is it possible ?

let me be clear... you want to share in some place 16 gigabytes of data that someone can access in a single chunk to work with (i.e. every client needs to have 16 gb all in memory for itself)? let's say you have 4 different users, you ideally have: - 16gb for the "storage", whatever system you cho

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

2012/2/6 Sebastian E. Ovide : > I'm talking about ~16G... Just investigating if it makes sense (if it is > possible) to reimplement a Java EE application in Python... - possible for sure. - makes sense? IMHO 16gb of shared memory, make wonder how the application was implemented in the first place.

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

nop, I said SHARED among sessions... so say that we have few hundreds of users connected at the same time, each of them has it own small session, and all of them can access a shared 16G (which is managed by a class that knows how to manage it... so some methods are thread safe and some methods are

[web2py] Re: processing upload field.

Uh, this one is tricky. computed fields are there to let you process the "computed" one basing on the unprocessed "normal" fields. So, you can definitely compute B from the "original" A. How do you normally process field A ?

[web2py] Table inheritance issues and a possible fix (648, 649, 353)

I've run against table inheritance problems (documented in http://code.google.com/p/web2py/issues/detail?id=649 and http://code.google.com/p/web2py/issues/detail?id=648) and others have too (http://code.google.com/p/web2py/issues/detail?id=353). Patches are provided with specific solutions. Ho

[web2py] how to iterate over a web2py row object to get all rows

Hi All, I am using web2py 1.99.4 on Win7. I have this part of code that I want to serialize to a view but conditionally. I am trying to retrieve id's from one table and pass the id's to get data from another table. Although I am able to make it work from within the loop but from outside of the

[web2py] Re: How to replace this native query with DAL

hum happen_time is a column of db.cash_journal ? and you want only the records that satisfy the conditions on the query, and in addition, that the difference in seconds between happen_time and now is less than "seconds" (259200) ? Without a test db I can't confirm, but can you try something al

[web2py] Re: lungo.js

GPL licensing would be an issue for me.

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

I can't imagine that every request would need to access all 16G every time. I use a method for caching data between requests using modules. I don't know if it would be truly shared between requests, or like Niphlod said, would be duplicated for each request. I have had a lot of success using mo

[web2py] Re: how to iterate over a web2py row object to get all rows

well... for row in lfu: list_friend_updates= getfriend(row.friendid) print list_friend_updates return dict(list_friend_updates=list_friend_updates) prints all, but reassign for every loop to list_friend_updates ONLY the getfriend(row.friendid). You are not seeing the first record when re

[web2py] Re: using radio widget can't receive the empty submit

It works for me. Try with this view (which does not include the layout): {{=form}} {{=xform}} {{=request.args}}{{=request.vars}} response.flash={{=response.flash}} On Feb 6, 2:49 am, Dan wrote: > My view did include the default layout, I omit it when I writing this > discussions. > > The respon

[web2py] Re: plugin google map

Hi mdipierro, I am fairly a newbie to python and sql, I have a task to render a google map as my home page (thereby replacing the default welcome page), and then populating the map with placemarks read from a table I have created in the database. The table already has latitude and longitude as

Re: [web2py] Re: lungo.js

GPLv3 = Fail On Mon, Feb 6, 2012 at 7:22 PM, Ross Peoples wrote: > GPL licensing would be an issue for me.

Re: [web2py] Getting the name of the Application

Yup . Thank you David! On Sun, Feb 5, 2012 at 9:13 PM, David wrote: > On 2/5/12 10:06 AM, Sathvik Ponangi wrote: > >> How do I get the name of the current Web2Py app, so that my code is >> resilient to app-name changes? >> > request.applica

[web2py] Re: SQLForm.factory and Ajax function

You can use the element function on the created form to locate the field (as explained in the book section "Server-side DOM and Parsing" in chapter 5) and add the onchange to it: c = form.element(_name='City') c['onchange'] = XML("ajax('function_name', ['City'], 'target_div');") On Feb 6, 4:05 

Re: [web2py] processing upload field.

On Fri, Feb 3, 2012 at 11:58 AM, VP wrote: > I have the following situation. > > There is a field A of type upload (image). > > There is another field B of type compute, which depends on A. > > I want to be able to process the image uploaded in field A and save > it, but before the compute in fiel

[web2py] help with extra_fields on auth_user needed

I added an extra field for the purpose of having digital signature image in it. The image displayed first time I added the field, but then stopped and now doesn't display on the local server. At the same time, another image from a different table displays fine in the same view. Am I doing som

[web2py] Re: help with extra_fields on auth_user needed

same code, on the same database works on a remote server, but not on a local computer.

[web2py] Re: SQLForm.factory and Ajax function

Another option is to handle it entirely on the client side via jQuery (in a script tag or a loaded script): $(function() { $('select[name="City"]').change(function() { ajax('function_name', ['City'], 'target_div'); }); }); Anthony On Monday, February 6, 2012 9:25:29 AM UTC-5, DenesL wr

[web2py] Re: Export CSV

Worked ! On Feb 3, 5:41 pm, Anthony wrote: > On Friday, February 3, 2012 6:16:09 PM UTC-5, Omi Chiba wrote: > > > Do I need to rewrite this "export_csv" function completely ? or Can I > > just add import csv and set QUOTE_ALL ? > > > Controller > > -- > > def export_csv():

[web2py] Re: help with extra_fields on auth_user needed

Is the image on the local server? If the image was uploaded to the remote server, it will only display on the remote server unless it was copied to the local server. On Monday, February 6, 2012 10:19:45 AM UTC-5, Adi wrote: > > same code, on the same database works on a remote server, but not on

[web2py] Re: help with extra_fields on auth_user needed

the original image was uploaded on the local server, but then when I deployed the app then the remote didn't work... so I uploaded it there, and I bet unique # changed... so I guess I'll need to copy image from there :) Thanks Anthony for help! Adnan

[web2py] Re: update with variable field (stored in variable)

works like a charm. Thanks a ton. On Feb 5, 9:15 pm, Anthony wrote: > On Sunday, February 5, 2012 2:04:13 PM UTC-5, Serbitar wrote: > > > I need to do something like this: > > > variable_field = 'val1' > > x = 2 > > id = 1 > > > db.define_table('a', > >     Field('name', type = 'integer'), > >  

[web2py] custom.widget manipulation with checkboxes

I can do something like this: fields = [Field('myfield', type = integer, default = db((db.mytable.id==id).select(db.mytable.myfield).first()] form=SQLFORM.factory( *fields) if form.accepts(request.vars, session): db(db.mytable.id==id).update(myfield=form.vars[entry]) form.custom.widget['my

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

16G is nothing 2day... think about a raster image of UK ! even if it was something smaller, imagine the time saved if you could keep some objects always in memory saving serialization and data loading times I don't need nothing really fancy, just something similar to Java Servlets (they keep

[web2py] Errors throw by job running in the scheduler

Hi I'm experimenting with the new scheduler. I have a program that is running there but gets a FAILED result. It would be nice if this created a web2py ticket I could then track down and fix, but it doesn't. Any plans to add that, or do I have something setup wrong that is causing me not t

[web2py] using an IDE with web2py

I am using aptana. I have included the modules and models directories in the pythonpath; and at the top of each python file I have "from ide import *". This refers to the file below and is supposed to to stop it marking references to web2py variables as errors and to enable autocomplete. This see

[web2py] Re: Errors throw by job running in the scheduler

Tickets don't get created, but there should be a trace in the database. Take a look in the db.scheduler_run.traceback field of the task in question. The scheduler_run.status should be FAILED and you'll see the run times, etc. in other columns... Basically, everything about the scheduler is in t

Re: [web2py] Re: Errors throw by job running in the scheduler

Just what I needed, thanks! -Jim On 2/6/2012 11:39 AM, LightDot wrote: Tickets don't get created, but there should be a trace in the database. Take a look in the db.scheduler_run.traceback field of the task in question. The scheduler_run.status should be FAILED and you'll see the run ti

[web2py] Re: using an IDE with web2py

I'm not sure about that problem, but note that trunk now includes the following in __init__.py: if 0: from globals import Request, Response, Session from cache import Cache from languages import translator request = Request() response = Response() session = Session() c

[web2py] Re: using an IDE with web2py

If I do "from gluon import *" then it does not find request, response, session. If I do "from gluon import request,response,session" then it works! I guess this is an aptana bug. On Feb 6, 5:44 pm, Anthony wrote: > I'm not sure about that problem, but note that trunk now includes the > followin

[web2py] Re: using an IDE with web2py

On Monday, February 6, 2012 1:18:55 PM UTC-5, apple wrote: > > If I do "from gluon import *" then it does not find request, response, > session. > Are you using trunk? I've got Aptana, and using trunk, if I do "from gluon import *", I get autocompletion for request, response, session, cache. An

[web2py] Re: using an IDE with web2py

That is odd. Yes I am on trunk and I have checked the gluon __init__.py file and it is exactly as you show above. On Feb 6, 6:34 pm, Anthony wrote: > On Monday, February 6, 2012 1:18:55 PM UTC-5, apple wrote: > > > If I do "from gluon import *" then it does not find request, response, > > session

[web2py] Re: SQLForm.factory and Ajax function

Thank you so much for the responses. I tried both methods, but none worked for me. I am guessing I have something typed wrongly. With the first method I came up with: def index():     form = SQLFORM.factory(Field('City',  requires=IS_IN_DB(db, 'cities.id', '%(name)s',error_message='Please select a

[web2py] new web2py application

Fine! http://www.globaleaks.org/

[web2py] Re: SQLForm.factory and Ajax function

Can you use the browser developer tools to see if the Ajax call is getting sent? On Monday, February 6, 2012 1:50:40 PM UTC-5, shartha wrote: > > Thank you so much for the responses. > I tried both methods, but none worked for me. I am guessing I have > something typed wrongly. With the first m

[web2py] Python Job Burnaby, BC - On site - 3 month contract around $4,000 a month

Hi, I am seeking a python developer to join my team for a 3 month contract, if the developer is successful we will extend the length of the contract, or even offer full-time employment. To start we are offering $4000 a month we may offer a little more depending on the developers skills. Project

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

16 GB shared across requests is called "Database", to run a memory like database you should go with Redis!

[web2py] Re: SQLForm.factory and Ajax function

Hi Anthony, No, it is not called. I tried to define the drop-down menu in a different way: form=FORM(SELECT('Iowa City', 'Cedar Rapids', _id='keyword',_name='City', _onchange="ajax('callback', ['City'], 'target');")) Note that in this case, the values of the drop-down menu are hard- coded (I

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

unfortunately I think that deserializing 16gb of data in a single chunk will choke redis too...

[web2py] Re: SQLForm.factory and Ajax function

You are missing the underscore from '_onchange' (my bad): c['_onchange'] = XML("ajax('callback', ['City'], 'target');") On Feb 6, 1:50 pm, shartha wrote: > Thank you so much for the responses. > I tried both methods, but none worked for me. I am guessing I have > something typed wrongly. With t

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

Use mmap module that is what you need. http://docs.python.org/library/mmap.html mic 2012/2/6 Niphlod : > unfortunately I think that deserializing 16gb of data in a single chunk will > choke redis too...

Re: [web2py] dataTables with serverside json

Revive pretty old thread!!! Hello Vineet, I fall on this thread today as I was trying to put serverside to work with datatables... I also read this threa on stackoverflow : http://stackoverflow.com/questions/6476133/json-data-for-jquery-datatable-in-web2py Until now here what I come with : def

[web2py] Re: SQLForm.factory and Ajax function

Thank you! My problem is solved now! It's strange as I suspected that and tried it with an underscore too, but it didn't work. On Feb 6, 2:41 pm, DenesL wrote: > You are missing the underscore from '_onchange' (my bad): > > c['_onchange'] = XML("ajax('callback', ['City'], 'target');") > > On Fe

[web2py] Re: new web2py application

wow. nice. On Feb 6, 12:54 pm, leone wrote: > Fine!http://www.globaleaks.org/

[web2py] VPScolo.com Five dolar VPS, anybody knows it?

I was looking for some cheap VPS options and I found this one www.vpscolo.com There is a plan for $5 that gives you 256MB burst to 512MB (I don't know how this "burst" happens yet...) but seems interesting... Anybody have ever heard about this VPS hosting? Thanks in advance, Tito -- Linux Use

Re: [web2py] Re: keep shared objects permanently in RAM: Is it possible ?

On Mon, Feb 6, 2012 at 7:39 PM, Bruno Rocha wrote: > 16 GB shared across requests is called "Database", to run a memory like > database you should go with Redis! > :D it sounds a lot... but it is not anymore... specially if you want to serve a lot of requests in realtime ! we are using two mach

[web2py] Re: Python Job Burnaby, BC - On site - 3 month contract around $4,000 a month

Update: We will allow developers to work remote on this project. Requirements: 1) Company specific software must not be released to anyone who is not an employee. 2) Company owns the rights to the software developed during the contract. 3) Members of web2py core development team must give you a r

[web2py] Re: SQLForm.factory and Ajax function

One more question, how can I access the value selected in the drop- down menu from within my callback function? Firebug shows under POST that there is a Parameter called City with a value that is different based on the selected item from the drop-down menu. However, I cannot access its value simply

[web2py] Re: SQLForm.factory and Ajax function

On Monday, February 6, 2012 4:32:39 PM UTC-5, shartha wrote: > > One more question, how can I access the value selected in the drop- > down menu from within my callback function? Firebug shows under POST > that there is a Parameter called City with a value that is different > based on the select

[web2py] Re: SQLForm.factory and Ajax function

Thanks DenesL and Anthony so much! Anthony, I don't know who you are or what you do, I just wanted to thank you for all the help you provide to the group. I would've loved to have a coffee with you! I like how you are always among the people who answer my questions! =) On Feb 6, 3:47 pm, Anthony

[web2py] Scheduler json string for vars parm

Hi I'm having trouble getting my vars json string right on my call to add a job to my scheduler. If I run with no vars, it works fine. But, when I add my json string I'm getting: Traceback (most recent call last): File "C:\dev\web2py\gluon\scheduler.py", line 159, in executor vars = l

Re: [web2py] Scheduler json string for vars parm

Yes I think the json format is strict to " instead of ' change with this and try again: vars='{"fromDate":"2012-01-01","toDate":"2012-01-31","districtNumber":0}', 2012/2/6 Jim Steil > Hi > > I'm having trouble getting my vars json string right on my call to add a > job to my scheduler. If I r

[web2py] Problem with custom modules

Hi, Just wondering how does web2py determine what modules to load from the modules directory? For some reason I just added payoneer_api.py in the modules directory but am getting the following error message. (Restarted the server still no difference) z_api.py: # coding: utf8 from reports_api imp

Re: [web2py] Scheduler json string for vars parm

That did it. Thanks! How do we go about getting the book updated? Page 195 is showing the syntax I was using. -Jim On 2/6/2012 4:18 PM, Martín Mulone wrote: Yes I think the json format is strict to " instead of ' change with this and try again: vars='{"fromDate":"2012-01-01","toDate"

Re: [web2py] dataTables with serverside json

Hello Bruno, Thanks to notice... I would prefer to not have dependencies... I will look into your code to try to understand why I can't have DTs to parse my json response... Richard On Mon, Feb 6, 2012 at 4:44 PM, Bruno Rocha wrote: > > BTW. PowerGrid is a plugin wrote with Jquery templates an

[web2py] Re: Problem with custom modules

Found the problem: from BeautifulSoup import BeautifulStoneSoup I was not using my virtualenv to run web2py so instead of reporting the import error it just prevents the module from loading. I see the good and bad with this approach is there a way to force web2py to tell about errors found when l

Re: [web2py] dataTables with serverside json

Hey Bruno, Is PowerGrid base on DTs? PowerTable was but I can't find any trace of DTs in PowerGrid... Thanks. Richard On Mon, Feb 6, 2012 at 5:27 PM, Richard Vézina wrote: > Hello Bruno, > > Thanks to notice... I would prefer to not have dependencies... I will look > into your code to try to

[web2py] registration_requires_approval & login_after_registration

I don't know if I'm doing something wrong or it's not working as expected. I want the user to be approved before they can log in. I created a new application in web2py with all the default settings. In db.py, I added: auth.settings.registration_requires_approval = True auth.settings.login_after_

[web2py] anybody around Denver

looking for a consulting opportunity? if so let me know. Massimo

Re: [web2py] dataTables with serverside json

Not, PowerGrid is based in pure Jquery Templates -- Bruno Rocha [http://rochacbruno.com.br]

Re: [web2py] Re: how to restart only one app in uwsgi?

On Sun, Feb 5, 2012 at 2:21 PM, Niphlod wrote: > kill -1 `cat /var/run/uwsgi-python/appname/pid` > Thanks! that works! -- Bruno Rocha [http://rochacbruno.com.br]

[web2py] Re: keep shared objects permanently in RAM: Is it possible ?

If so, let me rephrase it...having 16gb of data and have to access all 16 gb at on time is a daunting task. if you have 16gb of data and you work only on a piece of that, let's say, an indexed tree and a client requests just a node, you can try with redis. the problem arises only when you have to p

Re: [web2py] Re: Problem with custom modules

On Mon, Feb 6, 2012 at 8:36 PM, Bruce Wade wrote: > Found the problem: > > from BeautifulSoup import BeautifulStoneSoup > > I was not using my virtualenv to run web2py so instead of reporting the > import error it just prevents the module from loading. I see the good and > bad with this approach

Re: [web2py] Re: Problem with custom modules

OK thanks, I will also look into this because it will make life easier, keep me posted if you find a solution I will do the same. -- Regards, Bruce On Mon, Feb 6, 2012 at 3:20 PM, Bruno Rocha wrote: > > > On Mon, Feb 6, 2012 at 8:36 PM, Bruce Wade wrote: > >> Found the problem: >> >> from Bea

[web2py] Re: SQLForm.factory and Ajax function

You're welcome. Happy to help. I'll take you up on the coffee if you're ever in Richmond, VA. Anthony On Monday, February 6, 2012 4:50:36 PM UTC-5, shartha wrote: > > Thanks DenesL and Anthony so much! > > Anthony, I don't know who you are or what you do, I just wanted to > thank you for all t

Re: [web2py] Re: Problem with custom modules

I noticed when printing the name in _Web2pyImporter.__call__() a lot of modules are being called more then once. Has their been anything done to try and optimize this? For example loading the home page globals is sent to that method over 100 times. On Mon, Feb 6, 2012 at 3:24 PM, Bruce Wade wrot

[web2py] Re: registration_requires_approval & login_after_registration

Never mind. I don't know what was wrong, but python got frozen. After killing all python process and restarting it, it seems to be working perfectly.

[web2py] Re: using radio widget can't receive the empty submit

It seems no luck for me. I got following output when I submit my first form [] response.flash=Form but when comes into the second form, the response.flash is empty. [] response.flash= On Feb 6, 9:37 pm, DenesL wrote: > It works for me. > Try with this view (which does not incl

Re: [web2py] Re: DAL Connection String

Thanks for that. I tried setting it to true, but no luck. >From what I understand from the code though, I wouldn't expect it to - the credential_decoder lambda that gets set up based on that flag isn't used until after the regex tries to split the URI, ie: m = re.compile('^(?P[^:@]+)(\:

[web2py] Bug in smartgrid.

Hi there, Just updated to latest version: 1.99.4 (2012-02-04 10:13:29) stable as of ten minutes ago. The following is now producing an error whenever I try and use the smartgrid like so: def manage_feedback(): grid = SQLFORM.smartgrid(db.feedback) return locals() (I'm running on GAE if th

[web2py] Possible bug when using upload with GAE

Hi there, I've recently upgraded to the latest version of Web2py (1.99.4 (2012-02-04 10:13:29) stable) For some reason when I attempt to upload (or perhaps download) images using GAE launcher (version 1.6.2) the images are being truncated to < 200 bytes. Rather than the full 48k file. db.define_

[web2py] Re: SQLForm.factory and Ajax function

Great responses Anthony and DenesL. I agree with shartha that you 2 should be commended for supporting this group as well as you do. shartha, I have used factory a lot in my work and had settled on using custom forms mostly everywhere in my views. This was a style thing that I gravitated towards a

[web2py] Re: Problem with custom modules

Interesting. the importer was added about 1 year ago and we have not performed any optimization. Do you have other profiler numbers to show us that can give help us improve it? On Feb 6, 6:00 pm, Bruce Wade wrote: > I noticed when printing the name in _Web2pyImporter.__call__() a lot of > modules

[web2py] Re: new web2py application

This is beutiful. Just beutiful On Feb 6, 8:54 pm, leone wrote: > Fine!http://www.globaleaks.org/

[web2py] web2py performance

Hi Just download web2py, run it and go to edit welcome app. in db.py: db.define_table('mytable',Field('myfield','string')) in controllers/default.py: def index(): if request.vars.add_rows: for i in xrange(10): db.mytable.insert(myfield='') rows = db(db.mytable.id>0

Re: [web2py] web2py performance

You are using a for loop with 10 inserts it is the for loop holding you up not web2py. Plus who in their right mind would code something like that in production On Feb 6, 2012 11:24 PM, "LightOfMooN" wrote: > Hi > Just download web2py, run it and go to edit welcome app. > > in db.py: > db.def

[web2py] Re: web2py performance

I'm using loop for 10 inserts just one time to insert 100k records in database. All next time I just try to get response. And now in our project we have much more than 100k records, that can be filtered and sorted by some dinamic conditions. On 7 фев, 12:27, Bruce Wade wrote: > You are using