[web2py] Re: "Query Not Supported" on GAE

Dear Massimo, * * Is it a possible solution to retrieve all records in the table for Datastore and store it, then perform the search on this stored data object (by means of row.field.index('query_string') maybe?)? Furthermore, when target record(s) is found, is it possible present them with SQLF

[web2py] error_warpper in inline form

I have an inline form: form=SQLFORM.factory( Field('tag',length=128,requires=[IS_IN_DB(db,'tag.name','%(name)s',error_message='Tag not in database')]), Field('locality',length=64,requires=[IS_IN_DB(db,'locality.name','%(name)s',error_message='Localityniet in database')]), separat

Re: [web2py] Re: New Relic module causing import error

As I mentioned earlier this is no longer an issue since we've installed httplib2 via pip. It was happening when httplib2 was being loaded from our app's directory, but I'm honestly not even sure what module version that was. At this point we're just assuming it was a problem with an older module an

Re: [web2py] Re: Error Pages via AutoRoutes

What do you mean you "cannot define custom error page". if you put it at the end of your routes.py file what happens? Are they ignored? Do you get an error? I do not see you using routes_onerror in the example. Or is the problem that routes on error cannot be declared in the routes.conf file? O

[web2py] how can i login without using form?

asda -- --- 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.google.com/groups/opt_out.

[web2py] how can i login without using form?

hi all.. i m new on web2py. i try to get some values from twitter to my database.. the problem is "i got all values like twitter id, profil pic, background pic url, friends, fallowers etc. but i cant login" how can i rise the flag (if there s) auth_user.id_logged_in ? i mean how can i do that? :

Re: [web2py] Re: New Relic module causing import error

Is this only with web2py? What if you import newrelic followed by httplib2 in from shell or in wsgi before importing web2py? On Monday, 29 April 2013 21:28:24 UTC-5, Yarin wrote: > > Cliff- No, we are not using virtualenv > > > On Mon, Apr 29, 2013 at 10:23 PM, Cliff Kachinske > > > wrote: > >>

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hello Arnon, In web2py all DAL operations are wrapped in a transaction which can be committed explicitly via db.commit() or automatically at the end of an http request. It does not suffer from the problems of Active Records mentioned in the slides where each object is committed separately and t

Re: [web2py] Re: New Relic module causing import error

Cliff- No, we are not using virtualenv On Mon, Apr 29, 2013 at 10:23 PM, Cliff Kachinske wrote: > Are you using a virtualenv? > > Maybe you having a version clash between libs. > > -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users"

Re: [web2py] Re: New Relic module causing import error

Are you using a virtualenv? Maybe you having a version clash between libs. -- --- 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] is it possible to add an autocomplete widget to the rows of an SQLFORM.grid?

I want to use SQLFORM.grid to show rows of data from one table, and to conveniently allow the user to quickly select a foreign key. The foreign key is a reference field, so it works with a click to edit the row which then opens the detail view. I was hoping to allow an in-line edit. I think I c

Re: [web2py] Re: New Relic module causing import error

Turns out we were able to resolve this simply by pip installing httplib2 instead of loading it from the web2py application directory. Now everything's working together fine. Not sure what the original problem might have been, but thanks for the help-- On Monday, April 29, 2013 9:01:22 PM UTC-4

Re: [web2py] Re: Error Pages via AutoRoutes

Hi Massimo, I use this. Correct, once using autoroutes I cannot define custom error page no more. # -*- coding: utf-8 -*- ''' autoroutes writes routes for you based on a simpler routing configuration file called routes.conf. Example: - BEGIN routes.conf--- 127.0.0.1 /examples/default

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

So, clean-slake here - who is excited about SQLA's unit-of-work/session implementation? http://youtu.be/uAtaKr5HOdA * The slides for it are here: http://techspot.zzzeek.org/files/2012/session.key.pdf * Thw second-half shows an int

Re: [web2py] Re: New Relic module causing import error

On Tue, Apr 30, 2013 at 12:41 AM, Yarin wrote: > Ricardo- yes, importing httplib2 throws the same error, even without > importing oauth. > > We've noticed that the problem does not arise with the new relic import > statment on the first line, > but only on the second line, when the new relic agent

[web2py] Re: custom menu using response.menu

