[web2py] Re: How to set/reset administrator password (apache+wsgi+windows)

2012-12-25 Thread Paolo Caruccio
My simple way: a) stop apache server b) start web2py server in standard way by double clicking web2py.py in order that it creates its own files c) in displayed window set the admin password d) stop web2py server and check that in web2py folder there are options_std.py and parameters_8000.py e)

[web2py] Re: How to set/reset administrator password (apache+wsgi+windows)

2012-12-25 Thread Paolo Caruccio
Il giorno martedì 25 dicembre 2012 19:41:17 UTC+1, Paolo Caruccio ha scritto: My simple way: a) stop apache server b) start web2py server in standard way by double clicking web2py.py in order that it creates its own files c) in displayed window set the admin password d) stop web2py

[web2py] Re: Get url of uploaded file

2012-12-27 Thread Paolo Caruccio
Following code should work {{=URL('download', args=audio.filepath)}} Please read http://web2py.com/books/default/chapter/29/04#URLhttp://web2py.com/books/default/chapter/29/04#URL to learn more about URL mapping. Il giorno giovedì 27 dicembre 2012 13:03:07 UTC+1, Eduardo Costa Lopes ha

[web2py] Re: Problems with the MENU helper function and HTML5

2012-12-29 Thread Paolo Caruccio
One possible solution (not tested). 1 step) in static/js create a new file named web2py_metroui.js having the following contents jQuery(function(){ jQuery('.menuli.dropdown').each(function(){ jQuery(this).attr({'class':'','data-role':'dropdown'}); }); jQuery('.menu li

[web2py] Re: Problems with the MENU helper function and HTML5

2012-12-31 Thread Paolo Caruccio
for eventual bugs you'll find Happy New Year!! Il giorno domenica 30 dicembre 2012 23:01:28 UTC+1, Paolo Caruccio ha scritto: I don't think that MENU helper is the guilty in your case. I made a metroui version of welcome app (see the images). Follows the list of involved files: 1) views

Re: [web2py] geodal

2013-01-05 Thread Paolo valleri
Hi Massimo, I have just tried a few examples but there is a bug in the getPoint function, please find attached a simple patch to fix it. Paolo On Monday, December 24, 2012 7:21:12 PM UTC+1, Massimo Di Pierro wrote: Thank you Denes. Would you please check my changes. I do not think I broke

Re: [web2py] geodal

2013-01-06 Thread Paolo valleri
Hi Massimo, I've tried the same 3 tests. The first one failed, it was working before though, the ticket: Traceback (most recent call last): File /home/paolo/Dropbox/git/web2py/gluon/restricted.py, line 212, in restricted exec ccode in environment File /home/paolo/Dropbox/git/web2py

Re: [web2py] geodal

2013-01-06 Thread Paolo valleri
well done! All the former tests worked. I will investigate more the others functions as soon as possible. Paolo On Sunday, January 6, 2013 4:28:13 PM UTC+1, Massimo Di Pierro wrote: One more try please. On Sunday, 6 January 2013 02:11:09 UTC-6, Paolo valleri wrote: Hi Massimo, I've

[web2py] self join on postgres

2013-01-07 Thread Paolo valleri
start.gathered_on); and it fails raising the following error: Traceback (most recent call last): File /home/paolo/Dropbox/git/web2py/gluon/restricted.py, line 212, in restricted exec ccode in environment File /home/paolo/Dropbox/git/web2py/applications/vtraffic/controllers/default.py

[web2py] Re: self join on postgres

2013-01-07 Thread Paolo valleri
/pgsql-novice/2011-01/msg00069.php and now I am trying to understand how to define a sub_select with the limitby=1 to carry out the left join. Any idea ? Regards, Paolo On Monday, January 7, 2013 2:21:33 PM UTC+1, Niphlod wrote: did you try changing start and end as aliases ? while start

Re: [web2py] geodal

2013-01-08 Thread Paolo valleri
POINT(41.901514 12.460774),41.901514,12.460774 POINT(40.851775 14.268124),40.851775,14.268124 The geometry field MUST contain only point otherwise it raises an error. Hope it helps Paolo On Sunday, January 6, 2013 5:29:52 PM UTC+1, Paolo valleri wrote: Hi Massimo, I found an other strange

Re: [web2py] geodal

2013-01-08 Thread Paolo valleri
in dal.py .lower() at line 832: ftype = ftype % dict(schema=schema, tablename=tablename, fieldname=field_name.lower(), srid=srid, dimension=dimension) And now in the db I have the field *name_p* and *location_p* respectively Paolo

[web2py] Re: external link in menu with target option

2013-01-11 Thread Paolo Caruccio
While waiting web2py developers solve the issue, you could simply comment the line in web2py_bootstrap.js and see if all works as expected. In javascript a code line is commented when you put before it //, so the interested line becomes: // jQuery('ul.nav li.dropdown

Re: [web2py] Set up of db.py takes too long time

2013-01-15 Thread Paolo valleri
Try to add lazy_tables=True to DAL. Like: db = DAL('sqlite://storage.sqlite', migrate=False, lazy_tables=True) Paolo On Tuesday, January 15, 2013 10:06:03 AM UTC+1, Daniel Gonzalez wrote: No imports in the code-area profiled. Also, I am testing some requests, but the time I am measuring

[web2py] Re: Auth with migrate=False

2013-01-15 Thread Paolo valleri
is on the db definition. db = DAL('postgres://web2py:web2py@localhost:5432/traffic', migrate=False, lazy_tables=True, ) Paolo On Tuesday, January 15, 2013 11:38:49 AM UTC+1, Niphlod wrote: migrate=False is on the db or on Auth define_table() call ? Il giorno martedì 15 gennaio 2013 11:07

Re: [web2py] Re: Auth with migrate=False

2013-01-15 Thread Paolo valleri
: [ table.route_id.set_attributes(readable = False, writable = False), ] ) Paolo On Tuesday, January 15, 2013 3:10:32 PM UTC+1, Anthony wrote: Good point. Even better, use lazy_tables. You should also compile the app. On Tuesday, January 15, 2013 8:11:48 AM UTC-5, Paolo valleri wrote: Thanks

