[web2py] Quoting reserved words in DAL

2012-06-18 Thread Michael Toomim
I just got bit by the reserved-word problem: https://groups.google.com/d/msg/web2py/aSPtD_mGXdM/c7et_2l_54wJ I am trying to port a postgres database to a friend's mysql database, but we are stuck because the DAL does not quote identifiers. This problem has been discussed a fair amount: https://g

Re: [web2py] Re: database locking web2py vs. "external" access...

2012-06-18 Thread Niphlod
> > Ok, just to double check, that is for all DB back-ends or just for SQLite? > > This is true for every backend. > > > Ah, OK. So it would be easier to write code that uses any DB except > for SQLite... Hmmm > It's not a question of "easier" or "harder" : as always it's just choosing th

[web2py] Re: Best practice using scheduler as a task queue?

2012-06-18 Thread Niphlod
I'll get back to you this evening, but for now, maybe it's a fix. You're afraid that starting n web2py processes your code in "initialize" will duplicate inserts. That is the common behaviour in db transactions. if you're running three processes, and you're not lucky, all three will "se

[web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-18 Thread Andrew
Looks Great to me ! On Monday, June 18, 2012 4:38:09 PM UTC+12, Massimo Di Pierro wrote: > > Check what's in trunk now. Let me know if you think it needs improvement. > > On Sunday, 17 June 2012 15:45:41 UTC-5, Cliff Kachinske wrote: >> >> I agree that the old look, with dividers, *looks* better

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Andrew
My understanding is that the themes are all contained in a new bootstrap.css, or bootstrap.min.css file. These are the ones we don't want to touch. I've downloaded a few to have a look. I thought the bootswatch.css is just some extra styling to get the bootswatch themes (the different bootstr

Re: [web2py] Re: id.max()

2012-06-18 Thread Vasile Ermicioi
or max_id = db(db.Node).select(db.Node.id, orderby=~db.Node.id, limitby=(0,1)).first().id --

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-18 Thread Alec Taylor
b 1 Also, make it contrast with the background, e.g.: white text colour On Mon, Jun 18, 2012 at 6:30 PM, Andrew wrote: > Looks Great to me ! > > > > On Monday, June 18, 2012 4:38:09 PM UTC+12, Massimo Di Pierro wrote: >> >> Check what's in trunk now. Let me know if you think it needs improvement

[web2py] CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

2012-06-18 Thread Lazarof
CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

Re: [web2py] CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

2012-06-18 Thread Bruno Rocha
more info about it? http://zerp.ly/rochacbruno Em 18/06/2012 06:29, "Lazarof" escreveu: > CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL >

Re: [web2py] CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

2012-06-18 Thread Bruno Rocha
ok I got it http://thehackernews.com/2012/06/cve-2012-2122-serious-mysql.html?m=1 Em 18/06/2012 07:07, "Bruno Rocha" escreveu: > more info about it? > > http://zerp.ly/rochacbruno > Em 18/06/2012 06:29, "Lazarof" escreveu: > >> CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL >> >

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Paolo Caruccio
Massimo, actually files with prefix V2_ allow this: download and apply in w2p a bootswacth theme without other actions by user. Il giorno lunedì 18 giugno 2012 06:39:23 UTC+2, Massimo Di Pierro ha scritto: > > I included your patch but not version V2. That is because we do not want > to manta

[web2py] Problem while using two sqlform.grid in a single form

2012-06-18 Thread rahulserver
I tried to use two sqlform.grid in a web2py form. It does work as intended except for the problem that when I try to edit on of the form's row, other form's row with same Id also appears to be edited. How should i stop it? my controller: def CommitmentBrowse_rep(): rows=db(db.Commitments.Acco

Re: [web2py] Re: Upload the more than 100 MB file

2012-06-18 Thread Khalil KHAMLICHI
In case it might help, here is my trace back file and the controller (I am doing a manual insert, maybe I should not ?) : ## CONTROLLER STARTS HERE form = SQLFORM(db.fichiers, fields=['nom_fichier', 'fichier', 'project', 'description', 'users', 'deleted']) if form.v

[web2py] Problems with using downloaded layouts

2012-06-18 Thread rahulserver
I am facing two problems in general with downloaded layouts from web2py site: 1) whenever a form or table extends beyond the page body area, it goes beyound the middle area's margin.In default layout, the middle area appears to expand to accomodate the form or table. 2) In Sqlform.grid or smartg

Re: [web2py] CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

2012-06-18 Thread Michele Comitini
Here is some more detail http://ow.ly/bDXWk mic 2012/6/18 Bruno Rocha : > more info about it? > > http://zerp.ly/rochacbruno > > Em 18/06/2012 06:29, "Lazarof" escreveu: > >> CVE-2012-2122: A Tragically Comedic Security Flaw in MySQL

[web2py] Gaema/ web2py_multiauth, login_form not defined

2012-06-18 Thread wiel
I am trying to setup the gaema port from here http://code.google.com/p/cfhowes/source/browse/ now I followed the installation instructions to the T, but when the time came to view login_area.html i get this error: name 'login_form' is not defined did anybody get this error and get over it?

[web2py] Getting Aptana3 / GAE / web2py

2012-06-18 Thread sspiel
What are the recommended configuration settings for getting Aptana3 and GAE working with web2py? Currently, I'm using: 1. Project Type: PyDev 2. Workspace View: Web 3. Run Configurations: {web2py local server instance, webrowser with URL set to Application Administration interface 4. Added a cod

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Anthony
What is your db.UserImageStore model, and what is the code for downloading the image? On Monday, June 18, 2012 7:49:58 AM UTC-4, Sushant Taneja wrote: > > Hi, > > I am building an app using AppEngine + Web2py > > A user's profile image is retrieved from his Facebook profile via the > Graph API a

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Lucas R. Martins
i'm not using web2py-level caching, but i would like to use, if i can limit memory usage and expire it when i need. i have compiled app and i'm using sqlite. sqlite is a problem? 2012/6/18 Massimo Di Pierro > Are you using caching? Are you using sqlite? We should nail down the cause > of this p

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Sushant Taneja
The code for the model UserImageStore is : dal_db.define_table('UserImageStore', Field('profile_image','upload',uploadfield='profile_blob'), Field('profile_blob','blob'), Field('upload_ts','datetime'), Field('change_ts','datetime') ) and the my show_image function is : def show_i

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Anthony
> > and the my show_image function is : > > def show_image(): > return response.download(request,dal_db) > That's the problem -- response.download() calls dal.Field.retrieve(), which assumes the filename is encoded via base64.b16encode (i.e., it assumes the file was stored using dal.Field.s

[web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-18 Thread Omi Chiba
Absolutely b1! but how about change color to WHITE ? It will match the color on the left corner, such as menus, and blue link is hard to see on the black background. On Saturday, June 16, 2012 10:30:04 PM UTC-5, Andrew wrote: > > A week or two ago a change was made to the nav bar to give the a

[web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-18 Thread Omi Chiba
Never mind, I just confirmed it's WHITE in the latest trunk. On Monday, June 18, 2012 8:51:29 AM UTC-5, Omi Chiba wrote: > > Absolutely b1! but how about change color to WHITE ? > It will match the color on the left corner, such as menus, and blue link > is hard to see on the black background. >

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-18 Thread Richard Vézina
+1 option to use them! Richard On Sun, Jun 17, 2012 at 4:45 PM, Cliff Kachinske wrote: > I agree that the old look, with dividers, *looks* better. > > I also think the buttons are easier to find on the page, so I would like > to optionally use them. > > Would you take a patch with the option? >

Re: [web2py] Infinite loop: Auth using OAuth2 with Facebook

2012-06-18 Thread Alec Taylor
It seems to all work on facebook's side, I think there is something wrong with the aforementioned implementation I used. Can you review the ~20 lines of code and its positioning to highlight the problem? Thanks a heap On Sun, Jun 17, 2012 at 11:02 PM, Michele Comitini wrote: > Alec, > > There c

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Sushant Taneja
Will this work on AppEngine ? Since there is no filesystem The code for manual uploads is : stream = open(filename,'rb') Will this not give error since it will not be able to find the file ? On Monday, June 18, 2012 6:52:02 PM UTC+5:30, Anthony wrote: > > and the my show_image function is : >>

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Sushant Taneja
Sorry got confused. Made it work ! Here is the final code : dal_db.UserImageStore.insert(profile_image = dal_db.UserImageStore.profile_image.store(profile_image,), profile_blob = profile_image, upload_ts = datetime.now(),

[web2py] Re: Crappy downloaded image names

2012-06-18 Thread Anthony
Actually, on GAE, I don't think you have to explicitly define the blob field at all -- the DAL will automatically create a blob field for each upload field and store uploaded files in the blob field. So, I think this should work: dal_db.define_table('UserImageStore', Field('profile_image',

[web2py] how can I pick a directory from a web2py form (equivalent to WxDirPickerCtrl)

2012-06-18 Thread Janath
I need a control in a form which allows me to browse and select a directory (folder). any clue is appreciated! Janath

[web2py] Web2Py compute fields not working on update

2012-06-18 Thread Brandon Reynolds
I have this problem when i try to generate thumbnails. If the field is empty it inserts the photo thumb into the thumbnail. But when i try to update that record the thumbnail doesn't change. Here is my model: # coding: utf8 from image import THUMBER db.define_table('park', Field('park_name',

[web2py] uwsgi enable-thread option and web2py

2012-06-18 Thread mrtn
I'm deploying web2py with uwsgi 1.2.3, and upon starting the app, there is message in the uwsgi log says; *** Python threads support is disabled. You can enable it with --enable-threads *** And in the uwsgi doc, it says the following for option enable-thread: Enable threads in the embedded la

[web2py] Re: how can I pick a directory from a web2py form (equivalent to WxDirPickerCtrl)

2012-06-18 Thread Anthony
>From what I've read, this is not possible in HTML/Javascript from a browser (you can select a file, but not a folder path). Apparently it can be done via a Java applet, ActiveX plugin, or Flash. Anthony On Monday, June 18, 2012 11:52:06 AM UTC-4, Janath wrote: > > I need a control in a form wh

[web2py] count current visitors

2012-06-18 Thread ctrlSoft
hi, how to count current site visitors? smth like in google analitycs ... real-time visitors.

Re: [web2py] count current visitors

2012-06-18 Thread Richard Vézina
There is this : http://web2py.com/books/default/chapter/29/3?search=say#Let's-count On Mon, Jun 18, 2012 at 2:16 PM, ctrlSoft wrote: > hi, how to count current site visitors? smth like in google analitycs ... > real-time visitors.

Re: [web2py] count current visitors

2012-06-18 Thread Richard Vézina
Or more like google analytic there is the python Piwik : http://piwik.org/ Richard On Mon, Jun 18, 2012 at 2:23 PM, Richard Vézina wrote: > There is this : > http://web2py.com/books/default/chapter/29/3?search=say#Let's-count > > > > On Mon, Jun 18, 2012 at 2:16 PM, ctrlSoft wrote: > >> hi, ho

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Massimo Di Pierro
How is that possible? You edited bootswatch.css? On Monday, 18 June 2012 05:24:36 UTC-5, Paolo Caruccio wrote: > > Massimo, > > actually files with prefix V2_ allow this: download and apply in w2p a > bootswacth theme without other actions by user. > > > Il giorno lunedì 18 giugno 2012 06:39:23 U

[web2py] Re: Problem while using two sqlform.grid in a single form

2012-06-18 Thread Massimo Di Pierro
You cannot have two grids in the same page. On Monday, 18 June 2012 06:09:24 UTC-5, rahulserver wrote: > > I tried to use two sqlform.grid in a web2py form. It does work as intended > except for the problem that when I try to edit on of the form's row, other > form's row with same Id also appear

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Massimo Di Pierro
Currently there is not built-in way to limit memory usage. You can expire it but does not get deleted, only overwritten. You can explicitly delete an item from the cache using cache.ram.clear(regex) clears all items with ket matching regex. On Monday, 18 June 2012 07:42:06 UTC-5, Lucas R. Marti

[web2py] Re: Web2Py compute fields not working on update

2012-06-18 Thread Massimo Di Pierro
Let me understand this better. on insert, the thumbnails are created. on update, if you upload a new photo1 is photo_thing1 generated? Can you provide a simpler code to reproduce the problem with a just one upload field and one thumbnail field? massimo On Monday, 18 June 2012 11:24:05 UTC-

[web2py] Re: uwsgi enable-thread option and web2py

2012-06-18 Thread Massimo Di Pierro
There are pros and cons. If you use threads in a python program, the more computing cores you have, the slower - not faster - the program gets. This is a python feature because even if you have threads, there is only one interpreted and therefore execution is serialized anyway. For scalability

[web2py] Re: Web2Py compute fields not working on update

2012-06-18 Thread Brandon Reynolds
In a new record a thumbnail is correctly generated from photo. But if I didn't upload a photo or want to change the photo the thumbnail doesn't generate. So basically a new record works properly but when updating nothing in the thumbnail changes at all whether or not is currently has a photo in

[web2py] Re: GAE query cursors

2012-06-18 Thread howesc
thanks! now how do i go about updating the book to discuss these new features? On Sunday, June 17, 2012 9:09:33 PM UTC-7, Massimo Di Pierro wrote: > > uploading :-) > > On Sunday, 17 June 2012 10:40:51 UTC-5, howesc wrote: >> >> sorry if i confused you by submitting 2 non-inclusive patches.

Re: [web2py] Re: Problem while using two sqlform.grid in a single form

2012-06-18 Thread Jonathan Lundell
On Jun 18, 2012, at 3:06 PM, Massimo Di Pierro wrote: > You cannot have two grids in the same page. I'm using two grids on a page. It seemed all I needed to do was specify different formnames and it seemed to work. The second table is pretty much read-only, but it does have a paging control, and

Re: [web2py] Re: Problem while using two sqlform.grid in a single form

2012-06-18 Thread Cornelius Koelbel
+1 I am also using two grids (sometimes 4 grids) on one page. Why not? Kind regards Cornelius Am 18.06.2012 22:02, schrieb Jonathan Lundell: > On Jun 18, 2012, at 3:06 PM, Massimo Di Pierro wrote: >> You cannot have two grids in the same page. > > I'm using two grids on a page. It seemed all I n

[web2py] Re: Admin - edit static files is broken

2012-06-18 Thread Neil
Arnaud - did you find a solution to this? I am having the same problem: I deployed to nginx, and I can edit the models/views/controllers/etc. without any problems. However, I get a 404 when I try to edit static files (like a css). All files appear to have the same permissions. Anyone have ideas

[web2py] Re: Web2Py compute fields not working on update

2012-06-18 Thread Massimo Di Pierro
Will look into this asap. Please open a ticket about it so that it is tracked. On Monday, 18 June 2012 14:40:30 UTC-5, Brandon Reynolds wrote: > > In a new record a thumbnail is correctly generated from photo. But if I > didn't upload a photo or want to change the photo the thumbnail doesn't >

[web2py] Re: GAE query cursors

2012-06-18 Thread Massimo Di Pierro
Login and I will give you edit access. On Monday, 18 June 2012 14:44:39 UTC-5, howesc wrote: > > thanks! now how do i go about updating the book to discuss these new > features? > > On Sunday, June 17, 2012 9:09:33 PM UTC-7, Massimo Di Pierro wrote: >> >> uploading :-) >> >> On Sunday, 17 Ju

Re: [web2py] Re: Problem while using two sqlform.grid in a single form

2012-06-18 Thread Massimo Di Pierro
The grid uses the request args to figure out which grid page to visualize. There is only one set of request.args so if you have two grids each of them thinks the args are for them. You may get some un-intuitive behavior like navigating one grid affecting the other grid. The proper way to include

[web2py] Re: uwsgi enable-thread option and web2py

2012-06-18 Thread mrtn
Thanks Massimo. So what're the pros of having multiple threads in the context of web2py, if any? Asynchronous processing? On Monday, 18 June 2012 15:19:03 UTC-4, Massimo Di Pierro wrote: > > There are pros and cons. If you use threads in a python program, the more > computing cores you have, th

[web2py] Re: Web2Py compute fields not working on update

2012-06-18 Thread peter
I would try removing the readable and writeable false for the compute fields. It seems that it does automatically not show them. I found that setting readable and writeable to False means the thumbs only get computed on insert, not update. I reported this a while back. Peter On Monday, 18 June

Re: [web2py] count current visitors

2012-06-18 Thread ctrlSoft
thanks, very helpfull

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Paolo Caruccio
Massimo, "bootswatch.css" overwrites some css rules of "bootstrap.min.css" and "web2py.css" to allow layout to comply with bootstrap twitter theme (and consequently with bootswatch themes derived from it). "bootswatch.css" is a web2py file like "web2py.css", therefore we can edit it. Maybe we

[web2py] Re: uwsgi enable-thread option and web2py

2012-06-18 Thread Massimo Di Pierro
You need to have some kind of concurrency because if one user is doing, for example, a download you do not want other users to wait. The built-in web server uses threads for concurrency but this reduces efficiency. Some servers use lightweight threads with async sockets. They are the most effic

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Massimo Di Pierro
ok. I applied the V2. Massimo On Monday, 18 June 2012 16:41:34 UTC-5, Paolo Caruccio wrote: > > Massimo, > > "bootswatch.css" overwrites some css rules of "bootstrap.min.css" and > "web2py.css" to allow layout to comply with bootstrap twitter theme (and > consequently with bootswatch themes der

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Massimo Di Pierro
But I assume when a new version of bootswatch comes out, we will not be able to apply it without "remembering" the changes from the previous version. I am still worried about maintenance issues. Massimo On Monday, 18 June 2012 17:07:47 UTC-5, Massimo Di Pierro wrote: > > ok. I applied the V2. >

Re: [web2py] count current visitors

2012-06-18 Thread ctrlSoft
with page views i understand. but without any analitycs tools, is there a method to count active/oline visitors not registered users. i want to display on my page: total visits: 01234... today:01234.. *online:5*

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Jon Molesa
While testing webfaction I had launched a very simple app that required login to use. No one was registering so no one was using anything other than the landing page. However, webfactiion continually killed my process for going over it's memory limits. When I asked what was causing this and wha

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-06-18 Thread Paolo Caruccio
The bootswatch themes are based on bootstrap css files. Your doubt must refer to the latter one: for example, the passage from "bootstrap 2.0.2" to "bootstrap 2.0.4" caused the issue in web2py menu fixed with ".open > .dropdown-menu ul { display: block;}". In other words, we should worry about

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Vasile Ermicioi
> However, webfactiion continually killed my process for going over it's > memory limits. When I asked what was causing this and what I could do to > keep it under my account limit their reply was that this is a common > occurrence with web2py apps. I really didn't have the necessary skills to > ge

[web2py] Re: I am planning to re-develope my windows applications in python

2012-06-18 Thread Derek
If that's what your application is - define the table in your model, and add a smartgrid and you're done. It has crud (create, read, update, delete) functionality builtin, and sane defaults. a default smartgrid has 'add', 'query', sorting, paging, everything shown in your screenshots. It's so

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Jon Molesa
I can't say for certain now, but I'm pretty sure I switched from apache + mod_wsgi to uwsgi. In any case uwsgi is what I've set up on my Rackspace server. So far so good. I'm happy with the results. While I understand webfaction's need to control resource usage I really didn't appreciate that they

Re: [web2py] Re: Problem while using two sqlform.grid in a single form

2012-06-18 Thread Jonathan Lundell
On Jun 18, 2012, at 5:17 PM, Massimo Di Pierro wrote: > The grid uses the request args to figure out which grid page to visualize. > There is only one set of request.args so if you have two grids each of them > thinks the args are for them. You may get some un-intuitive behavior like > navigatin

Re: [web2py] Re: Web2py RAM usage

2012-06-18 Thread Lucas R. Martins
In my case, i just started web2py server and set up apache2 + proxypass. I need to change to uwsgi? 2012/6/18 Jon Molesa > I can't say for certain now, but I'm pretty sure I switched from > apache + mod_wsgi to uwsgi. In any case uwsgi is what I've set up on > my Rackspace server. So far so goo