Re: [web2py] web3py -> py4web

[Juan M. Chapa Z.]

Great!
El jul 24, 2019 12:40 a.m., "Massimo Di Pierro" 
escribió:

> OK. I know. I am not good with names.
> But there are lots of requirements to be fulfilled.
> py4web.com was available and the pypi package was available.
> Here is running on google cloud:
> http://py4web.com/
>
> Ducking...
>
> --
> 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.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/web2py/02406920-bc9b-4b08-96df-59d62e70b613%40googlegroups.com
> 
> .
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAMKmza_oyyqNmb29P%3Dj9B9Qf%3DZ8xnC%3DM7WhztegxNacRuH00%3DQ%40mail.gmail.com.

Re: [web2py] web3py -> py4web

[Manuele Pesenti]

I'm loving it!

Thanks again Massimo

    Manuele

On 24/07/19 07:40, Massimo Di Pierro wrote:

OK. I know. I am not good with names.
But there are lots of requirements to be fulfilled.
py4web.com was available and the pypi package was available.
Here is running on google cloud:
http://py4web.com/

Ducking...


--
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/9d067bf5-9ba8-ab8a-d226-8365f4eae917%40gmail.com.

[web2py] web3py -> py4web

[Massimo Di Pierro]

OK. I know. I am not good with names. 
But there are lots of requirements to be fulfilled.
py4web.com was available and the pypi package was available.
Here is running on google cloud:
http://py4web.com/

Ducking...

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/02406920-bc9b-4b08-96df-59d62e70b613%40googlegroups.com.

[web2py] Web3py FORM referenced fields

[John Bannister]

Hi All,

Does anyone have a working example of web3py Form using referenced fields?

I have created the standard person / pets tables with pets referencing 
person as 'reference person' in the table definition.

