[web2py] Re: Handle runtimeErrors with try/except

2015-10-15 Thread Anthony
except db._adapter.driver.OperationalError:

Anthony

On Thursday, October 15, 2015 at 11:29:25 PM UTC-4, 
argenio.bosa...@metamaxzone.com wrote:
>
> Good morning, I need handle exceptions when a database can't connect, 
>
> When that ocurre, the traceback is:
>
> Traceback (most recent call last):
>   File "/var/www/web2py/gluon/restricted.py", line 227, in restricted
> exec ccode in environment
>   File "/var/www/web2py/applications/servicios/models/00db.py" 
> , line 23, 
> in 
> 'db.pool_size', cast=int), check_reserved=['all'])
>   File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 174, in 
> __call__
> obj = super(MetaDAL, cls).__call__(*args, **kwargs)
>   File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 459, in 
> __init__
> raise RuntimeError("Failure to connect, tried %d times:\n%s" % (attempts, 
> tb))
> RuntimeError: Failure to connect, tried 5 times:
> Traceback (most recent call last):
>   File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 437, in 
> __init__
> self._adapter = ADAPTERS[self._dbname](**kwargs)
>   File "/var/www/web2py/gluon/packages/dal/pydal/adapters/base.py", line 57, 
> in __call__
> obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
>   File "/var/www/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line 
> 132, in __init__
> if do_connect: self.reconnect()
>   File "/var/www/web2py/gluon/packages/dal/pydal/connection.py", line 125, in 
> reconnect
> self.connection = f()
>   File "/var/www/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line 
> 130, in connector
> return self.driver.connect(**driver_args)
>   File "/var/www/web2py/gluon/contrib/pymysql/__init__.py", line 93, in 
> Connect
> return Connection(*args, **kwargs)
>   File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 575, in 
> __init__
> self._connect()
>   File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 741, in 
> _connect
> self._request_authentication()
>   File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 796, in 
> _request_authentication
> self._send_authentication()
>   File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 845, in 
> _send_authentication
> auth_packet.check_error()
>   File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 341, in 
> check_error
> raise_mysql_exception(self.__data)
>   File "/var/www/web2py/gluon/contrib/pymysql/err.py", line 142, in 
> raise_mysql_exception
> _check_mysql_exception(errinfo)
>   File "/var/www/web2py/gluon/contrib/pymysql/err.py", line 135, in 
> _check_mysql_exception
> raise errorclass, (errno,errorvalue)
> OperationalError: (1045, u"Access denied for user 'admin'@'172.17.0.2' (using 
> password: YES)")
>
>
> try:
>
> someCode()
>
> except RuntimeError:
> return 'errors'
>
>
> but that don't work, what is the method to catch this exceptions?
>
> thanks very much
>
>

-- 
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: Documentation: update requires writable=False

2015-10-15 Thread Anthony
Note, although good practice, you don't technically have to set writable to 
False, you just have to make sure no value is submitted for that field when 
doing an update, as the "update" attribute is intended as a default value 
when the record is updated (by definition, defaults apply only when an 
explicit value is not provided).

Anthony

On Thursday, October 15, 2015 at 11:29:04 PM UTC-4, Tom Clerckx wrote:
>
> Today I was struggling with why the following did not work for me in one 
> of my tables:
>
> Field('modified_on', 'datetime', default=request.now, update=request.now)
>
>
> After some fiddling I found that writable=False must be explicitly added for 
> this to work properly.
>
>
> --> Field('modified_on', 'datetime', default=request.now, update=request.now, 
> writable=False)
>
>
> I understand that it does not make sense to have writable=True when you added 
> update=... to a field (same counts if you use compute), but I believe it does 
> make sense to add this in the documentation (in the DAL chapter describing 
> the Field constructor) - just so other people don't waste time figuring this 
> out.
>
>
> Best regards,
>
> Tom.
>
>

-- 
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: How to provide feedback on button in LINKS section of sqlform.grid ?

2015-10-15 Thread Gary Cowell
Oh yes!

