[web2py] Re: reference field set to be null or in db but now the form does not display a dropdown with the values

What should be used instead? -- --- 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.go

Re: [web2py] Re: database shootout

I'm not even remotely suggesting anyone should use Fedora for a production server, that'd be nuts. Not so much because of the stability, but the release cycle is completely inappropriate, you'd have to upgrade the OS every 13 months at best, even if you skip every second release and stick with

[web2py] Re: session vs cookies performance

storage? yes. Performance? maybe. storing session in cookies has the big advantage to not require any kind of load balancer with sticky session for large deployments (i.e. from 20 web2py instances up), but at the added cost of unpacking and repacking the cookie at every request. Also, be sure th

[web2py] smartgrid showing values from cascading foreign tables.

I have tables: cities counties neighboorhoods streets The tabels are connected through foreign keys as follows: streets->neighborhoods; neighborhoods->counties, counties->cities When displaying streets through smartgrids, I'd like also to show for each value in streets the neighborhhod (this is

[web2py] Re: session vs cookies performance

Thanks for your answer. I am not storing too much, currenty I am storing for every user this string: facebook_id another string for the category of the forum where the user is right now the thread page were the user is the page of thread list This is for every user. I've been trying to use cooki

Re: [web2py] Re: Problem with uploading large file web2py version 2.3.2

Your post very very helpful. Indeed the problem is problem being passed to the URL function by the grid. I believe this is now fixed. Can you help me check it? Massimo On Saturday, 9 March 2013 13:21:38 UTC-6, Massimo Di Pierro wrote: > > Thank you Ricardo. This helps a lot. I will fix it asap.

[web2py] Re: session vs cookies performance

On Sunday, March 10, 2013 2:20:02 PM UTC+1, Jaime Sempere wrote: > > Thanks for your answer. > > I am not storing too much, currenty I am storing for every user this > string: > > facebook_id > another string for the category of the forum where the user is right now > the thread page were the us

[web2py] Re: session vs cookies performance

Using session makes sense. If for some reason you prefer cookies rather than server-side sessions, there is an option to store sessions in cookies -- see near the end of this section: http://web2py.com/books/default/chapter/29/04#session. In that case, you won't have to change any code and stil

[web2py] Re: session vs cookies performance

El domingo, 10 de marzo de 2013 14:32:59 UTC+1, Niphlod escribió: > > > > On Sunday, March 10, 2013 2:20:02 PM UTC+1, Jaime Sempere wrote: >> >> Thanks for your answer. >> >> I am not storing too much, currenty I am storing for every user these >> strings: >> >> facebook_id >> another string for

[web2py] Re: session vs cookies performance

