actually i'm fine with both.
postcount = db.post.id.count().with_alias('postcount')
postcount = db.post.id.count().named('postcount')
both looks fine but with_alias give the feeling more.
On 13 Mart, 08:57, "mr.freeze" wrote:
> BTW, if syntax is negotiable I think 'named' is better than
> 'with
BTW, if syntax is negotiable I think 'named' is better than
'with_alias':
postcount = db.post.id.count().named('postcount')
On Mar 13, 12:54 am, "mr.freeze" wrote:
> Now we just need to see if Massimo will take the patch!
>
> On Mar 13, 12:50 am, Mengu wrote:
>
> > alright then, this is reall
Now we just need to see if Massimo will take the patch!
On Mar 13, 12:50 am, Mengu wrote:
> alright then, this is really great. :) i'm happy that i could
> contribute to web2py. :)
>
> thanks mr.freeze.
>
> On 13 Mart, 08:42, "mr.freeze" wrote:
>
> > I think so. I tested on a similar query:
>
>
alright then, this is really great. :) i'm happy that i could
contribute to web2py. :)
thanks mr.freeze.
On 13 Mart, 08:42, "mr.freeze" wrote:
> I think so. I tested on a similar query:
>
> db.define_table('post',
> Field('title'),Field('body'))
>
> db.define_table('post_comment',
> Field
I think so. I tested on a similar query:
db.define_table('post',
Field('title'),Field('body'))
db.define_table('post_comment',
Field('post_id', db.post),
Field('comment', 'text'))
def mengu():
rows =
db(db.post_comment.post_id==db.post.id).select("COUNT(post.id) AS
postcount",
On Mar 12, 9:14 pm, Graham Dumpleton
wrote:
> On Mar 13, 8:48 am, Timothy Farrell wrote:
>
> > I'm not sure how you upgraded, but make sure you have a rocket.py in
> > your gluon folder.
>
> What ever they are doing they are trying to do it under Apache/
> mod_wsgi, not as a standalone process.
mr. freeze,
does also the following query work like in my patch?
db(db.vote.question_id==db.question.id).select("COUNT(vote.id) AS
votecount", db.question.id, db.question.title, orderby="votecount
DESC", groupby=db.question.id)
thanks. you are welcome btw :)
On 13 Mart, 06:05, "mr.freeze" wro
I use web2py for my personal website (www.spiffyte.ch). I'm also using
web2py to handle the server-side portions of a turn-based multiplayer
game I'm working on. The automatic JSON encoding is very handy for
that.
On Mar 12, 11:29 am, Thadeus Burgess wrote:
> It blogs (thadeusb.com /http://code.
I sent Massimo a patch for sql.py. I held off patching dal.py since I
am unfamiliar with the new structure. I figured Massimo would rather
do it himself based on the sql.py patch (which is very small) rather
than fix my code.
It seems to work well, allowing you to cast any expression into a new
va
On Mar 13, 8:48 am, Timothy Farrell wrote:
> I'm not sure how you upgraded, but make sure you have a rocket.py in
> your gluon folder.
What ever they are doing they are trying to do it under Apache/
mod_wsgi, not as a standalone process.
Graham
> -tim
>
> On 3/12/2010 3:42 PM, Jose wrote:
>
>
c:\Python25\Lib\site-packages>python easy_install.py ssl
Searching for ssl
Reading http://pypi.python.org/simple/ssl/
Reading http://docs.python.org/dev/library/ssl.html
Best match: ssl 1.15
Downloading http://pypi.python.org/packages/source/s/ssl/ssl-1.15.tar.gz#md5=81e
a8a1175e437b4c769ae65b3290e
I need help in building the windows binary. I cannot get Python25 +
ssl 1.15 installed becuase it requires visual studio.
Can one of you windows users try
install python 2.5
install setuputils
install mark hammond extensions
easy_install ssl
send me the c:/Python25 folder zipped.
--
You receiv
To summerize. Is there something that works on mod_proxy+cherrypy that
does not work on mod_proxy+rocket?
--
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 grou
hmmm. That may have been me although I do not remember editing the
patch. I may have done an error in applying it. Can you send me a
patch to fix the corrent version?
On Mar 12, 3:49 pm, pihentagy wrote:
> IS_DATE_IN_RANGE and IS_DATETIME_IN_RANGE have bugs.
>
> Someone changed my initial patch,
Sorry for my last message , it works Ok (I did not routed to my test
controler)
Thanks a lot
JmiXIII
On 12 mar, 22:10, mdipierro wrote:
> Need to see the model to make sure but try replace
>
> CodeOF=request.vars.OF
>
> with
>
> CodeOF=request.vars.OF or request.vars.META_OF
>
> The pro
I just deployed two mod_wsgi production configurations to Fedora and
Ubuntu, so maybe I can help. But you'll need to be a little more
specific about what problems you are having.
On Mar 11, 2:26 pm, kike wrote:
> I have some trouble to mount a web2py with apache2 and mod_wsgi in
> debian.
--
Y
Hello,
Well I've tried
CodeOF=request.vars.OF or request.vars.META_OF but it does not change
anything
Using the appadmin works (I can update records of db.OF)
Here is my model:
db.define_table("OF",
SQLField("META_OF", "integer"),
SQLField("META_RespOF","string"),
SQLField("META_
On Mar 12, 2010, at 2:09 PM, Timothy Farrell wrote:
> OK, in testing mod_proxy I've hit a snag. I'd like for someone else to take
> a look. I have web2py running on port 8000. Here's the relevant section of
> my httpd.conf (this is Apache 2.2.14):
>
>
>SetEnv force-proxy-request-1.0 1
>
On 12 mar, 21:48, Timothy Farrell wrote:
> I'm not sure how you upgraded, but make sure you have a rocket.py in
> your gluon folder.
>
$ hg pull
$ hg update
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to
OK, in testing mod_proxy I've hit a snag. I'd like for someone else to
take a look. I have web2py running on port 8000. Here's the relevant
section of my httpd.conf (this is Apache 2.2.14):
SetEnv force-proxy-request-1.0 1
SetEnv proxy-nokeepalive 1
ProxyBadHeader StartBody
IS_DATE_IN_RANGE and IS_DATETIME_IN_RANGE have bugs.
Someone changed my initial patch, that's not a problem, but 4 lines
misses the s - string specifier at the end of the strings.
error_message = "enter date on or before %(max)s"
error_message = "enter date on or after %(min)s"
error_message = "e
I'm not sure how you upgraded, but make sure you have a rocket.py in
your gluon folder.
-tim
On 3/12/2010 3:42 PM, Jose wrote:
On 11 mar, 16:08, mdipierro wrote:
We moved from cherrypy wsgiserver to Rocket, by Timothy Farrell.
I included an older version, need to include the latest one
On 11 mar, 16:08, mdipierro wrote:
> We moved from cherrypy wsgiserver to Rocket, by Timothy Farrell.
>
> I included an older version, need to include the latest one.
>
> It needs to be tested but let's wait I post the latest version before
> we do so.
>
> Why?
> @Tim, you made a very convincing
Need to see the model to make sure but try replace
CodeOF=request.vars.OF
with
CodeOF=request.vars.OF or request.vars.META_OF
The problem that when the second form is submitted vars.OF is None so
there no record to edit.
On Mar 12, 2:03 pm, JmiXIII wrote:
> I'm facing a pb with the fo
I'm facing a pb with the following controller :
# Formulaire de saisie principal
from gluon.tools import Crud
crud = Crud(globals(), db)
def saisie():
listeOF=db(db.GPOF.id>0).select()
CodeOF=request.vars.OF
Selection=FORM('Code OF:',
INPUT(_name='OF',_value=CodeOF,requires=IS_IN
I have removed the right-click and put in a web2py icon up in the
toolbar. I'm now working on the search interface, but it seems the
ajax() call is not readily available from within the editarea iframe.
Anyone got tips there? I'm also wondering whether to implement the
search with sqlite for loca
My interest in turnkey is that once made it will be available for
vmware, amazon, xen and will show up in the VPS.net list of available
appliances. The rule is that the machine has to be built by their
patching process.
I hit a block there because my patch fails ad apt-get install a module
that is
Hi Annet, long time no see.
>From the gluon/tools.py source under class Mail function send:
to: list or tuple of receiver addresses; will also accept single
object
Hope this helps,
Denes.
On Mar 12, 12:34 pm, annet wrote:
> I am trying to work out a working version of this: Using the Template
Totally!
-Thadeus
On Fri, Mar 12, 2010 at 12:05 PM, mdipierro wrote:
>
>> Soon to be a commerce site so my girlfriend can sell her cute
>> hand-made stuffed animals
>
> Email me some pictures. My son loves those. I may but one. If she can
> make them with only one large creepy eye (like ugly
I think this is a different issue. If you relocate plugins but you
still have all code in plugins//models/.py then they
would work no differently than now (they would be executed in
alphabetical order with the plugin name). To do what you ask you would
have to put plugin code in modules and import
> Soon to be a commerce site so my girlfriend can sell her cute
> hand-made stuffed animals
Email me some pictures. My son loves those. I may but one. If she can
make them with only one large creepy eye (like ugly dolls), than even
better.
--
You received this message because you are subscribed
On Mar 12, 11:53 am, MarKco wrote:
> Thank you very much.
> I created a new project with almost the same controllers and views,
> but with the table extended by the ID field (I actually did not choose
> a key in explicit way, so Web2py provided one by itself).
web2py does create the id field aut
I am trying to work out a working version of this: Using the Template
System to Generate Emails, page 146 -147 of the web2py.
1. The database table in db.py:
db.define_table('nfa',
Field('bedrijf',db.bedrijf,default='',notnull=True,ondelete='CASCADE',writable=False,readable=False),
Field('nfa
this is an excellent case.
On Mar 12, 10:13 am, Timothy Farrell wrote:
> The benchmarks are in. As you can see from the attached PDF, there is a
> strong case for Rocket.
>
> How I conducted these benchmarks:
>
> CPU: Athlon 4050e 2.1 GHz
> RAM: 3GB
> OS: Windows 7 Ultimate
> Python 2.6.1
> Rock
Thank you very much.
I created a new project with almost the same controllers and views,
but with the table extended by the ID field (I actually did not choose
a key in explicit way, so Web2py provided one by itself). Now
everything works perfectly!
Thanks again to everyone.
P.S. So has it to be
I ran a test on a virtual machine with similar results.
If I understand what you are trying to do correctly and that echo
message is valid then perhaps the script 'setup-web2py-ubuntu.sh' is
being run as part of the ISO patching process?
A better solution might be to put the script on the ISO be
If all plugins are designed to be class-like, then your example of
plugins just need to inherit.
The only reason I would be in support for logically changing the
location of plugins is the one of dependencies.
Meaning, if you have to specify to web2py when to load a plugin, and
in what order... i
It blogs (thadeusb.com / http://code.google.com/p/blogitizor/)
It does customer management / scheduling systems with project and
resource tracking
It does statistical analysis for research
It manages files on the fileserver, keeping things organized
It has tracked of the status of the GaiaOnline mi
Python 2.6.4, not 2.6.1 oops.
On 3/12/2010 10:13 AM, Timothy Farrell wrote:
The benchmarks are in. As you can see from the attached PDF, there is
a strong case for Rocket.
How I conducted these benchmarks:
CPU: Athlon 4050e 2.1 GHz
RAM: 3GB
OS: Windows 7 Ultimate
Python 2.6.1
Rocket 0.3.1
C
The benchmarks are in. As you can see from the attached PDF, there is a
strong case for Rocket.
How I conducted these benchmarks:
CPU: Athlon 4050e 2.1 GHz
RAM: 3GB
OS: Windows 7 Ultimate
Python 2.6.1
Rocket 0.3.1
Cherrypy 3.1.2
I used ApacheBench to run the numbers you see.
The wsgi app use
Have you tried: psad --Flush
On Mar 12, 7:15 am, mdipierro wrote:
> The main problem is the with examples/global/vars and book/default/
> docstring
> They generate dynamically links to docstrings recursively. Web spider
> get stuck there and keep requesting pages over pages, thus consuming
> lots
good point. I will take the patch.
On Mar 12, 9:01 am, DenesL wrote:
> To drop the seconds value as in the example format '%H:%M' above.
>
> On Mar 12, 8:07 am, mdipierro wrote:
>
> > The 'time' fields have a JS time picker. If you choose to do
>
> > db.table.field.requires.formatter=lambda v:
To drop the seconds value as in the example format '%H:%M' above.
On Mar 12, 8:07 am, mdipierro wrote:
> The 'time' fields have a JS time picker. If you choose to do
>
> db.table.field.requires.formatter=lambda v: v.strftime('%H-%M')
> instead of
> db.table.field.requires.formatter=lambda v:
The problem with framework level plugins is that if you pack the app
and unpack somewhere else then it will not work without the "framework
level" plugin installed separately. I do not think that is something
to encourage. Moreover different apps may reply on different versions
of the plugin and/or
On 5 March 2010 23:03, Yarko Tymciurak wrote:
> Does this seem "dense" to you?...
>
> If so, maybe this will make it readable:
Thanks to both of you. I only started working recently in Python
after a about 10 years of inactivity. This usage of 'reduce' is
something new to me. From your explana
Ok Massimo,
I agree with you in it makes no sense to rewrite a lot of web2py code.
Apart from that argument in favor, there is another I don't know if it
would be satisfied right now with plugin_name.py convention:
-Imagine you write a *framework level plugin* to subsitute auths (or
whatever
Just to clarify it:
Do we able to conservate my app (rewrited/extended) auth module/model,
working alongside "superAuth" thadeus plugin, discarding your framework
plugin and system Auth default one?
Alex
El 12/03/2010 15:31, Alex Fanjul escribió:
Ok Massimo,
I agree with you in it makes no s
The main problem is the with examples/global/vars and book/default/
docstring
They generate dynamically links to docstrings recursively. Web spider
get stuck there and keep requesting pages over pages, thus consuming
lots of memory and bandwidth. Humans do not do that. Humans would not
more than 2-
The 'time' fields have a JS time picker. If you choose to do
db.table.field.requires.formatter=lambda v: v.strftime('%H-%M')
instead of
db.table.field.requires.formatter=lambda v: v.strftime('%H:%M')
the time picker would not recognize it as valid time. Why would
anybody change the time forma
The location of plugins is not a backward compatibility issue. From
that point of view, we could relocate plugin files.
The reason I do not want to do is that it is an implementation issue
that requires rewriting a lot of web2py code (particularly for the
bytecode-compile functionality), that will
It is not a bug (as I define it). SImply you are not allowed in the
DAL to alias the table that is not joined. The reason you are not
allowed to do it is that it it not necessary. You also another
problem, your main filter (t1.id==123) involves the joined table. That
is not no allowed in SQL. This
This is fixed. You just need to replace the views/web2py_ajax.html for
the app that gives you trouble with the one that comes in 1.76.5
welcome.
On Mar 12, 2:18 am, selecta wrote:
> *bump*
>
> multiple crud update forms with delete checkbox cause the delete pop-
> up to open too often
>
> On Mar
nice I will take a look asap
On Mar 11, 10:13 pm, Wes James wrote:
> I've been trying to figure out an easier way to have all web2py API's
> etc. at a coders finger tips. I added some pieces to edit_area so
> that you can right-click in the edit_area text box and get a popup
> that you can selec
I will check this out for you later today as well.
Chris
On Feb 17, 1:41 am, Massimo Di Pierro wrote:
> I am trying to make a web2py appliance for turnkey linux. Once done
> this will run on xen, vmware and ec2.
>
> I could use some help. Try this.
>
> RUN THIS IN A VIRTUAL MACHINE BECAUSE I A
On 11 March 2010 06:11, villas wrote:
> Obviously if anyone else thinks they have an idea to move towards a
> well-tested div layout using a good naming scheme (preferably borrowed
> from a mainstream project which already has some templates) then do
> please mention it.
I am only starting on we
Hi All, Massimo,
I've been designing a web app using web2py. Web2py is
really a
very well designed framework. I am considering it along with
Django for a
medium sized web app development. How ever I would like to know,
if I can
code more applications for a single complex
Sounds like your new setup is working really well Massimo. Eventually
I will be bugging you for some details as well.
Congrats!
On Mar 11, 8:37 pm, "mr.freeze" wrote:
> Massimo has a script that blocks IPs of things it interprets as denial
> of service attacks, including crawling content without
On Mar 11, 5:29 pm, mdipierro wrote:
> can you show an example and I will try?
Never mind, form has to be recreated to include any changes.
On Mar 11, 3:10 pm, mdipierro wrote:
> I do not know. The problem is that the JS may not work with other
> formats.
On the original problem with IS_TIME
There're no free ports by default (due to security considerations, as
they claim), you'll need to contact the customer service and request
them to open the needed port for listening to inbound connections.
They should agree.
I had requested that for port 8000, and they opened it for me.
On Mar 1,
I control advances factory robotics with web2py. It's pretty cool, but
for now a secret beyond that. :D
Best Regards,
Jason
On Fri, 2010-03-12 at 02:38 -0800, selecta wrote:
> check out
> http://www.semanticsbml.org/aym (screeshots at sf.net will help if you
> do not want to input something)
> ht
SQLite does not support this AFAIK.
Keyed tables (the ones that define a primarykey) so far are only
supported on DB2, MS SQL, Ingres and Informix.
Others (except SQLite) can be added following the instructions in:
http://groups.google.com/group/web2py/browse_thread/thread/db150376b06d47fc
Denes.
Hi Massimo,
I haven't said that plugins should have to depend on others, but they
should be able to access/play with others to make a trully plugins
central network, the dependencies are resoluble at highly level with an
exposed convention API like:
plugin_most_active_users.requires=['commen
check out
http://www.semanticsbml.org/aym (screeshots at sf.net will help if you
do not want to input something)
http://www.semanticsbml.org/semanticSBML/
these are my current official web2py projects
the second one will use web2py as a application gui for now only some
new features are exposed tha
Hi all,
in the attempt to better knowing web2py and its community,
I'd like to write some entry on my blog (gioorgi.com).
I want to do a useful work for the community itself.
This day I'd like to focus myself on the question: for which projects do
you use web2py?
I have seen the master project o
Massimo,
thank you for your very very very quick response!
I tried the workaround but it does not seem to work.
This is the trace:
Error traceback
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 173, in restricted
exec ccode in environment
File "C:/web2py/ap
Hello. Here is everything that is needed to reproduce the bug. All code is
in models/db.py.
web2py is the latest released version (1.76.5)
>
/home/snake/python/web2py/1.76.5/web2py/applications/ttt/models/db.py(77)()->None
-> import pdb;pdb.set_trace()
(Pdb) l 70
65 db.define_table('mytable1'
*bump*
multiple crud update forms with delete checkbox cause the delete pop-
up to open too often
On Mar 10, 10:47 am, selecta wrote:
> If you load multiple crud update forms with the delete checkbox onto
> one page with LOAD and you click the delete checkbox the warning will
> pop up multiple
67 matches
Mail list logo
