Re: [web2py] PyCharm license for web2py dev - who wants?

2015-10-13 Thread 黄祥
+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] PyCharm license for web2py dev - who wants?

2015-10-13 Thread Massimiliano
+1

On Tue, Oct 13, 2015 at 9:04 AM, 黄祥  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.
>



-- 
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.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Re: Don't laugh but I like the admin editor ;o)

2015-10-13 Thread Edward Shave
Ok, I don't know why it took so long but just in case anyone else out there 
is as thick as me...

Make sure the editor has the focus before using the find and replace 
feature, otherwise your key presses will be directed to the browser  DOH..!

-- 
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] Buying a template for the community...

2015-10-13 Thread Manuele Pesenti
Il 11/10/15 09:24, Jason (spot) Brower ha scritto:
> I have been thinking, the admin interface could use some fixin' up.
> If I bought the extended licence to some theme, say...
> https://wrapbootstrap.com/theme/wrapkit-responsive-admin-template-WB09280SN?l=e
> or any other there...
> we would then have the power to sublincence it as LGPL or similar with
> restriction to the gpl stuff.
> That way we have a nice theme to play with and can start working on
> some of fun features to fill it in.
> BR,
> Jason Brower
http://demo.kimlabs.com/gentelella/production/index.html
here it is another theme I like very mutch (lots of useful widget in
there!), the licence is MIT and the code is already on github ;)

Manuele

-- 
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] web2py for onion.io ?

2015-10-13 Thread António Ramos
is is possible to have web2py inside this ?

https://onion.io/omega/

Regards

António

-- 
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 for onion.io ?

2015-10-13 Thread Leonel Câmara
It's a little low on the memory side but it runs python so I don't see why 
not as long as you don't expect to be serving a lot of requests. I would 
probably prefer a raspberry pi because it has quite a lot more memory.

-- 
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 for onion.io ?

2015-10-13 Thread António Ramos
That is not my idea.
I´m going down the specs to see the smallest web2py enabled IOT device.

Thank you

2015-10-13 11:24 GMT+01:00 Leonel Câmara :

> It's a little low on the memory side but it runs python so I don't see why
> not as long as you don't expect to be serving a lot of requests. I would
> probably prefer a raspberry pi because it has quite a lot more memory.
>
> --
> 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] Error in plugin S -Cubism "Tree Crud"

2015-10-13 Thread javierobcn
I'm really stuck for a few weeks , if someone can help me out . 

I use the plugin developed by S -Cubism "Tree Crud"

https://github.com/scubism/sqlabs

This plugin worked well in earlier versions of web2py , but in the latest, 
when i add a node , always gives error " Unauthorized"

I tried to debug the error but I can not fix it.

Anyone can download the plugin and give me a hand to debug ?

-- 
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: Pretty printing a string in a view

2015-10-13 Thread Gary Cowell
When I'm presenting for example log data from a process execution with 
web2py, I'll use PRE and put it in a textarea.

On Monday, 12 October 2015 11:07:52 UTC+1, Callum Daw wrote:
>
> Thank you so much, the  tag worked a charm, the issue I was facing is 
> that it returns XML to my unit which connects to it so having a  
> would have caused problems. Thanks again!
>
> On Monday, 12 October 2015 10:50:49 UTC+1, Leonel Câmara wrote:
>>
>> This is just how HTML works. For instance if you put this in your view:
>>
>> 
>> {{=mystring}}
>> 
>>
>> You will see the newlines and spacing.
>>
>> Otherwise, if you don't want it showing like that, you need to prepare 
>> your string better (for instance replacing \n in the string with ).
>>
>
>
> Isys Group Ltd is a wholly owned subsidiary of Capita Plc 
> .
>
>
>
>

-- 
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: can validate_and_update_or_insert() be used with Auth on GAE?

2015-10-13 Thread Carl Hunter Roach
I've dropped my attempt to use validate_and_update_or_insert() and have 
this workaround whereby I do a search and then call either 
validate_and_update() or validate_and_insert() ...

user = [
Storage(username="u1", password='p1', field2='field2'),
   Storage(username="u1", password='p1', field2='field2')]

for user in users:

rows = 
db(db.auth_user.username==user.username).select(db.auth_user.ALL)
if rows:
row = rows[0]
db(db.auth_user.id==row.id).validate_and_update(
password=user.password,
field2=user.field2)
else:
db.auth_user.validate_and_insert(
username=user.username,
password=user.password,
field2=user.field2)



On Monday, 12 October 2015 20:08:38 UTC+1, Carl Hunter Roach wrote:
>
> I'm trying to use validate_and_update_or_insert() to update/insert users 
> into my auth_user table. 
>
> user = [
> Storage(username="u1", password='p1', field2='field2'),
>Storage(username="u1", password='p1', field2='field2')]
>
> for user in users:
> res = 
> db(db.auth_user.username==user).validate_and_update_or_insert(password=user.password,
>  
> field2=user.field2)
>
> When a user is inserted all is well.
> *But when a user is to be updated then Web2py throws an exception finding 
> that "object has no attribute 'primary_key'"*
> What have I misunderstood?
>
> I can't find any documentation for validate_and_update_or_insert() but it 
> operates very similarly to validate_and_update or validate_and_insert
>
> My Auth is as follows:
> https_secure = False if isGAELocal() else True
> auth = Auth(db, secure=https_secure)
>
> The execution, above, is local and therefore over http but will be over 
> https when it goes into production. i.e. testing using dev_appserver and 
> targetting App Engine Big Table.
>

