[web2py] Re: please help us test new web site

2010-10-09 Thread Richard
nice. Can you explain the meaning behind the new logo? It reminded me of the Eye of Sauron - one Framework to rule them all! On Oct 10, 1:00 pm, Luis Díaz wrote: > very good design! > > I like the irc channel > -- > Díaz Luis > TSU Analisis de Sistemas > Universidad de Carabobo > > http://web2p

[web2py] Re: Any possible problems if I do this? Any possible improvement?

2010-10-09 Thread Richard
> 3) I'd also limit the IP access to the artist's home IP, but his IP will probably be dynamic. Maybe limit the area, I'll see. I've got some apps around the web with the admin exposed and haven't had any problems. Though it probably helps that nothing links to them. Could you modify admin so tha

[web2py] Re: please help us test new web site

2010-10-10 Thread Richard
I like the Django and Symfony logos: http://upload.wikimedia.org/wikipedia/commons/7/75/Django_logo.svg http://upload.wikimedia.org/wikipedia/commons/b/bc/Symfony.gif Straightforward. Richard On Oct 11, 8:24 am, mdipierro wrote: > I was working on it live. Sorry. Fixed now. > > On

[web2py] Re: please help us test new web site

2010-10-10 Thread Richard
forgot to include my point - so how about remove the WP thing and just keep the stylish "web2py" text. On Oct 11, 2:16 pm, Richard wrote: > I like the Django and Symfony > logos:http://upload.wikimedia.org/wikipedia/commons/7/75/Django_logo.svghttp://upload.wikimedia.org/wikipe

[web2py] Re: please help us test new web site

2010-10-11 Thread Richard
s the "holy grail" of web > > > frameworks. And because python is associated with Monty Python, and > > > Monty Python is strongly associated with "Monty Python and the Holy > > > Grail". So make the logo a beautiful chalice. G'nite all. > >

[web2py] Re: please help us test new web site

2010-10-11 Thread Richard
Great - just text - I am happy. I think the new design of the site means the color scheme in (A) is most appropriate. The subtle snake is good. Could you use lowercase letters instead? The .py extension is always lowercase. The color scheme in (B) would have worked great in the previous design.

[web2py] Re: please help us test new web site

2010-10-11 Thread Richard
> WRT C, does "b2p" mean something on its own? It sort of jumps out. http://acronyms.thefreedictionary.com/B2P Business to Partner Beijing to Paris Business to Peer Bridges to Prosperity

[web2py] Key error on GAE - expects numeric

2010-10-13 Thread Richard
I am getting the following error on Google App Engine: File "/base/data/home/apps/test/1.345469538660333403/gluon/contrib/ gql.py", line 752, in select new_item.append(int(item.key().id())) TypeError: int() argument must be a string or a number, not 'NoneType' Seems that web2py expects my ke

[web2py] Re: Packaging web2py for Debian

2010-10-13 Thread Richard
I remember talk about ability to upgrade through admin - is that practical? On Oct 14, 7:29 am, mdipierro wrote: > I feel this will be a maintenance nightmare unless it somehow upgrades > itself. The release process of debian is very slow compared to ours. > > On Oct 13, 3:12 pm, Michele Comitin

[web2py] Re: please help us test new web site

2010-10-13 Thread Richard
hi Tom, I liked the lowercase logo you did: http://susweb.net/images/web2py.gif Are you able to upload a higher quality version for the competition: http://blouweb.com/logovote On Oct 12, 11:09 pm, Tom Atkins wrote: > sorry last post unless anyone would like more. i do miss the web2py orange. >

[web2py] Re: Anyone used WHOOSH as search engine with web2py?

2010-10-14 Thread Richard
is it practical to use this on GAE? On Oct 13, 11:34 pm, selecta wrote: > it's fast, it's pure python (just dump in to web2py/site-packages) and > simple to use > > http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/4387b942c7ab/cont...http://tlc2.hg.sourceforge.net/hgweb/tlc2/tlc2/file/4387b94

[web2py] Re: new-app-engine-sdk

2010-10-16 Thread Richard
can delete all data - neat. On Oct 16, 12:24 pm, mdipierro wrote: > http://googleappengine.blogspot.com/2010/10/new-app-engine-sdk-138-in...

