[web2py] executesql for Nosql engine

Hi! What's the right way to ask to a NoSQL engine like mongodb if a table/database already exists? Can I obtain from my db (a DAL object) or their adaper/connection a mongodb interpreter for the command "show dbs" for example? Thank you very much Cheers Manuele -- --- You received this

[web2py] Re: auth.wiki() allow guests to view the wiki

Very sorry, I know now what I was doing. I changed the name of the page from index to "Hello World", so when I tried to visit the page it was asking me to create the index page, which of course required me to login. Thanks Simon On Monday, 19 August 2013 21:36:20 UTC+1, Alan Etkin wrote: > > H

[web2py] auth.wiki how to align and resize images

I have added a photo to my page using "Edit Page Media" I have added the following line to my page to display the image @1/road.jpg This gives me the image full size and centered. Is there something I can include on this line to add style such as size and alignment? -- --- You receiv

[web2py] Re: auth.wiki how to align and resize images

I found the solution myself here is how to do it [[The Road [This is a picture of the road] @1/road.jpg left 150px]] I found the answer on http://www.web2py.com/init/static/markmin.html [[alt-string for the image [the image title] http://www.web2py.com/examples/static/web2py_logo.png right

[web2py] Re: can we paint a def function with multiple memberships

thanx fabiano and anthony, awesome. lucas On Monday, August 19, 2013 9:23:21 PM UTC-4, lucas wrote: > > i am aware of: > > @auth.requires_membership('Administrator') > def users(): > etc > > however, can we allow for multiple or's, like > > @auth.requires_membership('Administrator') > or @auth

Re: [web2py] Re: SQLFORM.grid always show column sorter arrows

Found my issue. I am supplying a list to the orderby parameter. If I supply only 1 field then it works. Is it possible to check if it is a list and if so, turn on the sorter icon for just the first field in the list? On Monday, August 19, 2013 8:29:42 PM UTC-5, Jim S wrote: > > Just got back to

[web2py] Possible to do secondary, ternary..., n-ary orderby in grid?

Is it possible to do a ranked/n-ary/sequenced orderby in SQLFORM.grid? For example, let's say you list user information in a grid, which includes first name, last name, and middle name. It's possible to use orderby to order the users by last name. Is it possible to order by last name, then firs

Re: [web2py] Possible to do secondary, ternary..., n-ary orderby in grid?

On 20 Aug 2013, at 6:45 AM, Lamps902 wrote: > Is it possible to do a ranked/n-ary/sequenced orderby in SQLFORM.grid? For > example, let's say you list user information in a grid, which includes first > name, last name, and middle name. It's possible to use orderby to order the > users by last n

[web2py] Re: Date search on sqlform.grid not working

This is of some interest to me too. Issue 1640created. On Sunday, August 18, 2013 9:58:28 AM UTC+2, Massimo Di Pierro wrote: > > Good point. The search is performed in the database format which is ISO > (Y/m/d). The grid is not smart enough

[web2py] RESTful and content-type

I had a problem with Restful requests. The content-type response header was text/plain when I sent a http://xxx.json request. Is it ok? I need content-type response header as application/json. To do that I have modified the glucon/contenttype.py with the following code: *Original contenttype.py

[web2py] Re: RESTful and content-type

I don't think this is the right fix. This allows that a file without extension gets sent as entirely something else (meaning, I may have a file named "jpg" holding text data and it gets sent as appliaction/png). BTW, can you pack an app that reproduces the issue ? On Tuesday, August 20, 2013 1:

Re: [web2py] Possible to do secondary, ternary..., n-ary orderby in grid?

Awesome - thanks! On Tuesday, August 20, 2013 8:57:21 AM UTC-5, Jonathan Lundell wrote: > > On 20 Aug 2013, at 6:45 AM, Lamps902 > > wrote: > > Is it possible to do a ranked/n-ary/sequenced orderby in SQLFORM.grid? For > example, let's say you list user information in a grid, which includes > f

