Thank you Niphlod, much appreciated.
On Mon, Sep 2, 2013 at 4:04 PM, Niphlod niph...@gmail.com wrote:
description myqueueprocessor
start on (local-filesystems and net-device-up IFACE=eth0)
stop on shutdown
respawn limit 8 60 # Give up if restart occurs 8 times in 60 seconds.
exec sudo -u
totally unrelated note: did you try simply loading a grid via ajax ? if
your db isn't slow, from the user perspective it's pretty fast.
On Tuesday, September 3, 2013 2:10:59 AM UTC+2, Tim Richardson wrote:
Can anyone provide tutorial/example of a web2py implementation of an AJAX
grid which
On Tuesday, September 3, 2013 1:57:15 AM UTC+2, web2py_tn wrote:
but that defeats the purpose if I order by all the fields.
I've been trying for hours now get the correct way of grouping by (
groupby table.field ) in postgresql.
Any help?
ehm... what ? orderby and groupby takes exactly
On Tuesday, 3 September 2013 16:52:34 UTC+10, Niphlod wrote:
totally unrelated note: did you try simply loading a grid via ajax ? if
your db isn't slow, from the user perspective it's pretty fast.
On Tuesday, September 3, 2013 2:10:59 AM UTC+2, Tim Richardson wrote:
Can anyone provide
but I want to orderby one field and not all the fields. I want to orderby
Table1.id only.
On Tue, Sep 3, 2013 at 7:53 AM, Niphlod niph...@gmail.com wrote:
On Tuesday, September 3, 2013 1:57:15 AM UTC+2, web2py_tn wrote:
but that defeats the purpose if I order by all the fields.
I've been
you have a problem with what you want and what you get
Assuming a table
id name surname
1 tywin lannister
2 tyrion lannister
3 eddard stark
4 sansa stark
and a query where you want to know how many members of the Game Of Thrones
families
it's one of my long-end goals to provide an inline-editing-capable sqlform
grid right in web2py source. As of right now, you're forced to choose a
grid and reinvent the wheelother project made for web2py I think need a
tiddle bit of refactoring, but are a good and solid starting point.
On
I am sorry. I am trying to groupby and not orderby.
I want to select from 2 tables and groupby the id of one table. This works
fine in sqllight but throws an error on postgresql.
Massimo suggested that I add the id of the second table using |. However,
then I can't get the result I need, which is
Can you recreate a simple test to reproduce that behaviour and open a
ticket about it? It can be a bug of web2py or not.
mic
2013/9/3 André Kablu kabl...@gmail.com
Hi all,
I'd created one application that loads 15 lines of a mysql database.
Then I put all 150k lines in a list(), doing
please post your model, a simple data set and what you want as a
resultset
On Tuesday, September 3, 2013 11:42:38 AM UTC+2, web2py_tn wrote:
I am sorry. I am trying to groupby and not orderby.
I want to select from 2 tables and groupby the id of one table. This works
fine in sqllight
This is trivial. You just need a DNS entry for example.com and not for the
specific domains (this is the default anyway). Than in web2py you read the
entry from request.env.http_host
If you use apache (you do not have to use apache) make sure you have a
catch all virtual host VirtualHost
Do
cd web2py
sudo -u www-data python -c from gluon.main import save_password;
save_password(raw_input('admin password: '),443)
This will create a password file for you valid when admin is accessed via
https (port 443).
On Monday, 2 September 2013 16:52:10 UTC-5, mark warburton wrote:
after strugeling to get find a way on how to access the console I used this
method:
since I'm working on ubuntu web2py is located at /usr/share/web2py, however
if you start web2py with the desktop shortcut and you create an app it is
located in the ~/web2py/applications folder. so copied it
Have just unzipped web2py_win.zip, there is a duplicate file name, and the
files are different sizes so I presume have different content. Do we need
either or both of these files?
web2py\applications\examples\static\epydoc\gluon.html.__TAG__-class.html
No. This file should not be there:
gluon.html.__tag__-class.html
I will do some cleanup. We are about to release 2.6.1.
Massimo
On Monday, 2 September 2013 23:13:34 UTC-5, Les Ferguson wrote:
Have just unzipped web2py_win.zip, there is a duplicate file name, and the
files are different
On 3 September 2013 11:42, Bassem Bouguerra bougue...@gmail.com wrote:
I am sorry. I am trying to groupby and not orderby.
I want to select from 2 tables and groupby the id of one table. This works
fine in sqllight but throws an error on postgresql.
You cannot do that in Postgresql. If you
Hi,
I have recently start to use the scheduler module which looks great,
but when i try to use a simple example simply doesn't works, any
additional works requires?
created a scheduler.py inside models which contains
---
from gluon.scheduler
+1
Richard
On Fri, Aug 23, 2013 at 4:22 AM, Michele Comitini
michele.comit...@gmail.com wrote:
IMHO I would be careful in adding support to presentation frameworks
inside main web2py distribution.
The scaffolding applications should be a projects on their own.
This way there could be
I agree that this should be moved to contrib, as suggested. Perhaps even
before 2.6.x is released.
Like I said earlier, I'd move the existing bootstrap too.
Regards
On Tuesday, September 3, 2013 3:24:39 PM UTC+2, Richard wrote:
+1
Richard
On Fri, Aug 23, 2013 at 4:22 AM, Michele
first things first, if you use queue_task in a model, every request a task
will get queued.
Second thing: enable the debug log to see what a task prints out with -D 0
Third: the scheduler is supposed to be a quasi-daemonic process: you
usually want to read the results from the scheduler_run
I Agree.
On Tue, Sep 3, 2013 at 10:24 AM, Richard Vézina
ml.richard.vez...@gmail.com wrote:
+1
Richard
On Fri, Aug 23, 2013 at 4:22 AM, Michele Comitini
michele.comit...@gmail.com wrote:
IMHO I would be careful in adding support to presentation frameworks
inside main web2py
+1.
Only for put more gas in the fire, more CSS frameworks to develop your own
formstyles:
http://usablica.github.io/front-end-frameworks/compare.html
Regards,
2013/9/3 Vinicius Assef vinicius...@gmail.com
I Agree.
On Tue, Sep 3, 2013 at 10:24 AM, Richard Vézina
Thanks Niphlod,
Now i really understand how to works the scheduler.
Saludos,
Alfonso de la Guarda
Twitter: @alfonsodg
Redes sociales: alfonsodg
Telef. 991935157
1024D/B23B24A4
5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4
On Tue, Sep 3, 2013 at 8:32 AM,
According to:
http://web2py.com/books/default/chapter/29/10/services#Restful-Web-Services,
for the given controller api() the following example should be working:
$ curl -d name=Tim http://127.0.0.1:8000/myapp/default/api/friend.json
{errors: {}, id: 1}
1. The first line I think it
this part of the code works;
{{if auth.is_logged_in():}}{{for settings in
records:}}{{=db.settings[auth.user_id].fontsize}}{{pass}}{{else:}}{{=12}}px:}
but the preferences a logged in user makes seem to affect other users
setting.
On Sunday, September 1, 2013 4:43:27 AM UTC+1, viniciusban
Dear Massimo Di Pierro
Please i need your help , i have this problem which is about my sites admin
.
i installed web2py at centos and made configuration with zpanel anyhow
after time i figured out away to run web2py sites by making web2py folder
copy for each site and i replaced the site into
hello my code
if not auth.has_membership('admin'):
* db.trabalhador.val_formacao.writable=False*
form=SQLFORM(db.trabalhador,row.id,
showid=False,
submit_button=Gravar,
fields=['nome','bi','ncart','ncartval','rfid','apt_medica','apt_medicaval',*
Cut and paste from the book :
When a field is marked with writable=False, the field is not shown in
create forms, and it is shown readonly in update forms. If a field is
marked aswritable=False and readable=False, then the field is not shown at
all, not even in update forms.
Forms created with
Andrew, clear your IE cache and try downloading the file again, or rename
the file and then try downloading it. IE 9.0 will use the cache control
headers, so the file will be cached if you don't use the attachment
keyword. Look at line ~300 in the globals.py
On Tuesday, August 27, 2013
What i want to say and dont know why is that coding
*db.trabalhador.val_formacao.writable=False*
*db.trabalhador.val_formacao.readable=False*
*
*
*before my sqlform*
*
*
Results int the field beeing displayed and editable
That is not what i want
I want to hide the field in the form
2013/9/3
maybe this way:
select min(id), count(*), surname from table group by surname
?
On Tuesday, September 3, 2013 5:43:42 AM UTC-7, Johann Spies wrote:
On 3 September 2013 11:42, Bassem Bouguerra boug...@gmail.comjavascript:
wrote:
I am sorry. I am trying to groupby and not orderby.
I want
On Tue, Sep 3, 2013 at 12:47 PM, António Ramos ramstei...@gmail.com wrote:
shows the val_formação label only, no input text
Because Web2py shows readable fields as text, not as a readonly input field.
You see nothing probably because the field has no contents in this record.
--
---
You
2013/9/3 Richard Vézina ml.richard.vez...@gmail.com
Not sure I understand what you want to say here : shows the val_formação
label only, no input text
*Not sure I understand what you want to say here : shows the val_formação
label only, no input text*
*
*
i meant no editable input field in
On Tue, Sep 3, 2013 at 1:55 PM, António Ramos ramstei...@gmail.com wrote:
I want to hide the field in the form
So, don't include its name in fields list.
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and
That it's you need both in case you want to se the field input but prevent
your user to alter the value, you can set readonly=True in your SQLFORM()
call...
:)
Richard
On Tue, Sep 3, 2013 at 12:55 PM, António Ramos ramstei...@gmail.com wrote:
What i want to say and dont know why is that
ahHA!
I never use fields in SQLFORM didn't thought about this one...
Richard
On Tue, Sep 3, 2013 at 1:09 PM, Vinicius Assef vinicius...@gmail.comwrote:
On Tue, Sep 3, 2013 at 1:55 PM, António Ramos ramstei...@gmail.com
wrote:
I want to hide the field in the form
So, don't include its
auth !!
2013/9/3 António Ramos ramstei...@gmail.com
I have to include them in the field list because i have another line of
code to detect it
if aut.has_membership('admin')
show the field and allow it to be edited
else
Dont show the field( this is where i have the problem.
2013/9/3
You could create a kind of user_table_access_profile mechanism for each
table. You start by setting every fields to readable and writable false
then base on a user authentified you can switch field to true base on a
user_table_access_profile.
There is plenty of data structure you can use to store
I have to include them in the field list because i have another line of
code to detect it
if aut.has_membership('admin')
show the field and allow it to be edited
else
Dont show the field( this is where i have the problem.
2013/9/3 Vinicius Assef vinicius...@gmail.com
On Tue, Sep 3, 2013 at
uhm. apart from the technicalities of global_settings, shouldn't be better
to just import current and use current.request.folder as the base folder ?
On Tuesday, September 3, 2013 7:36:58 PM UTC+2, Jonathan Lundell wrote:
I have a module in my app's modules/ directory that needs a path to a
this doesn't return any other meaningful info about the id of the group, it
just uses an aggregate on it. In that case, you'd still need to orderby by
min(id).
tl;dr : any groupby query can be ordered either by a field included in a
group by or by an aggregate of any other column.
On Tuesday,
I have a module in my app's modules/ directory that needs a path to a file in
private/ at import time (so I can't pass the path in).
Using fileutils.abspath, I have to write:
abspath('applications', 'watchup', 'private', filename)
presumably because in abspath:
return
On 3 Sep 2013, at 10:36 AM, Jonathan Lundell jlund...@pobox.com wrote:
I have a module in my app's modules/ directory that needs a path to a file in
private/ at import time (so I can't pass the path in).
Using fileutils.abspath, I have to write:
abspath('applications', 'watchup',
On 3 Sep 2013, at 11:10 AM, Niphlod niph...@gmail.com wrote:
uhm. apart from the technicalities of global_settings, shouldn't be better to
just import current and use current.request.folder as the base folder ?
Yeah, that ought to work.
I wasn't thinking along those lines, I guess.
I try to create a new simple application on my local GAE instance (I
clicked 'run' in GAE since that's the only one that has admin). I get this
traceback:
Traceback (most recent call last):
File C:\Temp\web2py_src\web2py\gluon\admin.py, line 179, in app_create
os.mkdir(path)
File
BTW, AFAICT (As Far As I Can Tell :P), the abspath was only meant to have
easier code in admin. Docstring says
convert relative path to absolute path based (by default) on
applications_parent
application*s*_parent is the folder where the *applications/* folder is
(where web2py.py usually is),
On 3 Sep 2013, at 12:13 PM, Niphlod niph...@gmail.com wrote:
BTW, AFAICT (As Far As I Can Tell :P), the abspath was only meant to have
easier code in admin. Docstring says
convert relative path to absolute path based (by default) on
applications_parent
applications_parent is the folder
This issue is now fixed in trunk
2013-09-01
https://github.com/web2py/web2py/commit/085b4a0d15b173d84d92e2ed2b6db30923d2f643
Thanks Massimo
On Wednesday, August 7, 2013 12:57:14 PM UTC+2, step wrote:
Thank yOU for looking into this. Will you post a follow-up to this thread
or should I
On Tue, Sep 3, 2013 at 2:17 PM, António Ramos ramstei...@gmail.com wrote:
I have to include them in the field list because i have another line of code
to detect it
if aut.has_membership('admin')
show the field and allow it to be edited
So, just insert your field in this situation.
Make the
to flush the memory, import gc then call gc.collect()
On Monday, September 2, 2013 10:03:07 PM UTC-7, André Kablu wrote:
Hi all,
I'd created one application that loads 15 lines of a mysql database.
Then I put all 150k lines in a list(), doing many math calculations.
The results are
Given:
SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP BY
t1.t1_f1 ORDER BY max(t2.t2_f1), t1.t1_f1;
If I recall correctly in PostgreSQL you can do:
SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP BY
1 ORDER BY 2,1;
i.e. you can use the
It's not fixed for me. I've updated the issue.
On Thursday, August 29, 2013 8:14:56 PM UTC-5, Massimo Di Pierro wrote:
Should be fixed. Can you check?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and
jeditable is reasonably easy to work with for a cell at a time editing, and
works with SQLFORM.grids. Have played around with kendoui grids and their
editing is some of the nicest. Could put together some crude examples.
--
---
You received this message because you are subscribed to the
Hadn't heard of jeditable ... 'works with SQLFORM.grids' sounds good ...
crude examples or pointers would be good, particularly around communicating
updates (this is the big unknown for me).
On Wednesday, 4 September 2013 11:06:33 UTC+10, Simon Ashley wrote:
jeditable is reasonably easy to
I'm a newbie to web2py, but the book examples have gotten me a long ways,
and the forum (GG) has helped, also.
I have set up a pretty simple SOAP service, and have turned on Basic AUTH.
I get the correct results when the client provides the correct header, so
all that's good. But I'd like
I agree. I work with different designs and systems and the frameworks vary
greatly.
It would be nice to just let me select what I want.
Bootstrap 2.x
Bootstrap 3.x
Bare
Sass Based
etc...
On Tue, Sep 3, 2013 at 5:03 PM, José Ricardo Borba jrborba...@ig.com.brwrote:
+1.
Only for put more gas
On Monday, July 1, 2013 10:47:16 PM UTC+8, Ray (a.k.a. Iceberg) wrote:
On Monday, July 1, 2013 7:30:51 PM UTC+8, Ray (a.k.a. Iceberg) wrote:
Hi folks,
I just noticed that, the auto patterns generated by dal.py's
parse_as_rest() are using hyphen to replace underline. This way if I have:
57 matches
Mail list logo