[web2py] How to track page visits

2013-01-09 Thread sasogeek
what code will I put in controllers/views to track the number of times users visit a particular page such that anyone anywhere can see how many times that page has been viewed by anyone anywhere? Eg. If I view page A 5 times, and you view page A 3 times, and another person views page A 7

[web2py] Re: How to track page visits

2013-01-09 Thread David Marko
If this has to be persistent among server restarts, you should store it into database ... Dne středa, 9. ledna 2013 9:38:34 UTC+1 sasogeek napsal(a): what code will I put in controllers/views to track the number of times users visit a particular page such that anyone anywhere can see how

[web2py] Smartgrid orderby field , descending

2013-01-09 Thread António Ramos
hello, how do i order a smartgrid based on a field in descending order? for example the auth event table on date descending thank you --

Re: [web2py] Re: drop table cascade

2013-01-09 Thread Liang Yi Aris
No error shown in the interactive shell after executing the command. But the tables in the database are still there. I use Postgresql 9.2. On Wed, Jan 9, 2013 at 1:35 AM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: What do you get? An error? What error? On Friday, January 4, 2013

Re: [web2py] Re: Resizing a user uploaded image

2013-01-09 Thread Daniele Pestilli
No, just regular web2py webserver on my machine. Jan 9, 2013 2:36 AM、Bruno Rocha rochacbr...@gmail.com のメッセージ: are you running on Google App Engine? -- --

Re: [web2py] Smartgrid orderby field , descending

2013-01-09 Thread Javier Pepe
Use this: orderby=~db.table.date On Wed, Jan 9, 2013 at 7:08 AM, António Ramos ramstei...@gmail.com wrote: hello, how do i order a smartgrid based on a field in descending order? for example the auth event table on date descending thank you -- --

[web2py] Help with multi tenancy

2013-01-09 Thread Fabiano Faver
Its my first time dealing with multi tenancy and I'm still a bit confused how i could implement it with my scenario. I've built a app and want to allow that each 'company' access only their data. Each company have their user admin that can register products,things,etc and other users and their

[web2py] Re: Help with multi tenancy

2013-01-09 Thread David Marko
Here is feature description in docs: http://web2py.com/books/default/chapter/29/06?search=tenancy#Common-fields-and-multi-tenancy Dne středa, 9. ledna 2013 13:31:59 UTC+1 Fabiano Faver napsal(a): Its my first time dealing with multi tenancy and I'm still a bit confused how i could

[web2py] Re: Help with multi tenancy

2013-01-09 Thread Fabiano Faver
I got it. And how can I put this to only auth_user and auth_group too? So that Sub-admins can have a sqlform.grid with the users that he can see and add others? but only inside his company Em quarta-feira, 9 de janeiro de 2013 11h34min48s UTC-2, David Marko escreveu: Here is feature

[web2py] (2, 4, 1, 'alpha.2', datetime.datetime(2013, 1, 8, 15, 30, 47)) trunk: formstyle_bootstrap broken

2013-01-09 Thread Adi
Seems that bootstrap broke in latest trunk. All my forms, which use bootstrap are returning errors... commenting formstyle='bootstrap' makes it work fine. Traceback (most recent call last): File /Users/adnan/web2py24/gluon/restricted.py, line 212, in restricted exec ccode in environment

[web2py] About web2py videos and stuff

2013-01-09 Thread António Ramos
Hello i noticed that almost all of the video tutorials about web2py come from the master itself, Maximo Maximo needs time to make web2py better. and web2py is not a baby anymore! If web2py is used as a teaching tool and a lot of students use it, would it not be more productive to have the

[web2py] Appliance Manage Contacts - invalid view (default/company_create.html)

2013-01-09 Thread António Ramos
I got this error in Manage Contacts Appliance invalid view (default/company_create.html) when creating company Thank you --

Re: [web2py] About web2py videos and stuff

2013-01-09 Thread Bruno Rocha
I create some videos! (currently I have 308 web2py videos on my VIMEO account) But, it is all in Portuguese and major part of them are exclusively for my students. +1 for a video contest! Example of my on line web2py classes. A complete introduction to web

Re: [web2py] Re: drop table cascade

