[web2py] Re: Mongo list type field update

[Alan Etkin]

> The modificador_eventos field will be a json with a list format, so im 
> trying to insert a list in it using this code:
>
> eventos = json.loads(eventos)
> lista = [eventos, eventos, eventos]
> respuesta = db(db.tarifas.id == 
> id).validate_and_update(modificador_eventos=lista).as_dict()
>
> Where var eventos is:
>
> {
> "nombre": "qq",
> "fecha_inicio": "12/12/2012",
> "fecha_fin": "14/12/2012",
> "existencias": "3",
> "descuento": "21"
> }
>
> When i try to do that i receive this exception:
>
>   File "/usr/local/lib/python2.7/dist-packages/gunicorn/workers/sync.py", 
> line 130, in handle
>

I belive that a list:string field requires you to provide with a python 
list object containing string values. Doing otherwise should throw an 
exception. I'd try to use the json field type to store JSON.
 

-- 
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: simple seo plugin

[Alan Etkin]

Ooops

The web2pyslices site sends the new post notifications, my bad, I was
just sending them to some unchecked email folder.


2015-09-03 14:40 GMT-03:00 Alan Etkin :
> Sorry, probably your first post was not checked.
>
> We should implement some kind of  post permission request on the user list
> since the automated mail for admins at the slices app wont work or was
> disabled
>
> El 03/09/2015 12:11, "Anthony"  escribió:
>>
>> Actually, there's a bigger problem. In Python, default arguments are
>> evaluated when the function is first defined, so all of your default
>> arguments will be set when the module is first imported. Therefore, all
>> references to the "current" object in the default arguments will be fixed to
>> the values of the first request (when the module is first imported). Those
>> values will not change on subsequent requests. Instead, all of those
>> arguments should be set to some other default (such as None), and then
>> re-set using "current" within the function body, as Niphlod suggests.
>>
>> Anthony
>>
>> On Thursday, September 3, 2015 at 10:46:49 AM UTC-4, Niphlod wrote:
>>>
>>>
>>>
>>> On Thursday, September 3, 2015 at 7:22:52 AM UTC+2, Carlos Cesar
>>> Caballero wrote:
>>>>
>>>> Hi Niphlod, many thanks for your suggestions, The main problem with
>>>> web2pyslices.com is that I can't publish anything and I don't know why, I
>>>> mentioned this in other threads.
>>>> About the default value in argument, I can change it, but why you prefer
>>>> default to None?
>>>
>>>
>>> It'll be easier to read.
>>> For web2pyslices.com let's wait for @spametki to chime in...
>>>

-- 
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: simple seo plugin

[Alan Etkin]

Sorry, probably your first post was not checked.

We should implement some kind of  post permission request on the user list
since the automated mail for admins at the slices app wont work or was
disabled
El 03/09/2015 12:11, "Anthony"  escribió:

> Actually, there's a bigger problem. In Python, default arguments are
> evaluated when the function is first defined, so all of your default
> arguments will be set when the module is first imported. Therefore, all
> references to the "current" object in the default arguments will be fixed
> to the values of the first request (when the module is first imported).
> Those values will not change on subsequent requests. Instead, all of those
> arguments should be set to some other default (such as None), and then
> re-set using "current" within the function body, as Niphlod suggests.
>
> Anthony
>
> On Thursday, September 3, 2015 at 10:46:49 AM UTC-4, Niphlod wrote:
>>
>>
>>
>> On Thursday, September 3, 2015 at 7:22:52 AM UTC+2, Carlos Cesar
>> Caballero wrote:
>>>
>>> Hi Niphlod, many thanks for your suggestions, The main problem with
>>> web2pyslices.com is that I can't publish anything and I don't know why,
>>> I mentioned this in other threads.
>>> About the default value in argument, I can change it, but why you prefer
>>> default to None?
>>>
>>
>> It'll be easier to read.
>> For web2pyslices.com let's wait for @spametki to chime in...
>>
>>
>

-- 
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: Plugins Error

[Alan Etkin]

El martes, 12 de mayo de 2015, 14:07:54 (UTC-3), xmarx escribió:
>
> hi!
>
> when i click from design page (
> http://127.0.0.1:8000/admin/default/design/examples) "download plugins 
> from repository" button, i get an error like this:
>
>
With what version? 

Maybe the admin app can't get the list of packages and the error is not 
catched. Mind that there is an issue about web2pyslices site domain
 

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

[Alan Etkin]

> zvolsky also.
>
> On Monday, May 11, 2015 at 10:43:25 AM UTC-7, Derek wrote:
>>
>> Looks okay, needs to be pruned though as I see mirek posted a bunch of 
>> nonsense there.
>>
>
Done

-- 
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: web2pyslices down

[Alan Etkin]

>
> Web2pysplices.com is on sale
>

Cool! And what about web2pyslices.com, is it on sale also?

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

[Alan Etkin]

I forgot I was the web2pyslices app admin :P

To all users complaining about their articles not being shown on the site, 
please, don't sue me.

BTW: there seem to be some issue about the web2pyslices.com domain, since 
the one that is working is web2pyslices.pythonanywhere.com

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

[web2py] About Leonel's threaded comment example

[Alan Etkin]

Ron's question about the app posted at 
https://groups.google.com/d/msg/web2py/sbgzu1zUAqY/8h1P7-6boSgJ by Leonel

Do you know if its possible to implement this app without using any 
> javascript and nested structure but just applying pymongo freature?
>

Does pymongo provide client-side features? I don't think so. To handle the 
data stored at the database you need client logic. You can avoid coding 
javascript by using only html forms and css.

@Ron

Please, this is the place for asking questions about web2py for free and 
supported by all the users, I don't do web2py consulting for a living, as 
you already know.

-- 
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: Mongodb api reference

[Alan Etkin]

Question: is there an equivalent 
>
> db().select(db.blog.author) in pymongo api? For example if I use the above 
> implementation in pymongo:
>
> db1.blog.author (wouldn’t work). But I can get specific author 
> db1.blog.find({‘author’:’Ron’}) That is also equivalent to:
>
> db(db.blog.author == ‘Ron’).select() #In DAL
>

There cannot be any equivalent since pymongo can't output Rows resultsets 
(web2py objects)
 

> So, there is two way to go about it. I know some of pymongo syntax 
> wouldn't apply to DAL as there are no sql equivalent to it. How is it the 
> other way around?
>

What do you mean by "how is it the other way around"? web2py's DAL and 
pymongo have different purposes

-- 
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] Mongodb api reference

