[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

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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) will be sent securely to the server on receipt of
successful authentication.

That would be a much cleaner, more secure, streamlined and
self-contained model than your current one.

On Sun, Feb 10, 2013 at 9:33 AM, howesc  wrote:
>  - Apple explicitly does not allow using the hardware identifier in your
> app, and will reject app submission that do that.  because of this each app
> install "logs in" first as an anonymous user.
>  - website users use standard web2py auth
>  - app connections to the server use our modified OAuth API implementation.
> this forgoes web2py auth, but reads and writes to the same user table that
> web2py auth uses.  this allows the 2 different systems to connect.
>  - the mobile apps are native code on their respective platforms, the
> website is html.
>
> unfortunately our modified OAuth implementation is pretty specific to our
> needs and so i don't think it's a candidate for us to open source.  i'll
> take a look into what we are doing though to see if any of it can/should be
> open sourced.
>
> cfh
>
>
> On Saturday, February 9, 2013 11:40:50 AM UTC-8, Kenny wrote:
>>
>> Howesc,
>> Thanks for great info. So, does mobile app user have to register web2py
>> via access token provided by their hardware in mobile application? May you
>> explain how you built the login/registration module for mobile app users
>> along with web2py?
>> Do you code in html5 with native code for developing your mobile app?
>>
>> Sorry for asking more than one question, this topic sounds so interesting!
>> :)
>>
>> Thank you!
>>
>> On Feb 9, 2013 11:45 AM, "howesc"  wrote:
>>>
>>> well what we are using is a hybrid model:
>>>  - the ios device uses a modified form of OAuth to get access tokens (and
>>> we have the confusing problem of users start anonymous but with an access
>>> token, and then may later create an "account" associating an email and other
>>> user data with the account)
>>>  - the website uses web2py's auth to login those same users
>>>  - the APNS token (Apple Push Notification Service) is provided
>>> optionally by the user if they opt-in to push notifications.  as such it's
>>> not a primary key for the user and can't be used for authentication.   if
>>> the user chooses to share it with us we store that in a field on our user
>>> table.  Note that the APNS token is device specific, so if the user has
>>> multiple devices then they might have multiple tokens.
>>>
>>> does that clarify at all?
>>>
>>> cfh
>>>
>>> On Friday, February 8, 2013 9:46:42 PM UTC-8, Massimo Di Pierro wrote:

 I do not know how this works. Can you give us more details?

 On Friday, 8 February 2013 20:31:14 UTC-6, howesc wrote:
>
> i have millions of APNS tokens! i'd share, but they are tied to an
> app
>
> i did not tie APNS tokesn to web2py auth, but i added fields to my end
> user table, and the device uses my REST JSON API to POST the APNS tokens 
> to
> the server and update the user.  we don't use the APNS token as any sort 
> of
> user identifier.
>
> does that help?  lemme know if you are interested in more details.
>
> christian
>
> On Thursday, February 7, 2013 5:22:28 PM UTC-8, chris_g wrote:
>>
>> I'm looking into supporting Apple push notifications in an iPhone app
>> that connects to a web2py server.
>> In order to know which devices to push details to, web2py's auth
>> module would presumably need to maintain "Device Tokens".
>> I'm curious if anyone has implemented a solution that takes care of
>> this. I'd like to see how it was integrated with web2py's auth.
>>
>> Thanks,
>> Chris
>>>
>>> --
>>>
>>> ---
>>> 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+un...@googlegroups.com.
>>>
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>
> --
>
> ---
> 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 https://groups.google.com/groups/opt_out.
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 https://groups.google.com/groups/opt_out.




