Re: [web2py] Re: Programatically create Row

2021-02-13 Thread David Orme
Thanks for the suggestion. I don't need to create the form programmatically - the factory is great for that. I've already got code to create the form but want to create a dummy row on the server side to populate a display example form. Cheers, David On Sat, 13 Feb 2021, 08:37 Jacinto Parga

[web2py] Programatically create Row

2021-02-12 Thread david...@gmail.com
a sledgehammer to crack a nut. Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google

[web2py] Re: Fixes for uWSGI + ngnix install script in Ubuntu 20.04.01 LTS?

2021-01-07 Thread david...@gmail.com
the case. > > And yes, the Execstart in the uwsgi service should match the options in > the upstart config. On my Debian servers, I have `ExecStart = > /usr/local/bin/uwsgi --emperor /etc/uwsgi/apps-enabled --logto > /var/log/uwsgi/uwsgi.log`, and it works just fine. > > On Frid

[web2py] Re: Fixes for uWSGI + ngnix install script in Ubuntu 20.04.01 LTS?

2020-12-18 Thread david...@gmail.com
Just to add: I fixed the unresolved issues as I typed the email and then forgot to change the opening paragraph, so ignore part (b). Part (a) and part (c) from the first paragraph still apply. On Friday, 18 December 2020 at 11:12:40 UTC david...@gmail.com wrote: > Hi there, > > I

[web2py] Fixes for uWSGI + ngnix install script in Ubuntu 20.04.01 LTS?

2020-12-18 Thread david...@gmail.com
Hi there, I'm trying to set up Web2Py in Ubuntu 20.04.01 LTS using the scripts: https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh It doesn't work. I've been going through it some details and have almost got it working but wanted to (a) check I'm not being

[web2py] Re: problem with error tickets

2020-12-11 Thread David Manns
Solved. I had made a change which involved storing a rows object in the session. This was working (eliminating some duplicated database queries) but evidently interfered with ticketing. Now that I've reversed this ticketing is working fine. On Monday, December 7, 2020 at 6:42:47 PM UTC-5 David

[web2py] Re: Altering reference table format in SQLFORM

2020-08-11 Thread David Orme
Thanks! I had played with the represent attribute, with no success, but using that first option within the controller works. Changing the validator seems a bit over the top just to change the format, but it works! On Tuesday, 11 August 2020 16:07:36 UTC+1, villas wrote: > > Off the top of my

[web2py] Altering reference table format in SQLFORM