[Alan Etkin]

I'm bringing to the list some new user's questions

It will b nice to document all the DAL syntax n equivalent pymongo api.


Not sure what he meant, but documenting the pymongo api makes little sense 
(it is already documented by the authors). IMO we should instead document 
the way of accessing the adapter connection to use the pymongo api commands 
or any adapter (maybe it is already documented).
 

> N all the DAL doesnt apply to pymongo n added pymongo features.  Just 
> saying:)
>

DAL only uses pymongo features required by the DAL api itself, but there's 
no equivalent command between the lower level api and DAL.

It will b nice to document all the DAL syntax n equivalent pymongo api. N 
> all the DAL doesnt apply to pymongo n added pymongo features.
>

mongodb adapter is not meant to include or extend pymongo api commands, it 
is a high level interface for mongodb databases in web2py apps

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

[Alan Etkin]

I did not check the django app code but if you want to handle embedded json 
objects you should use table definitions with a json field.

Something like
db.define_table("mytable", Field("embeddedobject", "json") # db is a 
mongodb connection (DAL instance)


-- 
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] deploment on an obsolete Debian 5 server

[Alan Etkin]

@Michelle

Looks like the backports does not include python 2.7 (at least with the 
sources I searched so far).

@Simone

> we don't support python 2.5 from some time.. it's possible that "I 
> can't import" is a result of "tried and failed" rather than "didn't find 
> it".
>

When was python 2.5 support dropped? I think I'm going to use a easier 
approach by just installing an older version (I have tried release 2.0.9 
and it starts without errors)

-- 
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] deploment on an obsolete Debian 5 server

[Alan Etkin]

> Alan, if you need to update the interpreter you can look at backports:
> http://backports.debian.org/

Great! I'll check it asap

Thanks all for the 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: deploment on an obsolete Debian 5 server

[Alan Etkin]

> Did you download the source file from the web2py site or github?  If github
> there is this issue to take into account due to pydal being a submodule.

I tried the zipped package from www.web2py.com, I'm quite sure it
ships pydal also

-- 
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] deploment on an obsolete Debian 5 server

[Alan Etkin]

I was testing the last stable source code installation of the framework on 
a debian lenny don't know what else 5.0 server, but if you start it using 
the built-in web server on a terminal it throws a funny error message 
stating it can't find pydal

Has anyone tried to deploy web2py on that kind of server?
Should I use a compiled newer version of python?

The default O.S. interpreter is 2.5

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: Convert MongoDB / dict into a DAL Row

[Alan Etkin]

>
> Row.__str__ is called which in turn calls Row.as_dict, well Row.as_dict 
> does not know how to serialize ObjectId so it just ignores it.
>

I don't recall exactly (perhaps I should check the source), but I think the 
mongodb adapter doesn't support dealing with pure objectid objects for 
database I/O. What it does is always convert from/to long integers because 
objectid objects are mapped to web2py db record ids. So, you should not be 
able to work with objectid instances and DAL unless you only store and 
retrieve id values.

@Francisco: about your question on cache not working with mongo, I wouldn't 
say, maybe there is a bug in the adapter. AFAIK the caching of rows on 
selects should work with mongodb as well.

-- 
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: pymongo is installed but I get this error: no driver available ('pymongo',)

[Alan Etkin]

>
> Does the sys.path looks right to you?
>

It does if the pymongo driver is installed at one of the folders listed. As 
you have described in late posts, you seem to have an issue with directory 
permissions. I belive that running web2py with root permissions can solve 
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: pymongo is installed but I get this error: no driver available ('pymongo',)

[Alan Etkin]

 

> 2) sudo pip   which put all the unzipped pymongo files in the 
> /usr/local/lib/python2.7/dist-packages/ folder with root:staff ownership 
> and everyone  "r" privileges.
>

Odd, this should make the driver available for web2py. For debugging, 
perhaps you can check that the driver folder is included in sys.path when 
web2py runs. Make a simple controller to output sys.path (or else use the 
logging package):

def showpath():
import sys
return str(sys.path)


-- 
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: Upload file to copy.com

[Alan Etkin]

>
> Hi everyone,
>
> Is there a way for a web2py app, instead of uploading a file to the server 
> local file system, to upload a file to a www.copy.com account?
>

You can handle dropbox data from web2py apps instead

http://www.web2py.com/books/default/chapter/29/14/other-recipes?search=dropbox#Dropbox-API

However, you would need custom code to write upload streams to the remote 
storage system

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

[web2py] Re: sqlite <---> postgresql

[Alan Etkin]

> This is even better. No rush here, but just curious if there is any ETA 

> for it? 
>

ETA: uncertain. It is not a trivial change.

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

[web2py] Re: sqlite <---> postgresql

[Alan Etkin]

>
> Hello, 
>
> Do you consider it's safe to work with web2py on localhost machine and 
> use sqlite3 database as storage (which greatly simplifies setup) and 
> then deploy application on the production server by using e.g. 
> PostgreSQL database? 
>

There are some difficulties when you need to migrate data between both 
backends. Currently, if you have a complex model, you have to resort to 
engine specific commands to solve constraint issues like disabling triggers 
and usually you need to reorder model table definitions. In some cases like 
circular references, reordering is not enough, and there's need to manually 
fix the constraints. I've posted a module for web2py shell which automates 
the migration here:

https://groups.google.com/d/msg/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ

But you still need to fix the model definition order so it works with 
postgresql

BTW: there is a work-in-progress modification of dal so the engine 
migration is transparent.

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

[web2py] Re: json error when trying mongo slice

[Alan Etkin]

>
> this kind of entry:
> { u'counter':3, u'now':'2014:05-02 13:00:00' )
>
> the web2py manual shows this kind of entry:
> { 'counter':3, 'now':'2014:05-02 13:00:00' )
>

Currently the json validator accepts only legal json, meaning you have to 
enclose strings in double quotes (altough it automatically escapes special 
characters). This would validate:

{"møøse": "We apologise, we had to sack the møøse also"}

So I think both the book and the recipe need to be updated.

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

Re: [web2py] Re: Email and PGP

[Alan Etkin]

>
> I tried "sudo -u www-data gpg --gen-key", but I got permission denied to 
> access /home/richard/.
>
> I'd try to login as "www-data" but I don't know the password.
>

I don't think there is a password set for www-data. How about this?

sudo -i -u www-data gpg --gen-key

That fixed the permission issue for my system

Otherwise, if you want to login as www-data, you might need to set the user 
password

sudo passwd www-data

And then

sudo login

This is based in Ubuntu 12.04 so for your sytem may change.


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

Re: [web2py] Re: Email and PGP

[Alan Etkin]

>
> I thought about that, but I don't think there's an actual 
> www-data:www-data user on my Linux server by virtue of installing web2py, 
> is there?? How would I login?
>

Some script installations of web2py create the user. You need to know first 
what user is configured to run web2py in the webserver. How did you deploy 
web2py?

In Ubuntu and similar distributions you get the list of users in the system 
with 

cat /etc/passwd

To run a command as another user (i.e. for creating a key):

sudo -u www-data gpg --gen-key

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

Re: [web2py] Re: Email and PGP

[Alan Etkin]

> Something I don't understand...
>
> If I'm sending to myself (my_h...@gmail.com ), isn't my 
> public key the same as the recipient key? It's already in the key-ring.
>

> Do I have to import the public key again using 'gpg'?
>

No. In fact, I tried an auto-send and as you said, there is no need to add 
another key since it is the same as the sender key.

About an earlier post of yours:

> I did create the key files with gpg for sender "my_h...@gmail.com". By 
default, they're created in my home directory, so I moved the 
> .gnupg folder to /home/www-data/ and chown'd it and its contents to 
"www-data:www-data".

> Thinking that it might be a file ownership problem, I chown'd .gnupg and 
everything in it to www-data:www-data, but this gave me the 
> mail.error "GPG error:Invocation of gpgme_op_sign:Unspecified 
source:General error".

Did you try to setup the pgp keys as user www-data? It might be (just a 
guess) that there is a conflict about the system user and the generated 
keys, that is not logged by pyme

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

Re: [web2py] Re: Email and PGP

[Alan Etkin]

>
> Well, given the state of disarray that this matter is in, I'd best cut my 
> losses and abandon PGP email altogether. I can't wait forever for this 
> matter to be resolved/fixed.
>

I have tested the recipe in development and it works. I had to create the 
recipient public key which is not included in the recipe, but after that It 
worked (in in logging mode). I guess this is a production configuration 
issue. Maybe the book should also provide a working example for a standard 
production environment.

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

Re: [web2py] Re: Email and PGP

[Alan Etkin]

 

> ...the for loop is never entered. In other words, c.op_keylist_all(sender, 
> 1) is empty, so c.signers_add(sigkey) is never executed.
>

> Does that help?
>

Not much, but at least we now know that pyme (the python wrapper for the 
pgp library) cannot find any sub-key for sender, where it should.

I'd open an issue at code.google.com/p/web2py with a link to this thread.

BTW: pyme seems to be abandoned, there is an updated fork that is currently 
maintained:

https://bitbucket.org/malb/pyme

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

[web2py] Re: AppEngine NDB Ancestor Query

[Alan Etkin]

>
> I've been trying to find a way to use *ancestor queries 
> *using
>  web2py's db without luck.
>
> I guess the use of ancestors is currently not implemented, is that 
> correct? Are there any patches?
>

Isn't that a GAE specific feature? How one would port that to another 
database (for example sqlite)?

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

[web2py] Re: Export issues

[Alan Etkin]

>
> No, same behavior with web2py 2.5.1-stable
>

Then I think it should be fixed in trunk. Can you file an issue?

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

[web2py] Re: Export issues

[Alan Etkin]

>
> Hi all,
>
> I downloaded web2py from trunk on Jan 29th and I found some issues with 
> export.
>

Did you have a consistent output on earlier versions?

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

[web2py] Re: move from sqlite to postgres using cpdb.py failed

[Alan Etkin]

> I have been trying to move from sqlite to postgres without any success.
>

cpdb is not the one size fits-all solution for every problem when copying 
data between databases. Currently, there is an issue about reading table 
definitions which, unless I'm mistaken, makes almost impossible to transfer 
data between sqlite and postgresql for models beyond a simple case

http://code.google.com/p/web2py/issues/detail?id=1799&can=5

I agree that cpdb needs better documentation and also some enhancements. 
For example, I belive it does not run models, and it would simplify the 
migration.

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

[web2py] Re: Email and PGP

[Alan Etkin]

 

>  - The key was found but the can_sign property is set to False
>
> but I can't find how to set it... :(
>

You mean the o.s. command to enable signing? (wathever it is)? What if one 
forces the test to True at tools.py (so the key entry is added)? The 
problem about pyme is the lack of documentation IMO.

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

[web2py] Re: Email and PGP

[Alan Etkin]

>
> Okay, looks like nobody can help me. I guess not that many people use PGP 
> email from web2py. Probably because it's so gnarly.
>

Apparently, you get that error message because one of this reasons:

- A search for the signing key returned a void set
- The key was found but the can_sign property is set to False

If you want, you can debug the error checking the output in gluon/tools.py 
around line 496.

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

[web2py] Re: Selects as_trees

[Alan Etkin]

>
> I am looking for a way to expand all referenced fields and have read about 
> the as_trees() method for selecting rows. I do not quite understand the 
> parent field requirement, but say we have the following 
> tables/relationships, was looking for a nested dict output which could be 
> JSONified as follows:
>

I guess that the as_trees method will not make a tree with everything. It 
seems to work only with self referenced tables with a parent and children 
reference and list:reference fields.

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

Re: [web2py] Re: Wiki.auth 401 error

[Alan Etkin]

>
>  Any chance for steps on how to do that ? (For us that are new o web2py)
>

- Start the rocket built-in server (see the manual for instructions for 
windows)
- Open the admin app and authenticate
- Go to the app base address at http://localhost:8000/ and 
register

