[web2py] Re: web2py 2.15.1 is OUT

[Leonel Câmara]

Alex please create an issue in github, that's a genuine python 3 bug, 
exactly the kind we want to find during this experimental python 3 support 
phase.

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Alex]

I tested the latest version 2.15.2 and I've got a problem when accessing 
ajax post parameters with web2py under Python 3.

The client sends a PUT request using jquery like this:
$.ajax('', {
data: JSON.stringify({
report: report
outputFormat: 'pdf'
}),
type: "PUT", contentType: "application/json",
...


in the controller I access the parameters, e.g.

output_format = request.vars.outputFormat


when using Python 2.7 the variable output_format is set to 'pdf' as 
expected. When using Python 3.5 the variable is None.

Alex

On Thursday, August 3, 2017 at 5:26:31 AM UTC+2, Richard wrote:
>
> I recall having conversation about that, I am not sure, I think it 
> language file or pickle objects that get modify in a no way back manner... 
> But, sure the app code it not affected... I should retrieve this 
> exchange... will try tomorrow.
>
> Richard
>
> On Wed, Aug 2, 2017 at 9:53 PM, Anthony  
> wrote:
>
>> On Wednesday, August 2, 2017 at 12:26:45 PM UTC-4, Richard wrote:
>>>
>>> Don't forget to copy/paste (backup) you app before you try Python 3, 
>>> because there is no way back with the app once you use it under python 3 as 
>>> certain stuff are modify by python 3 that let your app unusable with python 
>>> 2 after.
>>>
>>
>> That sounds extreme, as you can certainly simply redeploy the original 
>> Python 2 code in a Python 2 environment -- there is a way back.
>>
>> Anthony
>>
>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Anthony]

On Wednesday, August 2, 2017 at 11:26:31 PM UTC-4, Richard wrote:
>
> I recall having conversation about that, I am not sure, I think it 
> language file or pickle objects that get modify in a no way back manner...
>

I think only the sessions and error tickets should be affected, as they are 
pickled. Language files should be OK -- they are just plain Python code 
(containing a Python dictionary).

Regarding sessions, simply copying/backing up the old sessions might not be 
particularly helpful -- if you do revert back to the old sessions, they 
will end up being outdated anyway.

The bigger point, though, should be that it is not intended that you would 
switch back and forth between Python 2 and Python 3 using the same 
application folders -- pick a Python version and stick with it.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Richard Vézina]

I recall having conversation about that, I am not sure, I think it language
file or pickle objects that get modify in a no way back manner... But, sure
the app code it not affected... I should retrieve this exchange... will try
tomorrow.

Richard

On Wed, Aug 2, 2017 at 9:53 PM, Anthony  wrote:

> On Wednesday, August 2, 2017 at 12:26:45 PM UTC-4, Richard wrote:
>>
>> Don't forget to copy/paste (backup) you app before you try Python 3,
>> because there is no way back with the app once you use it under python 3 as
>> certain stuff are modify by python 3 that let your app unusable with python
>> 2 after.
>>
>
> That sounds extreme, as you can certainly simply redeploy the original
> Python 2 code in a Python 2 environment -- there is a way back.
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Anthony]

On Wednesday, August 2, 2017 at 12:26:45 PM UTC-4, Richard wrote:
>
> Don't forget to copy/paste (backup) you app before you try Python 3, 
> because there is no way back with the app once you use it under python 3 as 
> certain stuff are modify by python 3 that let your app unusable with python 
> 2 after.
>

That sounds extreme, as you can certainly simply redeploy the original 
Python 2 code in a Python 2 environment -- there is a way back.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Richard Vézina]

Don't forget to copy/paste (backup) you app before you try Python 3,
because there is no way back with the app once you use it under python 3 as
certain stuff are modify by python 3 that let your app unusable with python
2 after.

Richard

On Wed, Aug 2, 2017 at 9:24 AM, Anthony  wrote:

> On Wednesday, August 2, 2017 at 9:13:31 AM UTC-4, bonbe wrote:
>>
>> The same thing happened to me.
>>
>> Are you saying that has happened with the latest release (2.15.2), or
> only with 2.15.0b1?
>
> Please use Python3.
>>
>> web2py should continue to work with Python 2, so there is no need to move
> to Python 3. If there is a bug, it will be fixed.
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Anthony]

On Wednesday, August 2, 2017 at 9:13:31 AM UTC-4, bonbe wrote:
>
> The same thing happened to me.
>
> Are you saying that has happened with the latest release (2.15.2), or only 
with 2.15.0b1?

Please use Python3.
>
> web2py should continue to work with Python 2, so there is no need to move 
to Python 3. If there is a bug, it will be fixed.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[bonbe]

The same thing happened to me.
Please use Python3.



2017年7月17日月曜日 21時11分58秒 UTC+9 vince:
>
> i download from 
> https://mdipierro.pythonanywhere.com/examples/static/web2py_src.zip
>
> on first line of changelog it's 2.15.0b1
>
> and when i run web2py.py error as below
>
> Traceback (most recent call last):
>   File "./web2py.py", line 21, in 
> import gluon.widget
>   File "/home/web2py/gluon/__init__.py", line 38, in 
> from .dal import DAL, Field
>   File "/home/web2py/gluon/dal.py", line 19, in 
> from gluon import sqlhtml
>   File "/home/web2py/gluon/sqlhtml.py", line 32, in 
> from pydal.helpers.methods import smart_query, bar_encode, _repr_ref, 
> merge_tablemaps
> ImportError: cannot import name merge_tablemaps 
>
> -vince
>
> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>
>> It took a year. Thanks to everybody who contributed. There are a ton of 
>> bug fixes and speed improvements.
>>
>> I would encourage everybody who contributed to add a comment in this 
>> thread explaining the main features/improvements they have made.
>>
>> If anything does not work or was broken it is only fault and I will 
>> remedy if reported.
>>
>> Massimo
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Leonel Câmara]

Carlos your problem was already reported:
https://github.com/web2py/web2py/issues/1672

Before the next release which will have the fix the workaround is:

form = SQLFORM.factory(db.tabela.campo.clone())


-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Carlos Costa]

I have a problem with this version.

This does not work anymore:

db.define_table('tabela', Field('campo'))
form = SQLFORM.factory(db.tabela.campo)

I throws this:

Traceback (most recent call last):
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\restricted.py", line 219, 
in restricted
exec(ccode, environment)
  File 
"C:/Users/carlos.costa/Downloads/web2py/applications/teste/controllers/default.py"
 , line 
66, in 
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\globals.py", line 409, in 

self._caller = lambda f: f()
  File 
"C:/Users/carlos.costa/Downloads/web2py/applications/teste/controllers/default.py"
 , line 
13, in teste
form = SQLFORM.factory(db.tabela.campo)
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\sqlhtml.py", line 1919, in 
factory
return SQLFORM(DAL(None).define_table(table_name, *fields),
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\base.py", line 
587, in define_table
table = self.lazy_define_table(tablename, *fields, **args)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\base.py", line 
599, in lazy_define_table
table = table_class(self, tablename, *fields, **args)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\objects.py", 
line 351, in __init__
field.bind(self)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\objects.py", 
line 1633, in bind
'Field %s is already bound to a table' % self.longname)
ValueError: Field tabela.campo is already bound to a table



Em segunda-feira, 10 de julho de 2017 18:40:08 UTC-3, Massimo Di Pierro 
escreveu:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Leonel Câmara]

Vince that seems like a bug in the way you updated web2py you seem to be 
using the old DAL.

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[vince]

i download 
from https://mdipierro.pythonanywhere.com/examples/static/web2py_src.zip

on first line of changelog it's 2.15.0b1

and when i run web2py.py error as below

Traceback (most recent call last):
  File "./web2py.py", line 21, in 
import gluon.widget
  File "/home/web2py/gluon/__init__.py", line 38, in 
from .dal import DAL, Field
  File "/home/web2py/gluon/dal.py", line 19, in 
from gluon import sqlhtml
  File "/home/web2py/gluon/sqlhtml.py", line 32, in 
from pydal.helpers.methods import smart_query, bar_encode, _repr_ref, 
merge_tablemaps
ImportError: cannot import name merge_tablemaps 

-vince

On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Dave S]