2020-08-11 Thread David Orme
I'm sure I'm missing something obvious but I am trying to alter the representation of a referenced field in a SQLFORM and failing hopelessly (Web2Py 2.20.4 on Python 3.7.7). The two tables involved are: db.define_table('markers', Field('first_name','string'),

[web2py] Re: changing default redirect after failed login attempt.

2020-08-10 Thread David Orme
Just to note that I had a similar fix to make and I think this solution is flawed: > auth.settings.controller = 'plugin_user_admin' > > It's exactly the right setting, but initialising an Auth instance uses `settings.controller` to initialise a whole bunch of links and I don't think these

[web2py] Re: import_from_csv_file and auth.signature

2020-07-24 Thread David Orme
Well now that is embarrassing. Thanks! For reference, this was my recipe to put at the top of a file that is going to populate multiple tables: if db(db.auth_user).count() == 0: #Bulk load account admin_user_id = db.auth_user.insert(first_name='Bulk uploader') else: admin_user_id =

[web2py] import_from_csv_file and auth.signature

2020-07-24 Thread David Orme
onical way to handle this? I had a quick look at the code and couldn't see an option for inserting default values. I can write a loop and add default values myself to individual record inserts but is there a standard way? Many thanks, David -- Resources: - http://web2py.com - http://web2py.com

Re: [web2py] Re: Mac Catalina 10.15.4 - Cannot run web2py binary

2020-04-21 Thread David Swarbrick
I had a similar problem a few days ago. The answer I received was effective. On windows Ensure python is pathed. Extract the source files from the .zip file to a directory. Run dos box or Switch to the new directory created, and run python web2py.py David Swarbrick da...@swarb.co.uk - dsw

[web2py] Reload login page needed after first attemp fails.

2020-04-20 Thread David Fuertes
Hello, I'm a default controller doing a redirection to another controller. [default] @auth.requires_login() def index(): redirect(URL('another_controler', my_funtion) I have a custom login method: pop3 authentication server wich return true or false if login password match with email

Re: [web2py] Which 4 or 2?

2020-04-18 Thread David Swarbrick
Thank you for the encouragement, and the really useful resources identified. I think I have to work through the book, and where something really is not understandable (for me), keep going back a few pages and trying again. David Swarbrick da...@swarb.co.uk - dsw...@gmail.com - swarb.co.uk Tel

Re: [web2py] Which 4 or 2?

2020-04-17 Thread David Swarbrick
py*, is easy to learn and I believe > that fit better to your site, py4web is really good and more faster, but in > web2py you have more tools to do things. > The transition after from web2py to py4web is not difficult. > > Cheers. > Chris. > > El vie., 17 abr. 2020 a las

[web2py] Which 4 or 2?

2020-04-17 Thread David Swarbrick
I have a UK case law database presently viewable at swarb.co.uk. The output is via WordPress. In better times we have had over 30k page views in a day. Presently I maintain it entirely using an ancient MS Access database. I need to move to a point where I have a sustainable and up to date

Re: [web2py] Installation

2020-04-05 Thread David Swarbrick
and run > python3 web2py.py. > > That should get you going. > > > > On Sun, 5 Apr 2020, 12:20 David Swarbrick, > > wrote: > >> I also tried the alternative suggestion on the installation page of >> running >> >> python web2py.py >> >

Re: [web2py] Installation

2020-04-05 Thread David Swarbrick
I also tried the alternative suggestion on the installation page of running python web2py.py . . but there is of course no such file in the directory. There are plenty of .pyd files (what are they?), but no .py files. And again - many thanks On Sunday, 5 April 2020 11:08:30 UTC+1, David

Re: [web2py] Installation

2020-04-05 Thread David Swarbrick
Many thanks That worked so that I could see the error message: Traceback (most recent call last): File "", line 6, in File "__main__.py", line 128, in File "__main__web2py__.py", line 33, in TypeError: start() takes no arguments (1 given) David Swa

[web2py] Installation

2020-04-05 Thread David Swarbrick
Seeking to run web2py on a windows 10 machine I downloaded and extracted all to a directory. I click on web2py.exe in that directory. It looks like it is throwing up a dos box, but the box just closes and exits. I have python 3.7 installed elsewhere. Any suggestion (please) where I might

[web2py] initial start server screen - i get a pbkdf2_hmac error - python ver problem?

2020-03-17 Thread David Wilkens
hey i'm new. i hope someone can help me. I have a mac and installed web2py. When setting the password on the initial start server screen i get a pbkdf2_hmac error. I believe it is a version problem. I have the original 2.7 that came w my OSX, but also 3.6.3 IDLE install. Can I get web2py to

[web2py] pbkdf2_hmac Err on start server

2020-03-17 Thread David Wilkens
First time installing web2py. Have PyCharm and pythonanywhere running. Help! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message

[web2py] web2py represent_none in SQLFORM.smartgrid in combination with date field throws exception

2020-02-25 Thread David Zejda
or: 'str' object has no attribute 'year' The problem occurs even if IS_DATE validator is not specified for the field. I have not checked it, but other validators might be affected too. web2py 2.18.5-stable+timestamp.2019.04.08.04.22.03 python 3.7.3 Have a nice day! David -- Resources: - http

Re: [web2py] Digest for web2py@googlegroups.com - 1 update in 1 topic

2020-02-01 Thread david jensen
se you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest_medium=email#!forum/web2py/join> > . > To unsubscribe from this group and stop receiving emails from it send an >

[web2py] Re: Progressive Web Apps

2019-12-04 Thread David Zejda
}} {{if 'cust_style' in response:}} {{=XML(response.cust_style)}} {{pass}} {{if 'cust_js' in response:}}{{=XML(response.cust_js)}} {{pass}} {{include}} {{block page_js}}{{end page_js}} David -- Resources: - http://web2py.com