[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')) ### the difference*
def __grid_0(flash, table):
response.flash=T(flash)
has_membership=auth.has_membership('Admin')
grid=SQLFORM.smartgrid(table, onupdate=auth.archive,
   create=has_membership,
   editable=has_membership,
   deletable=has_membership)
return dict(grid=grid)

def manage_blog():
return __grid_0(blog_manage_flash, blog_db)

*unexpected result*
*@auth.requires_membership('Admin') ### the difference*
def __grid_0(flash, table):
response.flash=T(flash)
has_membership=auth.has_membership('Admin')
grid=SQLFORM.smartgrid(table, onupdate=auth.archive,
   create=has_membership,
   editable=has_membership,
   deletable=has_membership)
return dict(grid=grid)

def manage_blog():
return __grid_0(blog_manage_flash, blog_db)

what i mean for unexpected result is, the user with the membership of group 
'Admin' can not see the manage_blog page, when i modified it with 
*@auth.requires(auth.has_membership(role 
= 'Admin'))*, the user with the membership of group 'Admin' can see the 
manage_blog page.

is there anyone know about it?

thank you so much in advance

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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 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 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 to google groups)….
>>
>>
>> Model:
>>
>> -Nothing.  I have an empty model file.  Other than the default settings 
>> that come with a new controller.  
>> Ordinarily I am using a Model and writing to the SQLite db.  But this is 
>> the simplest case I could make that 
>> still replicates the problem.
>>
>> View:
>>
>> -Don't have this either.  I'm only ever returning a json object via REST 
>> so there's no need for a view.
>>
>> Controller:  
>> You can see some of what normally gets loaded, which I've commented out. 
>>  I also tried to see if gc or cache would help.  
>> I've never used these before though so I may have been doing it 
>> incorrectly.
>>
>> the RESTful query would look something like:   
>> http://domain.com/memclimb/request.json?jo={"Test":"memory"}
>>
>>
>> "request.py" (controller)...
>> ___vv__
>> @request.restful()
>> #@cache(request.env.path_info,time_expire=10,cache_model=cache.ram)
>> def test():
>>   #import gc
>>   import gluon.contrib.simplejson
>>   response.view = 'generic.'+request.extension
>>   #gc.enable()
>>
>>   def GET(*args,**vars):
>> 
>> jsonObject = request.vars.jo
>> obj =  gluon.contrib.simplejson.loads(jsonObject)
>> return {'message': 'testing Memory.'}
>>
>>   #gc.collect()
>>   return locals()
>> ___^^
>>
>> Only seems to be a problem under high traffic.  So I created this python 
>> script and ran 10 instances of it from another machine.  
>> It's common for our site to have >100 trying to hit it at about the same 
>> time, but I can see the memory climb even with only 10.
>>
>> "testLoad.py"...
>> vv
>> #!/usr/bin/env python
>>
>> import sys
>> import os
>> import urllib
>>
>> def main():
>>   for i in range(1000):
>> result = urllib.urlopen('
>> https://domain.com/memclimb/request/test.json?jo={"Test":"memory"}')
>> json = result.read()
>>   print "done…\n\t%s"%json
>>
>>
>> if __name__ == '__main__':
>>   main()
>> __^^
>>
>>
>>
>> On Feb 5, 2013, at 8:30 AM, greaneym wrote:
>>
>> Hello,
>> In addition sending the model, view, controller code, you can try the 
>> following.
>>
>> It looks like dreamhost is using debian linux. You can try using the 
>> strace command in a shell while your process is running. You can run it 
>> against different process ids (pid) to help figure out what is associated 
>> with the problem.
>>
>> Here is a link that may be useful in running strace.
>> http://www.hokstad.com/5-simple-ways-to-troubleshoot-using-strace
>> Save the output in a file so you can look at it.
>>
>> Also you can run "top" in a shell to see what pid, program is running 
>> more than others and that may help you as well.
>>
>>
>>
>>>
>> -- 
>>  
>> --- 
>> 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+un...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>>
>>
> -- 
>  
> --- 
> 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+un...@googlegroups.com .
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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 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 to google groups)….
> 
> 
> Model:
> 
> -Nothing.  I have an empty model file.  Other than the default settings that 
> come with a new controller.  
> Ordinarily I am using a Model and writing to the SQLite db.  But this is the 
> simplest case I could make that 
> still replicates the problem.
> 
> View:
> 
> -Don't have this either.  I'm only ever returning a json object via REST so 
> there's no need for a view.
> 
> Controller:  
>   You can see some of what normally gets loaded, which I've commented 
> out.  I also tried to see if gc or cache would help.  
>   I've never used these before though so I may have been doing it 
> incorrectly.
> 
> the RESTful query would look something like:   
> http://domain.com/memclimb/request.json?jo={"Test":"memory"}
> 
> 
> "request.py" (controller)...
> ___vv__
> @request.restful()
> #@cache(request.env.path_info,time_expire=10,cache_model=cache.ram)
> def test():
>   #import gc
>   import gluon.contrib.simplejson
>   response.view = 'generic.'+request.extension
>   #gc.enable()
> 
>   def GET(*args,**vars):
> 
> jsonObject = request.vars.jo
> obj =  gluon.contrib.simplejson.loads(jsonObject)
> return {'message': 'testing Memory.'}
> 
>   #gc.collect()
>   return locals()
> ___^^
> 
> Only seems to be a problem under high traffic.  So I created this python 
> script and ran 10 instances of it from another machine.  
> It's common for our site to have >100 trying to hit it at about the same 
> time, but I can see the memory climb even with only 10.
> 
> "testLoad.py"...
> vv
> #!/usr/bin/env python
> 
> import sys
> import os
> import urllib
> 
> def main():
>   for i in range(1000):
> result = 
> urllib.urlopen('https://domain.com/memclimb/request/test.json?jo={"Test":"memory"}')
> json = result.read()
>   print "done…\n\t%s"%json
> 
> 
> if __name__ == '__main__':
>   main()
> __^^
> 
> 
> 
> On Feb 5, 2013, at 8:30 AM, greaneym wrote:
> 
>> Hello,
>> In addition sending the model, view, controller code, you can try the 
>> following.
>> 
>> It looks like dreamhost is using debian linux. You can try using the strace 
>> command in a shell while your process is running. You can run it against 
>> different process ids (pid) to help figure out what is associated with the 
>> problem.
>> 
>> Here is a link that may be useful in running strace.
>> http://www.hokstad.com/5-simple-ways-to-troubleshoot-using-strace
>> Save the output in a file so you can look at it.
>> 
>> Also you can run "top" in a shell to see what pid, program is running more 
>> than others and that may help you as well.
>> 
>> 
>> 
>> 
>> -- 
>>  
>> --- 
>> 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+un...@googlegroups.com.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
> 
> 
> -- 
>  
> --- 
> 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 https://groups.google.com/groups/opt_out.
>  
>  

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 Cat and only 1 can be selected.  
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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",
last_name="default",
email="s...@email.com",
password=password)