I was so close. Thanks for the help, you solved it :)


On Friday, 16 October 2015 04:34:04 UTC+1, DenesL wrote:
>
> Change that to
>
>   el.text = "Working...";
>
>
>
>
>
> On Sunday, October 11, 2015 at 4:20:58 AM UTC-4, Gary Cowell wrote:
>>
>> Hello. 
>>
>> I'm trying to give the user some feedback when they click on a links 
>> (link button) in the links section of a sqlform grid.
>>
>> I have this button code:
>>
>>button = A(
>> SPAN(_class="icon play icon-play glyphicon glyphicon-play")
>> ,"Start"
>> ,_id="startstop"
>> ,_class="button btn btn-success"
>> ,_title="Start"
>> ,_onclick="return change(this);"
>> ,_href=URL("dynamic","startstop",
>> args=[system.id, buttonURL, buttonTitle, db.e5system] , 
>> user_signature=True )
>> )
>>
>>
>> And this script in my view:
>>
>> 
>> function change( el )
>> {
>> el.value = "Working...";
>> }
>> 
>>
>>
>> But nothing happens when I click the button.
>>
>> I've tried many bits of javascript over the last few days and I'm getting 
>> nowhere fast.
>>
>> Can someone kindly give me a steer on what to do ?
>>
>> 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: How to provide feedback on button in LINKS section of sqlform.grid ?

2015-10-15 Thread 'DenesL' via web2py-users
Change that to

  el.text = "Working...";





On Sunday, October 11, 2015 at 4:20:58 AM UTC-4, Gary Cowell wrote:
>
> Hello. 
>
> I'm trying to give the user some feedback when they click on a links (link 
> button) in the links section of a sqlform grid.
>
> I have this button code:
>
>button = A(
> SPAN(_class="icon play icon-play glyphicon glyphicon-play")
> ,"Start"
> ,_id="startstop"
> ,_class="button btn btn-success"
> ,_title="Start"
> ,_onclick="return change(this);"
> ,_href=URL("dynamic","startstop",
> args=[system.id, buttonURL, buttonTitle, db.e5system] , 
> user_signature=True )
> )
>
>
> And this script in my view:
>
> 
> function change( el )
> {
> el.value = "Working...";
> }
> 
>
>
> But nothing happens when I click the button.
>
> I've tried many bits of javascript over the last few days and I'm getting 
> nowhere fast.
>
> Can someone kindly give me a steer on what to do ?
>
> 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] Documentation: update requires writable=False

2015-10-15 Thread Tom Clerckx
Today I was struggling with why the following did not work for me in one of 
my tables:

Field('modified_on', 'datetime', default=request.now, update=request.now)


After some fiddling I found that writable=False must be explicitly added for 
this to work properly.


--> Field('modified_on', 'datetime', default=request.now, update=request.now, 
writable=False)


I understand that it does not make sense to have writable=True when you added 
update=... to a field (same counts if you use compute), but I believe it does 
make sense to add this in the documentation (in the DAL chapter describing the 
Field constructor) - just so other people don't waste time figuring this out.


Best regards,

Tom.

-- 
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] bootstrap3 forms

2015-10-15 Thread Egor Sledov
I am trying to use a bootstrap3 template for my project. 

In bootstrap forms div element containing the input has class "has-error".

In web2py (gluon/html.py) input control itself is specially marked if it 
has na error. 
Well, more or less.

If I am returning an SQLFORM what would be the right approach to change a 
class of a parent element of an input? I looked at formstyles, but 
apparently when when formstyle is applied the form.errors is not populated 
yet.

Does anybody have a bootstrap3 library for web2py that "just works" by any 
chance? Or at least follows http://getbootstrap.com/css/#forms more closely.

Thank you.

-- 
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] Handle runtimeErrors with try/except

2015-10-15 Thread argenio . bosanto
Good morning, I need handle exceptions when a database can't connect, 

When that ocurre, the traceback is:

Traceback (most recent call last):
  File "/var/www/web2py/gluon/restricted.py", line 227, in restricted