[web2py] Re: Can't install gae remote_api using web2py

2010-10-18 Thread Richard
that "- remote_api: on" option was just added in the latest version. Do you have the latest version of GAE source? You may want to ask these kind of questions in the GAE group: http://groups.google.com/group/google-appengine http://groups.google.com/group/google-appengine-python On Oct 19, 5:21 

[web2py] Re: Instant Press in beta

2010-10-18 Thread Richard
contact form? Richard On Oct 19, 2:09 am, "Martin.Mulone" wrote: > After almost 3 month of heavy development, i think its mature enough > to move to beta phase. Well for me was a proof of concept, of what can > i do in web2py, i have to thank to massimo and the community to &g

[web2py] Re: Instant Press in beta

2010-10-19 Thread Richard
whitespace. Do you have plans for the future? Is this a personal project or for work? Regarding a better method for full text search, is this useful: http://billkatz.com/2009/6/Simple-Full-Text-Search-for-App-Engine Richard

[web2py] Re: Instant Press in beta

2010-10-20 Thread Richard
thanks Martin, will let you know if I get stuck. On Oct 20, 10:56 pm, "Martin.Mulone" wrote: > thanks richard, this a personal project. Google analytic in the next > beta i will add as a widget. I want to do my own implementation of > lightbox, but i have some others prio

[web2py] Re: Google Moderator...

2010-10-20 Thread Richard
would be nice to replace this with a web2py version - the "eat your own dogfood" approach. Perhaps with pystack: http://www.techfuel.net/zblog/blog/view/24 On Oct 20, 1:03 pm, Bruno Rocha wrote: > Nice! > > in web2py site we have a link tohttp://web2py.uservoice.com, which is a > place where ev

[web2py] Re: Supporters of the current logo concept

2010-10-25 Thread Richard
Agreed, lowercase is more appropriate. I suspect that logo was most popular because web2py.com uses it. On Oct 22, 1:52 pm, weheh wrote: > Bruno, thanks for the link. Massimo, please consider that we live in a > case sensitive world. All your branding to date has been lower case > web2py. web2py

[web2py] Re: Pythonn and Yahoo Pipes on Google App Engine

2010-10-25 Thread Richard
My understanding was Yahoo Pipes is good for people with little programming experience, who couldn't scrape the data otherwise. What does it offer to programmers? On Oct 26, 7:35 am, Bruno Rocha wrote: > The amazing Yahoo Pipes now runs on Google App Engine with Python! > > This is a great tool

[web2py] Re: clean up uservoice

2010-10-27 Thread Richard
On Oct 27, 9:49 am, Bruno Rocha wrote: > I think Googlehttp://www.google.com/moderator/should be better for that! what are advantages of Moderator over uservoice?

[web2py] Complete language files

2010-11-02 Thread Richard
I tried enabling Spanish for my website and found many of the strings defined in auth are missing in es-es.py. Are there more complete language files available?

[web2py] Re: GAE GQL count patch

2010-11-04 Thread Richard
my only concern would be timeouts for large tables On Nov 4, 11:39 am, howesc wrote: > Massimo and others, > > Google claims that count() does not have an enforced limit, though > they have mis-documented the feature.   > seehttp://code.google.com/p/googleappengine/issues/detail?id=4001if you >

[web2py] Re: new welcome app in trunk but minor problem...

2010-11-04 Thread Richard
Love the new welcome app design. Instead of developing flash further how about just using jgrowl instead. > It requires downloading 3 more files and the advantages are minimal. I think the advantages are worthwhile and the extra files do not matter if they are stored in sub-folders to avoid clu

[web2py] Re: ISBN database

2010-11-05 Thread Richard
You can find data about a book with an ISBN by querying the Amazon API or using this link format: http://www.amazon.com/FAKE/dp/ I have done this before and have a database of ISBN's - feel free to contact me privately. Richard On Nov 5, 6:39 pm, Kenneth wrote: > Hello list, > &g

[web2py] Re: Countries as Python objects

2010-11-06 Thread Richard
very useful set of data - thanks for sharing On Nov 6, 8:05 am, puercoespin wrote: > sorry, i have a problem with links > > The correcthttp://www.geonames.org > > In download section there are a exhaustive list of regions, cities and > countries. > > On 5 Nov, 22:02, puercoespin wrote: > > >www