-- 
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] Architecture for an application with multiple groups of users

2015-10-13 Thread Jean-François Milants
Hi,

I'm currently building a web-application based on web2py, and I would like 
some insights and advices about its architecture.
Please, if this forum is not the good place to ask this kind of question, 
just tell me. And if you could point me to some resources/communities that 
could help me, I would be grateful!

Basically, my application will provide services to employees from company. 
Each employees from each company will have an account, and there will be 
different levels of accounts ('simple employee', coordinator, 
administrative staff,...).
I want the employees to be able to access (read/write according to its 
level account) only to the data of the company he belongs to, not from the 
other. For example, employee 1 from company A cannot see the profile from 
employee 10 from company B.
There won't be any link between users from different companies.

But now, I'm thinking about the global architecture of the application. 
Here are some ideas:
 * 1 application with 1 DB : the DB contains everything, and the 
application must enforce the isolation of the employees in their own 
company. I think this is possible with Auth, and groups, memberships and 
permissions.
 * 1 application with multiple DB : 1 new DB is created for each company. 
But I don't know if one instance of web2py can handle multiple DB.
 * 1 instance of the application and 1 DB for each company: All the data 
from the companies are isolated from each other by design. This kind of 
architecture seems to perfectly fit Docker : one container per instance of 
the application.

I think that these 3 architectures are possible and all of them have their 
own pros and cons. The first one is the first one I've thought about, it 
seems to be the most instinctive one. The last one is more isolated and 
more scalable, but I'm new to this kind of architecture.
And you'll certainly think about other possibilities.
Now, how do I choose the best architecture? Should I target first the speed 
of development of the first version of my application? Or should I think 
about the scalability as soon as possible? Other concerns? Is there an 
architecture that would fit better with web2py than another one?

I don't want you to tell me which on to choose (it'll certainly depend on 
the number of users/companies, the load of the server, the size of the 
data,...) but can you give me some advices, ideas, thoughts based on your 
own experience in web-developpment? Or some link to online resources, 
books,...

Thanks a lot for your help!