exec ccode in environment
  File "/var/www/web2py/applications/servicios/models/00db.py" 
, line 23, 
in 
'db.pool_size', cast=int), check_reserved=['all'])
  File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 174, in __call__
obj = super(MetaDAL, cls).__call__(*args, **kwargs)
  File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 459, in __init__
raise RuntimeError("Failure to connect, tried %d times:\n%s" % (attempts, 
tb))
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/var/www/web2py/gluon/packages/dal/pydal/base.py", line 437, in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
  File "/var/www/web2py/gluon/packages/dal/pydal/adapters/base.py", line 57, in 
__call__
obj = super(AdapterMeta, cls).__call__(*args, **kwargs)
  File "/var/www/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line 132, 
in __init__
if do_connect: self.reconnect()
  File "/var/www/web2py/gluon/packages/dal/pydal/connection.py", line 125, in 
reconnect
self.connection = f()
  File "/var/www/web2py/gluon/packages/dal/pydal/adapters/mysql.py", line 130, 
in connector
return self.driver.connect(**driver_args)
  File "/var/www/web2py/gluon/contrib/pymysql/__init__.py", line 93, in Connect
return Connection(*args, **kwargs)
  File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 575, in 
__init__
self._connect()
  File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 741, in 
_connect
self._request_authentication()
  File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 796, in 
_request_authentication
self._send_authentication()
  File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 845, in 
_send_authentication
auth_packet.check_error()
  File "/var/www/web2py/gluon/contrib/pymysql/connections.py", line 341, in 
check_error
raise_mysql_exception(self.__data)
  File "/var/www/web2py/gluon/contrib/pymysql/err.py", line 142, in 
raise_mysql_exception
_check_mysql_exception(errinfo)
  File "/var/www/web2py/gluon/contrib/pymysql/err.py", line 135, in 
_check_mysql_exception
raise errorclass, (errno,errorvalue)
OperationalError: (1045, u"Access denied for user 'admin'@'172.17.0.2' (using 
password: YES)")


try:

someCode()

except RuntimeError:
return 'errors'


but that don't work, what is the method to catch this exceptions?

thanks very much

-- 
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: 0.db naming convention?

2015-10-15 Thread Egor Sledov
I believe files from models folder are loaded in alphabetical sequence. So, 
say, customers.py will be read before db.py file , where connection (and 
other application level things are defined). 

If you have file 0.db.py, it will be loaded before customers.py and likely 
before any other file you may create in models folder.

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

2015-10-15 Thread Jack Kuan
+1 Would love to give it a try. 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.


Re: [web2py] Re: 0.db naming convention?

2015-10-15 Thread Vinicius Assef
Appconfig is somewhat documented in the github repo.

Fill the search box and see the result.


--
Vinicius Assef

On 15 October 2015 at 13:07, Tom Campbell  wrote:

> Thank you, Leonel. AppConfig seems to be totally undocumented. Is this my
> cue to contribute to the docs by rooting around in the source
>  and
> asking you folks stupid questions about AppConfig?
>
> --
> 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: _onkeyup / ajax call

2015-10-15 Thread Mark Billion
Tried, but had problems with longer ones

j_query_calls = """https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js";>
"""
row_adder = """

$( document ).ready(function() {
$('#Debts_creditor__row').after('Suggested Creditors
'); $( "#Debts_creditor" ).keyup(function() { ajax('%s', ['creditor'], 'suggestions'); });}); """ %URL('default', 'cred_selector') return '%s%s%s' %(j_query_calls,row_adder, ajax_form) On Wednesday, October 14, 2015 at 8:24:58 PM UTC-4, Dave S wrote: > > > > On Wednesday, October 14, 2015 at 2:30:03 PM UTC-7, Mark Billion wrote: >> >> NM. I injected the jquery into the header. >> > > Element selection? > > /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: How to show query on a grid?

2015-10-15 Thread Jim S
...not tested, but you should get the general idea.

Hit me back up if this is confusing to you.

-Jim


