[web2py] Question about sum()

2013-02-10 Thread Calycé
Hi all, Given a query like the following one: booked = db.booking.seats.sum() db(db.schedule.training==db.training.id).select(db.schedule.training_date,db .training.short_title, db.schedule.seats, db.booking.seats.sum(), groupby=(

[web2py] Server konfigurations basics redirects

2013-02-10 Thread BlueShadow
Hi, I got my first domain which I redirected towards my server ip. The apache Server gives the request to web2py. which opens the default application. But that is what I want I want the domain to go directly towards one application. and it should replace the server ip and the application name.

Re: [web2py] ipython is your friend!

2013-02-10 Thread António Ramos
+1 for a VIDEO of this... 2013/2/9 JimK jkel...@gmail.com One of the nice things about python modules that are not c-compiled is the fact that you can read the source code. The bad part is that the source code is not always easy to find. This is where ipython comes in. IPython is an

[web2py] Re: Star Rating

2013-02-10 Thread Alan Etkin
So the star rating is definitely not making its way back to the server. I'm guessing it should look like the following: Storage {'rating': '5', '_formkey': '7c32617c-2136-4d8d-ad54-ea7ae454e551', '_formname': 'song/create', 'title': 'Thriller'} I have reproduced the issue with firefox

[web2py] import track_changes when using sys.path.append to import module in custom location

2013-02-10 Thread Tim Richardson
I have 2.3.2 with python 2.7 on Windows. I'm importing a module from an odd location in the file system, and therefore doing from gluon.custom_import import track_changes; track_changes(True) #while in development sys.path.append('C:\...') # a windows path import mod1#a module in the

[web2py] demo down

2013-02-10 Thread Sebastian E. Ovide
the interactive demo from the official web sire ( http://web2py.com/demo_admin) is down: admin disabled because unable to access password file -- Sebastian E. Ovide -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this

[web2py] Re: demo down

2013-02-10 Thread Sebastian E. Ovide
also: http://www.web2py.com/welcome On 10 February 2013 12:04, Sebastian E. Ovide sebastian.ov...@gmail.comwrote: the interactive demo from the official web sire ( http://web2py.com/demo_admin) is down: admin disabled because unable to access password file -- Sebastian E. Ovide --

[web2py] Re: Login page Optimizations - barest form of web2py

2013-02-10 Thread Abhishek Gupta
Hi Niphlod, I didn't want to use web2py features and thus auth as an object wouldn't be available to me. I finally did this, I changed wsgihandler.py so that : If url is base_url or base_url+/, I check the cookies. If cookies say, the user is logged in then I redirect him to my required

[web2py] Re: Star Rating

2013-02-10 Thread Alan Etkin
So the star rating is definitely not making its way back to the server. Right. This seems not to be a web2py issue: the plugin is setting a disabled attribute for the rating input, so the field is omitted on processing. I found a workaround, adding this to the view: {{=SCRIPT(

[web2py] Why aren't email/username fields unique?

2013-02-10 Thread Yarin
Why are email/username fields not created with (unique=True) by default? Since these fields are use to identify users, non-unique values would clearly break auth. (Side note: where is the code for defining the default auth table fields located?- can't find it anywhere) -- --- You received

[web2py] Re: Question about sum()

2013-02-10 Thread Massimo Di Pierro
I think you want: booked = db.booking.seats.sum().coalesce_zero() On Sunday, 10 February 2013 02:53:40 UTC-6, Calycé wrote: Hi all, Given a query like the following one: booked = db.booking.seats.sum() db(db.schedule.training==db.training.id).select(db.schedule.training_date,db

[web2py] Re: import track_changes when using sys.path.append to import module in custom location

2013-02-10 Thread Massimo Di Pierro
No. Track changes only tracks changes for modules that are stored in the application. On Sunday, 10 February 2013 05:48:41 UTC-6, Tim Richardson wrote: I have 2.3.2 with python 2.7 on Windows. I'm importing a module from an odd location in the file system, and therefore doing from

[web2py] Re: demo down

2013-02-10 Thread Massimo Di Pierro
Some apps are disabled because we are migrating to another server. On Sunday, 10 February 2013 06:09:58 UTC-6, sebastian wrote: also: http://www.web2py.com/welcome On 10 February 2013 12:04, Sebastian E. Ovide sebasti...@gmail.comjavascript: wrote: the interactive demo from the official

[web2py] Re: Why aren't email/username fields unique?

2013-02-10 Thread Massimo Di Pierro
All the code about Auth is in gluon/tools.py. True we do not check at the db level but we check at the web2py level: Field('email', length=512, default='', label=self.messages.label_email, requires=is_unique_email), On Sunday, 10 February

[web2py] Re: Why aren't email/username fields unique?

2013-02-10 Thread Anthony
The code is here: http://code.google.com/p/web2py/source/browse/gluon/tools.py#1452 Uniqueness is checked via the form validators rather than unique=True (which is enforced at the database level). The validators are more useful because they display a user friendly error message on the form

[web2py] How to have a single user application

2013-02-10 Thread rjmolesa
I'm interested in branching my current application so that it will be single user desktop application. As such I don't want the user to have to register but I want to maintain auth tables and settings. Essentially I want a user to be able to download the app and begin using it right away as a

[web2py] Re: Question about sum()

2013-02-10 Thread Calycé
Grazie mille Massimo, It is indeed what I was looking for :-) On Sunday, February 10, 2013 5:19:55 PM UTC+1, Massimo Di Pierro wrote: I think you want: booked = db.booking.seats.sum().coalesce_zero() On Sunday, 10 February 2013 02:53:40 UTC-6, Calycé wrote: Hi all, Given a query like

[web2py] Re: Star Rating

2013-02-10 Thread Michael Gheith
Hello Alan, I added this code to the view and it is still not working. Can you post your working .w2p somewhere? It makes sense that the select field that represents that stars is somehow disabled. Hope to hear from you soon Alan! Best, M.G. On Sunday, February 10, 2013 8:12:49 AM UTC-6,

[web2py] Re: Star Rating

2013-02-10 Thread Michael Gheith
Here is the code that worked for me when added to the view. Send all your thanks to Alan Etkin!! script $(document).ready(function() { $(form).submit( function() { $([name=rating]).removeAttr(disabled); } ); }); /script On Friday, February 8, 2013 4:52:19 PM

[web2py] Re: How to have a single user application

2013-02-10 Thread Niphlod
you should figure out a way to auto-login the user at the first use of the application. Depending on how your app is structured YMMV, but it shouldn't be hard. On Sunday, February 10, 2013 7:39:49 PM UTC+1, rjmolesa wrote: I'm interested in branching my current application so that it will be

Re: [web2py] Re: Why aren't email/username fields unique?

2013-02-10 Thread Yarin Kessler
Agree that is should be caught by validation- but why not enforce uniqueness on the DB as well to prevent data corruption in case the db gets hit by another source/ edited manually/ etc. Why have DB-level constraints if we don't use them in cases like this? On Sun, Feb 10, 2013 at 11:31 AM,

[web2py] Re: How to have a single user application

2013-02-10 Thread Massimo Di Pierro
if not db(db.auth_user).isempty(): auth.settings.disabled_actions.append('register') and only one user will be able to register. On Sunday, 10 February 2013 12:39:49 UTC-6, rjmolesa wrote: I'm interested in branching my current application so that it will be single user desktop application.

Re: [web2py] Re: Why aren't email/username fields unique?

2013-02-10 Thread Massimo Di Pierro
Because it migrations involving uniqueness are tricky and this change may break existing applications. Moreover there are cases when people do not want the email to be unique, for example if they also have a username. On Sunday, 10 February 2013 16:34:12 UTC-6, Yarin wrote: Agree that is

Re: [web2py] skyrocketing memory. How to pinpoint the problem?

2013-02-10 Thread Massimo Di Pierro
I tried your example but I cannot reproduce the problem (I am on Mac, OSX 10.7.5 and Python 2.7.3). Can others reproduce it? On Tuesday, 5 February 2013 13:15:45 UTC-6, pumplerod wrote: I'm reading up on strace now. in the meanwhile, here is the MVC code (not sure if I can attach a file

[web2py] Re: Is there a way to display field label or field value (vs. field name) in smartgrid breadcrumb?

2013-02-10 Thread Massimo Di Pierro
I opened issue 1327. Can you help us fix it or post some screenshots? That would speed up the resolution. On Monday, 4 February 2013 19:53:40 UTC-6, Michael Beller wrote: Thank you - the breadcrumb now displays the field Label but I found another issue with the breadcrumbs ... I start with

[web2py] Re: MySQL, self-reference, and null values

2013-02-10 Thread Massimo Di Pierro
Any advice about this. I am not sure about the problem. Seems mysql specific. On Friday, 1 February 2013 09:20:54 UTC-6, Loïc wrote: Dear All, I have a 'page' model with a sef-reference: db.define_table('page', Field('parent', 'reference page', readable=False, writable=False),

[web2py] Re: MySQL, self-reference, and null values

2013-02-10 Thread Massimo Di Pierro
Can you please open a ticket so the issue is tracked? On Friday, 1 February 2013 09:20:54 UTC-6, Loïc wrote: Dear All, I have a 'page' model with a sef-reference: db.define_table('page', Field('parent', 'reference page', readable=False, writable=False), Field('title', unique=True,

[web2py] How can do muliple check boxes if a group and only allow the user the select 1.

2013-02-10 Thread Dan Kozlowski
How can do muliple check boxes if a group and only allow the user the select 1. I used the smart grid to create the add and update. Dog or Cat and only 1 can be selected. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe

Re: [web2py] Re: How to have a single user application

2013-02-10 Thread Bruno Rocha
models/db.py db = DAL(.) from gluon.tools import Auth auth = Auth(db).define_tables() # if forst time running create the new user if db(db.auth_user).isempty(): password = CRYPT()(12345)[0] db.auth_user.valdiate_and_insert(first_name=default,

[web2py] Re: How can do muliple check boxes if a group and only allow the user the select 1.

2013-02-10 Thread Anthony
Why not use radio buttons or a drop-down if you want to allow only one selection? On Sunday, February 10, 2013 6:07:16 PM UTC-5, Dan Kozlowski wrote: How can do muliple check boxes if a group and only allow the user the select 1. I used the smart grid to create the add and update. Dog or

Re: [web2py] skyrocketing memory. How to pinpoint the problem?

2013-02-10 Thread Todd Shifflett
Strange. In order to get around the issue I converted it over to run on GAE. This seems to work ok. I notice thought that we're averaging about 2 requests per second. On Feb 10, 2013, at 3:35 PM, Massimo Di Pierro wrote: I tried your example but I cannot reproduce the problem (I am on

Re: [web2py] skyrocketing memory. How to pinpoint the problem?

2013-02-10 Thread Massimo Di Pierro
2 requests/second seem slow. What does your app do? Look at {{=response.toolbar()}} and see which DB query and how long they individually take. On Sunday, 10 February 2013 21:49:57 UTC-6, pumplerod wrote: Strange. In order to get around the issue I converted it over to run on GAE. This

[web2py] @auth.requires_membership('Admin') and @auth.requires(auth.has_membership(role = 'Admin'))

2013-02-10 Thread 黄祥
hi, what is the difference within : @auth.requires_membership('Admin') and @auth.requires(auth.has_membership(role = 'Admin')) it seems there is some limitation in @auth.requires_membership('Admin') e.g. *case 1 :* *as expected result* *@auth.requires(auth.has_membership(role = 'Admin')) ###

[web2py] Re: import track_changes when using sys.path.append to import module in custom location

2013-02-10 Thread Tim Richardson
Too bad no symlinks in windows. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit

Re: [web2py] Re: Integrating iPhone device tokens into web2py auth

2013-02-10 Thread Alec Taylor
Not to worry, I'm releasing a generalised open-source OAuth2 Library for web2py. As for your current mechanism of anonymous tokens… how about just storing a cookie (or some other client-side storage) and when the user logs-in or registers all their customisations (e.g.: if e-commerce, their cart)

[web2py] Re: Server konfigurations basics redirects

2013-02-10 Thread Emilius Omeen
rename your application to init or edit /web2py/routes.py default_application = 'your application name'# ordinarily set in base routes.py default_controller = 'default' # ordinarily set in app-specific routes.py default_function = 'index' # ordinarily set in app-specific routes.py