[web2py] time with no date and vevent

I defined tables Day and OpeningHours: db.define_table('Day', Field('name',length=16,default='',notnull=True,unique=True), Field('byday',length=2,default='',notnull=True,unique=True), format='%(name)s', migrate=False) db.define_table('OpeningHours', Field('nodeID','reference

[web2py] Re: official book vs web2py cookbook

On Wed, 18 Apr 2012 12:33:32 +0200 Johann Spies wrote: > You can read them in parallel. The Cookbook add some information > (and of cause recipies) from which one can learn. Thank you. > They are different. The Cookbook is not a reference while the > official book is to a certain extend. I a

[web2py] Re: heroku, web2py and gunicorn

in that case, I'll try to find some information on this but on low priority :( and keep this testing on hold for some time. Thanks Massimo. Sincerely, Rahul D On Wednesday, April 18, 2012 7:14:06 PM UTC+5:30, Massimo Di Pierro wrote: > > I experience the same issue but I have a different dia

[web2py] Instant Press & Bootstrap

Is Instant Press going to adopt Bootstrap instead of Skeleton? Sincerely, Gour -- The spirit soul bewildered by the influence of false ego thinks himself the doer of activities that are in actuality carried out by the three modes of material nature. http://atmarama.net | Hlapicina (Croatia)

[web2py] .represent in case of empty field

I defined a table EventList: db.define_table('EventList', Field('nodeID','reference Node',default='',notnull=True,ondelete='CASCADE',writable=False,readable=False), Field('summary',length=128,default='',notnull=True), Field('startDate',type='date'), Field('endDate',type='date'),

[web2py] Killer Web Development site

Hello, I've found nice web site which teaches about web development using web2py framework: http://killer-web-development.com/section/1/0 but wonder if anyone knows about its' status, iow, whether it is going tobe resumed? Sincerely, Gour -- Many, many births both you and I have passed. I can

Re: [web2py] .represent in case of empty field

On 19 April 2012 10:36, Annet wrote: > > db.EventList.startDate.represent = lambda v: v.strftime('%d/%m/%Y') > > > Is there a way to solve this problem? > > > Try db.EventList.startDate.represent = lambda v: v.strftime('%d/%m/%Y') or None Regards Johann -- Because experiencing your loyal love

[web2py] Re: New CMS for web2py? - Cms2py

>> Can you remind me what's considered web2py-cms? https://github.com/gilsondev/web2py-cms >> What is your objective with cms2py in comparison with e.g. InstantPress, Movuca etc.? I didn't know about Movuca. I will try it. In comparison with Instantpress I want a little different style of the C

[web2py] Re: Using smart query with REST in GAE and datetime greater than query

Massimo, Sorry for the delayed response took me a while to get trunk, unzip correctly, etc although I know now. I used the trunk version. If I put in: http://localhost:8080/hosp/api/calldatasmart.json?search=call.start is greater than "2010-03-14" I still get the same error... If I

[web2py] Re: .represent in case of empty field

db.EventList.endDate.represent = lambda v: v.strftime('%d/%m/%Y') if v else '' or db.EventList.endDate.represent = lambda v: v and v.strftime('%d/%m/%Y') or '' Anthony On Thursday, April 19, 2012 4:36:43 AM UTC-4, Annet wrote: > > I defined a table EventList: > > db.define_table('EventList',

Re: [web2py] Re: customized edit for using .smartgrid

Just curious why you say I should use grid instead of smartgrid. I've been using smartgrid extensively for the relations to other tables. -Jim On 4/18/2012 9:20 PM, Massimo Di Pierro wrote: Thanks for checking this. I made one more change to trunk that should fix it. Please try it again.

Re: [web2py] Re: customized edit for using .smartgrid

Massimo I think we need like 1617 changed from create_form = update_form = view_form = None to create_form = update_form = view_form = search_form = None -Jim On 4/18/2012 9:20 PM, Massimo Di Pierro wrote: Thanks for checking this. I made one more change to trunk that shou

Re: [web2py] Error with mssql database : Field is a reserved SQL word

It is in the todo list. ;-) On Thursday, 19 April 2012 00:59:38 UTC-5, Khalil KHAMLICHI wrote: > > I ended up removing this field from my models, since they can accept > defaults at db level, so everyone of my inserts works now. > The problem comes from the fact that the 3d party db was designed

[web2py] Re: time with no date and vevent

The web2py in trunk han applications/welcome/views/generic.ics that makes the calendar. It contains an example. Add to your table two virtual fields (start_datetime, stop_datetime) and it should work. On Thursday, 19 April 2012 02:17:48 UTC-5, Annet wrote: > > I defined tables Day and OpeningHou

Re: [web2py] can't find logging message in gae admin console

On Apr 18, 2012, at 11:55 PM, castanets wrote: > > I deployed a web2py app on gae. > for logging, > *.copied "logging.example.conf" and renamed it to "logging.conf" > > *.added myapp to [loggers] > [loggers] > keys=root,rocket,markdown,web2py,rewrite,app,welcome,myapp > > *.added [logger_myapp]

[web2py] Re: official book vs web2py cookbook

No because most of what is in 2.0 is already in trunk and partially documented in the book. On Thursday, 19 April 2012 03:26:27 UTC-5, Gour wrote: > > On Wed, 18 Apr 2012 12:33:32 +0200 > Johann Spies > wrote: > > > You can read them in parallel. The Cookbook add some information > > (and of ca

[web2py] Re: Using smart query with REST in GAE and datetime greater than query

Can you please open a ticket about this? On Thursday, 19 April 2012 06:43:24 UTC-5, Douglas Ross wrote: > > Massimo, > > Sorry for the delayed response took me a while to get trunk, unzip > correctly, etc although I know now. > > I used the trunk version. > > If I put in: > > http://loca

Re: [web2py] Re: customized edit for using .smartgrid

good catch. fixed in trunk. On Thursday, 19 April 2012 07:52:13 UTC-5, Jim S wrote: > > Massimo > > I think we need like 1617 changed from > > create_form = update_form = view_form = None > > to > create_form = update_form = view_form = search_form = None > > -Jim > > On 4/18/

[web2py] Re: pure css skins?

Themeforest is a useful site which refers to several layout systems e.g opencart, wordpress, joomla. On Thursday, 19 April 2012 04:54:47 UTC+1, Massimo Di Pierro wrote: > > Are you aware of any template/layout/skin system based on one and the same > html but different CSS/images? Something like

[web2py] Web2py + Python 2.7 on GAE: Can I use PIL and resize an image when uploading to datastore?

This is my model. I upload the image to the logotipo_marca_blob field... I can already use from PIL import Image inside app engine SDK without problems... db.define_table('marcas', Field('nome_marca',unique=True), Field('site_marca'), Field('nome_marca_url', readable=False), Fi

[web2py] Re: pure css skins?

+1 on Themeforest. They have some pretty cool templates. Although they don't adhere strictly to the requirements that Massimo outlines in his original post.

[web2py] Re: New CMS for web2py? - Cms2py

On Thu, 19 Apr 2012 04:11:07 -0700 (PDT) Mirek Zvolský wrote: > I want implement standard > plugin-wiki but not 1 editbox for whole page, but for many posts in > same page, located into blocks (center, sidebars, header, footer). Do you know about Conrete5 CMS (PHP) > So, we have here Chinese CM

[web2py] Re: official book vs web2py cookbook

On Thu, 19 Apr 2012 06:21:46 -0700 (PDT) Massimo Di Pierro wrote: > No because most of what is in 2.0 is already in trunk and partially > documented in the book. Good. Do you envison doing another book release for web2py or the next one will be web3py? Sincerely, Gour -- One who restrains

[web2py] Re: Postgres expers -- interesting design issue

I don't understand what you are trying to achieve, but whatever it is, you are doing it wrong; your model should be: db.define_table('A', Field('name')) db.define_table('B', Field('name'), Field('id_from_table_a', 'reference A')) # alternatively: # db.define_table('B', Field('name'), Field('id_f

[web2py] Re: Memory leak in standalone DAL (issue #731), can you please help test?

On Wednesday, April 18, 2012 10:26:32 PM UTC-4, Massimo Di Pierro wrote: > > In order to isolate the problem, let's check if this is a sqlite:memory > issue. Can you reproduce the problem with sqlite://storage.db ? > Yes, same result exactly. Note that the 'storage.db' is empty, but I'm seeing t

Re: [web2py] annoying behaviour with computed fields

I think you can't have your computed field to display in the form... I mean it makes no sens anyway, since the user should not be allow to enter a value in this field since it a calculated field. I am not sure about the behavior of readable and writable field in case of computed field in a form an

Re: [web2py] annoying behaviour with computed fields

Pretty much what Richard said. If you don't want the computed functionality, just write the logic in the controller.

[web2py] Re: Memory leak in standalone DAL (issue #731), can you please help test?

I've tested in on Ubuntu 11.04, with web2py 1.99.2 and trunk and in both cases after 35s the memory use is 1GB and growing. Same results with DAL("sqlite://storage.db").

[web2py] list:reference question about order and unordered reference id list

Hello, I would know if there is a way to tell to list:reference to not order the id of the reference table to keep the order in wich the user has pick those element... At the same time I just thought that this concept is useless except in case you use some javascript plugin like Chosen Multiple

[web2py] Re: Memory leak in standalone DAL (issue #731), can you please help test?

I just tried on OSX Lion and the problem is reproduced there. The RSIZE in top increases to about 1GB in less than a minute. The Python version on Lion is 2.7.1 I can also reproduce on Ubuntu 10.04.4 which is Python 2.6.5 Ron On Thursday, 19 April 2012 10:23:50 UTC-7, nick name wrote: > > On

[web2py] Re: Web2py + Python 2.7 on GAE: Can I use PIL and resize an image when uploading to datastore?

For simple things such as thumbnails, you can use the GAE images API (which internally uses PIL): https://developers.google.com/appengine/docs/python/images/imageclass from google.appengine.api import images blob = db.marcas(id).logotipo_marca_blob image = images.Image(blob) image.resize(32, 32)

Re: [web2py] Re: routes.py

Hmmm... So how does the router know if /abc is (1) function - /default_app/default_controller/abc or (2) argument - /default_app/default_controller/default_function/abc?

Re: [web2py] Re: routes.py

On Apr 19, 2012, at 12:24 PM, Wikus van de Merwe wrote: > Hmmm... So how does the router know if /abc is (1) function - > /default_app/default_controller/abc or (2) argument - > /default_app/default_controller/default_function/abc? If you supply a functions list, then it's a function if it's in

Re: [web2py] list:reference question about order and unordered reference id list

This is a part of the solution I think : http://www.ryancramer.com/journal/entries/select_multiple/ Richard On Thu, Apr 19, 2012 at 3:08 PM, Richard wrote: > Hello, > > I would know if there is a way to tell to list:reference to not order the > id of the reference table to keep the order in wi

Re: [web2py] annoying behaviour with computed fields

I can certainly workaround it by putting the age calculation in the onvalidation function; and then when it is accepted I reread the record and recreate the form. However it is inconsistent with the book that a readable compute field is not shown on the form; and is not the most obvious behavio

Re: [web2py] annoying behaviour with computed fields

What do you mean by reread and recreate?? You create a record, you update (modify) a record and you read a record. What behavior is not correct, I think also, we would need to see your code, maybe you have some error in your code that bring you to think that it is not working as expect. Richard

Re: [web2py] annoying behaviour with computed fields

See below. The age field is read only and the form is already created when you do the accept. So to get the updated age I recreate the form with the new data. It does work though I think it would have been neater to have the age as a compute field in the model. def onvalidation(form): """ c

Re: [web2py] annoying behaviour with computed fields

Model please! I would see you lambda computed field. Richard On Thu, Apr 19, 2012 at 4:09 PM, simon wrote: > See below. The age field is read only and the form is already created when > you do the accept. So to get the updated age I recreate the form with the > new data. It does work though I

Re: [web2py] Re: Database design

Of course, silly me. Couldn't see the trees for the forest :-) Thank you Anthony. Chris On Thu, Apr 19, 2012 at 1:20 AM, Anthony wrote: > db.property.property_type.writable = False > > Anthony > > > On Wednesday, April 18, 2012 4:32:02 PM UTC-4, leftcase wrote: >> >> I've put this into the cont

[web2py] Re: Errors creating/reading tickets

What became of this? I'm seeing the same error in R-1.99.7 today. I have been seeing this error in R-1.99.3 for weeks. I upgraded my dev environment to 1.99.7 hoping that the problem was fixed but its just as bad. On Sunday, March 11, 2012 7:41:14 PM UTC-5, Massimo Di Pierro wrote: > > Please

[web2py] Re: annoying behaviour with computed fields

> > I have a person table with date of birth and a compute field for age. I > want my form to show date of birth (writable) and age (read only). When the > form is accepted I reread the table and create a new SQLFORM with the new > age. > > However I cannot get this to work. > >- On a SQLFO

Re: [web2py] annoying behaviour with computed fields

I just read this again... Maybe you want some kind of ajax triggred computed field?? I mean you want to show to your user that base on the birth date they add entered that the age is X before the even submit the form. So, to me it is a client side processing base on the field input. Richard On

[web2py] how does Web2py resolve this variable in the link string

Hello, I am new to Web2py, and while I am going through the manual, I encountered the following code: auth.messages.verify_email = 'Click on the link http://' + \ request.env.http_host + \ URL(r=request,c='default',f='user',args=['verify_email']) + \ '/%(key)s to verify your email

[web2py] How can one retrieve user's email upon verify_email action

Hello, I am using the provided 'verify_email' action exposed by Auth facilities to verify each user's registration. I wonder if there is a way for retrieving user's email (the one that is being verified) so that a welcome message can be sent upon the success of verification. I intend to do th

[web2py] problem viewing errors via admin app because of EOFError exceptions when loading the error pickle

When attempting to view an app's errors via the admin app I often get an "Internal error" page instead. Looking in applications/admin/errors/ I see that it encountered an EOFError when trying to load the error file from the app. This is happening in 1.99.7. I was seeing it a lot in 1.99.3 als

Re: [web2py] consider adding a div around error message

Is this change proposal been include in the trunk?? Richard On Fri, Mar 2, 2012 at 3:05 PM, Richard Vézina wrote: > Ok, but we need to add a DIV() > > Richard > > > On Fri, Mar 2, 2012 at 12:51 PM, Bruno Rocha wrote: > >> >> >> On Fri, Mar 2, 2012 at 2:44 PM, Richard Vézina < >> ml.richard.vez..

Re: [web2py] list:reference question about order and unordered reference id list

Some progress... I just make a check and chosen plugin multiple select option return a unordered list of the picked element by the user... So, now, I think that it could be nice if web2py allow some way to determine in case of use of chosen kind of plugin to store a unordered list in list:referen

[web2py] List of users with a specific permission

Hi I'm looking for the most concise syntax to get a list of users that have a a certain permission. Here is what I have: groups = db((db.auth_permission.name=='load')&(db.auth_permission.table_name=='railLoad'))._select(db.auth_permission.group_id) userids = db(db.auth_membership.gr

Re: [web2py] list:reference question about order and unordered reference id list

Found this http://stackoverflow.com/questions/1867861/python-dictionary-keep-keys-values-in-same-order-as-declared on stackoverflow where the most rated post redirect here : http://dev.pocoo.org/hg/sandbox/raw-file/tip/odict.py Notice, it will download odict.py into your computer that contain a cl

Re: [web2py] list:reference question about order and unordered reference id list

Issue 768 :Allow insert of unsorted or unordered list:reference type field values On Thu, Apr 19, 2012 at 5:08 PM, Richard Vézina wrote: > Found this > http://stackoverflow.com/questions/1867861/python-dictionary-keep-keys-values-in-same-orde

[web2py] Re: Using smart query with REST in GAE and datetime greater than query

Issue 769 created. Thanks. On Thursday, 19 April 2012 23:22:53 UTC+10, Massimo Di Pierro wrote: > > Can you please open a ticket about this? > > On Thursday, 19 April 2012 06:43:24 UTC-5, Douglas Ross wrote: >> >> Massimo, >> >> Sorry for the delayed response took me a while to get trunk, unzi

Re: [web2py] List of users with a specific permission

If you use postgres this SQL could help if you just want something really quick : -- View: v_permission_summary -- DROP VIEW v_permission_summary; CREATE OR REPLACE VIEW v_permission_summary AS SELECT auth_permission.id AS permission_summary_id, (auth_user.first_name::text || ' '::text) || auth

[web2py] Re: How can one retrieve user's email upon verify_email action

I've tried to retrieve the email address using 'form.vars.email', but it gives me KeyError exception. I guess this is because that there is barely anything in the 'form' object returned by auth.verify_email()

[web2py] Re: Errors creating/reading tickets

Nope, I haven't gotten anywhere with this. I see from your other postthat you are using CentOS - I had thought that maybe it was a Windows thing and that was why nobody else seemed to be having the problem but apparently not? I'm won

Re: [web2py] Re: Errors creating/reading tickets

It does correlate with mod_wsgi. I wonder if it relates to this issue: http://code.google.com/p/modwsgi/wiki/IssuesWithPickleModule On Thu, Apr 19, 2012 at 4:25 PM, Brian M wrote: > Nope, I haven't gotten anywhere with this. I see from your other > post

[web2py] Re: Postgres expers -- interesting design issue

nick, Thanks for the response. Here's a longer explanation. Two applications, one is purchasing, the other is production. Purchasing has two tables, purchase_orders and product_lots. It's a one-to-may relationship; a purchase order can have many product lots. So we get: db.define_table('purc

[web2py] Re: How can one retrieve user's email upon verify_email action

> > I intend to do this in the model, via > auth.settings.verify_email_onaccept.append(lambda form: mail.send(to=' > user.em...@example.com',subject='Welcome!', > message="new > user email is %s'%form.vars.email")) > > > I think the

Re: [web2py] Re: extra column with random number to make record not guessable

I didn't know that it was possible... isn't the ID created by web2py ? On Sun, Apr 15, 2012 at 12:28 AM, howesc wrote: > nothing stops you from making the UUID the ID field in the database. most > databases support such behavior. > > GAE even provides a way to name a record though i don't thi

Re: [web2py] List of users with a specific permission

Richard Thanks for this, but I'm really trying to stay away from extra database coding. -Jim On 4/19/2012 4:17 PM, Richard Vézina wrote: If you use postgres this SQL could help if you just want something really quick : -- View: v_permission_summary -- DROP VIEW v_permission_summary;

[web2py] How to avoid 30 signature calcs

I have a form built as a table that displays many rows to allow users to edit or delete the row. Originally, I used the classic hidden input plus a submit button to pass the id of the row to the edit code via post_vars. Now, the form is becoming more complicated to enable some other functional

[web2py] Re: List of users with a specific permission

Something like this: userQuery = ((db.auth_permssion.name=='load') & (db.auth_permission.group_id==db.auth_membership.group_id) & (db.auth_membership.user_id==db.auth_user.id)) db.railLoad.loadedById.requires = IS_IN_DB(db(userQuery), 'auth_user.id', On Thursday, April 19, 2012 5:06

Re: [web2py] Memory leak in standalone DAL (issue #731), can you please help test?

On Wed, Apr 18, 2012 at 11:41 PM, nick name wrote: > Issue reference: 731: Standalone DAL is leaking memory+resources (don't know > whether or not inside web2py) I post a comment on this issue: http://code.google.com/p/web2py/issues/detail?id=731#c4 I think this is not a bug but an incorrect u

Re: [web2py] Re: Web2py + Python 2.7 on GAE: Can I use PIL and resize an image when uploading to datastore?

Hi! Thank you for your answer. I want resize to 3 or 4 different sizes and store this values againd, on different fields... Should I do that on the function where I receive the post? Would it take to much time? And... I need to insert a logo inside the image, can it be done using images API? If n

[web2py] Re: How to avoid 30 signature calcs

> > The problem I ran into was that I could not create a get_var with a > leading underscore: , vars = dict(foo='bar',_signature=sig) > results in a url that has get_vars as in: > www.domain.com/app/action/72/return_action?foo=bar. In other words, the > get_var with the leading

Re: [web2py] Re: pure css skins?

maybe http://foundation.zurb.com/

Re: [web2py] Re: pure css skins?

here is a nice article about it : http://coding.smashingmagazine.com/2011/10/25/rapid-prototyping-for-any-device-with-foundation/ On Fri, Apr 20, 2012 at 12:24 AM, Khalil KHAMLICHI < khamlichi.kha...@gmail.com> wrote: > maybe http://foundation.zurb.com/ > >

Re: [web2py] Re: List of users with a specific permission

No, I'm looking for a list of user ids. I don't want to filter by user id. -Jim On 4/19/2012 5:08 PM, Cliff wrote: Something like this: userQuery = ((db.auth_permssion.name=='load') & (db.auth_permission.group_id==db.auth_membership.group_id) & (db.auth_membership.user_id==db.auth_user.id

Re: [web2py] Re: Link button text in smartgrid

Hi It appears as though the old behavior has been restored for the link buttons on the grid rows. However, the new style still seems to be there for the link buttons in the breadcrumbs on linked .smartgrid pages. I can't seem to find where how the first case was fixed, but would like to see

[web2py] What would be the best way to generate a summary of the 'count(*) 'of all my database table columns?

I have multiple databases: dog --- type color sound car -- model maker condition I need to generate a grid with the table names, then under them the number of columns there are. I have made multiple DAL objects for each database like so: dog = DAL('mysql://root:@localhost/dog) car = D

Re: [web2py] What would be the best way to generate a summary of the 'count(*) 'of all my database table columns?

How about this? number_of_dog_colors = db(db.dog.id>0).count(distinct=True) On 4/19/2012 8:57 PM, Cody Goodman wrote: I have multiple databases: dog --- type color sound car -- model maker condition I need to generate a grid with the table names, then under them the number of colum

[web2py] Re: can't find logging message in gae admin console

> GAE has its own rules for logging, and IIRC doesn't pay attention to the logging configuration. I don't > recall the details, but I haven't been bothering to create a logging.conf > when using GAE. Make sure you're > looking in the right place and at the right version of your app in the GAE d

[web2py] Windows Apache and mod_wsgi: Deny IP?

HI, I need deny visitors by IP address. I change in httpd.conf: Order deny,allow Deny from xxx.xxx.xxx.xxx Allow from all and restart apache server but I do not see it change anything. I have to change how?

[web2py] Re: pure css skins?

I had a look at both Foundation and Bootstrap 2 weeks ago and decided to use Bootstrap (by the way, they're both not pure css). Mainly because I didn't like the styling of Foundation (compare forms, buttons, alerts etc.) and I found their naming conventions, well, awkward: Foundation: ...

[web2py] Re: .represent in case of empty field

Hi Johann and Anthony, Thanks for your replies. Problem solved. Kind regards, Annet.

[web2py] Re: time with no date and vevent

Massimo, The web2py in trunk han applications/welcome/views/generic.ics that makes > the calendar. It contains an example. Add to your table two virtual fields > (start_datetime, stop_datetime) and it should work. > I'll give this solution a try. In my application I have a generic.vcf file, in

[web2py] Re: Postgres expers -- interesting design issue

Cliff By adding the 'null' to the 'purchase_order_id' in the product_lots table, you automatically achieve it - that is, if the field is declared as Null, foreign key constraint is applicable only if it is non-null and a null value will automatically skip validation for foreign key. Another m