On Thursday, October 15, 2015 at 3:27:14 PM UTC-5, Jim S wrote:
>
> Try this:
>
>
> query = (db.guest.id>0) & (db.voucher.disp == False)
> fields = [db.voucher.voucher, db.guest.name, db.auth_user.id, 
> db.auth_user.first_name, db.guest.dia]
> left = (db.voucher.on(db.guest.id == db.voucher.guest), 
> db.auth_user.on(db.guest.fnd == db.auth_user.id))
> form = SQLFORM.grid(query, fields=fields, left=left)
>
> On Thursday, October 15, 2015 at 2:59:51 PM UTC-5, Fabiano Almeida wrote:
>>
>> Hi!
>>
>> I try to show query on a SQLFORM.grid, but returns error: AttributeError: 
>> 'Rows' object has no attribute '_db'
>>
>> My code:
>>
>> query = db((db.guest.id>0) & \
>> (db.voucher.disp == False) & \
>> (db.voucher.guest == db.guest.id) & \
>> (db.auth_user.id == db.guest.fnd)) \
>> .select(db.voucher.voucher, db.guest.name, db.auth_user.id , 
>> db.auth_user.first_name, db.guest.dia)
>> form = SQLFORM.grid(query)
>>
>> How to show query on a grid?
>>
>> thx in advance,
>>
>> 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: How to show query on a grid?

2015-10-15 Thread Jim S
Try this:


query = (db.guest.id>0) & \
(db.voucher.disp == False) & \
(db.voucher.guest == db.guest.id) & \
(db.auth_user.id == db.guest.fnd)

fields = [db.voucher.voucher, db.guest.name, db.auth_user.id, 
db.auth_user.first_name, db.guest.dia]

form = SQLFORM.grid(query)

On Thursday, October 15, 2015 at 2:59:51 PM UTC-5, Fabiano Almeida wrote:
>
> Hi!
>
> I try to show query on a SQLFORM.grid, but returns error: AttributeError: 
> 'Rows' object has no attribute '_db'
>
> My code:
>
> query = db((db.guest.id>0) & \
> (db.voucher.disp == False) & \
> (db.voucher.guest == db.guest.id) & \
> (db.auth_user.id == db.guest.fnd)) \
> .select(db.voucher.voucher, db.guest.name, db.auth_user.id , 
> db.auth_user.first_name, db.guest.dia)
> form = SQLFORM.grid(query)
>
> How to show query on a grid?
>
> thx in advance,
>
> 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: 0.db naming convention?

2015-10-15 Thread Leonel Câmara
Eheheh go ahead!

-- 
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] How to show query on a grid?

2015-10-15 Thread Fabiano Almeida
Hi!

I try to show query on a SQLFORM.grid, but returns error: AttributeError:
'Rows' object has no attribute '_db'

My code:

query = db((db.guest.id>0) & \
(db.voucher.disp == False) & \
(db.voucher.guest == db.guest.id) & \
(db.auth_user.id == db.guest.fnd)) \
.select(db.voucher.voucher, db.guest.name, db.auth_user.id ,
db.auth_user.first_name, db.guest.dia)
form = SQLFORM.grid(query)

How to show query on a grid?

thx in advance,

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.


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

2015-10-15 Thread Richard Vézina
How this is going, I think you may just add everyone that have ever
contribute to web2py... Just kidding...

:-P

Richard