[web2py] Re: Interesting developments...

2010-11-06 Thread Richard
no new features in the last 2 years - wow! > * Has a weird lead developer that implements just about any great idea he picks up in the list :) hahaha

[web2py] Re: Routes.py on GAE

2010-11-07 Thread Richard
I was having the same problem with robots.txt on GAE. Thanks for the tip Michael. Does anyone know a better way to do it? On Sep 17, 8:35 am, howesc wrote: > i have no idea myself, and got it working and so that's what i use. > if i ever try and run multiple web2py apps on the same app engine >

[web2py] html mail broken on GAE

2010-11-07 Thread Richard
When trying to send HTML mail on GAE I get: >>> mail.send(message='message') False Mail.send failure:May not set empty value for 'body' >>> mail.send(message=('dummy content', html)) True

[web2py] Re: html mail broken on GAE

2010-11-07 Thread Richard
Seems the problem is GAE expects text to have content, even though it is not used: gluon/tools.py: elif message.strip().startswith(''): text=None html=message I have fixed that by setting text=message On Nov 8, 1:00 am, Richard wrote: > When trying to s

[web2py] Re: twilio context ($100 prize)

2010-11-09 Thread Richard
nice service, and a cost-effective way to get publicity. On Nov 10, 12:50 am, mdipierro wrote: > http://blog.twilio.com/2010/11/attention-pythonistas-twilio-has-a-con...

[web2py:23306] Re: more slides - must read

2009-06-04 Thread Richard
That was great. I hadn't come across those DAL shortcuts before. Who is/was the presentation for? Pg 89 the values in queries and updates can be en expression ^ Pg 121 auto_email.py -> email_auth.py (unless has been updated recen

[web2py:23564] Re: new auth functions in trunk (basic, email/gmail, ldap)

2009-06-07 Thread Richard
ldap_auth? Richard On May 13, 3:01 pm, mdipierro wrote: > Please try this > > 1) to authenticate withgmail > > auth=Auth(globals(),db) > from gluon.contrib.login_methods.email_auth import email_auth > auth.settings.login_methods.append(email_auth()) > &g

[web2py:23622] Re: new auth functions in trunk (basic, email/gmail, ldap)

2009-06-08 Thread Richard
On Jun 8, 1:29 pm, mdipierro wrote: > Hi Richard, > > thegmailauthentication is not based on open-id (yet). it presents > you with a standard login form. It tried to log you in via the normal > auth_user table. It it fails, it tried to verify your password using > thegmailsmt

[web2py:23632] logging approach

2009-06-08 Thread Richard
suggest as alternative? Massimo hinted: "Perhaps there should be a logging command in web2py to avoid the problems with the logging module. " Has there been any development on this? Richard --~--~-~--~~~---~--~~ You received this message because you are subs

[web2py:24270] Re: userstate

2009-06-15 Thread Richard
import time? On Jun 16, 7:11 am, pk wrote: > Traceback (most recent call last): >   File "gluon/restricted.py", line 107, in restricted >   File "/Applications/web2py1.64/web2py.app/Contents/Resources/ > applications/2busy/views/menu/index.html", line 46, in > NameError: name 'time' is not def

[web2py:24312] Re: global logging to file

2009-06-16 Thread Richard
this looks useful - thanks! On Jun 16, 3:53 am, Hans wrote: > Important note: do *not* 'import logging' in your controller if you > use log.py. its done for all your controllers already in the log.py > model and it would break the log.py magic. > > On Jun 15, 7:46 pm, Hans > wrote: > > > Log f

[web2py:24324] Auth autologin after register

2009-06-16 Thread Richard
feature been implemented in the Auth tool? thanks, Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubs

[web2py:24397] Re: Auth autologin after register

2009-06-17 Thread Richard
last_visit=request.now, > > + > > expiration=self.settings.expiration) > > +                self.user = user > > +                session.flash = self.messages.logged_in > >              if log: > >                  self.log_event(log % form.vars) > >        

[web2py:24409] Re: Using jQuery UI ThemeRoller with web2py

