[web2py] Re: Strange behaviour of URL.verify() / @requires_signature() with big vars

2013-10-03 Thread D.
Thank you for the provided solutions - I'll try them out asap. When storing the list as a session-variable is it protected from user-manipulation as well? Best regards! Am Donnerstag, 3. Oktober 2013 22:57:44 UTC+2 schrieb Massimo Di Pierro: > > You can do but > > def one(): > files = [] >

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Mirko
Done here : https://code.google.com/p/web2py/issues/detail?id=1703 A possible workaround could be to add the following lines somewhere where it is always called (cmd_options.test is None for normal use): if request.global_settings.cmd_options.test: auth.login_bare('userlogin','userpassword')

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
https://code.google.com/p/web2py/issues/detail?id=1702 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribe

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
On Friday, 4 October 2013 13:50:42 UTC+10, Tim Richardson wrote: > > It doesn't seem to me to be a sort order problem. The problem seems to me > to be different: the criteria for evaluating which models to execute can > change while in that loop. If the criteria changes, then all candidate > m

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
It doesn't seem to me to be a sort order problem. The problem seems to me to be different: the criteria for evaluating which models to execute can change while in that loop. If the criteria changes, then all candidate models (all models in other words) should be reevaluated. The loop index shou

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
Yes, I am correct. That's a bit subtle. By making a model folder ZZZ and putting a copy of the requested model in there, it works. Not ideal. Possibly could be a bug, maybe. Or perhaps needs to be better documented. On Fri, Oct 4, 2013 at 1:37 PM, Tim Richardson wrote: > I have response.models_

Re: [web2py] Re: import a model ?

2013-10-03 Thread Anthony
Oh, it looks like the issue regarding sorting of model folderswas never fixed. Massimo, can we change to sort=True in compileapp.py lines 517and 521

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
I have response.models_to_run = ['.*'] at the top of the C1/C1_db model. When I put a breakpoint, it completes the rest of the C1_db model, and arrives at compileapp.py at a loop for model in models: this is the loop where the regex is evaluated. But it doesn't enter the loop. I'm guessing that pe

Re: [web2py] Re: import a model ?

2013-10-03 Thread Anthony
On Thursday, October 3, 2013 11:09:23 PM UTC-4, Anthony wrote: > An alternative would be something like this: > > what_models_to_be_executed = {"C1": ["tab1.py", "tab2.py", "tab3.py"], >> "C2": "tab2.py"} >> response.models_to_run = what_models_to_be_executed[request.controller] >> > > Note, i

Re: [web2py] Re: import a model ?

