Re: [web2py] Web2py on Koding.com

2014-03-14 Thread 黄祥
please take a look at : http://www.web2pyslices.com/slice/show/1956/install-web2py-on-kodingcom what is still outstanding is about the admin page still can not reach it said : admin disabled because unable to access password file perhaps experts in here, have the solution for that already tested

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 9:13 PM, Mariano Reingart wrote: > Is web2py bytecode compiled? > .pyo or .pyc appears in gluon folder? > Maybe in tour production server there is some permission/date issue and .pyc > files cannot be saved, so they are compiled on each run (that takes time). > But the compil

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Mariano Reingart
Is web2py bytecode compiled? .pyo or .pyc appears in gluon folder? Maybe in tour production server there is some permission/date issue and .pyc files cannot be saved, so they are compiled on each run (that takes time). Just and idea Best regards, Mariano Reingart http://www.sistemasagiles.com.

[web2py] Re: SmartGrid Add make a Fld Readonly

2014-03-14 Thread 黄祥
i think you can achieve it using conditional for that. e.g. write_in_form = 'add' in request.args or 'edit' in request.args db.clients.writeable = not write_in_form best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] database callback return an error when using bulk_insert

2014-03-14 Thread 黄祥
hi, i have a database callback when using bulk_insert it return an error : db(db.product.id == f.product).update(quantity = db.product(f.product).quantity + f.quantity) AttributeError: 'list' object has no attribute 'product' here is the code that produce error above: *# error traceback* *mode

[web2py] SmartGrid Add make a Fld Readonly

2014-03-14 Thread Dan Kozlowski
Can someone tell me how within a smartgrids I can make a Fld readonly on the add and update ? I have tried the following in the controller and it does not work. db.clients.writeable=False -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
Astonishingly, I've discovered something else... When I ran the test in my newly-created VM, I only ran it once. Later, I noticed I wasn't getting the 30x ratio anymore; I was only getting 2x, like Niphlod did. Luckily, I had taken a snapshot of the VM before running the test, so I reverted ba

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
I don't understand logging. How do I examine the log? Where is it?? On Friday, 14 March 2014 18:29:15 UTC-4, Michele Comitini wrote: > > Can you try with the following? > > note: no DAL, no sessions > > 2014-03-14 22:23 GMT+01:00 Niphlod >: > > > > On Friday, March 14, 2014 10:17:40 PM UTC+1,

[web2py] Re: Bootstrap3 package - help to test

2014-03-14 Thread LightDot
Are you looking for ways to set the required css class for the table itself or anything more? For example, you can manipulate the DOM for the table class. It's not a perfect approach, but should do for the time being: grid = SQLFORM.grid (...code...) grid.element('table', replace=lambda el: el.

[web2py] Re: Understanding translation and accept-language header?

2014-03-14 Thread LightDot
I'm less familiar with the translation parts of web2py that I'd like to be, but is this connected with the definitions of: '!langcode!': 'en-us', '!langname!': 'English (US)', that can be found in languages/default.py? Regards On Friday, March 14, 2014 8:39:21 PM UTC+1, User wrote: > > I'd re

[web2py] Re: Bootstrap3 package - help to test

2014-03-14 Thread Brando
Paolo, I got everything moved over. So far no problems. I'm trying to figure out the best way to style a SQLFORM.grid without using custom js. What is the easiest way to style the SQLFORM.grid with bootstrap3? On Thursday, March 13, 2014 8:59:07 AM UTC-7, Brando wrote: > > Just found this

Re: [web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Dewes
Maybe in apache2, on default config you have this line: AliasMatch ^/([^/]+)/static/(.*) /var/www/web2py/applications/$1/static/$2 Change it to: AliasMatch ^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*) /var/www/web2py/applications/$1/static/$2 At least that solved my pro

[web2py] Re: Help with SQL Query without using executesql preferably :)

