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 Jac

[web2py] Programatically create Row

2021-02-12 Thread david...@gmail.com
ing 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 G

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

2021-01-07 Thread david...@gmail.com
at's no longer 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 fin

[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&#x

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

[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

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

[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'), Fiel

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

[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 = d

[web2py] import_from_csv_file and auth.signature

2020-07-24 Thread David Orme
hen that import is run - the `auth.signature` fields are None and so that is the constraint that is failing. Is there a canonical 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

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 pas

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 editi

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

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

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

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

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

2020-02-01 Thread david jensen
op> > You received this digest because 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&utm_medium=email#!forum/web2py/join> > . > To unsubscribe from this gro

[web2py] Re: Progressive Web Apps

2019-12-04 Thread David Zejda
out like this: {{=response.title}} {{if 'cust_style' in response:}} {{=XML(response.cust_style)}} {{pass}} {{if 'cust_js' in response:}}{{=XML(response.cust_js)}} {{pass}} {{include}} {{block page_js}}{{e

[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
fault 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 > acce

[web2py] py4web and Eclipse/PyDev

2019-11-13 Thread David Zejda
e(contents+"\n", file, 'exec'), glob, 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 Runtime

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

[web2py] Re: error tickets missing error snapshot details

2019-10-23 Thread David Manns
UTC-4, 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 happen

[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('AccTr

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('A

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

2019-06-07 Thread David Manns
y= > db.CoA.Name)), > > To me, it looks like you are using "name" to 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 Su

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

2019-06-06 Thread David Manns
IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'CoA.Name')] appadmin displays table rows just fine. clicking a record link in the id column to edit the record fails: Ticket ID 127.0.0.1.2019-06-06.11-23-25.64b3e296-56e8-4c9f-a875-5a0ae496f620 'Account.Name' Version web2py™ Version 2.18

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

2019-06-06 Thread David Manns
OT_EMPTY(), IS_NOT_IN_DB(db, 'CoA.Name')] Database administration displays the table rows just fine. Clicking on a record's id field should display the record for editing. Instead I get an error, looks like when its setting up the widget for the first reference field. In my applicati

[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
s in 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

[web2py] Using parse_as_rest: problem with cross joins?

2019-05-17 Thread David Orme
27;) AND ("datasets"."latest" = 'T') ESCAPE '\'))); then I get rows like this: latest | id | dataset_id -+-+ T | 134 |177 T | 134 |177 T | 134 |177 T

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

2019-04-17 Thread David Manns
puts 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
ice() What I can't figure out how to do is to provide those headers for some 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 the

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

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

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

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

2019-04-06 Thread David Manns
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())]), > > The custom validator is: > > class IS_MEMBERSHIP_YEAR_EN

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

2019-04-06 Thread David Manns
n web2py™ 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 "

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

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

2019-04-04 Thread David Manns
7.0.0.1:8000/') starting browser... Traceback (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\We

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

2019-04-02 Thread David Orme
Field('val', 'integer')) db.tx_vals.bulk_insert([{'tx_id': 1, 'val':1}, {'tx_id': 1, 'val':2}, {'tx_id': 2, 'val':3}, {'tx_id'

[web2py] Re: AWS Lambda Serverless and Zappa

2019-03-22 Thread David Orme
t 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

[web2py] Re: ST_Transform in GIS support

2019-03-19 Thread David Orme
ound trip through WKT. Note also that the extended WKB provided by PostGIS contains a reference to the geometry SRID, so trying to update a field with a different SRID gets caught, as you might hope. In [10]: rec.update_record(point_wec=copy_wkb['wkb']) ------- ProgrammingError

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

[web2py] ST_Transform in GIS support

2019-03-19 Thread David Orme
{'ST_AsText(ST_Transform("transform_test"."point",4087))': 'POINT(333958.472379821 0)'}}] I've chosen the WEC projection because that is easy to verify that a point 3 degrees east along the equator from the origin has a X cooordinate in WEC of 1/120th of the

[web2py] Re: Geometry fields and validators

2019-03-15 Thread David Orme
cutesql("select 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

[web2py] Geometry fields and validators

2019-03-15 Thread David Orme
) except ProgrammingError: 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/

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

2018-11-25 Thread David Orme
audio.on(qry), 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

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

2018-11-24 Thread David Orme
de), cause 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 int

[web2py] Left join with filters on joined table

2018-11-24 Thread David Orme
t figure out how to pass them into the DAL. Any suggestions? I'm keen on the concept of passing 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

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

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

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

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

[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 = SQLFORM.fa

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

2018-07-28 Thread david jensen
, 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&utm_medium=email#!forum/web2py/topics> > Google > Groups > <https://groups.google.

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

[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&#

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

[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
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
#x27;Content-Disposition'] = file_header # get a stream of the file path = os.path.join(request.folder, 'uploads', 'datasets', str(record.dataset_id), record.file) stream = open(path, 'rb') return response.stream(stream) On Saturday, 3 Fe

[web2py] Re: Download link for dynamic upload folder

2018-02-03 Thread David Orme
at would derail the upload widget in the SQLFORM edit view but it doesn't seem to. Its probably a simpler way to get a custom download 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

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

[web2py] Re: Download link for dynamic upload folder

2018-02-02 Thread David Orme
I think that is field.retrieve firmly expecting a string and trying 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,

[web2py] Download link for dynamic upload folder

2018-02-02 Thread David Orme
rk. I've had a look at the source for response.download, heading 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 (Document

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

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

2018-02-02 Thread David Zejda
sion is that the problem indeed has something to do with web2py. But I am not sure what to try as a next step. :( 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)

[web2py] API for database sequence?

2018-02-01 Thread David Orme
got simple integers. 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

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

[web2py] Re: Sharing function between controller and scheduler

2017-08-17 Thread David Orme
s it that the worker 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 Thurs

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

[web2py] Sharing function between controller and scheduler

2017-08-17 Thread David Orme
ommit when 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 (Documentati

[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', requires=IS

[web2py] Re: Representing field in IS_IN_DB

2017-06-27 Thread David Orme
res = IS_IN_DB(query, 'project_details.project_id', '(%(project_id)s) %(title)s', zero='Select project.') Cheers, David -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

[web2py] Representing field in IS_IN_DB

2017-06-27 Thread David Orme
D number, which is going to be confusing. What I'd like to do is change the representation of the dropdown so that it uses the project ID and project title, but only the id is stored in the datasets table. I guess I was hoping that something like this would work: db.datasets.project_id.requires = IS_IN_DB(query,

[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&hl=en&source=downloadatoz.com Also, how

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 u

[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" g

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

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) - http://github.com/web2py/web2

[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) - http://github.com/we

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

[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 /room-owner/cost-per-night/{room_

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 be

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) - http://github.com/web2py/web2

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) - https://code

  1   2   3   4   5   6   7   8   9   10   >