[web2py] Re: Mongo list type field update
> 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
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 <spame...@gmail.com>: > 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" <abasta...@gmail.com> 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
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: web2pyslicesgate
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: Plugins Error
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: web2pyslices down
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] About Leonel's threaded comment example
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] web2pyslicesgate
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] Mongodb api reference
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: Mongodb api reference
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] Re: web2py-mongodb-engine
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
@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.
[web2py] deploment on an obsolete Debian 5 server
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.
Re: [web2py] deploment on an obsolete Debian 5 server
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
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] Re: Convert MongoDB / dict into a DAL Row
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',)
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',)
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: json error when trying mongo slice
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.
[web2py] Re: sqlite --- postgresql
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: sqlite --- postgresql
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: Upload file to copy.com
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.
Re: [web2py] Re: Email and PGP
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
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
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
Something I don't understand... If I'm sending to myself (my_h...@gmail.com javascript:), 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.
[web2py] Re: Export issues
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: Export issues
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: AppEngine NDB Ancestor Query
I've been trying to find a way to use *ancestor queries https://developers.google.com/appengine/docs/python/ndb/queries#ancestor*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.
Re: [web2py] Re: Email and PGP
...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: Email and PGP
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: Email and PGP
- 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: move from sqlite to postgres using cpdb.py failed
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=1799can=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.
Re: [web2py] Re: Wiki.auth 401 error
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/app name 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/app name/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: Selects as_trees
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.
[web2py] Re: move from sqlite to postgres using cpdb.py failed
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: Cassandra and web2py
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
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\web2pypython 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
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: Adding a second page to pypdf Template
Whenever i try to add a second page like this: I get this error: type 'exceptions.RuntimeError'(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: Variables from url
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 base address/app/controller/action/value 0/value 1/.../value n 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: simplejson and datetime
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: Web2py License
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
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
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 http://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(query).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
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)? input type=hidden name=opt value=new_game / -- 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
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: How to add users to a table row by request
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: Get label of field
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 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: GAE: insert using key_name
I gues my question is, can users safely rely on _something 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: request.uri_language
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: request.uri_language
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: Wiki.auth 401 error
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: GAE: insert using key_name
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: !! NEW ADMIN !!
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: DAL auth_user usage problem
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 !!
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: Learning Management System survey
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: Hi there Web2ppy noob here
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: GAE: insert using key_name
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: GAE: insert using key_name
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: processed value} 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
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
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 ( puthttps://developers.google.com/appengine/docs/python/datastore/modelclass#Model_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: GAE: defaults on _tableobj
(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
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: insert using key_name
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: defaults on _tableobj
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: defaults on _tableobj
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: insert using key_name
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: Multiple Uploads using jQuery-File-Upload: Javascript/CSS Conflict?
I'm trying to use jQuery-File-Uploadhttp://blueimp.github.io/jQuery-File-Upload/to implement multiple file uploads. I'm using this tutorialhttp://in10min.blogspot.com/2013/04/web2py-implement-multiple-files-upload.html as well as this sample app HEREhttps://bitbucket.org/xavrenard/multiupload_module/src. 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: Wiki.auth 401 error
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.
Re: [web2py] Re: !! NEW ADMIN !!
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: intercept closing session
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: do something 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: Unable to send email on server in web2py.....
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: cpdb from sqlite to postgresql
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.
[web2py] Re: Unable to send email on server in web2py.....
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.....
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.
[web2py] Re: OT: movuca internal error on comment
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.
Re: [web2py] Re: OT: movuca internal error on comment
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: Using Modules Class - AttributeError: 'Engine' object has no attribute 'form'
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] Re: limit the application for client user
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: Can somebody help me to integrate Web2Py on Hostagtor?
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.
[web2py] web2pyslices old notifications
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: Calendar widget in a custom form?
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: I don't want 'Login Successful' or 'Success' popping up on the screen in my app.
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_something 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: unpickling stack underflow
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: Firefox 26.0 and redirect after login
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: MongoDb
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.
Re: [web2py] Re: MongoDb
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: web2py on heroku getting InternalError: current transaction is aborted... Ticket
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 class 'gluon.contrib.pypyodbc.ProgrammingError' ('', 'SQL_INVALID_HANDLE') when DAL is mssq
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 app/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: building model at run-time?
... 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: error class 'gluon.contrib.pypyodbc.ProgrammingError' ('', 'SQL_INVALID_HANDLE') when DAL is mssq
In web2py, if I use db = DAL('mssql://...), the error class '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: Problem w/ cpdb.py script
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=1799start=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
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: Wiki.auth 401 error
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
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] Re: error using auth.wiki('slug') on service pages
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] Admin app support in app engine
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
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.