2014-03-14 Thread brahama von
Thanks Cliff. But i don´t think it is that simple, or perhaps it is, but i can't manage to build the right query. If i use group by, it groups by the id and the having=max is ignored. all ids appear. Probably it needs joins. Will try to do the raw query and see if anyone can translate it. Thanks

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Niphlod
On Friday, March 14, 2014 10:17:40 PM UTC+1, Jonathan Lundell wrote: > > On 14 Mar 2014, at 2:16 PM, Jonathan Lundell > > wrote: > > Setting aside that your 2x is a lot better than HH's, what's been > bothering me (assuming the effect is real) is: what could possibly be the > mechanism? > > I'

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 2:16 PM, Jonathan Lundell wrote: > On 14 Mar 2014, at 2:03 PM, Niphlod wrote: >> So seems that web2py shell and python script behaves exactly the same >> (if web2py was introducing complexity it should show right there). >> The same environment executed by rocket or uwsgi

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 2:03 PM, Niphlod wrote: > So seems that web2py shell and python script behaves exactly the same (if > web2py was introducing complexity it should show right there). > The same environment executed by rocket or uwsgi gets some gap (roughly 2x > time). > uwsgi behaves a litt

[web2py] Re: Pulling data from API for real-time calculation

2014-03-14 Thread Niphlod
if you do "real-time" calculations while the user presses buttons, it's supposed to return under 300ms. Online book states that part in environments where you do calculations in the background that takes more than 300ms (i.e. not real time). "usual" webserver timeout is set to 30-60 seconds. O