[web2py] Re: how to specify python3 for wsgihandler

2019-12-04 Thread David Zejda
hope it helps someone ... David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups

[web2py] Re: how to specify python3 for wsgihandler

2019-11-22 Thread David Zejda
ports for HTTP and HTTPS, which seems a better solution than proxying from one Apache instance to the other. David On Monday, 11 November 2019 23:42:56 UTC+1, David Zejda wrote: > > Hello to all. > > I have a web2py with several apps on a production server behind Apache > accessed

[web2py] py4web and Eclipse/PyDev

2019-11-13 Thread David Zejda
b, loc) File "/opt/py4web/py4web-start.py", line 3, in from py4web.core import main File "", line 983, in _find_and_load File "", line 152, in __exit__ File "", line 107, in release RuntimeError: cannot release un-acquired lock With regards, D

[web2py] how to specify python3 for wsgihandler

2019-11-11 Thread David Zejda
specify the python version? Thank you very much for an answer in advance! David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received

[web2py] Re: error tickets missing error snapshot details

2019-10-23 Thread David Manns
, David Manns wrote: > > In my development environment, on Windows, with web2py 2.18.5, error > tickets are truncated, no details are displayed. An example is included > below. The ticket file is only ~2kb, so the stored ticket is actually > truncated. Any idea why this is happening?

[web2py] error tickets missing error snapshot details

2019-10-23 Thread David Manns
ceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. Traceback (most recent call last): File "C:\Users\David\Google Drive\My Documents\OxCamNE.3.0\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\Users\David\Google Drive\My Documents

[web2py] Re: 2.18.5 appadmin database administration fails when trying to edit record.

2019-06-07 Thread David Manns
This is a duplicate of https://groups.google.com/forum/#!topic/web2py/2oVcXiUCAiE this one originally seemed to disappear so I resubmitted it. On Thursday, June 6, 2019 at 11:10:14 AM UTC-4, David Manns wrote: > > Here is my table definition: > > db.define_table('AccTrans',

Re: [web2py] appadmin database administration fails when trying to edit record

2019-06-07 Thread David Manns
Yes, I'm pretty sure it worked fine with 2.14.6! On Friday, June 7, 2019 at 5:42:12 PM UTC-4, Dave S wrote: > > > > On Friday, June 7, 2019 at 8:43:43 AM UTC-7, David Manns wrote: >> >> It turns out the orderby is redundant. >> >> Field('Account', '

Re: [web2py] appadmin database administration fails when trying to edit record

2019-06-07 Thread David Manns
o reference the COA, instead of > the ID. > > http://www.web2py.com/books/default/search/29?search=IS_IN_DB > > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > > > On Thu, Jun 6, 2019 at 10:25 AM

[web2py] appadmin database administration fails when trying to edit record

2019-06-06 Thread David Manns
. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "C:\Users\David\Google Drive\My Documents\OxCamNE.3.1\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\Users\David\Google Dri

[web2py] 2.18.5 appadmin database administration fails when trying to edit record.

2019-06-06 Thread David Manns
timestamp.2019.04.08.04.22.03 Python Python 2.7.14: C:\Python27\python.exe (prefix: C:\Python27) Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "C:\Users\David\Google Drive\My Documents\OxCamNE.3.1\gluon\restri

[web2py] Re: Using parse_as_rest: problem with cross joins?

2019-05-19 Thread David Orme
Sorry, being dim. The web2py repo links out to pydal, so I can just clone web2py/web2py. Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] Re: Using parse_as_rest: problem with cross joins?

