[web2py] Re: A Question about Performance of web2py

2016-04-06 Thread Leonel Câmara
Yeah like Niphlod said, I wouldn't worry about web2py at all in that instance. web2py will not be the bottleneck, getting data from that other server will. So just cache the hell out of the calls to make as little requests as possible, load the stuff you need the communication for using ajax so

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Richard Vézina
Hello Mark, Not sure about the bool part, I think web2py treat bool like that to comply with all the different backend and the apdater does the rest... On the other hand I am curious that you update row with simple update(), you suppose to use update_record() Ref: http://www.web2py.com/books/def

[web2py] Re: Some help with computed field in a query

2016-04-06 Thread 'DenesL' via web2py-users
Maybe you could use a virtual field and not a computed one: db.rentals.urlid = Field.Virtual( 'urlid', lambda r: URL('rentals_manage', args=r.id) ) then after rows = db(db.rentals...).select(...) the rows will contain an urlid field. http://web2py.com/books/default/chapter/29/06/the-database-ab

[web2py] Re: cas broken in 2.14.3?

2016-04-06 Thread Franz Pietz
Same here. My server was running 2.12.3 and CAS works fine (with a logout issue that I reported previously, but had no answer yet). After updating to 2.14.3, I get the same 'not authorized' page. On Saturday, April 2, 2016 at 4:15:04 AM UTC-3, mweissen wrote: > > Is cas broken in 2.14.3? > > I a

[web2py] Re: Downloading from "private" folder

2016-04-06 Thread Fabiano
What about files that don't fit any of those? I mean, I have private files, that are used directly by the developers or production support staff, but not by the application itself, and I am not sure where to put those. For example, application architecture diagrams, UML diagrams, requirements

Re: [web2py] Re: Downloading from "private" folder

2016-04-06 Thread Richard Vézina
On the other hand let say they are specific to a single app and only has utility for developper for generating piece of code for instance... I would says that you should create your own folder and at it to .gitingore if they shouldn't be deploy with the app in production... Richard On Wed, Apr 6

Re: [web2py] Re: Downloading from "private" folder

2016-04-06 Thread Richard Vézina
Are they specific to one applications or they apply to multiple application? Are they required in production? I guess not since they seems to be usefull for developping the app... If they are usefull for many app and only serve for development I would say that their place should be in /gluon/cont

[web2py] Re: As I use web2py from source with some modules from my pc,will those module work on pythonanywhere?

2016-04-06 Thread Mirek Zvolský
I think you have to install it too. But I have no special knowledge of Python Anywhere. If terminal+python is accessible or in short script just try: import unirest If fails, you can sure install modules written in pure Python. They could work if they are in web2py applications//modules/ folder. O

[web2py] Re: As I use web2py from source with some modules from my pc,will those module work on pythonanywhere?

2016-04-06 Thread Mirek Zvolský
...or if *pip* is accessible but hasn't access rights to standard target location, you can install to different location as here http://stackoverflow.com/questions/2915471/install-a-python-package-into-a-different-directory-using-pip Then set sys.path as mentioned above. Dne středa 6. dubna

[web2py] Re: As I use web2py from source with some modules from my pc,will those module work on pythonanywhere?

2016-04-06 Thread Anthony
On Sunday, April 3, 2016 at 6:29:34 AM UTC-4, Stephen Duisberg wrote: > > For example, my app uses unirest which is working because I have installed > unirest on my pc. Do I have to install it in the app module too or > pythonanywhere has all sorts of python modules inbuilt? > You can probably j

Re: [web2py] Re: Downloading from "private" folder

2016-04-06 Thread Anthony
On Wednesday, April 6, 2016 at 10:21:01 AM UTC-4, Richard wrote: > > Are they specific to one applications or they apply to multiple > application? > > Are they required in production? I guess not since they seems to be > usefull for developping the app... > > If they are usefull for many app and

[web2py] Re: Downloading from "private" folder

2016-04-06 Thread Anthony
On Wednesday, April 6, 2016 at 10:12:25 AM UTC-4, Fabiano wrote: > > What about files that don't fit any of those? > > I mean, I have private files, that are used directly by the developers or > production support staff, but not by the application itself, and I am not > sure where to put those. >

[web2py] Re: auth_user extra fields + row.to_dict()