No, inside menu2.py I still had response.menu = [etc.] when I changed that to menu2 = [etc.], it works! thank you, Anthony Margaret -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and s

[web2py] Re: Sahana Eden GSOC Project - anybody interested?

Where can we get access to the code? On Monday, April 29, 2013 10:58:29 AM UTC-4, Massimo Di Pierro wrote: > > > http://www.slideshare.net/conniewhite/sahana-eden-gsoc-social-media-integration > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" g

[web2py] Re: custom menu using response.menu

What does menu2.py look like? Does it have: menu2 = [...] Anthony On Monday, April 29, 2013 6:57:49 PM UTC-4, greaneym wrote: > > Thanks, I was hoping this kind of thing would work, but I'm still doing > something wrong. > > > In models, I added menu2.py which contains a custom menu but is set

Re: [web2py] Re: New Relic module causing import error

Ricardo- yes, importing httplib2 throws the same error, even without importing oauth. We've noticed that the problem does not arise with the new relic import statment on the first line, but only on the second line, when the new relic agent is initialized. import newrelic.agent # Doesn't cause

[web2py] Re: custom menu using response.menu

Thanks, I was hoping this kind of thing would work, but I'm still doing something wrong. In models, I added menu2.py which contains a custom menu but is set up just like the default menu in layout.html, and in the layout.other.html I added {{=MENU(menu2)}} but when I run the view, I am gett

[web2py] Re: custom menu using response.menu

There's nothing special about response.menu -- it's just a list of tuples. You can just as easily store the menu in any variable, so you can create as many menus as you want and then convert them to HTML in the view via the MENU() helper: In menu.py, or separately in menu1.py and menu2.py, or w

[web2py] custom menu using response.menu