# automatically login the user
user = auth.login_bare("s...@email.com", "12345")

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[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, notnull=True)
> //more fields not important here
> )
>
> When I insert a new page via appadmin without specifying a 'parent', 
> everything is OK with sqlite
>
> Since I moved my database to mysql, I have an error : 
>  (1452, 'Cannot add or update a 
> child row: a foreign key constraint fails (`dommartin25`.`page`, CONSTRAINT 
> `page_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `page` (`id`) ON DELETE 
> CASCADE)')
> How can I allow null values for the 'parent' field?
>
> Thank you
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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),
> Field('title', unique=True, notnull=True)
> //more fields not important here
> )
>
> When I insert a new page via appadmin without specifying a 'parent', 
> everything is OK with sqlite
>
> Since I moved my database to mysql, I have an error : 
>  (1452, 'Cannot add or update a 
> child row: a foreign key constraint fails (`dommartin25`.`page`, CONSTRAINT 
> `page_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `page` (`id`) ON DELETE 
> CASCADE)')
> How can I allow null values for the 'parent' field?
>
> Thank you
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 an action "manage_owners" that returns a smartgrid for 
> t_owner.  If I select the View button for the first owner, e.g. "Joe", I 
> get the following link:
>
> /playground/default/manage_owners/t_owner/view/t_owner/1
>
> with the breadcrumb "Owners" (that probably should be "Owners>Joe").
>
> If I instead select the link for Dogs for the owner in the smartgrid and 
> then select the link for Owner in the row for a Dog, I get the following 
> link for the same Owner as above:
>
> /playground/default/manage_owners/t_owner/t_dog.f_owner/1/view/t_owner/1
>
> with a misleading breadcrumb "Owners>Joe>Dogs for Owner" while viewing the 
> same form for the Owner as above.
>
> On Monday, February 4, 2013 5:44:58 PM UTC-5, Massimo Di Pierro wrote:
>>
>> I see. You are right. I think I now fixed it in trunk. Can you please 
>> check it?
>>
>> On Monday, 4 February 2013 16:28:25 UTC-6, Michael Beller wrote:
>>>
>>> I already use the Singular and Plural properties for the table but the 
>>> grid breadcrumbs don't appear to use them.  Also, the breadcrumb uses the 
>>> field name (f_owner) and not the label (Owner).
>>>
>>> Here is my model ...
>>>
>>> db.define_table('t_owner',
>>> Field('f_name', type='string', label=T('Name')),
>>> format='%(f_name)s',
>>> singular='Owner', plural='Owners',
>>> migrate=True)
>>>   
>>> db.define_table('t_dog',
>>> Field('f_name', type='string', label=T('Name')),
>>> Field('*f_owner*', type='reference t_owner', label=T('Owner')),
>>> format='%(f_name)s',
>>> singular='Dog', plural='Dogs',
>>> migrate=True)
>>>
>>> If I start with a smartgrid for t_owner (and show the linked table for 
>>> t_dog), after selecting the "Dogs" link for an owner in the grid, the grid 
>>> will display a list of dogs but with a breadcrumb that shows ""
>>> Owners>
>>> Joe>
>>> Dogs for f_owner""
>>>
>>> On Monday, February 4, 2013 9:27:35 AM UTC-5, Massimo Di Pierro wrote:

 db.f_owner._singular = 'Owner'
 db.f_owner._plural = 'Owners'

 This should do what you ask.

 On Sunday, 3 February 2013 20:19:29 UTC-6, Michael Beller wrote:
>
> I can't find any way around this and it looks like this is not the 
> desired behavior for the grid breadcrumbs.  One option is to change my 
> field name but that renders the label property not needed.
>
> Is there are way to control or modify the breadcrumbs?
>
> On Saturday, February 2, 2013 2:15:48 PM UTC-5, Michael Beller wrote:
>>
>> I'm using smartgrids to manage Owners and Dogs.  While navigating to 
>> the Dogs for an Owner from the Dogs smartgrid, the breadcrumb shows:
>>
>> "
>> Owners>
>> Joe>
>> Dogs for f_owner" ... 
>>
>> it would be much nicer to show: 
>>
>> "
>> Owners>
>> Joe>Dogs for Owner" or "
>> Owners>
>> Joe>Dogs for Joe".
>>
>> It would also be nice for the breadcrumb to show the singular 
>> property for the table, e.g., "Owner", instead of the plural property 
>> for 
>> this view.
>>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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 to google groups)….
>
>
> Model:
>
> -Nothing.  I have an empty model file.  Other than the default settings 
> that come with a new controller.  
> Ordinarily I am using a Model and writing to the SQLite db.  But this is 
> the simplest case I could make that 
> still replicates the problem.
>
> View:
>
> -Don't have this either.  I'm only ever returning a json object via REST 
> so there's no need for a view.
>
> Controller:  
> You can see some of what normally gets loaded, which I've commented out. 
>  I also tried to see if gc or cache would help.  
> I've never used these before though so I may have been doing it 
> incorrectly.
>
> the RESTful query would look something like:   
> http://domain.com/memclimb/request.json?jo={"Test":"memory"}
>
>
> "request.py" (controller)...
> ___vv__
> @request.restful()
> #@cache(request.env.path_info,time_expire=10,cache_model=cache.ram)
> def test():
>   #import gc
>   import gluon.contrib.simplejson
>   response.view = 'generic.'+request.extension
>   #gc.enable()
>
>   def GET(*args,**vars):
> 
> jsonObject = request.vars.jo
> obj =  gluon.contrib.simplejson.loads(jsonObject)
> return {'message': 'testing Memory.'}
>
>   #gc.collect()
>   return locals()
> ___^^
>
> Only seems to be a problem under high traffic.  So I created this python 
> script and ran 10 instances of it from another machine.  
> It's common for our site to have >100 trying to hit it at about the same 
> time, but I can see the memory climb even with only 10.
>
> "testLoad.py"...
> vv
> #!/usr/bin/env python
>
> import sys
> import os
> import urllib
>
> def main():
>   for i in range(1000):
> result = urllib.urlopen('
> https://domain.com/memclimb/request/test.json?jo={"Test":"memory"}')
> json = result.read()
>   print "done…\n\t%s"%json
>
>
> if __name__ == '__main__':
>   main()
> __^^
>
>
>
> On Feb 5, 2013, at 8:30 AM, greaneym wrote:
>
> Hello,
> In addition sending the model, view, controller code, you can try the 
> following.
>
> It looks like dreamhost is using debian linux. You can try using the 
> strace command in a shell while your process is running. You can run it 
> against different process ids (pid) to help figure out what is associated 
> with the problem.
>
> Here is a link that may be useful in running strace.
> http://www.hokstad.com/5-simple-ways-to-troubleshoot-using-strace
> Save the output in a file so you can look at it.
>
> Also you can run "top" in a shell to see what pid, program is running more 
> than others and that may help you as well.
>
>
>
>>
> -- 
>  
> --- 
> 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+un...@googlegroups.com .
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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 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, Anthony 
> > wrote:
>
>> 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 rather than 
>> causing a database operational error and a 500 response.
>>
>> Anthony
>>
>>
>> On Sunday, February 10, 2013 11:11:39 AM UTC-5, Yarin wrote:
>>>
>>> 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 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+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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. 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 'default' user. Has anyone tackled this before? How did you solve the 
> issue?

-- 

--- 
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 https://groups.google.com/groups/opt_out.




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, Anthony  wrote:

> 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 rather than
> causing a database operational error and a 500 response.
>
> Anthony
>
>
> On Sunday, February 10, 2013 11:11:39 AM UTC-5, Yarin wrote:
>>
>> 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 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 https://groups.google.com/groups/opt_out.
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 
> 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 'default' user. Has anyone tackled this before? How did you solve the 
> issue?

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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!!


$(document).ready(function() {

   $("form").submit(
 function() { 
 $("[name=rating]").removeAttr("disabled");
 }
   );
   
});





On Friday, February 8, 2013 4:52:19 PM UTC-6, Michael Gheith wrote:
>
> Hello web2py community :)
>
> I'm trying to implement a simple star rating for my site.  I followed the 
> steps in the web2py Application Development Cookbook, but it is not working 
> unfortunately; I select 2 stars for example, but it's not being saved to 
> the database.
>
> I have taken a look at the star rating widget in plugin_wiki, and could 
> not get that to work either!
>
> Can any of you provide me with a .w2p of something that works?
>
>
> Hope to hear from any of you soon, thanks in advance!
> Michael Joseph Gheith
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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, Alan Etkin wrote:
>
> > 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("""
> jQuery("form").submit(
>   function(){
> jQuery("[name=rating]").removeAttr("disabled");
>   }
> );
> """)}}
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 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
>> =(db.schedule.training_date,db.training.short_title,db.schedule.seats),left
>> =db.booking.on(db.schedule.id==db.booking.training_date))
>>
>> I'm retrieving the records I'm looking for except that for some of them I 
>> have no results in the summed column. These are for the records where there 
>> is no child record in the left table (booking).
>> Is there a way to tell sum() to return 0 instead of None ?
>>
>> Thanks for your help
>>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 'default' user. Has anyone tackled this before? How did you solve the 
issue?

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 rather than 
causing a database operational error and a 500 response.