2009-06-17 Thread Richard
I'm using one of the prepared themes hosted on Google: http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/smoothness/jquery-ui.css and then overrode some of the rules in Bandwidth isn't a problem for me but it should be faster for the user. Richard On Jun 17, 8:48 pm, glimm

[web2py:24454] reserved database words

2009-06-18 Thread Richard
list of words that are reserved in at least one database? If so, perhaps this could be somehow incorporated into web2py to make switching between databases more seamless. Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:24455] Re: reserved database words

2009-06-18 Thread Richard
I came across a reserved word list for mysql: http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html But it's not complete - the table name 'log' causes an error, but is not in the list. On Jun 19, 11:03 am, Richard wrote: > hi, > > I like to develop my web2py a

[web2py:24473] Re: google page count

2009-06-18 Thread Richard
I get 61,100 On Jun 19, 1:47 pm, mdipierro wrote: > It is just me or > > http://www.google.com/#q=web2py&fp=1&cad=b > > today returns 536,000 vs 50,600 of yesterday and every day before that. --~--~-~--~~~---~--~~ You received this message because you are subscrib

[web2py:24475] Re: reserved database words

2009-06-18 Thread Richard
quotes.  In the latter case, the names may contain reserved > > words, embedded spaces, even non-alphanumeric characters.  I've seen > > code generators that enclose all names in double quotes, whether > > needed or not.  I'm sure that web2py could be patched to do this as >

[web2py:24669] Re: Coming from grails world

2009-06-21 Thread Richard
On Jun 21, 8:11 pm, Daniel Guryca wrote: > Hey, I have just installed apache + web2py + mod_wsgi. > > Now results are very comparable to django results. > Great ! that's a relief! I was getting a worried about web2py performance after reading another thread on performance. > > I'm going to tes

[web2py:24670] Re: A proposal for Auth

2009-06-21 Thread Richard
> Can we get a discount on the updated Lulu version if we previously > bought the original Lulu ebook version? > A one-time deal, maybe?? +1! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" gro

[web2py:24744] Re: Difficulty with mysql migration

2009-06-22 Thread Richard
very useful! On Jun 22, 2:02 am, mdipierro wrote: > yes you can migrate an entire database from the shell with one > command: > > 1) have a model that connects to the sqliite db > 2) python web2py -S yourapp -M > 3) in the shell type > >    db.export_to_csv_file(open('somefile.csv','wb')) > > 4

[web2py:24746] Re: Having an 'upgrade' distribution?

2009-06-22 Thread Richard
My Apache server need to be restarted to reread some updated files (such as imported modules from the controller). Will the auto upgrade take care of this? On Jun 20, 11:13 am, mdipierro wrote: > By the end of july there will be auto upgrade. ;-) > > On Jun 19, 6:43 pm, Eddie Eyles wrote: > >

[web2py:24844] Re: Having an 'upgrade' distribution?

