[web2py] Re: real time graph

2013-07-22 Thread Massimo Di Pierro
It can be done with web2py and gluon/contrib/websocket_messaging.py easily. The problem is that how depends on details. On Monday, 22 July 2013 17:23:11 UTC-5, samuel bonilla wrote: > > the best option in python is > > http://mokshaproject.net/ > > El jueves, 18 de julio de 2013 17:58:54 UTC

Re: [web2py] FPDF database image

2013-07-22 Thread Tribo Eila
I figured it out, not the dimension of the files... but the type of image file. When I used the .png no error detected... but if I used .jpeg/.jpg it makes me trouble... Need help to solve these. Regards, Eila On Monday, July 15, 2013 6:49:00 PM UTC+3, Mariano Reingart wrote: > > You shoud h

[web2py] Re: Composite Unique Key

2013-07-22 Thread Apoorve Mohan
I need to keep composite unique attributes in the db and depending of which certain actions are to be performed. If the pair of that attributes are duplicate then wrong actions will be performed. This is critical for my app. So i need to have composite unique attributes. On Thursday, July 18, 2

[web2py] Re: cursor closed errors after refactoring code from controller into modules

2013-07-22 Thread Tim Richardson
Ah yes, as the book says: and now all modules imported can access current.auth. current and import create a powerful mechanism to build extensible and reusable modules for your applications. Beware! Given from gluon import current, it is correct to use current.request and any of the other thre

[web2py] Re: cursor closed errors after refactoring code from controller into modules

2013-07-22 Thread Tim Richardson
I bet this has got something to do with the models being executed at every interaction and my global code assigned a variable to the database in the module perhaps not being updated. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To u

[web2py] cursor closed errors after refactoring code from controller into modules

2013-07-22 Thread Tim Richardson
I had some support functions in a controller. They access DAL objects, particularly databases. I'm using SQLSERVER. I moved these functions to a module. To tell my module about the databases, I store the databases in the model db.py like so current.db1 = db1 and then use a global in the module

[web2py] DAL select help