Anthony

On Sunday, February 10, 2013 11:11:39 AM UTC-5, Yarin wrote:
>
> 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 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 https://groups.google.com/groups/opt_out.




[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 2013 10:11:39 UTC-6, Yarin wrote:
>
> 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 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 https://groups.google.com/groups/opt_out.




[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 
> 
> > wrote:
>
>> 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
>>
>>
>>
>>
>
>
> -- 
> Sebastian E. Ovide
>
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 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 directory
>
>
> It imports but the application does not pick up changes until I stop & 
> restart the rocket server.  It appears to me that track_changes(True) is 
> not working. I wonder if it is due to sys.path.append
>
>
>
>
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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
> .training.short_title, db.schedule.seats, db.booking.seats.sum(), groupby
> =(db.schedule.training_date,db.training.short_title,db.schedule.seats),left
> =db.booking.on(db.schedule.id==db.booking.training_date))
>
> I'm retrieving the records I'm looking for except that for some of them I 
> have no results in the summed column. These are for the records where there 
> is no child record in the left table (booking).
> Is there a way to tell sum() to return 0 instead of None ?
>
> Thanks for your help
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 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 https://groups.google.com/groups/opt_out.




[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("""
jQuery("form").submit(
  function(){
jQuery("[name=rating]").removeAttr("disabled");
  }
);
""")}}