2009-06-23 Thread Richard
ll automatically restart the server. I would hope not! But will the auto upgrade somehow force reloading the modules? > > massimo > > On Jun 22, 7:09 pm, Richard wrote: > > > My Apache server need to be restarted to reread some updated files > > (such as imported modules

[web2py:24937] Re: in trunk RadioWidget, CheckboxWidget

2009-06-24 Thread Richard
neat. On Jun 24, 6:28 am, mdipierro wrote: > or better: > > db.define_table('test',  SQLField('field1'),  SQLField('field2')) > > db.test.field1.requires=IS_IN_SET(('a','b','c')) > db.test.field1.widget = SQLFORM.widgets.radio.widget > > db.test.field2.requires=IS_IN_SET(('a','b','c'),multiple=T

[web2py:24938] Re: global logging to file

2009-06-24 Thread Richard
; > On Jun 17, 5:30 am, Hans > wrote: > > > I'm glad that its useful also to you Richard. > > > Massimo, maybe you want to check if you want it in one of the next > > versions. > > > On Jun 17, 2:23 am, Richard wrote: > > > > this looks

[web2py:25215] Re: upload filename

2009-06-28 Thread Richard
I'd also be interested in this. I want to prepend a timestamp [with strftime('%y%m%d%H%M%S')] to the upload filenames so when I browse them they are in alphabetical order. Richard On Jun 4, 11:51 pm, mdipierro wrote: > I have no objection in taking the code out in a func

[web2py:25220] maintain dictionary state between requests

2009-06-29 Thread Richard
hello, I have a Python dictionary that is unique to each user and takes a rather heavy database query to instantiate. Is there a way to maintain the state of this dictionary between requests? For example, is saving it in the session variable a good idea? thanks, Richard

[web2py:25294] Re: maintain dictionary state between requests

2009-06-29 Thread Richard
obviously have to consider how the session folder is shared between > servers, or make sure the same session is always served by the same > machine. > > On Jun 29, 8:10 am, Richard wrote: > > > hello, > > > I have a Python dictionary that is unique to each user and tak

[web2py:25296] Re: maintain dictionary state between requests

2009-06-29 Thread Richard
data in > > the database, though this has to be enabled). > > > If you scale your application up to more than one server you'll > > obviously have to consider how the session folder is shared between > > servers, or make sure the same session is always served by the same &

[web2py:25659] stacking applications

2009-07-05 Thread Richard
e constant? Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email

[web2py:25740] Re: stacking applications

2009-07-05 Thread Richard
I didn't think so. So what would you recommend. I have a language learning app that I need to customize for a few different languages (more that just strings) but the core is still being developed. On Jul 6, 1:03 am, mdipierro wrote: > No. > > On Jul 5, 7:37 am, Richard wrot

[web2py:25741] Re: How do we petition Google to mention web2py?

2009-07-05 Thread Richard
you could try contacting Guido through his blog: http://neopythonic.blogspot.com/ On Jul 6, 9:52 am, weheh wrote: > What's his email? Send it to me privately if you have it. I'm sure he > gets tons of email, but I'll be happy to compose a brief letter. --~--~-~--~~~

[web2py:25742] Re: Google app and AuthSub

2009-07-05 Thread Richard
there was a thread related to gmail authentication here: http://groups.google.com/group/web2py/browse_thread/thread/5f6a2780a31142f Massimo mentioned that web2py will soon have an API to allow a login form like stackoverflow.com (multiple OpenID providers)! Richard On Jul 3, 5:03 pm, weheh

[web2py:25744] Re: IDEA: account setup for translations by non admins...

2009-07-05 Thread Richard
I've also been wondering how to do this for a language learning app I'm working on. My users wouldn't be comfortable with a raw .po file and I want to avoid the extra dependencies of something external like pootle. Has anyone else made public translations possible in a web2py app

[web2py:26079] Re: Web2py vs the world

2009-07-09 Thread Richard
years old' that would be great! Would we be able to select on db.person.age? eg: db(db.person.age >= 18).select() Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. T

[web2py:26530] appadmin like interface with CRUD?

2009-07-14 Thread Richard
this means I have some duplicate code for each table. Is there a better way? Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email

[web2py:26549] Re: appadmin like interface with CRUD?

2009-07-14 Thread Richard
Delete {{ pass }} Add new Is there some way to automate this with CRUD? Richard On Jul 15, 2:18 pm, mdipierro wrote: > Have you tried exposing the action > >     def data(): return dict(form=crud()) > > It is not quite a full appadmin because we have a crud.select but n

[web2py:26551] multiple uploads

2009-07-15 Thread Richard
hello, the current database design of our application will require the user to upload 2 files in a single form. Is there any problem with this? One thing I thought of is we could no longer determine the size of the file with request.env.content_length. Richard

[web2py:26616] Re: Is there a way to place apps in a separate directory from the "applications" directory?

2009-07-15 Thread Richard
whoops - this was just reported in another thread! On Jul 16, 8:49 am, Richard wrote: > a note on upgrading:> python web2py.py -h > > ... > -u UPGRADE, --upgrade=UPGRADE                        upgrade > applications > > The doc string says --upgrade=UPGRADE but this doe

[web2py:26615] Re: Is there a way to place apps in a separate directory from the "applications" directory?

2009-07-15 Thread Richard
a note on upgrading: > python web2py.py -h ... -u UPGRADE, --upgrade=UPGRADEupgrade applications The doc string says --upgrade=UPGRADE but this doesn't work. You have to use --upgrade=yes. Richard On May 28, 11:45 pm, mdipierro wrote: > If you unzip new web2

[web2py:26618] Re: multiple uploads

2009-07-15 Thread Richard
hello, I want to store the actual length of each uploaded file in my table. I've seen around the forum people using request.env.content_length for that. Is there an alternative interface to that information? Richard On Jul 15, 11:44 pm, mdipierro wrote: > No there s no problem with t

[web2py:26628] Re: multiple uploads

2009-07-15 Thread Richard
27;,Field('data','upload'),Field > ('size','integer')) > > def store_size(form): >     request.vars.image.file.seek(0) >     form.vars.size=len(request.vars.image.file.read()) > > form=SQLFORM(db.image) > form.accept(request.vars,session,on

[web2py:26630] Re: multiple uploads

2009-07-15 Thread Richard
thanks Jonathan! On Jul 16, 4:03 pm, Jonathan Lundell wrote: > On Jul 15, 2009, at 9:46 PM, mdipierro wrote: > > > This should do it but I have not tried it > > > db.define_table('image',Field('data','upload'),Field > > ('size','integer')) > > > def store_size(form): > >    request.vars.image.f

[web2py:26688] breadcrumb design

2009-07-16 Thread Richard
;View'] And then the base view uses this to generate the links. However this creates a lot of redundancy for deep links. I remember in Django they use inheritance chains to build up the breadcrumbs to avoid this redundancy. Is there a way to do something

[web2py:27996] Re: Fwd: My thoughts on web2py

2009-08-04 Thread Richard
uld certainly set back the pace of development. And I also don't feel development is significantly constrained by backwards compatibility. Maintaining backwards compatibility is one of the core advantages of web2py that attracted me to it. Richard On Aug 5, 4:30 am, Pynthon wrote: > Yeah maybe

[web2py:27997] Re: How to properly remove a user in Auth.

2009-08-04 Thread Richard
another issue I came across is that the deleted user can stay logged in with their previous session cookie. Is there an efficient way to get around this? Richard On Jul 19, 5:33 pm, Hans Donner wrote: > Keep in mind if you reference to this user in other tables as well > (your apps).

[web2py:27998] Re: breadcrumb design

2009-08-04 Thread Richard
On Jul 17, 10:52 am, Alex Fanjul wrote: > I agree with you Richard, > In deed, in statusbar there is already a "kind of breadcrumb" but > wihtout links... > > A vote for this inbuild functionallity... > Otherwise, I bet that someone has a quick and simple idea to do

[web2py:28075] Re: Fwd: My thoughts on web2py

2009-08-05 Thread Richard
of > concept. I have a number of private apps at my work place that I don't want to redebug next time I upgrade. Some of these apps were written a year ago and still work with the current web2py version. What is the show stopping feature that requires breaking backward compatibility? Richa

[web2py:28132] Re: session forgetMeNot

2009-08-06 Thread Richard
try auth.settings.expiration = X On Aug 7, 2:35 pm, rb wrote: > Section 4.8 from the Web2py Manual states that session data remains > until/unless the user deletes the session cookie or else the session > expires. When does a session expire - or what causes a session to > expire? Do I have any

[web2py:28147] Re: breadcrumb design

2009-08-07 Thread Richard
equest.controller), _href=URL (r=request, c=request.controller, f='index'))) if request.function == 'index': # are at root of controller menus[-1] = pretty(request.controller) else: # are at function within controller menus.append(pretty(request.functi