2013-01-09 Thread Massimo Di Pierro
Did you do db.commit() after the db.table.drop()? On Tuesday, 8 January 2013 20:14:23 UTC-6, Liang wrote: No error shown in the interactive shell after executing the command. But the tables in the database are still there. I use Postgresql 9.2. On Wed, Jan 9, 2013 at 1:35 AM, Massimo Di

[web2py] Re: (2, 4, 1, 'alpha.2', datetime.datetime(2013, 1, 8, 15, 30, 47)) trunk: formstyle_bootstrap broken

2013-01-09 Thread Massimo Di Pierro
I think this is now fixed in trunk. Can you please check? On Wednesday, 9 January 2013 08:33:35 UTC-6, Adi wrote: Seems that bootstrap broke in latest trunk. All my forms, which use bootstrap are returning errors... commenting formstyle='bootstrap' makes it work fine. Traceback (most

[web2py] Re: (2, 4, 1, 'alpha.2', datetime.datetime(2013, 1, 8, 15, 30, 47)) trunk: formstyle_bootstrap broken

2013-01-09 Thread Adi
Works. Thanks Massimo! On Wednesday, January 9, 2013 10:37:19 AM UTC-5, Massimo Di Pierro wrote: I think this is now fixed in trunk. Can you please check? On Wednesday, 9 January 2013 08:33:35 UTC-6, Adi wrote: Seems that bootstrap broke in latest trunk. All my forms, which use bootstrap

Re: [web2py] Appliance Manage Contacts - invalid view (default/company_create.html)

2013-01-09 Thread Marco Mansilla
can you show the controller?, maybe it a mistake in the default.py contoller defining def company_create(): return dict() El Wed, 9 Jan 2013 14:53:01 + António Ramos ramstei...@gmail.com escribió: I got this error in Manage Contacts Appliance invalid view

[web2py] Ruby on rails Vulnerability

2013-01-09 Thread Massimo Di Pierro
Not to pick on the competition but this is very serious https://news.ycombinator.com/item?id=5028270 This is as web2py where to do pickle.loads(request.vars.whatever) by default in every application. Who sane of mind would do it? Massimo --

[web2py] Re: About web2py videos and stuff

2013-01-09 Thread Massimo Di Pierro
+1000 (I am bad at making videos) On Wednesday, 9 January 2013 08:39:50 UTC-6, Ramos wrote: Hello i noticed that almost all of the video tutorials about web2py come from the master itself, Maximo Maximo needs time to make web2py better. and web2py is not a baby anymore! If web2py is used

Re: [web2py] Appliance Manage Contacts - invalid view (default/company_create.html)

2013-01-09 Thread António Ramos
I deleted the app. The view does not exist!!! As some of the appliances, this also have bugs and its not good for web2py to put a link to appliances that have missing code or errors. It just doesnt help! 2013/1/9 Marco Mansilla thebigsho...@gmail.com can you show the controller?, maybe it a

Re: [web2py] Ruby on rails Vulnerability

2013-01-09 Thread Javier Quarite
Yes, indeed this is serious. If there are people here that develop with RoR should upgrade. Yesterday someone post about this http://www.insinuator.net/2013/01/rails-yaml/ (It may not be the right thing to do, but it helped me to understand) There's a microframework in ruby called Sinatra and the

[web2py] Re: PosOnlineStore example:, views/default/invioce.html wrongly named. (Fix)

2013-01-09 Thread Massimo Di Pierro
fixed. thanks. On Monday, 7 January 2013 10:11:45 UTC-6, web...@uit.co.uk wrote: In the PosOnlineStore example appliance, views/default/invioce.html should be called views/default/invoice.h All that's required to fix this is to rename the file to the correct name. This doesn't make much

[web2py] Re: SQLFORM widget support for wider range of input types

2013-01-09 Thread Massimo Di Pierro
I opened a thread in web2py-developers. I think we should support html5 types but we cannot break html4. On Thursday, 3 January 2013 04:56:33 UTC-6, Alan Etkin wrote: El domingo, 30 de diciembre de 2012 18:18:12 UTC-3, Massimo Di Pierro escribió: Seems like a good idea. What do other

[web2py] Re: cpdb errors

2013-01-09 Thread Massimo Di Pierro
Is there still an open issue here? On Tuesday, 8 January 2013 04:58:58 UTC-6, Simon Ashley wrote: That's a negative on cache.py. It's from a nightly build pulled about 5 days ago. The csv in question is about 150k records. (have pruned it down to a test of 10 records, and they import OK).

[web2py] Re: parse_as_rest queries

2013-01-09 Thread Massimo Di Pierro
I have implemented what you requested: patterns = [ ('/dogs[pet]', db.pet.kind=='dog') ] Can you please check it? On Monday, 31 December 2012 11:30:34 UTC-6, DenesL wrote: +1 for an extended syntax instead of routes. Blog post about http://blog.2partsmagic.com/restful-uri-design/ which

[web2py] Re: SQLFORM.factory + Multiple Tables + Upload Field + GAE Blob Problem

2013-01-09 Thread Massimo Di Pierro
Looking into this. Can you confirm the problem is isolated to uploads on GAE when using SQLFORM.factory(...) with more than one table in the arguments? On Tuesday, 21 August 2012 13:19:47 UTC-5, JungHyun Kim wrote: I found a work around to solve this problem I added these 3 lines after

[web2py] Re: error in mysql ?

2013-01-09 Thread rochacbruno
I found the problem, The problem is in Category basemodel https://github.com/rochacbruno/Movuca/blob/master/modules/datamodel/article.py#L172 It has fixtures which runs if category table is empty, it is needed because a default general category is always needed, category has self references

[web2py] Re: Official site quotes

2013-01-09 Thread Massimo Di Pierro
I cannot edit a quote from twitter. How about you you tweet something about web2py and I link it in the main page? On Thursday, 27 December 2012 06:46:26 UTC-6, Alan Etkin wrote: I think this should be changed: - Quotes by tech reviewers/users should take precedence over quotes by

[web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard

2013-01-09 Thread Massimo Di Pierro
Is this down? http://labs.blouweb.com/powerformwizard On Wednesday, 29 June 2011 09:33:10 UTC-5, rochacbruno wrote: Hi, I just created a new plugin for stepped form wizards. I made it last night, so it is not tested very well, I would like your help to test it. web2py PowerFormWizard

Re: [web2py] Re: cpdb errors

2013-01-09 Thread Martin Senecal
I don't think so. Once Simon unquoted his cmd line option values, he was able to do a DB copy with the following OS/DB combinations: Windows + sqlite Windows + mysql But is reporting issues with Windows + postgres (memory leak?) His plan is to repeat the same steps but on a linux system,

Re: [web2py] Re: SQLFORM Next Item in Database

2013-01-09 Thread D.P. Clark
I considered that idea, but the selection from the larger database may not always be consecutive in ID value. In that scenario, a user may end up editing an entry that the shouldn't have been looking at in the first place. Good suggestion though. On Tue, Jan 8, 2013 at 3:57 PM, Derek

[web2py] Re: raspberry pi

2013-01-09 Thread Peter Etchells
On Tuesday, 13 March 2012 23:04:40 UTC+13, Ramos wrote: it would be nice to be able to install web2py in raspberry pi http://www.raspberrypi.org/ --

[web2py] Re: raspberry pi

2013-01-09 Thread Peter Etchells
web2py for home automation: http://www.instructables.com/id/Raspberry-Pi-GPIO-home-automation/#intro --

[web2py] Re: SQLFORM widget support for wider range of input types

2013-01-09 Thread Alan Etkin
I'll try. Thanks. That's not an easy task though, there are some literary skills involved (for posting anything worth the link of course). --

[web2py] auth.wiki deployment issue

2013-01-09 Thread Andrew W
Hi, I need some help please. I've just deployed my first auth.wiki app. I'll let you know what it is once it's working properly. I've deployed to HostGator using web2py 2.3.2 (and the posts in this forum on the subject were very helpful). Using render='markmin' Everything was looking good

[web2py] Re: About web2py videos and stuff

2013-01-09 Thread Alan Etkin
El miércoles, 9 de enero de 2013 13:13:51 UTC-3, Massimo Di Pierro escribió:+1000 (I am bad at making videos) Sorry for the repeated information, but: for PyConAr 2012, we've developed an OS web2py app for storing and showing video streams (from local files or remote streams) that provides

[web2py] Re: auth.wiki deployment issue

2013-01-09 Thread Andrew W
Another Big Issue that I only just found after stopping my local rocket server: None of the Page Images are displaying. They are obviously looking for the localhost reference, which was looking great when I was also running locally. Looking at the html I see the following in the menu (Looks

[web2py] Re: auth.wiki deployment issue

2013-01-09 Thread Andrew W
I'll answer my own questions :) : It's because the wiki page saves the body (user entered content) and the generated html separately. The html has not been regenerated. How do I get it to regenerate all of the pages after deployment in the new environment ? Thanks Andrew W On Thursday,

[web2py] Re: auth.wiki deployment issue

2013-01-09 Thread Andrew W
and again: I edited each page and submitted. All OK.Just a little bit of a pain. It is only a one off task, but would a Submit All button be appropriate on the Manage Pages page ? On Thursday, January 10, 2013 8:42:34 AM UTC+13, Andrew W wrote: I'll answer my own questions :) : It's

[web2py] Re: Official site quotes

2013-01-09 Thread Alan Etkin
Ok. Let me think of something. Thanks --

[web2py] Re: auth.wiki deployment issue

2013-01-09 Thread Alan Etkin
Just a little bit of a pain. It is only a one off task, but would a Submit All button be appropriate on the Manage Pages page ? A workaround could be: # content setup (after changing the app url) for wiki in db(..).select() wiki.update_record(html=MARKMIN(wiki.body).xml()) --

Re: [web2py] Re: new plugin - web2py Form Wizard - PowerFormWizard

2013-01-09 Thread juaneduardo
Bruno to solve 'PowerFormWizard' object has no attribute 'readonly' I added 2 lines to powerForm plugin In modules/plugin_PowerFormWizard.py def __init__(self, table, steps, formstyle = 'divs', options={},

[web2py] Re: raspberry pi

2013-01-09 Thread Massimo Di Pierro
This is going on reddit.com immediately! Time for me to buy a raspberrypi. Massimo On Wednesday, 9 January 2013 12:37:45 UTC-6, Peter Etchells wrote: web2py for home automation: http://www.instructables.com/id/Raspberry-Pi-GPIO-home-automation/#intro --

[web2py] Re: Syntax allowed in app names.

2013-01-09 Thread Massimo Di Pierro
Can you please open a ticket about this? On Wednesday, 9 January 2013 14:25:33 UTC-6, rh wrote: I created some apps named like so: app.1 app.2 via the admin interface and it creates them but those apps don't show up with the other apps in the admin. It seems to me that if that

[web2py] Re: raspberry pi

2013-01-09 Thread Paul Gerrard
On Sunday, 23 December 2012 04:49:45 UTC, Paul Gerrard wrote: 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

[web2py] Re: raspberry pi

2013-01-09 Thread Paul Gerrard
On Wednesday, 9 January 2013 22:33:18 UTC, Paul Gerrard wrote: On Sunday, 23 December 2012 04:49:45 UTC, Paul Gerrard wrote: 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

Re: [web2py] Re: cpdb errors

2013-01-09 Thread Simon Ashley
Just confirming that csv imports fail with Postgres on Ubuntu 12.10, but both sqlite and mysql import fine. Suspect its a postgres issue, and will attempt different adapters/ refactor of the DAL table def to try and identify the cause Error message is fairly generic.

Re: [web2py] Re: cpdb errors

2013-01-09 Thread Massimo Di Pierro
which postgres version? On Wednesday, 9 January 2013 16:46:45 UTC-6, Simon Ashley wrote: Just confirming that csv imports fail with Postgres on Ubuntu 12.10, but both sqlite and mysql import fine. Suspect its a postgres issue, and will attempt different adapters/ refactor of the DAL

Re: [web2py] Re: cpdb errors

2013-01-09 Thread Simon Ashley
9.1 (fresh install yesterday) --

Re: [web2py] Re: SQLFORM Next Item in Database

2013-01-09 Thread Derek
Well, perhaps you could have a function called 'getNextID' which would query the database for the next higher ID value. On Wednesday, January 9, 2013 11:15:21 AM UTC-7, D.P. wrote: I considered that idea, but the selection from the larger database may not always be consecutive in ID value.

[web2py] Re: error in mysql ?

2013-01-09 Thread samuel bonilla
thanks bruno. you're a genius El jueves, 3 de enero de 2013 20:30:53 UTC-5, samuel bonilla escribió: this is the error class '_mysql_exceptions.IntegrityError' (1452, 'Cannot add or update a child row: a foreign key constraint fails (`samuel$otra`.`article_category`, CONSTRAINT

[web2py] Re: web2py application cookbook - reporting recipe

2013-01-09 Thread Alan Etkin
hello i was reading the book and using the code for the label/badge generation i got an error on Odd. I think I tested that example with Linux. Perhaps this is caused by a code update in the fpdf library. --

[web2py] width

2013-01-09 Thread Saba
db.define_table('emp', Field('name') -- some of the data in this column has really long values. ) db.define_table('emp_details', Field('name'),requires=[IS_IN_DB(db,'employee.name')]), Field('details') ) I'm using SQLFORM.grid to manage the data in the above tables. The

[web2py] Re: web2py application cookbook - reporting recipe

2013-01-09 Thread Massimo Di Pierro
The fpdf that comes with web2py has been modifed from the official one (to fix some compatibility problems) and changes where never merged into the official fpdf. On Wednesday, 9 January 2013 17:25:01 UTC-6, Alan Etkin wrote: hello i was reading the book and using the code for the

Re: [web2py] Re: Official site quotes

2013-01-09 Thread Michele Comitini
massimo btw can we show the #web2py twits not only to @web2py is possible in the admin app? 2013/1/9 Alan Etkin spame...@gmail.com: Ok. Let me think of something. Thanks -- --

Re: [web2py] Re: Official site quotes

2013-01-09 Thread Massimo Di Pierro
We can but should we? Let's discuss it on web2py developers. On Wednesday, 9 January 2013 18:27:42 UTC-6, Michele Comitini wrote: massimo btw can we show the #web2py twits not only to @web2py is possible in the admin app? 2013/1/9 Alan Etkin spam...@gmail.com javascript:: Ok. Let me

[web2py] Re: raspberry pi

2013-01-09 Thread Massimo Di Pierro
You are #6 or reddit.com front page! :-) On Wednesday, 9 January 2013 12:37:45 UTC-6, Peter Etchells wrote: web2py for home automation: http://www.instructables.com/id/Raspberry-Pi-GPIO-home-automation/#intro --

[web2py] how to quote in markmin

2013-01-09 Thread weheh
How to quote to get markmin to print instead of amp;? --

[web2py] SQLFORM question

2013-01-09 Thread b00m_chef
I need the code below to generate a form with a list of only names that are owned by the user logged in, not all names made by all people. db.define_table('owner', Field('user', db.auth_user), Field('name', 'string')) db.define_table('collar', Field('user', db.auth_user), Field('name',

Re: [web2py] Re: cpdb errors

2013-01-09 Thread Simon Ashley
I hate this. Its fixed (stable) for the time being, but cant clearly identify the cause. I'm sure that there is a still memory leak and it may appear again.. Early in the process, Ubuntu was acting similarly to Windows 7 i.e. consuming memory when importing the csv file and eventually failing.

Re: [web2py] SQLFORM question

2013-01-09 Thread Bruno Rocha
On Thu, Jan 10, 2013 at 3:09 AM, b00m_chef roman.goldm...@gmail.com wrote: requires=IS_IN_DB(*db(db.owner.user == auth.user.id)*, 'owner.id', '%(name)s') --

Re: [web2py] SQLFORM question

2013-01-09 Thread b00m_chef
I get an error on loading the new puppy page for first time. I had to change your code as it didn't work to the following: requires=IS_IN_DB(*db(db.owner.user == db.auth_user.idhttp://auth.user.id/ )*, 'owner.id', '%(name)s') Now I get an error: class 'sqlite3.OperationalError' no such table:

Re: [web2py] SQLFORM question

2013-01-09 Thread b00m_chef
I found why it wasn't working. It is because the db was set to migrate=False. However, the code doesn't work. I still get a listing of all Collars from all owners. On Wednesday, January 9, 2013 10:25:25 PM UTC-8, b00m_chef wrote: I get an error on loading the new puppy page for first time.