2013-07-22 Thread Trevor Overman
In my database, I have a list of items stored. What I am trying to do is select a database row when the list in the database contains the item that I am iterating through in the controller. Do anyone know how this could be done ? model db.define_table('table', Field('field_list','string'

[web2py] fw:

2013-07-22 Thread Michael Wolfe
http://mrcarinsurance.co.za/bbemolh/ljpnjralx Michael Wolfe 7/23/2013 2:16:39 AM -- --- 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 web2

[web2py] Re: real time graph

2013-07-22 Thread samuel bonilla
the best option in python is http://mokshaproject.net/ El jueves, 18 de julio de 2013 17:58:54 UTC-5, Vera Moreira escribió: > > 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

Re: [web2py] Re: offtopic : beautiful code

2013-07-22 Thread António Ramos
I see a chapter about python in the web2py book, why not add this talk to the web2py.com site somewhere... 2013/7/22 Massimo Di Pierro > Nice. I did not know partial from functools. There are a few places in > web2py related to streaming where we could use it to simplify code. > > On Sunday, 21

[web2py] Re: Off topic - Ubuntu Edge

2013-07-22 Thread samuel bonilla
yes, it's Fantastic http://www.indiegogo.com/projects/ubuntu-edge El lunes, 22 de julio de 2013 11:38:54 UTC-5, Ramos escribió: > > Does it worth it? > > I´m in the process of buying a Galaxy S4 > > https://www.youtube.com/watch?v=eQLe3iIMN7k > -- --- You received this message because yo

[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 > > Specifica

[web2py] Re: dynamic url/functions in controller

2013-07-22 Thread Massimo Di Pierro
oops. I fixed the typo in my message. On Monday, 22 July 2013 14:31:20 UTC-5, Antonis Konstantinos Tzorvas wrote: > > routes_in = [ > ['/droughtmonitor/stations/$name', > '/droughtmonitor/stations/show/$name'], > ['/droughtmonitor/stations/$name/edit', > '/droughtmonitor/stations/edit/$name'

[web2py] Re: dynamic url/functions in controller

2013-07-22 Thread Antonis Konstantinos Tzorvas
routes_in = [ ['/droughtmonitor/stations/$name', '/droughtmonitor/stations/show/$name'], ['/droughtmonitor/stations/$name/edit', '/droughtmonitor/stations/edit/$name'], ] routes_out = [(y,x) for (x,y) in routes_in] it worked! care in the $node-$name difference as it wanted to be the same var

[web2py] Re: dynamic url/functions in controller

2013-07-22 Thread Massimo Di Pierro
In routes.py routes_in = [ ['/app/nodes/$name', '/app/nodes/show/$node'], ['/app/nodes/$name/edit', '/app/nodes/edit/$node'], ['/app/nodes/$name/graph', '/app/nodes/graph/$node'], ] routes_out = [(y,x) for (x,y) in routes_in] On Monday, 22 July 2013 13:37:57 UTC-5, Antonis Konstantinos Tzo

[web2py] Re: [web2pyy] Mysql 2 Mongodb

2013-07-22 Thread Alan Etkin
> > I am just playing around with mongodb and web2py > > I noticed that when I just make a web2py dump of my mysql db and then > upload it to mongodb some of the "joins" now just rec id's are right and > some are newly generated. > > Also would it be possible to keep id to be web2py specific a

Re: [web2py] offtopic : beuatiful code

2013-07-22 Thread Niphlod
it's on the slide after that. I think he says he committed that on python 3.x but of course its backportable. Il giorno lunedì 22 luglio 2013 17:35:03 UTC+2, Richard ha scritto: > > Thanks for sharing Simone! > > Appreciate! > > I notice one change that can improve web2py, but not seems available

[web2py] dynamic url/functions in controller

2013-07-22 Thread Antonis Konstantinos Tzorvas
is there any way to get dynamic urls? for example i have ip.com/app/nodes/list (smartgrid) ip.com/app/nodes/edit/[db.node.name] ip.com/app/nodes/show/[db.node.name] (details about each node) ip.com/app/nodes/graph/[db.node.name] and i am thinking on changing the url-scheme into something like th

Re: [web2py] offtopic : beuatiful code

2013-07-22 Thread Massimo Di Pierro
Technically it would be equivalent to try: os.unlink(filename) except IOError: pass one could define OSError= IOError and from future import with_statement, then define ignore(...). It is not difficult but slower than the above syntax. I prefer if os.path.exists(filename). On Monday, 2

Re: [web2py] offtopic : beuatiful code

2013-07-22 Thread Richard Vézina
Thanks for sharing Simone! Appreciate! I notice one change that can improve web2py, but not seems available in python 2.7 : with ignore(OSError): os.unlink(filename) In replacement to : if os.path.exists(filename): os.unlink(filename) https://speakerdeck.com/pyconslides/transforming-c

[web2py] Off topic - Ubuntu Edge

2013-07-22 Thread António Ramos
Does it worth it? I´m in the process of buying a Galaxy S4 https://www.youtube.com/watch?v=eQLe3iIMN7k -- --- 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 we

Re: [web2py] Re: best advice for checking/unchecking all INPUT checkboxes with certain pattern in name

2013-07-22 Thread Richard Vézina
Document ready doesn't help?? On Sat, Jul 20, 2013 at 8:30 PM, lucas wrote: > i stuck the jQuery code in the body after my form block using the SCRIPT > helper and it works fine. not really sure its placement is so critical to > its workings. lucas > > -- > > --- > You received this message b

[web2py] Re: real time graph

2013-07-22 Thread Massimo Di Pierro
Nice. In the example there is this code: data.push(random()); In the example the problem is updated using random() points. I think Vera's problem is that the data must be pushed from the server to the client. She needs a websocket. On Monday, 22 July 2013 04:19:26 UTC-5, Zbigniew Pomianowski w

[web2py] Re: offtopic : beautiful code

2013-07-22 Thread Ron McOuat
Thanks, good material. -- --- 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://groups.google.

[web2py] Re: Pass helpers in variable to views

2013-07-22 Thread shapovalovdenis
Thanks Massimo, I've completely missed that. But in my case, I'm reading this html from db. So it is: headerad_block = XML(pageElementsTable.content_block, sanitize=False) actually. So, if I keep html content of a page with IMG, A, SRCs, HREFs, etc in db, how to pass it to the view to proper

Re: [web2py] invalid table/column name "comment"

2013-07-22 Thread Jeremy Hankenson
Thank you! This explains why when I created a separate model file it worked just fine, cause I didn't include that check_reserved argument. On Monday, July 22, 2013 4:39:23 AM UTC-5, Marin Pranjić wrote: > > It's not mysql comment, but DAL is written so it works with a lot of > databases. Thi

[web2py] Re: Pass helpers in variable to views

2013-07-22 Thread Massimo Di Pierro
You are telling me you are storing this " Some Title " in db? From a technical standpoint you can do: XML(reponse.render(pageElementsTable.content_block)) but this MAY introduce a major vulnerability, depending on where the content comes from. The response render is not just evaluating {{=URL

[web2py] Re: real time graph

2013-07-22 Thread Zbigniew Pomianowski
I use d3.js - seems to at least awesome. Here are some examples with real time paths: http://bost.ocks.org/mike/path/ W dniu piątek, 19 lipca 2013 00:58:54 UTC+2 użytkownik Vera Moreira napisał: > > hi everyone, > I need some help, does anyone have examples on how to do a "real time > graph". W

[web2py] Re: Pass helpers in variable to views

2013-07-22 Thread shapovalovdenis
Massimo, thanks again. I'm aware of security risks, the html in db is just legacy static pages, no user input there, ever. I'm just converting static pages to dynamic website with apps. But your suggestion to use replace looks even better! On Monday, July 22, 2013 1:57:20 PM UTC+3, Massimo Di

[web2py] Re: Prevent specific field from update

2013-07-22 Thread lesssugar
Cool, thanks a lot! On Monday, July 22, 2013 12:59:08 PM UTC+2, Massimo Di Pierro wrote: > > Do not use CRUD. Use SQLFORM instead. > > form = SQLFORM(...) > if form.process(dbio=False).accepted: > if form.record.field_X == 'B': del form.vars['field_X'] > form.record.update_record(**form.va

[web2py] Re: Prevent specific field from update

2013-07-22 Thread Massimo Di Pierro
Do not use CRUD. Use SQLFORM instead. form = SQLFORM(...) if form.process(dbio=False).accepted: if form.record.field_X == 'B': del form.vars['field_X'] form.record.update_record(**form.vars) On Monday, 22 July 2013 05:26:41 UTC-5, lesssugar wrote: > > Hi, Massimo, > > thanks for the solut

[web2py] import from csv

2013-07-22 Thread K. Antonis Tzorvas
with this db setup: db.define_table('station', Field('name'), Field('location'), Field('file', 'upload') db.define_table('records', ('station_id', db.station), Field('col1'), Field('col2')) col1-col2 are from file uploaded i want to have a controller that takes this csv file and imports the dat

[web2py] Re: Prevent specific field from update

2013-07-22 Thread lesssugar
Hi, Massimo, thanks for the solution, it looks totally fine but I just wasn't clear enough on this - my bad. The thing is I'm using crud.update() to generate the form I described earlier. How would I adapt your code to crud? I could use "onaccept" but it's triggered after the update nad before

Re: [web2py] Re: Radio Buttons layout problem with trunk

2013-07-22 Thread Johann Spies
Paolo and Massimo, Thank you very much for correcting this in the trunk. Regards Johann On 18 July 2013 18:46, Massimo Di Pierro wrote: > Thanks! :-) > > > On Thursday, 18 July 2013 11:16:12 UTC-5, Paolo Caruccio wrote: >> >> I answered to a specific question but you are right: the code shoul

Re: [web2py] invalid table/column name "comment"

2013-07-22 Thread Marin Pranjić
It's not mysql comment, but DAL is written so it works with a lot of databases. This could stop you from moving to another database engine later. If you want to turn it off, just edit your db.py file and remove check_reserved argument from your DAL(...) init call. I'd rather change column name - bu

Re: [web2py] FPDF database image

2013-07-22 Thread Tribo Eila
I followed your advised Massimo. It installed well. I already figured the dimensions of the images conflict. The 320x479 uploaded file works well. But if the users uploaded 1600x1200 or more, it makes the same error. Am I missing something? On Tuesday, July 16, 2013 1:13:53 PM UTC+3, Massimo D

[web2py] invalid table/column name "comment"

2013-07-22 Thread Jeremy Hankenson
Interesting problem I've encountered. I'm getting the error: * invalid table/column name "comment" is a "ALL" reserved SQL/NOSQL keyword* * * after defining my tables as such: # define tables for blog posts db.define_table('post', Field('title', unique=True), Field('body', 'text'),

[web2py] Re: offtopic : beautiful code

2013-07-22 Thread Massimo Di Pierro
Nice. I did not know partial from functools. There are a few places in web2py related to streaming where we could use it to simplify code. On Sunday, 21 July 2013 17:07:04 UTC-5, Niphlod wrote: > > I actually skipped over this a few times and today I finally reached its > place in my playlist fo

[web2py] Re: Pass helpers in variable to views

2013-07-22 Thread Massimo Di Pierro
You cannot use the template language inside a string. You can use inside a template file. content_block = XML("h1> Some Title ", should be content_block = XML('Some Title ' % URL('static','images/python.gif')) On Monday, 22 July 2013 00:20:07 UTC-5, shapova...@gmail.com wrote: > > Hi! > > Kn

[web2py] Re: weird bug with redis

2013-07-22 Thread dederocks
Thanks A LOT Simone, that solved this problem! Much much appreciated your help!! Le vendredi 19 juillet 2013 02:15:25 UTC+2, Niphlod a écrit : > > seems a more general problem within the os than a bug with web2py and > redis. although I'm a heavy user of redis, I never encountered that error. >