Using form=Form(db.pet) I get the dropdown of persons for the add no 
worries but on the form=Form(db.pet, record=id) for the edit form .. 
neither the id of the person or the persons name (format='%(name)s' is 
displayed even though I can still select from the dropdown list. The id is 
definately stored in the db.

BR
John




-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/676f67a8-1431-4fe3-9766-9272701f4a69%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web3py Auth

[villas]

Hi Massimo
Thanks for the auth implementation.  However, I personally think Groups are 
an essential feature of any auth.

As a suggestion, could you please consider at least a slimmed-down version 
of Groups.  I am thinking simply this:

   - Extra field:  auth_user.group_ids list:reference
   - Table:  auth_group,  (id, name)
   - Function:  is_user_in_groups(user=auth.user, groups=[], all=True) 
  - if all==False* then 'any'* 
  - groups could be list of ids or names   
  
Many thanks for your consideration!  D

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/efd1ede6-ba58-49de-9120-502ef7956b86%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[Massimo Di Pierro]

Please consider that it is not finished. As soon as done I will write some 
documentation. But basically you include utils.js, vue.min.js, 
axios.min.js, components/mtable.js and the you embed it







as a vue component.

On Thursday, 16 May 2019 08:31:23 UTC-7, John Bannister wrote:
>
> Hi Massimo,
>
> Had a quick look at the mtable prototype in the _dashboad/dbadmin and 
> re-visiting datatables as well. Will need to spend a bit more time on both 
> before I can come to any sort of solution but thanks very much for the 
> input. 
>
> On Thursday, 16 May 2019 16:50:48 UTC+2, Massimo Di Pierro wrote:
>>
>> Web3py will have a replacement for smartgrid based on vue. You can look 
>> at the mtable component already in there as a prototype. Anyway, nothing 
>> wrong with datatables.
>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/1e07a734-6039-45b7-a351-0ae313a366c7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[John Bannister]

Hi Massimo,

Had a quick look at the mtable prototype in the _dashboad/dbadmin and 
re-visiting datatables as well. Will need to spend a bit more time on both 
before I can come to any sort of solution but thanks very much for the 
input. 

On Thursday, 16 May 2019 16:50:48 UTC+2, Massimo Di Pierro wrote:
>
> Web3py will have a replacement for smartgrid based on vue. You can look at 
> the mtable component already in there as a prototype. Anyway, nothing wrong 
> with datatables.

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ea2307b5-7547-49db-b172-b049b82aace4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web3py

[John Bannister]

Hi All,

Had a first real 'play' with web3py' today and have a few questions the 
biggest of which I am hoping the gurus will be able to answer:-

1: Is there any way to not to have to restart the app every time changes 
are made to actions in the controller or new actions added etc? I 
understand that controllers are basically being imported when the app fires 
up but is any there any way to occasionally reload instead of having to 
restart the app? This is a fairly big one for me as sometimes tweaks will 
need to be made in production and restarting the web server is not really 
an option so hopefully I am missing something really simple.

Thanks in advance
John






  

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/51ba492d-542e-4d2d-a620-1776ca2a5bb2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[Massimo Di Pierro]

Web3py will have a replacement for smartgrid based on vue. You can look at the 
mtable component already in there as a prototype. Anyway, nothing wrong with 
datatables.

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/4b5a07bd-4d63-4404-a1ca-01db37b11aa7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[John Bannister]

Hi Jose,

Completely understandable on the code side of things and appreciate your 
sharing. I will for sure revisit the Datatables option this week with the 
information you have provided.

Once again thanks for your time and assistance
John

On Thursday, 16 May 2019 13:06:46 UTC+2, José L. wrote:
>
> I can't show you all the code because the property belongs to the person 
> who asked me to do it, 
> This is the part that takes the dataables json requests, fetch the records 
> and format them to be understood by datatables. I am skipping the 
> sorting/filtering part , that builds the  *query_filter* and *orderby* 
> variables
> I have also changed the table name by MY_TABLE and remove one field name. 
>
> Also, beware in this case the total number of records uses count(), you 
> will have to replace it if your table has many records.
>
> Hope it helps you.
> José L.
>
> @service.jsondef logs_table():
> query_filter = None
>
> if request.vars.start is not None:
> iDisplayStart = int(request.vars.start)
> else:
> iDisplayStart = 0
>
> if request.vars.length is not None:
> iDisplayLength = int(request.vars.length)
> else:
> iDisplayLength = 10
>
> if request.vars.draw is not None:
> sEcho = int(request.vars.draw)
> else:
> sEcho = 1
>
> 
>
> 
>
> query = db(query_filter).select(db.MY_TABLE.ALL,
> limitby=(iDisplayStart, iDisplayStart + iDisplayLength),
> orderby=orderby)
>
> iTotalRecords = db(query_filter).count()
>
> # iTotalRecords = 100
> aaData = []
>
> for row in query:
> datarow = {}
> for col in row:
> if row[col] is not None:
> if col == 'MY_TABLE' or '_record' in col:
> # internal dal col names
> continue
> elif col == 'name of field that is a datetime':
> datarow[col] = row[col].strftime('%Y-%m-%d %H:%M:%S')
> else:
> datarow[col] = row[col]
> else:
> datarow[col] = ''
>
> aaData.append(datarow)
> return dict(draw=sEcho, recordsTotal=iTotalRecords, 
> recordsFiltered=iTotalRecords, data=aaData)
>
>
> El jue., 16 may. 2019 a las 12:51, John Bannister ( >) escribió:
>
>> Hey Jose,
>>
>> Thanks for the quick response. Much appreciated. Do you happen to have a 
>> small working example of Datatables setup in server mode that I could take 
>> a look at to hopefully save some time? I last looked at it a few years ago 
>> as mentioned and any pointers would be great.
>>
>> Thanks in advance
>> John
>>
>> On Thursday, 16 May 2019 12:42:17 UTC+2, José L. wrote:
>>>
>>> Hey John, 
>>>
>>> I have used datatables with web2py in some projects and it was faster 
>>> than smartgrid when used in server mode.
>>> Whenever I had performance problems was because the code used .count() 
>>> to show the total number of records. In my case the tables have several 
>>> millions of records and that was way too slow. 
>>> That's a common problem in many databases engines, not a datatables 
>>> problem.
>>>
>>> When using an aprox. number instead of executing the sql count() 
>>> command, the datatable works fine showing hundred of rows from a table.
>>>
>>> You have to make your own code for the server side, to support filter or 
>>> sort if you need them, but it's quite straightforward.
>>>
>>> José L.
>>>
>>> El jue., 16 may. 2019 a las 11:42, John Bannister () 
>>> escribió:
>>>
 Hi All,

 I have a number of web2py applications that use the grid/smartgrid 
 functionality pretty heavily. The majority of the applications are working 
 with large data sets (some tables have > 20M records) and everything runs 
 fine.

 With the coming of Web3Py (which looks great) my question is what would 
 be a viable equivalent to web2py's grid/smartgrid?

 I looked at Datatables some time back which worked great on smaller 
 datasets but anything over 50K (on my testbed) starts to become unusable. 
 I 
 also implemented some server side processing for Datatables but never 
 quite 
 managed to get a usable solution or at least nothing that could handle big 
 data sets as efficiently as web2py.

 So basically looking for something that can handle large datasets that 
 will plug into web3py if anyone has any recommendations they would be much 
 appreciated or if anyone has managed to get Datatables working well with 
 large data sets some guidance would be great.

 Thanks in advance

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

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[José Luis Redrejo]

I can't show you all the code because the property belongs to the person
who asked me to do it,
This is the part that takes the dataables json requests, fetch the records
and format them to be understood by datatables. I am skipping the
sorting/filtering part , that builds the  *query_filter* and *orderby*
variables
I have also changed the table name by MY_TABLE and remove one field name.

Also, beware in this case the total number of records uses count(), you
will have to replace it if your table has many records.

Hope it helps you.
José L.

@service.jsondef logs_table():
query_filter = None

if request.vars.start is not None:
iDisplayStart = int(request.vars.start)
else:
iDisplayStart = 0

if request.vars.length is not None:
iDisplayLength = int(request.vars.length)
else:
iDisplayLength = 10

if request.vars.draw is not None:
sEcho = int(request.vars.draw)
else:
sEcho = 1





query = db(query_filter).select(db.MY_TABLE.ALL,
limitby=(iDisplayStart, iDisplayStart + iDisplayLength),
orderby=orderby)

iTotalRecords = db(query_filter).count()

# iTotalRecords = 100
aaData = []

for row in query:
datarow = {}
for col in row:
if row[col] is not None:
if col == 'MY_TABLE' or '_record' in col:
# internal dal col names
continue
elif col == 'name of field that is a datetime':
datarow[col] = row[col].strftime('%Y-%m-%d %H:%M:%S')
else:
datarow[col] = row[col]
else:
datarow[col] = ''

aaData.append(datarow)
return dict(draw=sEcho, recordsTotal=iTotalRecords,
recordsFiltered=iTotalRecords, data=aaData)


El jue., 16 may. 2019 a las 12:51, John Bannister ()
escribió:

> Hey Jose,
>
> Thanks for the quick response. Much appreciated. Do you happen to have a
> small working example of Datatables setup in server mode that I could take
> a look at to hopefully save some time? I last looked at it a few years ago
> as mentioned and any pointers would be great.
>
> Thanks in advance
> John
>
> On Thursday, 16 May 2019 12:42:17 UTC+2, José L. wrote:
>>
>> Hey John,
>>
>> I have used datatables with web2py in some projects and it was faster
>> than smartgrid when used in server mode.
>> Whenever I had performance problems was because the code used .count() to
>> show the total number of records. In my case the tables have several
>> millions of records and that was way too slow.
>> That's a common problem in many databases engines, not a datatables
>> problem.
>>
>> When using an aprox. number instead of executing the sql count() command,
>> the datatable works fine showing hundred of rows from a table.
>>
>> You have to make your own code for the server side, to support filter or
>> sort if you need them, but it's quite straightforward.
>>
>> José L.
>>
>> El jue., 16 may. 2019 a las 11:42, John Bannister ()
>> escribió:
>>
>>> Hi All,
>>>
>>> I have a number of web2py applications that use the grid/smartgrid
>>> functionality pretty heavily. The majority of the applications are working
>>> with large data sets (some tables have > 20M records) and everything runs
>>> fine.
>>>
>>> With the coming of Web3Py (which looks great) my question is what would
>>> be a viable equivalent to web2py's grid/smartgrid?
>>>
>>> I looked at Datatables some time back which worked great on smaller
>>> datasets but anything over 50K (on my testbed) starts to become unusable. I
>>> also implemented some server side processing for Datatables but never quite
>>> managed to get a usable solution or at least nothing that could handle big
>>> data sets as efficiently as web2py.
>>>
>>> So basically looking for something that can handle large datasets that
>>> will plug into web3py if anyone has any recommendations they would be much
>>> appreciated or if anyone has managed to get Datatables working well with
>>> large data sets some guidance would be great.
>>>
>>> Thanks in advance
>>>
>>> --
>>> 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 web...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.com
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
> Resources:
> - http://web2py.com
> - 

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[John Bannister]

Hey Jose,

Thanks for the quick response. Much appreciated. Do you happen to have a 
small working example of Datatables setup in server mode that I could take 
a look at to hopefully save some time? I last looked at it a few years ago 
as mentioned and any pointers would be great.

Thanks in advance
John

On Thursday, 16 May 2019 12:42:17 UTC+2, José L. wrote:
>
> Hey John, 
>
> I have used datatables with web2py in some projects and it was faster than 
> smartgrid when used in server mode.
> Whenever I had performance problems was because the code used .count() to 
> show the total number of records. In my case the tables have several 
> millions of records and that was way too slow. 
> That's a common problem in many databases engines, not a datatables 
> problem.
>
> When using an aprox. number instead of executing the sql count() command, 
> the datatable works fine showing hundred of rows from a table.
>
> You have to make your own code for the server side, to support filter or 
> sort if you need them, but it's quite straightforward.
>
> José L.
>
> El jue., 16 may. 2019 a las 11:42, John Bannister ( >) escribió:
>
>> Hi All,
>>
>> I have a number of web2py applications that use the grid/smartgrid 
>> functionality pretty heavily. The majority of the applications are working 
>> with large data sets (some tables have > 20M records) and everything runs 
>> fine.
>>
>> With the coming of Web3Py (which looks great) my question is what would 
>> be a viable equivalent to web2py's grid/smartgrid?
>>
>> I looked at Datatables some time back which worked great on smaller 
>> datasets but anything over 50K (on my testbed) starts to become unusable. I 
>> also implemented some server side processing for Datatables but never quite 
>> managed to get a usable solution or at least nothing that could handle big 
>> data sets as efficiently as web2py.
>>
>> So basically looking for something that can handle large datasets that 
>> will plug into web3py if anyone has any recommendations they would be much 
>> appreciated or if anyone has managed to get Datatables working well with 
>> large data sets some guidance would be great.
>>
>> Thanks in advance
>>
>> -- 
>> 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 web...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/49640192-d789-44e5-a4e9-db852e8d760f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Web3Py equivalent of SQLFORM.grid

[José Luis Redrejo]

Hey John,

I have used datatables with web2py in some projects and it was faster than
smartgrid when used in server mode.
Whenever I had performance problems was because the code used .count() to
show the total number of records. In my case the tables have several
millions of records and that was way too slow.
That's a common problem in many databases engines, not a datatables problem.

When using an aprox. number instead of executing the sql count() command,
the datatable works fine showing hundred of rows from a table.

You have to make your own code for the server side, to support filter or
sort if you need them, but it's quite straightforward.

José L.

El jue., 16 may. 2019 a las 11:42, John Bannister ()
escribió:

> Hi All,
>
> I have a number of web2py applications that use the grid/smartgrid
> functionality pretty heavily. The majority of the applications are working
> with large data sets (some tables have > 20M records) and everything runs
> fine.
>
> With the coming of Web3Py (which looks great) my question is what would be
> a viable equivalent to web2py's grid/smartgrid?
>
> I looked at Datatables some time back which worked great on smaller
> datasets but anything over 50K (on my testbed) starts to become unusable. I
> also implemented some server side processing for Datatables but never quite
> managed to get a usable solution or at least nothing that could handle big
> data sets as efficiently as web2py.
>
> So basically looking for something that can handle large datasets that
> will plug into web3py if anyone has any recommendations they would be much
> appreciated or if anyone has managed to get Datatables working well with
> large data sets some guidance would be great.
>
> Thanks in advance
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAHpm-q2R19-kd7VqSMmEQbFL7ggKG3d_2UHMz_uF3E7WkMPQjw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web3Py equivalent of SQLFORM.grid

[John Bannister]

Hi All,

I have a number of web2py applications that use the grid/smartgrid 
functionality pretty heavily. The majority of the applications are working 
with large data sets (some tables have > 20M records) and everything runs 
fine.

With the coming of Web3Py (which looks great) my question is what would be 
a viable equivalent to web2py's grid/smartgrid?

I looked at Datatables some time back which worked great on smaller 
datasets but anything over 50K (on my testbed) starts to become unusable. I 
also implemented some server side processing for Datatables but never quite 
managed to get a usable solution or at least nothing that could handle big 
data sets as efficiently as web2py.

So basically looking for something that can handle large datasets that will 
plug into web3py if anyone has any recommendations they would be much 
appreciated or if anyone has managed to get Datatables working well with 
large data sets some guidance would be great.

Thanks in advance

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/8e109e58-f4ac-4272-a835-d86e5101c7fe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Web3py

[En Ware]

I git installed web3py and quite enjoy it. I see its updated regular too. 

For those who don't know and maybe this is common sense , not sure. 

once you *git clone https://github.com/web2py/web3py.git  *do a *git pull*

2. reinstall requirements.txt (*pip3 install -r requirements.txt*) 
 - Changes:  module "reloader" was added 

3. Launch web3py (should work just fine now) 

* python3 web3py.py applications/todo/*

4. open browser and type: * localhost:8000 or 127.0.0.1:8000*

-- 
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] web3py again....

[Massimo Di Pierro]

Nope!
If that is what you do, just use bottle.
The whole point of web2py (which I am trying to preserve in web3py) is that 
the framework can run whether or not you have an application and multiple 
applications can be installed in a plug-and-play fashion. This means it is 
not logically possible for applications to be in changed of including the 
framework. 
Anyway, unlike web2py, web3py does allow this as an option, if you want to 
run a single application. I just have not documented it.


On Saturday, 30 March 2019 22:22:16 UTC-7, Carlos Cesar Caballero wrote:
>
> So far looks good, but I would prefer that the application include (or 
> import) the framework instead of the framework include the application. 
> With the first one, pip based deployments and CI/CD will be a lot easier.
>
> I have being playing with bottle a lot recently, so if there is some 
> web3py features list or guidelines, maybe I can give a hand.
>
> Greetings.
>
>
> El 28/3/19 a las 5:16 a.m., Massimo Di Pierro escribió:
>
> I know this comes up once in a while but ...
>
> https://github.com/web2py/web3py
>
> what do you think? 
>
> It is very preliminary but I will have an admin soon.
> Backporting SQLFORM, grid and Auth, should not be that complicated, 
> although I think we can do better.
>
> 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] web3py again....

[Christopher Smiga]

Hi Massimo and Team,

It's been a several years since contributing to the project, and I'm interested 
in web3py for several reasons such as

* it is a fresh project
* speed
* architecture improvements
* the future of web2py

In this effort, are pyunit (TDD), Python Behave Library (BDD), CI/CD, 
performance testing, functional testing, and code integrity via SonarQube being 
considered in the build process?

Web3Py has the potential of being the next world class web framework. What is 
the plan for development of this new endeavor since automation test development 
is important?

Thanks and regards,
Christopher Smiga
SDET (Software Development Engineer in Test)

-- 
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] web3py again....

[Carlos Cesar Caballero Díaz]

So far looks good, but I would prefer that the application include (or 
import) the framework instead of the framework include the application. 
With the first one, pip based deployments and CI/CD will be a lot easier.


I have being playing with bottle a lot recently, so if there is some 
web3py features list or guidelines, maybe I can give a hand.


Greetings.


El 28/3/19 a las 5:16 a.m., Massimo Di Pierro escribió:

I know this comes up once in a while but ...

    https://github.com/web2py/web3py

what do you think?

It is very preliminary but I will have an admin soon.
Backporting SQLFORM, grid and Auth, should not be that complicated, 
although I think we can do better.


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 
<mailto: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] web3py again....

[黄祥]

interested in github readme :

   - it is not as good as web2py yet, but it is 10-20x faster

perhaps could you share which benchmark method or tools to get this 
conclusion (compare with similar web2py todo apps) ? 

best regards,
stifan

-- 
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] web3py again....

[junderhill]

For authentication, Okta, Azure AD B2C, etc. are options that offload a lot 
of trouble, but I like having a fully-functional Auth built-in and we do 
use it in some projects.  It needs full OIDC support.  YMMV.  We build 
scalable back ends with Web2py using Postgres and Nginx.

John

On Thursday, March 28, 2019 at 12:16:58 PM UTC-7, Marcelo Huerta wrote:
>
> El jueves, 28 de marzo de 2019, 6:57:08 (UTC-3), José L. escribió:
>>
>>
>>- sqlform and grid are one of the key points for web2py. It's one of 
>>the main reasons to use it instead of other frameworks as development is 
>>really quick. However I think nowadays a backport from web2py is not a 
>> good 
>>idea. We should provide something optional based only on vue.js. As you 
>>say, we can do it better.
>>
>>
> SQLFORM and grid were the main selling points to me. Something similar 
> should be provided, surely.
>  
>
>>
>>- auth is not as important in my experience. It has never been the 
>>reason to pick web2py and there are other ways to do it.
>>
>> I love auth, actually. Maybe I haven't investigated enough, but what 
> other ways to do it are preferable in your opinion?
>

-- 
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] web3py again....

[Marcelo Huerta]

El jueves, 28 de marzo de 2019, 6:57:08 (UTC-3), José L. escribió:
>
>
>- sqlform and grid are one of the key points for web2py. It's one of 
>the main reasons to use it instead of other frameworks as development is 
>really quick. However I think nowadays a backport from web2py is not a 
> good 
>idea. We should provide something optional based only on vue.js. As you 
>say, we can do it better.
>
>
SQLFORM and grid were the main selling points to me. Something similar 
should be provided, surely.
 

>
>- auth is not as important in my experience. It has never been the 
>reason to pick web2py and there are other ways to do it.
>
> I love auth, actually. Maybe I haven't investigated enough, but what other 
ways to do it are preferable in your opinion?

-- 
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] web3py again....

[José Luis Redrejo]

Just tested, some considerations:

1. Tested with Python 3.6, followig strictly the provided instructions,
several things don't work:
a) static folder is not working properly. I get a 404 error for all the
requests
127.0.0.1 - - [28/Mar/2019 10:45:10] "GET /todo/index HTTP/1.1" 200 828
127.0.0.1 - - [28/Mar/2019 10:45:10] "GET /todo/static/js/sugar.min.js
HTTP/1.1" 404 774
127.0.0.1 - - [28/Mar/2019 10:45:10] "GET /todo/static/js/axios.min.js
HTTP/1.1" 404 774
127.0.0.1 - - [28/Mar/2019 10:45:10] "GET /todo/static/js/vue.min.js
HTTP/1.1" 404 770
127.0.0.1 - - [28/Mar/2019 10:45:10] "GET /todo/static/js/todo.js HTTP/1.1"
404 764

b) favicon requests also produce a python error:
27.0.0.1 - - [28/Mar/2019 10:44:47] "GET /favicon.ico HTTP/1.1" 404 742
Traceback (most recent call last):
  File "/opt/src/web3py/web3py.py", line 149, in load
self.data = jwt.decode(enc_data, self.secret,
algorithms=[self.algorithm])
  File "/opt/src/web3py/venv/lib/python3.6/site-packages/jwt/api_jwt.py",
line 84, in decode
payload, _, _, _ = self._load(jwt)
  File "/opt/src/web3py/venv/lib/python3.6/site-packages/jwt/api_jws.py",
line 177, in _load
binary_type))
jwt.exceptions.DecodeError: Invalid token type. Token must be a 


2. About your questions:

   - sqlform and grid are one of the key points for web2py. It's one of the
   main reasons to use it instead of other frameworks as development is really
   quick. However I think nowadays a backport from web2py is not a good idea.
   We should provide something optional based only on vue.js. As you say, we
   can do it better.
   - auth is not as important in my experience. It has never been the
   reason to pick web2py and there are other ways to do it.


3. about the new ideas:

   - I love the use of jwt and vue.js
   - I love it does not use custom import or eval. That will make testing
   much, much easier and logical.
   - I would like to have a kind of automatic integration between the
   backend and webpack, for modern development. It should be optional
   obviously, but something like django-webpack-loader should be added (or
   have web3py-webpack-loader as an external library that can be installed if
   required)


If you have a roadmap where others could lend a hand, please, tell it.
Maybe creating some github issues that could be assigned to volunteers. I'd
be glad to help.
José L.



El jue., 28 mar. 2019 a las 10:16, Massimo Di Pierro (<
massimo.dipie...@gmail.com>) escribió:

> I know this comes up once in a while but ...
>
> https://github.com/web2py/web3py
>
> what do you think?
>
> It is very preliminary but I will have an admin soon.
> Backporting SQLFORM, grid and Auth, should not be that complicated,
> although I think we can do better.
>
> 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] web3py again....

[Massimo Di Pierro]

I know this comes up once in a while but ...

https://github.com/web2py/web3py

what do you think? 

It is very preliminary but I will have an admin soon.
Backporting SQLFORM, grid and Auth, should not be that complicated, 
although I think we can do better.

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] Web3py reboot

[Kevin Keller]

Hey,

So I was wondering today what you guys would think about the idea to rename 
web2py to Web3py, once it reaches a level of maturity that would be able to 
justify the rename and a reboot.

That would also mean to update the web page and various resources. 

The reason is simple :

It seems that since  around 2016 python 3 has seen a major increase in adoption 
while web2py adoption decreased due to being perceived as python2 only 
framework, which at the time was certainly true.

While it's not true anymore, I think the perception of being a python2 only 
framework combined with outdated resources doesn't help adoption.

While sacrificing the established name is certainly not great, I think the 
benefits of a reboot with a name change to emphasize the python3 compatibility 
would far outweigh any drawback.
Python2 compatibility that is maintained would however seen as a plus and a 
major differentiator to other frameworks that dropped python2 support. 



What do you think? 

-- 
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] web3py status

[elguavas]

hi there,

i've seen peppered throughout this list references to web3py. i seems 
like it's mostly the unofficial name of of a concept at this stage, but i 
also see references to work being pulled into web2py from web3py...  where 
is this web3py and what's its current state? 

thanks,
e.

-- 
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/groups/opt_out.

[web2py] web3py?

[User]

I noticed a thread over in web2py-developers web3py - 
important!https://groups.google.com/forum/?fromgroups=#!topic/web2py-developers/RCeiRd3Rzs0
 which 
was exciting to read.  I've flirted with web2py and there's a lot that I 
like about it.  For some reason I find web2py exciting whereas django 
doesn't provide that.  I've used Yii on the php side which is great 
framework as far as php goes and asp.net mvc which is great as well.  I'd 
love to work with python but the main thing making me hesitate with web2py 
is critical mass.  
 
It seems like it wouldn't be hard for web2py to really dominate the python 
web framework space if some of the core criticisms were addressed.  I'm not 
fully up to speed on what they are but I usually hear about unit testing 
and global variables.  It feels like there is a roadblock preventing the 
project from skyrocketing.  Python needs a rails.  I understand that the 
design decisions are by choice with pros and cons.
 
My questions are:
1. Will web3py likely address these often repeated core criticisms? (I saw 
point 5 from the thread linked to above: 5) No more global environment. 
Apps will do from web3py import * (see below))
2. The developer thread is over in the developers section.  Will you have a 
more open forum for users (as opposed to developers) to have input on 
web3py?
 
 

-- 

[web2py] web3py lifetime of web2py

[Gour]

There is some talk that web3py will probably become 'new' product and
not just python-3 upgrade.

Otoh, I'm considering to buy paperback versions of Web2py's 4th ed as well as
the upcoming Packt book, but wonder how much would the skills acquired by
learning web2py be relevant for web3py, iow, what is the estimated lifetime for
web2py before some important work on web3py is underwent?


Sincerely,
Gour


-- 
In the material world, one who is unaffected by whatever good 
or evil he may obtain, neither praising it nor despising it, 
is firmly fixed in perfect knowledge.

http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810


signature.asc
Description: PGP signature

Re: [web2py] web3py lifetime of web2py

[Ovidio Marinho]

  I believe that there will be versions of web2py with python 3, so far the
project had been with python web2py 2.xx. There is nothing to fear as the
founder of Masimonot discontinue web2py.


   Ovidio Marinho Falcao Neto
Web Developer
 ovidio...@gmail.com
 ITJP - itjp.net.br
   83   8826 9088 - Oi
   83   9334 0266 - Claro
Brasil



2011/10/23 Gour g...@atmarama.net

 There is some talk that web3py will probably become 'new' product and
 not just python-3 upgrade.

 Otoh, I'm considering to buy paperback versions of Web2py's 4th ed as well
 as
 the upcoming Packt book, but wonder how much would the skills acquired by
 learning web2py be relevant for web3py, iow, what is the estimated lifetime
 for
 web2py before some important work on web3py is underwent?


 Sincerely,
 Gour


 --
 In the material world, one who is unaffected by whatever good
 or evil he may obtain, neither praising it nor despising it,
 is firmly fixed in perfect knowledge.

 http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810