[web2py] Re: Support for MS Access?

I don't understand : how, with a "DAL('mssql: ...')", will pyodbc send the good connection string to tSQLDriverConnect for MS Access databases ? May you give an example of DAL connection string for connect to a 'mybase.mdb' Access database ? On 17 mar, 00:34, DenesL wrote: > There is no DAL('msac

[web2py] Re: Proposals for New Tagline

I think the most important point is to get developers to try it. What could achieve that? Grab their attention and inspire them to install it. Why not 'sell' it like any other product using a tried and tested formula. The byline leads into the marketing to make a compelling case for any develop

[web2py] Re: return xml list

SQLTABLE truncates at around 16 chars by default. Here is an example to change that value to 100 in a view (this was obtained from the book, for further details go there). {{extend 'layout.html'}} Records {{=SQLTABLE(db().select(db.person.ALL), headers='fieldname:capitalize', truncate=100, upload=

[web2py] Re: Lacking nginx deployment guide

pbreit, I tried to follow the Linode recipe along with your instructions, but could not succeed. There were points were I really did not know what changes are needed to be made. For example: in '/etc/init.d/uwsgi' should the owner be uwsgi or www-data? in /etc/default/uwsgi, should the 'MODULE=wsg

[web2py] Re: Lacking nginx deployment guide

pbreit, please ignore my last post. Actually I could make nginx+uwsgi up and running by reading carefully your posts above. I have sum up the instructions here: http://stackoverflow.com/questions/5335153/how-to-deply-web2py-using-nginx Thank you so much for your help.

Re: [web2py] Re: Support for MS Access?

I guess you need a DSN or ODBC connection pointing to ms access db. Em 17/03/2011, às 06:04, Philnext escreveu: > I don't understand : how, with a "DAL('mssql: ...')", will pyodbc send > the good connection string to tSQLDriverConnect for MS Access > databases ? > May you give an example of DA

[web2py] Re: Support for MS Access?

It depends on how you want to connect. The current mssql driver supports DSN connections: mssql://the_dsn If you plan to use a different connection method please provide examples to be able to code in the appropriate changes in the source. References that might be useful: http://code.google.com/

[web2py] Re: Proposals for New Tagline

> IMNSHO, "Productivity by Design" sucks. > > It is vague, wishy-washy, and banal.  It could be said of every web > development tool from Apache to Zope.  It fails to capture any of > web2py's essential advantages. I disagree. I think it speaks to the very thing that sets web2py apart from every

[web2py] a little proposal for interface

I develop app under web2py and now I have a big list of views (40+) like: shop/global_sections.html extends adminpanel.html shop/index.html extends adminpanel.html shop/verify_accounts.html extends adminpanel.html shop/verify_shops.html extends adminpanel.html It's about 4-5 functions

[web2py] Re: Proposals for New Tagline

for me web2py is "Easy and Power" :)

[web2py] Re: a little proposal for interface

Good idea. I would take a patch to do that. On Mar 17, 8:46 am, LightOfMooN wrote: > I develop app under web2py and now I have a big list of views (40+) > like: > >    shop/global_sections.html extends adminpanel.html >    shop/index.html extends adminpanel.html >    shop/verify_accounts.html ext

[web2py] [snippet] Unit test and auth.has_membership or auth.requires_login

Hi everybody, First of all, thank you Massimo for your great framework and thanks to all the community who helped me much by posting answers and snippets to AlterEgo, the wiki or on the group. I've spent quite a time (sorry i am quite a beginner) for my Unit test to work because my controller che

[web2py] [problem][trunk] @auth.requires

@auth.requires(auth.has_membership(role='Admin')) def index(): return dict() No longer redirect to login page, instead show not authorized message. This only happen in trunk. -- Pablo Martín Mulone (mar...@tecnodoc.com.ar) http://www.tecnodoc.com.ar/ My blog: http://martin.tecnodoc.com.ar E

[web2py] Re: More WebSocket inquiries

On Mar 16, 4:06 pm, rochacbruno wrote: > There is a workaround using flash to enable cross browser support. Are any of those included presently? And, if so, which ones are compatible with the included tornado client? socket.io seems to claim it needs a special backend, but I would imagine ther

[web2py] Re: upload an excel sheet to be added to the system

Microsoft Excel .xls format (as well as the others) saves its files out in custom binary formats. It is very difficult to import them unless you have a way of decoding the binary format. Using csv, you can easily set up auto-importers (as long as the csv data-structure is fairly static). This is a

[web2py] Re: Unit test and auth.has_membership or auth.requires_login

PPS : sorry, i was not using test_db (was commented) and cannot use it right now cause you need to (re)define auth - so you have another useless user in your dev db

[web2py] Re: Major Speedup in trunk 10x

In the book under "Efficiency Tricks" it says: Set session.forget() in all controllers and/or functions that do not change the session. Does this new change make it unnecessary to bother calling session.forget() in most cases because sessions are no longer saved when empty or not modified?

[web2py] Best practice

Hi, I am new to web2py and am developing a GPL application which I plan to deploy in Google App Engine. >From my reading there appear to be at least 4 ways of building the web pages to maintain the application data: - writing individual controllers and views - using the CRUD tools - using the Wi

Re: [web2py] Re: Major Speedup in trunk 10x

On Mar 17, 2011, at 7:40 AM, Anthony wrote: > In the book under "Efficiency Tricks" it says: > > Set session.forget() in all controllers and/or functions that do not change > the session. > > Does this new change make it unnecessary to bother calling session.forget() > in most cases because s

Re: [web2py] [problem][trunk] @auth.requires

On Mar 17, 2011, at 7:29 AM, Martín Mulone wrote: > @auth.requires(auth.has_membership(role='Admin')) > def index(): > return dict() > > No longer redirect to login page, instead show not authorized message. This > only happen in trunk. > The two lines marked below were removed when Ma

Re: [web2py] Re: nginx with bultin uwsgi module

> > You can find web2py configuration example here: > > http://projects.unbit.it/uwsgi/wiki/Example#Web2Py2uWSGI > > I tried uwsgi + nginx + web2py and got everything working, including https, except for access to web2py administrative interface which is refused because - error message - the passw

[web2py] Re: Problem with list:reference

thanks for the solution it worked. but in doc here it asks to use the queried object directly? doesn't that way work?

[web2py] Re: Best practice

Hi Dave You should obtain experience with individual controllers and views. The book is well ordered to take you through the learning curve. Try to get to the point where you feel confident about what's going on before moving down the list. The Crud is ideal for fast prototyping and quick apps f

[web2py] Re: [problem][trunk] @auth.requires

I considered this a bug fix but I am open to discussion. This @auth.requires(auth.has_membership(role='Admin')) should have been @auth.requires_membership(role='Admin') OR @auth.requires(auth.user and auth.has_membership(role='Admin')) Before @auth.requires(...) was assuming a logged-in us

[web2py] Re: Problem with list:reference

You can use a nested select but it requires _select(db.table.field). You cannot pass a record as returned by .first() On Mar 17, 11:26 am, goutham v wrote: > thanks for the solution it worked. > but in doc > here > it

[web2py] web2py 1.94.1 is OUT

give it a try: ## 1.94.1 - moderniz 1.17 - web2py no longer saves session if no change, this makes it up up to 10x faster for simple actions - experimental REST API - better support for MSSQL NOT NULL - small bug fixes

Re: [web2py] Re: Major Speedup in trunk 10x

On Thursday, March 17, 2011 11:17:17 AM UTC-4, Jonathan Lundell wrote: > > On Mar 17, 2011, at 7:40 AM, Anthony wrote: > > In the book under "Efficiency Tricks" it says: > > Set session.forget() in all controllers and/or functions that do not > change the session. > > Does this new change m

Re: [web2py] Re: [problem][trunk] @auth.requires

The problem was that I remove the others conditions (to make it more basic), this is the code that brings the fail: @auth.requires(auth.has_membership(role='Admin') or \ auth.has_membership(role='Soporte') or \ auth.has_membership(role='Consulta_Soporte') or \

[web2py] Re: [problem][trunk] @auth.requires

for example auth.requires(request.ajax) you can do @auth.requires(auth.user and (auth.has_membership(role='Admin') or \ auth.has_membership(role='Soporte') or \ auth.has_membership(role='Consulta_Soporte') or \ auth.has_membership(role='Consulta_Clien

Re: [web2py] Re: [problem][trunk] @auth.requires

I currently developing this application this why this problem came :P. So I can make the proper changes. Also have to make the proper changes to http://web2py.com/book/default/chapter/08#Combining-Requirements 2011/3/17 Massimo Di Pierro > for example > > auth.requires(request.ajax) > > you can

Re: [web2py] Re: Major Speedup in trunk 10x

On Mar 17, 2011, at 9:45 AM, Anthony wrote: > On Thursday, March 17, 2011 11:17:17 AM UTC-4, Jonathan Lundell wrote: > On Mar 17, 2011, at 7:40 AM, Anthony wrote: >> In the book under "Efficiency Tricks" it says: >> >> Set session.forget() in all controllers and/or functions that do not change >

[web2py] Re: new features and new book sections/chapters

I think we should have a section displaying which all features of DAL are currently not supported on GAE and what are the alternative ways of achieving them.

[web2py] Re: [problem][trunk] @auth.requires

Hmmm... that is in the book...I will revert the changes. Massimo On Mar 17, 12:10 pm, Martín Mulone wrote: > I currently developing this application this why this problem came :P. So I > can make the proper changes. Also have to make the proper changes > tohttp://web2py.com/book/default/chapter

Re: [web2py] Re: Major Speedup in trunk 10x

Thanks. This is helpful. On Thursday, March 17, 2011 1:14:22 PM UTC-4, Jonathan Lundell wrote: > On Mar 17, 2011, at 9:45 AM, Anthony wrote: > > On Thursday, March 17, 2011 11:17:17 AM UTC-4, Jonathan Lundell wrote: >> >> On Mar 17, 2011, at 7:40 AM, Anthony wrote: >> >> In the book under "Eff

Re: [web2py] Re: nginx with bultin uwsgi module

you need a parameters_9001.py file, you can create one by running web2py on localhost I renamed parameters_8000.py to parameters_#mypoort.py

Re: [web2py] Re: Major Speedup in trunk 10x

On Mar 17, 2011, at 10:44 AM, Anthony wrote: > Thanks. This is helpful. > > On Thursday, March 17, 2011 1:14:22 PM UTC-4, Jonathan Lundell wrote: > On Mar 17, 2011, at 9:45 AM, Anthony wrote: >> On Thursday, March 17, 2011 11:17:17 AM UTC-4, Jonathan Lundell wrote: >> On Mar 17, 2011, at 7:40 AM,

[web2py] Re: [problem][trunk] @auth.requires

I have reverted this behavior in 1.94.2. Massimo On Mar 17, 12:10 pm, Martín Mulone wrote: > I currently developing this application this why this problem came :P. So I > can make the proper changes. Also have to make the proper changes > tohttp://web2py.com/book/default/chapter/08#Combining-Re

[web2py] Re: nginx with bultin uwsgi module

Currently I have apache, wsgi set up. But I would very like to try this. Do we have a slide (guide) for this set up? Thanks.

Re: [web2py] Re: Best practice

David, Thanks for the advice. Makes sense to me am working through the book at present. Patience not my strongest point :-) Dave -- Dave Warnock: http://42.blogs.warnock.me.uk Cycling Blog: http://42bikes.warnock.me.uk

[web2py] web2py applications and version control systems

Hi, Do people generally start version control at web2py/applications/myapp or at web2py? If an application is to be deployed on gae then shouldn't some files in web2py be considered part of the project (index.yaml, app.yaml) and therefore under version control? Yet I would prefer not to have the

[web2py] Re: nginx with bultin uwsgi module

On 17 Mar, 18:47, Vasile Ermicioi wrote: > you need a parameters_9001.py file, you can create one by running web2py on > localhost > I renamed parameters_8000.py to parameters_#mypoort.py Thanks for the hint, tried it and it didn't work. Very strange

Re: [web2py] Re: Proposals for New Tagline

It's nice to see people are getting my point of the tag-line. To me it's simple to the point and brings all goals of the product together in a few words. So many things, to many to tag line, are made for our productivity. It scratches more itches in web development than others. BR, Jason On 03

[web2py] Re: nginx with bultin uwsgi module

I just copied my parameters_8000.py to parameters_443.py I think it needs to be 443 since that's the https port. So: web2py$ cp parameters_8000.py parameters_443.py

[web2py] Re: web2py applications and version control systems

I hg clone web2py and then set up a second repository for my app. So I can update web2py and my app independently.

[web2py] Re: web2py 1.94.1 is OUT

moder..what? On Mar 17, 6:41 pm, Massimo Di Pierro wrote: > give it a try: > > ## 1.94.1 > - moderniz 1.17 > - web2py no longer saves session if no change, this makes it up up to > 10x faster for simple actions > - experimental REST API > - better support for MSSQL NOT NULL > - small bug fixes

[web2py] Re: web2py 1.94.1 is OUT

On Mar 17, 7:19 pm, guruyaya wrote: > moder..what? http://www.modernizr.com/

[web2py] Re: web2py 1.94.1 is OUT

Did I miss an r? It is used by the scaffolding app. On Mar 17, 2:43 pm, villas wrote: > On Mar 17, 7:19 pm, guruyaya wrote: > > > moder..what? > > http://www.modernizr.com/

Re: [web2py] Re: web2py 1.94.1 is OUT

+1 Díaz Luis http://www.facebook.com/diazluis2007 TSU Analisis de Sistemas Universidad de Carabobo Facultad de Odontología 2011/3/17 villas > On Mar 17, 7:19 pm, guruyaya wrote: > > moder..what? >

[web2py] Re: video about new RESTful APIs

This is now in trunk. Some API changes are still possible. Right now it supports fiels of type, id, integer, double, date, datetime, time, boolean, reference, list and string fields with "slug" in the name. If you have a model like this db.define_table('person',Field('name'),Field('birthdate','d

Re: [web2py] Re: video about new RESTful APIs

For clarification; This gets put in the model code not controller code correct? So for example in "db.py" Thanks. On 3/17/11 3:58 PM, Massimo Di Pierro wrote: This is now in trunk. Some API changes are still possible. Right now it supports fiels of type, id, integer, double, date, datetime

[web2py] Re: web2py 1.94.1 is OUT

If you have 1.94.1 or 1.94.2 please download 1.94.3 since the former two had a major bug (no redirection on pages that require login). On Mar 17, 2:46 pm, Luis Díaz wrote: > +1 > Díaz Luishttp://www.facebook.com/diazluis2007 > TSU Analisis de Sistemas > Universidad de Carabobo > Facultad de > Od

[web2py] Re: video about new RESTful APIs

No. This is an action @request.restful() def api(): def GET(*args,**vars): parsed = db.parse_as_rest('auto',args,vars) if parsed.status==200: return dict(content=parsed.response) raise HTTP(parsed.status,parsed.error) return locals() ix exposes the APIs so it goes

[web2py] Re: Proposals for New Tagline

I like this bue we do not need "and". We could just go for "Easy, Powerful, Secure" On Mar 17, 8:50 am, LightOfMooN wrote: > for me web2py is > "Easy and Power" :)

[web2py] Re: index.yaml not automatically generated in GAE SDK

Thanks for responding. I seem to have data persistence now whether I use the datastore_path parameter or not (!?) However, I still can't get the index.yaml generated. I have tried creating an index.yaml as described and put this in my ../web2py folder where the app.yaml and queue.yaml files alread

[web2py] get vars from view to my def

Hi there! I need a hint of how to get variable value from view to my function in controller. My code in controller: *** * def work(): *row=db.executesql('SELECT * FROM autos WHERE autos.id=20') *

[web2py] Re: index.yaml not automatically generated in GAE SDK

It should be created by dev_appserver when you run the queries. Each query will add to the file the index it needs. On Mar 17, 3:44 pm, Richard wrote: > Thanks for responding. I seem to have data persistence now whether I > use the datastore_path parameter or not (!?) > > However, I still can't g

[web2py] Re: get vars from view to my def

My code in controller: *** * def work(): *row=db(db.autos.id==20).select() < can be done with DAL *return dict(row=row) **

[web2py] Re: video about new RESTful APIs

SWEET! I'm not even going to bother fixing the mess I made :) This looks awesome! I'll be spending a good chunk of time on this later this evening and will post results/feedback and anything else you'd like to see or have me test. Thanks Mart :) On Mar 17, 4:26 pm, Massimo Di Pierro wrote: > N

[web2py] Re: index.yaml not automatically generated in GAE SDK

without the datastore_path parameter i was getting un-predictable results for retaining data, so i have made the habit of using it. just what i do... keep in mind that not every type of query needs an index, if the updated time on the file is incrementing then the dev_appserver probably is find

[web2py] Re: video about new RESTful APIs

I was confused by this as well. In the message above, I think "simply add this to your model" should read "simply add this to your *controller*" which of course makes much more sense. On Mar 17, 4:05 pm, "David J." wrote: > For clarification; This gets put in the model code not controller cod

[web2py] Re: gae RFC

I use GAE a lot, and the thing that worries me about bundling with web2py is that when GAE updates they detect that your dev_appserver.py and appcfg.py are running an out of date version. so far they don't stop you from running the old version but they could. I would not want web2py to be brok

[web2py] Re: web2py applications and version control systems

i have full web2py in source control for my clients. this is so that at any time they can go back to a version of both my application and web2py that was running on their server. it does make web2py upgrades a little trickier, but i think it is worth it from the code history/stability standpo

[web2py] Reverse order of changelog

With today's new release I checked the changelog and noticed that the most recent entires are still at the bottom of the page. There was a thread a couple weeks ago where Nik Go submitted a reversed changelog, which I find more readable: http://groups.google.com/group/web2py/browse_thread/thread/

[web2py] Re: video about new RESTful APIs

downloaded the version 1.94.3, and included the api in the controller. it responds well, but returns only the field names. when i include the field name, then it returns: record not found as far as I checked, the record with the same id is in the database...

[web2py] Re: index.yaml not automatically generated in GAE SDK

Thanks again for the comments. I have come to the conclusion that maybe no queries I am using actually require an index. I thought that this might trigger an index.yaml entry: records=db().select(db.tasks.ALL, orderby=db.tasks.owner) other than this I just have basic add task and update task form

[web2py] Re: Reverse order of changelog

things that come out of builds (like log, reports, source control data, etc) has always, and I suspect will always be a matter opinion (string stringer than other). For example, over the years I tried many (way too many) ways to present build data: flat text file, html, xml + xslt, flash/flex, et

[web2py] Re: gae RFC

This is an excellent point. On Mar 17, 4:33 pm, howesc wrote: > I use GAE a lot, and the thing that worries me about bundling with web2py is > that when GAE updates they detect that your dev_appserver.py and appcfg.py > are running an out of date version.  so far they don't stop you from running

[web2py] Re: video about new RESTful APIs

Please access the /patterns url, tell me which pattern you are suing and what url you are visiting. On Mar 17, 5:02 pm, Adnan Smajlovic wrote: > downloaded the version 1.94.3, and included the api in the controller. > > it responds well, but returns only the field names. when i include the field

Re: [web2py] Re: gae RFC

What about implements it as a plugin as Jonathan said? It's a good idea and we don't have to download the extra 7Mb. On Fri, Mar 18, 2011 at 12:35 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This is an excellent point. > > On Mar 17, 4:33 pm, howesc wrote: > > I use GAE a lot,

[web2py] Re: Proposals for New Tagline

Mike -- I think if we are creating a tagline to differentiate web2py vs. django, we've already lost sight of the bigger war. As I said in my (deliberately provocative) statement, every web framework ever created could claim "productivity" by the inherent "design" of the framework. There's nothin

[web2py] book "bugs"

In Validator section of Chapter 7, the example for IS_DATE_IN_RANGE incorrectly uses IS_DATETIME where IS_DATE_IN_RANGE is expected: requires = IS_DATE(format=T('%Y-%m-%d'), minimum=datetime.date(2008,1,1), maximum=datetime.date(2009,12,31),

[web2py] Re: video about new RESTful APIs

My apology. Tested again after seeing the patterns, and all works perfect, and as expected...

[web2py] Re: advanced form question

Yes. Try the IN_DB validators to tie them together. Search for "autopostback" by Bruno and go through its code. On Mar 14, 10:30 pm, Manuele Pesenti wrote: > Il 09/03/2011 04:44, DenesL ha scritto: > > > That is called cascaded fields. > > One example:http://groups.google.com/group/web2py/msg/b2

[web2py] Re: Proposals for New Tagline

>> does it excite me or tempt me to try it. +1 Joe I really think the tagline should lead people into the idea of trying the framework. For instance, to use Joe's example, 'A complete framework and webserver on a stick', might intrigue me enough to try it. As marketeers we were always taught '

[web2py] Re: Proposals for New Tagline

I think the essence of web2py can be summarized in one word: Pragmatic. Many design decisions and advantages of web2py can be traced to this word. Web2py ignores typical design patterns of python frameworks to come up with something quite unique. This word justifies the existence of web2py in th

[web2py] Re: book "bugs"

Hi niknok I have recently been editing the book (prompted by the suggestions of Kevin Ivarsen). You may find that these issues have been resolved. Please take a look (at the online version) and let me know if this section is still not correct. http://web2py.com/book/default/chapter/07#Validator

[web2py] Re: gae RFC

In the end the GAE SDK is a python module. We could just have a web2py admin button to download the latest one form the official repository. On Mar 17, 6:38 pm, Albert Abril wrote: > What about implements it as a plugin as Jonathan said? > It's a good idea and we don't have to download the extra

[web2py] Possible error in GAE

In web2py trunk, the decorador "@auth.requires_login()" has stopped working in the GAE environment, the following text is displayed in the browser: " *False Status: 303 SEE OTHER Set-Cookie: session_id_test="61:7588614f-6f94-48ba-b87b-80c20d7d27f2"; Path=/ Content-Type: text/html; charset=UTF-8

[web2py] Re: Proposals for New Tagline

Is "rapid development that scales" still on the table?

[web2py] Re: Possible error in GAE

Grrr. Thank you Lucas and sorry for the mess. I fixed it as you suggested in 1.94.4. On Mar 17, 8:47 pm, "Lucas D'Avila" wrote: > In web2py trunk, the decorador "@auth.requires_login()" has stopped working > in the GAE environment, the following text is displayed in the browser: > > " > > *False