I am making a widget with more fields that must return a single value
when form is submitted.
I have two way (I suppose..): to use javascript at the submit event of
specific form (I need form id) or/and to put
validation code in widget function.
The better should be have code to study to discover t
I'm redirecting from a function as:
redirect(URL(r = request, f = 'testingargs', args = arglist ))
At "testingargs" function, I'm getting "underscores" for arguments
(request.args(0)) if there are any spaces in arguments. Is there a way
to receive arguments without getting these underscores ?
red
Hi All,
I have 2 tables in an one2many relation. Table "config" has a
selfreference.
approval.define_table("config",
SQLField("name", "string", notnull=True),
SQLField("parent", 'reference config'))
approval.define_table("recipe",
SQLField("name", "string", n
No success.
Here's what I tested in the controller:
* All these alternatives result in an input text with the integer value of
opportunity_id being rendered:
1) db.task.opportunity_id.represent=lambda opportunity_id:
opportunity_id.oppy_main_id.name
2) db.task.opportunity_id.represent=lambda oppor
I am trying to build a complex widget that mixes helpers (an INPUT
helper) and plain html code that include others input tags used by
javascript.
It output all by (DIV object).components.extend([...,...]).
It is all ok when SQLFORM.factory displays it, but fail when I accept
the form:
Solved it using this:
arglist = "page = 0" + "&orderpref=" + "None" + "&agent=" + str
(form.vars.agent) + \
"&fsource=" + str(form.vars.fsource) +
"&fromdate=" + str
(form.vars.fromdate) + "&to=" + str(form.vars.to)
redirect(URL(request.application, 'defaul
In the controller I have the code:
form = SQLFORM(db.plugin)
#sets a non-editable form value to an editable form value. There
is then a DB validator which converts it into a proper slug
form.vars.slug = form.vars.name
if form.accepts(request.vars, session):
My problem is that I
You need web2py 1.74.6
approval.define_table("config",
SQLField("name", "string", notnull=True),
SQLField("parent", 'reference config'),
format = lambda r:"%s [%s]" % (r.name,r.parent.name))
approval.define_table("recipe",
SQLField("name", "string",
You have Field('name',type=None) and this cannot be.
On Jan 14, 7:35 am, leone wrote:
> I am trying to build a complex widget that mixes helpers (an INPUT
> helper) and plain html code that include others input tags used by
> javascript.
> It output all by (DIV object).components.extend([...,...]
ahhh!
redirect(URL(request.application, 'default', 'searchpurchaseresults',
vars=dict(page=0,orderpref='None',agent=form.vars.agent,
fsource=form.vars.fsource,
fromdate=form.vars.fromdate,
to=form.vars.to)))
>
accepts(...,onaccept=lambda form:do_something(form))
On Jan 14, 2:24 am, "Logan (LK)" wrote:
> In the controller I have the code:
>
> form = SQLFORM(db.plugin)
>
> #sets a non-editable form value to an editable form value. There
> is then a DB validator which converts it into a proper slu
Ach! Thanks. Now it runs.
leone
On 14 Gen, 15:13, mdipierro wrote:
> You have Field('name',type=None) and this cannot be.
>
> On Jan 14, 7:35 am, leone wrote:
>
>
>
> > I am trying to build a complex widget that mixes helpers (an INPUT
> > helper) and plain html code that include others input ta
'represent' is used for output type fields.
I believe you should be trying with a widget to get the SELECT you
want.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe fro
I would be nice if someone could port this php backended upload panel:
http://filetree.extjs.eu/
-wes
On Wed, Jan 13, 2010 at 7:33 PM, Yannick wrote:
> Hello mate,
> I just wonder if there is an example of several upload file (all at
> once a little bit like gmail attachment files) with Web2py
What is the best solution to automatically calculate a total field?
db.define_table ('order_detail',
Field('product_name'),
Field('qtd', 'integer'),
Field('price', 'integer'),
Field('total', 'integer', writable=False)
)
Where total = qtd *
with 1.74.5 and later you only need
db.order_detail.total.compute=lambda r: r['qtd']*r['price']
On Jan 14, 8:51 am, Alexandre Andrade
wrote:
> What is the best solution to automatically calculate a total field?
>
> db.define_table ('order_detail',
> Field('product_name'),
>
Is web2py suitable if I want to work with large datasets?
I am currently developing a database and want to use web2py to make it
available to the client.
Up to now I was using the shell and appadmin interfaces to the databasis.
When trying out the webgrid-slice from
http://www.web2pyslices.com/m
You can improve your example with
query = (db.advertisement.owner==auth.user.id)
links = db(query).select(orderby=db.advertisement.posted_on)
for b in links:
query=(db.published.advertisement_id==b.id)
res = db(query).select()
for a in res:
print a.mag_id
bu
What is the equivalent in DAL for
l = db.executesql("select id from artikel limit 10;")
Regards
Johann
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group,
I think all the problems arise from the fact that you do:
IS_IN_DB(db(db.opportunity.id==db.task.opportunity_id),...)
this is a join and you cannot do a JOIN in a validator because you are
referencing one table, not the temp table result of a join.
Parhaps this is what you want:
db.task.opp
Thanks, very nice.
2010/1/14 mdipierro
> with 1.74.5 and later you only need
>
> db.order_detail.total.compute=lambda r: r['qtd']*r['price']
>
> On Jan 14, 8:51 am, Alexandre Andrade
> wrote:
> > What is the best solution to automatically calculate a total field?
> >
> > db.define_table ('ord
The web2py DAL sipmly provides an interface to your database. There is
no overhead that depends on the size of your dataset. If you database
can handle it, web2py can.
There are exceptions. For example the requires=IS_IN_DB(..,) validator
builds an in-memory list of all the references in order to
l = db().select(db.artikel.id,limitby=(0,10))
On Jan 14, 9:19 am, Johann Spies wrote:
> What is the equivalent in DAL for
>
> l = db.executesql("select id from artikel limit 10;")
>
> Regards
> Johann
--
You received this message because you are subscribed to the Google Groups
"web2py-users" gr
Hi, I believe it is:
db().select(db.artikel.id, limitby=(0, 10))
See ya.
--
On Thu, Jan 14, 2010 at 3:19 PM, Johann Spies wrote:
> What is the equivalent in DAL for
>
> l = db.executesql("select id from artikel limit 10;")
>
> Regards
> Johann
>
> --
> You received this message because you
Thanks - also for your answer on my other question about large datasets.
2010/1/14 mdipierro :
> l = db().select(db.artikel.id,limitby=(0,10))
>
> On Jan 14, 9:19 am, Johann Spies wrote:
>> What is the equivalent in DAL for
>>
>> l = db.executesql("select id from artikel limit 10;")
>>
>> Regards
db.order_detail.total.compute=lambda r: r['qtd']*r['price']
don't work on updates
2010/1/14 mdipierro
> with 1.74.5 and later you only need
>
> db.order_detail.total.compute=lambda r: r['qtd']*r['price']
>
> On Jan 14, 8:51 am, Alexandre Andrade
> wrote:
> > What is the best solution to autom
Make sure Field(...,default=None, update=None)
On Jan 14, 9:47 am, Alexandre Andrade
wrote:
> db.order_detail.total.compute=lambda r: r['qtd']*r['price']
>
> don't work on updates
>
> 2010/1/14 mdipierro
>
>
>
> > with 1.74.5 and later you only need
>
> > db.order_detail.total.compute=lambda r:
still don't work. The value before still mantains.
Maybe I have to drop the column and create it again?
2010/1/14 mdipierro
> Make sure Field(...,default=None, update=None)
>
> On Jan 14, 9:47 am, Alexandre Andrade
> wrote:
> > db.order_detail.total.compute=lambda r: r['qtd']*r['price']
> >
>
def user():
return dict(form=auth())
Locally using SQLite or dev_appserver I can login to my application.
When I upload to GAE logging in silently fail, I am redirected from
init/default/user/login to init/default/index and no jquery flash
message appears. No log entries are added to GAE.
In
What is the difference between represent and format?
-Thadeus
On Thu, Jan 14, 2010 at 8:11 AM, mdipierro wrote:
> You need web2py 1.74.6
>
> approval.define_table("config",
>SQLField("name", "string", notnull=True),
> SQLField("parent", 'reference config'),
>
> ahhh!
AH!
-Thadeus
On Thu, Jan 14, 2010 at 8:16 AM, mdipierro wrote:
> ahhh!
>
> redirect(URL(request.application, 'default', 'searchpurchaseresults',
> vars=dict(page=0,orderpref='None',agent=form.vars.agent,
> fsource=form.vars.fsource,
Can you please run a test to better identify the problem. Can you
register a new user and try login as the new user? Same problem?
On Jan 14, 11:01 am, Carl wrote:
> def user():
> return dict(form=auth())
>
> Locally using SQLite or dev_appserver I can login to my application.
> When I upload
In one of my controller actions required to get the exact EXCEPTION
raised by postgreSQL function. How could I fetch the RAISE EXCEPTION
error using psycopg (or the connection cursor)?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to th
I am not sure I understand. If the exception is raised by the database
(postgresql), the driver catches it and re-raises it usually as a
OperationalError. You need to look into psycopg2 documentation. Web2py
does not capture the exception raised by the driver (except in the
case of failure to inser
It don't show at form, without readable=False.
I set readable=False, but it don't show the updated value.
2010/1/14 mdipierro
> Can you also try set readable=False?
>
> On Jan 14, 9:52 am, mdipierro wrote:
> > Make sure Field(...,default=None, update=None)
> >
> > On Jan 14, 9:47 am, Alexandre
Field('valor_total','double', default=None, update=None, readable=False),
db.cronograma_desembolso.valor_total.compute=lambda r:
r['valor_custeio_concedente']+ r['valor_investimento_concedente'] +
r['valor_custeio_contrapartida']+ r['valor_investimento_contrapartida']
(one line above)
2010/1/14
I see the problem. I can find a way around it but I feel it would be
wrong.
When you submit a form, what you see is what should go in the DB, even
if some fields are readonly.
If you have quantity, price and total you should not display the same
total that is in DB before submission as readonly,
Did you ever try register and login locally with dev-appserver before
uploading on GAE? Perhaps some index is missing and by running
locally, it would re-create the missing index.
Anyway, the behavior is strange and I do not fully understand it.
Could you email me the app?
On Jan 14, 12:42 pm, Ca
1. The total is not showed when editing. I don't need in this moment. When I
set .compute, its hide (like writable=False and readable=False) the field in
the form.
2. the main problem is .compute is not inserting/updating the field on db,
and neither acting as represent when showing
2010/1/14 md
Try Field('total','double') (compute=None, writable=True,
readable=True) and
jQuery("input[name='quantity'],input[name='price']").keyup(function()
{
jQuery("input[name='total']").val(parseFloat(jQuery("input
[name='price']").val())*parseInt(jQuery("input[name='quantity']"));
});
Use firebug in to
Solved without jquery
if form.accepts(request.vars, session):
row = db.cronograma_desembolso[form.vars.id]
total = row.valor_custeio_concedente +
row.valor_investimento_concedente + row.valor_custeio_contrapartida +
row.valor_investimento_contrapartida
> Different names help avoid confusion (or so I hoped).
huh...
Why not use the builtin __str__ or __unicode__ of the class to serve as
representation or "format" ?
-Thadeus
On Thu, Jan 14, 2010 at 12:38 PM, rfx_labs wrote:
>
> > db.define_table(...,format=...) goes into db.table._format
OK. You can also do:
if form.accepts(request.vars, session,
onvalidation=lambda form: form.vars.valor_total =
form.vars.valor_custeio_concedente +
form.vars.valor_investimento_concedente +
form.vars.valor_custeio_contrapartida +
form.vars.valor_investimento_contrapartida):
which is 2 db qu
because these method of the field object used to represent a field
value, not to represent the field object themself.
there is a __str__ and that is used to represent the field object.
one think is
>>> print db.table.field
another is
>>> print db.table.field.represent(row.field)
On Jan 14, 2:
A message for those people who would like to assist with the Haitian
earthquake response in a technical capacity. Please assist with SahanaPy's
deployment for orgs responding to the Haitian earthquake.
*Motto of story*
Visit #sahana in irc freenode.
*Objective*
We are building a registry of respo
I cloned web2py and write 2 functions for that
http://code.google.com/r/pihentagy-web2py/source/list
You can use those classes like that:
Field('invoice_date','date',
requires=IS_DATE_IN_RANGE(minimum=datetime.date.today(),
format='%d/%m/%Y')),
Field('settlement_date','datetime',
requires=
I went into each corner of my app on dev_appserver and then uploaded to GAE
but this didn't change the login behaviour.
Let me rebuild my app part by part from a skeleton and find the smallest app
that breaks. If I don't figure it out from that I can send you the app that
works and the app that br
Can you register and login in the Welcome app? that should be the
first test.
On Jan 14, 3:43 pm, Carl wrote:
> I went into each corner of my app on dev_appserver and then uploaded to GAE
> but this didn't change the login behaviour.
>
> Let me rebuild my app part by part from a skeleton and find
Inspired by Phyo Arkar's howto on setting up web2py with Cherokee and
FCGI I tried the setup, but was somewhat unsatisfied with the fcgi
method and decided to try uWSGI. I am happy I did so, since it proved
to be real easy and uWSGI is a real powerhouse and deserves attention
of the whole python we
Can you post a list of specific tasks that need to be completed?
Massimo
On Jan 14, 3:28 pm, Tim McNamara wrote:
> A message for those people who would like to assist with the Haitian
> earthquake response in a technical capacity. Please assist with SahanaPy's
> deployment for orgs responding to
On Jan 14, 10:15 pm, mdipierro wrote:
> Can you post a list of specific tasks that need to be completed?
Hi Massimo, it's here:
> > If you have JQuery ot web2py experience, please visit
> > http://trac.sahanapy.org/wiki/Haiti.
The best use of your skills would be this one:
* Change Password R
Wes James sent me a patch for that some time ago but I lost it. I will
try retrieve and apply immediately (assuming I find it or he resends
it to me)
Massimo
On Jan 14, 4:20 pm, Fran wrote:
> On Jan 14, 10:15 pm, mdipierro wrote:
>
> > Can you post a list of specific tasks that need to be compl
yes I can login successfully using Welcome so that does help narrow it down.
I start the skeleton build tomorrow!
all the best
2010/1/14 mdipierro
> Can you register and login in the Welcome app? that should be the
> first test.
>
> On Jan 14, 3:43 pm, Carl wrote:
> > I went into each corner o
Hello:
I have a problem, I do not know if this is a bug or I'm making
something wrong!!! I add this:
auth=Auth(globals(),self.db)
auth.define_tables()
mail=Mail() # mailer
mail.settings.server='localhost:25'# your SMTP server
I would also find this useful - an example that uploads 0-N files with
a button to add additional upload inputs.
On Jan 15, 5:12 am, Yannick wrote:
> gmail was just an example... Just to explain what I meant...
> I basically looking for an example to upload several file at once
> (Compatible und
It is a bug but it is strange this has never shoed up before. Fixing
in trunk.
On Jan 14, 4:51 pm, "b-global.net" wrote:
> Hello:
>
> I have a problem, I do not know if this is a bug or I'm making
> something wrong!!! I add this:
>
> auth=Auth(globals(),self.db)
> auth.define_tabl
Here's the thread:
http://groups.google.com/group/web2py/browse_thread/thread/f43363e7c398f0a4/324ad7226080aa8e
you had some concerns about my implementation using an extra key field.
-wes
On Thu, Jan 14, 2010 at 3:41 PM, mdipierro wrote:
> Wes James sent me a patch for that some time ago but
working on it Thanks.
On Jan 14, 5:13 pm, Wes James wrote:
> Here's the thread:
>
> http://groups.google.com/group/web2py/browse_thread/thread/f43363e7c3...
>
> you had some concerns about my implementation using an extra key field.
>
> -wes
>
> On Thu, Jan 14, 2010 at 3:41 PM, mdipierro wro
Thank you Massimo, for all your help!!!
Can I help to fix this bug?
Also, can I use other email function/class with Auth ?
Thank you.
Best Regards,
Victor
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to
On Jan 12, 8:02 pm, mdipierro wrote:
> I know thay have Financial Assistantships but I guess they are mostly
> for students.
> They have different rates for hobbists and professionals. The main
> discount was for early registration but the deadline has passed.
Financial Assistance is _not_ just f
It is already fixed in trunk because of other changes the trunk needs
some testing.
It would be of great help if you could test if this problem is gone
and auth still works.
On Jan 14, 5:38 pm, "b-global.net" wrote:
> Thank you Massimo, for all your help!!!
>
> Can I help to fix this bug?
>
> Al
OK. This is done. The solution is very much based on Wes James patch.
I took the time to clean up tools.py so I hope I did not introduce new
bugs but it is possible.
Now bare this me. The convention is a bit complex but we want:
- keep backward compatibility
- allow people to use the new reset_pa
I follow this:
http://www.web2py.com/AlterEgo/default/show/239
Installing web2py with MySQL on a bare CentOS 5 machine
Because we work with Red Hat Enterprise Linux 5.
When I run web2py. I see this:
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2010
Version 1.74.6
Never seen this before. which web2py version?
Can you try delete everything in the cache folder of your application?
On Jan 14, 7:16 pm, drayco wrote:
> I follow this:
>
> http://www.web2py.com/AlterEgo/default/show/239
> Installing web2py with MySQL on a bare CentOS 5 machine
>
> Because we wor
I slightly changes the behavior in trunk about his.
The problem is corrupted cache file. So instead of failing, it will
now just log the failure to open the file. You will get an error only
if you actually try to use the cache.disk and the file is corrupted.
We still need to understand how this c
You probably will not see that at pycon. All web2py talks have been
rejected.
On Jan 13, 10:11 pm, Jeff Bauer wrote:
> If work will let up long enough, I hope to attend ... the
> reason I couldn't take advantage of pre-registration discount.
> Assuming I'll be there (60%+), I'd like to see what o
I tried this. Got it to send me a link:
Click on the link
http://127.0.0.1:8000/app/default/user/reset_password?key=1263524904-9fbb5bd1-f0cd-4a1c-ace7-7febaf37e09f
to reset your password
I click on the link and then it takes me back to the reset password page.
(what's the best way to change t
Hi,
I just installed a new application into Web2Py (haiti-py), but I got
"Invalid Request" when I tried to run the application. It also didn't
appear on the list of applications on http://127.0.0.1:8000/admin/default/site.
However when I took out the hyphen it worked fine.
I'm using Windows XP, f
hyphens are not allowed in web2py urls.
if you call your app haiti_py, you should be able to access it as
haiti-py
Massimo
On Jan 14, 9:27 pm, Michael Howden wrote:
> Hi,
> I just installed a new application into Web2Py (haiti-py), but I got
> "Invalid Request" when I tried to run the applicati
I suggest we move the discussion to another thread and we stop this
one. Feel free to open another thread. If will not be able to fix the
redirect problem tonight. If you find a fix, plese send it to me or I
will fix it tomorrow.
Massimo
On Jan 14, 9:13 pm, Wes James wrote:
> I tried this. Got
Hi All,
PyCon Asia Pacific is happening soon in Singapore. http://apac.pycon.org
Massimo,
I came to know yesterday that you are on the Programme Team. So, are
you planning to come down to SG in June? Submitting any papers?
http://pycon.sit.rp.sg/organizing-committee-1
Yesterday at the PUGS, the
I doubt I will be able to attend but I do not know yet for sure.
Massimo
On Jan 14, 11:08 pm, Anand Vaidya wrote:
> Hi All,
>
> PyCon Asia Pacific is happening soon in Singapore.http://apac.pycon.org
>
> Massimo,
>
> I came to know yesterday that you are on the Programme Team. So, are
> you plan
WebGrid can handle large datasets as it limits the query by the page
size if the datasource is a Set or Table(s). The performance hit will
come in when the filter row is enabled since each filter is a query
for all distinct values in a field. I would try disabling the filter
row with:
grid.enable
which web2py version? 1.7.6
Can you try delete everything in the cache folder of your application?
No, I just Install and I try to run it for the first time
I try to use the embeded web server
I reviewed the folder web2py/applications/welcome/database/ and it is
empty
Maybe the lib for sqlite doe
Do they ever give reasons for the talks being rejected? Just curious.
On Jan 14, 9:28 pm, mdipierro wrote:
> I doubt I will be able to attend but I do not know yet for sure.
>
> Massimo
>
> On Jan 14, 11:08 pm, Anand Vaidya wrote:
>
>
>
> > Hi All,
>
> > PyCon Asia Pacific is happening soon in
Wow very Django heavy. That's disappointing.
On Jan 14, 10:27 pm, mikech wrote:
> Do they ever give reasons for the talks being rejected? Just curious.
>
> On Jan 14, 9:28 pm, mdipierro wrote:
>
>
>
> > I doubt I will be able to attend but I do not know yet for sure.
>
> > Massimo
>
> > On J
On RDBS, i have code:
rows = db(db.cat.id>0).select(orderby=db.cat.name,limitby=(1,10))
but on GAE:
rows = db(db.cat.id>0).select()
rows = rows.sort(lambda row:row.name)
rows = rows[1:10]
It spend long time in a large datasets.
Is there some other way i can use to ma
This
rows = db(db.cat.id>0).select(orderby=db.cat.name,limitby=(1,10))
works on GAE and it is fast.
mind that you should start counting at 0, not 1.
On Jan 15, 12:44 am, toan75 wrote:
> On RDBS, i have code:
> rows = db(db.cat.id>0).select(orderby=db.cat.name,limitby=(1,10))
> but on G
This is to mean, what is called is a database function which has no
return value but raises an exception when sth is wrong (don't ask
how). So, I want to return the error message as it appears inside the
database function, in place of using the try/except option in python.
Can I?
--
You received
http://jquery14.com/day-01/jquery-14
cool!
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more
80 matches
Mail list logo