[web2py] auth.wiki menu

2013-01-15 Thread Paolo valleri
menu.py? Thanks, Paolo --

[web2py] Re: How experimental is postgis?

2013-01-17 Thread Paolo valleri
for the elevation) but also to define 3d polylines. The 2d doesn't work with 3d, the 3d works well with 3d and 2d. The only problem is that the 3d is not backward compatible with existing 2d objects. @Massimo, how would you go with that? Paolo On Thursday, January 17, 2013 10:47:59 AM UTC+1, encompass wrote

[web2py] Re: How do you change memcache session expiry?

2013-01-18 Thread Paolo valleri
to remove from the book the advise of storing the session in memcached unless we find a solution Paolo Il giorno domenica 30 settembre 2012 00:54:03 UTC+2, Robert Clark ha scritto: Thanks everyone, have added an issue http://code.google.com/p/web2py/issues/detail?id=1049 On Sunday, September 30

[web2py] problems with wiki create

2013-01-20 Thread Paolo valleri
Hi all, I've just updated web2py to trunk and it seems that wiki _create is broken. I got this ticket: Traceback (most recent call last): File /home/paolo/Dropbox/git/web2py/gluon/restricted.py, line 212, in restricted exec ccode in environment File /home/paolo/Dropbox/git/web2py

[web2py] Re: SQLFORM.factory and uploaded files. where is the link?

2013-01-23 Thread Paolo valleri
add upload=URL('default', 'download') should solve the problem. Paolo On Thursday, January 24, 2013 12:11:33 AM UTC+1, Ramos wrote: Hello I dont know how to show the link to the uploaded files using SQLFORM.factory my code form=SQLFORM.factory(db.trabalhador,db.t_docs

[web2py] auth.wiki how to format all fields

2013-01-25 Thread Paolo valleri
to name a few. Checking the code, I figured out that the problem is due to the test: extension==html (see tools.py:5090) Could we return the other fields too? Paolo --

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

2013-01-25 Thread Paolo valleri
) cache.ram = cache.disk = cache.memcache but I don't know how to understand the gain of using it. Any idea? paolo On Friday, January 25, 2013 9:51:22 PM UTC+1, Arnon Marcus wrote: Oh, and what about memcache? Can web2py benefit from it? Is there somewhere an explanation about this? On Fri, Jan

[web2py] Re: auth.wiki how to format all fields

2013-01-27 Thread Paolo valleri
to keep track of that, I have opened an issue http://code.google.com/p/web2py/issues/detail?id=1303 On Friday, January 25, 2013 3:32:55 PM UTC+1, Paolo valleri wrote: Dear all, I've just came across the fact that with the following code: def wiki(): return auth.wiki(render='html

[web2py] Re: auth.wiki how to format all fields

2013-01-27 Thread Paolo valleri
; in order to 'format' better the wiki page, it would be nice to have at least information such as the fields title and modified_on. paolo On Sunday, January 27, 2013 4:56:51 PM UTC+1, Massimo Di Pierro wrote: I do not fully understand the issue. Can you post more code as an example? On Friday

[web2py] Re: Howto Multi file uploader

2013-01-30 Thread Paolo valleri
I don't think you will find something out-of-the-box. However, I advice you to start from here: http://malsup.com/jquery/form/ On Wednesday, January 30, 2013 10:48:57 AM UTC+1, Ramos wrote: Hello, what is the best way to add multi file upload functionality. This is very important for me. I