On Friday, July 14, 2017 at 1:12:39 AM UTC-7, Dave S wrote:
>
>
>
> On Thursday, July 13, 2017 at 6:20:21 PM UTC-7, Dave S wrote:
>>
>>
>>
>> On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote:
>>>
>>> Are you saying that used to work but doesn't any longer?
>>>
>>>
>> There are 3 examples in the book at the link.  They work in 2.14.6 using 
>> -S (and I did cut-n-paste to check).
>>
>>
> They seem to work in 2.15.0b1.
>
> (Note:  the examples depend on earlier examples, starting at "Other 
> Operators".)
>

And now I can add "work in 2.15.1" to the report.

/dps
 

>
>
>
>>
>>  
>>
>>> How about db(db.table).select(max)?
>>>
>>> Anthony
>>>
>>>
>> /dps
>>
>>
> Me again.
> -d
>  
>
>>  
>>
>>> On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:

 I'm using a simple query to get aggregate:

 max = db.table.date.max()
 row = db().select(max)

 Just following the example here 
 http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len

 But I ran into this error:

 Traceback (most recent call last):
   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
 serve_controller(request, response, session)
   File "/Users/web2py/web2py/gluon/main.py", line 180, in 
 serve_controller
 page = run_controller_in(request.controller, request.function, 
 environment)
   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
 run_controller_in
 vars = vars.xml()
   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
 2497, in xml
 rv = self.db.represent('rows_xml', self)
   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 
 834, in represent
 return self.representers[name](*args, **kwargs)
   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
 tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
 tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
 AttributeError: 'Expression' object has no attribute 'tablename'


 Kindly assist.


 On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>
> It took a year. Thanks to everybody who contributed. There are a ton 
> of bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will 
> remedy if reported.
>
> Massimo
>


-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Dave S]

On Thursday, July 13, 2017 at 5:17:11 PM UTC-7, Leonel Câmara wrote:
>
> Note this is deprecated:
>
> row = db().select(max)
>
> Calling db() like that without a query will break common filters for 
> instance.
>

Do we need another pull request on the book, since the examples are there? 
 (They were last edited in 2013, it appears.)

/dps
 

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Dave S]

On Thursday, July 13, 2017 at 6:20:21 PM UTC-7, Dave S wrote:
>
>
>
> On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote:
>>
>> Are you saying that used to work but doesn't any longer?
>>
>>
> There are 3 examples in the book at the link.  They work in 2.14.6 using 
> -S (and I did cut-n-paste to check).
>
>
They seem to work in 2.15.0b1.

(Note:  the examples depend on earlier examples, starting at "Other 
Operators".)



>
>  
>
>> How about db(db.table).select(max)?
>>
>> Anthony
>>
>>
> /dps
>
>
Me again.
-d
 

>  
>
>> On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:
>>>
>>> I'm using a simple query to get aggregate:
>>>
>>> max = db.table.date.max()
>>> row = db().select(max)
>>>
>>> Just following the example here 
>>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>>
>>> But I ran into this error:
>>>
>>> Traceback (most recent call last):
>>>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
>>> serve_controller(request, response, session)
>>>   File "/Users/web2py/web2py/gluon/main.py", line 180, in 
>>> serve_controller
>>> page = run_controller_in(request.controller, request.function, 
>>> environment)
>>>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
>>> run_controller_in
>>> vars = vars.xml()
>>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
>>> 2497, in xml
>>> rv = self.db.represent('rows_xml', self)
>>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 
>>> 834, in represent
>>> return self.representers[name](*args, **kwargs)
>>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
>>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
>>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>> AttributeError: 'Expression' object has no attribute 'tablename'
>>>
>>>
>>> Kindly assist.
>>>
>>>
>>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:

 It took a year. Thanks to everybody who contributed. There are a ton of 
 bug fixes and speed improvements.

 I would encourage everybody who contributed to add a comment in this 
 thread explaining the main features/improvements they have made.

 If anything does not work or was broken it is only fault and I will 
 remedy if reported.

 Massimo

>>>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Anthony, pls 
see https://groups.google.com/d/msg/web2py/h4b4xz2NzNM/QHSoRfrcCAAJ

If we put double quotes on the table name, which happens to not be there 
for *aggregates* and *distinct* then the sql query will work.

On Friday, July 14, 2017 at 5:43:57 AM UTC+8, Anthony wrote:
>
> Are you saying that used to work but doesn't any longer?
>
> How about db(db.table).select(max)?
>
> Anthony
>
> On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:
>>
>> I'm using a simple query to get aggregate:
>>
>> max = db.table.date.max()
>> row = db().select(max)
>>
>> Just following the example here 
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> But I ran into this error:
>>
>> Traceback (most recent call last):
>>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
>> serve_controller(request, response, session)
>>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
>> page = run_controller_in(request.controller, request.function, 
>> environment)
>>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
>> run_controller_in
>> vars = vars.xml()
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
>> 2497, in xml
>> rv = self.db.represent('rows_xml', self)
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
>> in represent
>> return self.representers[name](*args, **kwargs)
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>> AttributeError: 'Expression' object has no attribute 'tablename'
>>
>>
>> Kindly assist.
>>
>>
>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>>
>>> It took a year. Thanks to everybody who contributed. There are a ton of 
>>> bug fixes and speed improvements.
>>>
>>> I would encourage everybody who contributed to add a comment in this 
>>> thread explaining the main features/improvements they have made.
>>>
>>> If anything does not work or was broken it is only fault and I will 
>>> remedy if reported.
>>>
>>> Massimo
>>>
>>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Thank you Anthony. I always appreciate your input.

I recall using the aggregates max() and count() before and they worked fine 
following the book. That was quite long ago. However, this time, I did not 
try on the "old" web2py version. I upgraded to 2.15.1 and continued to code 
in it.

Using
db(db.table).select(max)



Gave a longer traceback:
Traceback (most recent call last):
  File "/Users/web2py/web2py/gluon/restricted.py", line 219, in restricted
exec(ccode, environment)
  File "", line 83, in 
  File "/Users/web2py/web2py/gluon/globals.py", line 422, in write
self.body.write(to_native(xmlescape(data)))
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/html.py", line 960, in xml
(fa, co) = self._xml()
  File "/Users/web2py/web2py/gluon/html.py", line 952, in _xml
co = b''.join([xmlescape(component) for component in self.components])
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/html.py", line 960, in xml
(fa, co) = self._xml()
  File "/Users/web2py/web2py/gluon/html.py", line 952, in _xml
co = b''.join([xmlescape(component) for component in self.components])
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/html.py", line 960, in xml
(fa, co) = self._xml()
  File "/Users/web2py/web2py/gluon/html.py", line 952, in _xml
co = b''.join([xmlescape(component) for component in self.components])
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/html.py", line 960, in xml
(fa, co) = self._xml()
  File "/Users/web2py/web2py/gluon/html.py", line 952, in _xml
co = b''.join([xmlescape(component) for component in self.components])
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/html.py", line 960, in xml
(fa, co) = self._xml()
  File "/Users/web2py/web2py/gluon/html.py", line 952, in _xml
co = b''.join([xmlescape(component) for component in self.components])
  File "/Users/web2py/web2py/gluon/html.py", line 125, in xmlescape
return to_bytes(data.xml())
  File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
2497, in xml
rv = self.db.represent('rows_xml', self)
  File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
in represent
return self.representers[name](*args, **kwargs)
  File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
  File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
AttributeError: 'Expression' object has no attribute 'tablename'



On Friday, July 14, 2017 at 5:43:57 AM UTC+8, Anthony wrote:
>
> Are you saying that used to work but doesn't any longer?
>
> How about db(db.table).select(max)?
>
> Anthony
>
> On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:
>>
>> I'm using a simple query to get aggregate:
>>
>> max = db.table.date.max()
>> row = db().select(max)
>>
>> Just following the example here 
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> But I ran into this error:
>>
>> Traceback (most recent call last):
>>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
>> serve_controller(request, response, session)
>>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
>> page = run_controller_in(request.controller, request.function, 
>> environment)
>>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
>> run_controller_in
>> vars = vars.xml()
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
>> 2497, in xml
>> rv = self.db.represent('rows_xml', self)
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
>> in represent
>> return self.representers[name](*args, **kwargs)
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>> AttributeError: 'Expression' object has no attribute 'tablename'
>>
>>
>> Kindly assist.
>>
>>
>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>>
>>> It took a year. Thanks to everybody who contributed. There are a ton of 
>>> bug fixes and speed improvements.
>>>
>>> I would encourage everybody who contributed to add a comment in this 
>>> thread explaining the main features/improvements they have made.
>>>
>>> If anything does not 

[web2py] Re: web2py 2.15.1 is OUT

[Dave S]

On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote:
>
> Are you saying that used to work but doesn't any longer?
>
>
There are 3 examples in the book at the link.  They work in 2.14.6 using -S 
(and I did cut-n-paste to check).



 

> How about db(db.table).select(max)?
>
> Anthony
>
>
/dps

 

> On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:
>>
>> I'm using a simple query to get aggregate:
>>
>> max = db.table.date.max()
>> row = db().select(max)
>>
>> Just following the example here 
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> But I ran into this error:
>>
>> Traceback (most recent call last):
>>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
>> serve_controller(request, response, session)
>>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
>> page = run_controller_in(request.controller, request.function, 
>> environment)
>>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
>> run_controller_in
>> vars = vars.xml()
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
>> 2497, in xml
>> rv = self.db.represent('rows_xml', self)
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
>> in represent
>> return self.representers[name](*args, **kwargs)
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>> AttributeError: 'Expression' object has no attribute 'tablename'
>>
>>
>> Kindly assist.
>>
>>
>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>>
>>> It took a year. Thanks to everybody who contributed. There are a ton of 
>>> bug fixes and speed improvements.
>>>
>>> I would encourage everybody who contributed to add a comment in this 
>>> thread explaining the main features/improvements they have made.
>>>
>>> If anything does not work or was broken it is only fault and I will 
>>> remedy if reported.
>>>
>>> Massimo
>>>
>>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Thank you Leonel,

I actually have a very complex query, and it ran into the error I 
mentioned. In my query I have:
db(query).select(other_fields, aggregate, groupby=...etc..., orderby=...etc
...)

and I ran into the error. So I tried to identify if it was my complex query 
throwing the error, my model or some other part, and over 4 hours (too 
long, I know...) I narrowed down to the aggregate, I tested specifically to 
the example provided by the web2py book. It still gave the same error.

In my normal use-case, I have a "query", but it's still good to know and 
add to the book that it is deprecated.


On Friday, July 14, 2017 at 8:17:11 AM UTC+8, Leonel Câmara wrote:
>
> Note this is deprecated:
>
> row = db().select(max)
>
> Calling db() like that without a query will break common filters for 
> instance.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

No I am not using the rname feature

On Friday, July 14, 2017 at 2:26:57 AM UTC+8, Richard wrote:
>
> Are you using rname feature?
>
> If so, the issue may need to be further investigate as why SELECT DISTINCT 
> ON (TABLE_of_sites.title) is not double quoted and all the other table_name 
> and field instance are...
>
> So maybe the flaw is somewhere in the escaping related to rname feature...
>
> Richard
>
> On Thu, Jul 13, 2017 at 2:11 PM, lyn2py  
> wrote:
>
>> Following this lead 
>> https://stackoverflow.com/questions/34708963/error-missing-from-clause-entry-for-table
>>
>> I discovered that if we add double quotes to the tablename, for all 
>> instances of the tablename, like this:
>> "TABLE_of_sites"
>>
>> Then the query will work.
>>
>>
>> On Friday, July 14, 2017 at 1:48:10 AM UTC+8, lyn2py wrote:
>>>
>>> Table code:
>>> db.define_table('TABLE_of_sites', 
>>> Field('site_id', 'reference sites'),
>>> Field('title', 'string'), 
>>> Field('date','datetime'),
>>> ...
>>> Field('updated','datetime', update=request.now, writable=False),
>>> format='%(site_id)s'
>>> )
>>>
>>>
>>> In controller:
>>> table = db['TABLE_of_sites']
>>> rows = db(table).select(distinct=table.title)
>>>
>>> Gives the error:
>>>
>>> ProgrammingError: missing FROM-clause entry for table "table_of_sites"
>>> LINE 1: SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of...
>>>
>>> ^
>>>
>>>
>>> I printed the sql query that resulted from the above code. It has the 
>>> FROM-clause, so I don't know why it would give the error. This is the 
>>> printed query:
>>> SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of_sites"."id", 
>>> "TABLE_of_sites"."site_id", "TABLE_of_sites"."date", 
>>> "TABLE_of_sites"."title" FROM "TABLE_of_sites" WHERE ("TABLE_of_sites"."id" 
>>> IS NOT NULL);
>>>
>>> I need to select 1 row for entries that appear multiple times for a 
>>> particular title, hence I'm using distinct (or aggregates like max() - 
>>> details in my previous post) but both are not working.
>>>
>>> Thank you for your time and assistance!
>>>
>>>
>>>
>>>
>>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:

 It took a year. Thanks to everybody who contributed. There are a ton of 
 bug fixes and speed improvements.

 I would encourage everybody who contributed to add a comment in this 
 thread explaining the main features/improvements they have made.

 If anything does not work or was broken it is only fault and I will 
 remedy if reported.

 Massimo