On Thu, Oct 15, 2015 at 12:35 PM, Carlos Correia <
car...@memoriapersistente.pt> wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> +1 :D
>
> Às 20:21 de 11-10-2015, Francisco Ribeiro escreveu:
> > 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 c
> an
> > provide them with a number of seats.
> >
> > A "+1" response for me is enough but I will also need your email address
> to se
> nd
> > 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 emai
> l
> > to web2py+unsubscr...@googlegroups.com  web2py+unsubscribe@googlegroups
> .com>.
> > For more options, visit https://groups.google.com/d/optout.
>
>
> - --
> Com os melhores cumprimentos,
>
> Carlos Correia
> =
> MEMÓRIA PERSISTENTE
> Tel.: 218 471 841 (NOVO)
> GSM:  917 157 146 / 967 511 762
> e-mail: ge...@memoriapersistente.pt - URL:
> http://www.memoriapersistente.pt
> Jabber: m...@jabber.org
> GnuPG: wwwkeys.eu.pgp.net
> URL Suporte: https://t5.m16e.com/gps
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1
>
> iQIcBAEBAgAGBQJWH9W/AAoJEMmo8B8WFGV2LqQP/3gm4tWR6fNEAKuI09VN/uPn
> +XPvI79T8H1RNO163SdPTehTsxAqfeIr1pRVC8mxysz3o0rzxttLRySdEsxSx24q
> 576pFdVXkPhSt5DUezh62VtipGPc5IjOCJ4BaJ7cOmglWRSsg3WSHddONUXpjSO4
> IEvKNiaZh2JaQQJeg+lHLE51FJ62jGSrUl2zR9rgHU1xKQK51Kye/76NxBslKKVz
> pqb8pMeH2C3BAA+MIkF+DtaqeiF7gms/RYNTTM1BUi49IdtagBuodm3ClSeo3Myx
> AMcyrSGCTnHL5lpSSa/+SlseumMt4TgP4jzbuRYsYKQ9WVNVwx1p3/wypA7ldZf+
> 1+uVusEgKKF25PdEjHNxpB1HqO0fW6ES4Kx2oiGSH3+Fnxdk1of1InSf9xT6tpFR
> In3bdHATK3j0G142dgr3OfPwvKF0gh/2TZZiqgLQzKWGZ4oiWBwsGgwiQiq3/AZg
> cOxcJkETr4B8CkeV2BpVFiAZnJlgV6+iNbn91O4zI2YOnTHZ4c0XQ53JFK8awI4R
> vErO4uhWPWaOsFk8QJjIJhvJSeJOQkkrKGheUTV9YUZDjhKcxyW13X5o3gyayTz8
> ZSHyLDvKFe+avKG9owrNO4LQ5t7DtaS/bB2teQgQXavuGpAqnDoyoQmPkwysUeN1
> RdLH9oiTENCsYnxrscQe
> =XvDL
> -END PGP SIGNATURE-
>
> --
> 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] PyCharm license for web2py dev - who wants?

2015-10-15 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

+1 :D

Às 20:21 de 11-10-2015, Francisco Ribeiro escreveu:
> 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 c
an
> provide them with a number of seats. 
> 
> A "+1" response for me is enough but I will also need your email address to se
nd
> 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 emai
l
> to web2py+unsubscr...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.


- -- 
Com os melhores cumprimentos,

Carlos Correia
=
MEMÓRIA PERSISTENTE
Tel.: 218 471 841 (NOVO)
GSM:  917 157 146 / 967 511 762
e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt
Jabber: m...@jabber.org
GnuPG: wwwkeys.eu.pgp.net
URL Suporte: https://t5.m16e.com/gps
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJWH9W/AAoJEMmo8B8WFGV2LqQP/3gm4tWR6fNEAKuI09VN/uPn
+XPvI79T8H1RNO163SdPTehTsxAqfeIr1pRVC8mxysz3o0rzxttLRySdEsxSx24q
576pFdVXkPhSt5DUezh62VtipGPc5IjOCJ4BaJ7cOmglWRSsg3WSHddONUXpjSO4
IEvKNiaZh2JaQQJeg+lHLE51FJ62jGSrUl2zR9rgHU1xKQK51Kye/76NxBslKKVz
pqb8pMeH2C3BAA+MIkF+DtaqeiF7gms/RYNTTM1BUi49IdtagBuodm3ClSeo3Myx
AMcyrSGCTnHL5lpSSa/+SlseumMt4TgP4jzbuRYsYKQ9WVNVwx1p3/wypA7ldZf+
1+uVusEgKKF25PdEjHNxpB1HqO0fW6ES4Kx2oiGSH3+Fnxdk1of1InSf9xT6tpFR
In3bdHATK3j0G142dgr3OfPwvKF0gh/2TZZiqgLQzKWGZ4oiWBwsGgwiQiq3/AZg
cOxcJkETr4B8CkeV2BpVFiAZnJlgV6+iNbn91O4zI2YOnTHZ4c0XQ53JFK8awI4R
vErO4uhWPWaOsFk8QJjIJhvJSeJOQkkrKGheUTV9YUZDjhKcxyW13X5o3gyayTz8
ZSHyLDvKFe+avKG9owrNO4LQ5t7DtaS/bB2teQgQXavuGpAqnDoyoQmPkwysUeN1
RdLH9oiTENCsYnxrscQe
=XvDL
-END PGP SIGNATURE-

