I can't create an index on postgresql using executesql. Here's what
happens:
>> db.executesql('create index bq_index on bonus_queue (hitid);')
...but the index does not show up in psql. It does not return
anything. It seems like the command might be blocking psql, because if
I run another index
Sorry, hamdy, but I don't think you answered the question. I have read
the doc many times and understand how to operate groups, memberships,
and permissions. The question is about structure.
Consider the following situation. Users can register with the site.
Users can create common interest groups
no, and it rarely happens. i just found it on errorlog maybe once per
week. is the current dal return error right away if the database file
is locked?
On Mar 18, 11:36 am, mdipierro wrote:
> That should not be a problem. Do you get this regularly or
> occasionally? Is this a long running thread?
Thanks Massimo.. very clear explaination
--
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 o
That should not be a problem. Do you get this regularly or
occasionally? Is this a long running thread?
On Mar 17, 10:15 pm, vince wrote:
> mutliprocess yes. i am running under mod_wsgi with single thread but
> multi process.
>
> i do assume the sqlite driver should try to acquire the database fi
mutliprocess yes. i am running under mod_wsgi with single thread but
multi process.
i do assume the sqlite driver should try to acquire the database file
lock for a specific time instead of return error right away? or is
there any way to catch the error and return some busy page? it should
be appl
I noticed that many vps hosting provide HAProxy these days.
On Mar 17, 9:26 pm, Kuba Kucharski wrote:
> http://web2py.com/book/default/section/11/12?search=poundhttp://www.apsis.ch/pound/
>
> kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes.
> I didn't mentioned but I had also ex
voice over ip data engine ( routing, billing, gui-backend, etc )
--
Kuba
--
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+unsubs
http://web2py.com/book/default/section/11/12?search=pound
http://www.apsis.ch/pound/
kernel is 2.6.31-14-server not PAE of course.. sorry for mistakes.
I didn't mentioned but I had also executed some sysctl and ulimit
tweaking before benchmarking.
I ran tests again with the same configuration v
maybe Im a bit ignorant, but what is pound?
alex
El 18/03/2010 2:20, Kuba Kucharski escribió:
This is probably obvious but I decided to try this myself:
Should one run web2py with Pound on multi-core server?
probably yes if you deal with concurrent connections..
This is my config:
2.6.31-19
> I was going to say "extend/include" not import
and even this is not true as I see now for small layout
--
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
> Did you "compile" the app before running the benchmarks?
yes
>
> Can you say more about "The most important thing: effects depend much
> on what you import. "
> imports should be cached and should not make a difference.
actually they don't, it is late, I was going to say "extend/include" not im
Did you "compile" the app before running the benchmarks?
Can you say more about "The most important thing: effects depend much
on what you import. "
imports should be cached and should not make a difference.
Massimo
On Mar 17, 8:20 pm, Kuba Kucharski wrote:
> This is probably obvious but I deci
Are you using multiple connections to the same database? db=DAL(...)
On Mar 17, 7:51 pm, vince wrote:
> Traceback (most recent call last):
> File "/home/web2py/gluon/main.py", line 518, in wsgibase
> session._try_store_in_db(request, response)
> File "/home/web2py/gluon/globals.py", line
I am pretty sure this is not a problem with sqlite timeout. It may be
a concurrency issue. Do you use the thread module explicitly or
multiprocessing or background processes? Can you post a minimalist app
that allows to reproduce the problem? If not can you tells us a little
more about the applicat
I am not sure I understand the question. I can tell you how I proceed:
1) make a prototype that does what I want.
2) deploy and see what happens
3) when I start having lots of hits try to reduce the number of
queries using cache/memcache
4) eventually move some date or all data to a non-relational
This is probably obvious but I decided to try this myself:
Should one run web2py with Pound on multi-core server?
probably yes if you deal with concurrent connections..
This is my config:
2.6.31-19-generic-pae
Intel(R) Xeon(R) CPU E5410 @ 2.33GHz
Ubuntu 64bit
one processor with 4 cores
disk
I advice you use https and you do not remove the security checks.
https works out of the box on GAE anyway.
On Mar 17, 7:03 pm, Richard wrote:
> to use appadmin on GAE I had to either use https or comment out the
> security checks
>
> On Mar 17, 12:16 pm, mattynoce wrote:
>
> > hi, i've looked a
You are right. I will find a place.
On Mar 17, 4:36 pm, Jonathan Lundell wrote:
> On Mar 17, 2010, at 9:59 AM, mdipierro wrote:
>
>
>
> > There is no cookbook because there is nothing to be done other than:
>
> > 0) register with gae and get an app_id
> > 1) change the name in app.yaml (first lin
Traceback (most recent call last):
File "/home/web2py/gluon/main.py", line 518, in wsgibase
session._try_store_in_db(request, response)
File "/home/web2py/gluon/globals.py", line 356, in _try_store_in_db
table._db(table.id == record_id).update(**dd)
File "/home/web2py/gluon/sql.py", l
Dope !
Thanks Jose.
-Thadeus
On Wed, Mar 17, 2010 at 7:23 PM, Jose wrote:
>
>
> On 18 mar, 00:11, "mr.freeze" wrote:
>> I think you need to do:
>>
>> def sales():
>> rows = db(db.sales.id>0).select()
>> rows = rows.setvirtualfields(sales=Sales())
>> return dict(rows=rows)
>>
>>
On Mar 17, 2010, at 4:58 PM, Jonathan Lundell wrote:
> mrows = ((db(m.group_id == g.id)) &
> (db(~(g.role.like('user_%').select(m.user_id, g.role)
> TypeError: unsupported operand type(s) for &: 'Set' and 'Set'
>
> This doesn't seem right
>
>
Never mind; it's not that kind of Set.
--
On 18 mar, 00:11, "mr.freeze" wrote:
> I think you need to do:
>
> def sales():
> rows = db(db.sales.id>0).select()
> rows = rows.setvirtualfields(sales=Sales())
> return dict(rows=rows)
>
> And remove this:
> db.sales.virtualfields.append(Sales())
works well, but what I meant is th
Scratch that, I didn't realize that virtualfields had been added to
Table.
On Mar 17, 7:11 pm, "mr.freeze" wrote:
> I think you need to do:
>
> def sales():
> rows = db(db.sales.id>0).select()
> rows = rows.setvirtualfields(sales=Sales())
> return dict(rows=rows)
>
> And remove this:
I think you need to do:
def sales():
rows = db(db.sales.id>0).select()
rows = rows.setvirtualfields(sales=Sales())
return dict(rows=rows)
And remove this:
db.sales.virtualfields.append(Sales())
On Mar 17, 7:01 pm, Jose wrote:
> On 17 mar, 23:54, Jose wrote:
>
>
>
> > Fails,
>
> > i
Thanks Massimo,
So can you advice me - if i already make some projects on web2py (i
didn't test them on some productive tasks) it would be sufficient for
my job? Can I use web2py DAL on some relational aspects with object-
relational dbms (postgresql) - with object and nested tables?
The best choi
to use appadmin on GAE I had to either use https or comment out the
security checks
On Mar 17, 12:16 pm, mattynoce wrote:
> hi, i've looked at some posts but can't seem to make this work. i can
> get appadmin to work on my local version of gae launcher (on a mac),
> but when i upload it, i can't
I use it to display results from my web scraping jobs.
Am also working on a legal document editor for a client and a language
learning app for myself.
Richard
On Mar 12, 8:42 pm, "Giovanni Giorgi" wrote:
> Hi all,
> in the attempt to better knowing web2py and its community,
> I'd like to writ
On 17 mar, 23:54, Jose wrote:
> Fails,
>
> in model/db.py
>
> db.define_table('sales',
> Field('item'),
> Field('item_total', 'double'),
> Field('tax_percentage', 'double'),
> Field('trans_date', 'datetime'),
> )
>
> class Sales():
> def total(self):
> return self.ite
mrows = ((db(m.group_id == g.id)) &
(db(~(g.role.like('user_%').select(m.user_id, g.role)
TypeError: unsupported operand type(s) for &: 'Set' and 'Set'
This doesn't seem right
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to
Fails,
in model/db.py
db.define_table('sales',
Field('item'),
Field('item_total', 'double'),
Field('tax_percentage', 'double'),
Field('trans_date', 'datetime'),
)
class Sales():
def total(self):
return self.item_total * self.tax_percentage
def tax(self):
r
On 17 mar, 23:25, Thadeus Burgess wrote:
> http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sql...
>
> -Thadeus
Thank Thadeus, excellent.
Jose
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send emai
http://thadeusb.com/weblog/view/web2py_virtualfields_as_an_orm_an_sqlalchemy_approach
-Thadeus
On Wed, Mar 17, 2010 at 5:41 PM, Jose wrote:
> In what was virtualfields development. Reviewing these threads was not
> yet defined the syntax.
>
> http://www.google.com/url?sa=D&q=http://groups.go
In what was virtualfields development. Reviewing these threads was not
yet defined the syntax.
http://www.google.com/url?sa=D&q=http://groups.google.com/group/web2py/browse_thread/thread/c684346f13773f93&usg=AFQjCNH_O8OPkwXqLw9TOndBiAJhLNxVWw
http://www.google.com/url?sa=D&q=http://groups.google.
SO Freebsd.
In opera works fine, but in firefox fails, try to save the page as
html
Jose
--
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
ab -n 1 -c 1000 -k http://localhost/
If your website is slow, Rocket will only speed it up if you have lots
concurrent connections.
-tim
-Original Message-
From: "Michael Toomim"
Sent: Tuesday, March 16, 2010 5:32pm
To: "web2py-users"
Subject: [web2py] Re: no more cherrypy wsgiser
On Mar 17, 2010, at 9:59 AM, mdipierro wrote:
> There is no cookbook because there is nothing to be done other than:
>
> 0) register with gae and get an app_id
> 1) change the name in app.yaml (first line: replace web2py with your
> app_id)
> 2) run it locally
>
> dev_appserver.py web2py
>
>
I think user CJ did. But my memory may fail. I am sure it is in the
bazaar logs, but not in the hg logs.
On Mar 17, 3:40 pm, Wes James wrote:
> I just found 1.68.1 and it is not in the 0.8.1.1 edit_area. Someone
> along the line must have added the "save" and it just didn't make it
> over with t
I just found 1.68.1 and it is not in the 0.8.1.1 edit_area. Someone
along the line must have added the "save" and it just didn't make it
over with the 0.8.2 update.
-wes
On Wed, Mar 17, 2010 at 2:25 PM, Wes James wrote:
> Odd, I see:
>
> case "s":
> use = true;
>
LOL.
One of you added this to editarea long ago. I forgot so a few versions
ago I upgraded editarea without patching it. You told us. So I fixed
this in trunk (adding a credit to you).
Massimo
On Mar 17, 3:25 pm, Wes James wrote:
> Odd, I see:
>
> case "s":
> use = t
The problem is that doing a POST to a url with GET variables is
problematic since it is not in the html specs and different browsers
may behave in different ways. It should be avoided. The solution is to
pass request.vars.OF as a hidden form variable
FORM(,hidden=dict(OF=CodeOF))
On Mar 17,
Odd, I see:
case "s":
use = true;
eA.execCommand("save");
break;
in this older code - same as my patch. Why is it there and not in
other versions?
weeeiirrr
On Wed, Mar 17, 2010 at 2:18 PM, Wes James wrote:
> This is interest
This is interesting. If I take 0.8.1.1 from sourceforge, ctrl-s does
not work. If I take 0.8.1.1 from web2py 1.74.9 then ctrl-s works. Is
there some parameter that was set for ctrl-s to work and then was not
set for 0.8.2 in latest web2py?
-wes
On Wed, Mar 17, 2010 at 1:11 PM, Wes James wrote:
Here I am once again.
I've tried to find the explanation of the following fact but did not
manage.
I Have the following code in my controller:
def saisie():
...
CodeOF=request.vars.OF or request.vars.META_OF
Selection=FORM('Code OF:',
INPUT(_name='OF',_value=CodeOF,requires=IS_IN_DB(db, '
1. You don't have to do anything as long as you don't go to the ccache
function in admin. Otherwise, you can replace the ccache function in
controllers/admin.py with the ccache function in
controllers/appadmin.py (also found in web2py welcome trunk). It is
the same code, but the appadmin version pe
Massimo,
I just went and copied edit_area from an older web2py I had. It is
0.8.1.1 and the ctrl+s works there. I tried the sourceforge version
of edit_area, which you are probably are using too, 0.8.2 and ctrl+s
is does not work. Oddly my patch for making it work is not in the
same location as
Hi thadeus,
I'm trying to understand the blogitizor code, but I'm wasn't be able to
install it yet at all.
I'm using last version of web2py 1.76.1, and windows 7 with python 2.5.
1) I could install pygments with "easy_install" but couldn't install
guppy beacuse it requires python 2.6 and I ha
web2py.exe -h
should work but will look into it
web2py -M -a '' -p 443
you get the right error since you did not specify -S whichapp
On Mar 17, 12:07 pm, Wes James wrote:
> Massimo,
>
> When I run web2py.exe -h I get nothing - it just goes back to the
> prompt. I tried web2py -M -a '' -p 443
I am now able to indeed access appadmin via https :-)
Thank you!
On Wed, Mar 17, 2010 at 6:10 PM, mdipierro wrote:
> replace http://... with https://
>
> GAE has its own certificate. It works for me at
>
> https://web2py-crm.appspot.com/init/appadmin
>
> On Mar 17, 10:23 am, mat -- wrote:
>
The use of decorators predates the generic.json and it is still
approrpriate for jsonrpc and xmlrpc, but for pure json output I'd use
the new generic.json also because you can customize it by giving
a .json to each action.
On Mar 17, 1:09 pm, "mr.freeze" wrote:
> It seems you can return json/xml/
On Mar 17, 1:09 pm, "mr.freeze" wrote:
> It seems you can return json/xml/etc. data by either decorating an
> action with @service.json or by simply calling the action with a file
> extension index.json. Is there a difference?
The "extension" uses the generic view templates - have a look at thos
I was just looking back at your email it is this one:
http://web2py.com/examples/static/1.76.5.1.b/web2py_win.zip
-wes
On Wed, Mar 17, 2010 at 12:28 PM, mdipierro wrote:
> which one is the "latest windows version" 1.76.5 or 1.76.5.1.b?
>
> On Mar 17, 12:07 pm, Wes James wrote:
>> Massimo,
>>
which one is the "latest windows version" 1.76.5 or 1.76.5.1.b?
On Mar 17, 12:07 pm, Wes James wrote:
> Massimo,
>
> When I run web2py.exe -h I get nothing - it just goes back to the
> prompt. I tried web2py -M -a '' -p 443 I get an error: the
> system can't find the file specified. I have to j
It seems you can return json/xml/etc. data by either decorating an
action with @service.json or by simply calling the action with a file
extension index.json. Is there a difference?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to thi
Traceback (most recent call last):
File "/Users/chris/Dropbox/workspace/chris/gluon/restricted.py",
line 173, in restricted
exec ccode in environment
File "/Users/chris/Dropbox/workspace/chris/applications/init/
controllers/appadmin.py", line 410, in
File "/Users/chris/Dropbox/workspace/
I use it to develop research applications in biotechnology - eg.
discovering new bacteria, tracking scientific data, identifying
potential drugs. Web2py integrates beautifully with third-party tools
and scientific packages leading to efficient and agile product
development.
On Mar 12, 5:42 am, "Gi
Massimo,
When I run web2py.exe -h I get nothing - it just goes back to the
prompt. I tried web2py -M -a '' -p 443 I get an error: the
system can't find the file specified. I have to just run web2py or
web2py and get the gui to run it.
-wes
--
You received this message because you are subscrib
Can you post the complete traceback?
On Mar 17, 12:03 pm, Chris wrote:
> Hi,
> I have an upload field in my database that looks like this:
>
> db.define_table('page',
> Field('book_id', db.book, required=True),
> Field('number', 'integer', required=True),
> Field('body', 'text', requi
You can do this also with cache.disk. You can cache any primitive
python structure including lists and dicts.
I am sure redis has richer apis and lots more features than cache.disk
but still its apis are closer to cache than dbs.
I think we can have a cache.redis (and I will make a patch for it
al
Hi,
I have an upload field in my database that looks like this:
db.define_table('page',
Field('book_id', db.book, required=True),
Field('number', 'integer', required=True),
Field('body', 'text', required=True),
Field('image', 'upload', autodelete=True),
)
db.page.image.requires =
Because you are not the owner of that app so your google credentials
do not get you in.
If you are the owner of an app, it will work.
There is no cookbook because there is nothing to be done other than:
0) register with gae and get an app_id
1) change the name in app.yaml (first line: replace we
"
Values in Redis can be Strings as in a conventional key-value store,
but also Lists, Sets, and SortedSets (to be support in version 1.1).
This data types allow pushing/poping elements, or adding/removing
them, also perform server side union, intersection, difference between
sets, and so forth dep
>I think this is more appropriate as a replacement for cache.ram than
>db.
maybe. but there is more than caching there:
"
While all the data lives in memory, changes are asynchronously saved
on disk using flexible policies based on elapsed time and/or number of
updates since last save.
If you ca
On Mar 17, 2010, at 9:10 AM, mdipierro wrote:
> replace http://... with https://
>
> GAE has its own certificate. It works for me at
>
> https://web2py-crm.appspot.com/init/appadmin
Where's the best approximation of a cookbook approach for running web2py on
GAE? I looked at the deployment
Does the GAE SSL certificate compatible with google checkout?
The snag with using plugin google checkout level 2 integration is the
need for a $80/year SSL certificate :(
-Thadeus
On Wed, Mar 17, 2010 at 11:10 AM, mdipierro wrote:
> replace http://... with https://
>
> GAE has its own c
replace http://... with https://
GAE has its own certificate. It works for me at
https://web2py-crm.appspot.com/init/appadmin
On Mar 17, 10:23 am, mat -- wrote:
> Hi - can someone (re)explain how to get appadmin running on GAE?
> On non-GAE hosting I understand it requires SSH tunnel. But i
Hi - can someone (re)explain how to get appadmin running on GAE?
On non-GAE hosting I understand it requires SSH tunnel. But is there an
equivalent on GAE? Currently, when accessing appadmin on both local GAE and
GAE I get: "Admin is disable because insecure channel". Does the app.yaml
file need to
This is not a web2py issue.
File "", line 1, in bind
socket.error: (48, 'Address already in use')
You have some other server running using the same port.
I just tried appadmin and works file with me.
On Mar 17, 8:57 am, Al wrote:
> The appadmin can be run on GAE, but it cannot run on local G
What error do you get? What triggers it? I do not think it related to
timeout of database.
On Mar 17, 6:01 am, vince wrote:
> i understand sqlite is not for heavy usage. i just want to know is
> there any way to set the timeout for database file access before
> returning "database is locked" erro
The problem with appadmin is that it is designed for the administrator
and has security issues. A user can execute any python code he/she
wants in the query string. This is a feature because its use is
supposed to be restricted to the administrator. Users have to be
trusted to expose appadmin to th
I think this is more appropriate as a replacement for cache.ram than
db.
On Mar 16, 11:38 pm, Thadeus Burgess wrote:
> Interesting, though for integration with the DAL this would require...
> some work! :) It seems that you will have to manually store lots of
> metadata that a RDMS already handle
web2py and other web frameworks all deal with concurrency in the same
way. They can run multiple threads and multiple processes. It works
well with multiple installation behind a load balancer such as pound
or haproxy.
The framework is built by avoiding use of modules that are not thread
safe and t
The appadmin can be run on GAE, but it cannot run on local GAE SDK.
(note: I have been thinking it might due to some basic settings, not
just my code, which I have overlooked, as running T3 and C.R.M
appliances have the same problem). I have customised myapp according
to the web2py manual to suit G
@ls1 : Nice! That sounds quite cool. Can you give any more info?
On Wed, Mar 17, 2010 at 10:47 AM, ls1 wrote:
> - moulds and
> - machinery management in manufacturing plant
>
> On 17 Mar, 07:53, Joe Barnhart wrote:
> > I'm using web2py to create applications for competitive swimming. I have
>
to your console.
On 17 Mart, 13:41, mohammed al-moustady
wrote:
> thank you hamdy but it is irrelevant to the code.
>
> BTW
> mdipierro
>
> do you mean print statement in the code itself? I thought it was s
> special function..
> ok even If I do these print statements were would it print to?
>
>
thank you hamdy but it is irrelevant to the code.
BTW
mdipierro
do you mean print statement in the code itself? I thought it was s
special function..
ok even If I do these print statements were would it print to?
On Mar 17, 10:16 am, "hamdy.a.farag" wrote:
> Hi Mohammed,
>
> I faced a problem l
i understand sqlite is not for heavy usage. i just want to know is
there any way to set the timeout for database file access before
returning "database is locked" error?
also is there any way to catch the error and return some "busy" error
page?
although i do not have problem with for eg. mysql,
These links are a good resource. But I'll need to figure out if I can
get it working in my current application. Thanks for your wonderful
support. I'll keep you all posted if I get success.
Rahul.
On Mar 15, 8:19 pm, mdipierro wrote:
> For now look at the following links that may help you:
>
> F
Matt,
I have the exactly opposite problem, my appadmin (latest version) runs
on GAE but it does not run locally, it has a yellow triangle with a !
sign in it. Have you modified the app.yaml - please see my other post:
http://groups.google.com/group/web2py/browse_thread/thread/3c6041a6b4e019c0/af6
hahaha, I knew that you couldn't resist...thanks again for your excelent
work.
alex
El 17/03/2010 10:45, mr.freeze escribió:
There is now :)
On Mar 17, 4:40 am, Alex Fanjul wrote:
there is no screenshot of working examplestrange from you mr.
freeze!! :-P
thanks for your slices
alex
There is now :)
On Mar 17, 4:40 am, Alex Fanjul wrote:
> there is no screenshot of working examplestrange from you mr.
> freeze!! :-P
> thanks for your slices
> alex
>
> El 17/03/2010 5:01, mr.freeze escribi :
>
> > Here's a simple example of getting jqGrid working with web2py. I'll be
> > im
there is no screenshot of working examplestrange from you mr.
freeze!! :-P
thanks for your slices
alex
El 17/03/2010 5:01, mr.freeze escribió:
Here's a simple example of getting jqGrid working with web2py. I'll be
improving it as I go along so feedback is welcome:
http://www.web2pyslices.co
there is no screenshot of working examplestrange from you mr. freeze!!
thanks for your slices
alex
El 17/03/2010 5:01, mr.freeze escribió:
Here's a simple example of getting jqGrid working with web2py. I'll be
improving it as I go along so feedback is welcome:
http://www.web2pyslices.com/mai
- moulds and
- machinery management in manufacturing plant
On 17 Mar, 07:53, Joe Barnhart wrote:
> I'm using web2py to create applications for competitive swimming. I have an
> online meet entry website now for high school swim events and plan to add a
> website that will actually run the meet p
I had actually used appadmin in production for a particular database
for several months. The users were the same as you are describing
(end-user, used to excel).
Now that it is time to give them the real app (as appadmin was just a
quick get us up and running)... they are actually sad to see us st
Hi Mohammed,
I faced a problem like this one b4 and simply as mdipierro said it was
a logic problem
try the validation function with the minimal code that works then add
line by line and check whether it works or not
then you'll detect when it fails
Oh BTW
if form.accepts(request.vars,session, o
Hi weheh
if you've added this line to your db.py model
auth.settings.create_user_groups = True
then you'll have a group created automatically per registering a new
user and called 'user_id' where id is the id of the registered user
then you can add permissions on that group as you wish and if y
87 matches
Mail list logo