>>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Leonel Câmara]

Note this is deprecated:

row = db().select(max)

Calling db() like that without a query will break common filters for 
instance.

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Anthony]

Are you saying that used to work but doesn't any longer?

How about db(db.table).select(max)?

Anthony

On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote:
>
> I'm using a simple query to get aggregate:
>
> max = db.table.date.max()
> row = db().select(max)
>
> Just following the example here 
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>
> But I ran into this error:
>
> Traceback (most recent call last):
>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
> serve_controller(request, response, session)
>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
> page = run_controller_in(request.controller, request.function, 
> environment)
>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
> run_controller_in
> vars = vars.xml()
>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
> 2497, in xml
> rv = self.db.represent('rows_xml', self)
>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
> in represent
> return self.representers[name](*args, **kwargs)
>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
> AttributeError: 'Expression' object has no attribute 'tablename'
>
>
> Kindly assist.
>
>
> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>
>> It took a year. Thanks to everybody who contributed. There are a ton of 
>> bug fixes and speed improvements.
>>
>> I would encourage everybody who contributed to add a comment in this 
>> thread explaining the main features/improvements they have made.
>>
>> If anything does not work or was broken it is only fault and I will 
>> remedy if reported.
>>
>> Massimo
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Richard Vézina]

Are you using rname feature?

If so, the issue may need to be further investigate as why SELECT DISTINCT
ON (TABLE_of_sites.title) is not double quoted and all the other table_name
and field instance are...

So maybe the flaw is somewhere in the escaping related to rname feature...

Richard

On Thu, Jul 13, 2017 at 2:11 PM, lyn2py  wrote:

> Following this lead https://stackoverflow.com/questions/34708963/error-
> missing-from-clause-entry-for-table
>
> I discovered that if we add double quotes to the tablename, for all
> instances of the tablename, like this:
> "TABLE_of_sites"
>
> Then the query will work.
>
>
> On Friday, July 14, 2017 at 1:48:10 AM UTC+8, lyn2py wrote:
>>
>> Table code:
>> db.define_table('TABLE_of_sites',
>> Field('site_id', 'reference sites'),
>> Field('title', 'string'),
>> Field('date','datetime'),
>> ...
>> Field('updated','datetime', update=request.now, writable=False),
>> format='%(site_id)s'
>> )
>>
>>
>> In controller:
>> table = db['TABLE_of_sites']
>> rows = db(table).select(distinct=table.title)
>>
>> Gives the error:
>>
>> ProgrammingError: missing FROM-clause entry for table "table_of_sites"
>> LINE 1: SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of...
>>
>> ^
>>
>>
>> I printed the sql query that resulted from the above code. It has the
>> FROM-clause, so I don't know why it would give the error. This is the
>> printed query:
>> SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of_sites"."id",
>> "TABLE_of_sites"."site_id", "TABLE_of_sites"."date",
>> "TABLE_of_sites"."title" FROM "TABLE_of_sites" WHERE ("TABLE_of_sites"."id"
>> IS NOT NULL);
>>
>> I need to select 1 row for entries that appear multiple times for a
>> particular title, hence I'm using distinct (or aggregates like max() -
>> details in my previous post) but both are not working.
>>
>> Thank you for your time and assistance!
>>
>>
>>
>>
>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>>
>>> It took a year. Thanks to everybody who contributed. There are a ton of
>>> bug fixes and speed improvements.
>>>
>>> I would encourage everybody who contributed to add a comment in this
>>> thread explaining the main features/improvements they have made.
>>>
>>> If anything does not work or was broken it is only fault and I will
>>> remedy if reported.
>>>
>>> Massimo
>>>
>> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Following this 
lead 
https://stackoverflow.com/questions/34708963/error-missing-from-clause-entry-for-table

I discovered that if we add double quotes to the tablename, for all 
instances of the tablename, like this:
"TABLE_of_sites"

Then the query will work.

On Friday, July 14, 2017 at 1:48:10 AM UTC+8, lyn2py wrote:
>
> Table code:
> db.define_table('TABLE_of_sites', 
> Field('site_id', 'reference sites'),
> Field('title', 'string'), 
> Field('date','datetime'),
> ...
> Field('updated','datetime', update=request.now, writable=False),
> format='%(site_id)s'
> )
>
>
> In controller:
> table = db['TABLE_of_sites']
> rows = db(table).select(distinct=table.title)
>
> Gives the error:
>
> ProgrammingError: missing FROM-clause entry for table "table_of_sites"
> LINE 1: SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of...
>
> ^
>
>
> I printed the sql query that resulted from the above code. It has the 
> FROM-clause, so I don't know why it would give the error. This is the 
> printed query:
> SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of_sites"."id", 
> "TABLE_of_sites"."site_id", "TABLE_of_sites"."date", 
> "TABLE_of_sites"."title" FROM "TABLE_of_sites" WHERE ("TABLE_of_sites"."id" 
> IS NOT NULL);
>
> I need to select 1 row for entries that appear multiple times for a 
> particular title, hence I'm using distinct (or aggregates like max() - 
> details in my previous post) but both are not working.
>
> Thank you for your time and assistance!
>
>
>
>
> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>
>> It took a year. Thanks to everybody who contributed. There are a ton of 
>> bug fixes and speed improvements.
>>
>> I would encourage everybody who contributed to add a comment in this 
>> thread explaining the main features/improvements they have made.
>>
>> If anything does not work or was broken it is only fault and I will 
>> remedy if reported.
>>
>> Massimo
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Table code:
db.define_table('TABLE_of_sites', 
Field('site_id', 'reference sites'),
Field('title', 'string'), 
Field('date','datetime'),
...
Field('updated','datetime', update=request.now, writable=False),
format='%(site_id)s'
)