2019-05-19 Thread David Orme
n that zip. Is it reasonable to drop a clone of pydal/pydal into packages or is there a release coming out shortly with the new api in it? Thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

[web2py] Using parse_as_rest: problem with cross joins?

2019-05-17 Thread David Orme
uot;latest" = 'T') ESCAPE '\'))); then I get rows like this: latest | id | dataset_id -+-+ T | 134 |177 T | 134 |177 T | 134 |177 T | 134 |180 T | 134 |180 T | 13

[web2py] Re: Problem with admin debugger still in 2.17.1

2019-04-17 Thread David Manns
an error on the console "*** DO_CLEAR failed Non-numeric breakpoint number (all})" On Saturday, October 6, 2018 at 3:07:30 PM UTC-4, Massimo Di Pierro wrote: > > We will address this in 2.17.3 > > On Friday, 5 October 2018 13:52:17 UTC-7, David Manns wrote: >> >

[web2py] Re: Smartgrid link very slow.

2019-04-16 Thread David Manns
, db.Members.ALL, left=[db.Colleges.on(db.Colleges.id==db.Affiliations.College), db.Members.on(db.Members.id==db.Affiliations.Member)], ... takes no time at all. On Monday, April 15, 2019 at 12:24:44 PM UTC-4, David Manns wrote: > > > here is my smartgrid (s

[web2py] CORS headers on static file

2019-04-16 Thread David Orme
static resources. I could wrap them up in a service and cache them, but is there a way to preserve the existing path and adjust the CORS headers? A quick look at gluon/main.py makes it seem tricky, but there are a lot of moving parts in there! Cheers, David -- Resources: - http://web2p

[web2py] Smartgrid link very slow.

2019-04-15 Thread David Manns
here is my smartgrid (simplified to show only essential pieces): grid = SQLFORM.smartgrid(db.Members, linked_tables=['Affiliations'], constraints=dict(Members=query), deletable=False, details=False, editable=True, create=True) Members is a table

[web2py] Re: Custom validator broken in 2.18.4, working in 2.17.2

2019-04-09 Thread David Manns
The original version works with 2.18.5 Thank you! On Thursday, April 4, 2019 at 4:52:37 PM UTC-4, David Manns wrote: > > The table in question has a field: > > Field('Paiddate', 'date', requires = [IS_EMPTY_OR(IS_DATE()), > IS_EMPTY_OR(IS_MEMBERSHIP_YEAR_END())]), > >

[web2py] Re: Custom validator broken in 2.18.4, working in 2.17.2

2019-04-06 Thread David Manns
PS this is not backward compatible to 2.17.2 On Thursday, April 4, 2019 at 4:52:37 PM UTC-4, David Manns wrote: > > The table in question has a field: > > Field('Paiddate', 'date', requires = [IS_EMPTY_OR(IS_DATE()), > IS_EMPTY_OR(IS_MEMBERSHIP_YEAR_END())]), > >

[web2py] Re: Custom validator broken in 2.18.4, working in 2.17.2

2019-04-06 Thread David Manns
, David Manns wrote: > > The table in question has a field: > > Field('Paiddate', 'date', requires = [IS_EMPTY_OR(IS_DATE()), > IS_EMPTY_OR(IS_MEMBERSHIP_YEAR_END())]), > > The custom validator is: > > class IS_MEMBERSHIP_YEAR_END(object): > def __init__(self, e

[web2py] Re: Custom validator broken in 2.18.4, working in 2.17.2

2019-04-06 Thread David Manns
™ Version 2.18.4-stable+timestamp.2019.03.13.05.27.54 Python Python 2.7.14: C:\Python27\python.exe (prefix: C:\Python27) Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. Traceback (most recent call last): File "C:\Users\

[web2py] Re: Custom validator broken in 2.18.4, working in 2.17.2

2019-04-05 Thread David Manns
Created a ticket: https://github.com/web2py/web2py/issues/2170 On Thursday, April 4, 2019 at 4:52:37 PM UTC-4, David Manns wrote: > > The table in question has a field: > > Field('Paiddate', 'date', requires = [IS_EMPTY_OR(IS_DATE()), > IS_EMPTY_OR(IS_MEMBERSHIP_YEAR_END())]),

[web2py] Custom validator broken in 2.18.4, working in 2.17.2

2019-04-04 Thread David Manns
(most recent call last): File "C:\Users\David\Google Drive\Oxcamne Archive\Web Site\OxCamNE.2.1\gluon\html.py", line 1890, in _validate (value, errors) = validator(value) File "C:\Users\David\Google Drive\Oxcamne Archive\Web Site\OxCamNE.2.1\gluon\packages\dal\pydal\valid

[web2py] Return random row on left join in one to many

2019-04-02 Thread David Orme
':2}, {'tx_id': 2, 'val':3}, {'tx_id': 2, 'val':4}) What I'm after is something that returns: [('a', 1), ('b', 3), ('c', None)] and where `a` will get 1 or 2 and `b` will get 3 or 4 randomly. Thanks, David -- Resources: - http://web2py.com

[web2py] Re: AWS Lambda Serverless and Zappa

2019-03-22 Thread David Orme
of it for caching. That seems to be a very similar approach to what you've done - now.sh uses AWS Lambdas under the hood - and the configuration set up of zappa looks similar to now.sh. It would be good to get some guidance if you've already solved some of the problems! Cheers, David On Friday, 23

[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread David Orme
']) --- ProgrammingError Traceback (most recent call last) # ProgrammingError: ('ERROR', '22023', 'Geometry SRID (4326) does not match column SRID (4087)') I don't think this breaks any existing functions. Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread David Orme
I guess more generally there is an issue with having to do a round trip through WKT to update a record - it loses precision and is there is an explicit warning about using it for passing data: http://postgis.org/docs/ST_AsText.html I don't see any point in altering how the select represents

[web2py] ST_Transform in GIS support

2019-03-19 Thread David Orme
o either: transformed = db(db.transform_test.id == 2).select(db.transform_test.point. st_transform(4087).st_astext().with_alias('wec')).first() rec = db.transform_test[2] rec.update_record(point_wec = transformed['wec']) # or db(db.transform_test.id == 2).update(point_wec = db.transform_test.point. st

[web2py] Re: Geometry fields and validators

2019-03-15 Thread David Orme
elect st_geomfromtext('{}');".format(geometry)) except db._adapter.driver.ProgrammingError: raise HTTP(404, "Invalid WKT Geometry") Cheers, David On Friday, 15 March 2019 13:21:43 UTC, David Orme wrote: > > > Hi, > > I'm looking for an approach to validate a user pr

[web2py] Geometry fields and validators

2019-03-15 Thread David Orme
mmingError: raise HTTP(404, "Invalid WKT Geometry") I suspect that is probably pretty robust across backends but am I missing something more general? Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

Re: [web2py] Re: Left join with filters on joined table

2018-11-25 Thread David Orme
groupby=db.sites.id) Thanks again, David On Saturday, 24 November 2018 23:20:31 UTC, Val K wrote: > > Try to move db.audio.start_time > '12:00:00' in the left join ON: > left=db.audio.on((db.audio.site_id == db.sites.id) & (db.audio.start_time > > '12:00:00')) > > >

Re: [web2py] Re: Left join with filters on joined table

2018-11-24 Thread David Orme
the left join to get reduced. I have to admit I'm not completely sure why, but the SQL examples show it happening! David On Sat, 24 Nov 2018, 22:18 Val K try remove db.sites from query (just db().select(...)) > db(db.sites) is shortcut for db(db.sites.id>0) which turns into WHERE > (

[web2py] Left join with filters on joined table

2018-11-24 Thread David Orme
assing request.vars to a handler that can be shared by different calls and returns a suitably tweaked subset of audio to be searched, but it seems like I need to pass the filters in somewhere else. Thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gith

[web2py] Other Recipes - Stripe - in the manual out of date.

2018-10-10 Thread David Manns
I recently implemented stripe checkout in my site which runs on Pythonanywhere. Initially, I followed the recipe in the manual, using /gluon/contrib/stripe.py. Worked in local test, but failed on my test site which is a free Pythonanywhere account, although PA say Stripe is whitelisted. The

Re: [web2py] Re: Using Stripe's Checkout w/ web2py

2018-10-10 Thread David Manns
I know your post is a long time ago, but since I have just been dealing with the same issue ... Initially, I followed the implementation described in the web2py manual, using /gluon/contrib/stripe.py. This worked locally but not on my (free) test account at PA. I re-implemented, following the

[web2py] Re: Occasional weirdness in 2.17.1 PyDal?

2018-10-09 Thread David Manns
Thanks, I think this is it. In the normal case session.email would not be None at this point but I think its possible to force this with the use of the browser back key after logging off, I hadn't thought of that. Duh... On Monday, October 8, 2018 at 7:46:59 PM UTC-4, Leonel Câmara wrote: > >

[web2py] Occasional weirdness in 2.17.1 PyDal?

2018-10-08 Thread David Manns
A well trodden path through my code seems to fail occasionally as below. The statement which fails: rows = db(db.Members.Alias.contains(session.email, case_sensitive = False)).select() rows in db.Members contain a column Alias which is 'list:string' containing a set of alternate email

[web2py] Problem with admin debugger still in 2.17.1

2018-10-05 Thread David Manns
I occasionally use the admin debugger package to investigate problems when running in my test environment on Windows 10 using the source distribution of web2py and Python 2.7 When I place a breakpoint on the code and execute my test case the interactive debugger is triggered, and I can step

[web2py] Re: web2py 2.17.1

2018-10-05 Thread David Manns
I have this problem too, there are a few forms where for information clarity I want to show fields which cannot be changed in a particular context. On Monday, October 1, 2018 at 7:43:06 AM UTC-4, Awe wrote: > > Well, yes I think it breaks something, > in 2.16.1 this was fine: > form =

Re: [web2py] Digest for web2py@googlegroups.com - 11 updates in 2 topics

2018-07-28 Thread david jensen
and, therefore be an addition to Python frameworks that beat node? David Jensen On Jul 28, 2018 4:44 PM, wrote: > web2py@googlegroups.com > <https://groups.google.com/forum/?utm_source=digest_medium=email#!forum/web2py/topics> > Google > Groups > <https://groups.goog

[web2py] Re: Docker Image for CentOS and Alpine

2018-04-24 Thread David Sperling
We are looking for a way to bypass the admin application security checks when running in a container. Any suggestions? The issue and detailed questions are here: https://github.com/web2py/web2py/issues/1913 On Friday, April 20, 2018 at 11:32:45 AM UTC-7, David Sperling wrote: > > We hav

[web2py] Docker Image for CentOS and Alpine

2018-04-20 Thread David Sperling
We have been using Web2py for several years and are now Dockerizing our solution for a cloud deployment. After looking through the existing Docker solutions, we did not find a project that met our requirements: - Based on CentOS (Alpine is supported as well) - Void of HTTPS support - we

[web2py] Setting session cookie expiration

2018-03-21 Thread David Manns
In the past my site has used two variations of login. For internal users with comprehensive access to our database, it has used a conventional email + password implemented via Auth. For a broader population of users who interact with the site to maintain their membership and register for events

[web2py] Re: web2py debugger breakpoint works once only in 2.16.1

2018-03-18 Thread David Manns
Once a single breakpoint has been triggered, no combination of clearing breakpoints, setting new breakpoints work. The new breakpoints show on the breakpoints as being set, but they do not trigger. This is definitely a bug, don't understand why this was marked as 'no action needed' David

[web2py] web2py debugger breakpoint works once only in 2.16.1

2018-03-12 Thread David Manns
This can be demonstrated with the welcome app. Start web2py Display the admin page, go into debug, breakpoints and set breakpoint on line 9 of the welcome app default.py Launch the welcome page - the breakpoint is hit. Click continue ... the welcome page displays The admin/breakpoint page

[web2py] Re: query to match if boolean field is not True

2018-02-12 Thread David Zejda
On Sunday, 11 February 2018 05:52:44 UTC+1, Massimo Di Pierro wrote: > > I would expect that too but it is not a web2py issue. It is a database > issue. web2py simply translate those in > Hi Massimo, thank you for explanation! David -- Resources: - http://web2py.com - http://web

[web2py] query to match if boolean field is not True

2018-02-06 Thread David Zejda
as expected. David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread David Orme
= os.path.join(request.folder, 'uploads', 'datasets', str(record.dataset_id), record.file) stream = open(path, 'rb') return response.stream(stream) On Saturday, 3 February 2018 21:44:23 UTC, David Orme wrote: > > Thanks, Anthony. So to sum up what I think the options are: > &

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread David Orme
link that points to the record rather than just the filename, but doesn't get around the need for a custom download function. On Saturday, 3 February 2018 17:37:32 UTC, Anthony wrote: > > On Saturday, February 3, 2018 at 1:58:26 AM UTC-5, David Orme wrote: >> >> So at the

[web2py] Re: web2py behind Apache with virtualhosts and SSL (SNI) leads to SSL_ERROR_RX_RECORD_TOO_LONG

2018-02-03 Thread David Zejda
' SSL started working normally. :) What initially confused me, that the problem appeared only for sites served by web2py. But I must admit that the problem really lied in the config. Truly, redirecting both HTTP and HTTPS requests to a HTTP site was not a bright idea. David -- Resources: - http

[web2py] Re: Download link for dynamic upload folder

2018-02-02 Thread David Orme
to find the end character of the lambda function. So, if that isn't possible, then I need a custom view of the record, which represents the file with a custom download function that I can pass new_ds_id to? On Friday, 2 February 2018 22:04:26 UTC, David Orme wrote: > > Hi, > > I'

[web2py] Download link for dynamic upload folder

2018-02-02 Thread David Orme
into field.retrieve and it looks like I should be able to set a custom_retrieve, but I can't find example usage. Any suggestions? Many thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

2018-02-02 Thread David Zejda
Hi, If you can, please list Open-IT cz, s.r.o. (Czech Republic) as well. Main website is https://www.o-it.info made in Zope. Though it should be replaced with something fresher. But, IMO, it is not as ugly that it could not be listed.. We have a plenty of web2py-based projects, such as:

[web2py] web2py behind Apache with virtualhosts and SSL (SNI) leads to SSL_ERROR_RX_RECORD_TOO_LONG

2018-02-02 Thread David Zejda
. :( Thank you very much for any idea! with regards David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you

[web2py] API for database sequence?

2018-02-01 Thread David Orme
. I can always create the sequence manually on the backend and then use: next_val = db.executesql("select nextval('unique_id_seq');") But is there an elegant way to do this within pydal? It would be nice to define the sequence in the model in the same way that tables are defined. Tha

[web2py] Custom Register Page

2018-01-02 Thread David Cabeza
Hello, I am making a register page because in my system, users are registered by certain users (administrators) with that permission. I can't use web2py custom register form because when I place auth.register() in the controller I'm being sent to index (because I am logged in) The thing is

[web2py] Re: Sharing function between controller and scheduler

2017-08-17 Thread David Orme
processes were started when the old version was in place? Do you need to restart the workers after updating python modules? I've added new modules, so maybe new modules get added, but existing ones use the version in place when the worker started? Thanks, David On Thursday, 17 August 2017 11:22

Re: [web2py] Sharing function between controller and scheduler

2017-08-17 Thread David Orme
Aha. That is very helpful. Thanks very much. Cheers, David > On 17 Aug 2017, at 14:20, Leonel Câmara <leonelcam...@gmail.com> wrote: > > That seems fine to me. Note however that you can know if the function is > being run by the scheduler looking at request.is_scheduler &g

[web2py] Sharing function between controller and scheduler

2017-08-17 Thread David Orme
it is run from the website. Is this a problem, either for overhead or for the database? Are there any other issues which mean I should keep the scheduler version and controller version separate? Thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http

[web2py] Accessing all attributes for all SQLFORM grid rows

2017-07-19 Thread David Orme
Hi, I've got a controller that is serving up a searchable SQLFORM grid of some map locations along with a Leaflet map containing the locations. The underlying table looks like this: db.define_table('gazeteer', Field('location', 'string', unique=True), Field('type', 'string',

[web2py] Re: Representing field in IS_IN_DB

2017-06-27 Thread David Orme
, 'project_details.project_id', '(%(project_id)s) %(title)s', zero='Select project.') Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] Representing field in IS_IN_DB

2017-06-27 Thread David Orme
uires = IS_IN_DB(query, 'project_id.id', '(%(id)s) %(db.project_details.title)s', zero='Select project.') Any solutions? Many thanks, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.c

[web2py] Re: GET queries other than ID

2017-04-30 Thread David Shavers
Hey, Anthony here is the finished product of what i was working on. It's an android app that lets you rent out your property to strangers. The payments and database are handled by web2py. https://play.google.com/store/apps/details?id=com.jbtus.daybyday=en=downloadatoz.com Also, how do i do

Re: [web2py] Re: Open Sourced dating website

2017-04-28 Thread David Shavers
Bump -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To

[web2py] Re: GET queries other than ID

2017-04-24 Thread David Shavers
Sweet, thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py] Re: GET queries other than ID

