[web2py] Re: Anyone in or near Barcelona?

[Jacinto Parga]

I am based in Spain and have some experience with Web2py. Nowadays learning 
how to migrate them to Py4web. In no COVID context I travel sometimes to 
Barcelona. May be I can help.

El jueves, 15 de octubre de 2020 a las 14:43:10 UTC+2, 
i.r...@appichar.com.au escribió:

> Hi - I'm looking for someone based in or around Barcelona with 
> Python/web2py experience who might be able to help with a couple of 
> projects I've built / will be building in web2py (or maybe web3py).
>
> If you know of of anyone please feel free to forward. 
>
> Thanks
> Ian
>

-- 
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/86b40f50-51e8-417d-9b8c-58a5aaa7d309n%40googlegroups.com.

[web2py] DAL implementation nof the Table-per-type inheritance model?

[BigBaaadBob]

It's hard to believe that I was talking about this in 2013 
, but here 
it is again!

I'm wondering if you can directly implement the Table-per-type or 
Shared-primary-key method of inheritance in the DAL?

[image: subclass-gradstu-scheme.gif]

The standard DAL inheritance method (including a table as a field) is a 
Table-per-concrete approach that has pros and cons. In particular for me, 
it is harder to deal with the common stuff (the stuff in the superclass) 
with the standard DAL method.  In many cases I never need to refer to the 
subclass specifics.

The best I have been able to do is something like the below. There is a lot 
of common stuff in the duration table (and, btw, the duration can be 
overridden and isn't necessarily the difference of the start and stop 
values in the subclasses). Depending on how the time is tracked, there are 
different algorithms used to compute a duration, for  example subtracting 
two datetimes or subtracting two floats (representing hours).

db.define_table(
'duration',
# Common stuff
Field('duration','decimal(10,2)',notnull=True),
)

db.define_table(
'datetime_duration',
Field('superclass','reference duration',unique=True,notnull=True),
Field('start','datetime',notnull=True),
Field('stop','datetime',notnull=True),
)

db.define_table(
'hour_duration',
Field('superclass','reference duration',unique=True,notnull=True),
Field('start','decimal(10,2)',notnull=True),
Field('stop','decimal(10,2)',notnull=True),
)

-- 
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/08ce05ed-8ce8-4877-9452-0fded7d07f1en%40googlegroups.com.

[web2py] web2py with python 3.6 index.html returns plain text

[António Ramos]

hello i´m testing my app from python 2.7 with python 3.6 on another web2py
server with web2py 2.20.4
i resolved all issues so far but now only my index.html pages returns plain
text
other pages are ok.
any help?
[image: image.png]

-- 
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/CAEM0BxNH8RNOYZZxyM4LjH0SmdbjEA0JkN6W6UJ%2Bs3sOT44ztw%40mail.gmail.com.

[web2py] python3.6 No module named applications.lab.modules.requests

[António Ramos]

hello i'm trying web2py with python3 and have an issue with python requests
Why is it looking for requests inside my app modules folder ??
regards
[image: image.png]

-- 
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/CAEM0BxMN%2BY-pUxfo%3DnOFpE4PbfbX9-D%2B8ECU_D%2Bd3Bcfrugs3A%40mail.gmail.com.

[web2py] Re: Object type None error

[Jim S]

Ok, I'm at a loss for what the problem could be.

To further troubleshoot I'd probably open a web2py shell for your app and 
try different things with a good amcid and with 1910.  

python web2py.py -S application_name
(http://web2py.com/books/default/chapter/29/04/the-core#Command-line-options)

I'd try

-hard coding the stored procedure call with the id instead of using 
variable substitution
-depending on how complex the stored procedure is, start issuing those sql 
statements and see if you can determine where something is going wrong
-when you say the sp does return values for that id, are you testing via 
python (not using pydal) or in a database tool?  If not in Python, can you 
test without using pydal and see what the results are?

-Jim


On Saturday, October 17, 2020 at 2:16:58 AM UTC-5, T.R.Rajkumar wrote:
>
> The print rowsconlab for id other than 1910 is 
>
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2020
> Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
> Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000
> please visit:
> http://127.0.0.1:8000/
> starting browser...
> [{'thsk': '0.0', 'tsk': '0.0', 'unitid': 'ts2', 'da': '0.00', 
> 'vda': '0.
> 00', 'sacamt': '0.00', 'amcno': 'PLT17CS051', 'tusk': '0.0', 'awg': 
> '0.00',
> 'esiamt': '0.00', 'pfamt': '0.00', 'tssk': '0.0'}]
>
> for id 1910 there is nothing printed in the cmd window.
>
> but the sp does return result below for id 1910
>
> unitidamcnothsktsktssktuskawgdavda
> pfamtsacamtesiamt
> ts2AHO20DP05710.00.00.010.0
> 2800.000.00460.002042.56186.78510.64
>
> for reasons unknow  to me web2py dal is not reading the result, resulting 
> in None type object not iterable error.
>
>

-- 
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/0b6278d3-e3a6-438a-8f64-14f5398d63eco%40googlegroups.com.

Re: [web2py] Re: web2py hosting

[Gaël Princivalle]

I've made some confusion, you're wright it's not MDDHosting where they're 
some old Webfaction guys but Opalstack.
I'll choose a VPS from Opalstack or OVH. Did someone tried to use 
Webfaction on OVH?

Il giorno venerdì 16 ottobre 2020 alle 18:45:41 UTC+2 Jose C ha scritto:

> Did someone tried this one?
>> https://www.mddhosting.com/
>>
>> It seems a new company made by old Webfaction guys.
>>
>> Not sure about that.  They say their company was created in 2007.  WF was 
> still brilliant then.  The only 'new' company founded by ex-Webfaction guys 
> that I know of is Opalstack.  See: 
> https://www.opalstack.com/2019/03/13/its-time-to-switch-to-an-independently-owned-hosting-company/
>
>  
>

-- 
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/9d084ce8-dbee-4380-b276-c4083b27af0cn%40googlegroups.com.

[web2py] Re: Object type None error

[T.R.Rajkumar]

The print rowsconlab for id other than 1910 is 

web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2020
Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000
please visit:
http://127.0.0.1:8000/
starting browser...
[{'thsk': '0.0', 'tsk': '0.0', 'unitid': 'ts2', 'da': '0.00', 
'vda': '0.
00', 'sacamt': '0.00', 'amcno': 'PLT17CS051', 'tusk': '0.0', 'awg': 
'0.00',
'esiamt': '0.00', 'pfamt': '0.00', 'tssk': '0.0'}]

for id 1910 there is nothing printed in the cmd window.

but the sp does return result below for id 1910

unitidamcnothsktsktssktuskawgdavda
pfamtsacamtesiamt
ts2AHO20DP05710.00.00.010.0
2800.000.00460.002042.56186.78510.64

for reasons unknow  to me web2py dal is not reading the result, resulting 
in None type object not iterable error.

-- 
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/b412c91d-090f-4048-8c69-4292e7978a33o%40googlegroups.com.