2016-04-06 Thread Anthony
On Wednesday, April 6, 2016 at 2:06:11 AM UTC-4, Mark Graves wrote: > > Hey everyone, > > I saw a random bug in an app I'm working on, and I was wondering what the > correct approach is. > > I have auth.settings.extra_fields["auth_user"] = [LIST_OF_FIELDS] > > later, I select that row and get it a

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Anthony
> > On the other hand I am curious that you update row with simple update(), > you suppose to use update_record() > They are both valid methods -- .update updates the Row object itself (like updating a dictionary), whereas .update_record updates the record in the database. You can actually iss

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Anthony
On Wednesday, April 6, 2016 at 11:20:44 AM UTC-4, Anthony wrote: > > On the other hand I am curious that you update row with simple update(), >> you suppose to use update_record() >> > > They are both valid methods -- .update updates the Row object itself (like > updating a dictionary), whereas .

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Richard Vézina
You maybe right Anthony abour update_record() it really depend though of what he is trying todo... :) Richard On Wed, Apr 6, 2016 at 11:21 AM, Anthony wrote: > On Wednesday, April 6, 2016 at 11:20:44 AM UTC-4, Anthony wrote: >> >> On the other hand I am curious that you update row with simple

[web2py] Show a value only if there is in the db

2016-04-06 Thread Andrea Marin
Hi all, I have a db table where I store some information and sometime a file like *.doc or *.pdf This is my model file db.define_table('pratiche', Field('nome', requires=IS_NOT_EMPTY()), Field('descrizione', 'text', requires=IS_NOT_EMPTY()), Field

[web2py] Re: Show a value only if there is in the db

2016-04-06 Thread Anthony
{{=A(row.doc_filename, _href=URL('show', args=row.doc)) if row.doc else 'no attached file'}} Anthony On Wednesday, April 6, 2016 at 11:39:25 AM UTC-4, Andrea Marin wrote: > > Hi all, > > I have a db table where I store some information and sometime a file like > *.doc or *.pdf > This is my mod

[web2py] Re: access tables in database using web2py DAL from iPython prompt

2016-04-06 Thread Vu Pham
Hi Massimo, I am connecting to an existing Microsoft SQL database through DAL - db = DAL('mssql4://sa:password@localhost/Unity'). This connection seems to be connected because I also created the fake table, and the table was created. I can view this table from both Microsoft SQL Manager, and

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Anthony
On Wednesday, April 6, 2016 at 11:30:34 AM UTC-4, Richard wrote: > > You maybe right Anthony abour update_record() it really depend though of > what he is trying todo... > Well at the point where row.update() is called, row is already a dictionary, so there is no .update_record() at that point.

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Richard Vézina
Yeah you right... On Wed, Apr 6, 2016 at 12:06 PM, Anthony wrote: > On Wednesday, April 6, 2016 at 11:30:34 AM UTC-4, Richard wrote: >> >> You maybe right Anthony abour update_record() it really depend though of >> what he is trying todo... >> > > Well at the point where row.update() is called,

[web2py] testing Recaptcha failed on bizzard error

2016-04-06 Thread Richard
Hello, https://github.com/web2py/web2py/blob/master/gluon/tools.py#L848 request = request or current.request self.request_vars = request and request.vars or current.request.vars As request would contains current.request why are trying the following assignation... I think it the

[web2py] rediretct 2 https [ ubuntu.sh]

2016-04-06 Thread goome
Hello i see that the script that install web2py (ubuntu.sh) by defualt will force every request to https. Why? Is there any problem to remove the redirect? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://c

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Mark Graves
Hey Anthony and Richard, Yes you are both correct. I am attempting to create a usable JSON object. The confounding details from what I can tell are: 1.) the offending method is defined in a model file, which returns a dictionary, which is then json serialized via response.json(RETURNED_FROM_MO

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Mark Graves
Offending code from a fresh web2py welcome app: in db.py before auth.define_tables() from gluon.contrib.populate import populate auth.settings.extra_fields['auth_user'] = [Field('test_field_1','boolean')] in controller default.py def test(): if db(db.auth_user.id>0).isempty(): po

[web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Niphlod
recaptcha should be discarded and recaptcha2 should be promoted as the default. On Wednesday, April 6, 2016 at 6:17:38 PM UTC+2, Richard wrote: > > Hello, > > https://github.com/web2py/web2py/blob/master/gluon/tools.py#L848 > > request = request or current.request > self.request_v

Re: [web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Richard Vézina
it failed for the same reason On Wed, Apr 6, 2016 at 2:29 PM, Niphlod wrote: > recaptcha should be discarded and recaptcha2 should be promoted as the > default. > > > On Wednesday, April 6, 2016 at 6:17:38 PM UTC+2, Richard wrote: >> >> Hello, >> >> https://github.com/web2py/web2py/blob/master/g

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Anthony
> > table = db.auth_user > fields = ['id','first_name'] > fields.append('test_field_1') > > query = table.id > 0 > > row = db(query).select(*fields).first().as_dict() > The problem is that you aren't passing the correct arguments to .select(). You must pass Field ob

Re: [web2py] auth_user extra fields + row.to_dict()

2016-04-06 Thread Mark Graves
Ah! Of course. Thanks Anthony! I knew it was something dumb i did =) -Mark On Wed, Apr 6, 2016 at 11:35 AM, Anthony wrote: > table = db.auth_user >> fields = ['id','first_name'] >> fields.append('test_field_1') >> >> query = table.id > 0 >> >> row = db(query).select(*fiel

Re: [web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Niphlod
that test doesn't really assure recaptcha will ever work and it's completely bogus: it just tries to enforce that serialization will work exatcly as it is now. the real issue is that there isn't a request anywhere On Wednesday, April 6, 2016 at 8:33:47 PM UTC+2, Richard wrote: > > it failed for

Re: [web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Richard Vézina
I try to create self.request and if I remember it start throwing error about threading... I know they are really basic test and the only objective was to get some coverage, start testing and see the difficulty it represents... Richard On Wed, Apr 6, 2016 at 2:49 PM, Niphlod wrote: > that test

Re: [web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Niphlod
don't get it in the wrong way, but covering how a recaptcha is serialized serves noone. If one uses recaptcha and he doesn't get the same number of spaces between (s) a failing test identifying that there are 2 instead of 3 spaces doesn't get web2py more covered (even if machines tell you so).

Re: [web2py] Re: testing Recaptcha failed on bizzard error

2016-04-06 Thread Richard Vézina
I take note... As I said it a draft... I consider having something even not perfect is better than non and we have to start somewhere... I learn a lot about web2py internal these days and I have a very limited time... I bang my head on all sort of issue trying to create these tests so don't have ti

[web2py] Re: IS_SET_DB using

2016-04-06 Thread SanDiego
Thank you very much. By the way, I realized that I sent out without completing the subject. :) On Tuesday, April 5, 2016 at 10:37:02 PM UTC-7, Dave S wrote: > > > > On Tuesday, April 5, 2016 at 10:04:47 PM UTC-7, SanDiego wrote: >> >> I wanted to use translatable fields using T() function. I coul

[web2py] Starting server in python script on Windows

2016-04-06 Thread Jeff Riley
Trying to run some selenium tests but not able to get the server started from within my python script on windows. If I don't already have web2py.exe running, it just spins in the web browser. Any ideas? Code: def start_web2py_server(): #noreload ensures single process print os.path.cu

[web2py] Re: Starting server in python script on Windows

2016-04-06 Thread Jeff Riley
Wow, one of these days I will learn to try a thousand things before I ask questions. This change in code is now working just fine. Code: def start_web2py_server(): #noreload ensures single process print os.path.curdir return subprocess.Popen(['../../web2py.exe', '-a "passwd"'])

[web2py] Re: Starting server in python script on Windows

2016-04-06 Thread Dave S
On Wednesday, April 6, 2016 at 2:56:18 PM UTC-7, Jeff Riley wrote: > > Wow, one of these days I will learn to try a thousand things before I ask > questions. This change in code is now working just fine. > > Code: > > def start_web2py_server(): > #noreload ensures single process > print

[web2py] Re: DAL connection to MSSQL

2016-04-06 Thread Brian M
You can do it but you must tell the DAL that the table exists. It won't just discovered existing tables for itself. -- 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 Is

[web2py] Re: SQLFORM.grid: search in a list:reference field does not work

2016-04-06 Thread villas
But the standard grid search widget never allowed for searching 'list:*' fields (except for google:datastore). Correct me if I'm wrong... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2p

[web2py] Re: Using web2py's template parser in an interesting way.

2016-04-06 Thread Encompass solutions
The application has to be in a png format, the application builders are designers that use vector. And the system passes the png to a very simple view that can only handle still images in png or jpg format, maybe one a minute with web2py as the "Application framework". Otherwise, yes, on every