[web2py] Re: The book updates and status

2012-12-22 Thread Kostas M
IMHO, as I have said previously, it would be nice if the markmin to PDF converter produced comparable layouts/fonts to the online version of the book... The printed book, up to now, misses a lot of the pleasant and appealing layout of the online version. --

[web2py] vert.x

2012-12-22 Thread Vasile Ermicioi
I just came on http://vertx.io/, it supports python (jython) what do you think? http://vertx.io and here also an article http://blog.andrewvc.com/vertx-node-on-ropes --

Re: [web2py] Possible bug in JSONRPC in v2.3.2

2012-12-22 Thread Niphlod
both of you, jump on the bandwagon here . https://groups.google.com/d/topic/web2py/5kCYP-wiELo/discussion On Saturday, December 22, 2012 7:04:18 AM UTC+1, rochacbruno wrote: On Sat, Dec 22, 2012 at 3:57 AM, Mike D mike@gmail.com javascript:wrote: s = methods[method](**params)

[web2py] Re: 2.2.1 left joins broken?

2012-12-22 Thread Niphlod
uhm the thing is, if you have record versioning, all active records should be marked with True. There's no point in record versioning if active records can be False or True *or None*. They can be either True or False to correctly identify the single active record on those tables. am I

[web2py] Re: smartgrid button placement 'left' 'right', 'both'

2012-12-22 Thread Niphlod
you'd have to import the new gluon/sqlhtml.py code. https://github.com/web2py/web2py/commit/0ee551de71853f8e65ba7520d5d83a7ef318da39 On Friday, December 21, 2012 6:30:04 PM UTC+1, joe smith wrote: I am trying to set the button placement of the View, Edit, Delete buttons in the smartgrid

[web2py] probing into examples application