In controller:
table = db['TABLE_of_sites']
rows = db(table).select(distinct=table.title)

Gives the error:

ProgrammingError: missing FROM-clause entry for table "table_of_sites"
LINE 1: SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of...

^


I printed the sql query that resulted from the above code. It has the 
FROM-clause, so I don't know why it would give the error. This is the 
printed query:
SELECT DISTINCT ON (TABLE_of_sites.title) "TABLE_of_sites"."id", 
"TABLE_of_sites"."site_id", "TABLE_of_sites"."date", 
"TABLE_of_sites"."title" FROM "TABLE_of_sites" WHERE ("TABLE_of_sites"."id" 
IS NOT NULL);

I need to select 1 row for entries that appear multiple times for a 
particular title, hence I'm using distinct (or aggregates like max() - 
details in my previous post) but both are not working.

Thank you for your time and assistance!




On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

Here it is...

db.define_table('TABLE_of_sites', 
Field('site_id', 'reference sites'),
Field('title', 'string'), 
Field('date','datetime'),
...
Field('updated','datetime', update=request.now, writable=False),
format='%(site_id)s'
)

There are multiple entries for a particular title, so I want to get the 
MAX(date) entry.

This is the query I used (result = not working):
table = 'TABLE_of_sites'
max = db[table].date.max()
row = db().select(max)


Other queries on the table work fine, but not aggregates. I tried count(), 
max() and they both don't work.

Queries that work are the straightforward ones:
db(db[table]).select()

In fact I also tried distinct and there's an error too, I will make a 
separate post.


On Friday, July 14, 2017 at 1:22:01 AM UTC+8, Richard wrote:
>
> @lyn2py, seems more a issue with naming in your model than anything 
> else... Can you show us your model?
>
> On Thu, Jul 13, 2017 at 1:16 PM, lyn2py  
> wrote:
>
>> I'm using a simple query to get aggregate:
>>
>> max = db.table.date.max()
>> row = db().select(max)
>>
>> Just following the example here 
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len
>>
>> But I ran into this error:
>>
>> Traceback (most recent call last):
>>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
>> serve_controller(request, response, session)
>>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
>> page = run_controller_in(request.controller, request.function, 
>> environment)
>>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
>> run_controller_in
>> vars = vars.xml()
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
>> 2497, in xml
>> rv = self.db.represent('rows_xml', self)
>>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
>> in represent
>> return self.representers[name](*args, **kwargs)
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
>> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>> AttributeError: 'Expression' object has no attribute 'tablename'
>>
>>
>> Kindly assist.
>>
>>
>> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>>
>>> It took a year. Thanks to everybody who contributed. There are a ton of 
>>> bug fixes and speed improvements.
>>>
>>> I would encourage everybody who contributed to add a comment in this 
>>> thread explaining the main features/improvements they have made.
>>>
>>> If anything does not work or was broken it is only fault and I will 
>>> remedy if reported.
>>>
>>> Massimo
>>>
>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1 is OUT

[Richard Vézina]

@lyn2py, seems more a issue with naming in your model than anything else...
Can you show us your model?

On Thu, Jul 13, 2017 at 1:16 PM, lyn2py  wrote:

> I'm using a simple query to get aggregate:
>
> max = db.table.date.max()
> row = db().select(max)
>
> Just following the example here http://www.web2py.com/
> books/default/chapter/29/06/the-database-abstraction-
> layer#sum-avg-min-max-and-len
>
> But I ran into this error:
>
> Traceback (most recent call last):
>   File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
> serve_controller(request, response, session)
>   File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
> page = run_controller_in(request.controller, request.function,
> environment)
>   File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in
> run_controller_in
> vars = vars.xml()
>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line
> 2497, in xml
> rv = self.db.represent('rows_xml', self)
>   File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834,
> in represent
> return self.representers[name](*args, **kwargs)
>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
>   File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
> tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
> AttributeError: 'Expression' object has no attribute 'tablename'
>
>
> Kindly assist.
>
>
> On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>>
>> It took a year. Thanks to everybody who contributed. There are a ton of
>> bug fixes and speed improvements.
>>
>> I would encourage everybody who contributed to add a comment in this
>> thread explaining the main features/improvements they have made.
>>
>> If anything does not work or was broken it is only fault and I will
>> remedy if reported.
>>
>> Massimo
>>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[lyn2py]

I'm using a simple query to get aggregate:

max = db.table.date.max()
row = db().select(max)

Just following the example 
here 
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len

But I ran into this error:

Traceback (most recent call last):
  File "/Users/web2py/web2py/gluon/main.py", line 445, in wsgibase
serve_controller(request, response, session)
  File "/Users/web2py/web2py/gluon/main.py", line 180, in serve_controller
page = run_controller_in(request.controller, request.function, 
environment)
  File "/Users/web2py/web2py/gluon/compileapp.py", line 660, in 
run_controller_in
vars = vars.xml()
  File "/Users/web2py/web2py/gluon/packages/dal/pydal/objects.py", line 
2497, in xml
rv = self.db.represent('rows_xml', self)
  File "/Users/web2py/web2py/gluon/packages/dal/pydal/base.py", line 834, 
in represent
return self.representers[name](*args, **kwargs)
  File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in __init__
tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
  File "/Users/web2py/web2py/gluon/sqlhtml.py", line 3319, in 
tablemap = dict(((f.tablename, f.table) for f in fieldmap.values()))
AttributeError: 'Expression' object has no attribute 'tablename'


Kindly assist.


On Tuesday, July 11, 2017 at 5:40:08 AM UTC+8, Massimo Di Pierro wrote:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Anthony]

On Thursday, July 13, 2017 at 1:03:31 PM UTC-4, Massimo Di Pierro wrote:
>
> @Anthony,
>
> could you provide a simple example?
>

model:

db.define_table('mytable',
Field('name'),
Field('photo', 'upload'))

controller:

def main_page():
return dict()

def form_component():
return dict(form=SQLFORM(db.mytable).process())

main_page.html view:

{{=LOAD('form_component', ajax=True)}}

With the above code, the file uploads for the db.mytable.photo field will 
now work (except in older browsers that do not support FormData). 
Previously, the way web2py.js handled Ajax form submissions (via 
jQuery.serialize) did not support file uploads, so the above code would 
fail to upload files for the db.mytable.photo field.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Massimo Di Pierro]

@Anthony,

could you provide a simple example?

Massimo

On Tuesday, 11 July 2017 15:19:58 UTC-5, Anthony wrote:
>
> One new feature is that in modern browsers (that support FormData), web2py 
> Ajax components now support file uploads out of the box (no need for 
> third-party plugins).
>
> Anthony
>
> On Monday, July 10, 2017 at 5:40:08 PM UTC-4, Massimo Di Pierro wrote:
>>
>> It took a year. Thanks to everybody who contributed. There are a ton of 
>> bug fixes and speed improvements.
>>
>> I would encourage everybody who contributed to add a comment in this 
>> thread explaining the main features/improvements they have made.
>>
>> If anything does not work or was broken it is only fault and I will 
>> remedy if reported.
>>
>> Massimo
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1 is OUT

[Anthony]

One new feature is that in modern browsers (that support FormData), web2py 
Ajax components now support file uploads out of the box (no need for 
third-party plugins).

Anthony

On Monday, July 10, 2017 at 5:40:08 PM UTC-4, Massimo Di Pierro wrote:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Anthony]

On Monday, June 26, 2017 at 12:04:37 PM UTC-4, Richard wrote:
>
> http://web2py.com/books/default/chapter/29/07/forms-and-validators#IS_DATE
>
> I don't know if we enforce that this formatting respect any python 
> standard...
>
> I can give a try if we can pass flatpickr parameters without issue... 
>

The point is, there is no reason that IS_DATE must use the same formatting 
strings as Flatpickr. For example, just do the following:

Field('mydate', 'date', requires=IS_DATE(format=T('%Y-%m-%d'))

and in web2py_ajax.html (and similarly in web2py.js):

var w2p_ajax_date_format = "{{=T('Y-m-d')}}";

w2p_ajax_date_format gets passed to Flatpickr. In that case, Flatpickr will 
generate dates that are in the format expected by IS_DATE(). But there is 
no reason that w2p_ajax_date_format must itself be a Python date formatting 
string -- it can simply using the Flatpickr formatting.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

http://web2py.com/books/default/chapter/29/07/forms-and-validators#IS_DATE

I don't know if we enforce that this formatting respect any python
standard...

I can give a try if we can pass flatpickr parameters without issue...

Richard

On Mon, Jun 26, 2017 at 11:57 AM, Anthony  wrote:

> On Monday, June 26, 2017 at 10:42:33 AM UTC-4, Richard wrote:
>>
>> We could certainly do that... Things would happen in web2py.js thought,
>> or we bringing out flatpickr from there... But it wouldn't work properly
>> passing parameters time/date/datetime from validators IS_TIME(), IS_DATE(),
>> etc. So we will get complaints saying that it doesn't work specifying date
>> format from validator as before...
>>
>
> Where does the web2py framework code pass parameters from the IS_TIME()
> and IS_DATE() validators to the Javascript date and time picker widgets?
>
> Note, we just have to specify the Flatpickr options so that the submitted
> value is in the correct format -- we don't actually have to use Python
> datetime formatting to achieve that. For example, if the IS_DATE()
> validator expects something in -MM-DD format, then just set up
> Flatpickr to return values in that format (using whatever formatting
> options the Flatpickr API requires to do so).
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Anthony]

On Monday, June 26, 2017 at 10:42:33 AM UTC-4, Richard wrote:
>
> We could certainly do that... Things would happen in web2py.js thought, or 
> we bringing out flatpickr from there... But it wouldn't work properly 
> passing parameters time/date/datetime from validators IS_TIME(), IS_DATE(), 
> etc. So we will get complaints saying that it doesn't work specifying date 
> format from validator as before...
>

Where does the web2py framework code pass parameters from the IS_TIME() and 
IS_DATE() validators to the Javascript date and time picker widgets?

Note, we just have to specify the Flatpickr options so that the submitted 
value is in the correct format -- we don't actually have to use Python 
datetime formatting to achieve that. For example, if the IS_DATE() 
validator expects something in -MM-DD format, then just set up 
Flatpickr to return values in that format (using whatever formatting 
options the Flatpickr API requires to do so).

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

We could certainly do that... Things would happen in web2py.js thought, or
we bringing out flatpickr from there... But it wouldn't work properly
passing parameters time/date/datetime from validators IS_TIME(), IS_DATE(),
etc. So we will get complaints saying that it doesn't work specifying date
format from validator as before...

I would have make sure that python datetime format plugin would support
most of the regular date time formating (not all) and we can just point
people to improve the plugin if their formating is not cover... Writing a
2-3 use case plugin in the first place wouldn't be that long...

We can craft a built massage telling people to improve the plugin when
their usecase is not cover... So we can implement default web2py date time
formating only to pick up flatpickr rapidly...

I am not that good in javascript though, so I leave that to others...

Richard


On Mon, Jun 26, 2017 at 10:33 AM, Anthony  wrote:

> I'm not sure it would really have to support Python date formatting.
> Couldn't we just specify the appropriate default formats in
> web2py_ajax.html
> 
> and then point users to the Flatpickr documentation if they want to use
> alternative formats (they'll need the Flatpickr documentation anyway to
> make other types of customizations)?
>
> Anthony
>
>
> On Monday, June 26, 2017 at 10:16:05 AM UTC-4, Richard wrote:
>>
>> To integrate flatpickr a flatpickr plugin should be write to support
>> python date time string formating : http://strftime.org/
>>
>> That what have been suggested by flatpickr devs :
>> https://github.com/chmln/flatpickr/issues/886
>>
>> I try to integrate flatpickr here and it get muddy along the road as I
>> learn flatpickr API for datetime formating which is javascript compliant if
>> compliant to anything at all... Code here : https://github.com/Buhtigith
>> uB/web2py/tree/improve/replace-calendar-time-picker-by-flatpicker
>>
>> It works, but you have to support all kinds of datetime string formatting
>> for which you will have a lot of logic to write... This logic should be
>> write once as a flatpickr plugin to me...
>>
>> Calendar may be ogly but by accepting python switches :
>> http://www.dynarch.com/jscal/#printDate
>>
>> It made it a really good fit...
>>
>> I don't really have time to work on a flatpickr plugin...
>>
>> Richard
>>
>> On Fri, Jun 23, 2017 at 10:36 AM, Oasis Agano 
>> wrote:
>>
>>> i think this guy is working on the flatpickr datepicker but could use
>>> some help
>>>
>>> https://github.com/web2py/web2py/issues/1646
>>>
>>>
>>> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:

 Dear Massimo,

 I saw your question in the developers group where I cannot post,
 therefore i do it here.

 I am currently aware of the following issues to be fixed:

 1. Google 2nd generation SQL is definitely a problem. Please note I
 made a temporary hack to fix it, described here:
 https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g

 2. We have a long overdue issue with the password reset emails not
 sending on GAE. I am using a temporary dirty workaround that sends a plain
 text new password, search for the issue about "lazyT object being passed to
 GAE".

 3. I am having trouble making the date picker work nicely across all
 browsers, especially where there is a native solution. Microsoft Edge is
 the worst case. In general, would be good to have a nicer date picker

 4. General comment: We have "batteries included", however, some of
 those batteries now have newer versions than included, e.g. bootstrap




 --
>>> 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- 

Re: [web2py] Re: web2py 2.15.1

[Anthony]

I'm not sure it would really have to support Python date formatting. 
Couldn't we just specify the appropriate default formats in web2py_ajax.html 

 
and then point users to the Flatpickr documentation if they want to use 
alternative formats (they'll need the Flatpickr documentation anyway to 
make other types of customizations)?

Anthony

On Monday, June 26, 2017 at 10:16:05 AM UTC-4, Richard wrote:
>
> To integrate flatpickr a flatpickr plugin should be write to support 
> python date time string formating : http://strftime.org/
>
> That what have been suggested by flatpickr devs :
> https://github.com/chmln/flatpickr/issues/886
>
> I try to integrate flatpickr here and it get muddy along the road as I 
> learn flatpickr API for datetime formating which is javascript compliant if 
> compliant to anything at all... Code here : 
> https://github.com/BuhtigithuB/web2py/tree/improve/replace-calendar-time-picker-by-flatpicker
>
> It works, but you have to support all kinds of datetime string formatting 
> for which you will have a lot of logic to write... This logic should be 
> write once as a flatpickr plugin to me...
>
> Calendar may be ogly but by accepting python switches : 
> http://www.dynarch.com/jscal/#printDate
>
> It made it a really good fit...
>
> I don't really have time to work on a flatpickr plugin...
>
> Richard
>
> On Fri, Jun 23, 2017 at 10:36 AM, Oasis Agano  
> wrote:
>
>> i think this guy is working on the flatpickr datepicker but could use 
>> some help
>>
>> https://github.com/web2py/web2py/issues/1646
>>
>>
>> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>>>
>>> Dear Massimo,
>>>
>>> I saw your question in the developers group where I cannot post, 
>>> therefore i do it here.
>>>
>>> I am currently aware of the following issues to be fixed:
>>>
>>> 1. Google 2nd generation SQL is definitely a problem. Please note I made 
>>> a temporary hack to fix it, described here: 
>>> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>>
>>> 2. We have a long overdue issue with the password reset emails not 
>>> sending on GAE. I am using a temporary dirty workaround that sends a plain 
>>> text new password, search for the issue about "lazyT object being passed to 
>>> GAE".
>>>
>>> 3. I am having trouble making the date picker work nicely across all 
>>> browsers, especially where there is a native solution. Microsoft Edge is 
>>> the worst case. In general, would be good to have a nicer date picker
>>>
>>> 4. General comment: We have "batteries included", however, some of those 
>>> batteries now have newer versions than included, e.g. bootstrap
>>>
>>>
>>>
>>>
>>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

To integrate flatpickr a flatpickr plugin should be write to support python
date time string formating : http://strftime.org/

That what have been suggested by flatpickr devs :
https://github.com/chmln/flatpickr/issues/886

I try to integrate flatpickr here and it get muddy along the road as I
learn flatpickr API for datetime formating which is javascript compliant if
compliant to anything at all... Code here :
https://github.com/BuhtigithuB/web2py/tree/improve/replace-calendar-time-picker-by-flatpicker

It works, but you have to support all kinds of datetime string formatting
for which you will have a lot of logic to write... This logic should be
write once as a flatpickr plugin to me...

Calendar may be ogly but by accepting python switches :
http://www.dynarch.com/jscal/#printDate

It made it a really good fit...

I don't really have time to work on a flatpickr plugin...

Richard

On Fri, Jun 23, 2017 at 10:36 AM, Oasis Agano  wrote:

> i think this guy is working on the flatpickr datepicker but could use some
> help
>
> https://github.com/web2py/web2py/issues/1646
>
>
> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>>
>> Dear Massimo,
>>
>> I saw your question in the developers group where I cannot post,
>> therefore i do it here.
>>
>> I am currently aware of the following issues to be fixed:
>>
>> 1. Google 2nd generation SQL is definitely a problem. Please note I made
>> a temporary hack to fix it, described here: https://groups.google.co
>> m/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>
>> 2. We have a long overdue issue with the password reset emails not
>> sending on GAE. I am using a temporary dirty workaround that sends a plain
>> text new password, search for the issue about "lazyT object being passed to
>> GAE".
>>
>> 3. I am having trouble making the date picker work nicely across all
>> browsers, especially where there is a native solution. Microsoft Edge is
>> the worst case. In general, would be good to have a nicer date picker
>>
>> 4. General comment: We have "batteries included", however, some of those
>> batteries now have newer versions than included, e.g. bootstrap
>>
>>
>>
>>
>> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Jim S]

For what it's worth, I disagree with the last statement completely.  I've 
used other frameworks and feel the documentation for web2py is far superior.

Some best practices docs would be nice but that hardly qualifies as poor 
documentation.

-Jim


On Friday, June 23, 2017 at 3:04:11 PM UTC-5, Oasis Agano wrote:
>
> It can be cool to have best practices documentations too;
>
> Unit testing(with auth,decorated methods...),
>
> Continuous Integration(Either travis-ci or jenkins...),
>
> because web2py may have many features but the documentation is still very 
> poor.
>
> kr,
> Oasis
>
>
> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>>
>> Dear Massimo,
>>
>> I saw your question in the developers group where I cannot post, 
>> therefore i do it here.
>>
>> I am currently aware of the following issues to be fixed:
>>
>> 1. Google 2nd generation SQL is definitely a problem. Please note I made 
>> a temporary hack to fix it, described here: 
>> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>
>> 2. We have a long overdue issue with the password reset emails not 
>> sending on GAE. I am using a temporary dirty workaround that sends a plain 
>> text new password, search for the issue about "lazyT object being passed to 
>> GAE".
>>
>> 3. I am having trouble making the date picker work nicely across all 
>> browsers, especially where there is a native solution. Microsoft Edge is 
>> the worst case. In general, would be good to have a nicer date picker
>>
>> 4. General comment: We have "batteries included", however, some of those 
>> batteries now have newer versions than included, e.g. bootstrap
>>
>>
>>
>>
>>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Oasis Agano]

It can be cool to have best practices documentations too;

Unit testing(with auth,decorated methods...),

Continuous Integration(Either travis-ci or jenkins...),

because web2py may have many features but the documentation is still very 
poor.

kr,
Oasis


On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Oasis Agano]

i think this guy is working on the flatpickr datepicker but could use some 
help

https://github.com/web2py/web2py/issues/1646


On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Massimo Di Pierro]

Make a PR

On Friday, 16 June 2017 10:05:48 UTC-5, Oasis Agano wrote:
>
> I think that *flatpickr* should be the default datetime picker for the 
> next Web2py it looks awesome
>
> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>>
>> Dear Massimo,
>>
>> I saw your question in the developers group where I cannot post, 
>> therefore i do it here.
>>
>> I am currently aware of the following issues to be fixed:
>>
>> 1. Google 2nd generation SQL is definitely a problem. Please note I made 
>> a temporary hack to fix it, described here: 
>> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>
>> 2. We have a long overdue issue with the password reset emails not 
>> sending on GAE. I am using a temporary dirty workaround that sends a plain 
>> text new password, search for the issue about "lazyT object being passed to 
>> GAE".
>>
>> 3. I am having trouble making the date picker work nicely across all 
>> browsers, especially where there is a native solution. Microsoft Edge is 
>> the worst case. In general, would be good to have a nicer date picker
>>
>> 4. General comment: We have "batteries included", however, some of those 
>> batteries now have newer versions than included, e.g. bootstrap
>>
>>
>>
>>
>>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Go ahead and integrate it... We shouldn't wait for that before launch long
awaiting new web2py version to me.

Richard

On Fri, Jun 16, 2017 at 11:05 AM, Oasis Agano  wrote:

> I think that *flatpickr* should be the default datetime picker for the
> next Web2py it looks awesome
>
> On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>>
>> Dear Massimo,
>>
>> I saw your question in the developers group where I cannot post,
>> therefore i do it here.
>>
>> I am currently aware of the following issues to be fixed:
>>
>> 1. Google 2nd generation SQL is definitely a problem. Please note I made
>> a temporary hack to fix it, described here: https://groups.google.co
>> m/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>
>> 2. We have a long overdue issue with the password reset emails not
>> sending on GAE. I am using a temporary dirty workaround that sends a plain
>> text new password, search for the issue about "lazyT object being passed to
>> GAE".
>>
>> 3. I am having trouble making the date picker work nicely across all
>> browsers, especially where there is a native solution. Microsoft Edge is
>> the worst case. In general, would be good to have a nicer date picker
>>
>> 4. General comment: We have "batteries included", however, some of those
>> batteries now have newer versions than included, e.g. bootstrap
>>
>>
>>
>>
>> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Oasis Agano]

I think that *flatpickr* should be the default datetime picker for the next 
Web2py it looks awesome

On Monday, June 5, 2017 at 10:39:11 AM UTC+2, Karoly Kantor wrote:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

On Wed, Jun 14, 2017 at 6:22 PM, Anthony  wrote:

> On Wednesday, June 14, 2017 at 2:33:58 PM UTC-4, Richard wrote:
>>
>> Anthony,
>>
>> What are the issue with Calendar?? I know it outdated, support seems to
>> shade away (http://www.dynarch.com/ -> Website down and a link to
>> documentation is provide...
>>
>
> See OP.
>
>
>> I had step back from implementing flatpickr, maybe we should to write
>> down requirements and evaluate various alternative to Calendar. Our at
>> least evaluate the path to flatpickr implementation... I thought it would
>> have been much more straight foward and I don't have enough time on my hand
>> right now to keep digging and workaround the issue that kick in during the
>> process...
>>
>
> Sure. I didn't do any extensive evaluation, though I suspect flatpickr
> could be made to work.
>

I am sure too, but it requires a lot of logic to be write on our side if we
want it to sopport all kind of python datetime formatting... It would be
better to modify flatpickr to support that out of the box... I open a
ticket on flatpickr github... But I think we should investigate on
moment.js, I read it supported by flatpickr, so it could or not make things
simpler...


>
>>
>> There is alternative :
>>
>> https://github.com/dbushell/Pikaday (had many contributors 50), they
>> mention it works well with Moment.js, which seems to make simpler to
>> configure datetime display base on locales, so we could have just to pass
>> locales...
>>
>
> Not bad, but the default styling isn't as nice, and doesn't handle times.
>
>
>> flatpickr (92 contributors)
>> https://github.com/nazar-pc/PickMeUp
>> 
>> (10 contributors)
>>
>
> Also nice, though depends on jQuery and doesn't handle times.
>
>
>> But maybe we could anticipate what comming up with web3py and pickup
>> Moment.js or postpone to web3py and do more stuff on client-side with
>> moment.js, but right now flatpickr don't seems to me a better fit then
>> Calendar which is relyable play well with python datetime.
>>
>
> As web3py will use Vue.js on the client-side, a Vue date/time picker would
> be most appropriate.
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Anthony]

