[web2py] Re: Database

2015-04-05 Thread Leonel Câmara
I would say postgresql is better than MySQL, not just web2py but for everything. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this

[web2py] Re: Database

2015-04-05 Thread 黄祥
granma said : 'everything is wonthefull if you know how to appreciate it' everything has a good side n bad side, imho better is which database you familiar n comfortable with, then please use it. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: query in is_in_db is not work

2015-04-05 Thread Anthony
There is an error in you query -- the and should be an . But that is not the source of your exception, which comes from the previous line that attempts to access the db.employee table. Apparently, at this point in the code, that table has not yet been defined (perhaps it is defined in a later

[web2py] Re: query in is_in_db is not work

2015-04-05 Thread 黄祥
There is an error in you query -- the and should be an . But that is not the source of your exception, which comes from the previous line that attempts to access the db.employee table. Apparently, at this point in the code, that table has not yet been defined (perhaps it is defined in a

[web2py] ERROR on clear cash fron admin DB

2015-04-05 Thread Dmitry Ermolaev
I store in cash connection: # покажем если был вызов а не из кэша def conn_1(curr, xcurr): print 'try connect to ',curr.abbrev # def __init__(self, service_url, service_name=None, timeout=HTTP_TIMEOUT, connection=None): cn = ServiceProxy(xcurr.connect_url, None, 40) #print cn

[web2py] Re: web2py 2.10.3 si OUT

2015-04-05 Thread 黄祥
format record representation is not work in grid (in the drop down select form field is work, but in the grid table just shown an id). e.g. db.define_table('test0', Field('test0'), format = '%(test0)s') db.define_table('test1', Field('test0', 'reference test0'), Field('test1'), format =

[web2py] Database

2015-04-05 Thread Wellington Faria
Hi! I would like to know wich is better database to use in web2py? Mysql or postgre? 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

[web2py] BaseAdapter supporting driver selection

2015-04-05 Thread Felipe Augusto Meirelles
Hi, On pydal/adapters/base.py, on line 170 shouldn't it be: items = uri.split('://', 1)[0].split('+') instead of items = uri.split('://', 1)[0].split(':')? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] w2p_clone broke web2py installation

2015-04-05 Thread Gary Cowell
Hello I installed web2py from pip, I think it's at 2.1.1 Then ran w2p_clone to bring in latest version. On launch I get the following error: Traceb Traceback (most recent call last): File web2py.py, line 18, in module import gluon.widget File

Re: [web2py] Drill-down menu with PostgreSQL

2015-04-05 Thread Carlos Zenteno
Thanks for explaining the materialization process. It will come handy on my app... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this

[web2py] Re: Design flaw in auth.impersonate ?

2015-04-05 Thread Limedrop
Well the easy answer is to simply open the impersonated user in a different browser (eg, have Support Team login in chrome and impersonated user login in firefox). For us it is important that impersonate is restricted to the user's permissions...we have several classes of user and it is

[web2py] Re: call a function from form.process()

2015-04-05 Thread 黄祥
yes, i know it's lack of parenthesis, pardon me, actually, my real code is i put it on module n pass into variable via the controller, the test (app n function), is the minimum application that was for dev environment to trace back the root cause of the problem. btw, anthony has shown the way,

[web2py] Re: AppConfig and Storage

2015-04-05 Thread 黄祥
Beware: since it's made for speed, once you take out the reload on the initialization, values will be stored indefinitely as they are fetched the first time. agreed, already tested it. imho, i think is still not stable. e.g. private/appconfig.ini [auth] actions_disabled = ['profile',

[web2py] Re: unknown error on production server! I need help fixing it asap ['NoneType' object is not callable]

2015-04-05 Thread Leonel Câmara
I think it's a weird bug where you have a cookie in your browser that is no longer in the server so you get that NoneType, not sure what causes it, I think it's probably a weird interaction with your webserver configuration (probably apache which seems to create weird problems). I'll try

[web2py] Re: auth_user table format

2015-04-05 Thread 黄祥
yes, you are right, i defined the custom_auth after auth.define_tables(), but the problem is when i put it before auth.define_tables() it return an error *e.g. no error but the result is not expected* auth = Auth(db) audit_from = db.Table(db, 'audit_from', Field('created_from', default =

[web2py] Developer network

2015-04-05 Thread 'sasogeek' via web2py-users
Hello, I'm wondering if there's a social media platform for app developers? I want to build one as an open source project using web2py... any thoughts, ideas, something to look on to start with? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Developer network

2015-04-05 Thread Phyo Arkar
Github? On Mon, Apr 6, 2015 at 11:10 AM, 'sasogeek' via web2py-users web2py@googlegroups.com wrote: Hello, I'm wondering if there's a social media platform for app developers? I want to build one as an open source project using web2py... any thoughts, ideas, something to look on to start

[web2py] Re: query in is_in_db is not work

2015-04-05 Thread 黄祥
There is an error in you query -- the and should be an . But that is not the source of your exception, which comes from the previous line that attempts to access the db.employee table. Apparently, at this point in the code, that table has not yet been defined (perhaps it is defined in a

[web2py] Database

2015-04-05 Thread Ron Chatterjee
I would say u want to start with sqlite n before deployment u can choose something more applicableble to ur requirents. There r no right or wrong ans. If performance n security is huge use mysql. Otherwise the open source -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] query in is_in_db is not work

2015-04-05 Thread 黄祥
hi, i have a query in is_in_db requires but not work properly e.g. *models/db.py* employee = db(db.employee.auth_user == 1).select().first() db.booking.room.requires = IS_IN_DB(db((db.room.status == 'Available') and (db.room.branch == employee.branch)), db.room.id, db.room._format) if auth.user

[web2py] Re: auth_user table format

2015-04-05 Thread Anthony
For the format attribute to affect the represent attribute of linked reference fields, it must be set before those reference fields are defined. If you are setting the auth_user format attribute after calling auth.define_tables(), then the auth_event table has already been defined. Instead,

[web2py] Re: Is julia going to be the next language of choice, can web2py benefit from its speed?

2015-04-05 Thread david jensen
On Saturday, April 4, 2015 at 1:33:40 AM UTC-4, Ron Chatterjee wrote: I recently came across the wonderful programing language call Julia. I used the word wonderful since its resembling to C/MATLAB environment as I am mostly familiar with. Regardless,... people are saying its two times

[web2py] Re: Design flaw in auth.impersonate ?

2015-04-05 Thread Massimo Di Pierro
Now I think 3 should be the solution but it should be an option and not default behavior. Nowhere we say that impersonate should behave has linux sudo permissions. The way it is intended to work is that when you impersonate another user you become that other use and you see what the other user

[web2py] Re: sorting ip address

2015-04-05 Thread rhardenstein
Try using the netaddr library... On Tuesday, March 31, 2015 at 3:27:11 PM UTC-7, Matheus Suffi wrote: Hello, im trying to sort an IP adddres list, this is the only result i getting 192.168.1.1 192.168.1.10 192.168.1.11 i want to list in that order: 192.168.1.1 192.168.1.2 192.168.1.3

Re: [web2py] Developer network

2015-04-05 Thread 'sasogeek' via web2py-users
Hmmm, I guess I never saw github as that... never really explored it, just have an account there. Will take a look and see what I can learn from it. Thanks On Monday, 6 April 2015 06:07:21 UTC+1, Phyo Arkar wrote: Github? On Mon, Apr 6, 2015 at 11:10 AM, 'sasogeek' via web2py-users

[web2py] auth_user table format

2015-04-05 Thread 黄祥
hi, i tried to have auth_user a proper format record representation, but it end with just the id shown on the table. e.g. *models/db.py* custom_auth_table = db[auth.settings.table_user_name] custom_auth_table._format = '%(first_name)s %(last_name)s' auth.settings.table_user = custom_auth_table

[web2py] Re: unknown error on production server! I need help fixing it asap ['NoneType' object is not callable]

2015-04-05 Thread 'sasogeek' via web2py-users
Thanks Leonel Somehow that worked! But I have no idea why it worked... seeing as you suggested it, can you explain to me please? Thanks again though. On Sunday, April 5, 2015 at 9:15:56 AM UTC+1, Leonel Câmara wrote: If you clear your browser cookies (you can try using a private browsing

[web2py] Re: Facing problem of settingup web2py project in Eclipse.

2015-04-05 Thread flagist0
Hello Amit! Web2py executes your code in a special environment populated with predefined objects (like request, response, T etc, http://web2py.com/books/default/chapter/29/04/the-core#API) Also web2py has special places where it looks for modules (/gluon, applications/your application/modules,

[web2py] Re: call a function from form.process()

2015-04-05 Thread Anthony
There's no reason you can't use a function in your first example: if form.process().accepted: oncreate_event(form) You can also use the onsuccess argument: form.process(onsuccess=oncreate_event) The above will mainly be useful when you have also specified a next argument and need to do

[web2py] Re: unknown error on production server! I need help fixing it asap ['NoneType' object is not callable]

2015-04-05 Thread Leonel Câmara
If you clear your browser cookies (you can try using a private browsing window) does it 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

[web2py] Design flaw in auth.impersonate ?

2015-04-05 Thread Louis Amon
When you impersonate a user in web2py, your whole auth session gets replaced with the user's, and that means you lose access to whatever permissions you used to have ( http://web2py.readthedocs.org/en/latest/tools.html#gluon.tools.Auth.impersonate ) Practically : if you're a staff member

[web2py] Re: call a function from form.process()

2015-04-05 Thread JorgeH
are you aware that you are not calling the function ? or is that semicode. def test(): form = SQLFORM(db.test) if form.process().accepted: oncreate_event () - you lack the parenthesis here, and the argument return dict(form = form) On Saturday, April 4, 2015 at 10:51:02 PM

[web2py] Re: Difference between response.files.insert() and URL(), and congratulations on v2.10

2015-04-05 Thread Louis Amon
Unless... you have response.optimize_css set somewhere in your code as well. In which case, some pre-processing and caching would be applied to your CSS file before it is injected in the view. More doc here : http://www.web2py.com/books/default/chapter/29/04/the-core#response On Thursday,

Re: [web2py] Drill-down menu with PostgreSQL

2015-04-05 Thread Louis Amon
That's an interesting approach indeed. Thanks Niphlod :) Well, in the end my company hired a SEO consultant and our conclusion was that we need to build a drill-down navigation instead of one page containing the whole tree. E.g. : *country* - administrative_area_level_1 -

[web2py] Re: Project: Heroku Buildpack for Web2py

2015-04-05 Thread Louis Amon
After much thought, and based on the fact that I've been using the Heroku/Web2py stack for more than a year now, I think I'll try to build a scaffolding app dedicated to Heroku in order to demonstrate exactly how one should go about building a web2py-based application on a PaaS cloud with no