-- 
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-15 Thread Michael M
+1

On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote:
>
> 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.


[web2py] Re: 0.db naming convention?

2015-10-15 Thread Tom Campbell
Thank you, Leonel. AppConfig seems to be totally undocumented. Is this my 
cue to contribute to the docs by rooting around in the source 
 and 
asking you folks stupid questions about AppConfig?

-- 
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: issue with recursive caches?

2015-10-15 Thread Leonel Câmara
No, cache disk does share data as long as it's the same folder and it locks 
the files themselves.

Anyway using the caches as in your last scenario should not cause any 
problems.

-- 
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: Why is https not working (not private) with my implementation of this web2py slice?

2015-10-15 Thread Phillip
I can access the page, but in order to access the functionality of the 
service worker process on the page, it appears some other step needs to be 
taken to properly utilize https.

Is there no way to 'normalize' https for this app?

-- 
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: how to return nothing

2015-10-15 Thread Alex Glaros
Perfect!

thanks Leonel,

only took 2 seconds to update 188,146 postal codes on sqlLite on my desktop.

I added a db.commit() line afterwards...not sure if needed.

Much appreciated!

Alex

-- 
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: issue with recursive caches?

2015-10-15 Thread Kiran Subbaraman

Ok, two things:
Firstly - As demonstrated in the sample application that I attached with 
the original post, I was using the combination of cache.ram with 
cache.disk, as my default cache: cache.ram(key, lambda: cache.disk(...), 
ttl)
Secondly, in the scenario where I create instance of CacheInRam, and 
CacheOnDisk, and use them like so:

cache_ram = CacheInRam()
cache_disk = CacheOnDisk(ONE_CONSTANT_FOLDER)
cache_ram(key, lambda: cache_disk(key, lambda: ..., ttl), ttl)

In the second case, yes the instances are new ones per request ( but 
this is a scenario I tried when testing my application independent of 
web2py). Note that it goes to the disk everytime, and all the cache disk 
instances are referring to the same cache folder. So, in this case, 
whether it refers to the same cache folder or not, it basically is not 
sharing the cache data ... is that what you meant? This is the reason 
why I did not see any contention.
Whereas, in this second case, if I were to retain a singleton of 
cache_disk, then I should be seeing the issue with cache.disk?



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

On Thu, 15-10-2015 8:37 PM, Leonel Câmara wrote:
Ohh wait a minute I thought only cache disk was involved. If you 
create new instances of CacheRam instead of using the one already 
provided you are not using the cache at all as the new instances will 
have an empty cache.

--
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: OperationalError: database is locked

2015-10-15 Thread Niphlod
mongodb isn't a supported backend for the scheduler.
And to answer your previous request: db2 is there just to support scheduler 
"internals" . if your task still wants to write to db there's nothing wrong 
with it.

