[web2py] Web2py and website GUI

2014-01-31 Thread Gael Princivalle
Hi all. Can someone talk about experiences of collaborations with a GUI designer, I mean someone that don't know nothing about web2py but have to design for you the website interface ? Are there third parts GUI design tools that's works great with web2py, like these:

[web2py] Export issues

2014-01-31 Thread Mirko
Hi all, I downloaded web2py from trunk on Jan 29th and I found some issues with export. Here's the use case: db.define_table('gender',Field('sex'),format='%(sex)s') db.define_table('friend',Field('forename'),Field('gender_id','reference gender'),format='%(forename)s') def manage_friends():

Re: [web2py] Using Homemade task queues

2014-01-31 Thread desta
Thank you Tim, now I think I get it! I was confused because I thought that every time I wanted to run a background task I had to run that python command. Thanks again! On Friday, January 31, 2014 8:19:47 AM UTC+2, Tim Richardson wrote: On Friday, 31 January 2014 08:43:29 UTC+11, desta

[web2py] Re: How to use PythonAnywhere to host an already developed Web2py app?

2014-01-31 Thread Dragan Matic
1. Create an account on pythonanywhere and log in (I presume you want a Beginner account for 0$/month) 2. Click on Dashboard 3. Click on Web 4. Click on Add a new web app 5. Click Next, click on web2py 6. Enter your admin password, click on Next 7. You can now see

[web2py] REF: Compound Primary

2014-01-31 Thread Teddy Nyambe
I have a table: db.define_table('mytable', Field('f1'), Field('F2')) I want to make F1 and F2 together with with the 'invisible id' as a compound primary key. I want the new records to have unique f1 and f2 Kind regards, -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Export issues

2014-01-31 Thread Alan Etkin
Hi all, I downloaded web2py from trunk on Jan 29th and I found some issues with export. Did you have a consistent output on earlier versions? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] AppEngine NDB Ancestor Query

2014-01-31 Thread Alan Heitkotter
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? Something like this: # ndb

[web2py] Re: Export issues

2014-01-31 Thread Mirko
No, same behavior with web2py 2.5.1-stable On Friday, January 31, 2014 9:45:28 AM UTC, Alan Etkin wrote: 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 -

Re: [web2py] Web2py and website GUI

2014-01-31 Thread Kiran Subbaraman
I was initially looking to work with one of the designers or themes from http://themeforest.net. What it comes down to is: * The styling for your website (primarily CSS) is provided by the theme/designer. This means that the CSS supplied with web2py may not be required. * Responsive web

[web2py] Re: Debug web2py with PyCharm 3.0

2014-01-31 Thread Tim Richardson
If you're using pycharm, it has two launch methods, run and debug. You need to start web2py via debug. This means you need to have a debug config which starts the web2py.py script, and you click on the debug icon. The professional version of pycharm already includes a web2py debug config,

[web2py] web2py db.py db._common_fields.append(auth.signature) value not in database error

2014-01-31 Thread Jayadevan M
In our system with some data in the tables, I added to db.py: db._common_fields.append(auth.signature) This added the requisite columns. But When I try to edit the records from appadmin, I get the error value not in database for the signature columns. So I go to psql and update all the signature

[web2py] Re: Debug web2py with PyCharm 3.0

2014-01-31 Thread Tim Richardson
On Friday, 31 January 2014 00:04:19 UTC+11, A36_Marty wrote: Could you elaborate more on the line: Make sure you don't have any imports of the standard web2py debug library. ? web2py and the admin app comes with an excellent web-based interactive debugger. You can drop your program into a

[web2py] db._common_fields.append(auth.signature) and is_active

2014-01-31 Thread Jayadevan M
I have set db._common_fields.append(auth.signature), but not enabled record_versioning. Will web2py still use is_active column for filtering/fetching data from the tables? By seeing the queries executed in the database log, my conclusion is No, the filter is not applied. Just for confirmation.

[web2py] Re: Export issues

2014-01-31 Thread Alan Etkin
No, same behavior with web2py 2.5.1-stable Then I think it should be fixed in trunk. Can you file an issue? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

Re: [web2py] Re: Export issues

2014-01-31 Thread Mirko Scavazzin
ok I will 2014-01-31 Alan Etkin spame...@gmail.com: 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) -

Re: [web2py] recommendations about web2py-compatiable message passing technology?

2014-01-31 Thread Michele Comitini
JsonRPC2 is simple and reliable. It is oriented to RPC more than pure message passing, so that should be ok. Also PHP has support http://sourceforge.net/projects/jsonrpc20php/ as most languages. In web2py and javascript, jsonrpc is very transparent to developer, in PHP there is a little bit of

