[web2py] Re: fake_migration issues

2021-01-29 Thread Dave S 


On Monday, January 25, 2021 at 6:36:23 PM UTC-8 Dave S wrote:

> Porting another (personal) application from my old 2.14.6 environment to 
> 2.21.1., and copied both the table files and storage.sqlite from the old 
> application.  Index page works, but another page which displays a sorted 
> list doesn't.
> [...]
> Is this a 2.21.1 issue, or have I rejoined those who bungle migrations?
>

Clearly the latter, but the help from Jim and Clemens here:
https://groups.google.com/g/web2py/c/MHNyKxeGEwY>
looked apropros.
But even with all 3 values true, I still don't seem to have table files, 
and I still get the error if there is data found by my query, but no error 
if rows is empty.

/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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f9deb06d-1516-4cbf-a08c-1c6622e6b177n%40googlegroups.com.

Re: [web2py] Re: Got error when I put 'fields' as an argument to SQLFORM.grid

2021-01-29 Thread Muhammad Atif Ayaz 
Thank you very much!

On Fri, Jan 29, 2021 at 9:14 AM valq...@gmail.com 
wrote:

> db.table['fieldname']
>
>
> четверг, 28 января 2021 г. в 07:31:04 UTC+3, at:
>
>> It gives error: `*AttributeError('str' object has no attribute
>> 'tablename')*`
>>
>> The reason is that the field names are in string format not in
>> db.tablename.fieldname format
>>
>>
>> On Wed, Jan 27, 2021 at 6:30 PM Jim Steil  wrote:
>>
>>> What is wrong with using the example you provided?
>>>
>>> -Jim
>>>
>>>
>>> On Tue, Jan 26, 2021 at 10:45 PM Muhammad Atif Ayaz 
>>> wrote:
>>>
 Thank you Jim, it works.

 Do you think a way that can help dynamically making a list of all
 fields of a table and then we can remove specific fields from it.
 Like the following which produces the required list but in the desired
 data-type:
 fields = [fld for fld in db.engagement.fields if fld!='token']
 grid = SQLFORM.grid(db.engagement, fields=fields)


 On Tue, Jan 26, 2021 at 9:50 PM Jim S  wrote:

> Can you try with the field in the format:
>
> db.tablename.fieldname
>
> ex:
>
> fields = [db.engagement.id, db.engagement.name]
>
> -Jim
>
>
> On Monday, January 25, 2021 at 11:45:49 PM UTC-6 at wrote:
>
>> Here is the code:
>> `fields=['id', 'name']`
>> `grid = SQLFORM.grid(db.engagement, fields=fields)`
>>
>> Error:
>> `AttributeError('str' object has no attribute 'tablename')`
>>
>>
>> --
> 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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/Ym3zsLYNePg/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+un...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/e19daf19-95c7-4e46-88da-74882bd4e51an%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 a topic in the
 Google Groups "web2py-users" group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/web2py/Ym3zsLYNePg/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 web2py+un...@googlegroups.com.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/web2py/CAFpY7yFSRZMRPY02sHJtxGasp3T%3Dy7sRdqbq58KncYDdDpkXDg%40mail.gmail.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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/Ym3zsLYNePg/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> web2py+un...@googlegroups.com.
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/CAERBpoCjJrCe_3W1Nq%3DZKh8wFc-e8stoHOpMzDwxMHfbFjexKA%40mail.gmail.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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/Ym3zsLYNePg/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/3b718aef-ec6a-45d3-9c6a-7ae039ae787an%40googlegroups.com
> 
> .
>

-- 
Resources:
- http://web2p

[web2py] Re: Threads in app

2021-01-29 Thread Dave S 

On Saturday, December 12, 2020 at 3:20:46 AM UTC-8 ermolaev...@gmail.com 
wrote:

> code:
> threadGetRate = Thread(target=get_from_exch, args=(db, exchg))
> threadGetRate.start()
>
> I start app by:
>
> > web2py.py -S 7pay_in -M -R applications/7pay_in/modules/serv_rates.py -A 
> True 60
>
> rise error - for connection to DB
>


I'm not sure what you are trying to do here, and I don't what error you are 
saying is happening.

Can you provide more information?

(typically, each request runs in its own thread, and how many threads there 
are may depend on the front end (Rocket, NginX, Apache, unicorn, etc);  The 
scheduler also managers a pool of threads).)

/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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/17446d3a-c6df-4cc7-844e-458c179271aen%40googlegroups.com.

Re: [web2py] Timeout for data entry screens: Help!

2021-01-29 Thread John Bannister 
What database are you using?

On Fri, 29 Jan 2021 at 16:12, Massimiliano  wrote:

