[web2py] Re: additional software to run postgreSQL/postGIS on web2py

2015-11-16 Thread Pierre
Thanks Leonardo, I think I got this thing working since yesterday I installed both postgresql 9.3 and the ubuntu postgis extension package, created a db and the web2py dal connection seems to work sorry but i know nothing about SQL databases (used ZOPE and PLONE so far that is ZODB) -- Res

[web2py] Re: ignore_field_case

2015-11-16 Thread Annet
Hi Anthony, Thanks for your reply. Note sure if the above is your actual code, but I think you wanted: > > db.ignore_field_case = myconf.take('ignore_field_case', cast=lambda value: > bool(int(value))) > This is my actual code for the connection string: db = DAL(myconf.take('db.uri'), pool_s

[web2py] Photoswipe on web2py?

2015-11-16 Thread Mark Abajian
Dear web2py Community, I have been using web2py for several years on and off. I would like to incorporate the PhotoSwipe lightbox (javascript) (http://photoswipe.com) onto my gallery page with thumbnails. Has anyone had any success with this? I found a tutorial online (http://webdesign.tutsp

[web2py] Re: getting confused when running select on joined tables

2015-11-16 Thread Red Beard
Hey, My answer won't answer your question directly - but Massimo made some amazing videos which I came across the other day: https://vimeo.com/album/3016728 - check out no.10 and 11 for details on the DAL he goes into detail about queries etc. Being a complete beginner they have really helped

[web2py] appadmin not updating: update=request.utcnow

2015-11-16 Thread Robin Manoli
Hey, I have the following field on some tables: *Field( 'updated_at', 'datetime', update=request.utcnow, writable=False, readable=False )* I want it to keep track of the last update of a row. It however remains with the created_at value. I think this has worked before. Can the problem be that

[web2py] Re: appadmin not updating: update=request.utcnow

2015-11-16 Thread Red Beard
Hey, I'm only just learning so this response may not be helpful?! The way I understand, appadmin is just a GUI for the database tables you have, so I don't think that is the problem.. The auth tables can keep track of: - created_on - created_by - modified_on - modified_by Add a

[web2py] Re: ignore_field_case

2015-11-16 Thread Anthony
Sorry, I misunderstood your configuration and what you were trying to do. The ignore_field_case setting does not affect searching for values within string fields -- rather, it ignores the case of the field name itself when creating new fields in the database (e.g., if you have Field('My_Field'),

[web2py] Re: appadmin not updating: update=request.utcnow

2015-11-16 Thread Anthony
The update attribute works only if no value is submitted with the update. However, in appadmin, the writable attribute is ignored, so the current value appears in the update form and is therefore submitted with the rest of the record, resulting in the current value being retained. Try deleting

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread lucas
hey anthony, ok, i read the docs you linked me to. still not seeing the details well enough to get me through. sorry, i am thick sometimes. i put in the view: {{block head}} function clk_form(tidi) { if (tidi != 0) { jQuery('div#form').css('display','inline'); } else {

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread RedBeard
hey, I've been watching Massimo's videos at: https://vimeo.com/album/3016728 I skipped a few to the deployment video, no: 30 - but before he gets to that he does a review of the previous videos: at 2mn30 he talks about the LOAD function with AJAX. You might want to check the previous videos ab

[web2py] st_dwithin

2015-11-16 Thread Pierre
Hi, I'd like to specify use_spheroid=False when calling web2py function st_dwithin postgis ref : boolean *ST_DWithin*(geography gg1, geography gg2, double precision distance_meters, boolean use_spheroid); Is it possible ? if not can can I achieve it with executesSQL ? -- Resources: - ht

[web2py] Re: appadmin not updating: update=request.utcnow

2015-11-16 Thread Robin Manoli
Thanks for your replies guys! Anthony, when I deleted the update value, it stored a NULL value instead. Does it mean I need to enter it manually? Or is there an easy fix to this? Den måndag 16 november 2015 kl. 13:30:44 UTC+1 skrev Anthony: > > The update attribute works only if no value is subm

Re: [web2py] Re: DAL returns string fields not as unicode strings

2015-11-16 Thread Alexandr Presniakov
Yes, the only difference in my example was that strings were printed by interpreter, not by print. The question is: why these strings are returned as byte strings? If they are encoded as utf-8 by default, why not return unicode typed strings? If I'm not mistaken, it was default behaviour before. Or

[web2py] Re: appadmin not updating: update=request.utcnow

2015-11-16 Thread Anthony
On Monday, November 16, 2015 at 9:43:09 AM UTC-5, Robin Manoli wrote: > > Thanks for your replies guys! > > Anthony, when I deleted the update value, it stored a NULL value instead. > Does it mean I need to enter it manually? Or is there an easy fix to this? > One alternative to manual entry migh

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread lucas
i don't think any of those videos will answer my question. so how can i affect that args values of the LOAD from somewhere else in the page, without reloading the page, itself, and then have it only RELOAD the contents of the DIV? -- Resources: - http://web2py.com - http://web2py.com/book (Do

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread Anthony
You can give the Ajax component an explicit name and later use jQuery.web2py.component to call it by name and refresh it: {{=LOAD(c='default', f='ajaxTask', args=[-1], ajax=True, target='task_form' )}} That will result in the id of the component div being set to "task_form", so you can easily i

[web2py] Re: how to SQLFORM via ajax?

2015-11-16 Thread lucas
thank you anthony, that did it. it is working great. lucas -- 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 sub

[web2py] Re: record representation and lambda

2015-11-16 Thread Anthony Smith
Thanks Anthony, yes there were some typo's my mistakes On Sunday, 15 November 2015 18:25:01 UTC+11, Anthony Smith wrote: > > Hi All, > > I have looking though the group for and answer on this, I am try to get > the product_name and batch_no from the product table to be the product in > the stock

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Paolo Valleri
Just to understand what we are talking about, which are the main issues in porting web2py on python 3.x ? Paolo On Saturday, November 14, 2015 at 11:24:30 PM UTC+1, Ramos wrote: > > weppy looks like a short webp2y environment, however lacks some good > documentation like web2py and all of the c

[web2py] Small issue in DAL using ``

2015-11-16 Thread Maxwell Morais
Hi all! I'm trying to implement a small layer over DAL, for my meta-schemas, and I'm facing a very strange issue! My model is hosted here https://github.com/MaxMorais/esquema/blob/master/esquema/lds.py#L248, I commented the line that is raising a error in SQLite3. What is going wrong is: When I

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Stuart Rolinson
I wanted to add to this discussion as well. I think that developing with python 2.7 and web2py has been fine, however I have been really concerned as my application gets bigger that we are going to have to migrate to a .net or java based solution in the future. The more I develop, the more I

[web2py] Re: hello all and a minor typo

2015-11-16 Thread noam cohen
Where is the recommended location to add the queue_task() so it runs exactly once when my app starts? I thought about .../applications/my_app/__init__.py but it was called TWICE (once by the web server and once by the scheduler, if I got it right) I could of course check if the task is already

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Richard Vézina
I would like to suggest a way to get out of these recurrent discussions... Why not adopt some guidance around the issue... I think the heart of the problem here is that not knowing what is coming or not make people insecure about the future of what is built (or could be build) with web2py. It may

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Jim S
+1 On Monday, November 16, 2015 at 3:38:48 PM UTC-6, Richard wrote: > > I would like to suggest a way to get out of these recurrent discussions... > > Why not adopt some guidance around the issue... I think the heart of the > problem here is that not knowing what is coming or not make people ins

[web2py] Re: Best way to migrate existing 2.9.11 app to use new css/js from web2py 2.12.3?

2015-11-16 Thread lillian
Anthony, The app mostly uses the default styling which is why I was surprised so much of it seemed broken when I tried to migrate, prompting my initial post. It seems like it might be easier to start a new app and just move the controllers/views/models over from the old app and go from there.

[web2py] Re: hello all and a minor typo

2015-11-16 Thread Niphlod
there is no facility to queue a task (or any a piece of code) only at the first request consistently. This doesn't mean that it isn't possible, just that there's not any easy machinery to do so. on top of my head: - queue the task just before launching web2py - queue the task every once in a whi

Re: [web2py] LDAP Auth

2015-11-16 Thread Richard Vézina
Could it be possible to not provide Certificate path? I use Redmine and the only thing required is specifying that we use LDAPS by checking a box and specifying the port... I have look a little bit at the code and it seems that this is realize by the help of Perl module "IO::Socket::SSL" (http://s

[web2py] Re: Best way to migrate existing 2.9.11 app to use new css/js from web2py 2.12.3?

2015-11-16 Thread Anthony
On Monday, November 16, 2015 at 5:09:57 PM UTC-5, lillian wrote: > > Anthony, > > The app mostly uses the default styling which is why I was surprised so > much of it seemed broken when I tried to migrate, > Yes, but it is the default styling for Bootstrap 2. The CSS rules for frameworks like Bo

[web2py] Re: Best way to migrate existing 2.9.11 app to use new css/js from web2py 2.12.3?

2015-11-16 Thread Anthony
And note, this issue is not specific to the web2py scaffolding app -- it applies to any site you want to migrate from Bootstrap 2 to Bootstrap 3 (or 4) or to Semantic UI, etc. On Monday, November 16, 2015 at 6:29:26 PM UTC-5, Anthony wrote: > > On Monday, November 16, 2015 at 5:09:57 PM UTC-5, l

[web2py] Re: Is this the best mailing list ever for web app developers?

2015-11-16 Thread Dave S
On Sunday, November 15, 2015 at 12:10:15 AM UTC-8, Anthony Smith wrote: > > That wasn’t suppose the be a question. > > sorry Guys > We do appreciate feedback, though, and as one of the folk who has been helped here, I can also claim the gurus and community are appreciated. /dps > > On Sund

Re: [web2py] LDAP Auth

2015-11-16 Thread Richard
Just found this : https://github.com/cannatag/ldap3 import ldap3 s = ldap3.Server('SERVER.DOMAIN', port=636, use_ssl=True) c = ldap3.Connection(s, user='USER_DN', password='PASSWORD') So no need for certificate path or file... Though only support LDAP v3 which may not be acceptable... What do

[web2py] Re: update_or_insert - Calculation when updating

2015-11-16 Thread Dave S
On Sunday, November 15, 2015 at 11:58:01 AM UTC-8, RedBeard wrote: > > Hi, > > Hi. See below (inline) > I have only just started learning python and web2py so please bear with me. > > When a user inserts an item and amount in tr_items, I am trying to have > the system check whether the item

[web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

2015-11-16 Thread joaquim carvalho
> > Hi Massimo > I use Web2py for some web development I've been working. Thanks to you web2py is a great tool. I am writing to give you a sugestion, if I might: why not create a "linked_tables_placement" in the SQLFORM.smartgrid? It will be very usefull. I think it is simple to implement. S

[web2py] Opportunities for deadlock in scheduler.py send_heartbeat?

2015-11-16 Thread Andy Southgate
Hi all, First of all, many thanks to all involved in web2py, it's been working out very well for me :) I've been using the scheduler a lot, and I think I've found a source of database deadlocks. As far as I can tell, it happens when the system is deleting what it thinks are dead workers becau

[web2py] How to cope with schema changes on Prod

2015-11-16 Thread mfarees . knysys
I have a web2py application that uses PostgreSQL and is running on 3 servers. We'll call them QA, Stage and Prod. Whenever I make some schema changes in my application, my deployment pipeline stops working. The deployment pipeline works this way; updated code is pushed to the QA server, this s

[web2py] Fix input error

2015-11-16 Thread Patrik Skřivánek
Hello, I have in my controller simple input form: form=FORM('Search user: ', INPUT(_name='search'), INPUT(_type='submit')) When I submit character from other than first 128 char of ascii table (for example: ů,á..), output is this error: Traceback (most recent call last): File "/home/web2py/g

[web2py] Production - making redirections on default index with parameters (maybe with nginx)

2015-11-16 Thread Sam Heather
Hi there, I am trying to create redirects using web2py from effectively the default index page (or just the route of the domain/package). Some keywords (such as 'about', stored in a list) wouldn't redirect. However, all not in that list would redirect. The desired behaviour is: https://startbe

[web2py] Re: How to cope with schema changes on Prod

2015-11-16 Thread 黄祥
just an idea, why not use configuration management software like puppet, chef, etc? you can set the web2py file configuration, and push it according to your setting environment (QA, Stage, Prod). best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py]

2015-11-16 Thread Richard Vézina
List of relevant posts : Most relevant: https://groups.google.com/d/msg/web2py/X80Ol0Uumrg/vGrGtaeOVZwJ https://groups.google.com/d/msg/web2py/mlG6-yHPa4g/MFAU9zX3jo4J https://groups.google.com/d/msg/web2py/WJOWlTnoz5I/y0-dQTywoHwJ The whole thread: https://groups.google.com/forum/#!topic/web2py

Re: [web2py]

2015-11-16 Thread Richard Vézina
Sorry this is a mistake thanks gmail I don't even know how I could have done that... :( Richard On Mon, Nov 16, 2015 at 8:50 PM, Richard Vézina wrote: > List of relevant posts : > > Most relevant: > https://groups.google.com/d/msg/web2py/X80Ol0Uumrg/vGrGtaeOVZwJ > https://groups.google.com/d/m

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Richard Vézina
Here it goes : List of relevant posts : Most relevant: https://groups.google.com/d/msg/web2py/X80Ol0Uumrg/vGrGtaeOVZwJ https://groups.google.com/d/msg/web2py/mlG6-yHPa4g/MFAU9zX3jo4J https://groups.google.com/d/msg/web2py/WJOWlTnoz5I/y0-dQTywoHwJ The whole thread: https://groups.google.com/foru

[web2py] Re: Best way to migrate existing 2.9.11 app to use new css/js from web2py 2.12.3?

2015-11-16 Thread lillian
Got it, thanks for the clarification. lillian On Monday, November 16, 2015 at 3:30:58 PM UTC-8, Anthony wrote: > > And note, this issue is not specific to the web2py scaffolding app -- it > applies to any site you want to migrate from Bootstrap 2 to Bootstrap 3 (or > 4) or to Semantic UI, etc.

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Paolo Valleri
Maintaining web2py is not easy at all, how/who will maintain two web2py/web3py? I see this as the major issue The old discussions were about the whole web2py, now there is pydal already working on python 3.x. Having a roadmap is a good way to proceed and surely github wiki is the place where docum