> > Err... I thought that I knew what cookies and session meant, but I am not > so sure right now (for me session was always stored in server, using *" > session.name"* in web2py... cookies are stored in user browser... and I > am not very sure of how to use them, I think they are set using > r

[web2py] Re: session vs cookies performance

Thanks for the answer and the advice. After reading your answers I think I will use just simple sessions, as you said it makes sense. If in the future I need something more, I'll try the sessions in cookies, sounds like a good alternative. El domingo, 10 de marzo de 2013 14:43:10 UTC+1, Anthon

[web2py] Re: reference field set to be null or in db but now the form does not display a dropdown with the values

Not sure what you mean -- just take the validator out of the list: requires=IS_EMPTY_OR(IS_IN_DB(db, db.t_building_complexes)) On Sunday, March 10, 2013 5:08:53 AM UTC-4, memo wrote: > > What should be used instead? -- --- You received this message because you are subscribed to the Google Gr

[web2py] Re: Problem with uploading large file web2py version 2.3.2

This was indeed a problem with grid (not uploaded) as suggested by Roberto. Can you please check it is fixed in trunk? On Friday, 8 March 2013 19:55:35 UTC-6, Mạnh Trần Đức wrote: > > Hi,this is my db: > > db.define_table('clsb_product', > Field('produ

[web2py] Re: web2py app not working on gae

Looks like a file permission issue: It cannot read or find: /Users/username/Dropbox/LearnSoftware_and_Math/learnweb2py/web2py1/web2py/VERSION On Saturday, 9 March 2013 17:25:42 UTC-6, curiouslearn wrote: > > I am trying to learn how to deploy a web2py app on GAE. I downloaded a > fresh install

[web2py] Re: Having trouble with user_signature

It is been escaped while in this context should not be escaped. Use: ajax("{{=XML(URL(c='my_controller', f='do_something', vars=dict(x=session.x, y=session.y), user_signature=True))}}", [], ":eval"); On Thursday, 7 March 2013 22:22:17 UTC-6, weheh wrote: > > For extra security I'm adding user_si

[web2py] Re: Ballarò vs Agorà vs IS_MATCH

I do not have a strong opinion but I do not see a problem with unconditionally decoding. Shall I wait for a patch? On Thursday, 7 March 2013 17:54:12 UTC-6, Jonathan Lundell wrote: > > I have something like IS_MATCH(ur'(?u)[\w ]+', strict=True) for a field. > > I added the re.U override because

[web2py] Re: web2py 2.4.2 is OUT

This should now be fixed. Can you check? On Tuesday, 5 March 2013 17:21:03 UTC-6, Ralo Tannahill wrote: > > +1 for web2py!! > > In the admin interface I can see: > > Version 2.4.2 stable (2013-03-04 03:26:21) > > Unable to check for upgrades > > Running on *%s* > > %s should b

[web2py] Re: REF:Error accessing a foriegn key object

The problem is here: comment.created_by.first_name you have a comment with create_by == None. Probably test data you created before login. Use comment.created_by.first_name if comment.created_by else "unknown" On Wednesday, 6 March 2013 01:58:13 UTC-6, software.ted wrote: > > Following the

Re: [web2py] Detect web2py main process exit on cron process

Your patch is in trunk. Can you please check it? Thank you Alvaro. On Wednesday, 6 March 2013 07:05:57 UTC-6, Álvaro José Iradier wrote: > > Proposition: > > I have made a small proposed patch to newcron.py, in order to keep a list > of cron subprocesses and send a terminate signal when web2py ex

[web2py] Encrypt an email?

I found that website http://www.msgpadlock.com who basically allow you to encrypt/decrypt a message that I can then copy paste into the email i want to send. My question is is there a better way? Thanks guys! -- --- You received this message because you are subscribed to the Google Groups "w

[web2py] Re: sorting in admin panel

I made some improvements in trunk. Not exactly what you asked but better than before. Please check them and let us know how to do better. On Sunday, 3 March 2013 15:27:03 UTC-6, BlueShadow wrote: > > My project is getting bigger and bigger and its getting hard to find > specifc files in the admi

Re: [web2py] Ballarò vs Agorà vs IS_MATCH

On 10 Mar 2013, at 9:29 AM, Massimo Di Pierro wrote: > I do not have a strong opinion but I do not see a problem with > unconditionally decoding. Shall I wait for a patch? I wrote too soon! I won't have a patch right away, because a) I'm at SXSW with little time, and b) I think it needs at l

Re: [web2py] Re: Problem with uploading large file web2py version 2.3.2

On Sun, Mar 10, 2013 at 2:21 PM, Massimo Di Pierro wrote: > This was indeed a problem with grid (not uploaded) as suggested by Roberto. > Can you please check it is fixed in trunk? I did the same test as before and now I don't see the memory and CPU spikes, so it's fixed. Massimo, who is Roberto

Re: [web2py] Re: Problem with uploading large file web2py version 2.3.2

> > Massimo, who is Roberto? > > If I'm not wrong you are referring to me and I'm Ricardo ;) > > Both names have 7 letters and starts/ends with same letters, > remind me http://en.wikipedia.org/wiki/Typoglycemia > > lol. I'm niphlod, niphold, niphodl , etc . commits messages ala "autoc

Re: [web2py] 'exceptions.SyntaxError' No fields to update when login on heroku + facebook

Where is exception raised? We can fix it. On Saturday, 9 March 2013 07:48:23 UTC-6, Michele Comitini wrote: > > Leo, > > Good that you found the cause. > I will update the ticket, because SyntaxError is quite misleading. > > If you can follow https://code.google.com/p/web2py/issues/detail?id=1369

[web2py] My hack to add JSON support to `request.vars`

Might be helpful to someone, also maybe we should implement it as `request.vars.json`, like Python-Requests does? vars = request.vars vars = str(vars) vars = json.loads(vars[vars.find("{")+2 : vars.rfind("\': \'\'")]) -- --- You received this message because you are subscribed to the Google Gr

[web2py] Re: My hack to add JSON support to `request.vars`

What's the usecase for this ? On Sunday, March 10, 2013 5:40:20 PM UTC+1, Alec Taylor wrote: > > Might be helpful to someone, also maybe we should implement it as > `request.vars.json`, like Python-Requests does? > > vars = request.vars > vars = str(vars) > vars = json.loads(vars[vars.find("{"

[web2py] How to view primary key selection in the long term

Can someone please explain how the default primary key can survive data refreshes over the long term? My instinct is to create a natural primary key for all tables, e.g., scoreID (A, B, C, D), instead of using the default primary auto-increment field. db.define_table('ScoreLookupTable', ## val

[web2py] Re: Is it possible to deploy using Tornado on GAE?

Christian, thanks for the feedback. Is it possible that the times you experienced slow load up was because the applications were put to sleep? I think unless you have reserved instances, GAE does that to applications that have not been accessed recently. If not, it is slightly disappointing th

[web2py] Re: web2py app not working on gae

Hi Massimo, Thank you for looking into this. The file is VERSION is present at that location. It has the following permissions: -rw-rw-rw- 1 username staff 51 Mar 9 17:27 VERSION Does it need to be executable? For the millionth time thanks for creating web2py and trying to make things su

[web2py] web2py on slant.co

Hi All, Not a question but just wanted to bring this to your attention. Slant.co is a new site whose goal is to allow people to ask questions whose answers may be subjective (such as, what is your favorite web framework). I saw a question on General purpose python web framework and added web2p

[web2py] Re: web2py on slant.co

Forgot to link to the site. Here it is: http://slant.co/topics/general-purpose-python-web-framework-usable-in-production-sites On Sunday, March 10, 2013 1:29:57 PM UTC-4, curiouslearn wrote: > > Hi All, > > Not a question but just wanted to bring this to your attention. > > Slant.co is a new sit

[web2py] Re: Encrypt an email?

Hello! You can try this: http://web2py.com/books/default/chapter/29/08#x509-and-PGP-Encryption 2013. március 10., vasárnap 4:55:06 UTC+1 időpontban a.ma...@hotmail.com a következőt írta: > > I found that website http://www.msgpadlock.com who basically allow you to > encrypt/decrypt a message t

[web2py] Re: My hack to add JSON support to `request.vars`

> > Might be helpful to someone, also maybe we should implement it as > `request.vars.json`, like Python-Requests does? > web2py already supports json input by using the json fieldtype. The following line should add a textarea with json validation in sqlforms (and use native db json type when

[web2py] Re: web2py app not working on gae

When I try to deploy using the admin interface in web2py I get the following for GAE Output: 01:55 PM Host: appengine.google.com 01:55 PM Application: firstappongae; version: 1 Traceback (most recent call last): File "/usr/local/bin/appcfg.py", line 171, in run_file(__file__, globals())

Re: [web2py] Re: Problem with uploading large file web2py version 2.3.2

I am all red. :-( Anyway, I got your name correct in the commit. I should definitively know better. You have an italian name. Massimo On Sunday, 10 March 2013 11:13:20 UTC-5, Ricardo Pedroso wrote: > > On Sun, Mar 10, 2013 at 2:21 PM, Massimo Di Pierro > > wrote: > > This was indeed a problem

Re: [web2py] Re: Problem with uploading large file web2py version 2.3.2

I have a script to automatically group all your aliases when generating the book acknowledgements. ;-) On Sunday, 10 March 2013 11:17:15 UTC-5, Niphlod wrote: > > > >> Massimo, who is Roberto? >> >> If I'm not wrong you are referring to me and I'm Ricardo ;) >> >> Both names have 7 letters and

[web2py] smartgrid showing values from cascading foreign tables.

Don't think smartgrid can do that, try to use grid by passing the query joining 4 tables -- --- 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..

Re: [web2py] Re: web2py 2.4.2 is OUT

Hi, I just tested and it still doesn't work. Windows XP Python 2.7.3 Web2py - Current (2.4.2 2013-03-04 03:26:21) (Stable) Browsers: Internet Explorer 8, Chrome (Version 25.0.1364.160 m), Firefox (19.0.2). I haven't tested on other versions of Windows (such as Vista and 7 for ex) and also on Li

[web2py] Re: How to view primary key selection in the long term

if by "data refreshes" you mean "database restores", than it's more a problem about how you choose to do it vs how web2py does it. I think there are still some problems dumping from admin to csv and reimporting in a blank-slate, but if your database is somewhat "biggie" csv dumps and restores a

[web2py] Re: How to view primary key selection in the long term

do you know if Postgres will pick up where it left off on auto-increment field after database restore? On Sunday, March 10, 2013 11:24:31 AM UTC-7, Niphlod wrote: > > if by "data refreshes" you mean "database restores", than it's more a > problem about how you choose to do it vs how web2py does

[web2py] Re: Problem setting PluginManager options

> Is it a problem with my code or a PluginManager issue?. Well, it is a problem with my code. I tried a simplified plugin setup following the old recipe (third edition) and it works. There's something illegal about the plugin setup (project code) but I cannot figure it out. -- --- You receiv

[web2py] compatibility issue

I'm currently using web2py 2.1.1 and wanted to try 2.4.2 but I got a problem with retrieving uploaded files from the file system. I'm using the retrieve method of the upload field. The problem is in dal.py line 9265 where it returns the file path instead of the stream. stream = pjoin(file_proper

Re: [web2py] 'exceptions.SyntaxError' No fields to update when login on heroku + facebook

Hi, On Sun, Mar 10, 2013 at 5:39 PM, Massimo Di Pierro wrote: > Where is exception raised? We can fix it. gluon/dal.py in update method line 9792, The code (gluon/dal.py): -

Re: [web2py] Re: web2py 2.4.2 is OUT

Not working here, in either Win7 / Chrome or Ubuntu 12.10 / Chromium. On Sun, Mar 10, 2013 at 7:31 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This should now be fixed. Can you check? > > > On Tuesday, 5 March 2013 17:21:03 UTC-6, Ralo Tannahill wrote: >> >> +1 for web2py!! >> >

[web2py] Re: How to view primary key selection in the long term

of course. it wouldn't be a backup if schemas and data are not the same before the backup / after the restore! On Sunday, March 10, 2013 7:54:03 PM UTC+1, Alex Glaros wrote: > > do you know if Postgres will pick up where it left off on auto-increment > field after database restore? > > On Sunday

[web2py] how to send bulk emails with web2py

hi, web2py mail.send checks if mail is sent or not, so if I want to send 1000 emails it will take a while or will break at some point because my server execution time is 30s so please advise me what to do in this case thank you PS: flask-mail has such an example http://pythonhosted.org/Flask-Ma

[web2py] Re: Change upload behaviour: standard filename

Thanks, that's what I was missing. I was thinking they needed to be in a particular controller not in the model. On Tuesday, March 5, 2013 9:02:12 PM UTC-6, Jim Gregory wrote: > > Did you include the code for the store_file and retrieve_file functions > listed in the Stack Overflow answer befor

[web2py] apache non web2py site besides web2py

Hi I like to move an old site to my server this site is static and complete. its basic html so I just want to put it on the server set up the apache and be done with it. my problem is that I don't know how I have to change the apache conf that it still works for web2py and for another site. on

[web2py] bug with onvalidation argument in form.accepts

I'm using the onvalidation argument as a dict to pass a function for onsuccess and onfailure. e.g. if form.accepts(request.vars, formname='client_form', onvalidation=dict( onsuccess=validateClientForm, onfailure=validateClientForm)): The problem is that if onfailure is given as an argument and th

[web2py] Re: how to send bulk emails with web2py

Probably best to add the emails to a queue and then let a scheduler task work its way through the queue separate from the controller. You could also make a modified version of web2py's mail class that sends multiple emails per smtp connection to speed things up. On Sunday, March 10, 2013 2:47:

[web2py] Re: select() - How to fetch specific fields?

Interesting question, I have a similar problem. Really, why can't we select only one field with select() ? For example, If i have several field in table Detailtip2 and want to select only top 10 amounts: rows = db((db.Detailtip2.year==session.year) & (db.Detailtip2.budget==session.budget)).sele

[web2py] Re: select() - How to fetch specific fields?

no.no.no.no. db(query).select(something) returns either None or a list of Row objects each holding only one key, 'something', with the corresponding value. your select should return just the detailtip2.amount field. If it returns the whole detailtip2 table then post the model of that table and

[web2py] Re: compatibility issue

It has always return the file name instead of a stream, except for a trunk version in which we did a test. On Sunday, 10 March 2013 13:58:23 UTC-5, Alex wrote: > > I'm currently using web2py 2.1.1 and wanted to try 2.4.2 but I got a > problem with retrieving uploaded files from the file system.

[web2py] Pass Query to SQLFORM

Hello I am probably going about this wrong. But I am wondering if it is possible to do something like this with SQLFORM so I can pass on successful submission an update saying confirmed = False @auth.requires_login() def edit_listing(): listing_id = request.args(0) query = db((db.listin

[web2py] Re: compatibility issue

Can you check is the current trunk works for you? We are trying to improve the APIs of retrieve. On Sunday, 10 March 2013 13:58:23 UTC-5, Alex wrote: > > I'm currently using web2py 2.1.1 and wanted to try 2.4.2 but I got a > problem with retrieving uploaded files from the file system. I'm using

[web2py] Re: compatibility issue

I guess you meant to say it always returned a stream instead of the file name in your reply above (and not the other way around)? I just saw your recent commit and it works fine again, the retrieve method now returns a stream as excepted. thanks! Am Sonntag, 10. März 2013 23:40:39 UTC+1 schrieb

Re: [web2py] Pass Query to SQLFORM

Ok so after doing a bit more research I have come across this: http://www.web2py.com/examples/static/epydoc/web2py.gluon.sqlhtml.SQLFORM-class.html and I have done this listing_id = request.args(0) query = (db.listing.id[listing_id]) & (db.listing.userinfo[auth.user.id]) form = SQL

[web2py] Re: 'Rows' object has no attribute '_db'

Sure, and thank you for the fast response. I had logged off for the night. Traceback (most recent call last): File "/home/ameteq/webapps/web2py/web2py/gluon/restricted.py", line 204, in restricted exec ccode in environment File "/home/ameteq/webapps/web2py/web2py/applications/sms_test_pr

Re: [web2py] Re: select() - How to fetch specific fields?

On Sun, Mar 10, 2013 at 9:48 PM, Kenan wrote: > Interesting question, I have a similar problem. Really, why can't we select > only one field with select() ? > > For example, If i have several field in table Detailtip2 and want to select > only top 10 amounts: > rows = db((db.Detailtip2.year==sessi

Re: [web2py] Pass Query to SQLFORM

I am now getting this error AttributeError: 'Table' object has no attribute 'SUBSTRING(listing.userinfo,5,(6 - 5))' Using this code listing_id = request.args(0) query = db.listing[listing_id] and db.listing.userinfo[auth.user.id] query = db.listing[query] form = SQLFORM(db.listi

[web2py] Re: 'Rows' object has no attribute '_db'

Also, I should note, this doesn't specifically have to be a SQLForm.grid. I'm just trying to display the results of the query. In my controller I'm using Ext.js to render to the view. So if I could assign the value of the rows object to an Ext.js store or some other mechanism for display that w

[web2py] Re: compatibility issue

No. For uploads stored on filesystem it always returned (filename, fullfilename). For other types of uploads it returned (filename, stream). We tried to change this and return always consistently (filename, stream). There was only one trunk version that did that. It was reverted because of cac

Re: [web2py] Pass Query to SQLFORM

This is not valid dal syntax. Can you explain what is the supposed to do? On Sunday, 10 March 2013 19:00:45 UTC-5, Andrew Evans wrote: > > I am now getting this error > > AttributeError: 'Table' object has no attribute > 'SUBSTRING(listing.userinfo,5,(6 - 5))' > > > Using this code > > listi

Re: [web2py] Pass Query to SQLFORM

the syntax for SQLFORM is: SQLFORM(table, record or record_id) In your first example you were passing a query instead of a record. Now you are passing db.listing[query] . But in this context query should be a record_id instead you are passing db.listing[listing_id] and db.listing.userinfo[au

[web2py] Re: compatibility issue

I have to disagree, unless we're talking about something different... this was definitely standard behavior until recently. I have two older web2py versions which both return a stream. I'm talking about the retrieve method in dal.py, maybe you mean something different? web2py 1.99.2:

[web2py] Re: Problem with smartgrid no GUI Bread Crums or missing buttons for links

My CCS is there and seems to be fine. Any other thoughts ? On Monday, March 4, 2013 9:06:17 PM UTC-6, Dan Kozlowski wrote: > > Does anyone have this same problem with a smart grid ? Running on Linux. > Thanks > > 1.) the word grid is show to the right of the grid > 2.) No boxes for Bread Crums >

[web2py] Re: compatibility issue

You just proved I was wrong. My memory failed me. This is good. This means the current trunk is ok. :-) Massimo On Sunday, 10 March 2013 20:04:25 UTC-5, Alex wrote: > > I have to disagree, unless we're talking about something different... this > was definitely standard behavior until recently.

[web2py] grid/smartgrid searching foreign key tables

I define a table so: db.define_table ('mytable', blah..., format='% (name) s') So as we know, grid will display the contents of the name field when mytable is used as a foreign table. But if you try to search on that field, the search only works if you submit record id integers as search param

[web2py] Re: compatibility issue

great, I almost got confused. current trunk looks fine to me :) -- --- 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 mo

Re: [web2py] Pass Query to SQLFORM

Hi Massimo thank you for you help! What I was trying to do using crud.update initially was have a user update one of their records. When they do this I would like to set a boolean value that is in db.listing named 'confirmed' to False (confirmed=False) which is readable=False and writable=False I

[web2py] how to use web application to send serial commands?

Hello everyone! i am clueless on how to create a web app that allows me to control a device through serial command? Currently my Raspberry Pi acts as a web2py server and it can communicate with the device using netcat and minicom. Can someone give me an idea or example? :) thank you very much!

Re: [web2py] override smartgrid 'add' button

Hi, Your post is a year old by now but I wonder if you find the "right" solution other than hide the "add" link and provide your own? Regards, Yuval On Thursday, May 10, 2012 6:05:53 AM UTC-7, Jim S wrote: > > I would really like to see an option to override the default Add button. > I have