On Thursday, October 15, 2015 at 4:39:17 AM UTC+2, kenny c wrote:
>
> If SQLite cannot handle many concurrent users while writing/reading, 
> should I move to postgres or mongoDB? There will be over 10k rows added 
> every 10mins.
>
> Thanks.
>
> On Wednesday, October 14, 2015 at 10:03:30 PM UTC-4, kenny c wrote:
>>
>> Hi Niphlod,
>>
>> Thank you for this information. 
>>
>> Could you tell me how you manage to copy new data into db from db2 after 
>> finishing the scheduler job?
>>
>> Thank you.
>>
>> On Friday, November 9, 2012 at 10:31:03 AM UTC-5, Niphlod wrote:
>>>
>>> if you can, use a separate db for the scheduler. SQLite doesn't handle 
>>> well concurrent writes (with default operational capabilities), so having 
>>> the scheduler operating on the same database of your "insertion" of 
>>> messages can lead to locks.
>>>
>>> Just do 
>>>
>>> db = DAL('whatever.db')
>>> db2 = DAL('whatever_scheduler.db')
>>>
>>> db.define_table('messages', .)
>>>
>>> from gluon.scheduler import Scheduler
>>> mysched = Scheduler(db2)
>>>
>>> and to queue tasks you can then use
>>>
>>> db2.scheduler_tasks.validate_and_insert()
>>>
>>> or, with the new API
>>>
>>> mysched.queue_task(***)
>>>
>>>
>>>
>>> On Friday, November 9, 2012 3:56:59 PM UTC+1, Mike Anson wrote:

 Greetings...

 I may have a problem with my database (sqlite) locking.

 Traceback (most recent call last):
   File "/home/web2py/src/web2py/gluon/scheduler.py", line 218, in 
 executor
 result = dumps(_function(*args,**vars))
   File "applications/ircmessage/models/tasks.py", line 57, in 
 send_unsent_messages
 for row in db(db.messages.status=='unsent').select(db.messages.id, 
 db.messages.message, db.messages.uid):
   File "/home/web2py/src/web2py/gluon/dal.py", line 8787, in select
 return adapter.select(self.query,fields,attributes)
   File "/home/web2py/src/web2py/gluon/dal.py", line 2127, in select
 return super(SQLiteAdapter, self).select(query, fields, attributes)
   File "/home/web2py/src/web2py/gluon/dal.py", line 1615, in select
 return self._select_aux(sql,fields,attributes)
   File "/home/web2py/src/web2py/gluon/dal.py", line 1580, in _select_aux
 self.execute(sql)
   File "/home/web2py/src/web2py/gluon/dal.py", line 1693, in execute
 return self.log_execute(*a, **b)
   File "/home/web2py/src/web2py/gluon/dal.py", line 1687, in log_execute
 ret = self.cursor.execute(*a, **b)
 OperationalError: database is locked

 I have a scheduler every minute that get's records (messages) out of 
 the DB with a status of unsent. The messages then get posted to an IRC 
 channel and updated to sent to they are not included the next time the 
 scheduler runs the script.

 This seems to work just fine.

 It's when I inject a new message (which by default has a message status 
 set to unsent) via a bash script. The message inserts fine but my script 
 that posts it to the IRC channel doesn't not post anything but simply 
 updates it's status to sent without actually sending it. By sending it I 
 mean post a message over sockets.

 Here is my model for sending unsent messages:
 for row in db(db.messages.status=='unsent').select(
 db.messages.id, db.messages.message, db.messages.uid):
 message_id = row.id
 message_message = row.message
 message_uid = row.uid
 
 #socket connection already opened earlier in the script
 s.send("PRIVMSG %s :%s - %s\r\n" % (channel, message_uid, 
 message_message))
 print "message %s has been sent" % message_id

 ## Only seems to print message when a delay is here.
 time.sleep(5)

 ## Set message record to sent and update modified field
 modified_stamp = strftime("%Y-%m-%d %H:%M:%S")
 db.messages[message_id] = dict(status='sent', 
 modified=modified_stamp)
 
 db.commit()

 Inserting a message via jsonrpc (shown) and cURL (not shown):

 @service.jsonrpc
 def savemessage(message, uid):
 db.messages.insert(message=message, uid=uid)
 db.commit()
 
 message = {"status":"saved"}

 return message


 Should I simply switch to a postgresql or mysql database to prevent 
 this locking?

 Thanks for any help/advice in advance

>>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/l