Re: [web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Niphlod
me neither but it may be related to static_version. A simple screenshot from firebug or chrome developers tools will tell us. On Friday, March 14, 2014 5:43:41 PM UTC+1, Massimo Di Pierro wrote: > > Sorry I do not understand. > > -- Resources: - http://web2py.com - http://web2py.com/book (Docum

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Niphlod
Well well, it was some time that someone didn't start a "web2py is slow(er) thread". let's start clearing some field ubuntu 12.10 64 bit, python 2.7.3. Original script: # -*- coding: utf-8 -*- import time def test(): start = time.time() x = 0.0 for i in range(1,5):

Re: [web2py] Re: Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread Francisco Costa
Thanks for the feedback Massimo, I'm only focus on the Portuguese version for now, but soon I'll official launch the EN version Francisco Costa http://franciscocosta.com On Fri, Mar 14, 2014 at 4:30 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I would make the BUY button bigger

[web2py] Re: Understanding translation and accept-language header?

2014-03-14 Thread User
I'd really like to understand this. If I set the current language to 'en', why does en-gb get translated but en-us does not get translated? On Sunday, March 9, 2014 10:31:57 PM UTC-4, User wrote: > > So why do en-us and en-gb behave differently? That is, why is en-gb > translated and en-us not

[web2py] Re: web2py on Mac OS Mavericks, trying to use port 80

2014-03-14 Thread Dave S
On Friday, March 14, 2014 9:51:55 AM UTC-7, LightDot wrote: > > Hello Manuel, welcome to the list. > > The issue you're seeing is not a bug, it's a feature of the OS or, rather, > of it's security settings. The same behavior can be observed on Linux, > FreeBSD, Solaris, ... any UN*X OS basicall

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
Okay, I have some excellent news to report. Well, excellent for me, not so much for you guys... I can reproduce the problem on another system. Here's what I did: My Mac has Parallels installed. I created a new VM, downloaded Ubuntu Server 12.04, and installed it. Then I updated it with the late

[web2py] Re: Verbatim Tag

2014-03-14 Thread David Simmons
> > Hi Leonel > I think you are correct in that it might make it a little more difficult to parse. My problem with having to change either of the delimiters for Angular or Web2py is that I have to remember to change them for everything. For example if I change the web2py delimiters I then have

Re: [web2py] Web2py on Koding.com

2014-03-14 Thread Richard Vézina
Showing the callback code would help. Richard On Fri, Mar 14, 2014 at 2:50 PM, wuelfhis asuaje wrote: > I've just deployed my app there with latest meb2py source > > Configured apache, everythig looks fine, except when i try to get ajax > links created like (A(IMG(..)..calback(myfunction())) >

[web2py] Web2py on Koding.com

2014-03-14 Thread wuelfhis asuaje
I've just deployed my app there with latest meb2py source Configured apache, everythig looks fine, except when i try to get ajax links created like (A(IMG(..)..calback(myfunction())) The links point to something like /myapp/controler/function but in my machine point to something like /myapp/#n

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 11:28 AM, horridohobbyist wrote: > First, I don't know how to use the profiler. > > Second, for something as trivially simple as the Welcome app with the > calculation loop, what is the profiler going to tell us? That simple > multiplication and division are too slow? That th

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
First, I don't know how to use the profiler. Second, for something as trivially simple as the Welcome app with the calculation loop, what is the profiler going to tell us? That simple multiplication and division are too slow? That the for loop is somehow broken? Should I try to profile the ent

[web2py] Re: Verbatim Tag

2014-03-14 Thread Leonel Câmara
David, I don't like that idea as I think it makes the views harder to parse. I need to remember that I'm inside a verbatim block to know if I'm reading python or not. I don't like the extra mental strain so I prefer the changing the delimiters strategy as I have a reminder of what I'm reading i

[web2py] Plus Sign in URL Args

2014-03-14 Thread EW
Hi, I'm having trouble with a url containing a plus sign in the args. When I go to that url, the plus sign has been converted to an underscore. Even printing raw_args in the controller shows the underscore. When I hover over the link to the url in question, the "+" has been replaced with "%2B

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Michele Comitini
Please try to profile as suggested we need more info. 2014-03-14 18:18 GMT+01:00 horridohobbyist : > I originally installed web2py according to the Book. This was several years > ago. > > I recently upgraded to the latest version, but I had to do it manually, as > the administrative interface had

[web2py] Re: Verbatim Tag

2014-03-14 Thread David Simmons
Hi Massimo I appreciate you can change either Web2py or Angular delimiters but the small code change I have suggested allows you to have the best of both worlds. If you change one of the delimiters it means you need to be careful with anything that might rely on it. Is there any reason why we

[web2py] Re: Verbatim Tag

2014-03-14 Thread David Simmons
LightDot The implementation I put together was only done last night and I have done limited testing. I did it as I feel Web2py and Angular make a fantastic combination and want to explore the two working together more. I'm really keen to understand from Massimo and other Web2py guru's if my id

[web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
I originally installed web2py according to the Book. This was several years ago. I recently upgraded to the latest version, but I had to do it manually, as the administrative interface had all kinds of permission problems with the upgrade. I have a Dell server box, 2.4GHz quad-core Xeon with 4

[web2py] Re: Python Performance Issue

2014-03-14 Thread Anthony
Oops, sorry. On Friday, March 14, 2014 11:38:34 AM UTC-4, horridohobbyist wrote: > > The computed time interval brackets the calculations. I don't see how that > would be affected by HTTP processing. > > Anyway, just replacing the calculations with a string return gives: > > elapsed time: 2.09808

[web2py] Re: Custom fill with SQLFORM not saving. Web2py version 2.8.2

2014-03-14 Thread Martin
it worked! thank you Le jeudi 13 mars 2014 21:00:24 UTC+2, Martin a écrit : > > Hi all, > > >...if FORM.accepts(form,request.vars): .. > not working for custom form, please may i know if i'am missing something... > Thanks! > > def page1(): >form=SQLFORM(db.a_table) >if FORM.accepts(f

[web2py] Re: Accepting custom form without saving

2014-03-14 Thread Martin
Thank you Massimo, you reply was helpful. Le jeudi 13 mars 2014 21:28:03 UTC+2, Martin a écrit : > > Hi all, > Please could anyone tell me how to accept a *custom SQLFORM* without > inserting to db, since > > if form.process().accepted: seems to be perform insertion directly. > > thanks! > > --

[web2py] Re: web2py on Mac OS Mavericks, trying to use port 80

2014-03-14 Thread LightDot
Hello Manuel, welcome to the list. The issue you're seeing is not a bug, it's a feature of the OS or, rather, of it's security settings. The same behavior can be observed on Linux, FreeBSD, Solaris, ... any UN*X OS basically: non root users can't bind to ports below 1024. This limit can be cha

[web2py] Pulling data from API for real-time calculation

2014-03-14 Thread Martin
Hi all, Please could anyone help me out, I need to pull some data from some API (ex: https//xxx/aaa/ etc.) that returns json data type. I will take input from logged-in users (onkeyup event) with the API retured json to perform some real-time calculation and then display the result to the logg

[web2py] Re: Python Performance Issue

2014-03-14 Thread Massimo Di Pierro
Can anybody else reproduce this? If so, let's try find out what OS/versions/hardware you have in common. On Friday, 14 March 2014 11:18:28 UTC-5, Leonel Câmara wrote: > > > must be computed before debug() gets called, so no problem there either. > > Yes Jonathan but debug, or anything else, didn'

[web2py] Re: Verbatim Tag

2014-03-14 Thread Massimo Di Pierro
That's not how we do it. You either tell web2py to use different delimiters: response.delimiters = ('<%', '%>') or you tell angular to do so: var myApp = angular.module('myApp', [], function($interpolateProvider) { $interpolateProvider.startSymbol('[['); $interpolateProvider.endSymbol(']

Re: [web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Massimo Di Pierro
Sorry I do not understand. On Friday, 14 March 2014 11:30:04 UTC-5, Ovidio Marinho wrote: > > Massimo has a problem when we use the script, web2py not posing on > localhost port. > > > > > Ovidio Marinho Falcao Neto > ITJP.NET.BR >

[web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
If I take out the calculations and just put x = 0.0, making this essentially an empty loop, I get 0.096 second, which is awfully high for a do-nothing loop. If I remove everything between start = time.time() and debug(), I get 0.1 second. So 0.1 second is the granularity of my measureme

Re: [web2py] web2py on Mac OS Mavericks, trying to use port 80

2014-03-14 Thread Jonathan Lundell
On 13 Mar 2014, at 11:34 PM, audion...@gmail.com wrote: > It seems this is related to Mac OS policy to keep use of some ports for it's > own usage. > My question is wether this is a bug or an enhancement request to have an > error message in the graphical web2py launch app to inform user ? > (Whe

Re: [web2py] Re: Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread Massimo Di Pierro
I would make the BUY button bigger and call is "Products". It was not obvious to me I could browse the products without committing to anything. ;-) On Friday, 14 March 2014 11:21:39 UTC-5, Francisco Costa wrote: > > No, you can browse the marketplace without login > https://chique.pt/buy?lang=e

[web2py] Re: web2py on Mac OS Mavericks, trying to use port 80

2014-03-14 Thread Annet
Hi Manuel, The issue is not limited to Mac OS Mavericks, I ran into the same issue on Mac OS Lion Server and Mountain Lion Server. For that reason I leave Web2py's Server Port setting to the default 8000 instead of setting it to 80. Kind regards, Annet -- Resources: - http://web2py.com - http

[web2py] Re: Verbatim Tag

2014-03-14 Thread LightDot
Hi Massmo, On Friday, March 14, 2014 2:46:58 PM UTC+1, Massimo Di Pierro wrote: > > {{data.message + " world!"}} > > should be > > {{= data.message + " world!"}} > No... this part is fictional AngularJS code, just meant as an example. I think you're missing the point of this thread, and that is

[web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Massimo Di Pierro
Can you open the page with chrome? In the javascript console (under network activity) it will tell you which files return a 404 error (if any). Then you can check if the files are there or not. On Friday, 14 March 2014 11:06:09 UTC-5, SimonD wrote: > > Thanks, > The vhost configs (I assuming tha

Re: [web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Ovidio Marinho
Massimo has a problem when we use the script, web2py not posing on localhost port. Ovidio Marinho Falcao Neto ITJP.NET.BR ovidio...@gmail.com itjp.net...@gmail.com Brasil 2014-03-14 11:27 GMT-03:00 Massimo Di Pierr

[web2py] Re: Python Performance Issue

2014-03-14 Thread Massimo Di Pierro
Just adding one datapoint. I am trying this with my mac. In both cases I see 0.002xx seconds. Therefore I cannot reproduce the discrepancy. Are you using web2py from source? What kind of machine do you have? Massimo On Friday, 14 March 2014 08:28:48 UTC-5, horridohobbyist wrote: > > I conducted

[web2py] Re: Python Performance Issue

2014-03-14 Thread Leonel Câmara
> must be computed before debug() gets called, so no problem there either. Yes Jonathan but debug, or anything else, didn't need the result of the x computation. So it was possible, I don't know the internals of cpython that well, the loop was optimized away in the command line version. I a

Re: [web2py] Re: Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread Francisco Costa
No, you can browse the marketplace without login https://chique.pt/buy?lang=en Francisco Costa http://franciscocosta.com On Fri, Mar 14, 2014 at 4:17 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Do I need to login? Is there more information one can see without login. > Looks nic

[web2py] Re: Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread Massimo Di Pierro
Do I need to login? Is there more information one can see without login. Looks nice. On Friday, 14 March 2014 08:54:24 UTC-5, Francisco Costa wrote: > > Hi there, > > Just wanted to get some feedback form the web2py community about this new > project: > > *CHIQUE* is

[web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread SimonD
Thanks, The vhost configs (I assuming that we are talking about sites-available/default ?), is as per the setup script as kindly included in web2py. It is unchanged apart from the installation directory (i.e. other than www-data). I have changed all references of www-data to a new directory nam

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 8:59 AM, horridohobbyist wrote: > I disagree. I'm getting very consistent results with time.time(). Right, I see no problem with the experiment. And the arguments to debug() must be computed before debug() gets called, so no problem there either. > > With a print statement,

[web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
I disagree. I'm getting very consistent results with time.time(). With a print statement, Welcome yields 0.587778091431 second, while the command line execution gives 0.0202300548553 second. Again, that's 29 times faster. On Friday, 14 March 2014 11:51:04 UTC-4, Leonel Câmara wrote: > > Time i

[web2py] Re: Python Performance Issue

2014-03-14 Thread Leonel Câmara
Time is still a bad way to measure as the web2py version process may be getting preempted and not getting as much CPU time. Althoug,h I would agree there seems to be something odd going on here. Possibly dead code elimination. What happens with the time if you add a "print x" after the "for" to

[web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
The computed time interval brackets the calculations. I don't see how that would be affected by HTTP processing. Anyway, just replacing the calculations with a string return gives: elapsed time: 2.09808349609e-05 On Friday, 14 March 2014 11:27:39 UTC-4, Anthony wrote: > > How long does web2py

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
xrange makes no difference. And, yes, I've run the Welcome program dozens of times and the results are very consistent. There is little randomness in time.time(). My Linux server is a dedicated machine at the datacentre. I have it all to myself. Not much else is running on it. Apache2, web2py.

[web2py] Re: Python Performance Issue

2014-03-14 Thread Anthony
How long does web2py take to return just a simple string (i.e., remove the calculations from test())? You can't really compare the time an HTTP request takes to the time it takes to run a simple Python script -- a lot more is going in with an HTTP request (though .1 seconds still sounds high).

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 7:39 AM, horridohobbyist wrote: > Okay, version 2.6.5 is verified. No difference in the Python version. > > So how to explain the performance difference? It's getting to be interesting. To make the result more robust, I'd try it with a much bigger range, maybe 100x, to be su

[web2py] Re: need help with query

2014-03-14 Thread Bastiaan
> > Solved it by using 2 seperate queries: > rij = db().select( db.track_trace.id_reparaties, db.track_trace.id_status, db.track_trace.created_by, max, groupby=~db.track_trace.id_reparaties, having=(db.track_trace.id_status == 4)) ids = [] for item in rij:

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
Okay, version 2.6.5 is verified. No difference in the Python version. So how to explain the performance difference? On Friday, 14 March 2014 09:36:29 UTC-4, Jonathan Lundell wrote: > > On 14 Mar 2014, at 6:28 AM, horridohobbyist > > > wrote: > > I conducted a simple experiment. I took the "Wel

[web2py] Re: Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread 黄祥
wonthefull, just a suggestion, for a page translation please. some page in english and some is in portugese best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/l

[web2py] web2py on Mac OS Mavericks, trying to use port 80

2014-03-14 Thread audionuma
Hello, Thanks to the team for the great tool ! I have minor issues on Mac OS Mavericks, just wanted to check before creating an issue on google code. System Mac OS 10.9.2 $ which python /usr/bin/python $ python --version Python 2.7.5 Steps download web2py_src.zip unzip the archive into $basedir

[web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread shapovalovdenis
I remember see something on previous version, IIRC the thing was in apache's vhost config. On Friday, March 14, 2014 4:27:04 PM UTC+2, Massimo Di Pierro wrote: > > Anybody else experiencing this? > > On Friday, 14 March 2014 06:39:08 UTC-5, SimonD wrote: >> >> Hello, I have seen a previous post o

[web2py] Re: Custom fill with SQLFORM not saving. Web2py version 2.8.2

2014-03-14 Thread Massimo Di Pierro
This was never the correct syntax. You are passing a SQLFORM objected to a FORM method. if FORM.accepts(form,request.vars): should be if form.process().accepted: On Thursday, 13 March 2014 14:00:24 UTC-5, Martin wrote: > > Hi all, > > >...if FORM.accepts(form,request.vars): .. > not wo

[web2py] Re: Accepting custom form without saving

2014-03-14 Thread Massimo Di Pierro
form.process(dbio=False).accepted On Thursday, 13 March 2014 14:28:03 UTC-5, Martin wrote: > > Hi all, > Please could anyone tell me how to accept a *custom SQLFORM* without > inserting to db, since > > if form.process().accepted: seems to be perform insertion directly. > > thanks! > > -- R

[web2py] Re: Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-14 Thread Fcosqui
Traceback (most recent call last): File "/var/web2py/gluon/restricted.py", line 217, in restricted exec ccode in environment File "/var/web2py/applications/site/controllers/default.py", line 89, in File "/var/web2py/gluon/globals.py", line 385, in self._caller = lambda f: f() F

[web2py] Re: Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-14 Thread Fcosqui
Traceback (most recent call last): File "/var/web2py/gluon/restricted.py", line 217, in restricted exec ccode in environment File "/var/web2py/applications/site/controllers/default.py", line 89, in File "/var/web2py/gluon/globals.py", line 385, in self._caller = lambda f: f() F

[web2py] Accepting custom form without saving

2014-03-14 Thread Martin
Hi all, Please could anyone tell me how to accept a *custom SQLFORM* without inserting to db, since if form.process().accepted: seems to be perform insertion directly. thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Custom fill with SQLFORM not saving. Web2py version 2.8.2

2014-03-14 Thread Martin
Hi all, ...if FORM.accepts(form,request.vars): .. not working for custom form, please may i know if i'am missing something... Thanks! def page1(): form=SQLFORM(db.a_table) if FORM.accepts(form,request. vars): session.vars=form.vars redirect(URL(r=request,f='confirm')

[web2py] http 400 error after change urls

2014-03-14 Thread Relsi Maron
Hi, This happening an unusual thing here, after I changed my urls, I am getting many http 400 errors. I've rebooted the routes, already rebooted the server, and the errors are still happening. Sometimes you can access the url, and sometimes receive error 400. And sometimes it no rewrite the ro

Re: [web2py] Re: login_next and next var

2014-03-14 Thread Trevor Strauss
Hi Jonathan, I've been banging my head on this all day, how do I get _next to work? On Tuesday, 4 February 2014 13:49:50 UTC-5, Jonathan Lundell wrote: > > On 4 Feb 2014, at 10:32 AM, Annet > > wrote: > > Notice extra ' before 'URL > > > When I remove the ' ' around the URL > > Login > > The

Re: [web2py] Re: CAS provider and registration

2014-03-14 Thread ureal frank
On Sunday, February 16, 2014 5:10:16 PM UTC, Massimo Di Pierro wrote: > > I am open to change this. Do you want to attempt a patch to address some > of the issues? > Any news regarding this issue? I've tested it today with 2.9.4 and the behaviour is the same. it would be awesome to have this '

Re: [web2py] Re: login_next and next var

2014-03-14 Thread Trevor Strauss
Hi Annet, I'm somewhat new...can you explain how you ended up getting this to work? I am encountering same issue with login button I've created for jqm layout. Thanks,Trevor On Wednesday, 5 February 2014 07:56:59 UTC-5, Annet wrote: > > Hi Jonathan, > > Thanks for your reply. > > It's a URL; i

[web2py] Re: Problem with web2py on Heroku

2014-03-14 Thread Chris DeGroot
I think I may have made sense of the error above. Based on the code below, DatabaseStoredFile.web2py_filesystem is set to true even if the table creation fails (which it does), as I don't think the error will be caught before it gets to that line. A few lines later, it tries to access that

[web2py] Re: Appadmin on 2.9.4

2014-03-14 Thread Massimo Di Pierro
Anybody else experiencing this? On Friday, 14 March 2014 06:39:08 UTC-5, SimonD wrote: > > Hello, I have seen a previous post on an apparently broken Admin screen, > but I think this is a different issue (or just a noobie question). > I have done my app development on 2.3.2 (on Ubuntu 10.04 LTS).

[web2py] Re: Problems - Changes on SQLTABLE? Upgraded to 2.9.4-stable

2014-03-14 Thread Massimo Di Pierro
Can you please download and try trunk? It should be fixed there. On Thursday, 13 March 2014 20:23:09 UTC-5, drayco wrote: > > We use extensive SQLTABLE and in this moment we have a lot of errors > similar to > > File "/home/drayco/web2py/gluon/sqlhtml.py", line 2929, in __init__ > columns =

[web2py] Fashion Marketplace in Web2py - Feedback needed

2014-03-14 Thread Francisco Costa
Hi there, Just wanted to get some feedback form the web2py community about this new project: *CHIQUE* is a mobile fashion marketplace built around real-time social experiences. Our vibrant community brings fashion lovers together to share their individual style, tu

[web2py] Re: Admin and tickets broken after upgrade to 2.9.4

2014-03-14 Thread Massimo Di Pierro
I cannot say. There is some file in there that does not get overwritten when you unzip it. On Thursday, 13 March 2014 17:42:09 UTC-5, shapova...@gmail.com wrote: > > Your suggestion just did the trick. But now I'm curious - what was the > problem then?? > > On Friday, March 14, 2014 12:14:11 AM

[web2py] Re: Verbatim Tag

2014-03-14 Thread Massimo Di Pierro
{{data.message + " world!"}} should be {{= data.message + " world!"}} On Thursday, 13 March 2014 17:21:28 UTC-5, David Simmons wrote: > > Hi All (again). > > I did some digging around with the web2py source code and came up with > this. > > https://gist.github.com/shortly-portly/9538005 > >

Re: [web2py] Re: Python Performance Issue

2014-03-14 Thread Jonathan Lundell
On 14 Mar 2014, at 6:28 AM, horridohobbyist wrote: > I conducted a simple experiment. I took the "Welcome" app, surely the > simplest you can have (no databases, no concurrency, etc.), and added the > following to the index page: > > def test(): > start = time.time() > x = 0.0 > for

[web2py] Re: Python Performance Issue

2014-03-14 Thread horridohobbyist
I conducted a simple experiment. I took the "Welcome" app, surely the simplest you can have (no databases, no concurrency, etc.), and added the following to the index page: def test(): start = time.time() x = 0.0 for i in range(1,5000): x += (float(i+10)*(i+25)+175.0)/3.14

[web2py] Re: Creating report from diffrent tables

2014-03-14 Thread 黄祥
pardon me, is your table definition is right? e.g. db.define_table('employee_login_detail', Field('employee_code'), Field('employee_email'), Field('employee_name'), Field('employee_login_date','date'), Field('employee_login_time'), Field('ip_address')) db.define_table('employee_leave', * Field('emp

[web2py] Re: Creating report from diffrent tables

2014-03-14 Thread Raj
Thanks Stifan can u give some example. i have gone trow that, but i am not getting result On Friday, 14 March 2014 17:31:33 UTC+5:30, 黄祥 wrote: > > for total number, i think you can achieve it with sum query in dal. > > ref : > > http://web2py.com/books/default/chapter/29/06/the-database-abstra

[web2py] Re: Python Performance Issue

2014-03-14 Thread Leonel Câmara
If you have a performance issue why haven't you used a profiler yet? No one is going to "guess" it, web2py.py -F foldername Then use something like runsnakerun or pstats. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

Re: [web2py] Re: GAE deployment problem with gluon.settings

2014-03-14 Thread Francisco García Claramonte
Hello Massimo, 2014-03-13 14:41 GMT+01:00 Massimo Di Pierro : > I made a change in trunk about this. Can you please check it? > > Thank you for your fast answer and patch. I'll test it in next days and I'll tell to the list. Thank you for your work. ;) Regards, Francisco > On Thursday, 13 Marc

[web2py] Re: Creating report from diffrent tables

2014-03-14 Thread 黄祥
for total number, i think you can achieve it with sum query in dal. ref : http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum--avg--min--max-and-len best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

[web2py] Creating report from diffrent tables

2014-03-14 Thread Raj
Hi Web2py user I want to create report on Employee.I have three tables holiday list, login details and employe leave. I want to create report in such way so i can see employe name, total number of day in current month, total no of present, total number of holiday i current month and total numb

Re: [web2py] Re: web2py dal week query

2014-03-14 Thread 黄祥
a, i c, thank you so much for your hints, michele. best regards, stifan On Friday, March 14, 2014 6:41:11 AM UTC+7, Michele Comitini wrote: > > From postgresql manual: > > http://www.postgresql.org/docs/current/static/functions-datetime.html > > > SELECT EXTRACT(WEEK FROM TIMESTAMP '2001-02-16