> Reading better you message, I'm not sure that auth.settings.expiration is
> what you need.
> Sorry
>
> Il giorno ven 29 gen 2021 alle ore 16:10 Massimiliano 
> ha scritto:
>
>> You can set:
>>
>> auth.settings.expiration
>>
>> Value are in seconds. So 86400 is one day,
>>
>>
>>
>> Il giorno ven 29 gen 2021 alle ore 14:42 Davidiam <
>> david.rosa...@gmail.com> ha scritto:
>>
>>> 2.18.5-stable+timestamp.2019.04.08.04.22.03
>>> (Running on Microsoft-IIS/10.0, Python 3.6.8)
>>>
>>> Hello,
>>>
>>> We built some web2py applications and we are now getting feedback from
>>> the users that if they don't save their data entry screen data within about
>>> 10 minutes, that the save fails and they have to re-enter all their data.
>>> As they often get interruptions while entering data, this is becoming a bit
>>> of a problem.
>>>
>>> Can this "timeout" be modified to give them more time?  Is this coming
>>> from web2py or would this me more an infrastructure issue?
>>>
>>> Thanks in advance for any replies!
>>> David
>>>
>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "web2py-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/c389ecc4-0693-438d-ae89-ef01660dfb34n%40googlegroups.com
>>> 
>>> .
>>>
>>
>>
>> --
>> Massimiliano
>>
>
>
> --
> Massimiliano
>
> --
> 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/CANPTPxJ3YT9onfb2nfb%3D%3D5OSbxpgQoyJbGvg_u6bV2ha-ND1XA%40mail.gmail.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/CAGvnVuYHmEnPjQY1cm5gsdESqw%2B6MAnKh6dh1B8rS4jAnCZzOA%40mail.gmail.com.

Re: [web2py] Timeout for data entry screens: Help!

2021-01-29 Thread Massimiliano 
Reading better you message, I'm not sure that auth.settings.expiration is
what you need.
Sorry

Il giorno ven 29 gen 2021 alle ore 16:10 Massimiliano 
ha scritto:

> You can set:
>
> auth.settings.expiration
>
> Value are in seconds. So 86400 is one day,
>
>
>
> Il giorno ven 29 gen 2021 alle ore 14:42 Davidiam 
> ha scritto:
>
>> 2.18.5-stable+timestamp.2019.04.08.04.22.03
>> (Running on Microsoft-IIS/10.0, Python 3.6.8)
>>
>> Hello,
>>
>> We built some web2py applications and we are now getting feedback from
>> the users that if they don't save their data entry screen data within about
>> 10 minutes, that the save fails and they have to re-enter all their data.
>> As they often get interruptions while entering data, this is becoming a bit
>> of a problem.
>>
>> Can this "timeout" be modified to give them more time?  Is this coming
>> from web2py or would this me more an infrastructure issue?
>>
>> Thanks in advance for any replies!
>> David
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-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/c389ecc4-0693-438d-ae89-ef01660dfb34n%40googlegroups.com
>> 
>> .
>>
>
>
> --
> Massimiliano
>


-- 
Massimiliano

-- 
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/CANPTPxJ3YT9onfb2nfb%3D%3D5OSbxpgQoyJbGvg_u6bV2ha-ND1XA%40mail.gmail.com.

Re: [web2py] Timeout for data entry screens: Help!

2021-01-29 Thread Massimiliano 
You can set:

auth.settings.expiration

Value are in seconds. So 86400 is one day,



Il giorno ven 29 gen 2021 alle ore 14:42 Davidiam 
ha scritto:

> 2.18.5-stable+timestamp.2019.04.08.04.22.03
> (Running on Microsoft-IIS/10.0, Python 3.6.8)
>
> Hello,
>
> We built some web2py applications and we are now getting feedback from the
> users that if they don't save their data entry screen data within about 10
> minutes, that the save fails and they have to re-enter all their data.  As
> they often get interruptions while entering data, this is becoming a bit of
> a problem.
>
> Can this "timeout" be modified to give them more time?  Is this coming
> from web2py or would this me more an infrastructure issue?
>
> Thanks in advance for any replies!
> David
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-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/c389ecc4-0693-438d-ae89-ef01660dfb34n%40googlegroups.com
> 
> .
>


-- 
Massimiliano

-- 
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/CANPTPxKi34Y-8_0YRam8LvgngDnp25_GSJisugke-aPZsEOtpA%40mail.gmail.com.

[web2py] Timeout for data entry screens: Help!

2021-01-29 Thread Davidiam 
2.18.5-stable+timestamp.2019.04.08.04.22.03
(Running on Microsoft-IIS/10.0, Python 3.6.8) 
 
Hello,

We built some web2py applications and we are now getting feedback from the 
users that if they don't save their data entry screen data within about 10 
minutes, that the save fails and they have to re-enter all their data.  As 
they often get interruptions while entering data, this is becoming a bit of 
a problem.

Can this "timeout" be modified to give them more time?  Is this coming from 
web2py or would this me more an infrastructure issue?

Thanks in advance for any replies!
David

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-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/c389ecc4-0693-438d-ae89-ef01660dfb34n%40googlegroups.com.