Dear Friends of Web2Py,
I am using the python shell within Web2Py
http://127.0.0.1:8000/admin/shell/index/welcome.
I created a small database called person with 1 field called name. I
inserted a few records and then queried the database table and printed
a set of rows. Then on a next query it
Thanks
You need to put the define_table in a model file or type it in again. You
are probably better off using a command line shell, see teh link
https://groups.google.com/d/topic/web2py/AzCFS8X7oLc/discussion
The post by Yarko is the one you want to look at, sorry
On Wed, Jun 1, 2011 at 7:40 PM, Jason Brower encomp...@gmail.com wrote:
Me does a dance. Thanks!
And yes it makes rain :-)
Thanks!
On 1 Юни, 19:12, Massimo Di Pierro massimo.dipie...@gmail.com wrote:
yes
rows.export_to_csv_file(open(),colnames=[])
On Jun 1, 8:38 am, Bob handzh...@gmail.com wrote:
Is there any way to change colnames before exporting to CSV?
Now I have a query like this:
Just for clarifications:
To upgrade a previous installation of plugin wiki, you just need re-
upload
Is it Correct?
On 1 jun, 20:32, Massimo Di Pierro massimo.dipie...@gmail.com wrote:
I also posted a new plugin wiki. It is not very different fixes a
vulnerability by doing a digital signature
Yes I did. Dal seems to try to put 0 in database but MySQL rejects the
value, since there is no row with index 0. I think the proper way to
indicate None in MySQL would be NULL.
On Jun 1, 7:14 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
Did you try:
db.define_table(tags,
On May 30, 10:50 pm, Sebastian E. Ovide sebastian.ov...@gmail.com
wrote:
For this reason it is best to deploy web2py behind
Apache78http://www.apache.org/
, Lighttpd85 http://www.lighttpd.net/ or
Cherokee86http://www.cherokee-project.com/download/
I just set up a site using nginx; so far,
I have the basic package (no extra mem) and the builtin upgrade works
well. Maybe you got some other stuff running?
On Jun 2, 2:08 am, JorgeH jorgeh...@gmail.com wrote:
It didnt for me
It went out of memory and the web2py process was killed automatically by the
server
i think this might help you out:
http://comments.gmane.org/gmane.comp.python.web2py/39225
http://projects.unbit.it/uwsgi/
http://projects.unbit.it/uwsgi/http://projects.unbit.it/uwsgi/wiki/Doc
I use uwsgi without any other server and works fine so far
you can limit memory usage
setup instructions:
you need to create a custom application
wget
In previous post it was stated that CRUD was more for prototyping and
SQLFORM for when you need more control. However now I see that there
is some additional functionality in CRUD e.g. the link with the auth
module; and archiving of records.
It seems to me these are two separate ways of doing the
Also available on pypi, get it while it's hot.
On Jun 2, 2011 1:41 PM, Miguel Lopes mig.e.lo...@gmail.com wrote:
On Wed, Jun 1, 2011 at 7:40 PM, Jason Brower encomp...@gmail.com wrote:
Me does a dance. Thanks!
And yes it makes rain :-)
Please do - that would be an interesting read!
On Jun 2, 5:42 am, cjrh caleb.hatti...@gmail.com wrote:
On May 30, 10:50 pm, Sebastian E. Ovide sebastian.ov...@gmail.com
wrote:
For this reason it is best to deploy web2py behind
Apache78http://www.apache.org/
, Lighttpd85
Hello,
I get following error after upgrade to 1.96.1:
Wersja
web2py™ Version 1.96.1 (2011-06-01 19:20:34)
Python Python 2.7.1: /usr/bin/python
Traceback
Traceback (most recent call last):
File /home/users/brushek/web2py/gluon/restricted.py, line 184, in
restricted
exec ccode in
Hello,
I'm using pyodbc to connect to a Teradata database in my normal
python
programs.
I am just starting to use web2py and experimenting with connecting
to
the same database.No luck so far.
The webbook says there is support for pyodbc but I cannot find any
examples of the connection
Oops we are not talking about the same thing. Looks like there is some
duplication of code.
I was thinking about :
IS_SLUG..urlify()
gluon.contrib.urlify should go away or IS_SLUG..urlify should call
gluon.contrib.urlify
On Jun 1, 11:47 pm, pbreit pbreitenb...@gmail.com wrote:
from
If you did not edit the code yes.
On Jun 2, 3:43 am, GoldenTiger goldenboy...@gmail.com wrote:
Just for clarifications:
To upgrade a previous installation of plugin wiki, you just need re-
upload
Is it Correct?
On 1 jun, 20:32, Massimo Di Pierro massimo.dipie...@gmail.com wrote:
I
Thanks. But now the logout, login and register links no longer work.
Traceback (most recent call last):
File gluon/restricted.py, line 181, in restricted
File
You need an Adapter. Let me look into this and send you one to try...
On Jun 2, 12:52 am, Andrew awillima...@gmail.com wrote:
Hello,
I'm using pyodbc to connect to a Teradata database in my normal
python
programs.
I am just starting to use web2py and experimenting with connecting
to
the
This line:
(T('Index'),URL('index').xml()==URL().xml(),URL('index'),[])
should be
(T('Index'),URL('index')==URL(),URL('index'),[])
This is because this code was generated by the wizard and the wizard
is still experimental. This worked with only an early version of the
wizard. The new wizard
Hello,
I have following error:
Traceback (most recent call last):
File /home/services/nginx/web2py/gluon/restricted.py, line 184, in
restricted
exec ccode in environment
File /home/services/nginx/web2py/applications/panel_vps2/models/
menu.py, line 8, in module
Thank You Masimo, I posted twice, becaouse I didn't see the first
post. So ignore it.
On 2 Cze, 14:19, Massimo Di Pierro massimo.dipie...@gmail.com wrote:
This line:
(T('Index'),URL('index').xml()==URL().xml(),URL('index'),[])
should be
(T('Index'),URL('index')==URL(),URL('index'),[])
If I put auth() instead of form, everybody can register again.
Dwayne
[danto@localhost ~]$ python2 web2py/web2py.py -a pass -i 0.0.0.0
Traceback (most recent call last):
File web2py/web2py.py, line 16, in module
import gluon.widget
File /home/danto/web2py/gluon/__init__.py, line 15, in module
from globals import current
File
El Thu, 2 Jun 2011 08:47:45 -0400
danto web2py.n...@gmail.com escribió:
[danto@localhost ~]$ python2 web2py/web2py.py -a pass -i 0.0.0.0
Traceback (most recent call last):
File web2py/web2py.py, line 16, in module
import gluon.widget
File /home/danto/web2py/gluon/__init__.py, line
I can add for myself, that under nginx + uwsgi web2py is twice time
faster than Rocket (no offence :) ), look:
nginx:
httperf --hog --server web2py.server.tld (changed) --port 8443 --num-
conns=1000 --num-calls=1
[...]
Request rate: 1258.2 req/s (0.8 ms/req)
[...]
Rocket (standard web2py
2011/6/2 Vasile Ermicioi elff...@gmail.com
http://projects.unbit.it/uwsgi/
http://projects.unbit.it/uwsgi/http://projects.unbit.it/uwsgi/wiki/Doc
I use uwsgi without any other server and works fine so far
you can limit memory usage
setup instructions:
you need to create a custom
2011/6/2 danto web2py.n...@gmail.com
[danto@localhost ~]$ python2 web2py/web2py.py -a pass -i 0.0.0.0
Traceback (most recent call last):
File web2py/web2py.py, line 16, in module
import gluon.widget
File /home/danto/web2py/gluon/__init__.py, line 15, in module
from globals
Hi Massimo,
I recently started to develop an application based on powerpack, so I
created some models and these worked fine using the db administrator
interface, until I try to edit any record and I get an error from dal,
I don't know if it is related to my model definition, to powerpack or
I do not recommend to enter values manually in powerpack and perhaps in
another app using appadmin, because you are avoiding data validation.
2011/6/2 Oscar oscar.m...@gmail.com
Hi Massimo,
I recently started to develop an application based on powerpack, so I
created some models and these
I believe that was a trunk Issue not a 1.96.1 (stable) issue.
I also think that is now fixed in trunk. Can you try again?
Massimo
On Jun 2, 8:28 am, Marco Mansilla b...@esdebian.org wrote:
El Thu, 2 Jun 2011 08:47:45 -0400
danto web2py.n...@gmail.com escribió:
[danto@localhost ~]$ python2
This patch that was added to the trunk breaks my application which runs on
MSSQL. Whenever I try to read a datetime from MSSQL now, I get a syntax
error about not being able to parse the date time from a string. Reverting
my web2py installation to to R-1.96.1 fixes the problem.
usually uwsgi is used behind other servers like nginx, cherokee, apache
I use uwsgi embedded http servers so I don't need nginx, apache or any other
server
just add --http option
a while ago they didn't recommend embedded server for production, but now
they think that this might be a good idea,
If I put auth() instead of form, everybody can register again.
Dwayne
And this is not what I want :( Can somebody help me ?
Dwayne
taskqueue is no longer a labs feature, but a trunk feature on GAE, so use:
from google.appengine.api import taskqueue
can you try and load the logged URL by hand in the browser? It should
follow the same URL processing and i have not had to add special routes.py
or app.yaml to make it work.
thanks for the feedback.
my task is called correctly when I manually Run it from
http://localhost:8080/_ah/admin/tasks?queue=default
I've given the task a name (to make it unique) using a mixture of a-z0-9-
The fact that dev_appserver is failing to call the URL correctly / URL is
failing to call
Nginx+uwsgi *ought to be* the deployment of choice for web2py.
Materials need to be posted and updated on how to set up and tweak
this configuration. This will complete the whole webp2y experience.
Frankly, I have no idea why web2py should depend on Rocket, instead of
using Python wsgi server
Doing a little more research on this:
This happens when doing an INSERT. And the exact error I get:
DataError: ('22007', '[22007] [FreeTDS][SQL Server]Syntax error converting
datetime from character string. (241) (SQLExecDirectW)')
What's happening is my application is importing data from a
what is the differences between gluon.contrib.urlify and
IS_SLUG..urlify(...)?
is it same? which is the best for use?
thank you so much
On Thu, Jun 2, 2011 at 7:12 PM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
Oops we are not talking about the same thing. Looks like there is some
AHAH!
I figured out what it was. I will post in a new thread since it actually has
nothing to do with the DAL at all, but rather the new behavior of the
Storage() object.
ah ha!
a bug in my app's db.py was preventing dev_appserver.py from calling my task
url... sensitive chap.
these subtly differences between web2py, dev_appserver and GAE are
frustrating - I'll be happier when it's all in the cloud :)
On 2 June 2011 15:28, Carl Roach m...@carlroach.com wrote:
I just updated my trunk only to find several scripts not working properly
and acting strangely. I thought it was a change made to MSSQL, but I have
narrowed down the problem to revision 1980 titled, 'many semplifications'. A
change made to storage.py's __getattr__() function is causing the
Use IS_SLUG.urlify(...)
I will remove the latter. Was never intended to be there.
On Jun 2, 9:39 am, Stifan Kristi steve.van.chris...@gmail.com wrote:
what is the differences between gluon.contrib.urlify and
IS_SLUG..urlify(...)?
is it same? which is the best for use?
thank you so much
On
Is this now fixed in trunk?
On Jun 2, 9:51 am, Ross Peoples ross.peop...@gmail.com wrote:
AHAH!
I figured out what it was. I will post in a new thread since it actually has
nothing to do with the DAL at all, but rather the new behavior of the
Storage() object.
The new Storage in trunk is experimental. It may go away. Yet I think
the problems you refer to have been solved. Can you please try trunk
again and confirm?
Massimo
On Jun 2, 9:57 am, Ross Peoples ross.peop...@gmail.com wrote:
I just updated my trunk only to find several scripts not working
Hello everybody,
Is there a social network plug-in for Web2py, which for example allows
users to send messages to each other ?
Thank you very much,
François
Something like this?
http://vimeo.com/21364178
On Jun 2, 10:09 am, François gustave5...@gmail.com wrote:
Hello everybody,
Is there a social network plug-in for Web2py, which for example allows
users to send messages to each other ?
Thank you very much,
François
HI,
anyone have a quick and dirty template to build something like a
google group (group posts, group/individual replies, group/individual
mail). Or maybe a suggestion on the best and quickest way to get one
going?
Thanks,
Mart :)
http://www.pyforum.org/ ?
On 2 June 2011 17:01, mart msenecal...@gmail.com wrote:
HI,
anyone have a quick and dirty template to build something like a
google group (group posts, group/individual replies, group/individual
mail). Or maybe a suggestion on the best and quickest way to get one
sweet!!! sounds like a fabulous app! can't wait for it to be available
for download and to take a look!
thanks for the link! :)
On Jun 2, 12:17 pm, Tom Atkins minkto...@gmail.com wrote:
http://www.pyforum.org/?
On 2 June 2011 17:01, mart msenecal...@gmail.com wrote:
HI,
anyone
Was a wrong validation.
Regards,
Oscar
On 2 jun, 09:43, Martín Mulone mulone.mar...@gmail.com wrote:
I do not recommend to enter values manually in powerpack and perhaps in
another app using appadmin, because you are avoiding data validation.
2011/6/2 Oscar oscar.m...@gmail.com
Hi
On Jun 2, 2011, at 8:53 AM, Massimo Di Pierro wrote:
Use IS_SLUG.urlify(...)
I will remove the latter. Was never intended to be there.
There are a couple of things that could be fixed in urlify.
def urlify(value, maxlen=80):
s = value.decode('utf-8').lower()# to lowercase
i do not know anything based on email messages, but,
we have PyForum http://www.pyforum.org/
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda a programar: http://CursoDePython.com.br ]
[ O seu aliado nos cuidados com os animais: http://AnimalSystem.com.br ]
[ Consultoria em
Thanks to you as well Bruno! :)
Man, seems i have been so much out of loop in that last few months!
Thanks,
Mart :)
On Jun 2, 12:09 pm, Bruno Rocha rochacbr...@gmail.com wrote:
i do not know anything based on email messages, but,
we have PyForumhttp://www.pyforum.org/
--
Bruno Rocha
[
http://py.codeconf.com/ by these people http://codeconf.com/
My mistake, it was a trunk issue, now it's fixed, tanks a lot =)
I believe that was a trunk Issue not a 1.96.1 (stable) issue.
I also think that is now fixed in trunk. Can you try again?
Massimo
On Jun 2, 8:28 am, Marco Mansilla b...@esdebian.org wrote:
El Thu, 2 Jun 2011 08:47:45 -0400
It still returns an empty Storage instance instead of None.
I just tried this in a web2py shell:
from gluon.storage import Storage
data = Storage()
data.foo = 'bar'
data.foo
'bar'
data.test
Storage {}
Here is a link to download PyForum -
http://dl.dropbox.com/u/830444/pyforum_1-0-3.tgz
this is an outdated version, as Julio does not published the newest version
yet.
This 1-0-3 has some auth bugs, but it can be solved easily.
--
Bruno Rocha
[ About me: http://zerp.ly/rochacbruno ]
[ Aprenda
thanks again! I'll give it a try :)
On Jun 2, 12:48 pm, Bruno Rocha rochacbr...@gmail.com wrote:
Here is a link to download PyForum
-http://dl.dropbox.com/u/830444/pyforum_1-0-3.tgz
this is an outdated version, as Julio does not published the newest version
yet.
This 1-0-3 has some auth
The reason for underscored is that they are not visible when links are
undelined.
On Jun 2, 11:34 am, Jonathan Lundell jlund...@pobox.com wrote:
On Jun 2, 2011, at 8:53 AM, Massimo Di Pierro wrote:
Use IS_SLUG.urlify(...)
I will remove the latter. Was never intended to be there.
There
WOW!
PyForum pretty nice!
Richard
On Thu, Jun 2, 2011 at 1:12 PM, mart msenecal...@gmail.com wrote:
thanks again! I'll give it a try :)
On Jun 2, 12:48 pm, Bruno Rocha rochacbr...@gmail.com wrote:
Here is a link to download PyForum -
http://dl.dropbox.com/u/830444/pyforum_1-0-3.tgz
The point is that it allows you to do
data.a.b.c=1
without having to do
data.a=Storage()
data.a.b=Storage()
data.a.b.c=1
In your test:
data.test
Storage {}
but:
data.test == None
True
if not data.test: print 'null'
null
On Jun 2, 11:54 am, Ross Peoples ross.peop...@gmail.com wrote:
I just
On Jun 2, 2011, at 10:24 AM, Massimo Di Pierro wrote:
The reason for underscored is that they are not visible when links are
undelined.
They could be treated like spaces (replaced with hyphens).
On Jun 2, 11:34 am, Jonathan Lundell jlund...@pobox.com wrote:
On Jun 2, 2011, at 8:53 AM,
On Jun 2, 2011, at 10:29 AM, Massimo Di Pierro wrote:
The point is that it allows you to do
data.a.b.c=1
without having to do
data.a=Storage()
data.a.b=Storage()
data.a.b.c=1
In your test:
data.test
Storage {}
but:
data.test == None
True
if not data.test: print 'null'
Hi Massimo,
I use Storage in many places, and I always compare with is None, which I
believe would now break my code.
I also vote for explicit initialization, and make sure that is None works
ok.
Thanks,
Carlos
I looked at Pyforum but had trouble finding the code and was concerned about
it apparently being dead and GPL.
I found this but am not sure it is the last update:
http://code.google.com/p/pyforum/
Would be nice to have something like FluxBB or Vanilla available.
I'm bumping this message, because the bug still hasn't been fixed in
the new release.
The erroneous line is now line 822 in dal.py, version 1.96.1. It
worked correctly after I applied the same fix.
On Apr 29, 12:30 pm, Loren McGinnis mcginnis.lo...@gmail.com wrote:
I'm using a legacy database
http://projects.unbit.it/uwsgi/
http://projects.unbit.it/uwsgi/http://projects.unbit.it/uwsgi/wiki/Doc
I use uwsgi without any other server and works fine so far
you can limit memory usage
setup instructions:
you need to create a custom application
wget
so I installed it but getting lots of errors, did a few things to get
around the them, i.e. converted the sql cmds to something web2py can
use (I.e. db.auth_roles.insert(bla=bla)), and a few things that seemed
apparent but still getting errors like table doesn't exist)... so
maybe plugin_wiki is
I agree
On Jun 2, 12:30 pm, Jonathan Lundell jlund...@pobox.com wrote:
On Jun 2, 2011, at 10:24 AM, Massimo Di Pierro wrote:
The reason for underscored is that they are not visible when links are
undelined.
They could be treated like spaces (replaced with hyphens).
On Jun 2,
When a property is first uploaded PIL creates all the different sized
thumbnails from any accompanying images. They are placed in the upload
folder with filenames added to the db like any other form uploaded
file. The files are fetched by a customised download function that
builds the path, adds a
will fix this tonight.
On Jun 2, 1:00 pm, Loren McGinnis mcginnis.lo...@gmail.com wrote:
I'm bumping this message, because the bug still hasn't been fixed in
the new release.
The erroneous line is now line 822 in dal.py, version 1.96.1. It
worked correctly after I applied the same fix.
On
Keep None on the Storage object, then create a new class and call it
MultiStorage which implements the new functionality.
--
Thadeus
On Thu, Jun 2, 2011 at 12:37 PM, Carlos carlosgali...@gmail.com wrote:
Hi Massimo,
I use Storage in many places, and I always compare with is None, which I
I finally got to the bottom of this. It is fixed in trunk. Trunk has
some experimental stuff you do not want but if you just get this file:
applications/admin/controllers/mercurial.py
the problem should be gone.
On May 2, 8:45 pm, ehgonzalez ehgonzale...@gmail.com wrote:
Hello,
When I'm
Will do that.
How about having current.settings=MultiStorage()
and having PluginManager(name) return the current.settings.name?
On Jun 2, 1:35 pm, Thadeus Burgess thade...@thadeusb.com wrote:
Keep None on the Storage object, then create a new class and call it
MultiStorage which implements the
I found my problem...
Quite time have pass... I had worked on soo many other thing...
The : generic.load view were missing since I start my app with older version
of web2py (before the component feature added).
Richard
On Mon, Apr 4, 2011 at 3:08 PM, Anthony abasta...@gmail.com wrote:
I'm
web2py uses pyodbc to connect to MS SQL Server.
The connection string has the following format:
db=DAL(mssql://user:password@host/database)
If there are no differences in the SQL language betweeen MSSQL and
Teradata then you are in luck and the current adapter might just work.
On Jun 2, 1:52
Hi Folks,
Sorry I have been a bit busy with qa-stack lately, there were some
security issues that I had to take care with pyforum that is why I
removed the code from the main site, all this has been fixed, but I
need to upload the latest code to bitbucket (which is where qa-stack
is also), I'll
Thank you, this is nice and impressive !
Is there a place where I can download the code ?
François
On 2 juin, 17:57, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
Something like this?http://vimeo.com/21364178
On Jun 2, 10:09 am, François gustave5...@gmail.com wrote:
Hello
great to have you in this group!!
a few questions:
could you explain more how does this limit work: what happens to new
requests if memory limit is reached ?
do I need --master option (for increased stability) if I use ugreen and
--protocol=http?
thank you !
Having the two Storage and MultiStorage objects would be nice, as Storage
would require explicit initialization (just like request.vars does). Then if
you want to use recursive Storage objects (data.a.b.c = 1), that's where
MultiStorage comes in.
Nice suggestion, because I do like this new
Good news, thanks!
Try Yammer (free).
Cool. That's kind of what I do except for the last-modified. PIL has been
decent to work with for this first-timer. http://pricetack.com
So is this going away?
from gluon.contrib.urlify import urlify
Will I still be able to urlify without IS_SLUG()?
I think there is still a problem with impersonate since it is no longer
entered via a POST.
http://code.google.com/p/web2py/source/browse/gluon/tools.py#2330
if not self.is_logged_in() or not current.request.post_vars:
should be
if not self.is_logged_in():
Can someone confirm?
On Jun 2, 2011, at 1:21 PM, pbreit wrote:
So is this going away?
from gluon.contrib.urlify import urlify
Will I still be able to urlify without IS_SLUG()?
We could pull urlify out of IS_SLUG and make it available as validators.urlify.
It's already a static method, so it doesn't really care.
Is there a generic way of using validators outside a database context?
On Jun 2, 2011, at 1:45 PM, pbreit wrote:
Is there a generic way of using validators outside a database context?
Sure, you can call them directly. Look at the doctests for examples.
IS_EMAIL()('somethingwrong')
('somethingwrong', lazyT 'enter a valid email address')
when the returned tuple contains a second element which is != None, it is an
error message and validador returned 'invalid'
IS_EMAIL()('someth...@domain.com')
('someth...@domain.com', None)
when the second
I have it somewhere. I will post it on web2py appliances asap.
On Jun 2, 3:06 pm, François gustave5...@gmail.com wrote:
Thank you, this is nice and impressive !
Is there a place where I can download the code ?
François
On 2 juin, 17:57, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
Hello,
Here my view code :
{{extend 'layout_form.html'}}
style type=text/css title=currentStyle
@import
{{=URL('static','plugin_added/jquery-ui-1.8.9.custom/development-bundle/themes/base/jquery.ui.all.css')}};
/style
script type=text/javascript charset=utf-8
very cool, massimo, hope you can share it, so that we can learn from it,
thank you so much.
On Fri, Jun 3, 2011 at 4:03 AM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
I have it somewhere. I will post it on web2py appliances asap.
On Jun 2, 3:06 pm, François gustave5...@gmail.com
what if I want to define a virtual field and use it for different table
with same field names that I want to use in the virtual field
calculation? Do I have to cut paste and chance only the table name in
the formula or there's a modular way to do it?
thanks a lot
Manuele
yes, double good news! thanks for that, i can't wait to try it! :)
Mart
On Jun 2, 4:16 pm, pbreit pbreitenb...@gmail.com wrote:
Good news, thanks!
LOL :) its been about 6 weeks and I'm still listening to the video and
typing (then correcting my bad spelling :) ) - my daughter is keen on
adding color and using it at school -because daddy (me) won't let
her near the the official FaceBook ;) Although at the rate i seem to
get things done
1 - 100 of 111 matches
Mail list logo