Re: [web2py] web2py db.py db._common_fields.append(auth.signature) value not in database error

2014-01-31 Thread Vinicius Assef
This was a bug. I sent a patch [1] and it was applied. It's in trunk and will be in next version launch. [1] https://github.com/web2py/web2py/pull/352 On Fri, Jan 31, 2014 at 8:26 AM, Jayadevan M maymala.jayade...@gmail.com wrote: In our system with some data in the tables, I added to db.py:

Re: [web2py] db._common_fields.append(auth.signature) and is_active

2014-01-31 Thread Vinicius Assef
You're right. On Fri, Jan 31, 2014 at 8:32 AM, Jayadevan M maymala.jayade...@gmail.com wrote: I have set db._common_fields.append(auth.signature), but not enabled record_versioning. Will web2py still use is_active column for filtering/fetching data from the tables? By seeing the queries

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
Yes, now check what is in r.content. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google

[web2py] Re: How to use PythonAnywhere to host an already developed Web2py app?

2014-01-31 Thread Bklynate
This worked, Thank you very much. One more question though, How do I get my YOUR_USERNAME.pythonanywhere.com/ to automatically direct to my webapp instead of point to the generic Welcome HelloWorld app? Otherwise I have to constantly add the app in for YOUR_USERNAME.pythonanywhere.com/app2

[web2py] mini web2py and logs

2014-01-31 Thread Manuele Pesenti
Hi! where can I find logs of errors tracebacks when I work on a minified version of web2py? Thanks a lot Manuele -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] Re: Export issues

2014-01-31 Thread Mirko
Done. https://code.google.com/p/web2py/issues/detail?id=1866 On Friday, January 31, 2014 10:43:33 AM UTC, Alan Etkin wrote: 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 -

[web2py] Re: How to use PythonAnywhere to host an already developed Web2py app?

2014-01-31 Thread Bklynate
I realized I could always make the Welcome app redirect to my other app, but I would like it if my YOUR_USERNAME.pythonanywhere.com/ went directly to my new app. On Friday, January 31, 2014 8:07:00 AM UTC-5, Bklynate wrote: This worked, Thank you very much. One more question though, How do

[web2py] Re: add the session value to an existing session

2014-01-31 Thread 黄祥
pardon, could you explain the meaning of this code, please : 1. quantity = max(0, quantity + 1) 2. quantity = session.purchase_order.get(id, 0) what is the 0 (zero) meaning on code above? the code is taken from web2py appliances pos online store, yet it work when i took the price from the

[web2py] Re: REF: Compound Primary

2014-01-31 Thread Anthony
web2py can't set a multi-column constraint at the database level, so you'll have to do that directly in the database (once you do that, attempting an insert that violates the constraint will cause a database exception to be thrown). If you want form validation with friendly error messages

[web2py] Re: add the session value to an existing session

2014-01-31 Thread Anthony
I think it will make things a lot easier if you spend some time learning Python a little better. That will help you to understand the original code and how to modify it to suit your needs. max() and .get() are standard Python functions -- you should be able to find lots of places to explain

[web2py] Re: DAL and relations

2014-01-31 Thread Dreamer
it there a way to elaborate on this a bit more... i have a similar structure...and i am able to do a multiupload.. and create new albums. however i am looking to allow users to upload images to the same album or any pre-existing album On Friday, 22 October 2010 09:51:00 UTC+5:30, Alex wrote:

[web2py] Fixing web2py ajax call changing controller