2012-12-22 Thread Adi
Just noticed from gogle webmaster tools that someone was probing into links bellow and got 500 server response for each. Is there anything that could potentially be dangerous from a security prospective, since examples get deployed with every installation of web2py? (I deleted it now in

[web2py] Re: probing into examples application

2012-12-22 Thread Niphlod
well, the source code is available since the example app is released with web2py... I don't think any security is breached if someone is accessing those pages. PS: Of course in production you should deploy only your app and remove examples. Welcome and admin are also going to be removed if

[web2py] how to use session in cookie?

2012-12-22 Thread Adi
I tried using session.connect(cookie_key='key', compression_level=9) instead of session.connect(request, response, db=db), and got the error as bellow, plus some inconsistent unexpected behavior. When I rolled back to db sessions all works fine as expected. It's an e-commerce app,

[web2py] Re: The book updates and status

2012-12-22 Thread Massimo Di Pierro
The book is converted automatically from the online version. markmin-latex-pdf. Can you say specifically what should be changed in the pdf/printed version? On Saturday, 22 December 2012 04:15:26 UTC-6, Kostas M wrote: IMHO, as I have said previously, it would be nice if the markmin to PDF

Re: [web2py] Possible bug in JSONRPC in v2.3.2

2012-12-22 Thread Massimo Di Pierro
Turns out we do not have a choice. params is a variable specified by jsonrpc. It can be an array or an object. The change in trunk was wrong as we need to check whether it is an array or an object (serialized as dict). and act accordingly. It should now be fixed in trunk. Massimo On Saturday,

[web2py] Re: 2.2.1 left joins broken?

2012-12-22 Thread Massimo Di Pierro
I think we agree with each other. The problem is that somebody may add auth.signature later and therefore precent records will have is_active=None. The user will have to manually set is_active from None to True. On Saturday, 22 December 2012 07:08:58 UTC-6, Niphlod wrote: uhm the thing

[web2py] Re: how to use session in cookie?

2012-12-22 Thread Massimo Di Pierro
Can you please look for the error in the apache logs? There is a limitation in the cookie size wich may break for large sessions. On Saturday, 22 December 2012 08:49:04 UTC-6, Adi wrote: I tried using session.connect(cookie_key='key', compression_level=9) instead of

Re: [web2py] Interesting - Brython (python to javascript)

2012-12-22 Thread Arnon Marcus
How do you debug this? Is here a source-map generation mechanism to allow debugging python code in the browser's debugger? Can the transpiler run server-side? On Fri, Dec 21, 2012 at 1:20 PM, Francois Dion francois.d...@gmail.comwrote: If you have had issues with these, you should report the

[web2py] Re: 2.2.1 left joins broken?

2012-12-22 Thread Niphlod
agreeing too. Someone applying versioning AFTER must know that he must set all current records to True (maybe a note marked important on the relevant section on the book may be appropriate). Better a one-time operation than large where conditions appearing everywhere and killing performances.

[web2py] Re: how to use session in cookie?

2012-12-22 Thread Adi
Size could definitely be my problem... Bellow is the bottom part of the Apache error log: [Sat Dec 22 04:22:50 2012] [error] k,len 0 3 [Sat Dec 22 04:22:50 2012] [error] k,len 1 3 [Sat Dec 22 04:22:50 2012] [error] k,len 2 3 [Sat Dec 22 04:22:54 2012] [error] k,len 0 3 [Sat Dec 22 04:22:54

[web2py] Re: probing into examples application

2012-12-22 Thread Adi
Thanks Simone. Just wanted to mention it, in case there is potentially something to double-check, or worry, but all seems to be good :) On Saturday, December 22, 2012 9:14:23 AM UTC-5, Niphlod wrote: well, the source code is available since the example app is released with web2py... I

[web2py] Re: how to use session in cookie?

2012-12-22 Thread Adi
Sorry Massimo, Seems I was looking into wrong error_log... This one is related to web2py... JUst run it again: [Sat Dec 22 11:10:53 2012] [error] [client 24.150.57.81] (13)Permission denied: access to /mobipp_us/static/plugin_wiki/rating/jquery.rating.js denied, referer:

[web2py] Re: 2.2.1 left joins broken?

2012-12-22 Thread Massimo Di Pierro
I changed it so that auth.signature.is_active defaults to notnull=True. This makes sure what when added in a migration, it sets the default value for existing records. Hope this does not break existing apps. If you have an existing app using auth.signature, please check this does not break it.

[web2py] Re: web3py?

2012-12-22 Thread apps in tables
Hi Massimo, Can webRTC be touched by web2py, (as a feature or as an example) , or by web3py ? here is an example, http://www.youtube.com/watch?v=ZIIcEac24RU and its documentation, https://github.com/priologic/easyrtc/blob/master/docs/easyrtc_client_tutorial.md Regards, Ashraf --

[web2py] Re: how to use session in cookie?

2012-12-22 Thread Massimo Di Pierro
In think the problem is exactly the size of the cookie. On Saturday, 22 December 2012 10:15:20 UTC-6, Adi wrote: Sorry Massimo, Seems I was looking into wrong error_log... This one is related to web2py... JUst run it again: [Sat Dec 22 11:10:53 2012] [error] [client 24.150.57.81]

[web2py] Re: web3py?

2012-12-22 Thread Massimo Di Pierro
Very interesting. Looks like it completely client-side so it should work without problems with web2py. Massimo On Saturday, 22 December 2012 11:35:33 UTC-6, webpypy wrote: Hi Massimo, Can webRTC be touched by web2py, (as a feature or as an example) , or by web3py ? here is an example,

Re: [web2py] how to cleanse field value

2012-12-22 Thread wwwgong
Thank you! On Wednesday, December 19, 2012 7:04:03 PM UTC-5, Massimo Di Pierro wrote: Here is a custom validator that replaces '-' with '_' class MyValidator(obejct): def __call__(self,value): return (value.replace('-','_'), None) Field(..., requires=MyValidator()...) On

[web2py] help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
If you have fields with auth.signature and mysql/pgsql could you help me test the latest trunk? The reason is that I changed the is_active field from notnull=False to notnull=True. This should trigger a migration of your data. I want to make sure nothing breaks. Can you confirm this is ok?

[web2py] Re: web3py?

2012-12-22 Thread webpypy
Do you prefer it as feature or example? On Saturday, December 22, 2012 8:39:18 PM UTC+3, Massimo Di Pierro wrote: Very interesting. Looks like it completely client-side so it should work without problems with web2py. Massimo On Saturday, 22 December 2012 11:35:33 UTC-6, webpypy wrote:

[web2py] geodal

2012-12-22 Thread Massimo Di Pierro
I made some changes to the DAL geo APIs. This is an experimental feature so we are allowed to make changes. Anyway, the changes should be backward compatible. The only issue is that I am documenting the geodal api in the book and I would not want to change them later. Can you please check

[web2py] Re: web3py?

2012-12-22 Thread Massimo Di Pierro
I do not understand the question. On Saturday, 22 December 2012 11:44:24 UTC-6, webpypy wrote: Do you prefer it as feature or example? On Saturday, December 22, 2012 8:39:18 PM UTC+3, Massimo Di Pierro wrote: Very interesting. Looks like it completely client-side so it should work without

[web2py] Re: web3py?

2012-12-22 Thread webpypy
I mean, do we expect a web2py example that use webRTC or do we expect a core feature in web2py(or web3py) that interface with the cam and mic? --

Re: [web2py] geodal

2012-12-22 Thread Bruno Rocha
Excelent! I did not know DAL has its support, In my new project I will use this with Postgres, trying to test it today. Thank you again. --

[web2py] Re: how to use session in cookie?

2012-12-22 Thread Adi
Thanks Massimo. So, is session.connect(request, response, db=db) my only option for mysql at the moment? i tried to get memcache working, but getting stuck with syntax... is there a valid sample somewhere? In one of the posts I found this code, but getting an error bellow... from

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Adi
do you mean: db._common_fields.append(auth.signature) i have it, and can test now On Saturday, December 22, 2012 12:44:06 PM UTC-5, Massimo Di Pierro wrote: If you have fields with auth.signature and mysql/pgsql could you help me test the latest trunk? The reason is that I changed the

[web2py] Re: web3py?

2012-12-22 Thread Massimo Di Pierro
At this time none of them since my priority if finish the book by next week. ;-) After that we'll see. As I said before the library is client side. I am not sure there is anything web2py specific. An example would be nice. Masimo On Saturday, 22 December 2012 11:55:16 UTC-6, webpypy wrote:

Re: [web2py] geodal

2012-12-22 Thread Massimo Di Pierro
For the record, this feature has been in since summer 2011. It was sponsored by the Sahana project and implemented by Denes. It was only documented in an email from Denes. I have now added it to the manual and changed the APIs a little to make more human friendly. The API could use more work

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
Yes. That would be a good test. On Saturday, 22 December 2012 12:30:25 UTC-6, Adi wrote: do you mean: db._common_fields.append(auth.signature) i have it, and can test now On Saturday, December 22, 2012 12:44:06 PM UTC-5, Massimo Di Pierro wrote: If you have fields with auth.signature and

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
Specifically let me know: - after upgrade, do you see a migration in sql.log? - does everything seem to work or you get a ticket? Masimo On Saturday, 22 December 2012 12:30:25 UTC-6, Adi wrote: do you mean: db._common_fields.append(auth.signature) i have it, and can test now On Saturday,

Re: [web2py] Possible bug in JSONRPC in v2.3.2

2012-12-22 Thread Mike D
Thanks guys. On Saturday, December 22, 2012 6:59:10 AM UTC-8, Massimo Di Pierro wrote: Turns out we do not have a choice. params is a variable specified by jsonrpc. It can be an array or an object. The change in trunk was wrong as we need to check whether it is an array or an object

[web2py] Re: web3py?

2012-12-22 Thread webpypy
Thank you, Massimo. --

[web2py] Call controller automatically

2012-12-22 Thread FERNANDO VILLARROEL
Dear. I have a controller that basically runs a SQL shown in their respective views. Need is that while the user STAY in this view, the controller automatically running every 5 seconds, and so the result of the SQL refresh the view. I could use a Refresh button, but I want it to be automatic.

[web2py] 2 Bugs in web2py Examples # 29

2012-12-22 Thread JoeCodeswell
Dear web2py users, While trying to work my way through smartgrid, i discovered that there are 2 Bugs in the web2py documentation [quick] Examples # 29. See: https://www.web2py.com/examples/default/examples#database_examples 1. around line 11. #BUG: Field

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Adi
My app was in a fake migration mode, and when I enabled a migration it wanted to re-ecreate two existing tables, one regular (pmt), the other archive (customer_archive)... (sql.log bellow). I renamed existing tables in order to proceed... What I see is that archive table got created with

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
This is not exactly what I was hoping for but it shows a problem with trunk. It migrates is_active form notnull=False to notnull=True and then tries to copy the old data (which include Null values). This will break the migration. It worked for you because the step was only faked. The creation

[web2py] Small form on all pages..

2012-12-22 Thread hiro
What is the best way to create a small form that is visible on all pages? I want to have a small form in the sidebar where users can add notes (without changing view..) I have tried just adding the for in the layout and send the data to a controller using an ajax function:

[web2py] should re remove crud from the book?

2012-12-22 Thread Massimo Di Pierro
I am finishing up the book 5th edition. I was to remove every mention of the crud API. Almost all of the functionality has been moved into SQLFORM(...).process(). The latter is in fact better. The crud code has not been updated in long time and should be deprecated. The code will stay and we

Re: [web2py] should re remove crud from the book?

2012-12-22 Thread Jonathan Lundell
On 22 Dec 2012, at 11:44 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I am finishing up the book 5th edition. I was to remove every mention of the crud API. Almost all of the functionality has been moved into SQLFORM(...).process(). The latter is in fact better. The crud code has

