[web2py] Upload Video

2016-12-14 Thread David
How can I upload a video and display it in a view from the db? The normal "upload" type in db only lets me choose an image I have tried these links: http://www.reddit.com/r/Python/comments/1r7v23/audio_streaming_app_in_web2py_from_scratch/

[web2py] Re: column must appear in the GROUP BY clause or be used in an aggregate function

2016-12-14 Thread Niphlod
once you group, you can only select the grouped fields and any other field as an aggregate. >From a set-based logic perspective (which is what "serious" database enforce) it has absolutely no meaning asking for entity.id in your case. On Wednesday, December 14, 2016 at 5:44:05 PM UTC+1, Ramos

[web2py] Re: Authomatic Single sign-on with MS Active Directory

2016-12-14 Thread Niphlod
I took a stab at it but it's incredibly resource-intensive. In fact, I just coded a very complicated routine for single sign-on (kerberos) in an app that does only user authentication and is used as a cas backend by other apps. Restricting the usage to just logging in a few times a day is

[web2py] selection list with items not yet selected

2016-12-14 Thread icodk
I have an item ,category and item_category tables facilitating many to many relations between items and categories, which enables an item to belongs to several categories. I use SQLSmartgrid to show the item_category table and to add categories to specific item. This all works well. I can

Re: [web2py] Re: Problem with limitby?

2016-12-14 Thread Scott Hunter
It would be the case if one were cloned from the other. - Scott On Wednesday, December 14, 2016 at 3:54:44 PM UTC-5, Richard wrote: > > You should check if both data set are the same which shouldn't be the case > for the machine you experiment the issue with... > > On Wed, Dec 14, 2016 at 3:27

Re: [web2py] Re: Problem with limitby?

2016-12-14 Thread Richard Vézina
You should check if both data set are the same which shouldn't be the case for the machine you experiment the issue with... On Wed, Dec 14, 2016 at 3:27 PM, Scott Hunter wrote: > I have just tried it on a different OS X machine (but same version of the > OS), and did not

[web2py] Re: Problem with limitby?

2016-12-14 Thread Scott Hunter
I have just tried it on a different OS X machine (but same version of the OS), and did not see the problem. And I didn't see it on pythonanywhere, so I guess it is just that one machine. - Scott On Wednesday, December 14, 2016 at 2:03:10 PM UTC-5, Anthony wrote: > > Sorry, I cannot reproduce

Re: [web2py] Re: Problem with limitby?

2016-12-14 Thread Scott Hunter
You read it too rapidly. I am *not* getting the same results with and without limitby, which is the whole point. In particular, the first 20 records produced by the query without limitby contains records that do not appear in the 20 records produced when limitby=(0,20) is used; the 20 records

Re: [web2py] Re: Contributing to web2py

2016-12-14 Thread Richard Vézina
I think he wants to execute a single or subset of test case inside a test_WEB2PY_MODULE_NAME. I don't think this is possible, but as Simone details you can run onlye the tests for a given web2py component (python file in gluon) at a time. Richard On Wed, Dec 14, 2016 at 2:28 PM, Niphlod

Re: [web2py] Re: Problem with limitby?

2016-12-14 Thread Richard Vézina
Hello Scott, You mention that both results set were the same with and without limitby, I guess is because the number of record your query return is already 20 or even less record so, limitby don't kick in and is useless because your data set has too few records... You also mention that belongs

[web2py] Re: jquery 1.12.2 vulnerability

2016-12-14 Thread Niphlod
you are free to use whatever you may like in your own app. btw, jquery 1.12.2 afaik is not vulnerable, just "old". On Monday, December 12, 2016 at 7:53:29 PM UTC+1, Jacinto Parga wrote: > > > Hi, > > I have recently made a security analisys in a web application deployed > with web2py in Google

[web2py] Re: Scheduler in systemd environment (running very long tasks)

2016-12-14 Thread Niphlod
that piece of code is in place to let the worker being terminated by a sigterm, i.e a ctrl+c, that is useful for development purposes. it *should* have nothing to do with long running tasks, but I'm really honest saying I never had a single task alive for more than an hour. Frankly I don't know