2013-10-03 Thread Anthony
> > An alternative would be something like this: what_models_to_be_executed = {"C1": ["tab1.py", "tab2.py", "tab3.py"], > "C2": "tab2.py"} > response.models_to_run = what_models_to_be_executed[request.controller] > Note, it must be a list (above, in the case of C2, it would just be a string

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
I put it at the top of the C1 model and I know it is being executed... I'll step through more and see what's happening On 04/10/2013 12:55 pm, "Anthony" wrote: > > Right now I have at the top of C1 >> response.models_to_run['.*'] (just for debugging) but I still get a >> ticket saying that >> >

Re: [web2py] Re: import a model ?

2013-10-03 Thread Vinicius Assef
An alternative would be something like this: what_models_to_be_executed = {"C1": ["tab1.py", "tab2.py", "tab3.py"], "C2": "tab2.py"} response.models_to_run = what_models_to_be_executed[request.controller] On Thu, Oct 3, 2013 at 11:55 PM, Anthony wrote: > >> Right now I have at the top of C1 >> r

Re: [web2py] Re: import a model ?

2013-10-03 Thread Anthony
> Right now I have at the top of C1 > response.models_to_run['.*'] (just for debugging) but I still get a > ticket saying that > Are you saying you put that line at the top of the C1 controller? If so, that's too late -- the controller isn't run until after the models have been executed. Yo

Re: [web2py] Re: import a model ?

2013-10-03 Thread Vinicius Assef
reponse.models_to_run must be updated on models, before controller execution. On Thu, Oct 3, 2013 at 11:41 PM, Tim Richardson wrote: > Thanks. I'm trying that but not getting it to work for me, maybe I have > another problem. > > The problem is a function in controller C1 which refers to a part o

Re: [web2py] Re: import a model ?

2013-10-03 Thread Tim Richardson
Thanks. I'm trying that but not getting it to work for me, maybe I have another problem. The problem is a function in controller C1 which refers to a part of the model for C2. Both controllers have models in models/C1 and models/C2 Right now I have at the top of C1 response.models_to_run['.*'] (

[web2py] Re: import a model ?

2013-10-03 Thread Anthony
You can customize response.models_to_run . Anthony On Thursday, October 3, 2013 9:46:37 PM UTC-4, Tim Richardson wrote: > > If I have a conditional model, that is a model in a folder named after its > controller, how can another c

[web2py] import a model ?

2013-10-03 Thread Tim Richardson
If I have a conditional model, that is a model in a folder named after its controller, how can another controller source that model? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issue

[web2py] Re: DAL: read tagged data with handle?

2013-10-03 Thread Anthony
> def writeTagTest(): > a = db.tag.insert(name='red') > b = db.tag.insert(name='green') > c = db.tag.insert(name='blue') > db.product.insert(name='Test Toy Car',tags=[a, b, c]) > return dict(message="Insert ok", tag=db.tag,product=db.product) > > > def readTagTest(): >

[web2py] Representing Fields in SQLFORM.grid

2013-10-03 Thread pjryan126
I am trying to apply a standard representation to the fields in a SQLFORM.grid object using their field names with the following code: for f in db.things.fields: db.things[f].represent = lambda value, row: DIV(value if value else '-',_class=f, _id=str(row.id)+ '.' + f) but all o

[web2py] Representing Fields in SQLFORM.grid

2013-10-03 Thread pjryan126
I am trying to apply a standard representation to the fields in a SQLFORM.grid object using their field names with the following code: for f in db.timesheet.fields: db.things[f].represent = lambda value, row: DIV(value if value else '-',_class=f, _id=str(row.id)+ '.' + f) but al

[web2py] application for seminar management?

2013-10-03 Thread Stefaan Himpe
Hello list, I'm looking for suggestions for something to manage in-house seminars. Does anything like this exist already? (I can hardly imagine it doesn't...) Can Pynuke or Conf2py be used for something like this? If nothing exists, I might try to make something simple myself. Some requireme

[web2py] Re: onselect ajax...

2013-10-03 Thread Avi A
It alerts the $(this).val() though. On Thursday, October 3, 2013 8:18:15 PM UTC+3, Avi A wrote: > > > Hi, > I'm trying to use the ajax function on a list , with no success so far. > > def echo(): > return request.vars.value > > name="f_item_category"> > > {{for c in category:}} >

[web2py] Google charts plugin added

2013-10-03 Thread Tim Richardson
I added a google charts plugin http://www.web2pyslices.com/slice/show/1721/google-charts-plugin -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You recei

[web2py] Re: onselect ajax...

2013-10-03 Thread Avi A
Thanks. It partially works, it displays "None" instead of the id. On Thursday, October 3, 2013 10:10:02 PM UTC+3, Niphlod wrote: > > I'm not sure that the onselect attribute of an option tag does what you > need (triggering something when a certain option is selected). > Don't use inline javascr

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Anthony
On Thursday, October 3, 2013 4:55:01 PM UTC-4, Massimo Di Pierro wrote: > please open a ticket about this. we need a new request.is_shell option or > something similar to detect this state. > request.global_settings.cmd_options can be used to distinguish other command line executions as well, s

Re: [web2py] network troubles with builtin webserver (Windows)

2013-10-03 Thread Alex
thanks a lot, Ricardo! you're right about HTTP pipeline. Opera is the only browser with (activated) HTTP pipeline. If I deactivate it the site is loaded very fast. The 10 seconds delay is exactly the timeout setting for individual requests. So far I could not get the webserver to deliver all fi

[web2py] Re: Strange behaviour of URL.verify() / @requires_signature() with big vars