Re: [web2py] should re remove crud from the book?

2012-12-22 Thread Massimo Di Pierro
I am going over the book with grep. The problems are these: 1) crud checks permission, SQLFORM does not. 2) crud is used in welcome 3) in chapter 13 we say plugins can rely on crud. So on a second thought we cannot easily remove it form the book. I will remove some examples to avoid using

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Adi
let me know when you change. i can test again... On Saturday, December 22, 2012 2:40:19 PM UTC-5, Massimo Di Pierro wrote: This is not exactly what I was hoping for but it shows a problem with trunk. It migrates is_active form notnull=False to notnull=True and then tries to copy the old

[web2py] controller not returning variables

2012-12-22 Thread jonas
this is probably simple but I post it anyway I have a layout that includes sidebar.html: section id=main class=main row br br div class=span2 left-sidebar offset1 !-- div class=headerDivider/div -- {{block left_sidebar}} {{include 'default/sidebar.html'}} {{end}}

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
I reverted it so there should be no problem. This leave the original problem. If people add an auth signature, they must manually change is_active=None to is_active=True. On Saturday, 22 December 2012 13:59:13 UTC-6, Adi wrote: let me know when you change. i can test again... On Saturday,

[web2py] Re: controller not returning variables

2012-12-22 Thread Anthony
When you include a view like: {{include 'default/sidebar.html'}} it is not calling a sidebar() function in the default.py controller. Rather, it is simply including the code from the sidebar.html file at that point in your main view file, as if the code had been manually inserted there. No

[web2py] Re: Call controller automatically

