[web2py] Question about sum()
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] Server konfigurations basics redirects
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.
Re: [web2py] ipython is your friend!
+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 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 appname -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?return 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??return 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.tab 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?return or In [7]: SQLFORM.smartgrid??return 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] Re: Star Rating
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 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.
[web2py] import track_changes when using sys.path.append to import module in custom location
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] demo down
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] Re: demo down
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 -- 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: Login page Optimizations - barest form of web2py
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: Star Rating
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] Why aren't email/username fields unique?
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: Question about sum()
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] Re: import track_changes when using sys.path.append to import module in custom location
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: demo down
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 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: Why aren't email/username fields unique?
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: Why aren't email/username fields unique?
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] How to have a single user application
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: Question about sum()
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] Re: Star Rating
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: Star Rating
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 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: How to have a single user application
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.
Re: [web2py] Re: Why aren't email/username fields unique?
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 abasta...@gmail.com 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
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?
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 abas...@gmail.com javascript: 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 javascript:. 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?
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 javascript:.
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: Is there a way to display field label or field value (vs. field name) in smartgrid breadcrumb?
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 OwnersJoe).
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 OwnersJoeDogs 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
JoeDogs for Owner or
Owners
JoeDogs 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.
[web2py] Re: MySQL, self-reference, and null values
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 :
class '_mysql_exceptions.IntegrityError' (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
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 :
class '_mysql_exceptions.IntegrityError' (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] How can do muliple check boxes if a group and only allow the user the select 1.
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
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] Re: How can do muliple check boxes if a group and only allow the user the select 1.
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] skyrocketing memory. How to pinpoint the problem?
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.
Re: [web2py] skyrocketing memory. How to pinpoint the problem?
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 javascript:.
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] @auth.requires_membership('Admin') and @auth.requires(auth.has_membership(role = 'Admin'))
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.
[web2py] Re: import track_changes when using sys.path.append to import module in custom location
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.
Re: [web2py] Re: Integrating iPhone device tokens into web2py auth
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 how...@umich.edu 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 how...@umich.edu 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: Server konfigurations basics redirects
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.