2013-10-03 Thread Massimo Di Pierro
You can do but def one(): files = [] for i in range(10): files.append(i) session.files = files redirect(URL("two")) def two(): files = session.files logger.info(True) OR from simplejson import loads, dumps def one(): files = [] for i in range(10):

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Massimo Di Pierro
please open a ticket about this. we need a new request.is_shell option or something similar to detect this state. On Thursday, 3 October 2013 09:52:07 UTC-5, Mirko wrote: > > Eventually I got something working (may be crappy) to put on top of > controller file: > > *if request.global_settings.cm

Re: [web2py] network troubles with builtin webserver (Windows)

2013-10-03 Thread Ricardo Pedroso
On Thu, Oct 3, 2013 at 4:43 PM, Alex wrote: > I'm using the builtin webserver with web2py on Windows. > > When I refresh the page (to reload all files) of a small app in Opera it > takes very long (>10 sec) until the page is completely loaded. When I check > the network log (with Dragonfly) I see

[web2py] Re: passing a alphanumerig id to a SQLFORM.grid getting error

2013-10-03 Thread Ari Lion BR Sp
Hi Niphold, thanks for the answer..! So do you have any way to work with that? Surely, at my database I dont have any blank spaces at primary keys. I was thinkin on integrating some ERPs thru web2py and those ERPs use Alphanumeric (surely, without blank spaces) as primary keys. I thik it would be

[web2py] DAL: read tagged data with handle?

2013-10-03 Thread Py Dev
Hi, here is some code, that should write and read some tags, it is a slightly different version as the code in the book (5th Edition) on page 316: The write test works, but I do not get the handle to read it back. What is wrong with this code, marked in read? Thanks for your help! Cheers! pd

[web2py] Re: Change SQLFORM.grid Submit button label

2013-10-03 Thread Paolo Caruccio
if grid.create_form or grid.update_form: o = grid.element(_type='submit', _value='%s' % T('Submit')) o['_value'] = T("Compare Selected") Il giorno giovedì 3 ottobre 2013 19:38:23 UTC+2, P T ha scritto: > > Thanks Massimo, but that didn't work. I resorted to using the followin

[web2py] Re: Legacy Table - Keyed Table / String primary Key

2013-10-03 Thread Ari Lion BR Sp
In Time: I'm working with MySQL. Em quinta-feira, 3 de outubro de 2013 14h40min37s UTC-3, Ari Lion BR Sp escreveu: > > Hi, > > I have a Legacy table with string primary key. > seems to bel web2py is not able to handle only the records containing > alphanumeric charachters . For those containing

[web2py] Re: passing a alphanumerig id to a SQLFORM.grid getting error

2013-10-03 Thread Niphlod
AFAIK the grid doesn't support non-integer primary keys. All the ids are passed around as arguments to have clean urls and dealing with those arguments as strings is a big issue (imagine /default/index/edit/tablename/*abc defg ... *it's not even a valid argument ^_^) On Thursday, October 3, 201

[web2py] Re: Legacy Table - Keyed Table / String primary Key

2013-10-03 Thread Ari Lion BR Sp
I built a *grid *for listing records for this table (in this case, Products table) and all work well, it means, *on clickin on button* of *SQLFORM.grid* for edditing , as below [image: Imagem inline 1] all works well [image: Imagem inline 2] including master / details that we set (ie, the

[web2py] Re: Absolute URL from field in grid

2013-10-03 Thread Niphlod
uhm: seems that you didn't quite get how lambda works. lambda row : something(row) equals to def something(row): return 'a' lambda is used just to "inline" a small snippet of code. In your case, you need to generate the link from the field pdf_path, but you need to take the pdf_pat

[web2py] Re: network troubles with builtin webserver (Windows)

2013-10-03 Thread Niphlod
I use rocket on windows and don't incur in any noticeable problem. Of course its slower on Windows than Linux (as expected) but never had an issue of a corrupt file ... what error do you get exactly ? On Thursday, October 3, 2013 5:43:27 PM UTC+2, Alex wrote: > > I'm using the builtin webserver

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

2013-10-03 Thread Niphlod
whoops, linked the slightly wrong page :) http://www.connectionstrings.com/sql-server-native-client-11-0-odbc-driver/ On Thursday, October 3, 2013 6:39:19 PM UTC+2, Josh Myers wrote: > > Thank you, everyone. The problem of how to sign in with windows > authorization was solved for me when I use

[web2py] Re: onselect ajax...