web2py should now have created a wiki_editor and assigned the new user to 
the editor group. If not:

- Go to http://localhost:8000//appadmin
- Click in the auth_group table (it opens a view of the table)
- Check that there is a group named wiki_editor, otherwise create it (by 
clicking in the new record button)
- Go to appadmin again and open the auth_membership view
- Create a membership record that links the wiki_editor group and your 
auth_user id

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

[web2py] Re: Cassandra and web2py

[Alan Etkin]

The DAL does not have a Cassandra adapter, so you'll have to use an 
> external Python driver (e.g., https://github.com/datastax/python-driver).
>

Or code your own adapter (and perhaps share it)

http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Note-on-new-DAL-and-adapters

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

[web2py] Re: move from sqlite to postgres using cpdb.py failed

[Alan Etkin]

> I have check sql.tmp - it contains only 'END'. After adding the print line 
> I have got following message, with no tables([]):
>

Have you run the app connecting to sqlite once? You must do it so web2py 
automatically creates the table files. cpdb reads those files from the 
database folder to build the table definitions. There is no data to copy 
since the script does not find the tables (it should log a message about 
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/groups/opt_out.

[web2py] Re: move from sqlite to postgres using cpdb.py failed

[Alan Etkin]

>
> try:
>   import pyreadline as readline
> except ImportError:
>   import readline
>

It seems this win problem should be posted at 
http://code.google.com/p/web2py/issues
 

>
> 2)I have created brand new db in postgres.
>
> 3)I have tried to copy data from 1 db to another by following cmd:
> c:\Users\power\PycharmProjects\test_test\web2py>python scripts/cpdb.py  -d 
> gluon
>  -f applications/app/databases -y sqlite://dbs.sqlite -Y 
> postgres://postgres:avh
> 1981@localhost/idna_dbs1 -t False
>
> 4)It gave me following results:
>
> gluon path not found
> creating tables...
> exporting data...
> importing data...
> done!
> Attention: do not run this program again or you end up with duplicate 
> records
>
> 5)But I have got nothing in my postgresql db!
>

There should be a sql.tmp file somewhere used for copying the data between 
databases (maybe at the command working directory). You can check that to 
verify the script is writing the input values. Also check that the script 
is retrieving the app model correctly, i.e., adding the following command 
in cpdb.py after line 537:

print other_db.tables

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

[web2py] Re: web2py slices plugins: thumbnail images