-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 controller using a 
301 redirect, else I display the html contents.

This way, I can significantly improve speed for my login page as I would 
now just cache the contents using memcache.

- abhishek

On Saturday, 9 February 2013 00:55:00 UTC+5:30, Niphlod wrote:
>
> if auth.user_id .
>
> On Friday, February 8, 2013 6:52:13 PM UTC+1, Abhishek Gupta wrote:
>>
>> Hi,
>>
>> I have a website running on web2py. I want to optimize the login page, 
>> and strip all the web2py functional but to see if the user is logged in or 
>> not. To explain more, I want to do following:
>>
>> if user.is_logged_in_custom():
>>   return my_html
>>
>> else:
>>   redirect to_some_other_page
>>
>> The idea is that I don't want to interact with databases, models, and any 
>> other modules etc and get the login page as fast as possible. I can't 
>> simply cache it, as in that case if user is logged in then also the login 
>> page is displayed. 
>>
>> Thanks in advance
>> Abhishek
>>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 wrote:

> 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
>
>
>
>


-- 
Sebastian E. Ovide

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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 group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.




[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 directory


It imports but the application does not pick up changes until I stop & 
restart the rocket server.  It appears to me that track_changes(True) is 
not working. I wonder if it is due to sys.path.append






-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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:
>  '7c32617c-2136-4d8d-ad54-ea7ae454e551', '_formname': 'song/create', 
> 'title': 'Thriller'}>
>