-- 
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: Postgres: No databases/*.table files created

2015-10-13 Thread Matt Norris
Thank you for giving me a few more clues. I tried running the application 
with a remote DB, a local DB, and fiddled with configuration options, but 
I'm still not able to pinpoint the file. If I run SQLite, files are 
generated in the `databases` folder. If I connect to a database, they are 
not. However, errors appear in the proper directory. 

I am running the `python web2py.py` through Heroku's Procfile, which I 
thought might be the problem. However, after running the application with 
no Heroku-specific commands, I see the same thing. 

On Friday, October 9, 2015 at 4:50:18 AM UTC-7, Anthony wrote:
>
> Looks like that is coming from here, 
> https://github.com/web2py/pydal/blob/master/pydal/adapters/base.py#L497, 
> which indicates a file is being found. Are you sure there's nothing there? 
> If it is there, is it an empty file? Can you unpickle it yourself?
>
> I've read that you can also get this error if the file is open for write 
> by another process or if you run out of RAM.
>
> Anthony
>
> On Thursday, October 8, 2015 at 6:29:42 PM UTC-4, Matt Norris wrote:
>>
>> I am using Postgres and my tables are created fine when I first hit my 
>> application. However, on the next hit, I get the following error: 
>>
>>  File 
>> applications/APPNAME/databases/715f66f7f718f8a2afa073dfc0be5874_web2py_session_APPNAME.table
>>  
>> appears corrupted
>>
>> I get this error because *no files* have been created in the 
>> `databases` folder. 
>>
>> Migrations are on, and I realize that if I turn them off and hit the 
>> application this error goes away, but it seems like I shouldn't have to do 
>> that. 
>>
>> Why aren't the .table files created? 
>>
>> Thanks, 
>> Matt 
>>
>

-- 
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: Error in plugin S -Cubism "Tree Crud"

2015-10-13 Thread Willoughby
Sadly that code is 4 years old and their web site has been deactivated, 
which I think fits the definition of 'no longer maintained'.
I might suggest moving to something else.

On Tuesday, October 13, 2015 at 7:05:53 AM UTC-4, javierobcn wrote:
>
> I'm really stuck for a few weeks , if someone can help me out . 
>
> I use the plugin developed by S -Cubism "Tree Crud"
>
> https://github.com/scubism/sqlabs
>
> This plugin worked well in earlier versions of web2py , but in the latest, 
> when i add a node , always gives error " Unauthorized"
>
> I tried to debug the error but I can not fix it.
>
> Anyone can download the plugin and give me a hand to debug ?
>
>

-- 
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] Buying a template for the community...

2015-10-13 Thread Manuele Pesenti
Il 13/10/15 11:15, Manuele Pesenti ha scritto:
> http://demo.kimlabs.com/gentelella/production/index.html
> here it is another theme I like very mutch (lots of useful widget in
> there!), the licence is MIT and the code is already on github ;)
Here: https://github.com/kimlabs/gentelella

M.
>
> Manuele

-- 
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: CMS WEB2PY

2015-10-13 Thread Carlos Cesar Caballero Díaz
I am working on a site that is builded using custom made CMS, I am 
planning to release it to github when it's finished (the cms), right now 
you can see the site (work in progress) at www.daxslab.com, suggestions 
and criticism are very welcomed


El 12/10/15 a las 06:09, Paolo Amboni escribió:
Are there some contraindications to use web2py with php based cms like 
joomla?


Il giorno sabato 10 ottobre 2015 18:34:55 UTC+2, Anthony ha scritto:

If it has to be Python, there are several Django based CMSes --
Wagtail looks like a nice one (there's also
Mezzanine and Django CMS).

Anthony

On Saturday, October 10, 2015 at 3:32:22 AM UTC-4, Paolo Amboni
wrote:

After some research i finally concluded that there is no
stable and structured CMS made for web2py (tell me if i'm wrong).
Which is a python cms that better can be put beside a web2py
site (already made)?
Thanks.

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




--
Este mensaje le ha llegado mediante el servicio de correo electronico que 
ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema 
Nacional de Salud. La persona que envia este correo asume el compromiso de usar 
el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/

--
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: CMS WEB2PY

2015-10-13 Thread Paolo Amboni
The site is really well made. But te CMS is we2py based?

Il giorno martedì 13 ottobre 2015 15:17:20 UTC+2, Carlos Cesar Caballero ha 
scritto:
>
> I am working on a site that is builded using custom made CMS, I am 
> planning to release it to github when it's finished (the cms), right now 
> you can see the site (work in progress) at www.daxslab.com, suggestions 
> and criticism are very welcomed
>
> El 12/10/15 a las 06:09, Paolo Amboni escribió:
>
> Are there some contraindications to use web2py with php based cms like 
> joomla?
>
> Il giorno sabato 10 ottobre 2015 18:34:55 UTC+2, Anthony ha scritto: 
>>
>> If it has to be Python, there are several Django based CMSes -- Wagtail 
>> looks like a nice one (there's also Mezzanine and 
>> Django CMS).
>>
>> Anthony
>>
>> On Saturday, October 10, 2015 at 3:32:22 AM UTC-4, Paolo Amboni wrote: 
>>>
>>> After some research i finally concluded that there is no stable and 
>>> structured CMS made for web2py (tell me if i'm wrong).
>>> Which is a python cms that better can be put beside a web2py site 
>>> (already made)?
>>> Thanks.
>>>
>> -- 
> 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] Buying a template for the community...

2015-10-13 Thread Jim S
I think it is a great idea to get a default theme working out of the box. 
 I've written 3 (I think) web2py applications using different themes from 
wrapbootstrap.com in the past.  The key (in my opinion) is to find one that 
doesn't have a lot of javascript magic going on behind the scenes.  And, to 
find one that is free and properly licensed.  The ones I've used in the 
past I've paid for just for the one application where I used it.  

The free ones mentioned above look great.  I didn't look to see if there 
was much javascript magic going on in the background, but did really like 
the looks of them.  Also, I like themes that make use of datatables.  I've 
had good luck using datatables in the past with web2py apps.

If the community could decide on one they'd like to see used, I will try to 
devote some time to get it web2py-ready...

-Jim

On Tuesday, October 13, 2015 at 7:48:52 AM UTC-5, Manuele wrote:
>
> Il 13/10/15 11:15, Manuele Pesenti ha scritto: 
> > http://demo.kimlabs.com/gentelella/production/index.html 
> > here it is another theme I like very mutch (lots of useful widget in 
> > there!), the licence is MIT and the code is already on github ;) 
> Here: https://github.com/kimlabs/gentelella 
>
> M. 
> > 
> > Manuele 
>
>

-- 
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: Architecture for an application with multiple groups of users

2015-10-13 Thread Jim S
This link to the book might help:

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=multi-tenant

-Jim

On Tuesday, October 13, 2015 at 7:03:53 AM UTC-5, Jean-François Milants 
wrote:
>
> Hi,
>
> I'm currently building a web-application based on web2py, and I would like 
> some insights and advices about its architecture.
> Please, if this forum is not the good place to ask this kind of question, 
> just tell me. And if you could point me to some resources/communities that 
> could help me, I would be grateful!
>
> Basically, my application will provide services to employees from company. 
> Each employees from each company will have an account, and there will be 
> different levels of accounts ('simple employee', coordinator, 
> administrative staff,...).
> I want the employees to be able to access (read/write according to its 
> level account) only to the data of the company he belongs to, not from the 
> other. For example, employee 1 from company A cannot see the profile from 
> employee 10 from company B.
> There won't be any link between users from different companies.
>
> But now, I'm thinking about the global architecture of the application. 
> Here are some ideas:
>  * 1 application with 1 DB : the DB contains everything, and the 
> application must enforce the isolation of the employees in their own 
> company. I think this is possible with Auth, and groups, memberships and 
> permissions.
>  * 1 application with multiple DB : 1 new DB is created for each company. 
> But I don't know if one instance of web2py can handle multiple DB.
>  * 1 instance of the application and 1 DB for each company: All the data 
> from the companies are isolated from each other by design. This kind of 
> architecture seems to perfectly fit Docker : one container per instance of 
> the application.
>
> I think that these 3 architectures are possible and all of them have their 
> own pros and cons. The first one is the first one I've thought about, it 
> seems to be the most instinctive one. The last one is more isolated and 
> more scalable, but I'm new to this kind of architecture.
> And you'll certainly think about other possibilities.
> Now, how do I choose the best architecture? Should I target first the 
> speed of development of the first version of my application? Or should I 
> think about the scalability as soon as possible? Other concerns? Is there 
> an architecture that would fit better with web2py than another one?
>
> I don't want you to tell me which on to choose (it'll certainly depend on 
> the number of users/companies, the load of the server, the size of the 
> data,...) but can you give me some advices, ideas, thoughts based on your 
> own experience in web-developpment? Or some link to online resources, 
> books,...
>
> Thanks a lot for your help!
>

-- 
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: CMS WEB2PY

2015-10-13 Thread Carlos Cesar Caballero Díaz

yes, the CMS is web2py based.

El 13/10/15 a las 09:39, Paolo Amboni escribió:

The site is really well made. But te CMS is we2py based?

Il giorno martedì 13 ottobre 2015 15:17:20 UTC+2, Carlos Cesar 
Caballero ha scritto:


I am working on a site that is builded using custom made CMS, I am
planning to release it to github when it's finished (the cms),
right now you can see the site (work in progress) at
www.daxslab.com , suggestions and
criticism are very welcomed

El 12/10/15 a las 06:09, Paolo Amboni escribió:

Are there some contraindications to use web2py with php based cms
like joomla?

Il giorno sabato 10 ottobre 2015 18:34:55 UTC+2, Anthony ha scritto:

If it has to be Python, there are several Django based CMSes
-- Wagtail looks like a nice one
(there's also Mezzanine and Django CMS).

Anthony

On Saturday, October 10, 2015 at 3:32:22 AM UTC-4, Paolo
Amboni wrote:

After some research i finally concluded that there is no
stable and structured CMS made for web2py (tell me if i'm
wrong).
Which is a python cms that better can be put beside a
web2py site (already made)?
Thanks.

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




--
Este mensaje le ha llegado mediante el servicio de correo electronico que 
ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema 
Nacional de Salud. La persona que envia este correo asume el compromiso de usar 
el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/

--
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] PyCharm license for web2py dev - who wants?

2015-10-13 Thread Richard Vézina
+1

On Tue, Oct 13, 2015 at 9:32 AM, Carlos Cesar Caballero Díaz <
desarro...@spicm.cfg.sld.cu> wrote:

> +1
>
> I am from Cuba, and I can't buy a PyCharm licence because of the US
> restrictions to cuban citizens for economic transactions (we can't use
> Paypal or any credit/debit card payment mechanism), so, a free licence will
> be very welcomed.
>
> El 11/10/15 a las 15:21, Francisco Ribeiro escribió:
>
> Hello all,
>
> for those who know PyCharm is a great IDE from JetBrains that provides
> free licenses for Open Source projects like web2py (
> https://www.jetbrains.com/buy/opensource/?product=pycharm ). To request
> such a license, I need to know how many of you would want one of these as
> well so I can provide them with a number of seats.
>
> A "+1" response for me is enough but I will also need your email address
> to send you the license key (which you can send on a private message).
>
> Kind regards,
> Francisco
> --
> 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)
- 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: CMS WEB2PY

2015-10-13 Thread Paolo Amboni
Very interesting if you release it on github I'll definitely try it.

-- 
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: CMS WEB2PY

2015-10-13 Thread Leonel Câmara
I may actually have to make a web2py CMS quite soon. I have a bunch 
requirements that off-the-shelf CMSes don't fulfill but I would be really 
interested in seeing your code Carlos, give us a heads up when you release.

-- 
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] PyCharm license for web2py dev - who wants?

2015-10-13 Thread Carlos Cesar Caballero Díaz

+1

I am from Cuba, and I can't buy a PyCharm licence because of the US 
restrictions to cuban citizens for economic transactions (we can't use 
Paypal or any credit/debit card payment mechanism), so, a free licence 
will be very welcomed.


El 11/10/15 a las 15:21, Francisco Ribeiro escribió:

Hello all,

for those who know PyCharm is a great IDE from JetBrains that provides 
free licenses for Open Source projects like web2py ( 
https://www.jetbrains.com/buy/opensource/?product=pycharm ). To 
request such a license, I need to know how many of you would want one 
of these as well so I can provide them with a number of seats.


A "+1" response for me is enough but I will also need your email 
address to send you the license key (which you can send on a private 
message).


Kind regards,
Francisco
--
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.




--
Este mensaje le ha llegado mediante el servicio de correo electronico que 
ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema 
Nacional de Salud. La persona que envia este correo asume el compromiso de usar 
el servicio a tales fines y cumplir con las regulaciones establecidas

Infomed: http://www.sld.cu/

--
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] Insert/update user record in 2 db

2015-10-13 Thread Gael Princivalle
Hello all.

In a web2py application I would like to insert/update user records in 2 db.
The first one is the application db, a postgres db:
db = DAL('postgres://user:pass@localhost:5432/my_web2py_app_db', 
check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True, 
migrate=True)


The second one is used by a mailing program called php list. It's a mysql 
db.
db_php_list = DAL('mysql://user:pass@localhost:3306/my_php_list_db', 
fake_migrate_all=False, migrate=True)

I don't see any db_php_list table in database administration.

Mysql port is 3306?
For an existing db, I've to add 'fake_migrate_all=False, migrate=True', 
right?

Admitting that I can connect to the mysql db, how can I handle the user 
insert/updates to both db?

Thanks, regards.



-- 
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] Replace 'Log in' text in auth.navbar by 'User'

2015-10-13 Thread Gael Princivalle
Hello all.

It seems that some users the first time they want to login expect that it's 
just necessary click on the first level menu 'Log in'.
But it's not like that, they have to look at the dropdown menu second level 
'Log in' voice.

How can I change the first level 'Log in' text by 'User' in auth.navbar?

Thanks, regards.

-- 
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: CMS WEB2PY

2015-10-13 Thread Ron Chatterjee
Problem that I see using CMS that its very hard to make changes and the 
code is always very embedded and dependent. Hopefully it  will be different 
than what I have seen. Interesting!


On Tuesday, October 13, 2015 at 10:11:20 AM UTC-4, Leonel Câmara wrote:
>
> I may actually have to make a web2py CMS quite soon. I have a bunch 
> requirements that off-the-shelf CMSes don't fulfill but I would be really 
> interested in seeing your code Carlos, give us a heads up when you release.
>

-- 
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: CMS WEB2PY

2015-10-13 Thread Richard Vézina
Look very nice Carlos, congrats...

Richard

On Tue, Oct 13, 2015 at 10:42 AM, Ron Chatterjee 
wrote:

> Problem that I see using CMS that its very hard to make changes and the
> code is always very embedded and dependent. Hopefully it  will be different
> than what I have seen. Interesting!
>
>
> On Tuesday, October 13, 2015 at 10:11:20 AM UTC-4, Leonel Câmara wrote:
>>
>> I may actually have to make a web2py CMS quite soon. I have a bunch
>> requirements that off-the-shelf CMSes don't fulfill but I would be really
>> interested in seeing your code Carlos, give us a heads up when you release.
>>
> --
> 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: Filtering a set of items from a collection issues

2015-10-13 Thread John Smidt
Ok, I get how the IS_IN_SET needs a filtered set as the first argument but 
now I'm not sure how to get the `current_collection_id`? This is all 
dealing with a SQLFORM.grid and my `.requires` statement is in my model so 
how do I get the id of the collection that was selected from the grid into 
my model for the filter?

On Monday, October 12, 2015 at 12:32:08 PM UTC-6, Anthony wrote:
>
> First, you've got the arguments to IS_IN_DB wrong -- the first argument is 
> a DAL connection object or a DAL Set object (which is what you want), and 
> the second is a single field object (or a field name in 'table.field' 
> format). Second, your query implies a join, but really you just want to 
> filter f_collection_id based on a single value, so you probably want 
> something like:
>
> db.geo_collection.f_featured_img.requires = IS_IN_DB(
> db(db.geo_item.f_collection_id == current_collection_id),
> db.geo_item.id, ...)
>
> You'll have to set current_collection_id to the appropriate value.
>
> Anthony
>
>
>
>
> On Monday, October 12, 2015 at 12:54:03 PM UTC-4, John Smidt wrote:
>>
>> Hi,
>> I am trying to populate a drop down box so that a user may choose a 
>> "featured Image" from a collection of images. There are multiple 
>> collections, so I need to filter out the other images that are in the 
>> different collections. The code I have is shown below:
>>
>> db.geo_collection.f_featured_img.requires=IS_IN_DB(db, 
>> (db.geo_item.f_collection_id == db.geo_collection.id),lambda row: '%s' % 
>> row.id + " - " + row.f_name)
>>
>> What I had in mind is that the program would go through every item in the 
>> database, and compare its collection id with the collection's id that we 
>> are currently looking at. If the item passes this boolean statement, then 
>> it is added to the dropdown box.
>>
>> When I do this, it states that there are too many values to unpack. 
>> Traceback below:
>>
>> Traceback (most recent call last):
>>   File "/home/SIRI/web2py/gluon/restricted.py", line 217, in restricted
>> exec ccode in environment
>>   File "/home/SIRI/web2py/applications/mqr/models/db_wizard.py" 
>> ,
>>  line 149, in 
>> db.geo_collection.f_featured_img.requires=IS_IN_DB(db, 
>> (db.geo_item.f_collection_id == db.geo_collection.id),lambda row: '%s' % 
>> row.id + " - " + row.f_name)
>>   File "/home/SIRI/web2py/gluon/validators.py", line 497, in __init__
>> (ktable, kfield) = str(field).split('.')
>> ValueError: too many values to unpack
>>
>> I thought that using the 'IS_IN_DB' command might be messing with this, 
>> so I changed it to 'IS_IN_SET'. I got this error instead:
>>
>> Traceback (most recent call last):
>>   File "/home/SIRI/web2py/gluon/restricted.py", line 217, in restricted
>> exec ccode in environment
>>   File "/home/SIRI/web2py/applications/mqr/controllers/cms.py" 
>> , 
>> line 478, in 
>>   File "/home/SIRI/web2py/gluon/globals.py", line 372, in 
>> self._caller = lambda f: f()
>>   File "/home/SIRI/web2py/gluon/tools.py", line 3239, in f
>> return action(*a, **b)
>>   File "/home/SIRI/web2py/applications/mqr/controllers/cms.py" 
>> , 
>> line 26, in display_manage
>> oncreate=coll_create,onupdate=coll_create)
>>   File "/home/SIRI/web2py/gluon/sqlhtml.py", line 2764, in smartgrid
>> user_signature=user_signature, **kwargs)
>>   File "/home/SIRI/web2py/gluon/sqlhtml.py", line 2093, in grid
>> update_form = SQLFORM(table, record, **sqlformargs)
>>   File "/home/SIRI/web2py/gluon/sqlhtml.py", line 1145, in __init__
>> inp = self.widgets.options.widget(field, default)
>>   File "/home/SIRI/web2py/gluon/sqlhtml.py", line 270, in widget
>> options = requires[0].options()
>>   File "/home/SIRI/web2py/gluon/validators.py", line 428, in options
>> items = [(k, self.labels[i]) for (i, k) in enumerate(self.theset)]
>> TypeError: 'Query' object does not support indexing
>>
>>
>> Any ideas on how I could do this? I feel like it's a really simple tweak, 
>> but I'm just not seeing it. Any help would be fantastic.
>>
>>
>>

-- 
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] what if i want bootstrap with semanticui ?

2015-10-13 Thread António Ramos
I like semantic a lot better than bootstrap.


Why the hell did you glue bootstrap with web2py ?

It should be kind of a "plugin" like npm install bootstrap or something
like that.
I know there has been some discussion about it but using google groups mess
i cant find it so i need to ask again

Regards
António

-- 
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] what if i want bootstrap with semanticui ?

2015-10-13 Thread Richard Vézina
I think, semantic get more usable in the last version, but bootstrap was
just there before. So, I guess it is the main reason why web2py is tide to
bootstrap... Also, I know that Massimo really like semantic, so feel free
to propose web2py integration or welcome_semantic and it will surely be
merged...

Richard

On Tue, Oct 13, 2015 at 12:35 PM, António Ramos 
wrote:

> I like semantic a lot better than bootstrap.
>
>
> Why the hell did you glue bootstrap with web2py ?
>
> It should be kind of a "plugin" like npm install bootstrap or something
> like that.
> I know there has been some discussion about it but using google groups
> mess i cant find it so i need to ask again
>
> Regards
> António
>
> --
> 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] what if i want bootstrap with semanticui ?

2015-10-13 Thread Richard Vézina
I tried derive a semantic for the w3 Massimo's prototype of client side
welcome which use Ractive.js for client side interaction, but my lack of
time stall the process...

Richard

On Tue, Oct 13, 2015 at 1:30 PM, Richard Vézina  wrote:

> I think, semantic get more usable in the last version, but bootstrap was
> just there before. So, I guess it is the main reason why web2py is tide to
> bootstrap... Also, I know that Massimo really like semantic, so feel free
> to propose web2py integration or welcome_semantic and it will surely be
> merged...
>
> Richard
>
> On Tue, Oct 13, 2015 at 12:35 PM, António Ramos 
> wrote:
>
>> I like semantic a lot better than bootstrap.
>>
>>
>> Why the hell did you glue bootstrap with web2py ?
>>
>> It should be kind of a "plugin" like npm install bootstrap or something
>> like that.
>> I know there has been some discussion about it but using google groups
>> mess i cant find it so i need to ask again
>>
>> Regards
>> António
>>
>> --
>> 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: Don't laugh but I like the admin editor ;o)

2015-10-13 Thread Dave S


On Tuesday, October 13, 2015 at 2:10:48 AM UTC-7, Edward Shave wrote:
>
> Ok, I don't know why it took so long but just in case anyone else out 
> there is as thick as me...
>
> Make sure the editor has the focus before using the find and replace 
> feature, otherwise your key presses will be directed to the browser  DOH..!
>

Useful feedback, thanks.

/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] handling None for list:reference

2015-10-13 Thread Carl Hunter Roach
apologies for this question - I see it's been popular over the years - but 
I can't find the definitive answer.

How can I either:
a) handle the case of have no references to insert? or
b) avoid the duplication of two db inserts that are identical except one is 
missing a field that can't be set to None.?

Note: I am not building a HTML ui from the database definition but 
inserting data via code.

in my db.py:

db.define_table('item', ..., Field('geoPts', 'list:reference geoPt'), ...)

in a module:

pts = # set to a list of zero or more db id values

if pts:
db.item.insert(
...
geoPts=pts,
)

else:
db.item.insert(
...
# note that we don't try and set geoPts to None
)

-- 
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: Error in plugin S -Cubism "Tree Crud"

2015-10-13 Thread Dave S


On Tuesday, October 13, 2015 at 5:45:57 AM UTC-7, Willoughby wrote:
>
> Sadly that code is 4 years old and their web site has been deactivated, 
> which I think fits the definition of 'no longer maintained'.
> I might suggest moving to something else.
>

If tree handling is the goal, does Massimo's post from 2 years ago help?

https://groups.google.com/d/msg/web2py/bsGZ4lp-gz4/4olaBq6t7qQJ>

If the OP is looking for a CSS solution, that may not be what he wants.

/dps

 

>
> On Tuesday, October 13, 2015 at 7:05:53 AM UTC-4, javierobcn wrote:
>>
>> I'm really stuck for a few weeks , if someone can help me out . 
>>
>> I use the plugin developed by S -Cubism "Tree Crud"
>>
>> https://github.com/scubism/sqlabs
>>
>> This plugin worked well in earlier versions of web2py , but in the 
>> latest, when i add a node , always gives error " Unauthorized"
>>
>> I tried to debug the error but I can not fix it.
>>
>> Anyone can download the plugin and give me a hand to debug ?
>>
>>

-- 
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] Buying a template for the community...

2015-10-13 Thread Dave S


On Tuesday, October 13, 2015 at 6:43:29 AM UTC-7, Jim S wrote:
>
> I think it is a great idea to get a default theme working out of the box. 
>  I've written 3 (I think) web2py applications using different themes from 
> wrapbootstrap.com in the past.  The key (in my opinion) is to find one 
> that doesn't have a lot of javascript magic going on behind the scenes. 
>  And, to find one that is free and properly licensed.  The ones I've used 
> in the past I've paid for just for the one application where I used it.  
>
> The free ones mentioned above look great.  I didn't look to see if there 
> was much javascript magic going on in the background, but did really like 
> the looks of them.  Also, I like themes that make use of datatables.  I've 
> had good luck using datatables in the past with web2py apps.
>
> If the community could decide on one they'd like to see used, I will try 
> to devote some time to get it web2py-ready...
>
>>
>>
https://playbook.cio.gov/designstandards/getting-started/ 

>
as introduced and  explained at
https://18f.gsa.gov/2015/09/28/web-design-standards/>

 
The code for that is on github at
https://github.com/18F/web-design-standards>
although it is set up for Ruby, and they do promote some CSS compilers 
(Bourbon?)


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


Re: [web2py] Re: CMS WEB2PY

2015-10-13 Thread Dave S


On Monday, October 12, 2015 at 12:12:46 PM UTC-7, Vinicius Assef wrote:
>
> Quokka CMS is a very nice and modern choice, too. 
>
>
Got a pointer?  I don't think the solar cell calculator was the software 
you meant.

/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: Insert/update user record in 2 db

2015-10-13 Thread Niphlod
a legacy db just needs migrate=False. Nothing else. Just as a production db 
where migrations aren't needed in THAT single request. 

tl;dr: The default for every NON "development-mylaptop-etc" environment 
should be migrate=False. Let me reinstate once again: migrate=True is a 
TOTAL WASTE of cpu when models aren't requiring any migration

back to you issue: if you're comfortable with executing queries by hand in 
the database, a DAL line is all you need. If you want to leverage fancy 
syntax over an Abstraction (where the A in DAL comes from), you kinda need 
to define the Abstraction. Which, boiled down, means defining table models 
you want to interact with.



On Tuesday, October 13, 2015 at 4:16:37 PM UTC+2, Gael Princivalle wrote:
>
> Hello all.
>
> In a web2py application I would like to insert/update user records in 2 db.
> The first one is the application db, a postgres db:
> db = DAL('postgres://user:pass@localhost:5432/my_web2py_app_db', 
> check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True, 
> migrate=True)
>
>
> The second one is used by a mailing program called php list. It's a mysql 
> db.
> db_php_list = DAL('mysql://user:pass@localhost:3306/my_php_list_db', 
> fake_migrate_all=False, migrate=True)
>
> I don't see any db_php_list table in database administration.
>
> Mysql port is 3306?
> For an existing db, I've to add 'fake_migrate_all=False, migrate=True', 
> right?
>
> Admitting that I can connect to the mysql db, how can I handle the user 
> insert/updates to both db?
>
> Thanks, regards.
>
>
>
>

-- 
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: CMS WEB2PY

2015-10-13 Thread Anthony

>
> On Monday, October 12, 2015 at 12:12:46 PM UTC-7, Vinicius Assef wrote:
>>
>> Quokka CMS is a very nice and modern choice, too. 
>>
>>
> Got a pointer?  I don't think the solar cell calculator was the software 
> you meant.
>

http://quokkaproject.org/

It's based on Flask. Created by a former web2py core contributor.

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 for onion.io ?

2015-10-13 Thread Niphlod
IMHO 64mb are enough. The real question is how much ram is available once 
the OS has been loaded. 
Also, the same question applies to the 16 MB of flash drive: it's really 
NOT that much. E.g. web2py weights  exactly 16MB uncompressed. 
Stripping it down (no populate.py, no admin nor examples app, a light 
"init" app, no pg8000 nor pymysql, pyfpdf) it comes to an usable 8MB. It's 
not impossible but still beware: that thing isn't modern at all.
BTW: it's not really a web2py problem. nodejs binary (no absolute else) 
weights no less than 25 MB.

On Tuesday, October 13, 2015 at 12:42:48 PM UTC+2, Ramos wrote:
>
> That is not my idea.
> I´m going down the specs to see the smallest web2py enabled IOT device.
>
> Thank you
>
> 2015-10-13 11:24 GMT+01:00 Leonel Câmara  >:
>
>> It's a little low on the memory side but it runs python so I don't see 
>> why not as long as you don't expect to be serving a lot of requests. I 
>> would probably prefer a raspberry pi because it has quite a lot more memory.
>>
>> -- 
>> 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] qrcode

2015-10-13 Thread Fabiano Almeida
Hi all!

How to dynamically generate qr code in web2py?

grateful,

Fabiano.

-- 
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] Path to Appconfig

2015-10-13 Thread lenin . martinez
Good mornings Community.

Exist some way to set a path to appConfig.ini ?? Because my config file is 
in another server and i need read from there, And that file can be in JSON 
??

THanks.



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

2015-10-13 Thread Niphlod
with any qrcode library or qrcode ondemand service out there ? What did you 
try ?

On Tuesday, October 13, 2015 at 11:05:23 PM UTC+2, Fabiano Almeida wrote:
>
> Hi all!
>
> How to dynamically generate qr code in web2py?
>
> grateful,
>
> Fabiano.
>

-- 
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: Path to Appconfig

2015-10-13 Thread Niphlod
appconfig kinda needs to be local
can definitely be a valid json and you can set the path as the first 
argument. 

On Tuesday, October 13, 2015 at 11:10:02 PM UTC+2, 
lenin.m...@metamaxzone.com wrote:
>
> Good mornings Community.
>
> Exist some way to set a path to appConfig.ini ?? Because my config file is 
> in another server and i need read from there, And that file can be in JSON 
> ??
>
> THanks.
>
> 
>

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

2015-10-13 Thread 黄祥
i think there is web2py appliances that create some thing like this before 
: semanticwebexample

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] Re: qrcode

2015-10-13 Thread Richard Vézina
You can have a look on the side of elaphe :
https://bitbucket.org/whosaysni/elaphe/

For most type of code it works... But there were issue with bouding box for
some of them in the pass, hope it has been solve since then...

Richard

On Tue, Oct 13, 2015 at 5:28 PM, 黄祥  wrote:

> i think there is web2py appliances that create some thing like this before
> : semanticwebexample
>
> 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.
>

-- 
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: CMS WEB2PY

2015-10-13 Thread Dave S


On Tuesday, October 13, 2015 at 12:31:24 PM UTC-7, Anthony wrote:
>
> On Monday, October 12, 2015 at 12:12:46 PM UTC-7, Vinicius Assef wrote:
>>>
>>> Quokka CMS is a very nice and modern choice, too. 
>>>
>>>
>> Got a pointer?  I don't think the solar cell calculator was the software 
>> you meant.
>>
>
> http://quokkaproject.org/
>
> It's based on Flask. Created by a former web2py core contributor.
>
>

Thanks.  That definitely missed my search.

/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: what if i want bootstrap with semanticui ?

2015-10-13 Thread Anthony
On Tuesday, October 13, 2015 at 12:35:31 PM UTC-4, Ramos wrote:
>
> I like semantic a lot better than bootstrap.
>
>
> Why the hell did you glue bootstrap with web2py ?
>

I wouldn't say Bootstrap is "glued" with web2py. web2py comes with an 
optional scaffolding application that includes a front end, and that front 
end happens to be based on Bootstrap. The front end has to be based on 
*something* -- if we choose Semantic, then folks will ask why not 
Bootstrap? Given the popularity and prevalence of Bootstrap, it isn't a bad 
choice.

More generally, I would argue that the choice of front end framework for 
the scaffolding app is not *that *important. The fact is, if you want to 
make any significant customizations to the look and feel of the UI, it 
isn't much harder to start completely from scratch with some template based 
on another framework than it is to try to alter the existing app (most of 
the work is in customizing layout.html and developing form and grid 
styles). On the other hand, if you don't want any significant 
customization, then it shouldn't much matter what framework is used, as 
long as the end result looks decent and is usable.

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: Filtering a set of items from a collection issues

2015-10-13 Thread Anthony


On Tuesday, October 13, 2015 at 12:21:10 PM UTC-4, John Smidt wrote:
>
> Ok, I get how the IS_IN_SET needs a filtered set as the first argument but 
> now I'm not sure how to get the current_collection_id? This is all dealing 
> with a SQLFORM.grid and my .requires statement is in my model so how do I 
> get the id of the collection that was selected from the grid into my model 
> for the filter?
>

First, no reason not to use IS_IN_DB -- it is designed for this purpose.

Regarding the current collection ID, you can just set the validator within 
your controller (after you get the current ID) -- the "requires" attribute 
of a field can be changed at any time before the actual validation happens. 
Another option is to get it from request.vars (if the current request 
doesn't involve the controller action in question, then the value will 
simply be None).

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: CMS WEB2PY

2015-10-13 Thread Kiran Subbaraman

Carlos,
Nice site. I'll follow your github space (https://github.com/daxslab) , 
and take a look at the CMS code, once its on github.



Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On Tue, 13-10-2015 6:48 PM, Carlos Cesar Caballero Díaz wrote:
I am working on a site that is builded using custom made CMS, I am 
planning to release it to github when it's finished (the cms), right 
now you can see the site (work in progress) at www.daxslab.com, 
suggestions and criticism are very welcomed


El 12/10/15 a las 06:09, Paolo Amboni escribió:
Are there some contraindications to use web2py with php based cms 
like joomla?


Il giorno sabato 10 ottobre 2015 18:34:55 UTC+2, Anthony ha scritto:

If it has to be Python, there are several Django based CMSes --
Wagtail looks like a nice one (there's also
Mezzanine and Django CMS).

Anthony

On Saturday, October 10, 2015 at 3:32:22 AM UTC-4, Paolo Amboni
wrote:

After some research i finally concluded that there is no
stable and structured CMS made for web2py (tell me if i'm wrong).
Which is a python cms that better can be put beside a web2py
site (already made)?
Thanks.

--
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)
- 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: PyCharm license for web2py dev - who wants?

2015-10-13 Thread Gerd
+1

Am Sonntag, 11. Oktober 2015 21:21:16 UTC+2 schrieb Francisco Ribeiro:
>
> Hello all,
>
> for those who know PyCharm is a great IDE from JetBrains that provides 
> free licenses for Open Source projects like web2py ( 
> https://www.jetbrains.com/buy/opensource/?product=pycharm ). To request 
> such a license, I need to know how many of you would want one of these as 
> well so I can provide them with a number of seats. 
>
> A "+1" response for me is enough but I will also need your email address 
> to send you the license key (which you can send on a private message).
>
> Kind regards,
> Francisco
>

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