[web2py] Re: issue with recursive caches?

2015-10-15 Thread Leonel Câmara
Ohh wait a minute I thought only cache disk was involved. If you create new 
instances of CacheRam instead of using the one already provided you are not 
using the cache at all as the new instances will have an empty cache.

-- 
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: issue with recursive caches?

2015-10-15 Thread Kiran Subbaraman
Thanks for confirming this issue. 

The other thing I noticed is that if I just go ahead and create an instance 
of CacheInRam and CacheOnDisk, and combine them as before, and go ahead and 
use them - this would mean that a cache ram & disk instance is created for 
practically every request, wasteful - but then I do not see this locking 
happening. So, this locking is an issue with the same instance being used 
to access the disk cache ... and doesn't arise if different cache disk 
instances are trying to work recursively?

Also, if there is any help I can extend to help with this issue, please let 
me know. Am in the middle of putting up my building and deploying my 
application ... but will set aside time to help with this issue.


On Thursday, October 15, 2015 at 7:59:23 PM UTC+5:30, Leonel Câmara wrote:
>
> Yep, the cache locks the key it's writing so this is not possible. If the 
> keys are not the same it still gets locked because of statistics gathering. 
> The only way to prevent this would be to have a disable statistics option 
> in cache disk, which I am inclined to develop as it would also allow truly 
> concurrent access to cache disk.
>

-- 
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: issue with recursive caches?

2015-10-15 Thread Leonel Câmara
Yep, the cache locks the key it's writing so this is not possible. If the 
keys are not the same it still gets locked because of statistics gathering. 
The only way to prevent this would be to have a disable statistics option 
in cache disk, which I am inclined to develop as it would also allow truly 
concurrent access to cache disk.

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

2015-10-15 Thread Daniel Aguayo
+1

2015-10-15 10:42 GMT-03:00 Loïc :

> +1
> thanks
>
>
> Le dimanche 11 octobre 2015 21:21:16 UTC+2, Francisco Ribeiro a écrit :
>>
>> 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.
>



-- 
Daniel Aguayo Catalán
@dantoac
GNU/Linux User #387337

-- 
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-15 Thread Loïc
+1
thanks

Le dimanche 11 octobre 2015 21:21:16 UTC+2, Francisco Ribeiro a écrit :
>
> 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.


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

2015-10-15 Thread Mirek Zvolský
>> Carlos >>

PyCharm Community Edition is for free, simple navigate to
https://www.jetbrains.com/pycharm/download/
choose Community Edition and Download. Works much better then Eclipse (just 
my meaning).




Dne úterý 13. října 2015 15:31:02 UTC+2 Carlos Cesar Caballero napsal(a):
>
> +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+un...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Re: CMS WEB2PY

2015-10-15 Thread Paolo Amboni
I'm very curious  to see the config part!! Let us know when you publish the 
source code. Thanks.

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.


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

2015-10-15 Thread Blutoh

 +1

On Sunday, October 11, 2015 at 3:21:16 PM UTC-4, Francisco Ribeiro wrote:
>
> 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.


[web2py] Re: how to return nothing

2015-10-15 Thread Leonel Câmara
Yes that line is wrong, this:

db(db.PostalCode.id  > 
0).update(PostalCode.countryCode 
= PostalCode.countryCodeFromGeoNames)

Should be:

db(db.PostalCode.id  > 0).update(countryCode = 
db.PostalCode.countryCodeFromGeoNames)


-- 
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: Why is https not working (not private) with my implementation of this web2py slice?

2015-10-15 Thread Leonel Câmara
That's normal since SSL certificates are usually for domains not IP 
addresses. When you open the page for the first time in your browser there 
will be a warning from the browser it should have a link like "advanced" or 
"more options" say that you know the dangers and tell it to proceed.

-- 
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: 0.db naming convention?

2015-10-15 Thread Leonel Câmara
Models are executed alphabetically so it was just a convenient way to 
define some stuff that you wanted to have available in all your models. 
Nowadays you have AppConfig so usually that's what you should use.

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