2017-04-24 Thread David Shavers
Hey Anthony, Thanks for replying. So what you're saying is that the auto generated value for cost_per_night is trying to get me to put in two integers and that the resulting json will be a range withing those two? For example: the link you posted would give me all of the values between 25 and

Re: [web2py] Re: Open Sourced dating website

2017-04-24 Thread David Shavers
I've been trying to keep spam accounts to a minimum, but I do agree that I should provide a test account for other developers to browse. Username: alex101 Password: alex101 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

Re: [web2py] IMPORTANT - WEB2PY CONSULTING

2017-04-24 Thread David Shavers
Hey Richard, I've been trying to keep spam accounts to a minimum, but I do agree that I should provide a test account for other developers to browse. Username: alex101 Password: alex101 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] IMPORTANT - WEB2PY CONSULTING

2017-04-24 Thread David Shavers
Hi, I have a dating website that uses a lot of web2py features. I know android and web2py and can help bring people up to speed if they need. www.jbtus.com Contact - www.facebook.com/shaversapps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] GET queries other than ID

2017-04-24 Thread David Shavers
Bump -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To

[web2py] GET queries other than ID

2017-04-21 Thread David Shavers
Hi, How do I GET data by using the "cost-per-night" url? ID works fine, but that's the only thing that does. www.example.com/app/default/api/patterns gives me this: /room_owner[room_owner] /room-owner/id/{room_owner.id} /room-owner/id/{room_owner.id}/:field

Re: [web2py] Re: Open Sourced dating website

2017-04-21 Thread David Shavers
Haha thanks a lot Massimo, your acknowledgement makes me want to code better -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message

Re: [web2py] Re: Open Sourced dating website

2017-04-16 Thread David Shavers
Includes forum, feed similar to that of Facebook, user to user messaging, gender sorting, preference sorting, sexual orientation sorting, group chats, picture uploading, user profiles, etc -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: Open Sourced dating website

2017-04-16 Thread David Shavers
Bump, Fully featured dating website. If you have any ideas of what you would like to see added let me know and I will try to do it and then open source it. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

  1   2   3   4   5   6   7   8   9   10   >