[web2py] Re: contribute: db diagram for web2py appadmin

2013-01-31 Thread Paolo Caruccio
mercoledì 30 gennaio 2013 17:23:21 UTC+1, Paolo Caruccio ha scritto: I was not able to succesfully install pygraphviz on my windows7 64bit enviroment but I liked Jose's idea https://groups.google.com/d/topic/web2py/cFqD1M6rkc8/discussion, so I wrote a simple addendum to appadmin in order

[web2py] wiki: how to cache media files?

2013-01-31 Thread Paolo valleri
as commonly happens with for js or css. Is it a problem of my configuration or of wiki it self? paolo -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr

[web2py] Re: contribute: db diagram for web2py appadmin

2013-02-01 Thread Paolo Caruccio
to turn this into an admin plugin and allow appadmin to access it? On Wednesday, 30 January 2013 15:04:06 UTC-6, Paolo Caruccio wrote: Massimo, thanks for the compliments and for the suggestions. Actually, in my mind the posted code is a sort of appadmin plugin. For this reason I separated db

[web2py] Re: contribute: db diagram for web2py appadmin

2013-02-01 Thread Paolo Caruccio
Jose. thank you too for the amazing idea to draw a graph of the database. I take the opportunity to ask you where I can download a working pygraphviz build for windows. Il giorno giovedì 31 gennaio 2013 23:11:00 UTC+1, Jose ha scritto: Very nice. Excellent work Paolo. Jose -- --- You

[web2py] Re: contribute: db diagram for web2py appadmin

2013-02-02 Thread Paolo Caruccio
thank you. package downloaded from [1] setup.py modified following istructions on [2] After setup.py install command all worked fine. Il giorno sabato 2 febbraio 2013 14:03:09 UTC+1, Jose ha scritto: El viernes, 1 de febrero de 2013 15:50:43 UTC-3, Paolo Caruccio escribió: Jose. thank

[web2py] Re: contribute: db diagram for web2py appadmin

2013-02-03 Thread Paolo Caruccio
first post updated with latest version. Il giorno venerdì 1 febbraio 2013 21:21:28 UTC+1, Massimo Di Pierro ha scritto: Can you post a link to the latest? On Thursday, 31 January 2013 08:31:53 UTC-6, Paolo Caruccio wrote: first post updated: replaced following files db_diagram.html

[web2py] Re: login by ajax

2013-02-18 Thread Paolo valleri
+1 for auth,ajax_login() paolo On Monday, February 18, 2013 4:50:20 AM UTC+1, Massimo Di Pierro wrote: Should we offer something like {{=auth.ajax_login()}} helper which submits to /user/login? If would not be difficult to write. How should it work? On Sunday, 17 February 2013 21:37

[web2py] Re: [Newbee] - Error message with plugin_Wiki : 'auth' not defined

2013-02-20 Thread Paolo valleri
Hi Pibol, plugin_wiki is now deprecated, use auth.wiki() instead. http://web2py.com/books/default/chapter/29/03?search=auth.wiki#The-built-in-web2py-wiki paolo On Wednesday, February 20, 2013 3:17:42 PM UTC+1, open...@gmail.com wrote: Hi all, I am beginner in Web2Py and I like it much. I

Re: [web2py] Re: Scheduler: new plugin cs_plugin_monitor

2013-02-25 Thread Paolo valleri
Really nice job, +1 for shipping this with web2py. paolo On Sunday, February 24, 2013 3:34:03 PM UTC+1, Massimo Di Pierro wrote: I think this plugin should ship with web2py. ;-) On Sunday, 24 February 2013 07:28:11 UTC-6, Niphlod wrote: spoilers here https://www.dropbox.com/sh

[web2py] Re: [newbee] Wiki_plugin - WidgetBuilder-jqgrid : How to link data from db to jqgrid

2013-02-26 Thread Paolo valleri
Hi Bruno, plugin_wiki is deprecated and it has been replaced by auth.wiki, have a look here: http://web2py.com/books/default/chapter/29/03?search=auth.wiki#The-built-in-web2py-wiki Paolo On Tuesday, February 26, 2013 5:09:06 PM UTC+1, open...@gmail.com wrote: Hi, I am new on Web2py and I

[web2py] Re: SQLFORM in Bootstrap modal

2013-02-26 Thread Paolo valleri
jquery lines that fire the click event to the original sumbit when the modal submit is clicked. This approach is not clear at all, it works though, Something better would be nice to come. Paolo On Wednesday, February 27, 2013 3:59:36 AM UTC+1, Vincenzo Ampolo wrote: Hi, I'm looking to a way

[web2py] Re: Optimising caching and enabling gzip for web2py on heroku?