2014-01-31 Thread A36_Marty
Controller def index(): select_list = (Create a SELECT of options with the _onchange=ajax('ajax_requery',['selectlist'],'div_grid') grid = SQLFORM.grid(...) div_grid = DIV(grid, _id=div_grid) return dict(div_grid = div_grid, select_list=select_list) def ajax_requery():

[web2py] Re: AppEngine NDB Ancestor Query

2014-01-31 Thread Alan Etkin
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

[web2py] Web2py Forums

2014-01-31 Thread Marc Garcia
Hi, I want to implement a forum to my web2py webpage. The best I've seen is PyForum but it seems to be abandoned and I haven't seen any activity in the last two years. What will be the best choice? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Fixing web2py ajax call changing controller

2014-01-31 Thread Anthony
You shouldn't try to create the same grid using two different actions. Links are generated by the grid assuming the links should point back to the same action that generated the grid. Instead, it might work better to generate the initial grid on the index page via Ajax. The easiest method

Re: [web2py] Re: Email and PGP

2014-01-31 Thread horridohobbyist
Thanks. Here's what I found... In send(), after this code fragment: c = core.Context() c.set_armor(1) c.signers_clear() for sigkey in c.op_keylist_all(sender, 1): ...the for loop is never entered. In other words, c.op_keylist_all(sender, 1) is empty, so c.signers_add(sigkey)

[web2py] Re: Install in hostgator

2014-01-31 Thread desta
I am writing to update this method. We have followed the instructions included above but we kept getting an internal server error 500. The problem was that we had no experience how virtualenv works! So first you need to create one with the following command: virtualenv /home/USER/python The

[web2py] Re: Do I need to set auth.settings.hmac_key?

2014-01-31 Thread Massimo Di Pierro
It should be modified. On Thursday, 30 January 2014 11:35:08 UTC-6, User wrote: Ok I was confused because the books says ( http://www.web2py.com/book/default/chapter/09#Settings-and-messages) The following is a very important setting: auth.settings.hmac_key = None It must be set to

[web2py] Re: join after filtering first table

2014-01-31 Thread Massimo Di Pierro
Please show the model and explain in english what you want to do. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you

[web2py] Re: Web2py Forums

2014-01-31 Thread Massimo Di Pierro
https://github.com/mdipierro/web2py-appliances/tree/master/MyForum On Friday, 31 January 2014 03:48:54 UTC-6, Marc Garcia wrote: Hi, I want to implement a forum to my web2py webpage. The best I've seen is PyForum but it seems to be abandoned and I haven't seen any activity in the last two

[web2py] Re: join after filtering first table

2014-01-31 Thread Avi A
It's OK thanks. On Friday, January 31, 2014 7:57:45 PM UTC+2, Massimo Di Pierro wrote: Please show the model and explain in english what you want to do. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Avi A
rest_action = _action().get(method, None) AttributeError: 'NoneType' object has no attribute 'get' On Friday, January 31, 2014 2:12:44 PM UTC+2, Anthony wrote: Yes, now check what is in r.content. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: app not working after install 2.8.2 is_mobile error

2014-01-31 Thread Ian W. Scott
I just ran into this same error using the auto-update to come up to 2.8.2. I was able to find this solution, but it did cost me about 1.5 hours of figuring out what was wrong. Not so bad in the grand scheme of things, but maybe the auto-update interface in the admin app could include some way

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
Is that what's in r.content? If so, looks like you didn't add the return locals() line at the bottom of your api() function. Anthony On Friday, January 31, 2014 1:23:53 PM UTC-5, Avi A wrote: rest_action = _action().get(method, None) AttributeError: 'NoneType' object has no attribute 'get'

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Avi A
I did, but now I see that i didn't put it left enough. Now the error I get: if db(db.auth_user.api_key == post_params.api_key).count(): AttributeError: 'dict' object has no attribute 'api_key' Maybe I should pop it out of the URL params like you suggested above? On Friday, January 31, 2014

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
Sorry, it should be post_params['api_key'] rather than post_params.api_key. Anthony On Friday, January 31, 2014 2:20:57 PM UTC-5, Avi A wrote: I did, but now I see that i didn't put it left enough. Now the error I get: if db(db.auth_user.api_key == post_params.api_key).count():

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Avi A
Almost there... TypeError: _filter_fields() got an unexpected keyword argument 'f_steps' and I do have it on the model: db.define_table('t_tests_results', Field('f_test', type='reference t_tests', label=T('Test')), Field('f_project', type='reference t_projects',

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
Oops, this: t.validate_and_insert(t._filter_fields(**post_params)) should be: t.validate_and_insert(**t._filter_fields(post_params)) Anthony On Friday, January 31, 2014 2:46:23 PM UTC-5, Avi A wrote: Almost there... TypeError: _filter_fields() got an unexpected keyword argument 'f_steps'

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Avi A
return str(long(obj)) ValueError: invalid literal for long() with base 10: 'Android' and that's where Android goes to: db.define_table('t_types', Field('f_platform_name', type='string', label=T('Platform Name')), auth.signature, format='%(f_platform_name)s',

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
Doesn't look like that's going into a string field. Maybe check the call being made. On Friday, January 31, 2014 3:20:51 PM UTC-5, Avi A wrote: return str(long(obj)) ValueError: invalid literal for long() with base 10: 'Android' and that's where Android goes to: db.define_table('t_types',

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Avi A
Well, not sure what to check. You saw the tables definitions and this is the call: test_params = {'api_key': 'e5dcc229-906d-47f8-b6ab-d184509f4f0b', 'f_test': 'test', 'f_project': 'Reader', 'f_platform': 'Android', 'f_device': 'Toshiba', 'f_steps': '10', 'f_matches':'7', 'f_missmatches': '3'}

[web2py] Re: Trying to build a post api.

2014-01-31 Thread Anthony
The string field you showed was for f_platform_name, but in your test_params, you have f_platform, which I assume must be an integer or reference field (the str(long(obj)) code is only called for id, integer, and reference type fields in the DAL). On Friday, January 31, 2014 4:18:53 PM UTC-5,

Re: [web2py] Re: Email and PGP

2014-01-31 Thread Alan Etkin
...the for loop is never entered. In other words, c.op_keylist_all(sender, 1) is empty, so c.signers_add(sigkey) is never executed. Does that help? Not much, but at least we now know that pyme (the python wrapper for the pgp library) cannot find any sub-key for sender, where it should.

[web2py] sqlite 3.7 with web2py

2014-01-31 Thread peter
I want to use sqlite 3.7 with web2py because it supports WAL, write ahead logging. This gives much better performance if users often write to the database. Without it one can get database locked tickets. I have managed to set up python 2.7.1 to use sqlite version 3.7 (sqlite3.sqlite_version

[web2py] Re: add the session value to an existing session

2014-01-31 Thread 黄祥
yeah, you are right, your code is work, i found the root cause is on the *views/transcation/purchase_cart.html* {{=SPAN(session.purchase_order[row.id]['quantity'], _id=item_%s % row.id) }} {{=T('In Order') }} when i remove it, and look into response.toolbar() i got my expected session

[web2py] Re: add the session value to an existing session

2014-01-31 Thread Anthony
Ids are Python long integers, so when the repr method is called to display them in some contexts, the L is appended. That shouldn't be causing your error, though -- instead, looks like there is no 2 key in purchase_order. Anthony On Friday, January 31, 2014 6:15:02 PM UTC-5, 黄祥 wrote: yeah,

[web2py] Re: Debug web2py with PyCharm 3.0

2014-01-31 Thread 黄祥
hi, i'm trying to follow tim's hint : When you run your application (or do debug) from pycharm, the default configuration should launch python web2py.py If it doesn't do this, pycharm has not detected that you are using web2py. Exit pycharm and delete any .idea folders, which may contain

Re: [web2py] Re: Email and PGP

2014-01-31 Thread horridohobbyist
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. Meanwhile, perhaps the web2py book should be updated to reflect the current lack of usability of PGP email, so that

Re: [web2py] Re: Email and PGP

2014-01-31 Thread horridohobbyist
Maybe I'll try again in another couple of years. Perhaps third time will be the charm, eh? On Friday, 31 January 2014 19:20:10 UTC-5, horridohobbyist wrote: 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

Re: [web2py] How to start external python script from my web2py controller (Solution needed as soon as possible )

2014-01-31 Thread Joe Barnhart
It sounds like you are describing the Scheduler (in the book). This is a completely separate instance of Python and web2py that can run long-running things in a different process from the website. I use it for reading large files and populating the database, or generating long reports. In

[web2py] Find Next

2014-01-31 Thread horridohobbyist
Stooopid question: In the web-based editor, how do you find next? It's a royal pain having to type the search string in Search: again and again to find the next instance. Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: How to use PythonAnywhere to host an already developed Web2py app?

2014-01-31 Thread Dave S
On Friday, January 31, 2014 5:41:06 AM UTC-8, Bklynate wrote: I realized I could always make the Welcome app redirect to my other app, but I would like it if my YOUR_USERNAME.pythonanywhere.com/ went directly to my new app. Is this a question that leads to routes.py? I haven't played

[web2py] Re: Fixing web2py ajax call changing controller

2014-01-31 Thread A36_Marty
Thank you for your response. I've got components working and have a couple of follow-up questions -- mainly due to my ignorance and novice web2py abilities. 1) I see a args and vars option on the view-side component LOAD() function for the component; however, I'm having trouble with the view

[web2py] Re: Do I need to set auth.settings.hmac_key?

2014-01-31 Thread User
Should I create an issue for changes to the book? Or do you already have it notated? On Friday, January 31, 2014 12:55:51 PM UTC-5, Massimo Di Pierro wrote: It should be modified. On Thursday, 30 January 2014 11:35:08 UTC-6, User wrote: Ok I was confused because the books says (

[web2py] Re: Fixing web2py ajax call changing controller

2014-01-31 Thread Anthony
Something like this (not tested): script $(function() { $('select[name=account_list]').on('change', function() { $.web2py.component('{{=URL('positions2', 'component_grid.load')}}' + '?account=' + this.value, target='grid'); }); }); /script {{=select_account_list}}