I have reproduced the issue with firefox 18.0.1 and the built-in server 
(Version 2.4.1-alpha.2+timestamp.2013.02.08.12.41.08).

The rating select value is not retrieved server-side, it is being skipped 
somehow. Not sure where (perhaps when creating the request object).

-- 

--- 
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 https://groups.google.com/groups/opt_out.




Re: [web2py] ipython is your friend!

2013-02-10 Thread António Ramos
+1 for a VIDEO of this...

2013/2/9 JimK 

> 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 alternative to the regular python interpreter which offers a
> bunch of niceties.  This interpreter is supported by web2py out of the box;
> just install ipython (pip install ipython) and start web2py at the command
> prompt (python web2py.py -S  -M).  This will load the web2py
> environment for your application and it's models using the ipython
> interpreter.  I won't go through them all, but rather just a couple that
> really come in handy for me during web2py development.
>
> Let's say you want to see the doc string for SQLFORM:
> In [2]: form = SQLFORM?
> ipython display a scrollable doc string (type 'q' to exit the doc string
> viewer)
>
> Now you want to see the source code of the SQLFORM class:
> In [3]: form = SQLFORM??
> ipython now shows the entire SQLFORM class
>
> Let's say you want to just see all of the methods that SQLFORM has to
> offer:
> In [5]: SQLFORM.
> SQLFORM.AUTOTYPES SQLFORM.assert_status
> SQLFORM.grid  SQLFORM.search_menu
> SQLFORM.FIELDKEY_DELETE_RECORDSQLFORM.build_query
> SQLFORM.hidden_fields SQLFORM.sibling
> SQLFORM.FIELDNAME_REQUEST_DELETE  SQLFORM.confirm
> SQLFORM.insertSQLFORM.siblings
> SQLFORM.ID_LABEL_SUFFIX   SQLFORM.createform
>  SQLFORM.mro   SQLFORM.smartdictform
> SQLFORM.ID_ROW_SUFFIX SQLFORM.dictform
>  SQLFORM.process   SQLFORM.smartgrid
> SQLFORM.REDIRECT_JS   SQLFORM.element
> SQLFORM.regex_attrSQLFORM.tag
> SQLFORM.accepts   SQLFORM.elements
>  SQLFORM.regex_class   SQLFORM.update
> SQLFORM.add_buttonSQLFORM.factory
> SQLFORM.regex_id  SQLFORM.validate
> SQLFORM.add_class SQLFORM.flatten
> SQLFORM.regex_tag SQLFORM.widgets
> SQLFORM.appendSQLFORM.formstyles
>  SQLFORM.remove_class  SQLFORM.xml
>
> Finally, if you want to dig into any of those methods, like smartgrid:
> In [6]: SQLFORM.smartgrid?
> or
> In [7]: SQLFORM.smartgrid??
>
> and since the SQLFORM code is well documented and the argument names are
> descriptive, you should be able to figure out more problems on your own.
>
> This is just a taste of what you can do with ipython.  It can also display
> more detailed traceback messages, run os-level commands without exiting the
> interpreter, debug code, etc.
>
> I hope this helps a bit!
>
>
> Jim
>
>
>  --
>
> ---
> 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 https://groups.google.com/groups/opt_out.
>
>
>

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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. 
can anyone tell me how I can do it. I'm a real novice in server 
administration.

domain = ip/applicationname/
So when you get to the index page it looks like this: 
domain/default/index.html

-- 

--- 
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 https://groups.google.com/groups/opt_out.




[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=(
db.schedule.training_date,db.training.short_title,db.schedule.seats), left=
db.booking.on(db.schedule.id==db.booking.training_date))

I'm retrieving the records I'm looking for except that for some of them I 
have no results in the summed column. These are for the records where there 
is no child record in the left table (booking).
Is there a way to tell sum() to return 0 instead of None ?

Thanks for your help

-- 

--- 
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 https://groups.google.com/groups/opt_out.