[Alan Etkin]

 
>
> Too bad that many of the growing collection of plugins don't have a 
> thumbnail image :(
>

Agree. Maybe the book note can improve the feature's user feedback. BTW: 
the current layout is not too pretty. Any help about coding a better view 
is welcome.

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

[web2py] Re: simplejson and datetime

[Alan Etkin]

> What I am interested in doing, is have it turned back into a datetime 
> object when 'decoding' - and THAT is not supported even in the web2py 
> flavor - and I haven't found a single simple solution for it on the web for 
> the standard simplejson either.
>

It seems the only way of decoding iso dates as datetime is passing a 
function to object_hook. I don't think there is a faster way of doing that, 
since you'll have to instantiate each datetime object again anyway, AFAIK.

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

[web2py] Re: Variables from url

[Alan Etkin]

> Hi,
> I have a question:
>
> For example, somebody opens this page:
> .../profile/1
>
> Now, in the def profile(): there shall be a variable:
>
> a=1
>
> Or, when this page gets opened:
> .../profile/12345
>
> I wish this variable:
> a=12345
>
This is discussed in detail in the web2py book:

http://www.web2py.com/books/default/chapter/29/04/the-core#Dispatching

Just an example:

if the url has this form

//.../

Your action logic (i.e. a function defined at the controller file) could 
retrieve it this way:

value_1 = request.args(0)
...
value_n = request.args(n)


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

[web2py] Re: Adding a second page to pypdf Template

[Alan Etkin]

>
> Whenever i try to add a second page like this:
>

> I get this error:
>
> (FPDF error: Unsupported image type: )
>
>
Can you post the traceback if any? Try adding a blank cell before the 
second add_page call.

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

[web2py] Re: Web2py License

[Alan Etkin]

>
> We are in an opensource shy team that is very concerned about licensing.  
> I see that the Web2py license is LGPL3, but does Web2py carry any other 
> license implications such as GPL, GPL2 in it's parts?
>
 
Given that there is contributed code included with the default package, and 
they have their own license. AFAIK, the note added to the framework license 
does not specify the terms about contributed code:

(web2py/LICENCE)
### On Commercial Redistribution

In accordance with LGPL you may:
- redistribute web2py with your apps (including official web2py binary 
versions)
- release your applications which use official web2py libraries under any 
license you wish
But you must:
- make clear in the documentation that your application uses web2py
- release any modification of the web2py libraries under the LGPLv3 license

I think that the second point about the "... official libraries..." would 
allow to include the framework package into a project package with 
different license, (in case that is what you are asking) as long as there 
is no conflict between them.

There are previous threads about this subject, so perhaps you want to 
search for them in the mail list for better documentation.

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

[web2py] Re: pygraphviz library not found

[Alan Etkin]

> When navigating to the Edit -> Graph Model on any web2py app, I get the 
> error "pygraphviz library not found".
>

Can you import the library from an interactive session?
Maybe you have a path issue, i.e., you are using the built-in python 
interpreter of a compiled web2py installation without access to the system 
python path

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

[web2py] Re: custom one-to-many left-join python object and json object

[Alan Etkin]

>
> Hey,
> I have a simple one-to-many relation, between questions and answers. Each 
> question may have 0 or more answers, so any *db.answer.question* refers 
> to a certain *db.question.id *.
>
> Now, in order to create a code for efficiently displaying the questions 
> and their belonging answers, I wonder: how to make the sql query, and how 
> to generate the json object of the question and answer data?
>

Have you tried this?

>>> data = db().select().as_json()

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

[web2py] Re: How to use a bootstrap button group as radio buttons in a custom form

[Alan Etkin]

>
> Thanks Alan - I'm still trying to get the intended result: Bootstrap 
> buttons that function like radio buttons.  I studied fields being brought 
> in as normal radios
>

Have you tried setting name="opt" for this input instead (leaving the 
options with their original attributes)?




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

[web2py] Re: request.uri_language

[Alan Etkin]

 
>
> I've got this server error:
> 200 Error
>

My bad, unless you have specified the name or it is available in that 
scope, using app, test or whatever would raise a NameError. Perhaps it can 
be solved using a string ("test") for the dictionary key.

routers = {
"test": dict(

default_language = possible_languages['default'][0],
...


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

[web2py] Re: request.uri_language

[Alan Etkin]

>
> Is it possible that nobody knows how this request.uri.language works ?
>

Shouldn't this

app: dict(

be this way instead?

test: dict(
 

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

 

> I gues my question is, can users safely rely on _ methods? 
>

The change revert is due this concern about api reliability, so adapters 
behave as specified in

http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=_insert#Raw-SQL

What is w2p's "policy" regarding underscore-prefixed functions.
> Are they considered private?
>

Underscore is required in some cases for example to avoid name collisions. 
I suppose that the policy about the use of underscore follows the pep8 
style guide except for special cases described in the book. For example 
(chapter 4):

Functions that take arguments or start with a double underscore are not 
> publicly exposed and can only be called by other functions.


So can I use the above function as it is?
>

I think so 

> What do you mean by  "temporarily"?
> Could the feature be implemented in the future with a different name?

It could, If there's agreement about adding it to the adapter.

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

[web2py] Re: Get label of field

[Alan Etkin]

 

> My doubt is, how i get the labels of specific field, or a group of fields, 
> or all fields?
>

>>> table, field = col.split(".")
>>> db[table][field].label


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

[web2py] Re: How to add users to a table row by request

[Alan Etkin]

There is a built-in feature for RBAC (Auth). Check the book

http://www.web2py.com/books/default/chapter/29/09/access-control#Access-Control

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

[web2py] Re: How to use a bootstrap button group as radio buttons in a custom form

[Alan Etkin]

>
> hoping someone can point me in the right direction, as the post title says 
> I want to use a btn-group
>

Try using name="opt" for the input element. However, it would be better to 
use a custom widget.

http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#Widgets

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

> Sorry for the confussion..
> But it works fine. I will definitally use this.
>
> (I posted something stupid and removed the stupid post but left some 
> traces. ;-))
>

Well there are good reasons not to add the feature, at least with the 
current name:

https://groups.google.com/d/msg/web2py-developers/bN0WS9_skzw/NJq4bs5M8KIJ

Sorry; however, you could temporarily implement a similar method by 
subclassing GoogleDatastoreAdapter so it pre-processes data without 
applying changes.

http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Note-on-new-DAL-and-adapters

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

[web2py] Re: Wiki.auth 401 error

[Alan Etkin]

>
> Pretty much give up on this, the wiki looked very promising when i first 
> tried it, seems to be dead now,
>

Still unable to reproduce the issue with Version 
2.8.2-stable+timestamp.2014.01.09.11.46.01 in development.

Mind that you must have permission to create wikis. Check that there is a 
wiki_editor or wiki_author membership in the app database applied to your 
user. Also check that when creating the app in development, you have access 
to the admin app, otherwise the automatic permission creation can fail.

If you think this is an environment specific problem, file an issue at 
http://code.google.com/p/web2py and we'll try to fix it asap.

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

[web2py] Re: !! NEW ADMIN !!

[Alan Etkin]

>
> You can clone the repo
>
> git clone https://github.com/pyner/admin_plus.git
>

Or use this

https://github.com/pyner/admin_plus/blob/master/web2py.plugin.admin_plus.w2p?raw=true

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

[web2py] Re: DAL auth_user usage problem

[Alan Etkin]

>
>
> AttributeError: 'Table' object has no attribute '('username', '')'
>

There's an now closed issue that is possibly related to this

http://code.google.com/p/web2py/issues/detail?id=1849

On what version did you 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/groups/opt_out.

[web2py] Re: !! NEW ADMIN !!

[Alan Etkin]

El lunes, 6 de enero de 2014 18:19:54 UTC-3, samuel bonill escribió:
>
> Admin Plus(A-Plus) is a web2py plugin that provides an easy-to-use 
> interface for managing your data
>

Wait, isn't this a similar project than this another?

https://groups.google.com/d/msg/web2py/9ajKQChEmHQ/lNzHUqTKaa8J

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

> But it works fine. I will definitally use this.

Ok. If you can, it would be useful if you could share your tests about 
supported features for records lacking id values and any issue you find 
with setters and getters using key names. Note that the Rows class supports 
defining objects using dictionaries to construct them. Finally, I belive a 
plugin to extended DAL class so it provides retrieving and setting records 
by key name would be also useful.

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

> Works great! 

>
> On Thursday, January 9, 2014 7:21:45 PM UTC+1, Quint wrote: 
> Excellent! 
>
>
> I already included it to try it out but how do i use it?


Your message is confusing, does it work or it does not? It worked for my 
environment (recent release of gae sdk and development server)

Specifically, what worked was:

>>> myvalues = db._insert(k=v, ...)
{k: }

Where db is a google app engine connection (DAL instance)

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

>
> How about adding support in dal.py for the following:
>
> # processes the field input and add defaults, computes, etc. (does not 
> make actual insertion).
> >>> values = db._insert(spam="alot", ...)
> {"spam": "alot", ...}
>

I made a pr about supporting _insert for processing values without applying 
changes to the database as proposed in the previous post

https://github.com/web2py/web2py/pull/341


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

[web2py] Re: Hi there Web2ppy noob here

[Alan Etkin]

>
> form = SQLFORM.factory(
> Field('meter_num',requires=IS_IN_DB(db,db.meter)),
> Field('meter_type',requires=IS_IN_DB(db,db.meter)),
> Field('dept_id',requires=IS_IN_DB(db,db.dept.id,'%(dept_id)s'))
>

You have missed the closing parenthesis for the .factory method.

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

[web2py] Re: Learning Management System survey

[Alan Etkin]

>
> Any news on progress?
>

Check Pyodel

http://code.google.com/p/pyodel

There's a working prototype available and an online demo at 
http://pyodel.appspot.com

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

[web2py] Re: Wiki.auth 401 error

[Alan Etkin]

>
> Jim and Alan, 
>
> I have the exact same problem, and exact same error.  my setup is simple: 
> using the latest "web2py_win" (as of December 2013) and followed the book 
> "web2py_manual_5th".  The instructions in section 3.5 will guide you to use 
> the built in wiki, and if you follow these instructions you will get the 
> same error mentioned here.
>

Could you try the example with trunk, i.e. the latest repo source code 
version? This way we can confirm it was "fixed" (or better, cannot be 
reproduced) in future versions. As of now, I cannot test the book howto 
with a win machine. Perhaps this is just reproducible with windows.

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

[web2py] Re: Multiple Uploads using jQuery-File-Upload: Javascript/CSS Conflict?

[Alan Etkin]

>
> I'm trying to use 
> jQuery-File-Uploadto implement 
> multiple file uploads.  I'm using this 
> tutorial
>  as 
> well as this sample app 
> HERE. 
>  
>

I made a multiple upload demo for storing imap drafts here (using 
SQLFORM.factory and form customization)

http://www.web2pyslices.com/slice/show/1706/how-to-compose-a-multi-attachment-draftnormal-email-with-imapsmtp

I suppose it is possible to use it for any other app modifying the 
controller so it stores or processes the input however needed.

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

How about adding support in dal.py for the following:

# processes the field input and add defaults, computes, etc. (does not make 
actual insertion).
>>> values = db._insert(spam="alot", ...)
{"spam": "alot", ...}

So one can use the output for storing named keys (with app specific logic 
or maybe plugin for extended datastore functions).

AFAIK, the patch is trivial (it would need adding a _insert adapter method 
like the case of mongodb or imap)

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

[web2py] Re: GAE: defaults on "_tableobj"

[Alan Etkin]

> About using appengine property default values, the patch sets defaults for 
> entity creation but I think that this would bypass the DAL interface,
>

I did not take in account that the patch just copies defaults, my bad. So I 
don't think the feature affects any previous implementation or leads to 
unexpected behavior, since it just passes model data to the backend 
configuration. However, a possible problem is when modifying field defaults 
after table creation, further changes would not be updated in _tableobj.

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

[web2py] Re: GAE: defaults on "_tableobj"

[Alan Etkin]

 

> by using it's  _tableobj I meant.. and then use GAE api
>

About using appengine property default values, the patch sets defaults for 
entity creation but I think that this would bypass the DAL interface, which 
uses it's own logic for setting default values. This could lead to web2py 
apps behaving unexpectedly when executing gae database commands due to 
parallel/concurrent ways of settings defaults.

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

>
> Compatible with what?
>

With any web2py feature expecting entity keys (web2py records) with integer 
ids.

But you would know that you don't need those functionalities if you would 
> decide to use a key_name
>

I think this is usually called a "corner case". I would't add the feature 
for the purpose for storing entities by name since it does not require much 
coding to implement it per-application using the gae api.

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

> But does that mean you should not allow it to be inserted that way?
> Nothing restricts users from operating (using web2py api) on rows 
inserted with GAE api

There's no restriction on the use of the datastore, since it is not a 
service reserved for web2py apps, although I belive storing records without 
id assignment would be restrictive for apps (and I doubt it will be 
actually compatible at all, with the exception of the keyed tables 
mentioned before, in case it is supported).

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

[web2py] Re: GAE: defaults on "_tableobj"

[Alan Etkin]

> (For instance when I want to supply a "key_name" when I put() an entity 
so I can have better performance to get() that entity from db.
> Or when I want to use put_multi())

put_multi is supported by DAL trough the bulk_insert method. How better is 
performance when using named keys? Do you have benchmarks?. Also, is the 
use of named keys supported by DAL? I think it is not: 

https://groups.google.com/d/msg/web2py/lFKiIGary0c/_sx0EoJkYk0J

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

[web2py] Re: GAE: insert using "key_name"

[Alan Etkin]

> I would like to be able to do this using web2py. I could also choose to 
> use the GAE API directly to do this but then a could not make use thing 
> like calculated Fields etc in my web2py tables.
>

One issue about forcing key names is that there's no guarantee that the new 
key will provide a valid ID integer when retrieved, and the DAL api 
requires record insertions to provide that kind of value. Note that calls 
to Key.id() can return None, which is used by the insert method to create 
the db reference object. IIRC, the exception of that rule is the case of 
keyed tables, but I'm not if it is supported for gae nosql. In case it is 
supported, the patch could instead use keyed tables for storing entity key 
names.

>From the datastore Python api:

"... The identifier may be either a *key name* string, assigned explicitly 
by the application when the instance is created, or an integer *numeric 
ID,*assigned automatically by App Engine when the instance is written (
put)
 
to the Datastore ..."

I have not tested the behavior but according to the above I think that the 
datastore api would return None instead of valid integer identifiers for 
the case of entities stored with manual key names.

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

[web2py] Re: intercept closing session

[Alan Etkin]

El martes, 7 de enero de 2014 14:40:38 UTC-3, Giuseppe D'Amico escribió:
>
> Hi, I am new with web2py, is there a way to intercept  the closing of a 
> session?
>

You mean you want to catch a user logout from the scaffolding app?

You could modify the user action at controllers.py so it checks wether the 
"logout" action was asked:

def user():
if request.args[0] == "logout":


There's also the auth.settings.logout_onlogout which can be a function that 
receives auth.user as argument (undocumented) and auth.settings.logout_next 
(a URL for redirection after logout).

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

Re: [web2py] Re: !! NEW ADMIN !!

[Alan Etkin]

>
> You can Contribute in many ways:
>

Consider posting this to the plugins list in web2pyslices, adding a link to 
the installer (.w2p file) so it can be installed directly from admin.

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

[web2py] Re: cpdb from sqlite to postgresql

[Alan Etkin]

>
> The result is an error message:
>>
>> EXCEPTION: could not make a copy of the database
>> Failure to connect, tried 5 times:
>> Traceback (most recent call last):
>>   File "gluon/dal.py", line 7766, in __init__
>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>   File "gluon/dal.py", line 2756, in __init__
>> if do_connect: self.find_driver(adapter_args,uri)
>>   File "gluon/dal.py", line 795, in find_driver
>> raise RuntimeError("no driver available %s" % str(self.drivers))
>> RuntimeError: no driver available ('psycopg2', 'pg8000')
>>
>
It seems that dal.py cannot import the drivers. Do you see any driver not 
found error log when you run the script? Also, can you import the driver 
with an interactive session?

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

Re: [web2py] Re: Unable to send email on server in web2py.....

[Alan Etkin]

El lunes, 6 de enero de 2014 12:26:48 UTC-3, Akash Agrawall escribió:
>
> Still same error. it's too urgent for me 
>

It appears gmail is using some sort of smtp service lock for your 
application account:

http://designoservices.com/smtp-error-534-5-7-14-54-sending-mail-through-cake-or-php-using-gmail-account/
http://stackoverflow.com/questions/17462380/server-send-emails-using-gmail-smtp-gets-alerts
http://webapps.stackexchange.com/questions/44768/limitations-on-sending-email-through-gmail-smtp

According to the first post, it is resolved by just "... logging into your 
gmail and verifying its identity ..."

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

[web2py] Re: Unable to send email on server in web2py.....

[Alan Etkin]

>
> Sorry for late reply man. I checked the same no luck in that... !! 
> :(
>

Please post the output of mail.result and mail.error after the call to 
.send() 

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

[web2py] Re: Unable to send email on server in web2py.....

[Alan Etkin]

>
> Hie folks.. I know this question is already been asked but I didn't get 
> any help from those answers. please hava look at this 
> I am unable to send email in server(to be specific webfaction.com) ...
> but it's running fine on local host
>

Have you checked this thread?

https://groups.google.com/d/msg/web2py/riP3IpRWYMA/rWFQnO7-9pgJ

Here is how you configure the mail object (web2py book):
http://www.web2py.com/books/default/chapter/29/08/emails-and-sms#Setting-up-email

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

Re: [web2py] Re: OT: movuca internal error on comment

[Alan Etkin]

> anyway I found that in spite of the error I got yesterday the comment has 
been already posted.

Ok, this is because the comment is commited before the buggy notification 
feature starts :P.

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

[web2py] Re: OT: movuca internal error on comment

[Alan Etkin]

 

> that's what I get trying to add a comment to a post of mine.
>>
>
Manuele, can you please try to add the comment now?
 

>
>> Sorry but I didn't find a contact form on web2pyslices site.
>>
>
We should add at least a link to this list for posting issues.

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

[web2py] Re: limit the application for client user

[Alan Etkin]

>
> hi,
>
> is it possible to limit the application for client user? something 
> identical with trial version for client user, so the user can try the 
> application, test and use it for several time (1 month for example) or base 
> on table record (limit to 10/100 record per table).
> if possible what is the best way to achieve it using web2py way?
>

How about a demo table like

db.define_table("demo", Field("user_id", "reference auth_user", 
default=auth.user_id),
Field("expires", "date"),
Field("usage", "json"),
Field("status", 
requires=IS_IN_SET(("expired", "active"

Then upon registration, compute a predefined expiration date and set a JSON 
object for storing table usage and other metrics. On each request, you'd 
need to

- retrieve or create the user demo record
- compute any db i/o, check for usage limits and store as json
- check if deadline was reached

Not sure if this is the most efficient way, specially abuout the usage 
storage as json, but that way you can dinamically modify your usage metrics 
more easily. I think that storing usage as yaml/json files can improve 
performance.

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

[web2py] Re: Using Modules Class - AttributeError: 'Engine' object has no attribute 'form'

[Alan Etkin]

>
> I'm testing using Classes within my Modules to handle a lot of the heavy 
> lifting.  I can't figure out what i'm doing wrong here.  I need an adult.
>
 

>  def __init__(self):
> self.request = current.request
> def form(self):
>

Your Engine class has a form function defined within the constructor block, 
so you ought to de-dent your function so it becomes a class method to use 
that syntax.

class Engine(object):
def __init__(self):
...
def form(self):
...


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

[web2py] web2pyslices old notifications

[Alan Etkin]

If you have an account at web2pyslices, you'll probably start receiving old 
notifications from the site about comments, articles, etc. This is due to a 
bug in the model recently discovered which was preventing the automated 
notification service to send those mails.

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

[web2py] Re: Can somebody help me to integrate Web2Py on Hostagtor?

[Alan Etkin]

>
> I'm having my first steps on web2py and python and would really benefit 
> from a "dummy" tutorial...
>

Check this posts

http://www.web2pyslices.com/slice/show/1567/running-web2py-on-hostgator-shared-host
https://groups.google.com/d/msg/web2py/HvKqgkatK1E/0mFjGUYPjLYJ

However, deployment recipes should be different for shared hosting and vps 
plans.

Also I'd suggest to do a search in this forum using "hostgator" as search 
key.

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

Re: [web2py] Re: MongoDb

[Alan Etkin]

> Thanks for the answer. Luckily there are no joins, but I need to see what 
> web2py features of DAL won't work.
>

To my knowledge, you cannot use the scheduler or Auth.accessible_query, 
everything else not requiring join queries should work.

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

[web2py] Re: MongoDb

[Alan Etkin]

>
> I have an app running on MySQL , I want to use mongoDB instead. 
> I want to help on migration from mysql to mongoDB.
> Thanks,
>

Beware that mongodb adapter is in an experimental stage of development, so 
you should know what you are doing before migrating. I suppose there are 
lots of howtos for migrating data between those backends. The web2py way of 
doing has two options, AFAIK:

- use cpdb (never tried it with those connections)
- use DAL.import_from_csv_file and DAL.export_from_csv_file methods (for a 
small amount of db records)

Mind that the most important issue is that mongodb is not a relational 
database management system and there's no such thing as JOIN queries. This 
is a limitation for web2py also, since some of the web2py features require 
joins to work.

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

[web2py] Re: Firefox 26.0 and redirect after login

[Alan Etkin]

 
>
> I tested these functions in Safari, in Safari everything works as before.
> Does anyone have an idea what changed in Firefox and how to solve this 
> issue?
>

Does it actually redirect (does it open the new location)? You can check 
the response output with the firefox console (Ctrl+Shift+K)

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

[web2py] Re: unpickling stack underflow

[Alan Etkin]

> HELP PLEASE!
>
>
Could you post the relevant part of code that throws the error? What 
version of web2py are you running? 

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

[web2py] Re: I don't want 'Login Successful' or 'Success' popping up on the screen in my app.

[Alan Etkin]

>
> How do I keep session.flash and response.flash from doing their things 
> when I don't want to? Specifically I don't want the messages popping up 
> after a user logs in or when they make a new entry to the DB.
>

For processing forms, you can disable the message_ option in 
.process()

http://www.web2py.com/books/default/chapter/29/07/forms-and-validators?search=success#The-process-and-validate-methods

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

[web2py] Re: Calendar widget in a custom form?

[Alan Etkin]

>
> After adding some input validation I've realized that the calendar widget 
> is not popping up. Is there anything I need to add to the controller or 
> elsewhere?
>

I suspect there's no widget option for the INPUT objects, unless it was 
added and was not updated in examples:

http://www.web2py.com/examples/static/epydoc/gluon.html.INPUT-class.html

However, for a similar effect, you can use a customized SQLFORM object

http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM
http://www.web2py.com/books/default/chapter/29/07/forms-and-validators#Custom-forms

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

[web2py] Re: web2py on heroku getting "InternalError: current transaction is aborted..." Ticket

[Alan Etkin]

>
> 2013-12-28T05:17:30.576667+00:00 app[web.1]: ProgrammingError: relation 
> "web2py_filesystem" does not exist
>
> 2013-12-28T05:17:30.576667+00:00 app[web.1]: LINE 1: SELECT path FROM 
> web2py_filesystem WHERE path='applications/...
>
> 2013-12-28T05:17:30.576667+00:00 app[web.1]:   
>

Check this issues:

https://code.google.com/p/web2py/issues/detail?id=1602
https://code.google.com/p/web2py/issues/detail?id=1625

It seems that the driver is throwing something not expected by 
isProgramming... or isOperational, otherwise the error should be logged but 
would not stop execution.
 

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

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

[Alan Etkin]

>
> This error is produced when the controller files execute a query string, 
> example db(db.usr).select() or db(db.usr).count(). It does not always occur 
> but frequently occur!
>

Have you checked /databases/sql.log?

Maybe you can post the last commands stored for debugging.

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

[web2py] Re: error ('', 'SQL_INVALID_HANDLE') when DAL is mssq

[Alan Etkin]

>
> In web2py, if I use db = DAL('mssql://...), the error  'gluon.contrib.pypyodbc.ProgrammingError'> ('', '*SQL_INVALID_HANDLE*') 
> frequently occurs.
>

Can you please be more specific? What is the source code in you application 
producing the error?

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

[web2py] Re: building model at run-time?

[Alan Etkin]

>
> ... On the other end, if you have 20-30 tables is pretty easy to "learn" 
> the syntax and define tables with migrate=False that will avoid creating 
> those tables (because they exist already in your backend) and use those 
> definitions in DAL.
>

And for automatically build the model from the legacy db, you can try using 
one of the extract_ scripts that ship with the installation in 
web2py/scripts/

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

[web2py] Re: Wiki.auth 401 error

[Alan Etkin]

>
> Hi Alan, it's 2.8.2
>

I think we need to see the source; I tried to reproduce it, but couldn't.

My system environment:
2.8.2-stable+timestamp.2013.12.20.15.08.47
(Running on Rocket 1.2.6, Python 2.7.3)

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

[web2py] Re: Problem w/ cpdb.py script

[Alan Etkin]

>
> Note that, when I tried to use the script to copy to a MySQL DB on 
> pythonanywhere, I got a 150 error, that it couldn't create an auth table, 
> and  this may be related to foreign keys as well.
>

Note that there is another issue about cpdb (actually about the DAL class 
constructor and the table creation order), check that this not the same.

https://code.google.com/p/web2py/issues/detail?id=1799&start=100

Some backends allow to disable constraint checks (i.e. postgresql), maybe 
you can try issuing a command to disable them with executesql before the 
inserts (editing the script)

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

[web2py] Re: Wiki.auth 401 error

[Alan Etkin]

> This used to work, activate the built in wiki, then register, log in and I 
> got the wiki available. Now when I try to make a new wiki I get 401 even 
> though it lets me log on.
>

With what version?

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

[web2py] Re: Wordpress model file

[Alan Etkin]

>
> I have several projects in my work, that require handling wordpress. As I 
> hate doing stuff in PHP, and DAL is my prefered tool for a lot of my work, 
> I've created a model file of wordpress. I hope you'll find it useful, and 
> I'd love to hear your feedback
>

It must be because I've never used wordpress, but, what is the purpose of 
the model file. How do you use such model?

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

[web2py] Admin app support in app engine

[Alan Etkin]

A subset of the admin app features was enabled in trunk for Google App 
Engine apps. New deployments using the app.yaml example file should support 
the following (using GAE SDK 1.8.8 and Python 2.7/WSGI):

- Error ticket storage and browser (with datastore connections)
- Web shell
- File viewer

For sql databases, a connection should be specified as described in 
http://www.web2py.com/books/default/chapter/29/13/deployment-recipes?search=ticket_storage.txt#Collecting-tickets

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

[web2py] Re: error using auth.wiki('slug') on service pages

[Alan Etkin]

El jueves, 19 de diciembre de 2013 07:54:34 UTC-3, Janko Strusa escribió:
>
> Ok, I have reported the issue.
>

force_render is being ignored in actions that involve service pages. If you 
want to combine them with document content, a workaround is having the wiki 
create the tables in the model or controller with

auth.wiki(resolve=False)



And then, to show a doc, you can do (in a view)

{{=MARKMIN(db(db.wiki_page.slug=="sidebar").select().first().body)}}



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

[web2py] Re: error using auth.wiki('slug') on service pages

[Alan Etkin]

>
>  I've tried {{=auth.wiki(slug="test", force_render=True)["content"]}}. I 
> get error ticket.
>

Would you please file an issue at web2py.googlecode.com? If possible, post 
as much info as possible, including the relevant source code used in the 
model, controller and view.

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