[web2py] Postgresql: a request

I could not get a pg8000 connection to work (see another email) so what I am writing involves only the psycopg2 driver. It might be the same for pg8000. At the moment it seems necessary to duplicate in the python code what the database is doing when using constraints. Example: I have several t

[web2py] Is there any way to calculate distance between two points(lat and long) inside of sqlite?

I just started programming in web2py from php. I know how to do it on Mysql and GAE(geohash or I forgot but there's another one) But it seems that SQLite doesn't support acos and asin. Is it true? Is there any other way around to calculate inside of Sqlite query? What would be the best way to d

[web2py] call function in template layout

i would like to know if it's possible to call a home made function in a template. i've made this gist and i would like to call it in template : https://gist.github.com/2032147 like : {{ encadrement(form) }} And where to place my gist to call it in template. And if not, where to put this functi

[web2py] Re: web2py recipe book

+1 - This book seems wonderful I'ld like to have one Rahul D. On Mar 14, 6:17 am, weheh wrote: > Hope this stimulates much interest in the cookbook and that I'm not > stepping on any copyright issues. This is the pre-production TOC. > > web2py Cookbook Table of Contents (draft copy) > > Chapter

[web2py] Re: Picture Gallery

According to the example {{=plugin_wiki.widget('slideshow',table = 'image', field='file', transition='fade', width=500, height=500)}} but I find that {{=slideshow(table = 'image', field='file', transition='fade', width=500, height=500)}} works fine. In either case db.define_table('image',

Re: [web2py] install web2py in dreamhost

I'm hosting web2py based www.phonetizer.com with Dreamhost. I'm using the Passenger WSGI option provided by Dreamhost. To set up web2py I followed the instructions here: http://wiki.dreamhost.com/Web2py On Wed, Mar 14, 2012 at 7:27 AM, Alex s wrote: > > Hi, > Have anyone installed web2py in dr

[web2py] Re: error in def show():

On Tuesday, March 13, 2012 11:18:35 PM UTC+1, praveen krishna wrote: > > Hii, >I am getting an error at line 9: in creating an image blog in > ubuntu(linux) 11.10 ,I have installed the web2py through terminal > > 4. > 5. > 6. > 7. > 8. > 9. > > 10. > 11. > 12. > 13. > > > def show(): >

[web2py] Re: error in def show():

I have installed the latest version of web2py 1.99.4 which has the error Traceback 1. 2. 3. 4. 5. 6. 7. Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/home/praveen/web2py/applications/

[web2py] Re: call function in template layout

In a view you can only call functions defined in this view or a one being extended/included: http://web2py.com/books/default/chapter/29/5#Functions-in-views More complex data processing should be done in the controller. Views should just present the data. Make the form transformation in the cont

[web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

You can use mysql with web2py: http://web2py.com/books/default/chapter/29/6#Connection-strings

Re: [web2py] Re: who uses the online designer?

I use its offline version: wwwSqlDesigner: http://code.google.com/p/wwwsqldesigner/ I made some tunnings to fit better in web2py. But it's experimental yet. -- Vinicius Assef On Tue, Mar 13, 2012 at 6:42 PM, Derek wrote: > It's horribly out of date. SQLField isn't used anymore, and it won't m

Re: [web2py] Re: call function in template layout

Thanks Bussiere "Les nouvelles technologies offrent pleins de nouvelles possibilités, pleins de possibilités d'erreurs surtout en fait." insurance.aes256 : http://goo.gl/gHyAY On Wed, Mar 14, 2012 at 12:15 PM, Wikus van de Merwe wrote: > In a view you can only call functions defined in thi

[web2py] Re: Support for PyPy

I tried my web2py applications with pypy1.8 on windows 7 with ie9 and Firefox 9.0.1 - It works very well . Although I could not justify the speed that much but I have to say it works. Speed was similar for me (may be I am not using jit - I used pypy.exe to run it ) the welcome application load

[web2py] Re: subdomain routes for websites

Hi Wikus, I'm trying to use a single controller for all my functions, including the "web/site" controller/function. Is it not possible?. Thanks again, Carlos On Tuesday, March 13, 2012 5:19:54 AM UTC-6, Wikus van de Merwe wrote: > > What is the purpose of the "demo" version there? Wouldn'

Re: [web2py] pg8000: ProgrammingError: ('ERROR', '42P07', 'relation "auth_user" already exists')

auth_user is created with Auth. However if you just changed the driver then it tries to recreate the tables that are already in the database. This already exist issue gives me a lot of problems, it would be nice if it detects that it exists it just doesn't try create it. On Tue, Mar 13, 2012 at

[web2py] Re: subdomain routes for websites

I'm not sure if it will work, but you might try something like this in routes.py: routes_in = ( (r'.*?://(?P[^.]*).*?/app/web/site/(?P.*)', r'/app/web/site/\g/\g') ) Note, that uses the pattern-based rewrite system, which cannot be mixed with the parameter-based rewrite system, so make sur

[web2py] Download file dialog to local PC when running from PythonAnywhere

Hi, in fact I have 3 questions: 1. Is there a simple dialogue which lets you chose a download directory (and then eventually to download the file(s))? 2. I set up web2py so that it's run from PythonAnywhere. Now, if I read out the directories or download files the path is located on the servers of

Re: [web2py] Re: subdomain routes for websites

On Mar 14, 2012, at 6:49 AM, Anthony wrote: > I'm not sure if it will work, but you might try something like this in > routes.py: > > routes_in = ( > (r'.*?://(?P[^.]*).*?/app/web/site/(?P.*)', > r'/app/web/site/\g/\g') > ) > > Note, that uses the pattern-based rewrite system, which cannot

[web2py] New multi-user translation plugin available

http://code.google.com/p/plugin-multitranslate/ (text from the project page) A web2py app plugin that allows role based translations with merge, partial file translation assignments, translation comments and other features. It is currently functional, although it needs proper tests (multiple envi

Re: [web2py] Re: subdomain routes for websites

> > Another approach would be to use the parametric router, setting the > defaults to app/web/site, and in the model extract the subdomain from > request.env and prepend it to request.args. > I like that approach too. > Notice that the routes_out editing (or the equivalent in the parametric

[web2py] Re: Translations file

I am working in a plugin solution for multiple translators. Maybe a version of this could be implemented in admin, but my plugin uses a db connection for storing user translations and that would require new pre-defined translation scaffolding tables. I'd like to add the Google Translate plugin feat

[web2py] Re: call function in template layout

> > In a view you can only call functions defined in this view or a one being > extended/included: > http://web2py.com/books/default/chapter/29/5#Functions-in-views You can also call functions defined in any model file (all objects defined in model files are available in the view environment),

Re: [web2py] Re: subdomain routes for websites

I do need to generate some URLs as absolute, pointing to other sub/domains, i.e. not relative to the current sub/domain, will this be a problem?. Thanks very much ! On Wednesday, March 14, 2012 8:39:55 AM UTC-6, Anthony wrote: > > Another approach would be to use the parametric router, setting

Re: [web2py] Re: subdomain routes for websites

On Mar 14, 2012, at 7:53 AM, Carlos wrote: > I do need to generate some URLs as absolute, pointing to other sub/domains, > i.e. not relative to the current sub/domain, will this be a problem?. The problem lies in deciding whether to include the subdomain name in outgoing URLs (that is, URLs that

[web2py] Re: web2py recipe book

For those interested the following coupon code: bawdanu gives you a 40% off on any Pack eBook. I just used it to buy this ebook that I'm eager to read now ;-) Here's the link to Pack Publishing page where the coupon is: http://www.packtpub.com/article/surveythankyou BTW, many thanks to Massimo and

[web2py] Re: Download file dialog to local PC when running from PythonAnywhere

> > Hi, > in fact I have 3 questions: > 1. Is there a simple dialogue which lets you chose a download > directory (and then eventually to download the file(s))? > If you have a link to download a file, the browser handles the dialog that allows you to choose the download folder and download t

[web2py] Re: Translations file

> > I'd like to add the Google Translate plugin features also in other > releases. > Note, the Google Translate API service is now paid only: http://code.google.com/apis/language/translate/overview.html

[web2py] Re: New multi-user translation plugin available

+1 On Wednesday, 14 March 2012 09:32:46 UTC-5, Alan Etkin wrote: > > http://code.google.com/p/plugin-multitranslate/ > > (text from the project page) > > A web2py app plugin that allows role based translations with merge, > partial file translation assignments, translation comments and other >

[web2py] Re: Translations file

"... These decisions were made due to the substantial economic burden caused by extensive abuse ...". Good point. Thanks. Well, maybe I can add the feature and give the option to disable it for non-payers. On 14 mar, 12:37, Anthony wrote: > > I'd like to add the Google Translate plugin features

[web2py] Re: web2py recipe book

Thanks for this...appreciate it!!! dan On Tuesday, March 13, 2012 6:17:22 PM UTC-7, weheh wrote: > > Hope this stimulates much interest in the cookbook and that I'm not > stepping on any copyright issues. This is the pre-production TOC. > > web2py Cookbook Table of Contents (draft copy)

Re: [web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

Thank you for reply Wikus. I know I can use mysql. But I am trying to stick with Sqlite. hehe Does DAL queries support MySql just like Sqlite? On Wed, Mar 14, 2012 at 4:18 AM, Wikus van de Merwe < dupakrop...@googlemail.com> wrote: > You can use mysql with web2py: > http://web2py.com/books/defaul

[web2py] Re: web2py recipe book

is Packt a british company??? my total is in pounds which is odd.. d On Wednesday, March 14, 2012 8:15:17 AM UTC-7, Calycé wrote: > > For those interested the following coupon code: bawdanu gives you a > 40% off on any Pack eBook. I just used it to buy this ebook that I'm > eager to read n

[web2py] autocompleteWidget improvement

Hi, I have opened a ticket to propose an improvement of tha AutocompleteWidget http://code.google.com/p/web2py/issues/detail?id=716&thanks=716&ts=1331743652 What's the way to define it in my application without mod

[web2py] Re: web2py recipe book

Here is the addess on their invoice: Packt Publishing Ltd. 2nd Floor, Livery Place 35 Livery Street Birmingham, B3 2PB United Kinkgdom So yes, they appear to be british but you could specify the currency you wish to use (I paid in €). On Mar 14, 5:42 pm, greenpoise wrote: > is Packt a british co

[web2py] Re: autocompleteWidget improvement

You can create a widget function that creates the original widget and returns it modified: def mycustomwidget(): new_widget = SQLFORM.widgets.autocomplete(request, db.category.name, limitby=(0,10), min_length=2) ... # modify the helper return new_widget db.mytable.myfield.widget = myc

[web2py] Re: web2py recipe book

thanks..and thanks for that coupon...got mine, cant wait. d On Wednesday, March 14, 2012 10:06:48 AM UTC-7, Calycé wrote: > > Here is the addess on their invoice: > Packt Publishing Ltd. > 2nd Floor, Livery Place > 35 Livery Street > Birmingham, B3 2PB > United Kinkgdom > > So yes, they

[web2py] {{pass}} problems

i don't understand the pass ... I anyone have a better tutorial than the official one. Here is my layout.html : Projet Jackpoint body{ color:#b7d14e; background-color:#000f00; margin:4px; margin-top:0px; font-family:monospace; } a:link{ color:#94d118; } a:visited{ color:#94a443; } he

Re: [web2py] {{pass}} problems

in layout you need {{pass}} because indentation are not available (you know python need indentation to understand bloc of code). So since you don't have those indentation in html you need to tell web2py where are the bloc of code. So, you need one pass for a given bloc of code (if, for, etc.) Rich

[web2py] Re: {{pass}} problems

Your layout.html needs an {{include}} at the end to tell it where to insert the user.html view. Also, looks like user.html has one too many {{pass}} statements (you just need two to close the two if blocks). Anthony On Wednesday, March 14, 2012 3:10:52 PM UTC-4, bussiere adrien wrote: > > i don

Re: [web2py] Re: {{pass}} problems

it's not that but htanks : layout.html Projet Jackpoint body{ color:#b7d14e; background-color:#000f00; margin:4px; margin-top:0px; font-family:monospace; } a:link{ color:#94d118; } a:visited{ color:#94a443; } {{include}} user.html : {{extend 'layout.html'}} __ _

Re: [web2py] DAL and schema

On Tuesday, March 6, 2012 12:58:50 PM UTC-5, howesc wrote: > > in this case i think you still use 2 DAL connections, one for each > "schema" in postgres. What would that connection string look like for mssql? I can't seem to find any reference to setting it at the connection level in web2py's

[web2py] Re: logical/relationship url mapping

After looking through it and testing some scenarios. I think there are a few big problems with parse_as_rest(): 1) it makes the code in the controller way too monolithic 2) it blurs the separation of routing and application level logic 3) it doesn't allow for granular access/authorization check

Re: [web2py] Re: subdomain routes for websites

Hi Jonathan, In fact I'm already wrapping URL to handle some other special behavior. I'll check all suggestions, and will post back Thanks again!, Carlos On Wednesday, March 14, 2012 9:07:25 AM UTC-6, Jonathan Lundell wrote: > > On Mar 14, 2012, at 7:53 AM, Carlos wrote: > > I do need to g

Re: [web2py] Re: {{pass}} problems

still not work : Projet Jackpoint body{ color:#b7d14e; background-color:#000f00; margin:4px; margin-top:0px; font-family:monospace; } a:link{ color:#94d118; } a:visited{ color:#94a443; } {{include}} and not : {{extend 'layout.html'}} __ __ _ \

Re: [web2py] Re: {{pass}} problems

I tried your exact layout.html and user.html, and it works fine for me, with 2 or 3 {{pass}} statements (only 2 are required -- the third is ignored). The only problem I see is that you're putting your CSS in a tag, but it should be a

[web2py] Re: logical/relationship url mapping

> > 1) it makes the code in the controller way too monolithic > What does that mean exactly? You can have multiple RESTful controllers, and they can call functions defined elsewhere if necessary. > 2) it blurs the separation of routing and application level logic > What problems does this c

Re: [web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

yes.but there is no API for acos and asin. If you want I have an implementation that calculates distance from two points (lat,long) in kilometers, just in plain python. If you want to calculate the minimum distance from a specific point to a list of 10 points saved into the db it's prob

[web2py] Re: GAE and sending email

I had the same problem. Although GAE supports 'reply_to' its not implemented in web2py. I inserted two lines in web2py/gluon/tools.py; here is what the code looks like now: elif self.settings.server == 'gae': xcc = dict() if cc: x

Re: [web2py] Re: {{pass}} problems

an actual error i will try again ... Thanks Bussiere "Les nouvelles technologies offrent pleins de nouvelles possibilités, pleins de possibilités d'erreurs surtout en fait." insurance.aes256 : http://goo.gl/gHyAY On Wed, Mar 14, 2012 at 9:05 PM, Anthony wrote: > I tried your exact layout.h

Re: [web2py] Re: {{pass}} problems

dammit still not work they are here : https://github.com/bussiere/jackpoint/blob/master/applications/init/errors/127.0.0.1.2012-03-14.20-56-03.76ae121a-f33b-439d-b403-1d1707ae4fb7 https://github.com/bussiere/jackpoint/blob/master/applications/init/views/layout.html https://github.com/bussiere/jac

Re: [web2py] Re: logical/relationship url mapping

> What does that mean exactly? You can have multiple RESTful controllers, and > they can call functions defined elsewhere if necessary. Just taking the sample code in the docs as an example You have the patterns, the magic sauce in parse_as_rest(), then the db object passes the results to the par

[web2py] export csv

Hello, I strungle with export of csv... I have this function that works great : def export_csv(tab1_id): import gluon.contenttype response.headers['Content-Type'] = \ gluon.contenttype.contenttype('.csv') import cStringIO stream=cStringIO.StringIO() db((db.tab1.id == t

Re: [web2py] Re: autocompleteWidget improvement

Il 14/03/2012 18:09, Alan Etkin ha scritto: You can create a widget function that creates the original widget and returns it modified: def mycustomwidget(): new_widget = SQLFORM.widgets.autocomplete(request, db.category.name, limitby=(0,10), min_length=2) ... # modify the helper r

[web2py] GAE email 'reply_to'

Reply_to is supported by GAE but the interface doesn't currently implemented. The following 2 lines need to be added to web2py.gluon.tools.py at line 600: if reply_to: xcc['reply_to'] = reply_to

[web2py] Re: autocompleteWidget improvement

I bet if you declared the widget custom class in the model, you wouldn have this request object issue. Is there any particular need to use a module instead of normal model code? On 14 mar, 18:20, Manuele Pesenti wrote: > Il 14/03/2012 18:09, Alan Etkin ha scritto: > > > > > > > > > > > You can cr

Re: [web2py] Re: {{pass}} problems

The project is here : i'am under debian now and i've pull my project. https://github.com/bussiere/jackpoint And it still dont work i'am ready to pay a beer for the explanation and the solution if you have a paypal account $5. Regards "Les nouvelles technologies offrent pleins de nouvelles possi

[web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

Is it not suitable for your code to do calculations in the controller code before storing/updating data? On 14 mar, 05:19, Kenny wrote: > I just started programming in web2py from php. > > I know how to do it on Mysql and GAE(geohash or I forgot but there's > another one) > > But it seems that SQ

[web2py] Re: export csv

I have not experience with the book csv output example, but it looks different than your implementation: -It has a special view "/name.csv" to render the function output -The Content-Type parameter is "application-vnd.ms-excel" I think you could change the response view parameter on form vali

Re: [web2py] Re: {{pass}} problems

Found just that before my modification in defult.py i was in a file. My modifcatin change the file the new file wasincorrect thanks time to sleep Bussiere "Les nouvelles technologies offrent pleins de nouvelles possibilités, pleins de possibilités d'erreurs surtout en fait." insurance.aes256 :

[web2py] Re: plugins

A multi user role based plugin for application translations http://code.google.com/p/plugin-multitranslate/ Translator and manager tutorials (in english): http://code.google.com/p/plugin-multitranslate/wiki/TranslatorTutorial http://code.google.com/p/plugin-multitranslate/wiki/ManagersTutorial

[web2py] Re: GAE email 'reply_to'

please open a ticket in google code and we can get this done quickly. On Wednesday, 14 March 2012 17:01:51 UTC-5, David Manns wrote: > > Reply_to is supported by GAE but the interface doesn't currently > implemented. > > The following 2 lines need to be added to web2py.gluon.tools.py at line > 6

Re: [web2py] Re: export csv

Ho yeah, I forget about that option... Thanks Alan Richard On Wed, Mar 14, 2012 at 6:53 PM, Alan Etkin wrote: > I have not experience with the book csv output example, but it looks > different than your implementation: > > -It has a special view "/name.csv" to render the function output >

Re: [web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

It's not suitable for doing calculation in the controller. I don't know how bad it is going to be if I go with the path that Niphlod suggested. I have about 1000 Points. You think your solution will work well? On Mar 14, 2012 3:34 PM, "Alan Etkin" wrote: > Is it not suitable for your code to do c

[web2py] Re: Is there any way to calculate distance between two points(lat and long) inside of sqlite?

You can still send "raw" sql commands to a database trough DAL, but the returned values of the db query depend on the driver. There's more info on this subject in the manual, section 6.10.2 about .executesql() On 14 mar, 21:18, Kenny Chung wrote: > It's not suitable for doing calculation in the

[web2py]

Re: [web2py] Modules on Google App Engine

The thing is that locally, it works. only when I deploy to GAE it is missing... which files do you recommend I look into to try and find the reason for this weird problem? On Tuesday, March 13, 2012 5:32:52 PM UTC-4, rochacbruno wrote: > > Maybe you have a syntax error or an error with imports i

Re: [web2py] Modules on Google App Engine

I guess your module is trying to do something denied in GAE, some python std modules are not available on GAE, and also you cannot access filesystem. Another common problem is incompatibility with Python2.5 Take a look at LOG tab at your google app engine admin page, may be the traceback is there

[web2py] bug in unicode decoding/encoding upload file?

OK, I think I got this figured out and working, finally. What I did is this. After file upload, I opened the uploaded file, decoded it and re-encoded, but using my own auto-detect routine rather than gluon's decoder routine. This worked! I'm curious why gluon's autodetector doesn't work. At first

Re: [web2py] Re: logical/relationship url mapping

> > > What does that mean exactly? You can have multiple RESTful controllers, > and > > they can call functions defined elsewhere if necessary. > > Just taking the sample code in the docs as an example You have the > patterns, the magic sauce in parse_as_rest(), then the db object > passes the r

Re: [web2py] Modules on Google App Engine

On Mar 14, 2012, at 8:32 PM, Bruno Rocha wrote: > I guess your module is trying to do something denied in GAE, some python std > modules are not available on GAE, and also you cannot access filesystem. One thing to try would be to put the modules in site-packages, so they're in sys.path and don'

[web2py] First message and getting aknowledge about the group behavior.

Hello All. I met Massimo at the PyConUS and joined the sprints with Mariano. I am trying to help this week, but I don't know the best practices here. I think the best way to know it is to ask. Well, I was playing with tests and found one failing test: testUnicodeToAsciiUrl #label is too long I

Re: [web2py] First message and getting aknowledge about the group behavior.

Hi Ramiro! Nice to have more Brazilians in web2py community! Generally you can just take/open an issue, solve and submit a patch to Massimo (if you are using github, you can just fork and send a pull request), however it is a good idea to "ping" the whole group, so others can help with the issue,

[web2py] Re: web2py ported to bottle, flask, pyramid, tornado, wsgiref

When would I choose something like Bottle over using straight web2py? What's the difference from bottle with gluino, and web2py? Martin M, you used to have bottle on your blog site. I went to have a look but it's gone. So many choices !? Thanks Andrew On Mar 14, 4:22 pm, Bruno Rocha wrote: >