On 8 October 2013 15:24, Niphlod niph...@gmail.com wrote:
the smartest thing to do would be to avoid orderby when there are less
records than paginate.
...
What we should orderby to then? The only assured field that has an implicit
index is the id (being a PK). Orderby(ing) a PK should
I found it.
It was in db.py
db.define_table('frame',
Field('framename', type='string',
# #unique=True,
the problem. Is it
a bug ?
label=T('Framename')),
On Fri, 4 Oct 2013 19:32:36 -0700 (PDT)
IVINH toa...@gmail.com wrote:
Nginx config:
In my case Nginx is setup as reverse-proxy and it dispatches reuqests to
gunicorn listening on local port.
routes_in = ((
(('.*http://demo.ivinh.com.* /*', '/demo')),
(('.*http://demo1.ivinh.com.* /*',
Great, thanks.
On Wednesday, October 9, 2013 3:38:19 AM UTC+3, Derek wrote:
I'm working on a new slice, I'll finish it up tomorrow and post it on
web2pyslices. It will do the standard cascaded dropdown lists... car /
make...
On Tuesday, October 8, 2013 5:21:41 PM UTC-7, Derek wrote:
If you have a properly clustered table, possibly a readonly table, you
don't need any orderby even paginating through the grid.
In any case if the grid needs ordering, it's up to the grid to take care of
it, not through a magic trick by the DAL.
Here I make the assumption that other people beside
Tim,
I suppose you should open a ticket about it. This behavior must be defined
and then wrote in the book.
2013/10/9 Tim Richardson t...@tim-richardson.net
In trunk, notice that a conditional model calling/calling_db.py
is loading before
db.py
This is not what 2.6.4 does; it loads
On Wed, 9 Oct 2013 09:51:35 +0200
Khalil KHAMLICHI
khamlichi.kha...@gmail.com wrote:
supposing you have the correct dns settings for those domaines, you
only need to modify the routes.py file located inside web2py
directory .
I did not find any existing routes.py file?
here is a working
On Wed, 9 Oct 2013 09:51:35 +0200
Khalil KHAMLICHI
khamlichi.kha...@gmail.com wrote:
hope this helps.
Ahh...forgot to restart gunicorn. :-(
All is well now or web2py rocks. ;)
Sincerely,
Gour
--
As the embodied soul continuously passes, in this body,
from boyhood to youth to old age, the
I have same problem (occasionally)
SO Debian 7 VPS
83.37.153.54.2013-10-09.08-47-01.c139aa5f-0503-4642-933c-a4b3460c70a0
Version web2py™ Version 2.6.4-stable+timestamp.2013.09.22.01.43.37
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
Traceback (most recent call last):
File
Hello,
one of the items on web2py's wish list is moving tickets from Google to
Github (https://trello.com/c/u9Iyz3B0/31-move-tickets-to-github).
It would be really nice to have the complete project at Github, so I
wonder if web2py noob can help somehow make it happen sooner than later?
Gour,
Could you find some literature to help accomplish the task? This would
help a lot.
mic
2013/10/9 Gour g...@atmarama.net
Hello,
one of the items on web2py's wish list is moving tickets from Google to
Github (https://trello.com/c/u9Iyz3B0/31-move-tickets-to-github).
It would be
On Wed, 9 Oct 2013 11:20:24 +0200
Michele Comitini
michele.comit...@gmail.com wrote:
Could you find some literature to help accomplish the task? This
would help a lot.
Something like this:
https://github.com/arthur-debert/google-code-issues-migrator ?
Sincerely,
Gour
--
Not by merely
+1
Seems good to me!
2013/10/9 Gour g...@atmarama.net
On Wed, 9 Oct 2013 11:20:24 +0200
Michele Comitini
michele.comit...@gmail.com wrote:
Could you find some literature to help accomplish the task? This
would help a lot.
Something like this:
Issue 1709
https://code.google.com/p/web2py/issues/detail?id=1709 (with demonstration
app and clear description of the problem)
On Wednesday, 9 October 2013 19:40:19 UTC+11, Michele Comitini wrote:
Tim,
I suppose you should open a ticket about it. This behavior must be
defined and then
Il 24/09/13 15:44, Ricardo Cárdenas ha scritto:
Hi Manuele,
Thanks for your email. (0,0) in effect represents two possible
outcomes: /I could not geocode this address/ and also /please try
again later/. How can I know if it makes sense to retry later?
best regards -Ricardo
Hi Ricardo,
if
SQLFORM.grid for laptops. Less white space, more data. Screen shot at end
of post.
in modules, create ui_def.py as follows:
# -*- coding: utf-8 -*-
def uidict():
return dict(widget='',
header='',
content='',
default='',
cornerall='',
Hey,
I am facing a little problem that my web2py setup is not setting the cookie
expiration time. So what happens is that the Firefox users get logged put
once they close their browser.
I want to set the cookie expiration time to a month or even more. Does
anybody know a solution?
Thanks,
Why would it be necessary then to do add the id of all the tables involved
in the query? My workaround is to specify the orderby using the id of one
of the involved tables and that already makes a big difference measured
against a query trying to use three or four fields when ordering.
On Wednesday, October 9, 2013 4:22:26 AM UTC-4, Michele Comitini wrote:
If you have a properly clustered table, possibly a readonly table, you
don't need any orderby even paginating through the grid.
My understanding is that having a clustered index does not guarantee a
consistent ordering
Very useful! 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 received this message because you are subscribed to the Google Groups
yes. not supported
On Tuesday, 8 October 2013 06:31:55 UTC-5, Tim Richardson wrote:
It seems that I can't use aggregate functions to create a column in a
SQLFORM.grid (because I can specify only a query, not a set)
Is this correct?
I want to select patients with max visit date in a
Thanks for your reply
On Tuesday, 8 October 2013 02:47:48 UTC+5:30, Anthony wrote:
web2py does not have an ORM (object relational mapper), so you won't be
creating classes to define models. Instead, web2py has a DAL (database
abstraction layer). Different conceptualization/implementation,
The class * RequestHandler* (tornado 3.1.1) has e new function *
_When_complete* that is called by the function *_execute*.
--v--
def _execute(self, transforms, *args,
Hello everybody
First of all to avoid this question: Yes I copied the appadmin and
javascript file from the welcome app to my own app ;-)
My Problem is, that some LOAD(ajax=True) doesn't work any-more (but not all
loads with ajax). If I change it to LOAD(ajax=False) it works. So it seems
I realize grid is complicated enough as it is. But I would love this:
def grid(
query,
tbody=None,
...)
...
if tbody:
# call it if it's a function
# Insert if not
else:
# build rows as usual
...
)
On Tuesday, October 8, 2013 7:31:55
All working now, Thanks Niphlod...
-Jim
On Tuesday, October 8, 2013 4:49:30 PM UTC-5, Jim S wrote:
Niphlod - once again you have decoded my poorly worded question and given
me the solution. Yes, I'm talking about checkboxes and refreshing the
second grid in a separate component. I will
There is a problem with sorting of model subfolders in 2.7.2. We made some
changes in trunk. Please help me check that:
[ ] if you have a byte-compiled app, it still runs fine
[ ] if you byte-compiler an app with trunk, it runs fine
[ ] models are executed in this order:
models/*.py
Hi All,
I'm not sure that this is exactly a web2py question, but it seems like this
is where the smart people hang out so I'll post here in hopes of some help.
I am trying to execute a command like this from within a web2py page:
ssh pi@remotehost.local /etc/scripts/script.sh parameter1
You need to copy web2py.js from the latest welcome app into your old app.
On Wednesday, 9 October 2013 04:57:20 UTC-5, Michael Helbling wrote:
Hello everybody
First of all to avoid this question: Yes I copied the appadmin and
javascript file from the welcome app to my own app ;-)
My
?
On Wednesday, 9 October 2013 09:21:41 UTC-5, Cliff Kachinske wrote:
I realize grid is complicated enough as it is. But I would love this:
def grid(
query,
tbody=None,
...)
...
if tbody:
# call it if it's a function
# Insert if not
I try set parameters for mandrillapp.com:
mail.settings.server = 'smtp.mandrillapp.com:587'
mail.settings.sender = 'mirek@zvol...@gmail.com'
mail.settings.login = 'mirek@zvol...@gmail.com:my_API_key_here'
F.e. Request_reset_password will write mail sent. However it doesn't work.
With
Here f.e. settings from Heroku - domain heroku.com is parametr here:
ActionMailer::Base.smtp_settings = {
:port = '587',
:address ='smtp.mandrillapp.com',
:user_name = ENV['MANDRILL_USERNAME'],
:password = ENV['MANDRILL_APIKEY'],
:domain =
Should'd grid elements be ordered to allow pagination?
On Oct 8, 2013, at 6:45 PM, Michele Comitini wrote:
Whenever there is a big performance impact it's better not to make
assumptions on what is the most common use case.
I hate to hear the web2py is slow refrain because it's false if you
Hello Massimo and list members
I'm sociologist from Colombia. technology entusiastic and have a server
for humanitarian and professional purposes.
I have an entry question and a second one is about my technical
difficulties
First Almost a month ago I knew web2py and I liked it a lot!!!, and
Hello Miguel,
I am sorry you are having problems with Apache.
First of all let me say that web2py requires programming. If you prefer to
use a system that does not require programming like Joomla and if that
works for you, that use Joomla. If instead you require programming (for
example you
On Wednesday, October 9, 2013 8:05:47 PM UTC+2, Massimo Di Pierro wrote:
Should'd grid elements be ordered to allow pagination?
definitely. assuming a set where
1 a
2 b
3 c
4 d
you need a way to tell the backend that you want only the first two
records. With no explicit ordering,
really more a question on mandrill than web2py.
http://help.mandrill.com/entries/23744737-Where-do-I-find-my-SMTP-credentials-
On Wednesday, October 9, 2013 7:28:49 PM UTC+2, Mirek Zvolský wrote:
Here f.e. settings from Heroku - domain heroku.com is parametr here:
I'd almost publish a plugin for it :P
On Wednesday, October 9, 2013 3:30:03 PM UTC+2, stefaan wrote:
Very useful! 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
on the other end, we never crossed the discussion about the fact that
posting an issue to google code requires no signup like posting an issue on
github, and that you can't add attachments to github issues.
On Wednesday, October 9, 2013 12:18:57 PM UTC+2, Michele Comitini wrote:
+1
Seems
sorry for being late. This is from web2py's 2.6.0 changelog.
Attention MySQL users: The length of string fields changed from 255 to 512
bytes. If you have migrations enabled this will trigger a large migration.
To prevent it, first set migrate_enabled=False, upgrade, check everything
is ok,
It's up...
http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified
I'm not sure if it's using the web2py best practices, and I did write it on
2.5.1 so I don't know if it would work with the latest version (I assume
so). In any case, it's the most basic way to do it, and it
On Wednesday, October 9, 2013 6:13:58 AM UTC-7, Anthony wrote:
On Wednesday, October 9, 2013 4:22:26 AM UTC-4, Michele Comitini wrote:
If you have a properly clustered table, possibly a readonly table, you
don't need any orderby even paginating through the grid.
My understanding is that
On Wednesday, October 9, 2013 11:05:47 AM UTC-7, Massimo Di Pierro wrote:
Should'd grid elements be ordered to allow pagination?
Yes, if you are going to scroll through a window of results, your rows 10 -
20 can change depending on the order returned by the database. If you don't
specify
On Wed, 9 Oct 2013 11:44:28 -0700 (PDT)
Niphlod niph...@gmail.com wrote:
on the other end, we never crossed the discussion about the fact
that posting an issue to google code requires no signup like posting
an issue on github, and that you can't add attachments to github
issues.
Well, then
is web2py running under user pi?
On Wednesday, October 9, 2013 9:57:00 AM UTC-5, Jason Gray wrote:
Hi All,
I'm not sure that this is exactly a web2py question, but it seems like
this is where the smart people hang out so I'll post here in hopes of some
help.
I am trying to execute a
Well, then the answer is Bitbucket which on top of that provides
downloads as well. ;)
What downloads ?
--
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
On Wednesday, October 9, 2013 5:51:11 AM UTC-7, Cliff Kachinske wrote:
SQLFORM.grid for laptops. Less white space, more data. Screen shot at end
of post.
How are you detecting a laptop? Are you basing this on the user agent
screen size?
/dps
in modules, create ui_def.py as follows:
On Wed, 9 Oct 2013 12:56:49 -0700 (PDT)
Niphlod niph...@gmail.com wrote:
What downloads ?
E.g. http://tortoisehg.bitbucket.org/download/index.html
But now I see that it seems Github has brought the feature back. :-)
Sincerely,
Gour
--
Many, many births both you and I have passed. I can
On Tuesday, October 8, 2013 11:23:31 AM UTC-7, Niphlod wrote:
On Tuesday, October 8, 2013 7:36:45 PM UTC+2, Dave S wrote:
On Monday, October 7, 2013 11:45:14 PM UTC-7, Niphlod wrote:
I think you just need to ctrl+f5 reloading the cache of the browser. If
anyone isn't able to edit files
Dave S
Not at all. I'm ignoring handhelds right now and assuming desktop users
will also appreciate the extra space.
On Wednesday, October 9, 2013 4:05:32 PM UTC-4, Dave S wrote:
On Wednesday, October 9, 2013 5:51:11 AM UTC-7, Cliff Kachinske wrote:
SQLFORM.grid for laptops. Less white
Niphlod,
Maybe I almost will. :)
On Wednesday, October 9, 2013 2:41:16 PM UTC-4, Niphlod wrote:
I'd almost publish a plugin for it :P
On Wednesday, October 9, 2013 3:30:03 PM UTC+2, stefaan wrote:
Very useful! Thanks.
--
Resources:
- http://web2py.com
- http://web2py.com/book
does it happen only on opera? if yes, what build on what os ?
On Wednesday, October 9, 2013 10:20:49 PM UTC+2, Dave S wrote:
On Tuesday, October 8, 2013 11:23:31 AM UTC-7, Niphlod wrote:
On Tuesday, October 8, 2013 7:36:45 PM UTC+2, Dave S wrote:
On Monday, October 7, 2013 11:45:14 PM
yep, lot of peoples (me included) switched to hosting binaries on
bitbucket. I assume they noticed and they got the feature back (kind of)
letting releases to include binaries.
On Wednesday, October 9, 2013 10:15:48 PM UTC+2, Gour wrote:
On Wed, 9 Oct 2013 12:56:49 -0700 (PDT)
Niphlod
Good point -- perhaps orderby_on_limitby should default to False -- then
the grid can simply set it to True. Actually, I wonder if the grid should
go further and additionally order on primary keys even when an explicit
orderby is specified (just in case the orderby field(s) do not contain
On Wednesday, October 9, 2013 1:34:11 PM UTC-7, Niphlod wrote:
does it happen only on opera? if yes, what build on what os ?
Seems to happen on Firefox 18 on Fedora 16, but the CTRL-F5 works without
requiring an F5 after.
Opera is 12.16 Build 1860 , and it describes the OS as i686,
On Wednesday, October 9, 2013 1:21:09 PM UTC-7, Cliff Kachinske wrote:
Dave S
Not at all. I'm ignoring handhelds right now and assuming desktop users
will also appreciate the extra space.
Okay.
/dps
On Wednesday, October 9, 2013 4:05:32 PM UTC-4, Dave S wrote:
On Wednesday, October
You have a point, if it's a grid or smartgrid, and paging is enabled, it
should be sorted by the developer's preference, and secondly by the primary
key, whether that's an ID or something else.
On Wednesday, October 9, 2013 1:41:04 PM UTC-7, Anthony wrote:
Good point -- perhaps
Just to avoid confusion, when I say clustered I am talking about
postgresql. See:
http://www.postgresql.org/docs/current/interactive/sql-cluster.html
2013/10/9 Derek sp1d...@gmail.com
You have a point, if it's a grid or smartgrid, and paging is enabled, it
should be sorted by the
If you have a properly clustered table, possibly a readonly table, you
don't need any orderby even paginating through the grid.
Maybe. It appears that will only work if there is a covering index used in
the query. I don't think Web2Py specifies which indexes are used for a
query, so even if
I just downloaded sourcecode today 10/09/2013. Running on Windows 7 with 64
bit python, I get following error message.
Does anyone else have this issue? Any suggestions for where to get started?
Jarrod
Python 2.7.3 |EPD_free 7.1-2 (32-bit)| (default, Aug 8 2013, 05:30:12)
[MSC v.1
500
Why is a light purple hat $2 less than a white one?
On Tuesday, October 8, 2013 5:42:10 AM UTC-7, Adi wrote:
hmm... it's a broad question, so please ask anything more specific and
i'll be glad to answer.
Here are some of my observations...
What was important to me, were speed, mobile
Make sure you install this:
http://sourceforge.net/projects/pywin32/
On Wednesday, October 9, 2013 3:20:10 PM UTC-7, jarrodwilcox wrote:
I just downloaded sourcecode today 10/09/2013. Running on Windows 7 with
64 bit python, I get following error message.
Does anyone else have this issue?
:)
There are only few hats left in this color, so they are just on small
special now, but we also send absolutely free hat to anyone who's going
through chemotherapy
http://nammuhats.com/page_view/6/Chemotherapy-Hatstreatment.
On Wed, Oct 9, 2013 at 6:26 PM, Derek sp1d...@gmail.com wrote:
Why
Hello everybody.
This happens both in development environment as in staging environment.
If someone can help me...
Thanks!
On Wed, Oct 9, 2013 at 2:34 AM, __pyslan__ - Ayslan Jenken
ayslan.pyt...@gmail.com wrote:
Massimo, the strange behavior continues to occur...
I had to make a
Is this an upgrade? Did it work before?
On Wednesday, 9 October 2013 17:20:10 UTC-5, jarrodwilcox wrote:
I just downloaded sourcecode today 10/09/2013. Running on Windows 7 with
64 bit python, I get following error message.
Does anyone else have this issue? Any suggestions for where to
When using SQLTABLE (or something like: {{=query_results}}) to display rows
in a view, foreign key fields display data from their related table.
Is web2py doing individual queries for each of these fields?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
It looks like in a DAL callback, the original values of the record are not
available?
So I would need to do read the old row from the database to get the old
values of the row to determine if the value of a field has changed?
Thanks.
On Monday, October 7, 2013 10:35:25 AM UTC-10, Niphlod wrote:
I'm pretty new to web2py, so I'm probably making a silly mistake. In any
case, the error goes something like this:
In db.py, I have something like
db.define_table(my_table,
Field(name),
Field(the_date,
Just wanted to chime in on this.
For me, I had to add a length=255 to all my unique=True fields, even
after adding length=255 for the string fields.
On Wednesday, October 9, 2013 11:46:48 AM UTC-7, Niphlod wrote:
sorry for being late. This is from web2py's 2.6.0 changelog.
Attention MySQL
Field(the_date,
requires=IS_EMPTY_OR(IS_DATE()),
widget=SQLFORM.widgets.date.widget),
should be
Field('the_date',type='date')
the requires and the widget are default.
On Wednesday, 9
hi,
i realize that in the new version of web2py 2.7.x the field show in grid is
not sequential without explicit it in the fields.
e.g.
models/db.py
db.define_table('model',
Field('model'),
Field('brand', 'reference brand'),
Field('product_number'),
format='%(model)s')
It depends. It may.
For example given:
db.define_table('person',Field('name'),format='%(name)s')
db.define_table('dog',Field('name'),Field('owner','reference dog'))
if you do:
SQLFORM.grid(db.dog.owner==db.person.id)
it will do a recursive select for each row to find a representation of
had you already take a look record versioning?
taken from book :
Record versioning
_enable_record_versioning
It is possible to ask web2py to save every copy of a record when the record
is individually modified.
so if you combine record versioning, auth signature that have modified date
field
We have to use tables from sql server (aspnet_user and aspnet_membership)
for our authentication.
So we've extended Auth like this
from gluon.tools import Auth
def MyNewAuth
...
# we copied the Login method from Auth to here
...
# use the following code to decipher the password from
Massimo, Derek
Thanks for replies!
This is a new installation of latest web2py version. I have had the
earlier web2py versions working from sourcecode for some time. However,
win32 was installed from Mark Hammond's site for another project since I
last used web2py. Both pywin and win32
Actually, you must understand Auth to extend it.
Mainly to authenticate user and put its data on session (login).
You don't need to make an Auth subclass, but compose a solution doing
the same thing.
Or you can think about login_bare, too.
On Wed, Oct 9, 2013 at 11:22 PM, GregD
I'm trying to shorten the url from something like:
www.example.com/myapp/default/index?page=1
to
www.example/com/index?page=1
I'm using pagination on the index page, so that's why you see the ?page=1
My routes.py is pretty standard:
routers = dict(
# base router
BASE=dict(
77 matches
Mail list logo