2013-03-03 Thread Paolo valleri
, in this case the 'somehow' is not clear to me yet. Paolo On Sunday, March 3, 2013 5:51:29 AM UTC+1, Alec Taylor wrote: Going through the Google PageSpeed Insights report (https://developers.google.com/speed/pagespeed/insights) to see what I should optimise to improve my site-load speed

[web2py] Re: web2py 2.4.2 is OUT

2013-03-03 Thread Paolo valleri
Good works, I will try it later today. I don't know if you have already discussed about that, just in case, I would suggest to start the use of git tags so it will be easier to update web2py and keep track of the different releases. Paolo On Monday, March 4, 2013 7:58:19 AM UTC+1, Massimo Di

[web2py] Re: web2py 2.4.2 is OUT

2013-03-05 Thread Paolo Caruccio
- graph representation of models - admin based on bootstrap, thanks Paolo - support for semantic versioning - new bootstrap based admin, thanks Paolo - improved scheduler (and change in scheduler field names), thanks Niphlod - graphiz support added to adm, thanks Jose - on_failure in grid

[web2py] Re: web2py 2.4.2 is OUT

2013-03-06 Thread Paolo Caruccio
corners to iron but I could not wait any longer. Changelog: - 2D GEO API: geoPoint, getLine, geoPolygon - support for 'json' field type in DAL - schema export with db.as_json/as_xml, thanks Alan - graph representation of models - admin based on bootstrap, thanks Paolo - support for semantic

Re: [web2py] Re: web2py 2.4.2 is OUT

2013-03-06 Thread Paolo Caruccio
- schema export with db.as_json/as_xml, thanks Alan - graph representation of models - admin based on bootstrap, thanks Paolo - support for semantic versioning - new bootstrap based admin, thanks Paolo - improved scheduler (and change in scheduler field names), thanks Niphlod - graphiz

[web2py] Re: Slow DAL initialization

2013-03-14 Thread Paolo valleri
I am wondering why the pool_size is set to 0 by default http://web2py.com/books/default/chapter/29/06#Connection-pooling Which are the side effect of having something greater than 0? Is not worth to have it set for example as 5 by default? paolo On Thursday, March 14, 2013 2:47:56 PM UTC+1

Re: [web2py] Re: Scheduler: new plugin cs_plugin_monitor

2013-03-15 Thread Paolo valleri
ret = self._db._adapter.insert(self, self._listify(fields)) File /home/pvalleri/src/web2py/gluon/dal.py, line 1201, in insert raise e OperationalError: database is locked Paolo On Thursday, February 28, 2013 10:57:40 PM UTC+1, Niphlod wrote: plugin just got beta status. I'd gladly

Re: [web2py] Re: Scheduler: new plugin cs_plugin_monitor

2013-03-16 Thread Paolo valleri
plugin!)? Paolo On Friday, March 15, 2013 11:29:26 AM UTC+1, Niphlod wrote: maybe the fact that you're using sqlite :D If you have a recent sqlite distribution activate the WAL, it can zero out the issues for normal loads (usually also for low loads SQLite ends up locked) Jokes aside, that's

[web2py] Cache performance with computed columns

2013-03-25 Thread Paolo valleri
. The question that came to my mind is about computed columns, are they cached? Paolo -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr

Re: [web2py] Re: Cache performance with computed columns

2013-03-25 Thread Paolo valleri
: 0.00217413902283 q1: 1.62124633789e-05 q2: 0.00206780433655 q1: 8.10623168945e-06 q2: 0.00120091438293 Given that, in a local env cache.ram is faster than memcache. Paolo On Monday, March 25, 2013 11:54:07 AM UTC+1, Niphlod wrote: well, when you plan to use cache you do it because

[web2py] scheduler sincronization

2013-03-25 Thread Paolo valleri
to impose more accuracy ? paolo -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https

Re: [web2py] Re: scheduler sincronization

2013-03-26 Thread Paolo valleri
problem or something different. Do you think that should be fixed by using a different db engine? Paolo On Tuesday, March 26, 2013 12:42:14 PM UTC+1, Niphlod wrote: with the default logging.conf the timestamp is present as in all other web2py-related logging PS: are you sure

Re: [web2py] Re: scheduler sincronization

2013-03-26 Thread Paolo valleri
that with a single worker, with that function that basically just prints something and an execution every 300 seconds the problem lies into a lock, unless the SQLite library available on your system is reallly old. On Tuesday, March 26, 2013 2:21:21 PM UTC+1, Paolo valleri wrote: When yesterday I saw

[web2py] Re: Just knew about Server-Sent Events and want to share it with you