2012-12-22 Thread Anthony
Perhaps you could use an ajax component (see http://web2py.com/books/default/chapter/29/12#Components): {{=LOAD(..., timeout=5000, times='infinity', ajax=True)}} That will load the component via Ajax and refresh its content every 5 seconds indefinitely. Anthony On Saturday, December 22, 2012

[web2py] Re: Query results from 2 children tables from same parent ordered by date

2012-12-22 Thread Mamisoa Andriantafika
ok find it too using this code in view: {{for e in exams_mutex:}} divh1Examen du {{=e['COALESCE(dataset1.date,dataset2.date)']}}/h1/div {{pass}} Le samedi 22 décembre 2012 08:27:03 UTC+1, Mamisoa Andriantafika a écrit : I actually need to display those coalesce dates out of SQLTABLE that I

Re: [web2py] Re: controller not returning variables

2012-12-22 Thread Jonas
Ok, I have a {{include}} statement in the beginning of the layout.html file that cals index.html and the corresponding index.py controller. And that one returns variables. So there is no way to call sidebar.py with tve corresponding view to get the variables? 22 dec 2012 kl. 20:53 skrev

Re: [web2py] should re remove crud from the book?

2012-12-22 Thread Alan Etkin
I like crud very much (it's almost tallking english to the server) crud.read crud.update, ... it's like a web2py classic. For me, sounds like your preferred pizza delivery is not selling pepperoni anymore El sábado, 22 de diciembre de 2012 16:57:34 UTC-3, Massimo Di Pierro escribió: I am

[web2py] Re: Small form on all pages..

2012-12-22 Thread hiro
Ok I had messed up some of my code, now everything works fine! Thanks anyway! --

Re: [web2py] Re: controller not returning variables

2012-12-22 Thread Anthony
On Saturday, December 22, 2012 5:00:52 PM UTC-5, jonas wrote: Ok, I have a {{include}} statement in the beginning of the layout.html file that cals index.html and the corresponding index.py controller. And that one returns variables. So there is no way to call sidebar.py with tve

[web2py] Re: The book updates and status

2012-12-22 Thread Alan Etkin
El viernes, 21 de diciembre de 2012 03:50:54 UTC-3, Massimo Di Pierro escribió: Thanks this is great. One thing that can save you time is diff the current trunk version of the boot with first github commit. The first commit may still have bugs but less likely since it was already the

Re: [web2py] Re: controller not returning variables

2012-12-22 Thread jonas
ok. thanks, that clarified the a few things. On Saturday, December 22, 2012 10:48:35 PM UTC, Anthony wrote: On Saturday, December 22, 2012 5:00:52 PM UTC-5, jonas wrote: Ok, I have a {{include}} statement in the beginning of the layout.html file that cals index.html and the corresponding

[web2py] Re: The book updates and status

2012-12-22 Thread Alan Etkin
The font used on the online version is much more 'friendly', and computer oriented. Versus the printed font, which reminds me formal law letters... I'm not sure about the better computer orientedness of the online version over the roman font of the pdf. Also, Serif typography is said to be

[web2py] Re: The book updates and status

2012-12-22 Thread Massimo Di Pierro
The pdf/printed book style is based on this: http://code.google.com/p/tufte-latex/ Massimo On Saturday, 22 December 2012 17:40:20 UTC-6, Kostas M wrote: Ok, I will try to show what I mean, since these things it is kind of personal choice, and I am not a dtp designer, but still... I have

[web2py] Re: Cron every 5 seconds.

2012-12-22 Thread Alan Etkin
Duplicated https://groups.google.com/d/topic/web2py/eiEImsH_ZVg/discussion --

[web2py] calendar.js incompatible with moment.js

2012-12-22 Thread Yarin
We've found that the popular date library moment.js fails on date parsing when used alongside the calendar.js file included by default with web2py projects. I've submitted a bug report: http://code.google.com/p/web2py/issues/detail?id=1243 We removed calendar.js from our projects, but I'm

Re: [web2py] calendar.js incompatible with moment.js

2012-12-22 Thread Bruno Rocha
Celendar.js license is ok with web2py and it supports date, time or date and time. On Sun, Dec 23, 2012 at 12:41 AM, Yarin ykess...@gmail.com wrote: We've found that the popular date library moment.js fails on date parsing when used alongside the calendar.js file included by default with

[web2py] Re: new feature in trunk, for teachers mostly

2012-12-22 Thread Jurgis Pralgauskis
How can I setup EMAIL_SERVER to use gmail? default is: EMAIL_SERVER = 'localhost' and what is the meaning of EMAIL_LOGIN = None ? Thanks in advance :) 2012 m. kovas 27 d., antradienis 06:32:31 UTC+3, Massimo Di Pierro rašė: edit applications/admin/models/0.py and set MULTI_USER_MODE =

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Cliff Kachinske
What happens if you add the field, set it to True,then add the notnull constraint? --

[web2py] Re: calendar.js incompatible with moment.js

2012-12-22 Thread Massimo Di Pierro
Do you get any error in the chrome console? On Saturday, 22 December 2012 20:41:43 UTC-6, Yarin wrote: We've found that the popular date library moment.js fails on date parsing when used alongside the calendar.js file included by default with web2py projects. I've submitted a bug report:

[web2py] Re: new feature in trunk, for teachers mostly

2012-12-22 Thread Massimo Di Pierro
Yes mail.settings.sender = 'smtp.gmail.com' mail.settings.login = 'y...@gmail.com:password' On Saturday, 22 December 2012 20:52:04 UTC-6, Jurgis Pralgauskis wrote: How can I setup EMAIL_SERVER to use gmail? default is: EMAIL_SERVER = 'localhost' and what is the meaning of EMAIL_LOGIN =

[web2py] Re: help testing auth.signature with mysql/pgsql

2012-12-22 Thread Massimo Di Pierro
The problem is that adding notnull constraint causes a migration (except on sqlite). Because the field exists already web2py creates a new tmp field, than tried to move existing data over. But the data contains Null while the new field is notnull=True therefore the migration will fail. On

[web2py] Re: Remote access appadmin

2012-12-22 Thread Rufus
I started up a brand new install of the latest stable web2py on my laptop: Version 2.3.2 (2012-12-17 15:03:30) stable Running on my home network @ 192.168.1.68:8000 I can open Safari on my iphone and enter: http://192.168.1.68:8000 and get the welcome screen for Web2py.If I press the

[web2py] Re: Remote access appadmin

2012-12-22 Thread Massimo Di Pierro
Follow up to step 4 http://www.akadia.com/services/ssh_test_certificate.html Then you will have the server.crt and server.key files. Run web2py -h for instructions on how to use them. Massimo On Saturday, 22 December 2012 22:02:27 UTC-6, Rufus wrote: I started up a brand new install of the

[web2py] Re: raspberry pi

2012-12-22 Thread Paul Gerrard
I've had two RPIs for several months. My first task was to install Web2py and our app on it (Apache, MySQL and 90 tables etc.) and it worked fine. I used an 8Gb SD card. It wasn't lightning fast, but as a potential test/demo environment it worked fine. Paul. On Tuesday, 13 March 2012 10:04:40

Re: [web2py] Re: calendar.js incompatible with moment.js

2012-12-22 Thread Yarin Kessler
Not errors, just incorrect results- fails to parse dates, and returns isValid() false when testing valid date strings- see my bug report for a reproducable example- On Sat, Dec 22, 2012 at 10:27 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Do you get any error in the chrome console?