On Wednesday, June 14, 2017 at 2:33:58 PM UTC-4, Richard wrote:
>
> Anthony,
>
> What are the issue with Calendar?? I know it outdated, support seems to 
> shade away (http://www.dynarch.com/ -> Website down and a link to 
> documentation is provide...
>

See OP.
 

> I had step back from implementing flatpickr, maybe we should to write down 
> requirements and evaluate various alternative to Calendar. Our at least 
> evaluate the path to flatpickr implementation... I thought it would have 
> been much more straight foward and I don't have enough time on my hand 
> right now to keep digging and workaround the issue that kick in during the 
> process...
>

Sure. I didn't do any extensive evaluation, though I suspect flatpickr 
could be made to work.
 

>
> There is alternative :
>
> https://github.com/dbushell/Pikaday (had many contributors 50), they 
> mention it works well with Moment.js, which seems to make simpler to 
> configure datetime display base on locales, so we could have just to pass 
> locales...
>

Not bad, but the default styling isn't as nice, and doesn't handle times.
 

> flatpickr (92 contributors)
> https://github.com/nazar-pc/PickMeUp 
> 
>  
> (10 contributors)
>

Also nice, though depends on jQuery and doesn't handle times.
 

> But maybe we could anticipate what comming up with web3py and pickup 
> Moment.js or postpone to web3py and do more stuff on client-side with 
> moment.js, but right now flatpickr don't seems to me a better fit then 
> Calendar which is relyable play well with python datetime.
>

As web3py will use Vue.js on the client-side, a Vue date/time picker would 
be most appropriate.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Anthony,

What are the issue with Calendar?? I know it outdated, support seems to
shade away (http://www.dynarch.com/ -> Website down and a link to
documentation is provide...

But it plays so well with python date/datetime formatting string...

I had step back from implementing flatpickr, maybe we should to write down
requirements and evaluate various alternative to Calendar. Our at least
evaluate the path to flatpickr implementation... I thought it would have
been much more straight foward and I don't have enough time on my hand
right now to keep digging and workaround the issue that kick in during the
process...

There is alternative :

https://github.com/dbushell/Pikaday (had many contributors 50), they
mention it works well with Moment.js, which seems to make simpler to
configure datetime display base on locales, so we could have just to pass
locales...
flatpickr (92 contributors)
https://github.com/nazar-pc/PickMeUp (10 contributors)

Flatpickr seems the new kid on the block and the edge date picker lib
available...

But maybe we could anticipate what comming up with web3py and pickup
Moment.js or postpone to web3py and do more stuff on client-side with
moment.js, but right now flatpickr don't seems to me a better fit then
Calendar which is relyable play well with python datetime.

We can use flatpickr for time though as we don't have any picker for this
field type if we determine that we will integrate and replace Calendar...

Richard




On Tue, Jun 13, 2017 at 3:38 PM, Richard Vézina  wrote:

> Hmm, I had a look at the code of flatpickr for fromatting :
> https://github.com/chmln/flatpickr/blob/master/src/flatpickr.js#L1461
>
> Would require a major refactor to support python string fromatting
> datetime parameter '%Y-%m-%d %H:%M:%S'
>
> Also it doesn't seems to support timezone...
>
>
> https://chmln.github.io/flatpickr/formatting/
>
> On Mon, Jun 12, 2017 at 4:01 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Here : https://github.com/web2py/web2py/commit/0205594f0853680e7c
>> 548dd0c506640958e36f1b
>>
>> Just go to : welcome/default/test_flatpickr, a dummy form with the 3
>> field types date, datetime, time demo
>>
>> Meaningful changes are mostly at the top and the bottom of diff...
>>
>> Remain to manger i18n and figure out what to do with datetime... I think
>> date is correct and time if default widget config with seconds is
>> acceptable we are done. For datetime as mention it more complexe... Maybe
>> we could propose enhancement to flatpickr to support default web2py style
>> datetime formatting like '%Y-%m-%d %H:%M:%S'... Calendar was supporting
>> that... But I am not sure if there is any standard way to specify datetime
>> string format??
>>
>> Richard
>>
>> On Mon, Jun 12, 2017 at 3:47 PM, Richard Vézina <
>> ml.richard.vez...@gmail.com> wrote:
>>
>>> Ok, I figure this out, I mean it work with only change into web2py.js
>>> and web2py_ajax.html with web2py-master (up to date)...
>>>
>>> I should remove reference to web2py_ajax.js in this comment and replace
>>> it with web2py.js I guess??
>>>
>>> Have you any input regarding the previous message about flatpickr
>>> integration and backward compatibility...
>>>
>>> I will share the mods I made so far from my fork and share the a link
>>> pointing to it here ASAP.
>>>
>>> Richard
>>>
>>> On Mon, Jun 12, 2017 at 3:43 PM, Anthony  wrote:
>>>
 On Monday, June 12, 2017 at 2:28:21 PM UTC-4, Richard wrote:
>
> Also, I am not sure what happen with web2py_ajax.*js *I found
> reference to it in web2py_ajax*.html*
>

 You must have a very old version -- web2py_ajax.js was changed to
 web2py.js a long time ago.

 Anthony

 --
 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 unsubscribe from this group and stop receiving emails from it, send
 an email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Hmm, I had a look at the code of flatpickr for fromatting :
https://github.com/chmln/flatpickr/blob/master/src/flatpickr.js#L1461

Would require a major refactor to support python string fromatting datetime
parameter '%Y-%m-%d %H:%M:%S'

Also it doesn't seems to support timezone...


https://chmln.github.io/flatpickr/formatting/

On Mon, Jun 12, 2017 at 4:01 PM, Richard Vézina  wrote:

> Here : https://github.com/web2py/web2py/commit/
> 0205594f0853680e7c548dd0c506640958e36f1b
>
> Just go to : welcome/default/test_flatpickr, a dummy form with the 3
> field types date, datetime, time demo
>
> Meaningful changes are mostly at the top and the bottom of diff...
>
> Remain to manger i18n and figure out what to do with datetime... I think
> date is correct and time if default widget config with seconds is
> acceptable we are done. For datetime as mention it more complexe... Maybe
> we could propose enhancement to flatpickr to support default web2py style
> datetime formatting like '%Y-%m-%d %H:%M:%S'... Calendar was supporting
> that... But I am not sure if there is any standard way to specify datetime
> string format??
>
> Richard
>
> On Mon, Jun 12, 2017 at 3:47 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Ok, I figure this out, I mean it work with only change into web2py.js and
>> web2py_ajax.html with web2py-master (up to date)...
>>
>> I should remove reference to web2py_ajax.js in this comment and replace
>> it with web2py.js I guess??
>>
>> Have you any input regarding the previous message about flatpickr
>> integration and backward compatibility...
>>
>> I will share the mods I made so far from my fork and share the a link
>> pointing to it here ASAP.
>>
>> Richard
>>
>> On Mon, Jun 12, 2017 at 3:43 PM, Anthony  wrote:
>>
>>> On Monday, June 12, 2017 at 2:28:21 PM UTC-4, Richard wrote:

 Also, I am not sure what happen with web2py_ajax.*js *I found
 reference to it in web2py_ajax*.html*

>>>
>>> You must have a very old version -- web2py_ajax.js was changed to
>>> web2py.js a long time ago.
>>>
>>> Anthony
>>>
>>> --
>>> 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Here :
https://github.com/web2py/web2py/commit/0205594f0853680e7c548dd0c506640958e36f1b

Just go to : welcome/default/test_flatpickr, a dummy form with the 3 field
types date, datetime, time demo

Meaningful changes are mostly at the top and the bottom of diff...

Remain to manger i18n and figure out what to do with datetime... I think
date is correct and time if default widget config with seconds is
acceptable we are done. For datetime as mention it more complexe... Maybe
we could propose enhancement to flatpickr to support default web2py style
datetime formatting like '%Y-%m-%d %H:%M:%S'... Calendar was supporting
that... But I am not sure if there is any standard way to specify datetime
string format??

Richard

On Mon, Jun 12, 2017 at 3:47 PM, Richard Vézina  wrote:

> Ok, I figure this out, I mean it work with only change into web2py.js and
> web2py_ajax.html with web2py-master (up to date)...
>
> I should remove reference to web2py_ajax.js in this comment and replace it
> with web2py.js I guess??
>
> Have you any input regarding the previous message about flatpickr
> integration and backward compatibility...
>
> I will share the mods I made so far from my fork and share the a link
> pointing to it here ASAP.
>
> Richard
>
> On Mon, Jun 12, 2017 at 3:43 PM, Anthony  wrote:
>
>> On Monday, June 12, 2017 at 2:28:21 PM UTC-4, Richard wrote:
>>>
>>> Also, I am not sure what happen with web2py_ajax.*js *I found reference
>>> to it in web2py_ajax*.html*
>>>
>>
>> You must have a very old version -- web2py_ajax.js was changed to
>> web2py.js a long time ago.
>>
>> Anthony
>>
>> --
>> 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Ok, I figure this out, I mean it work with only change into web2py.js and
web2py_ajax.html with web2py-master (up to date)...

I should remove reference to web2py_ajax.js in this comment and replace it
with web2py.js I guess??

Have you any input regarding the previous message about flatpickr
integration and backward compatibility...

I will share the mods I made so far from my fork and share the a link
pointing to it here ASAP.

Richard

On Mon, Jun 12, 2017 at 3:43 PM, Anthony  wrote:

> On Monday, June 12, 2017 at 2:28:21 PM UTC-4, Richard wrote:
>>
>> Also, I am not sure what happen with web2py_ajax.*js *I found reference
>> to it in web2py_ajax*.html*
>>
>
> You must have a very old version -- web2py_ajax.js was changed to
> web2py.js a long time ago.
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Anthony]

On Monday, June 12, 2017 at 2:28:21 PM UTC-4, Richard wrote:
>
> Also, I am not sure what happen with web2py_ajax.*js *I found reference 
> to it in web2py_ajax*.html*
>

You must have a very old version -- web2py_ajax.js was changed to web2py.js 
a long time ago.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Also, I am not sure what happen with web2py_ajax.*js *I found reference to
it in web2py_ajax*.html*

quote:

// These variables are used by the web2py_ajax_init function in
web2py_ajax.js (which is loaded below).

But it seems to have been removed??

I try to search the list and github for explanations without success...

Richard

On Mon, Jun 12, 2017 at 2:23 PM, Richard Vézina  wrote:

> I made some progress... It relatively straigh foward to replace Calendar...
>
> I am reading IS_TIME() validator which handle time with second or not... I
> am not sure how I could translate that with time picker from flatpicker
> which use enableSeconds boolean flag to determine if it requires second or
> not in the widget... web2py IS_TIME() surely handle both, but should I set
> as a default for time picker to include seconds... If we don't I am not
> sure web2py end users can specify flatpickr to support second without
> having to go in web2py.js and set enableSeconds to "true"... I would say it
> better to just manualy erase second in the input field than not having
> access to the feature at all from the widget???! What do you think?
>
> It similar for datetime... Flatpickr don't support this way of configuring
> the time part : '%Y-%m-%d %H:%M:%S'. Date and time are configure separatly,
> I work around in a backward compatible way the date part by stripping all
> the "%" as Flatpickr use "Y-m-d" format specification instead of "%Y-%m-%d"
> in case of date type field. But datetime type field is more difficult to
> manage... I guess we will need to write some logic in js to parse web2py
> datetime configuration string to set flatpickr default time flags properly
> which is a tedious task...
>
> I will have look at internationalization...
>
> Richard
>
>
>
>
> On Fri, Jun 9, 2017 at 3:17 AM, Jörg Schneider 
> wrote:
>
>> +1
>>
>> --
>> 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

I made some progress... It relatively straigh foward to replace Calendar...

I am reading IS_TIME() validator which handle time with second or not... I
am not sure how I could translate that with time picker from flatpicker
which use enableSeconds boolean flag to determine if it requires second or
not in the widget... web2py IS_TIME() surely handle both, but should I set
as a default for time picker to include seconds... If we don't I am not
sure web2py end users can specify flatpickr to support second without
having to go in web2py.js and set enableSeconds to "true"... I would say it
better to just manualy erase second in the input field than not having
access to the feature at all from the widget???! What do you think?

It similar for datetime... Flatpickr don't support this way of configuring
the time part : '%Y-%m-%d %H:%M:%S'. Date and time are configure separatly,
I work around in a backward compatible way the date part by stripping all
the "%" as Flatpickr use "Y-m-d" format specification instead of "%Y-%m-%d"
in case of date type field. But datetime type field is more difficult to
manage... I guess we will need to write some logic in js to parse web2py
datetime configuration string to set flatpickr default time flags properly
which is a tedious task...

I will have look at internationalization...

Richard




On Fri, Jun 9, 2017 at 3:17 AM, Jörg Schneider  wrote:

> +1
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Jörg Schneider]