[web2py] Re: Encoding problem in 'format' from define_table on GAE

Well, I found a solution for this strangely undocumented issue: format=lambda r: r.nombre.decode("utf-8", 'ignore') + ' - ' + str(r.precio) + '€'.decode("utf-8", 'ignore') Then, using the lambda and decode, it works. Maybe that the 'ignore' isn't neccesary, but I left there just in case. El lu

[web2py] Querying Multiple Databases

I asked a question last Friday and haven't received any answers https://groups.google.com/forum/#!topic/web2py/t7xI7P0dqn4 I really need help so I thought I would post my core question again. What is the best way to connect to a variable list of legacy Postgres databases? The list could be b

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

Where is this code? If it is in a web2py model or controller you do not need to close. If it is a a script that you run with web2py.py ... -R script.py than you need to close it. You should close it with my_db.commit() What is the reason for this? res = my_db.executesql("SELECT * FROM inf

[web2py] session logic

The session logic has been rewritten (for clarity and to fix a bug). Can you help checking nothing is broken? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email

[web2py] Another Book Correction Needed (5th ed P.369)

There appears to be another error in the 5th Edition Web2Py book in Chapter 7 on P.369. The issue is with the following code block: def list_records(): REGEX = re.compile('^(\w+).(\w+).(\w+)\=\=(\d+)$') match = REGEX.match(request.vars.query) if not match: redirect(URL('error

[web2py] Re: Another Book Correction Needed (5th ed P.369)

seems like import re is missing at beginning of function. Alex Am Dienstag, 20. August 2013 18:47:29 UTC+2 schrieb REM: > > There appears to be another error in the 5th Edition Web2Py book in > Chapter 7 on P.369. > > The issue is with the following code block: > > def list_records(): > REGE

[web2py] Re: diffrence between web2py and django framework...

when I decided for a framework I studied the documentation for both django and web2py. It seems like they have more or less the same functionality but what really made the difference for me is the DAL. db(db.tablename.fieldname <= value).select() # web2py Tablename.objects.filter(fieldname__lt

Re: [web2py] Re: Another Book Correction Needed (5th ed P.369)

Thanks, now it works. Man, seems like learning this stuff would be a lot easier *if I had already learned it*. Then spotting/fixing these book errors would be a breeze. On Tue, Aug 20, 2013 at 1:46 PM, Alex wrote: > seems like > import re > is missing at beginning of function. > > Alex > > A

[web2py] Re: jQuery help with form and page reload on button click

I just noticed that this also happens in another view if I use a custom form. When I simply show the form as {{=form}} then jQuery does not cause the form to submit.. in that case, the js/jQuery code is inside a button that causes checkboxes to be selected on the page when the button is clicked

[web2py] Re: How to add itens to a shopping cart

I found that https://code.google.com/p/web2py-estore/ El domingo, 18 de agosto de 2013 21:21:57 UTC-5, Elliott Chaves escribió: > > Hi, > > i having a problem to add itens to a shopping cart. To be more precise, i > don't know how to do that. I thinking in how to connect a call from view to

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_st

[web2py] Re: GAE Cron, or some equivelant

nothing? On Monday, August 19, 2013 7:49:03 AM UTC-4, jjg0 wrote: > > I was referring to google app engine... > The book hasn't been very helpful > > On Friday, August 16, 2013 6:05:41 PM UTC-4, Massimo Di Pierro wrote: >> >> It all depends on how you run web2py. If you run it with web2py.py thank

[web2py] Re: Not a web2py issues but ...

graet ! when will be published !! El lunes, 19 de agosto de 2013 08:51:56 UTC-5, Massimo Di Pierro escribió: > > ... I am writing a book about Numerical Algorithms in Python. It is almost > done. If you are interested in the subject and are interested in the area, > please email me. I will b

[web2py] Re: Version in admin lists "(Running on %s)" instead of providing server info

Submitted. Thanks. On Monday, August 19, 2013 11:26:08 PM UTC-7, Massimo Di Pierro wrote: > > Good point. Please open a ticket about this. > > On Tuesday, 20 August 2013 01:00:02 UTC-5, HittingSmoke wrote: >> >> Long ago web2py used to provide which python version it was running on in >> the admi

[web2py] Re: GAE Cron, or some equivelant

Scheduler in GAE is not allowed. I'd go for their cron or their task queue... https://developers.google.com/appengine/docs/python/config/cron?hl=it&csw=1 https://developers.google.com/appengine/docs/python/taskqueue/?hl=it&csw=1#Using_Task_Queues_in_Python There's also a presentation that explains

[web2py] Re: diffrence between web2py and django framework...

Well, since you are asking the web2py users, I suspect you'll find biased reviews, favoring web2py. That's fine if you are trying to justify your decision to a superior. However, the decision as to which framework to use should not be taken lightly. You should create identical apps (small) in b

[web2py] Re: executesql for Nosql engine

Il 20/08/13 09:56, Manuele Pesenti ha scritto: > Hi! > What's the right way to ask to a NoSQL engine like mongodb if a > table/database already exists? > Can I obtain from my db (a DAL object) or their adaper/connection a > mongodb interpreter for the command "show dbs" for example? I answere myse

[web2py] Re: bootstrap 3

Bootstrap has gone to flat design for its default theme. This is generally the direction web design is taking. It's more sleek and clean out of the box. If people want a raised theme BS 3 offers themes to return to the original design so the new version is more about choice and easier customiza

[web2py] Re: Date search on sqlform.grid not working

well, I can work on it. Basically the issue is how are we going to resolve it ? Is it acceptable that the sqlform.grid search widget always works only with dates in ISO format (i.e. it will disregard whatever regional setting is otherwise chosen)? If yes, I have more or less yet an idea on how t

[web2py] Re: web2py | Email + IMAP | Help Wanted

> Let me know how the efforts are progressing on that front to add > Save-As-Draft on the IMAP server. There's an append impementation added to trunk. However, to work properly it needs the following patch too (pending for revision) http://code.google.com/p/web2py/issues/detail?id=1638&start=100

[web2py] Re: GAE Cron, or some equivelant

Still not getting this. The gae docs says 'A cron.yaml file in the root directory of your application (alongside app.yaml) configures scheduled tasks for your Python application.' so I made a cron.yaml file in my root directory in /web2py folder right where the app.yaml file is. Looking at th

Re: [web2py] Re: bootstrap 3

Like flat design better! BS 3 is just look less like twitter and that a good thing to me... Richard On Tue, Aug 20, 2013 at 3:36 PM, HittingSmoke wrote: > Bootstrap has gone to flat design for its default theme. This is generally > the direction web design is taking. It's more sleek and clean

[web2py] Re: Version in admin lists "(Running on %s)" instead of providing server info

uhm. Right now it displays "running on request.env.server_software". Usually the header is provided from the underlying server, but it's not required. However I'll send a patch for having "Running on unknown, Python 2.7.3" to leave out the %s. On Tuesday, August 20, 2013 8:30:34 PM UTC+2, Hitti

[web2py] Re: GAE Cron, or some equivelant

I'm just reading through the docs. *Cron support in the development server* When using the Python SDK, the dev_appserver has an admin interface that allows you to view cron jobs at http://localhost:8000/cron. The development server doesn't automatically run your cron jobs. You can use your loc

[web2py] Re: bootstrap 3

Unfortunately bs3 has dropped some components used by web2py, for example submenus, has changed many classes and so on. In other words it's a different framework that requires changes in web2py code which - currently- infringe the backward compatibility. Moreover IE7 and FF3.6 aren't supported

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_s

Re: [web2py] Re: Two databases with an auth in each

Thank you very much for your response On Monday, August 19, 2013 6:22:33 AM UTC-7, David Ripplinger wrote: > > In my situation, I'm offering two completely different services to my two > types of users: one is getting budgeting software and the other is getting > advertising options. So in my ca

[web2py] Re: bootstrap 3

On Tuesday, August 20, 2013 1:22:19 PM UTC-7, Paolo Caruccio wrote: > Unfortunately bs3 has dropped some components used by web2py, for example > submenus, has changed many classes and so on. In other words it's a > different framework that requires changes in web2py code which - currently- >

[web2py] Re: plugin_clientapi

Thanks Alan, will do so in the next couple of days (after current deadlines) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroup

[web2py] Re: bootstrap 3

Anthony you are right about the scaffolding, But currently, web2py renders forms with formstyle="bootstrap" which have css classes not used anymore in bs3. Therefore we should use jquery to adapt the rendered html but we could see heavy flash of unstyled content phenomenon. Another way is to use

[web2py] Re: bootstrap 3

+1 on Anthony and on the fact that having some pretty "maintained-out-of-band kickass layouts" is somewhat missing in web2py. I'm waiting on the final release to test bs3, but for example the structure of response.menu has been definitely a PITA to work with bs2 and it's going to be even more PI

[web2py] Re: bootstrap 3

Man, I'm such a clairvoyant!! This was already brought up to @massimo in the past. I'd go with a new formstyle='bootstrap3' to handle all changes. It's unthinkable to have it otherwise and maintain all things working bs2-->bs3 without heavy FOUC. Don't loose your mind over it ^_^ On Tuesday, Au

Re: [web2py] Re: Ajax input masks

Thank you, I see what you are saying and will test the jQuery examples. Ideally, I'd like to predefine the validation code and just specify a mask when the field is declared in the Field statement (DRY). Then forms would inherit the value and use the appropriate jQuery code for those fields.

[web2py] Re: bootstrap 3

On Tuesday, August 20, 2013 2:01:54 PM UTC-7, Paolo Caruccio wrote: > Anthony you are right about the scaffolding, But currently, web2py renders > forms with formstyle="bootstrap" which have css classes not used anymore in > bs3. > This doesn't mean the scaffolding app has to remain on Bootstra

[web2py] Re: bootstrap 3

indeed we have https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L760 the external contrib module was exactly what I proposed to @massimo, but by the time we were discussing, a new release was issued (I seem to remember it was around the time of 2.0.x). This doesn't mean the sca

[web2py] Re: bootstrap 3

Web2py includes several formstyles even now (table3cols, table2cols, divs, ul and bootstrap). The default formstyle is table3cols, isn't it? What needs to be done now is to add a new bootstrap3 formstyle. If forms include formstyle=bootstrap, the users will continue to get BS2 classes (as they

[web2py] Re: bootstrap 3

BTW, a nice thing to have would be a global default formstyle that propagates to all SQLFORM-related serializations. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an

Re: [web2py] Re: How to add itens to a shopping cart

I did something, but is very ugly ;) i'll share the code latter! -- Elliott Chaves Graduando em Engenharia Elétrica - IFPB - www.ifpb.edu.br -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receivi

[web2py] Re: bootstrap 3

Using a library from contrib sounds like a good approach and I wish this was done before adding bootstrap. Perhaps it should be done now, for all future formstyles? Even now, bootstrap is really just covering bootstrap-horizontal (there are other form options within BS). Regards, Ales On Tues

[web2py] Re: bootstrap 3

@Anthony I never said that the scaffolding can't change, I said that web2py currently can't apply bs3 per default without to change some core code but your and Niphlod solutions have cleared my doubts. In fact I have ready a welcome app founded on bs3 and jQuery 2.0.3. @Niphold Thank you. If

[web2py] how to exclude field from SQLFORM.factory

I'm using SQLFORM.factory to create a form for two tables: form = SQLFORM.factory(db.invoice, db.individual_invoice, table_name='individual_invoice') now I need to exclude one field from invoice table in case the invoice already exists, this field should not be updated once the invoice is creat

Re: [web2py] how to exclude field from SQLFORM.factory

db.tablename.fieldname.writable=False db.tablename.fieldname.readable=False before you create a form On Tue, Aug 20, 2013 at 11:43 PM, Alex wrote: > I'm using SQLFORM.factory to create a form for two tables: > form = SQLFORM.factory(db.invoice, db.individual_invoice, > table_name='individual_inv

[web2py] Re: bootstrap 3

Am I reading the book correctly? SQLFORM chapter doesn't mention formstyle=bootstrap. I haven't been able to find it mentioned anywhere else in the book either, not even in the section about modifying views. So, could this be considered an experimental feature and thus moved to a contrib withou

[web2py] Re: bootstrap 3

+1 for gluon.contrib.formstyle We could extend the styles to other interesting frameworks and apply this styles on several web2py components and not only the forms. Of course, as Niphlod said, we should have a default formstyle also. Il giorno martedì 20 agosto 2013 23:35:43 UTC+2, LightDot ha sc

[web2py] Re: Version in admin lists "(Running on %s)" instead of providing server info

So is this a server configuration issue? I don't even see the Python version, just the web2py version. On Tuesday, August 20, 2013 1:06:57 PM UTC-7, Niphlod wrote: > > uhm. Right now it displays "running on request.env.server_software". > Usually the header is

[web2py] Re: bootstrap 3

I'm just glad to see this is being looked into. I think BS3 is an improvement over 2. I know it's not just a simple flip of the switch but it would be nice to see "official" support some time in the future. On Monday, July 29, 2013 7:01:47 AM UTC-7, Niphlod wrote: > > just to inform everybody th

[web2py] Re: Date search on sqlform.grid not working

To me, the latter is a proper solution for apps that use translated dates. But even the former is far better than now, as far as user experience goes. On Tuesday, August 20, 2013 9:35:59 PM UTC+2, Niphlod wrote: > > well, I can work on it. Basically the issue is how are we going to resolve > it

Re: [web2py] how to exclude field from SQLFORM.factory

right, totally forget I could use that also for SQLFORM.factory. thanks Marin! On Tuesday, August 20, 2013 11:47:10 PM UTC+2, Marin Pranjić wrote: > > db.tablename.fieldname.writable=False > db.tablename.fieldname.readable=False > > before you create a form > > On Tue, Aug 20, 2013 at 11:43 PM,

[web2py] Using DAL outside of web2py

I have the following scenario and am wondering how others are handling it. I have a dev and prod environment that I'm working with. They exist on different servers. In my dev environment I have migrate turned on for all tables. In prod they are turned off. I use mercurial for source control

[web2py] Re: bootstrap 3

On Tuesday, August 20, 2013 2:20:51 PM UTC-7, Niphlod wrote: > indeed we have > https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L760 > the external contrib module was exactly what I proposed to @massimo, but > by the time we were discussing, a new release was issued (I seem to

[web2py] installing appliance.

Hi, I tried to install the car app and I got to: invalid function (default/Cars) on both urls: http://localhost:8000/Cars http://localhost:8000/Cars/appadmin I was using the admin ui to "upload and install packed application" It happened to me with other apps I tried as well. Thanks, Avi. -- --

[web2py] Re: bootstrap 3

On Tuesday, August 20, 2013 2:35:17 PM UTC-7, Paolo Caruccio wrote: > @Anthony > I never said that the scaffolding can't change, I said that web2py > currently can't apply bs3 per default without to change some core code but > your and Niphlod solutions have cleared my doubts. > Right. And to b

[web2py] Re: bootstrap 3

On Tuesday, August 20, 2013 2:24:00 PM UTC-7, Niphlod wrote: > BTW, a nice thing to have would be a global default formstyle that > propagates to all SQLFORM-related serializations. > ++1 For now, you can do something like: SQLFORM.formstyles.table3cols = SQLFORM.formstyles.bootstrap or SQLF

[web2py] session.forget(response) prevents SQLFORM.factory from working

session.forget(response) prevents SQLFORM.factory from working. Is this supposed to happen? If so, why? I was hoping it would prevent the session files from being written. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe f

Re: [web2py] Re: bootstrap 3

On Tue, Aug 20, 2013 at 10:15 PM, Anthony wrote: > > > I'm not sure we should have created a formstyle called "boostrap", though. > Instead, we should probably put a formstyle.py in contrib that includes > several custom formstyles, including ones for Bootstrap 2 and Bootstrap 3. > Then you would

Re: [web2py] session.forget(response) prevents SQLFORM.factory from working

On Wed, Aug 21, 2013 at 12:26 AM, wrote: > session.forget(response) prevents SQLFORM.factory from working. Is this > supposed to happen? If so, why? I was hoping it would prevent the session > files from being written. > > To secure forms submission web2py needs to store an hash in the session to

Re: [web2py] session.forget(response) prevents SQLFORM.factory from working

The form can be forced to work without sessions but I strongly advise against doing it, for security reasons (CSRF protection, etc.): if form.process(session=None).accepted: ...code... Regards, Ales On Wednesday, August 21, 2013 2:14:12 AM UTC+2, Ricardo Pedroso wrote: > > > On Wed, Aug 21, 201

[web2py] Store values from Select button

Hi, I am new to web2py and trying to learn some basic features but facing prob. I would like to create select button and store its selected value in a variable so that I can use in other function. Also I don't want to create submit button for select button. Is it possible to store selected value

[web2py] bug in trunk with request.vars being turned into a list with a duplicated value???

I have this URL: http: //127.0.0.1:8050/patient_form/enter_form/enter_form?login_id=T19566&_signature=609f2082e4d219a48ae44e2448ab0e01a9a05e55 and the controller does this: login_id = request.vars.login_id ... valid_code = cache.disk(login_id,lambda: None,time_expire=SESSION_MINUTES*60 ) The

Re: [web2py] installing appliance.

Maybe there is no "custom" view in the app... In the book it says that generic.html is disabled in prod to prevent security hole. So if there is no view in your and it only use the generic one it may be the source the issue you get. Hard to say without test it myself, but I am busy rigth now. Ric

[web2py] Re: bug in trunk with request.vars being turned into a list with a duplicated value???

According to git bisect, the commit which seems to cause the problem is b0e9140508 web2py backport of lazy get_vars, post_vars and vars On Wednesday, 21 August 2013 11:00:58 UTC+10, Tim Richardson wrote: > > I have this URL: > http:// > 127.0.0.1:8050/patient_form/enter_form/enter_form?login_id=T

[web2py] Re: bug in trunk with request.vars being turned into a list with a duplicated value???

moved to developers group -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.googl

Re: [web2py] Re: bootstrap 3

> I'm not sure we should have created a formstyle called "boostrap", though. >> Instead, we should probably put a formstyle.py in contrib that includes >> several custom formstyles, including ones for Bootstrap 2 and Bootstrap 3. >> Then you would do: >> >> from gluon.contrib.formstyle import

[web2py] Re: bug in trunk with request.vars being turned into a list with a duplicated value???

On Tuesday, August 20, 2013 6:00:58 PM UTC-7, Tim Richardson wrote: > I have this URL: > http:// > 127.0.0.1:8050/patient_form/enter_form/enter_form?login_id=T19566&_signature=609f2082e4d219a48ae44e2448ab0e01a9a05e55 > > > and the controller does this: > > login_id = request.vars.login_id > > When

[web2py] Re: Version in admin lists "(Running on %s)" instead of providing server info

The python version will be an addition. the "configuration issue" is not that major bug that you'd expect it's a wsgi var that some server add, some server don't. given the "rather default" nginx+uwsgi for example, it is explicitely set, otherwise it's not present. As for wsgi spec, it's not

[web2py] Re: Two databases with an auth in each

> Alternatively, you could create separate tables that are simply linked to the auth_user table. This is what I did, and so far it works out well. I followed the 'party' pattern and added the party.id to the auth_user table. Kind regards, Annet -- --- You received this message because yo