2013-04-05 Thread Paolo Caruccio
Well, I just tested version 2.4.5 Stable ts 2013.04.04.21.10.38 and all worked for me. What issue have you encountered? Anyway, the code was and is experimental (for example it doesn't work on IE). If do you want something more tested please try comet messaging included in web2py as Derek

[web2py] Re: Server-Sent Events

2013-04-08 Thread Paolo Caruccio
When I wrote the small app SSE_clock I was searching a replacement for a long polling javascript code that I was using in order to push db's table update notifications to clients. I abandoned the project by lack of browser's support. Anyway, the application is a simple translation from php to

Re: [web2py] Re: Server-Sent Events

2013-04-09 Thread Paolo Caruccio
just a crazy question: what about if you wrap the eventsource in a web worker? Il giorno martedì 9 aprile 2013 22:56:51 UTC+2, Arnon Marcus ha scritto: The first yield WILL block the thread, but as you say, only the thread of that connection. So the inter-thread communication would then be

[web2py] Re: help with css

2013-04-14 Thread Paolo Caruccio
The first behavior (a small button is shown on narrow screen) is normal. The second no. Original behavior was to show all submenu when you clicked on small button. You could check this on web2py 2.3.0. Something broke this I'll investigate and submit a patch asap. Il giorno sabato 13 aprile

[web2py] Re: help with css

2013-04-14 Thread Paolo Caruccio
aprile 2013 16:52:03 UTC+2, Massimo Di Pierro ha scritto: Can we increase width that triggers the first behavior (small button)? On Sunday, 14 April 2013 05:06:01 UTC-5, Paolo Caruccio wrote: The first behavior (a small button is shown on narrow screen) is normal. The second no. Original

[web2py] Re: css-menu

2013-04-14 Thread Paolo Caruccio
The Niphlod's solution is better but add following rules .navbar-inverse .navbar-inner { background-color:green; background-image:none; } .navbar-inverse .navlia { color:red; } to the section other rules in web2py_bootstrap.css for a very fast and not complete customization. Il giorno

[web2py] Re: Where do I change the size of the editor object in admin?

2013-04-14 Thread Paolo Caruccio
A possible solution in order to hide the small vertical scrollbar displayed when the page is loaded: in applications/admin/static/codemirror/lib/codemirror.css please change line 13 from height: 300px; to height: auto; the css rule after the change will be: .CodeMirror-scroll { overflow:

[web2py] Re: Where do I change the size of the editor object in admin?

2013-04-14 Thread Paolo Caruccio
No. My previous solution doesn't work in all circumstances. The problem is more complex and involves the javascript code. Il giorno lunedì 15 aprile 2013 00:35:19 UTC+2, Paolo Caruccio ha scritto: A possible solution in order to hide the small vertical scrollbar displayed when the page

[web2py] Re: help with css

2013-04-15 Thread Paolo Caruccio
Patch sent https://code.google.com/p/web2py/issues/detail?id=1447 Il giorno lunedì 15 aprile 2013 05:48:16 UTC+2, Massimo Di Pierro ha scritto: Can you send me a patch? thanks. On Sunday, 14 April 2013 10:36:40 UTC-5, Paolo Caruccio wrote: I found the problem causing the submenu display

[web2py] Re: help with css

2013-04-15 Thread Paolo Caruccio
aprile 2013 16:42:39 UTC+2, Massimo Di Pierro ha scritto: Can you explain how that works? Il giorno lunedì 15 aprile 2013 05:47:48 UTC-5, Paolo Caruccio ha scritto: Patch sent https://code.google.com/p/web2py/issues/detail?id=1447 Il giorno lunedì 15 aprile 2013 05:48:16 UTC+2, Massimo

[web2py] Re: help with css

2013-04-16 Thread Paolo Caruccio
but on reduced browser windows only. The patch doesn''st change the button size. Il giorno martedì 16 aprile 2013 00:58:09 UTC+2, Massimo Di Pierro ha scritto: I did ( committing now) but I do not see any improvement. On Monday, 15 April 2013 10:28:07 UTC-5, Paolo Caruccio wrote: Please replace

[web2py] Re: @cache decorator

2013-04-18 Thread Paolo valleri
Basically it stores the output of the function, in your case the output is the rendered view. For more info about cache, have a look here: http://web2py.com/books/default/chapter/29/04#cache Paolo On Thursday, April 18, 2013 6:17:36 PM UTC+2, BlueShadow wrote: Hi I got a site which calls

[web2py] Re: db select with rows

2013-04-21 Thread Paolo valleri
( db(db.tableB.id http://db.tableb.id/==row.id).select() ) Paolo On Sunday, April 21, 2013 10:28:18 AM UTC+2, BlueShadow wrote: I can't get my head around this problem it's probably easy but I ask anyway: I got rows(lets call them rowsA) from tableA and I want to select all items from

[web2py] Re: bootstrap thumnails problem

2013-05-02 Thread Paolo Caruccio
This behavior is due to different number of text lines in labels. You could use a jquery plugin (search the net for jquery equal height) in order to give to the div.thumbnail the same height as tallest one. Or you could give to the div.thumbnail a fixed height and auto overflow-y by a css rule.

[web2py] Re: Dynamically change highlighted class for response.menu

2013-05-09 Thread Paolo Caruccio
for a pyhon solution (not involving javascript) you could check this argument https://groups.google.com/d/topic/web2py/8AHYqV_EKy0/discussion https://groups.google.com/d/topic/web2py/8AHYqV_EKy0/discussion Il giorno martedì 7 maggio 2013 17:56:10 UTC+2, Omi Chiba ha scritto: I have a

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Paolo valleri
I didn't know that as well, Is there a limit in the number of dicts passed to the bulk_insert? Paolo On Monday, May 20, 2013 11:18:51 AM UTC+2, Niphlod wrote: there's a bulk_insert method too. http://web2py.com/books/default/chapter/29/06?search=bulk Il giorno lunedì 20 maggio 2013 10:36

[web2py] Re: Bulk insert: how to improve performances?

2013-05-20 Thread Paolo valleri
that in our bulk_insert? Paolo On Monday, May 20, 2013 2:57:30 PM UTC+2, Niphlod wrote: this is the implementation def bulk_insert(self, table, items): return [self.insert(table,item) for item in items] no limits there, but it doesn't leverage any native BULK operation, so, don't pass

[web2py] Re: Scaling + performance tips to prepare for launch

2013-05-21 Thread Paolo valleri
It is worth to check this too https://developers.google.com/speed/pagespeed/insights Paolo On Tuesday, May 21, 2013 8:40:20 PM UTC+2, Niphlod wrote: the session.forget(response) will render all session related features useless. Use wisely. I'd add lazy_tables=True to your points, as well

[web2py] Re: Postgres users beware auth.signature is_active; bad problem, easy to fix

2013-05-24 Thread Paolo valleri
I agree, it would be nice to have is_active as a real boolean although I don't know how difficult could be its implementation without breaking the backward compatibility. Furthermore, I've just checked my instance and is_active is saved as 'T' with postgres 9.1 Paolo On Friday, May 24, 2013 5

[web2py] Re: DAL Select constant field

2013-05-30 Thread Paolo valleri
Hi, actually, I couldn't see the reason of that :-P but anyway this seems to work q=db( db.clients.id 0).select( db.clients.clientuuid, '%s' % 1) Paolo On Thursday, May 30, 2013 5:23:34 PM UTC+2, Zach wrote: Hi guys, I am trying to run something in the form of : select clientuuid, 1

[web2py] Re: web2py 2.4.7 admin Recent Tweets not loaded

2013-05-31 Thread Paolo valleri
we want to spread from the admin page. Paolo On Friday, May 31, 2013 3:19:27 PM UTC+2, Massimo Di Pierro wrote: Done. in trunk. On Thursday, 30 May 2013 22:39:10 UTC-5, 黄祥 wrote: hi, just want to report that web2py 2.4.7 admin Recent Tweets not loaded. error: Unable to download because

[web2py] Re: Problem overriding bootstrap.min.css with customized submit button style

2013-06-03 Thread Paolo Caruccio
please try: input.btn_auth { background:url('../images/button_02.png') no-repeat; border: 0px; width:205px; height:45px; position: relative; top:80px; left:97px; } input.btn_auth:hover { background:url('../images/button_hover_02.png') } input.btn_auth:active {

[web2py] Re: css help

2013-06-04 Thread Paolo Caruccio
In order to eliminate the issue under point 1, we could modify slightly the interested code in layout.html in: !-- Masthead == -- header class=mastheader row id=header div class=span12 div class=page-header

[web2py] Re: Fun with Scheduler

2013-06-05 Thread paolo betti
I agree Scheduler is great. I use this technique: in modules/lib.py: def a_func(db): # some code # ... return in models/scheduler.py def a_func(): import lib return lib.a_func(db) from gluon.scheduler import Scheduler scheduler = Scheduler(db) in

[web2py] admin access password file

2013-06-12 Thread Paolo valleri
, it tries to access parameters_80.py. Thus, I created the file parameters_80.py but then it fails saying to use https :(. Paolo -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from

[web2py] Re: Save rendered .html views to file system

2013-06-12 Thread Paolo valleri
)}} footer.html will be rendered either if the key hasn't cached already or it is no longer valid (expired). Hope it helps Paolo On Wednesday, June 12, 2013 10:04:07 AM UTC+2, Annet wrote: In my application the header and footer of the layout, contain more or less static information (navbar

[web2py] Re: Spammers on web2pyslices.com

2013-06-15 Thread Paolo valleri
got a captcha, have you already implemented it? Paolo On Saturday, June 15, 2013 6:40:50 AM UTC+2, rochacbruno wrote: Hi, recently we are having too many spams posted on web2pyslices.com I am deleting one by one, but started to be difficult to track this. We need to implement a captcha

[web2py] Re: Spammers on web2pyslices.com

2013-06-17 Thread Paolo Betti
Hi, is a different solution but have you ever tried CloudFlare (cloudflare.com) service? It is a kind of proxy-cache online. I use it with my site that has very very low traffic :-) but open comments and spammers have disappeared. {the site is made with Plone but I have to upgrade to web2py

Re: [web2py] Re: admin access password file

2013-06-17 Thread Paolo valleri
Hi Massimo, I've just tried but the issue hasn't gone :( what can I do to debug it more, by who is the request.env.server_port setter ? Paolo On Sunday, June 16, 2013 10:32:37 AM UTC+2, Massimo Di Pierro wrote: After uwsgi_param UWSGI_SCHEME $scheme; you must add uwsgi_param

Re: [web2py] @request.restful() only works on localhost

2013-06-17 Thread Paolo valleri
that could be a problem of a generic view not correctly loaded due to the following line in db.py response.generic_patterns = ['*'] if request.is_local else [] change it to response.generic_patterns = ['*'] Paolo On Monday, June 17, 2013 9:50:58 PM UTC+2, Michele Comitini wrote: send

[web2py] Re: web2pyslice and PIL thumbnail quality

2013-06-20 Thread Paolo valleri
I am not sure but the quality option could be for jpeg only. Paolo On Thursday, June 20, 2013 5:06:06 PM UTC+2, lesssugar wrote: A bit of offtopic but maybe someone knows what's going on. I'm using this thumbnail generating slice I found: LINKhttp://www.web2pyslices.com/slice/show/1522

[web2py] Re: disable left side panel in editor in 2.5

2013-06-24 Thread Paolo valleri
Are you looking for an hard-code option or for an easy-to-click button to reduce the whole panel? Paolo On Monday, June 24, 2013 8:31:48 PM UTC+2, Massimo Di Pierro wrote: Not sure but there should be. Please open a ticket and we will add it tonight. On Monday, 24 June 2013 05:05:34 UTC-5

[web2py] Re: Can page/chapter titles be added to the online book ?

2013-06-24 Thread Paolo valleri
/default/chapter/29/06#The-database-abstraction-layer actually even better without the 'default' Paolo On Monday, June 24, 2013 8:31:11 PM UTC+2, Massimo Di Pierro wrote: Good idea. Asap. It is easy to do. On Monday, 24 June 2013 05:01:11 UTC-5, Holger Schurig wrote: As I'm new to web2py, I

[web2py] datetime operation with dal (postgres)

2013-06-28 Thread Paolo valleri
(test_sum.id IS NOT NULL); Moreover, I run the same example with sqlite, it worked well without error, the resulting values are wrong though. What can I do? Paolo -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group

[web2py] Re: datetime operation with dal (postgres)

2013-06-28 Thread Paolo valleri
Hi Massimo, can you point out how to write query with date diff? I tried this: db(diff_date timedelta(days=4)).select() and I got the same ticket, I don't know if this is there right way for expressing query with date_diff. Paolo On Friday, June 28, 2013 12:41:13 PM UTC+2, Massimo Di Pierro

[web2py] Re: Stop menu from collapsing

2013-06-28 Thread Paolo Caruccio
This should work: replace navbar section in layout.html with !-- Navbar == -- div class=navbar navbar-inverse div class=flash{{=response.flash or ''}}/div div class=navbar-inner div class=container

[web2py] Re: Radio Buttons layout problem with trunk

2013-07-18 Thread Paolo Caruccio
Please put the following code in your custom css file (or in the bottom of web2py_bootstrap.css if you are using the welcome app scaffolding): .generic-widget input[type='radio'] {margin:-1px 0 0 0; vertical-align:middle ;} .generic-widget input[type='radio'] + label {display:inline-block;

[web2py] Re: Radio Buttons layout problem with trunk

2013-07-18 Thread Paolo Caruccio
together with the patch. Il giorno giovedì 18 luglio 2013 17:56:50 UTC+2, Massimo Di Pierro ha scritto: Should this go in web2py_bootstrap.css? On Thursday, 18 July 2013 10:51:15 UTC-5, Paolo Caruccio wrote: Please put the following code in your custom css file (or in the bottom

[web2py] Re: better calendar.js?

2013-07-18 Thread Paolo Caruccio
How to Turn Off Form Autocompletionhttps://developer.mozilla.org/en-US/docs/Mozilla/How_to_Turn_Off_Form_Autocompletion?redirectlocale=en-USredirectslug=How_to_Turn_Off_Form_Autocompletion Il giorno giovedì 18 luglio 2013 21:46:46 UTC+2, Jim S ha scritto: I have no idea what version my

Re: [web2py] Re: better calendar.js?

2013-07-18 Thread Paolo Caruccio
. On Thu, Jul 18, 2013 at 3:03 PM, Paolo Caruccio paolo.ca...@gmail.comjavascript: wrote: How to Turn Off Form Autocompletionhttps://developer.mozilla.org/en-US/docs/Mozilla/How_to_Turn_Off_Form_Autocompletion?redirectlocale=en-USredirectslug=How_to_Turn_Off_Form_Autocompletion Il giorno

Re: [web2py] Re: better calendar.js?

2013-07-18 Thread Paolo Caruccio
2013 23:42:21 UTC+2, Jim S ha scritto: So it should be an update to the widget, right? -Jim On Thu, Jul 18, 2013 at 4:24 PM, Paolo Caruccio paolo.ca...@gmail.comjavascript: wrote: Well, the automplete is a form | input attribute and therefore you could set in HTML code form name=form1

[web2py] Re: real time graph

2013-07-19 Thread Paolo Valleri
Have a look at http://www.flotcharts.org/ Paolo On Friday, July 19, 2013 12:58:54 AM UTC+2, Vera Moreira wrote: hi everyone, I need some help, does anyone have examples on how to do a real time graph. What I need is a graph to constantly show random numbers, I´m using matplotlib I

Re: [web2py] Re: better calendar.js?

2013-07-19 Thread Paolo Caruccio
scenarios, could be useful) will be preserved and, from a developer point of view, it's simpler remove a button or change its onclick action when he/she want use an other calendar or even use the html5 calendar feature. Il giorno venerdì 19 luglio 2013 15:13:25 UTC+2, Paolo Caruccio ha scritto

[web2py] Re: Errors in form, please check it out....... HOW?

2013-07-22 Thread Paolo Caruccio
In the last trunk of web2py, the form input error message is more visible. See attached image. Il giorno lunedì 17 giugno 2013 16:04:50 UTC+2, REM ha scritto: I'm attempting to understand a few things and decided to test out one of the items at: http://web2py.com/appliances Specifically,

[web2py] Re: Google Analytics - 'analytics is not defined' error

2013-07-24 Thread Paolo Valleri
/master/applications/welcome/static/js/analytics.min.js btw, it is a bit out of date. Paolo On Wednesday, July 24, 2013 4:12:34 PM UTC+2, st...@hurlingstats.com wrote: Wondering if anyone has seen this. I've set my tracking id in menu.py response.google_analytics_id = 'UA--X' When I load

Re: [web2py][share] ressources

2013-07-24 Thread Paolo Valleri
On Wednesday, July 24, 2013 4:47:37 PM UTC+2, Richard wrote: Hello, I recently discover these two lib : http://johnny.github.io/jquery-sortable/ (avoid jquery ui just to get drag and drop capability) thanks for sharing, I would try to use that with bootstrap tabs.

[web2py] Re: Err 24: too many files open

2013-07-25 Thread Paolo Valleri
dederocks, I've just tried to run lsof -p uwsgi pid# on a ubuntu server running web2py In my case, it returns 138 opened files among libraries, sockets and so on; the most opened file is /dev/zero, opened 55 times. Paolo On Thursday, July 25, 2013 8:18:32 AM UTC+2, dederocks wrote: Thanks

[web2py] Re: Err 24: too many files open

2013-07-25 Thread Paolo Valleri
is instantiated? Paolo On Thursday, July 25, 2013 8:48:37 AM UTC+2, dederocks wrote: Thank you Paolo for the benchmark! In my case, I start at 107, and at the end of the process the count is at 672!! nginx on the other hand is stable around 55. And the culprit is (drums ...): redis

Re: [web2py] Re: Appending div class=error for validation using jQuery.

2013-07-25 Thread Paolo Caruccio
Please try; jQuery(div class='error'Please Enter Name/div/div).appendTo(jQuery( #taxpayer_name).parent()); or jQuery(div class='error'Please Enter Name/div/div).insertAfter( #taxpayer_name); Your code fails because the div.error is created inside the input element Il giorno giovedì 25 luglio

Re: [web2py] Re: This javascript worked in older version of web2py - not in trunk version.

2013-07-25 Thread Paolo Caruccio
Yes the issue is due to jquery version. In your code, please replace .prop() to .attr() (for reference see http://api.jquery.com/prop/) Below code worked in my test: script jQuery(document).ready(function(){ jQuery('#a2_other').hide(); jQuery('#survey_a2').change(function(){

<    1   2   3   4   5   6   7   >