+1

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Anthony]

Note, flatpickr supports dates, datetimes, and times, so it can replace 
both the calendar widget and the timeEntry widget.

Anthony

On Thursday, June 8, 2017 at 10:28:59 AM UTC-4, Richard wrote:
>
> Will give a try... Hope it not too difficult to do, I don't have much 
> time...
>
> Richard
>
> On Wed, Jun 7, 2017 at 4:46 PM, Carlos Costa  
> wrote:
>
>> +1 on date picker. It is totally outdated.
>>
>> Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor 
>> escreveu:
>>>
>>> Dear Massimo,
>>>
>>> I saw your question in the developers group where I cannot post, 
>>> therefore i do it here.
>>>
>>> I am currently aware of the following issues to be fixed:
>>>
>>> 1. Google 2nd generation SQL is definitely a problem. Please note I made 
>>> a temporary hack to fix it, described here: 
>>> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>>
>>> 2. We have a long overdue issue with the password reset emails not 
>>> sending on GAE. I am using a temporary dirty workaround that sends a plain 
>>> text new password, search for the issue about "lazyT object being passed to 
>>> GAE".
>>>
>>> 3. I am having trouble making the date picker work nicely across all 
>>> browsers, especially where there is a native solution. Microsoft Edge is 
>>> the worst case. In general, would be good to have a nicer date picker
>>>
>>> 4. General comment: We have "batteries included", however, some of those 
>>> batteries now have newer versions than included, e.g. bootstrap
>>>
>>>
>>>
>>>
>>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Marlysson Silva]

+1 to change built in date picker , I same already changed it by other in 
my apps .

Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor escreveu:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

Will give a try... Hope it not too difficult to do, I don't have much
time...

Richard

On Wed, Jun 7, 2017 at 4:46 PM, Carlos Costa 
wrote:

> +1 on date picker. It is totally outdated.
>
> Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor
> escreveu:
>>
>> Dear Massimo,
>>
>> I saw your question in the developers group where I cannot post,
>> therefore i do it here.
>>
>> I am currently aware of the following issues to be fixed:
>>
>> 1. Google 2nd generation SQL is definitely a problem. Please note I made
>> a temporary hack to fix it, described here: https://groups.google.co
>> m/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>>
>> 2. We have a long overdue issue with the password reset emails not
>> sending on GAE. I am using a temporary dirty workaround that sends a plain
>> text new password, search for the issue about "lazyT object being passed to
>> GAE".
>>
>> 3. I am having trouble making the date picker work nicely across all
>> browsers, especially where there is a native solution. Microsoft Edge is
>> the worst case. In general, would be good to have a nicer date picker
>>
>> 4. General comment: We have "batteries included", however, some of those
>> batteries now have newer versions than included, e.g. bootstrap
>>
>>
>>
>>
>> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Carlos Costa]

+1 on date picker. It is totally outdated.

Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor escreveu:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Jim S]

+1

On Wednesday, June 7, 2017 at 2:03:09 PM UTC-5, Richard wrote:
>
> flatpickr seems really nice... Any reason why we don't replace the actual 
> "built-in" calendar that we ship web2py with?
>
> Richard
>
> On Tue, Jun 6, 2017 at 9:31 AM, Anthony  
> wrote:
>
>> On Tuesday, June 6, 2017 at 5:02:10 AM UTC-4, tim.n...@conted.ox.ac.uk 
>>  wrote:
>>>
>>> Re #3: I highly recommend swapping in Eonasdan's 
>>> bootstrap-datetimepicker: 
>>> https://github.com/Eonasdan/bootstrap-datetimepicker
>>>
>>
>> That's nice but is tied to Bootstrap and has a lot of dependencies. 
>> Something more lightweight, such as https://chmln.github.io/flatpickr/, 
>> might be more appropriate.
>>
>> Anthony
>>
>> -- 
>> 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py 2.15.1

[Richard Vézina]

flatpickr seems really nice... Any reason why we don't replace the actual
"built-in" calendar that we ship web2py with?

Richard

On Tue, Jun 6, 2017 at 9:31 AM, Anthony  wrote:

> On Tuesday, June 6, 2017 at 5:02:10 AM UTC-4, tim.nyb...@conted.ox.ac.uk
> wrote:
>>
>> Re #3: I highly recommend swapping in Eonasdan's
>> bootstrap-datetimepicker: https://github.com/Eonasdan/bo
>> otstrap-datetimepicker
>>
>
> That's nice but is tied to Bootstrap and has a lot of dependencies.
> Something more lightweight, such as https://chmln.github.io/flatpickr/,
> might be more appropriate.
>
> Anthony
>
> --
> 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 unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[Anthony]

On Tuesday, June 6, 2017 at 5:02:10 AM UTC-4, tim.nyb...@conted.ox.ac.uk 
wrote:
>
> Re #3: I highly recommend swapping in Eonasdan's bootstrap-datetimepicker: 
> https://github.com/Eonasdan/bootstrap-datetimepicker
>

That's nice but is tied to Bootstrap and has a lot of dependencies. 
Something more lightweight, such as https://chmln.github.io/flatpickr/, 
might be more appropriate.

Anthony

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py 2.15.1

[tim . nyborg]

Re #3: I highly recommend swapping in Eonasdan's bootstrap-datetimepicker: 
https://github.com/Eonasdan/bootstrap-datetimepicker

I just altered my web2py_ajax.html to swap dependencies and initialize 
datepickers:

# response.files.insert(1,'/inc/css/calendar.css')
# response.files.insert(2,'/inc/js/web2py/calendar.js')

# Replacing web2py calendar with bootstrap datetimepicker
response.files.insert(1, 
"/inc/js/eonasdan-bootstrap-datetimepicker/build/css/bootstrap-datetimepicker.min.css")
response.files.insert(2, "/inc/js/moment/moment.js")
response.files.insert(3, 
"/inc/js/eonasdan-bootstrap-datetimepicker/build/js/bootstrap-datetimepicker.min.js")


// Initialize bootstrap datetimepicker
$(function (){
$('.date').datetimepicker({
format: '-MM-DD',
keyBinds: null, // Stop keypresses from navigating the widget, 
allowing users to edit date/times normally
}); 
$('.datetime').datetimepicker({
format: '-MM-DD HH:mm',
useCurrent: 'day',  // This pulls out the current day, without 
the current time (00:00 default)
keyBinds: null, // Stop keypresses from navigating the widget, 
allowing users to edit date/times normally
});
});

Enter code here...





On Monday, 5 June 2017 09:39:11 UTC+1, Karoly Kantor wrote:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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 unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.