[web2py] Re: Contributing to web2py

2016-12-14 Thread Niphlod
- if you cloned from github without reading the main page I wonder what "documentation" needs to be more explicit. - you can single tests with run python -m unittest gluon.tests.whatever On Monday, December 12, 2016 at 12:20:26 AM UTC+1, Marlysson Silva wrote: > > Guys , good night . > > I

[web2py] Re: Problem with limitby?

2016-12-14 Thread Anthony
Sorry, I cannot reproduce running on Ubuntu -- both printouts as well as the first page of the grid (after sorting on Myfield2) all have the same 20 records when I run it. Maybe someone else can try it on OSX. What happens if you run the OSX binary version of web2py? Anthony On Tuesday,

[web2py] Re: SQLFORM grid search : Get ids of filtered records

2016-12-14 Thread Anthony
See the answer at https://groups.google.com/d/msg/web2py/i01tO7LQVYE/APWn-NPoCAAJ. The only difference is you need to conditionally set the values to True or False depending on which button was clicked. Assuming the approve/reject filtered buttons are your 5th and 6th buttons, respectively, it

[web2py] Re: column must appear in the GROUP BY clause or be used in an aggregate function

2016-12-14 Thread villas
You usually have to include ALL the selected fields in the groupby and orderby clauses. Anyhow, the logic of the query doesn't seem correct either. I think you probably need something like this: count = db.ficheiros.entity.count()

[web2py] column must appear in the GROUP BY clause or be used in an aggregate function

2016-12-14 Thread António Ramos
can i get some help? it was working with sqlite but not with postgresql for row in db(db.ficheiros.entity==db.entity.id).select(db.entity.entity, db.entity.id,count,groupby=db.entity.entity): column "entity.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1:

Re: [web2py] Re: Does anyone know what happens with site web2py.com?

2016-12-14 Thread Philip Kilner
Hi Massimo, On 14/12/16 15:52, Massimo Di Pierro wrote: very strange. I did no maintenance. Perhaps the host did. Maybe this? : - http://blog.pythonanywhere.com/146/ HTH -- Regards, PhilK 'a bell is a cup...until it is struck' -- Resources: - http://web2py.com -

[web2py] Re: Does anyone know what happens with site web2py.com?

2016-12-14 Thread Massimo Di Pierro
very strange. I did no maintenance. Perhaps the host did. On Wednesday, 14 December 2016 09:35:51 UTC-6, Gleb Erofeev wrote: > > > > Maybe I missed smthng > --

[web2py] Does anyone know what happens with site web2py.com?

2016-12-14 Thread Gleb Erofeev
Maybe I missed smthng -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] FYI - web2py book example on "Securing sessions and admin" needs to be fixed

2016-12-14 Thread Terrence Brannon
The web2py book example on "Securing sessions and admin" states that the 2nd step in securing an admin session is: nohup python web2py --nogui -p 8002 -i 127.0.0.1 -a '' & However the ampersand on

[web2py] Re: wiki menu in bootstrap theme

2016-12-14 Thread Massimo Di Pierro
If you call wiki.automenu() it will append the menu to response.menu. Then you can loop {{for item in response.menu:}}...{{pass}} and build it yourself. item is always (title, False, link) False or True depending on whether you are looking at that page. On Tuesday, 13 December 2016 07:11:38

[web2py] Re: Authomatic Single sign-on with MS Active Directory

2016-12-14 Thread Willoughby
Take a look at the win32security module that's part of pywin32: http://timgolden.me.uk/pywin32-docs/win32security.html On Wednesday, December 14, 2016 at 8:47:54 AM UTC-5, piero crisci wrote: > > Hello i am using correctly the Ldap authentication . > But i was wondering if there was a chance

[web2py] Authomatic Single sign-on with MS Active Directory

2016-12-14 Thread piero crisci
Hello i am using correctly the Ldap authentication . But i was wondering if there was a chance to make authomatic sign on without insert the username and password again. The users infact are on pc on the same domain of the application. Anyone has a hint to help me with this? -- Resources: -