+1
Having this option would make it really simple to change between the
full-blown DAL result set and a faster stripped down one (which could
then be adapted with the processor to keep the rest of the code
working.)
I've been thinking about something like this as well. Instead of a separate
I post here this discussion because I'm not yet subscribed to the
developers list and this regards the documentation...
Il 09/02/2012 18:55, Massimo Di Pierro ha scritto:
this is a good point. The problem is how to fix it.
sqlhtml does not take a ondelete (perhaps it should, and grid should
- Is it possible to call scheduled_workers functions asynchronously?
How?
- How should I adapt the behavior of a scheduled_worker as changing
its model and adding new functionality?
Thank you
Omi, We tried the solution that you have mentioned using join provided
by web2py, it works fine on local server.
But when we run it in google appengine sandbox or deploy it using
google app engine it gives the error Too many tables in the query.
Is there a solution to resolve this? Is there any
On 9 February 2012 18:14, Bruno Rocha rochacbr...@gmail.com wrote:
I dont know exactly how it works, but I had problems serializing db in to
current, so Massimo said to always pass it explicitly to classes ad
functions, I remember that SQLITE worked, but not Postgres.
Anthony's advice to me
I have an application on google app engine.
I have used web2py framework to develop the application
I have a module in which I need to fetch the records from 3 tables and
the final set of records contain data from all the 3 tables.
Here each of my tables contain more than 1000 records so when I
other ways to do it without using current.
in the module (ex. tools.py):
def regte_verwysing(regte, tabel, veld, db):
lys = db(db[tabel].article == regte).select(db[tabel][veld])
verwysings = [x[veld] for x in lys]
return verwysings
in the model (ex. db.py):
import tools.py
I had this same doubt and this thread have helped as there is no
explanation on online book.
But I want to make the rows selectable to allow user to update all them
toguether.
I have no clue how to edit the submit button that shows at the end of the
table when selectable is active.
Any tips?
Niphlod,
Just out of curiosity.
Is the dal connection pooled?
If in postgres you CLUSTER on the salary index do figures change?
mic
2012/2/10 BrendanC bren...@gmail.com:
Niphlod,
Thanks (belatedly) for your valuable contribution and your test results.
The only thing missing from your test
ofcoz i put all the reusable code inside modules and such. and most are
object oriented.
But that is not a choice WHEN you want to separate Controllers thats going
to serve ONLY JSONRPC and controller for HTML only.Folder becomes only
necessary choice.
On one application , i have 20 JSON RPC
just take a look to
http://web2py.com/book/default/chapter/06#Connection-pooling for
understanding how DAL handles connections.
Your initial question was a concern on speed on aggregate and unions, and
the script you provided clearly use one and only one db connection.
I'm sorry if I
Help me understand.
session[request.controller] = {} # This works great
# Raises an exception unless foo is already an attribute of
session[request.controller]
bar = session[request.controller].foo
AttributeError: 'dict' object has no attribute 'foo' # Okay, makes
sense
# I think this should
# I think this should work:
if 'column_select_value' in session[request.controller].keys():
column_select_value =
session[request.controller].column_select_value
# But I get this:
AttributeError: 'dict' object has no attribute 'column_select_value'
In Python, you cannot
Done : Issue 655 http://code.google.com/p/web2py/issues/detail?id=655:Adding
cache argument to .count()
Richard
On Fri, Feb 10, 2012 at 12:02 AM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
open a ticket. this should be added
On Feb 9, 11:42 am, Richard Vézina
With web2py being licensed under LGPL it is possible to build applications
which are proprietary software. To some degree it is even possible to build
another web framework that uses unchanged web2py code as back-end. In
practice, however, the latter is too complicated on a technical level. The
Niphold,
Thanks for the reply.
My first question is about this:
http://www.postgresql.org/docs/8.1/static/sql-cluster.html. Sorry if
I did not explicit about what I was referring, as it is postgresql
specific. I was wondering if you would see different figures or not,
because order by is
Sorry, I forgot GAE doesn't support Join. I can't think of any other
way except your original one. I heard now mysql is available on GAE.
Maybe you can try if the support join ?
http://googleappengine.blogspot.com/2011/10/google-cloud-sql-your-database-in-cloud.html
On Feb 10, 6:10 am, Saurabh S
Anthony, thank you.
I get it now. I somehow thought these two are equivalent:
session[request.controller].something = 'foo'
session[request.controller]['something'] = 'foo'
Obviously they aren't.
On Feb 10, 8:41 am, Anthony abasta...@gmail.com wrote:
# I think this should work:
if
I'm not sure this happen for postgres but I think it's a bug.
I submit the issue #656.
http://code.google.com/p/web2py/issues/detail?id=656
On Feb 9, 1:58 pm, Niphlod niph...@gmail.com wrote:
that seems a float vs decimal problem
bottom line, I didn't get what is not working right
Is there some way to run Web2Py on PyPy http://pypy.org?
Hello,
I am working on a module for my current site that will make doing
internationalization easier for non-technical people. Primary reason the
current site will be translated into 5 different languages to start and the
people doing the translations are not very good with technology to some
Instead of using gluon, I pass it while importing the module.
For example, if my module is commons, then in my controller:
import commons
commons.db = db
commons.request = request
commons.session = session
Now db , request and session should now be available in the module...
Check the app engine requests log to make sure the right task URL is being
used.
some questions/thoughts:
- local test server or production?
- did you check the task queue? in production go to the admin console and
find the task queues link. in local test go to /_ah/admin and find the
task queue link
- is params a required argument to taskqueue.add()? i don't know if
While reading the web2pybook on page
http://web2py.com/books/default/chapter/29/5 in the def...return chapter I
tried to enter the code into the images shell controller
(http://127.0.0.1:8000/admin/shell/index/images) to kind of test out both
the code and using the shell.
I copied this into
I just want to report here about this thread that it seems that computed
field has to be set to readable and writable = True to make the computed
field to be effectively computed on form submit. Computed field won't
appears in form but will be computed. If not readable and writable True (I
didn't
uhm, could be interesting. I myself have some problems updating the
language of an application that has ~1200 strings with the normal admin
page.
Having them inside a db would be useful but I don't think I'll use the
translate directly on the site feature I placed some T()s inside
but this project which i doing alone now , with a team with different
people , which going to grow soon to 15 members thats become big problem.
* correction * Which i was doing alone Before , now I am with a team of
different programming background.
On Fri, Feb 10, 2012 at 7:27 PM, Phyo
I needed to put:
print itemize1('www.google.com')
I forgot the print command.
You make a good point on the ~1200 strings. The language files are just
python dictionaries, so I don't see any reason why we can't provide paging
so make the file easier to work with.
Sure if you would like to help the more people the better as I think
everyone using web2py would benefit from
On Feb 10, 2012, at 4:57 AM, Phyo Arkar wrote:
On one application , i have 20 JSON RPC methods , separated by each
controller. It going to be more than 100 JSORPC methods within 1 year for
whole project.
Out of curiosity: why only one method per controller?
SQLFORM.grid has ondelete, SQLFORM(...).accept(...) does not. The book
is correct.
The problem is that grid uses ondelete when doing ajax delete but not
when using SQLFORM(...).accept(...)
On Feb 10, 4:03 am, Manuele Pesenti manuele.pese...@gmail.com wrote:
I post here this discussion because
Not sure I understand. You do not call scheduled_workers functions.
You schedule tasks. Workers pick them up from queue an execute them
using the available power.
On Feb 10, 4:54 am, blackthorne francisco@gmail.com wrote:
- Is it possible to call scheduled_workers functions asynchronously?
@mcm : I was replying to BrendanC.
On cluster indexes: retried, getting slighly better resultsthis timings
don't get into account the actual CLUSTER operation, only the queries
fired after having the table reindexed.
method1 : 20.4900407235
method2 : 4.55434324348
method3 : 5.32198321083
Yet on schedules, if my task failed or timed out, will web2py try to
run it next time?
On Fri, Feb 10, 2012 at 3:39 PM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
Not sure I understand. You do not call scheduled_workers functions.
You schedule tasks. Workers pick them up from queue
no problem. just for the record, in the admin app the vertical length of
the page would be a minor problem for me if the untranslated strings showed
before/after the yet translated ones ... 1200 strings before, add a
controller, 1250 strings after, also if they are highlighted it's heavy to
i'm connected trough ssh to a remote linux box .. i started web2py by command
line using :
python web2py.py -i 10.0.1.7 -p 8080 -a xx
if i go on the web page :
http://myip:8080/welcome/default/index
i can access to the web2py main page, but if i try to login to the admin
interface
Ciao Massimo,
You suggest you do not disable it. Instead run:
python web2py.py -i 10.0.1.7 -p 8080 -a ''
python web2py.py -i 127.0.0.1 -p 8081 -a xx
then connect to 8081 via ssl tunnel.
exposing admin without https is a major security risk. If you really
want to do, you can comment the
Another option, which I use is to generate SSL certs and run web2py with -k
and -c so that web2py runs on SSL, enabling admin from other computers.
Of course I have interess for all what can improve internalization, because
at this time it is not very clever.
Current problems:
1) No data from where (in sources) the current string is. It would be nice
to have inforrmation like web2py core, instantpress, plugin xxx, my
application yyy. So
Here *request* is a user requesting a page, not your application making
a query to the database.
OK - now that clears up my confusion and it all makes sense- guess I was
having a YASM (yet another senior momentg) here. (So used to thinking in
terms of http requests it's easy to forget the
Hi,
I have posted a question about getting this to work with DAL, I am unable
to do so. Therefor wish to just use executesql but am also having some
issues.
The way we have been doing it with sqlalchemy:
sqlstr = select sum(happen_amount) from cash_journal
where
The model follows. Focus on the category.name field (and point out
anything else that looks wrong/inept). Looks like I have belt,
suspenders, and back-up suspenders for that field. I need
category.name to be unique and not empty. Is it the
requires=IS_NOT_EMPTY() that forces me to use
I am interested in this, did you see how Magento inline translations works?
Let me know if I can help.
http://zerp.ly/rochacbruno
Em 10/02/2012 13:42, Bruce Wade bruce.w...@gmail.com escreveu:
Hello,
I am working on a module for my current site that will make doing
internationalization
one option working with the framework as is:
- make a controller called jsonrpc with 1 method
- use the first arg from the request.args to select the module to call
- create a directory in modules and put all your calls in there.
- import and invoke the modules as needed by the controller
what db is involved ?
placeholders can have different formats, I don't recall using the
:variable notation...
PS: I'm assming that the seconds() method in the other thread didn't
worked... sorry for that
In summary, creating a person table from the web2py shell creates an entry
in the SQL log but does not create the table.
I'm using the images example webapp for working the examples in Chapter
26http://web2py.com/books/default/chapter/29/6.
I entered...
db.define_table('person',
On Fri, Feb 10, 2012 at 1:00 PM, Wikus van de Merwe
dupakrop...@googlemail.com wrote:
GPLv3
Whats the key differences between GPLv3 and LGPLv3 ?
--
Bruno Rocha
[http://rochacbruno.com.br]
PS: for postgresql, it's nasty ... placeholders are in python notation, so
db.executesql('select * from %s', placeholders=('example'))
or
db.executesql('select * from %(tablename)s', placeholders={'tablename' :
'example'})
works.
If payback types is passed as a string, you need to add a %
Yeah the DAL didn't work as planed.
Your final suggestion worked. I was using postgresql. With sqlalchemy you
can use :keyword I guess web2py requires %%(keyword)s as you said above.
Thanks for the help, this one was driving me crazy :D
On Fri, Feb 10, 2012 at 12:16 PM, Niphlod
Here is why openoffice moved from GPL to LGPL:
http://blogs.oracle.com/webmink/entry/openoffice_org_goes_to_lgplv3
On Fri, Feb 10, 2012 at 12:09 PM, Bruno Rocha rochacbr...@gmail.com wrote:
On Fri, Feb 10, 2012 at 1:00 PM, Wikus van de Merwe
dupakrop...@googlemail.com wrote:
GPLv3
You did not db.commit() it
On Feb 10, 2:04 pm, Bill Thayer bill.tha...@live.com wrote:
In summary, creating a person table from the web2py shell creates an entry
in the SQL log but does not create the table.
I'm using the images example webapp for working the examples in Chapter
I am looking into writing lots of documentation and have been looking
around at the different solutions. I know that the web2py book was written
with Markin, and seeing as how it is able to output to multiple different
formats and supports things like tables and image alignment, I figure it's
On Friday, February 10, 2012 3:09:56 PM UTC-5, rochacbruno wrote:
On Fri, Feb 10, 2012 at 1:00 PM, Wikus van de Merwe
dupakrop...@googlemail.com wrote:
GPLv3
Whats the key differences between GPLv3 and LGPLv3 ?
I think basically LGPL allows linking of proprietary software and GPL
it's actually not web2py, but the db adapter .
Also, it would be a lot easier without having to taking into account the
first interpolation (payback_types = ('s','p')) .
In that case you can use the simple %(name)s notation with dict as
placeholders parameter, or the positional one with
well, I did it, LGPLv3
https://github.com/rochacbruno/Movuca/blob/master/LICENSE
I needed to choose today because I will start a big project for one client
using Movuca as base, and I read too much (do not understand everything)
but I think LPGP will fits it.
Only question I have is:
I am using
CKEditor is licensed under LGPL, so you're good there. As for
plugin_ckeditor. I wrote it, but I haven't given it a license yet (on my
todo list). However, I will probably go with LGPL as well. It only makes
sense as web2py and CKEditor are both LGPL. So you are all set with the
CKEditor
Thanks for your tips.
I'm out of office in these days so I cannot test it now. I was just
thinking to the solution suggested by tom. I will try it because I
will have to serve various applications. I will need to remove the w2p
prefix too to obtain (e.g.):
http://server2/cpa4 and
Hi,
i have search posts on this group, but i don't have found the solution
of my question :$
I have a table, wich display record of a database, nothing weird..
I have made a form, so you can filter the result.
You can check Tag of the record, Status of the record, so on...
How can i create an
jodb.define_table('category',
Field('name', 'string', length=100, unique = True, requires =
IS_NOT_EMPTY()),
Here, by explicitly specifying requires, you are preventing web2py from
automatically adding the IS_NOT_IN_DB validator, so you have to add that
one explicitly as well.
*queries=[]*
*if arg1 == x: queries.append(db.table.field == x)*
*if arg2 == y: queries.append(db.table.otherfield == y)*
*# many conditions here*
*query = reduce(lambda a,b:(ab),queries)*
*db(query).select()*
On Fri, Feb 10, 2012 at 8:10 PM, gbs grosbe...@gmail.com wrote:
Hi,
i
I know that you can do :
result = db((db.xxx.tag==tag) (db.xxx.status==status)).select()
But i don't know how to generate the condition, one by one...
On 10 fév, 23:10, gbs grosbe...@gmail.com wrote:
Hi,
i have search posts on this group, but i don't have found the solution
of my
Oh? you think?
Ok i will test, thanks a lot!
On 10 fév, 23:18, Bruno Rocha rochacbr...@gmail.com wrote:
*queries=[]*
*if arg1 == x: queries.append(db.table.field == x)*
*if arg2 == y: queries.append(db.table.otherfield == y)*
*# many conditions here*
*query = reduce(lambda
You could do something like:
query = db.mytable.id 0
if tag:
query = db.mytable.tag == tag
if status:
query = db.mytable.status == status
Anthony
On Friday, February 10, 2012 5:10:01 PM UTC-5, gbs wrote:
Hi,
i have search posts on this group, but i don't have found the solution
You can reach a very high level of
parallelism with lower dead-locking probability than with java
threads.
any source about that ? (any paper, benchmarks etc...)
Search for something like Guido van Rossum threading vs forking or
read some recent Bruce Eckel books. The summary is that
sql = db
-- if tag :
sql = sql(db.mytable.tag = xxx)
-- if status:
sql = sql(db.mytable.status = xxx)
result = sql.select()
On Fri, Feb 10, 2012 at 2:25 PM, Anthony abasta...@gmail.com wrote:
You could do something like:
query = db.mytable.id 0
if tag:
query = db.mytable.tag ==
Thanks to all.
I have test the first answer, from Bruno..
It's work!
Thanks a lot, i'm searching/reading during a long time!
I will test the others solutions, why i think they are more simple/
comprehensible for me :$
Best regards
ps : sorry for the language
On 10 fév, 23:18, Bruno Rocha
On Friday, February 10, 2012 5:35:50 PM UTC-5, Detectedstealth wrote:
sql = db
-- if tag :
sql = sql(db.mytable.tag = xxx)
-- if status:
sql = sql(db.mytable.status = xxx)
result = sql.select()
Yes, that's nice too. It works because the Set object is callable, and
calling it adds a
2012/2/9 Sebastian E. Ovide sebastian.ov...@gmail.com:
That is a nice trick for sharing information with different processes
reducing to the minimum the FS IO... It still has the IO bottleneck of
read/write from/to file compare with real data permanent in memory... but
still a valid
I wrote:
The problem with MAP_ANONYMOUS is that you cannot share after fork.
I should have written: you cannot share *a mmap created* after fork.
http://www.kernel.org/doc/man-pages/online/pages/man2/mmap.2.html
If you are on Linux here you find some quick explanation how mmap,
tmpfs and
There's a tree structure among the record, upon which the aggregation is
computed.
Some dbs (e.g. oracle) have extensions for tree-like structures (CONNECT BY
etc), but it is not standard, and I need to support both sqlite and
postgres in this app.
This solution will lead to a race condition. Do not use it!
If you have multiple threads, they might update your commons at the same
time and you'll get request from one session, and session from another, and
db from a third.
current is a thread-local thing, guaranteed not to be touched by any
I usually run it with -i 0.0.0.0 , which means it listens simultaneously on
127.x.y.z and on any other address the computer might have. The admin pages
are accessible only when coming through localhost (127.0.0.1) or ssl, no
need for different processes/ports.
There's very useful information about debugging web2py here:
http://groups.google.com/group/web2py/browse_thread/thread/7ea4aadbd2676e3/c714f62f47db2968
On 10 feb, 03:53, shartha m.mirghorb...@gmail.com wrote:
I found some older posts on how to debug using web2py.py. Such file
doesn't exist in
I have try the solution of anthony, but i don't have the skill in
python to success..
(some error with 'Rows' object has no attribute 'select', etc ;)
But it's my fault,
Thanks again
On 10 fév, 23:43, gbs grosbe...@gmail.com wrote:
Thanks to all.
I have test the first answer, from Bruno..
On Friday, February 10, 2012 6:19:09 PM UTC-5, gbs wrote:
I have try the solution of anthony, but i don't have the skill in
python to success..
(some error with 'Rows' object has no attribute 'select', etc ;)
Once the query has been built, this should work:
rows = db(query).select()
It looks nice.
The registration validation returns a None error at the first
section. I think that the text font is oversized (seen with Firefox
3.6.24 and a 16 LCD)
Regards
On 9 feb, 22:29, Bruce Wade bruce.w...@gmail.com wrote:
Hi,
I know I have been posting a lot of questions in this
If you mean having markmin to give the image a given width, this migth
help:
... This paragraph has an image aligned to the right with a width of
200px. Its is placed using the code
[[some image http://www.web2py.com/examples/static/web2py_logo.png
right 200px]]. ...
from here:
Yes, thanks, you'r right.
With you'r method, it's simple ;)
And you can make AND condition :
query = db.mytable.tag == tag
OR condition :
query |= db.mytable.tag == tag
It's exactly what i'm seeking!
You'r solution, and Bruno's one, are perfect,
I hope that can help someone else,
Have a nice
I belive there's no info about this case in the book, perhaps you
could use form helpers and other tags into the link placeholders after
the menu object creation, modifying the MENU output, so the effect
would be similar to what you described. However, there could be some
issues with the display
Yeah the None error is because we need to add an error message for
IS_STRONG for some reason that validator doesn't return any message,
possibly a bug??
I agree the fonts are oversized however that is what the CEO wants because
most of our members are older people who are not very good with
Sorry, to reopen this thread, I have a question close to this one.
I want to invoke a method called plugin_run from a scheduler task.
def plugin_run(plugin_title, **kw): - this is the signature
plugin_run('http',targets=['https://www.google.pt']) - valid example
considering this, how should I
Never mind, just did it!
args=[]
vars={plugin_title:http,targets:[http://www.google.pt]}
On Feb 11, 2:08 am, blackthorne francisco@gmail.com wrote:
Sorry, to reopen this thread, I have a question close to this one.
I want to invoke a method called plugin_run from a scheduler task.
def
Thanks for that!
I've never tested it in a multi-threaded environment.
On Sat, Feb 11, 2012 at 4:41 AM, nick name i.like.privacy@gmail.comwrote:
This solution will lead to a race condition. Do not use it!
If you have multiple threads, they might update your commons at the same
time and
Thank you Anthony, I am going to talk about it with Michele.
On Fri, Feb 10, 2012 at 7:44 PM, Anthony abasta...@gmail.com wrote:
Only question I have is:
I am using MIchelle's code to facebook and google Oauth. [
I am using eclipse + pydev for debugging.
It rocks.
Miguel Lopes has shared a excellent write-up on how-to.
You might be interested in this thread (see the 4th from last post)
Forgot to mention that Full version of Eclipse is Not required. Only
the runtime.
You need to google for the runtime binary version download link.
-- V
On Feb 11, 9:28 am, Vineet vineet.deod...@gmail.com wrote:
I am using eclipse + pydev for debugging.
It rocks.
Miguel Lopes has shared a
strange, really :D
I don't mind if that turns out in the logging, but I have the same
behaviour
niphlod@platypus:~$ uwsgi-python --version
uWSGI 0.9.6.8
I use uwsgi-python in production /usr/bin/uwsgi-python . If I recall
correctly that is a symbolic link to
Richard,
Here is my minimal code for returning json data in dataTables via
web2py's ajax function.
---View---
!-- here's a well-formed table --
table id=abc_table
thead
tr
thABC Category Name/th
thCode/th
/tr
/thead
tbody
/tbody
/table
script
// this I keep in js folder
function
89 matches
Mail list logo