[web2py:28283] Re: feature request: activate the feature request template

2009-08-09 Thread Richard
This would be a good idea because a lot of feature requests get lost in the traffic of this forum. Has it been activated yet? I didn't notice a feature request link on the web2py google code page. Richard On Jul 31, 11:04 am, "Sebastian E. Ovide" wrote: > Hi All > >

[web2py:28289] multiple joins to the same table

2009-08-10 Thread Richard
the ice creams with the name of each flavour. Note that sometimes the ice cream will have just 1 flavor so f2 will not be set. How would I do this in a single query? thanks, Richard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Go

[web2py:28290] Re: New book. Chapters 6,7,8 again

2009-08-10 Thread Richard
- p217: Mail(globals()) -> Mail() On Jul 13, 5:17 am, Vidul wrote: > Thank you, Massimo, that's the most reliable forum on this planet (no > irony)! > > On Jul 12, 5:32 pm, mdipierro wrote: > > > Book ERRATA: > > > def give_create_permission(form): > >     group_id=auth.id_group('user_%s' % >

[web2py:28323] Re: feature request: activate the feature request template

2009-08-10 Thread Richard
ow. With a feature tracker I could easily determine the status. Richard On Aug 10, 4:49 pm, Yarko Tymciurak wrote: > BTW - can you name _one_ feature request that has been "lost"? > > I think this is probably a non-issue, as important requests will not be > forgotten (and unim

[web2py:28324] Re: multiple joins to the same table

2009-08-10 Thread Richard
thanks! - I forgot about that trick On Aug 11, 4:44 am, DenesL wrote: > fla1=db.flavor.with_alias('fla1') > fla2=db.flavor.with_alias('fla2') > r=db().select(db.ice_cream.id,fla1.name,fla2.name, >   left=[fla1.on(db.ice_cream.f1==fla1.id), >         fla2.on(db.ice_cream.f2==fla2.id)]) --~--~---

[web2py:28340] Re: feature request: activate the feature request template

2009-08-11 Thread Richard
On Aug 11, 5:17 pm, mdipierro wrote: > Thank you Richard, > some comments below. > > On Aug 10, 7:21 pm, Richard wrote: > > > hello, > > > > You know that currently the main repository is on launchpad.net? > > > Currently the Google Code page says "

[web2py:28385] Re: feature request: activate the feature request template

2009-08-11 Thread Richard
I was referring to the stackoverflow like OpenID login app is. Where can I find it? On Aug 11, 10:27 pm, mdipierro wrote: > On Aug 11, 6:41 am, Richard wrote: > > > > > On Aug 11, 5:17 pm, mdipierro wrote: > > > > Thank you Richard, > > > some com

[web2py:28398] Re: feature request: activate the feature request template

2009-08-12 Thread Richard
o if you were waiting on Mecurial support for Google Code do you plan to migrate now? > On Aug 11, 6:55 pm, Richard wrote: > > > I was referring to the stackoverflow like OpenID login app is. Where > > can I find it? > > > On Aug 11, 10:27 pm, mdipierro wrote: >

[web2py:28405] sqlite cascade support?

2009-08-12 Thread Richard
hello, Does sqlite support cascade or am I doing something wrong? I have these tables: db.define_table('A', db.Field('B', db.B, ondelete='CASCADE'), ) db.define_table('B', db.Field('name'), ) And when I run db(db.A.i

[web2py:28454] Re: sqlite cascade support?

2009-08-12 Thread Richard
hmm, that's a pity. Thanks for the link. Is there a single query that could delete all my A's and B's? Or do I need to iterate through the A's and remove them all manually? Richard On Aug 12, 5:52 pm, Yarko Tymciurak wrote: > It apprears that sqlite does not su

[web2py:28463] Re: sqlite cascade support?

2009-08-12 Thread Richard
ve them all manually? Richard On Aug 13, 5:47 am, Yarko Tymciurak wrote: > If you must use sqlite, then google for sqlite cascade - there are C program > files that will convert your SQL to sqlite triggers which will accomplish > this (according to all that I saw - I have no experience

[web2py:28464] Re: def download(): slow

2009-08-12 Thread Richard
hmm that's interesting. I should probably be doing that too. What is the recommended way to serve static binary data in web2py? Like the above example? Or perhaps directly through Apache? Richard On Aug 13, 5:53 am, hcvst wrote: > FIXED > > Hi, > > I've now changed

[web2py:28465] Re: Web2py.com down

2009-08-12 Thread Richard
I can't access www.web2py.com at the moment and have experienced intermittent downtime. On Aug 8, 2:33 pm, b00m_chef wrote: > Just tried to accessweb2py.com and was not up. > > Tried using a proxy (guardster), same result. --~--~-~--~~~---~--~~ You received this

[web2py:28470] Re: Difficulty with mysql migration

2009-08-12 Thread Richard
>db.import_from_csv_file(open('somefile.csv','rb')) don't forget you need a db.commit() after importing. On Jun 22, 2:02 am, mdipierro wrote: > yes you can migrate an entire database from the shell with one > command: > > 1) have a model that connects to the sqliite db > 2) python web2py -S

[web2py:28475] Re: sqlite cascade support?

2009-08-12 Thread Richard
ybe it will be practical to migrate over night. I had a try just now with db.export_to_csv_file() / db.import_from_csv_file() and after fixing some reserved keywords and NULL references, managed to import. Yarko, I read you migrated the live Pycon database, so do you have any tips? Richard On Aug

[web2py:28476] Re: Left Join Failures

2009-08-12 Thread Richard
hi Christian, I also just got this error message when testing a migration from sqlite to postgres. Thanks for the diagnosis of the problem. Have you found a work around yet using the DAL? Richard On Aug 10, 4:56 pm, howesc wrote: > This is in Postgres. > > I did a little dig

[web2py:28477] Re: current link indication with MENU() helper

2009-08-12 Thread Richard
Maybe add it to the issue tracker: http://code.google.com/p/web2py/issues/list On Aug 13, 11:57 am, ionel wrote: > Massimo, > > When will we have this feature added into menu helper? I really need > this... > > Thanks. > > On Jun 17, 12:13 pm, mdipierro wrote: > > > Sorry, this needs to be add

[web2py:28564] Re: logo

2009-08-13 Thread Richard
A - globes are too common On Aug 14, 2:29 am, Massimo Di Pierro wrote: > Two logos have been proposed for web2py. I love them both and I would   > like your opinions. Here they are attached. > > Which one should go on the main web2py page and the book? > > Vote A for the logo with the W and B f

[web2py:28578] Re: Simple question -- where is name of upload file stored?

2009-08-13 Thread Richard
of server db.media.insert(current_filename=filename, original_filename=request.vars.media.filename, size=size) That is what I currently use - please tell me if there is a better way. Richard On Aug 14, 2:58 pm, weheh wrote: > I want to open the uploaded file, parse it, and then delete it. But &

[web2py:28579] Re: current link indication with MENU() helper

2009-08-13 Thread Richard
to override layout.html and assign a different css class when > a menu link is active. I did not put it in layout.html and menu.py to > keep is leaner and easier to read. > > On Aug 12, 9:25 pm, Richard wrote: > > > Maybe add it to the issue > > tracker:http://code.google.com/p/web

[web2py:28581] Re: logo

2009-08-13 Thread Richard
> the python logo is a registered trademark, and copyrighted if the python snake was included somehow there wouldn't be a legal problem. Scipy does this: http://www.scipy.org/images/scipylogo.gif On Aug 14, 2:41 pm, Yarko Tymciurak wrote: > the python logo is a registered trademark, and cop

[web2py:28588] Re: logo

2009-08-13 Thread Richard
svg > > On Fri, Aug 14, 2009 at 12:30 AM, Richard wrote: > > > > the python logo is a registered trademark, and copyrighted > > if the python snake was included somehow there wouldn't be a legal > > problem. Scipy does this:http://www.scipy.org/images/scipy

[web2py:28589] Re: Simple question -- where is name of upload file stored?

2009-08-13 Thread Richard
On Aug 14, 3:10 pm, Yarko Tymciurak wrote: > try form.vars.filename.new_filename > > the pattern is: > > form.vars..new_filename are you sure about that? I've been accessing form.vars..filename instead > On Thu, Aug 13, 2009 at 11:58 PM, weheh wrote: > > > I want to open the uploaded file, p

[web2py:28591] Re: Where to specify logout time

2009-08-14 Thread Richard
I believe it is: auth.settings.expiration = SECONDS Richard On Aug 14, 3:29 pm, weheh wrote: > I know I saw this written somewhere, maybe in some doc, maybe in some > sample code, but I can't find it again for the life of me. Where/how > do I specify the amount of time befo

[web2py:28602] login to web2py application with script

2009-08-14 Thread Richard
2.Request(login_url, post_data) response = opener.open(request) Some thoughts: - is a formkey necessary, and does it need to be unique? - do I need to use multipart encoded data? (which Python's builtin libraries do not support) thanks, Richard --~--~-~--~~~---~--~--

<    1   2   3   4   5   6   7   8   9   10   >