Is it possible to have two menu.py files in models that associate with response.menu? I wanted to have an index file that has something like this, {{extend 'layout.html}} {{include layout.other.html}} {{include dashboard.html}} where layout.other.html has the menu2 for the dashboard. Is it pos

[web2py] Re: Menu item without URL

If you do: ('Item 3', False, None, [('Subitem1', False, URL(...)), ('Subitem2', False,URL (...))]) "Item 3" should be a clickable link, but clicking it won't do anything (it's href will b "#", and it will have an "onclick" handler that does nothing in response to a click). If you don't want it

Re: [web2py] Re: New Relic module causing import error

On Mon, Apr 29, 2013 at 9:30 PM, Yarin Kessler wrote: > Yes, we have httplib2 installed in our modules folder, and the python-oauth2 > lib runs fine if we don't import the new relic agent first. Likewise, the > new relic works fine and we get no errors if we never call import oauth2. > It's only w

Re: [web2py] apache backdoor?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 29-04-2013 17:17, Massimo Di Pierro escreveu: > http://apache.slashdot.org/story/13/04/29/1258205/sophisticated-apache-backdoor-in-the-wild > > I have moved to Nginx already and I am happy. ;-) > If "they" were able to replace httpd bin why would

Re: [web2py] Re: New Relic module causing import error

Yes, we have httplib2 installed in our modules folder, and the python-oauth2 lib runs fine if we don't import the new relic agent first. Likewise, the new relic works fine and we get no errors if we never call import oauth2. It's only when both are imported. On Mon, Apr 29, 2013 at 3:51 PM, Niphl

Re: [web2py] apache backdoor?

They have not yet understood how apache binary is being replaced by a malicious version. It is not clear if the attack begins through apache itself or by cpanel or ssh. The article title emphasize apache as the guilty one, but the point is that this kind of attack goes undetected very easily and

[web2py] Re: New Relic module causing import error

are you positive that you have httplib2 installed (and available)? custom_import machinery is tricky and the most complete picture should be in Massimo's end. for starters, let's be sure that httplib2 is installed ^_^ On Monday, April 29, 2013 9:45:21 PM UTC+2, Yarin wrote: > > We're trying

[web2py] New Relic module causing import error

We're trying to integrate New Relic with web2py. We installed it per their instructions for web2py running on mod_wsgi, adding the following lines in wsgihandler.py: import newrelic.agent newrelic.agent.initialize('/opt/web-apps/web2py/

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

On Monday, April 29, 2013 2:59:29 PM UTC-4, Arnon Marcus wrote: > > Look, I get that in many open-source communities, feature-requests are > generally frowned upon. It's like "who this guy thinks he is, telling me > what's missing with MY great achievement, hu...?" > There is a lot of ego-invol

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

I think the issue here is that the feature you are proposing doesn't provide any real benefit, not many people are interested, it would take significant development time to implement, and potentially confuse new users of the software. The thing is, web2py is open source and released under the L

[web2py] Menu item without URL

Hi How can i create a menu item without a URL? Basically what i want is that if a menu item expands into a submenu, then that menu item should not be clickable, only the sub menu items should have URLs. If i write it as None, it still gets converted to a default URL (default/index) For eg. "M

[web2py] Re: Jquery mobile module not working

I have the same Problem.. El martes, 2 de abril de 2013 17:07:35 UTC-3, Torvald Baade Bringsvor escribió: > > Hi > > I'm trying out the jquery mobile plugin for web2py (2.4.5) and I'm having > no success. When I load the page (both on mobile device and desktop) I get > a blank page. > > When I

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Look, I get that in many open-source communities, feature-requests are generally frowned upon. It's like "who this guy thinks he is, telling me what's missing with MY great achievement, hu...?" There is a lot of ego-involved... Sometimes too-much so... Granted, I don't pay anyone here, so socia

Re: [web2py] Is there a way how to use a viewScope on conversationScope like variable?

I understand that scope idea is based on statefullness of these mentioned frameworks. I can see the statefullness important (and useful) when you work on intranet applications that require a more complicated logic etc. The viewScope starts on first page GET and lives for all POSTs to server an

Re: [web2py] apache backdoor?

Hi Massimo, On 29/04/13 17:17, Massimo Di Pierro wrote: http://apache.slashdot.org/story/13/04/29/1258205/sophisticated-apache-backdoor-in-the-wild To be fair, following the link, it seems to be more of a cPanel backdoor - it doesn't seem that Apache alone is vulnerable, only via cPanel.

Re: [web2py] Is there a way how to use a viewScope on conversationScope like variable?

On Mon, Apr 29, 2013 at 5:26 PM, David Marko wrote: > Such a great piece of code!! Thanks. Its very close but page scope should be > bound to specific instance of page so it works also in situation when you > open the same page in several browser tabs. It must be independent. Didn't understand

[web2py] Re: Sahana Eden GSOC Project - anybody interested?

Seems interesting, but impracticable. If you are on top of a mountain, how are you going to get cellular service? And if you do get service, why not just call someone and say "hey im stuck up here, get some help". Also, would I really want my local fire department (coast guard, police) monitori

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

The really great thing about free open source software is that you can fork or write a wrapper for any module. You don't even have to wait for someone else to agree that your idea is worth spending time on. On Saturday, April 27, 2013 9:18:45 AM UTC-4, Arnon Marcus wrote: > > I am in the proc

Re: [web2py] Is there a way how to use a viewScope on conversationScope like variable?

Such a great piece of code!! Thanks. Its very close but page scope should be bound to specific instance of page so it works also in situation when you open the same page in several browser tabs. It must be independent. -- --- You received this message because you are subscribed to the Googl

[web2py] Re: conditional sum() row table in controller

it's work well now, thank you so much. massimo, already tested with many cases 1. have promotion price, the others don't have 2. both have promotion price 3. both don't have promotion price, use unit price the results are as expected. grand_total=sum((item.promotion_price or item.unit_price)*s

[web2py] Re: Form method = GET and keepvalues

don't have the time to fully test it , but process() or validate() consider only request.post_vars by default https://github.com/web2py/web2py/blob/master/gluon/html.py#L2103 so, try as villas says (explicitely passing request.vars to an accept() ) or use form.validate(request_vars=request.vars

[web2py] apache backdoor?

http://apache.slashdot.org/story/13/04/29/1258205/sophisticated-apache-backdoor-in-the-wild I have moved to Nginx already and I am happy. ;-) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receivin

[web2py] Re: Form method = GET and keepvalues

Also try this: if form.accepts(request.vars,keepvalues=True,dbio=False): I also think the syntax you suggested should have worked, but I don't know why... On Monday, April 29, 2013 10:53:48 AM UTC+1, Domagoj Kovač wrote: > > Hi, > > In my grid i have a search form that filters grid result

Re: [web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

Yeah, been a long day it should be: db.define_table( 'contact', Field ('name'), Field ('address'), format = '%(name)s') db.define_table( 'courses' , Field

Re: [web2py] Is there a way how to use a viewScope on conversationScope like variable?

On Mon, Apr 29, 2013 at 10:13 AM, David Marko wrote: > Is there a way how to use/crrate a viewScope on conversationScope like > variable in web2py? In JAVA based frameworks (e.g. JSF, Spring Framework) > there are scoped environments available. In web2py we have requestScope, and > sessionScope (i

[web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

Isn't that the same model? On Monday, April 29, 2013 11:31:17 AM UTC-4, Michael Hall wrote: > > > My bad, the model in my example should be: > > db.define_table( > 'contact', > Field ('name'), > Field

[web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

Doh did it again, its been a long day, the model with the correct reference is db.define_table( 'contact', Field ('name'), Field ('address'), format = '%(name)s') db.define_table(

[web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

My bad, the model in my example should be: db.define_table( 'contact', Field ('name'), Field ('address'), format = '%(name)s') db.define_table( 'courses', Field

[web2py] didods

de -- --- 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.google.com/groups/opt_out.

[web2py] Inserting test data with a user in appadmin vs a customer user

Since auth.signature holds the creation date of an entry to a db table, I was hoping to use it to query for the newest 5 items and display them on the main page. auth=Auth(db) auth.define_tables(username=False, signature=False) auth.enable_record_versioning(db) db.define_table('brandName',

[web2py] Sahana Eden GSOC Project - anybody interested?

http://www.slideshare.net/conniewhite/sahana-eden-gsoc-social-media-integration -- --- 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...@googlegr

[web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

I do not see any relation between courses and contact. On Monday, 29 April 2013 07:32:10 UTC-5, Michael Hall wrote: > > I would like to have a smartgrid that references its parent table in > linked_tables, what is the web2py way of doing this? I have found some help > in this thread: > https://

[web2py] Re: conditional sum() row table in controller

rand_total=sum((item.promotion_price or item.unit_price)*session.order[item.id] for item in *db(db.product.id.belongs(*session.order.keys())).select(db.product.id,db.product.promotion_price,db.product.unit_price)) On Sunday, 28 April 2013 23:37:37 UTC-5, 黄祥 wrote: > > pardon me, for not tell

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

> they don't build up magically by default (though the cascade parameter >> allows the same flexibility as the one present in your backend) but given >> that all the six "important" events are available and fired accordingly, >> you can hook up whatever business logic you like. >> >> > > Tha

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

> > But what exactly an I expected to propose that would be concrete? An API? > Must I be an API coder in order to propose a feature-set? > Sort of. At least in pseudo-code, perhaps you could suggest how you would expect to be able to represent a particular type of data model. > > And about

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

> > If you go through the links I have been pin-pointing here, you would find > many concrete examples of data-models and how they are used in SQLA's ORM. I have gone through the links (not the full presentations, though), and I don't think I've seen anything that looked obviously easier than

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Hi Arnon, Is this thread about... 1. ...storing and manipulating hierarchical trees using the DAL? If so, please specify an example of your data? 2. ...using the DAL with ORM-like syntax? If so, it would be interesting to see an example of the syntax you would like. Perhaps

[web2py] Re: how to dynamically select fields for SQLFORM.grid

Never mind. I figured it out. Here's what I've got as a proof of concept: selected_fields=() fields = db.items.fields() for field in fields: selected_fields += db.items[field], This gives the same output as if I manually entered selected_fields=(field_1,field_2,..field_n) On Monday, April 2

[web2py] how to dynamically select fields for SQLFORM.grid

I've got a very nice looking grid from SQLFORM.grid based on my db.items, however it has ~30 columns which can be too much information for the user. I'd like to make it so the fields shown are selectable by the user. So far I've created db.search which stores the user's search history and added

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

> > I was disappointed to discover that this example is proorly-formed. The > comparison ther, (as well as in other places, like this: > http://web2py.com/examples/static/sqla2.html) feels somewhere between > ill-informed to disingenuous. The original link states the following: The web2py da

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

Anthony found something close to what I'm after: https://code.google.com/p/web2pyorm/ But what exactly an I expected to propose that would be concrete? An API? Must I be an API coder in order to propose a feature-set? And about use-cases - I gave mine, as well as links to others. What else sho

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

This is actually really close to what I am after - 10x. Alas, it seems DOA... I have contacted the creator. -- --- 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] SQLFORM.Smartgrid and with parent table in Linked Tables

I would like to have a smartgrid that references its parent table in linked_tables, what is the web2py way of doing this? I have found some help in this thread: https://groups.google.com/forum/?fromgroups=#!topic/web2py/vDGJdct550Q but the solution is a bit sketchy due to it modifying sqlhtml.p

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

I am interested in these discussions but it seems to me that far too much is being written and I apologise if I haven't read all the references which have been proposed. The fact is that Hierarchical data does not fit at all well into a RDBMS. The main issue is therefore to decide what 'kludge

Re: [web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

This has turned into a meta-discussion, but I get the criticism (I think it is exaggerated, though...). Yes, I should read more about new DAL features, and I will, I just assumed that creative-usage-patters would not necessarily be as well documented as the bare features themselves, and that some p

[web2py] how to introduce scrapped data into web2py framework

Hi Guys, I want to introduce myscrapped data into web2py framework how can i do ?? is there any approach or method ? -- --- 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

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

On Monday, April 29, 2013 11:47:41 AM UTC+2, Arnon Marcus wrote: > > > they don't build up magically by default (though the cascade parameter >> allows the same flexibility as the one present in your backend) but given >> that all the six "important" events are available and fired accordingly,

[web2py] IS_EMPTY_OR(IS_IMAGE()) on field of type upload

I reported this issue: https://groups.google.com/forum/?fromgroups=#!newtopic/web2py/web2py/j-BY78sJ5N4 It was solved, but in web2py 2.4.6 I am having the same problem again. Kind regards, Annet -- --- You received this message because you are subscribed to the Google Groups "web2py-users

[web2py] Form method = GET and keepvalues

Hi, In my grid i have a search form that filters grid results. Is it possible to have SQLFORM.factory to have _method=GET and to keep values on form.validate: Something like: fields = [] fields.append(Field("asset_id", requires=IS_EMPTY_OR(IS_IN_DB(db, 'asset.id

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

> they don't build up magically by default (though the cascade parameter > allows the same flexibility as the one present in your backend) but given > that all the six "important" events are available and fired accordingly, > you can hook up whatever business logic you like. > > That answer

Re: [web2py] Re: response.download

Thanks! -- --- 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.google.com/groups/opt_o

Re: [web2py] Re: response.download

On Mon, Apr 29, 2013 at 9:54 AM, Domagoj Kovač wrote: > Where can i open a ticket about this? > > I am not sure now. I have an image, lets say logo. I want to display this > image via: > {{=IMG(_src=URL("default", "download", args="logo.png"), _width="170px")}} > > I thought if i move my image to

[web2py] Is there a way how to use a viewScope on conversationScope like variable?

Is there a way how to use/crrate a viewScope on conversationScope like variable in web2py? In JAVA based frameworks (e.g. JSF, Spring Framework) there are scoped environments available. In web2py we have requestScope, and sessionScope (if I use this naming) but cant figure out how to create a v

[web2py] Re: response.download

Where can i open a ticket about this? I am not sure now. I have an image, lets say logo. I want to display this image via: {{=IMG(_src=URL("default", "download", args="logo.png"), _width="170px")}} I thought if i move my image to static/images folder then this would work. {{=IMG(_src="/static/

[web2py] Re: ORM (?) : A Revisit, NOT a Rebuttal

On Monday, April 29, 2013 3:59:40 AM UTC+3, Anthony wrote: > > I think you're arguing against a bit of a straw man here. Past resistance > to the idea of an ORM has usually been in the context of suggestions for an > ORM *instead of* a DAL, not as an additional abstraction on top of the > DAL

[web2py] Re: IS IN DB

Thanks Anthony, I did it like this: for option in form.elements('select[name=event_class_id] option'): if option['_value'] and db.event_class(option['_value']).repeated: option.update(_class='repeated') Database query for each option is not problematic, because i don't ha