2013-10-03 Thread Niphlod
I'm not sure that the onselect attribute of an option tag does what you need (triggering something when a certain option is selected). Don't use inline javascript when there are far more readable and concise alternatives $('#t_items_f_item_category').change(function() { ajax('echo', [$(thi

[web2py] Re: Legacy Table - Keyed Table / String primary Key

2013-10-03 Thread Niphlod
this happens when you try to do what exactly ? On Thursday, October 3, 2013 7:40:37 PM UTC+2, Ari Lion BR Sp wrote: > > Hi, > > I have a Legacy table with string primary key. > seems to bel web2py is not able to handle only the records containing > alphanumeric charachters . For those containing

[web2py] passing a alphanumerig id to a SQLFORM.grid getting error

2013-10-03 Thread Ari Lion BR Sp
Hi to All, I need to work with legacy table, even knowing it's not so recomended. One of my tables has a String for primarykey. I have built a SQLFORM.grid When editing *only numbers* record code (key) - all works fine. [image: Imagem inline 1] all works fine [image: Imagem inline 2]

[web2py] Legacy Table - Keyed Table / String primary Key

2013-10-03 Thread Ari Lion BR Sp
Hi, I have a Legacy table with string primary key. seems to bel web2py is not able to handle only the records containing alphanumeric charachters . For those containing only numbers I get no problem. For the alphanumeric (for exmple '222Y9800') I get back the following Tichket. list index o

[web2py] Re: Web2py admin crashes

2013-10-03 Thread Dave S
On Thursday, October 3, 2013 10:51:37 AM UTC-7, Dave S scribbled: > > > On Thursday, October 3, 2013 8:28:52 AM UTC-7, Joe Magaro wrote: >> >> Hi, >> >> All was working well, until today I went and clicked "administrative >> interface" for my site, and it issues a ticket. >> >> Internal errorTick

[web2py] Re: Web2py admin crashes

2013-10-03 Thread Dave S
On Thursday, October 3, 2013 8:28:52 AM UTC-7, Joe Magaro wrote: > > Hi, > > All was working well, until today I went and clicked "administrative > interface" for my site, and it issues a ticket. > > Internal errorTicket issued: > admin/65.94.212.187.2013-10-03.19-26-12.8b8b3b98-0858-4925-a517-

[web2py] Re: Change SQLFORM.grid Submit button label

2013-10-03 Thread P T
Thanks Massimo, but that didn't work. I resorted to using the following jQuery in the view: $('input[type="submit"][value="Submit"]').attr('value', 'Compare Selected' );; May be there is an equivalent expression in Web2Py. Thanks, PT On Thursday, October 3, 2013 8:19:57 AM UTC-5, Massimo

[web2py] onselect ajax...

2013-10-03 Thread Avi A
Hi, I'm trying to use the ajax function on a list , with no success so far. def echo(): return request.vars.value {{for c in category:}} {{=c.f_category_name}} {{pass}} Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

[web2py] Re: .ics file name

2013-10-03 Thread Paolo Caruccio
maybe not related to your issue but anyway interesting to read http://greenbytes.de/tech/tc2231/#inlwithasciifilenamepdf http://greenbytes.de/tech/webdav/rfc6266.html Il giorno lunedì 30 settembre 2013 09:45:47 UTC+2, Annet ha scritto: > > In my application I include the name of an organization

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

2013-10-03 Thread Josh Myers
Thank you, everyone. The problem of how to sign in with windows authorization was solved for me when I used the following connection string in SQL Server 2005: db = DAL('mssql://DRIVER={SQL Server};SERVER:ServerName;DATABASE=DatabaseName;TRUSTED_CONNECTION=YES;') For some reason it needed t

[web2py] network troubles with builtin webserver (Windows)

2013-10-03 Thread Alex
I'm using the builtin webserver with web2py on Windows. When I refresh the page (to reload all files) of a small app in Opera it takes very long (>10 sec) until the page is completely loaded. When I check the network log (with Dragonfly) I see that usually the first 10-20 files (css, js, images

[web2py] Absolute URL from field in grid

2013-10-03 Thread Gael Princivalle
Hi. In a table I have that: db.define_table('products', Field('code', unique=True), Field('description'), Field('brand'), Field('pdf_path')) I want to have a sqlform.grid that gone have all links to pdf_path field. These are absolute links like "http://www.exa

[web2py] Web2py admin crashes

2013-10-03 Thread Joe Magaro
Hi, All was working well, until today I went and clicked "administrative interface" for my site, and it issues a ticket. Internal errorTicket issued: admin/65.94.212.187.2013-10-03.19-26-12.8b8b3b98-0858-4925-a517-59ebed5f1ad1

[web2py] Re: Strange behaviour of URL.verify() / @requires_signature() with big vars

2013-10-03 Thread D.
It does not really matter what's in the list: Even a simple list like this leads to a 403-error: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] How would I store and retrieve a long list in a session? Thank you so much for your help! Am Donnerstag, 3. Oktober 2013 15:22:04 UTC+2 schrieb Massimo Di Pierro:

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Mirko
Eventually I got something working (may be crappy) to put on top of controller file: *if request.global_settings.cmd_options.test.startswith('%s/%s' % (request.application,request.controller)): auth.login_bare('user_for_test','his/her password') * Mirko On Thursday, October 3, 2013 3:58:31

[web2py] Re: Union of tables displayed in SQLFORM.grid

2013-10-03 Thread Niphlod
you can reassemble the smaller ones in a view, define that view as migrate=False and query that with web2py. There's no support for UNION in web2py. On Thursday, October 3, 2013 3:10:22 PM UTC+2, TYRANISTAR wrote: > > Hello everyone, > > I have a big mysql table that I want to break into smaller

[web2py] Re: how to build windows binary?

2013-10-03 Thread Niphlod
all files gets correctly imported and compiled even if it's commented with latest py2exe On Thursday, October 3, 2013 11:52:44 AM UTC+2, step wrote: > > Thanks Niphlod. By the way, when I build web2py.exe should I > uncomment line 17 of web2py.py or should I leave it commented out as it > is? >

[web2py] Re: Expression' object has no attribute

2013-10-03 Thread Anthony
db.static_text.id is a field object. If you want a record, you would do: db.static_text(1) or db(db.static_text.id == 1).select().first() Anthony On Thursday, October 3, 2013 10:09:54 AM UTC-4, Gael Princivalle wrote: > > Hi. > > I want to show different fields in my applications, depending of

[web2py] Expression' object has no attribute

2013-10-03 Thread Gael Princivalle
Hi. I want to show different fields in my applications, depending of the current language (italian or english). Here is my table with static text like company presentation... db.define_table('static_text', Field('title_en'), Field('title_it'), Field('text_en', type='text

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Mirko
Hi Massimo, thank you very much for helping! However it looks like request.function contains '_TEST' only when doctest is run from the web IDE, and contains function name when run from command line.. On Thursday, October 3, 2013 3:25:24 PM UTC+2, Massimo Di Pierro wrote: > > You need to add some

Re: [web2py] Multiple domains accessing all apps through URL

2013-10-03 Thread Jonathan Lundell
On 3 Oct 2013, at 5:36 AM, Anthony wrote: > On Thursday, October 3, 2013 12:36:34 AM UTC-4, Jonathan Lundell wrote: > On 2 Oct 2013, at 10:36 PM, Anthony wrote: >> A couple years ago, Jonathan seemed to think this behavior was a bug and >> alluded to a fix in trunk: >> https://groups.google.com

[web2py] Union of tables displayed in SQLFORM.grid

2013-10-03 Thread TYRANISTAR
Hello everyone, I have a big mysql table that I want to break into smaller ones in order to retrieve its results quicker via a web2py interface. Question is is there a way to call a union of the smalleer tables via SQLFORM.grid (giving the number and names of tables as arguments) and if not is

Re: [web2py] .ics file name

2013-10-03 Thread Richard Vézina
You can test your ical file here : http://severinghaus.org/projects/icv/ To help troobleshoot... Richard On Thu, Oct 3, 2013 at 9:35 AM, Richard Vézina wrote: > Ho! You are generating the file? I thought you were parsing a file... So > maybe you need .encode('someencoding') > > I am not sure b

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Massimo Di Pierro
You need to add some logic that says: if request.function = '_TEST': auth.login_bare('user_for_test','his/her password') On Thursday, 3 October 2013 07:02:09 UTC-5, Mirko wrote: > > Hi all, > > I confirm "*python web2py.py -T a/b/c"* is not working with 2.5.1 when > function c is decorated

Re: [web2py] .ics file name

2013-10-03 Thread Richard Vézina
Ho! You are generating the file? I thought you were parsing a file... So maybe you need .encode('someencoding') I am not sure but I think web2py will return ascii since python default encoding is ascii (http://docs.python.org/2/howto/unicode.html) So something like that : row.variable.encoding('

Re: [web2py] Re: Master / Detail with field value in the detail and overall value in the master

2013-10-03 Thread 黄祥
yes, can, sqlform.grid have ondelete too. e.g. def __oncreate_function(form): your function/query here def __onupdate_function(form): your function/query here def __ondelete_function(table_involved, id_of_the_deleted_record): your function/query here def grid_function(): grid = SQLFORM.grid(db.

[web2py] Re: Strange behaviour of URL.verify() / @requires_signature() with big vars

2013-10-03 Thread Massimo Di Pierro
What's into files? How long are the strings? There are limits to how long the query string can be. I thing the files should be saved in a session and retrieved by the target page On Thursday, 3 October 2013 01:52:47 UTC-5, D. wrote: > > I'm still struggeling with this problem - does anyone have

[web2py] Re: Change SQLFORM.grid Submit button label

2013-10-03 Thread Massimo Di Pierro
if grid.create_form or grid.update_form: grid.element(_type='submit')[ '_value'] = T("something") On Wednesday, 2 October 2013 23:15:07 UTC-5, P T wrote: > > Hello All, > > > I want change the label of Submit button in the SQLFORm.grid. I found two > solutions in the forum and both seems to be no

RES: [web2py] Re: Master / Detail with field value in the detail and overall value in the master

2013-10-03 Thread Meir
Thank you! I will test now! But in the case of JavaScript that calls a delete, event exists to delete? For this case must deduct the value in the header ... De: web2py@googlegroups.com [mailto:web2py@googlegroups.com] Em nome de ?? Enviada em: quinta-feira, 3 de outubro de 2013 10:09 Para: we

[web2py] Re: User Login causes error on GAE

2013-10-03 Thread Massimo Di Pierro
Something is resetting auth.settings.table_user. Do you have that your code. Do you use lazy tables? On Wednesday, 2 October 2013 23:06:09 UTC-5, Andy W wrote: > > Version 2.6.4 > Upgrade seemed to go OK. Soon after the upgrade I added > auth.settings.extra_fields in db.py to add an extra field

[web2py] Re: Master / Detail with field value in the detail and overall value in the master

2013-10-03 Thread 黄祥
did you mean header detail? i think you can do it with oncreate (function run on create event) and onupdate (function run on update event). first create oncreate and onupdate function after then call it from your grid function. e.g. def __oncreate_function(form): your function/query here def _

[web2py] Master / Detail with field value in the detail and overall value in the master

2013-10-03 Thread Meir
Hello community, all right? I resolve an impasse ... I have a screen with Master / Detail. Detail is in the SQLFORM.grid and I would like to update or insert a record in the detail he added up the total value of a field that is in the Master. What better way for this? Remembering: The D

[web2py] On moving incremental changes to production

2013-10-03 Thread Jayadevan M
I have deployed version 1 of an application in production. Let us say we used the admin console and created a project (.w2p) file and that was how we deployed it. Which is the best way to roll out the next release? If we use the same approach, it will also move to prod the files under databases

Re: [web2py] "Not indexable" error when disabling app from admin

2013-10-03 Thread Marin Pranjić
I think this is fixed in trunk. Marin On Thu, Oct 3, 2013 at 2:36 PM, keiser1080 wrote: > Hi, > > "Not indexable" error when disabling app from admin. > My setup: > > 2.6.4-stable+timestamp.2013.09.22.01.43.37 > (Running on nginx/1.1.19, Python 2.7.3) in a virtual env > > > On other virtual en

[web2py] "Not indexable" error when disabling app from admin

2013-10-03 Thread keiser1080
Hi, "Not indexable" error when disabling app from admin. My setup: 2.6.4-stable+timestamp.2013.09.22.01.43.37 (Running on nginx/1.1.19, Python 2.7.3) in a virtual env On other virtual environment that work under 2.5.1-stable+timestamp.2013.06.06.15.39.19 (Running on nginx/1.1.19) --

[web2py] Re: displaying associated information

2013-10-03 Thread Mihir Lade
my understanding behind how it should work is.. "when the products button is hit, it should grab the auth_id and pass it to some function, maybe something like "getProducts()" which then queries the products database and only returns the results which are associated with the auth_id" could be

[web2py] Re: Issue running doctest with decorated functions

2013-10-03 Thread Mirko
Hi all, I confirm "*python web2py.py -T a/b/c"* is not working with 2.5.1 when function c is decorated with *@auth.requires_login()* It works fine without that decoration and I don't know how to authenticate when running doctests from command line, any suggestions ? Many thanks! Mirko On Fri

[web2py] displaying associated information

2013-10-03 Thread Mihir Lade
hi guys, i am working on a part of a project where i need to display data associated with each author.. the author's page currently looks like: http://webeng.gwillz.com/suzannecollins/default/authors which is generated using the code: {{extend 'layout.html'}} Authors {{for Author in Autho

Re: [web2py] Re: Multiple domains accessing all apps through URL

2013-10-03 Thread Anthony
On Thursday, October 3, 2013 12:36:34 AM UTC-4, Jonathan Lundell wrote: > On 2 Oct 2013, at 10:36 PM, Anthony > > wrote: > > A couple years ago, Jonathan seemed to think this behavior was a bug and > alluded to a fix in trunk: > https://groups.google.com/d/msg/web2py/elnV_6Ntw3E/KWNlpoJfpWAJ. >

[web2py] Re: HA/Cluster Feature Request?

2013-10-03 Thread Anthony
Database sessions are also discussed in the main book section on sessions, along with the cookie based session option (which can also be helpful for high availability). Anthony On Thursday, October 3, 2013 4:55:24 AM UTC-4, Niphlo

[web2py] Re: how to build windows binary?

2013-10-03 Thread step
Thanks Niphlod. By the way, when I build web2py.exe should I uncomment line 17 of web2py.py or should I leave it commented out as it is? On Tuesday, October 1, 2013 8:43:52 PM UTC+2, Niphlod wrote: > > it's because of a bug in widget.py. Sending a PR and notifying @massimo > right now. > > On T

[web2py] Re: CREATE DATABASE cannot run inside a transaction block

2013-10-03 Thread at
thank you richard! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-use

[web2py] Re: Is is possible to create a postgres database from web2py application?

2013-10-03 Thread at
Thanks all for replies and assistance; I've now a better understading of DAL's scope and limitations. Regards, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Is

[web2py] Re: HA/Cluster Feature Request?

2013-10-03 Thread Niphlod
why doesn't anyone search the book before asking ??? :-P http://web2py.com/books/default/chapter/29/13/deployment-recipes#Efficiency-and-scalability Il giorno mercoledì 2 ottobre 2013 15:45:21 UTC+2, damona ha scritto: > > Any thoughts on this for clustering and High Availability? > > Could a fea

[web2py] Re: PATCH(?) DAL with MSSQL and windows authentication

2013-10-03 Thread Niphlod
Il giorno giovedì 3 ottobre 2013 01:20:40 UTC+2, Josh Myers ha scritto: > > I'm not a database expert. > > Aren't both of those connection strings equivalent in the DAL? Why are > you saying they are different? I will try it in the other format, the > non-@ format. > > ehm. mssql://Provider

[web2py] Re: Scheduler question

2013-10-03 Thread Niphlod
Il giorno giovedì 3 ottobre 2013 08:19:48 UTC+2, Andrew W ha scritto: > > Hi Niphlod, > If I could add to the questions (I'm having some success with the > scheduler but there's a few gaps in my understanding): > What process removes the rows from the scheduler_worker table ? > Does it make an

[web2py] logging controller output for specific session

2013-10-03 Thread Geo
Greetings, I have a controller that generates many log messages. Most of them are currently used for debugging but some (warnings and errors) are also useful for users. Logs are currently handled with a module similar to this: http://www.web2pyslices.com/slice/show/1416/logging I have tried att