Re: [web2py] Getting drop-down value names from grandparent record

On 10 July 2012 01:09, MichaelF wrote: > >lambda r: '%s' % (db.I1[db.C1_2[r.C1_2].I1].Name), >_and=IS_NOT_IN_DB(db(db.C1_2_3.C1_2==request.vars.C1_2), 'C1_2_3.C3')) > db.C1_2_3.C1_2.requires=IS_IN_DB(db, 'C1_2.id', > > ... > 1. Am I even allowed to have a lambda function there? > 2. In a

Re: [web2py] Re: Has anyone done a detailed security analysis or attempted a methodical attack on web2py?

I know a few of these guys, and they relly seem to know their stuff. Let's see if they take the bait. :) They know python and webservices very well. BR, Jason Brower On 07/10/2012 01:24 AM, Massimo Di Pierro wrote: No but I am willing to pay to get it done. On Monday, 9 July 2012 10:48:39 U

[web2py] Re: Issue getting Janrain working

I figured it out... The trunk welcome (and all default apps) are missing the conditional for the reset password in the view... Here is a patch: --- welcome/views/default/user.html 2012-07-04 17:54:18.0 -0400 +++ socialjack/views/default/user.html 2012-07-10 00:57:48.0 -0400

[web2py] Multiple select Web2py

Hi all, I have a multiple select that I attach to a auth user profile. However, after I save the profile and log back in, I don't see the selected values when I am editing the profile form. Any ideas. Thank you all very much.

[web2py] Issue getting Janrain working

I am running latest trunk. Added the private/janrain.key file as prescribed with the domain:key When navigating to the /default/user/login page I get a 500 server error. It appears that the reset_password button is trying to be rendered even though using janrain should disable it. I tried man

[web2py] Re: list:string & crud form entry -- what's the latest?

> > Yah, I tried the Enter key, and a lot of other combinations of control > and/or shift + enter as well as an abracadabra (on Chrome (didn't try any > other browser)), but none of them got the list:string to represent except > as a single string field. No additional string fields magically ap

[web2py] Re: Upload file into DB without SQLFORM

Makes sense. I updated the book to reflect this: http://web2py.com/books/default/chapter/29/6#Manual-uploads. Anthony On Monday, July 9, 2012 10:26:52 PM UTC-4, Massimo Di Pierro wrote: > > The problem is this: > > db.table.insert(field = db.table.field.store(...)) > > db.field.store is executed

[web2py] Re: Upload file into DB without SQLFORM

The problem is this: db.table.insert(field = db.table.field.store(...)) db.field.store is executed before db.table.insert therefore before the record is created. there are three options: 1) db.table.field.uploadfield==True (the default) no problem. store() uploads to filesystem because it file

[web2py] Re: IDs position in URLs and SEO

After lots of experimentation I think the stack overflow approach is best (assuming the slug part is generated in the links but ignored). First of all you already have the record id therefore you do not need to look-it up. Second you can edit the slug (because for example of a mistake) and you

[web2py] Re: list:string & crud form entry -- what's the latest?

Yah, I tried the Enter key, and a lot of other combinations of control and/or shift + enter as well as an abracadabra (on Chrome (didn't try any other browser)), but none of them got the list:string to represent except as a single string field. No additional string fields magically appeared, as

[web2py] Re: Dangerous web2py object-reuse pattern?

2) Sorry, not by web2py. Threads and processes are managed (started and killed) by the web server. Web applications (in any framework) should never start their own threads. On Monday, 9 July 2012 18:02:37 UTC-5, Daniel Gonzalez wrote: > > Sorry to bug you here, but: > > 1) Thread safety: sure,

[web2py] Re: Upload file into DB without SQLFORM

On Monday, July 9, 2012 7:59:50 PM UTC-4, Derek wrote: > > That is correct, that's how it's documented as well. > Is it documented that the file storage is not handled when the file is stored in a blob field rather than the filesystem? Anthony

[web2py] Re: Generating pdf using web2py-appreport (xhtmltopdf) in Python Web2py webapp

Hi Akash, Your example controller code seems good and shouldwork. The issue is that PISA is a bit sensitive and only supports a reduced subset of CSS. The error suggests PISA does not know how to handle "Alpha(Opacity=0)". You will need to somehow strip out the unsupported CSS from the html

[web2py] Re: Upload file into DB without SQLFORM

That is correct, that's how it's documented as well. On Monday, July 9, 2012 10:48:07 AM UTC-7, Athelionas wrote: > > Alright, finally I got it working by manually assigning file content to > uploaded_data field. Looks like store() function does not actually store > data if files are to be place

Re: [web2py] Looking for multi-select widget that uses two text boxes

That's good, I thought you still might have some other requirement(s). Anyhow, if you implement it, please advise how it goes. I might try switch to that one if you found it easy to use. All the best, David On Tuesday, July 10, 2012 12:10:50 AM UTC+1, MichaelF wrote: > > Nothing's wrong w

[web2py] Re: is this a bug in editor?

I'm not sure it's in stable, but in trunk there is an entirely new editor ( ACE ), which may work better. Anthony On Monday, July 9, 2012 7:41:07 PM UTC-4, Derek wrote: > > I've seen that happen before. If you have selected text, and you scroll, > you get that. > > I switc

[web2py] Re: is this a bug in editor?

I've seen that happen before. If you have selected text, and you scroll, you get that. I switched to Amy editor, and now I just have issues when I paste... if you go into /admin/default/peek/admin/models/0.py and change TEXT_EDITOR='amy' it seems to work better. Of course, if you scroll with t

[web2py] IDs position in URLs and SEO

Some web applications with restful URLs like Foursquare ( https://foursquare.com/v/restaurante-baobab/*4bed589a75feef3b8d0197e6*) put ID's at the end of the URL, some others like StackOverflow ( http://stackoverflow.com/ques

Re: [web2py] Looking for multi-select widget that uses two text boxes

Nothing's wrong with Anthony's answer; I like it. On Monday, July 9, 2012 4:54:42 PM UTC-6, villas wrote: > > I used this one once: > http://www.senamion.com/blog/jmultiselect2side.html > > However, it appears the one Anthony suggested would be better -- what's > wrong with that suggestion? > >

[web2py] Getting drop-down value names from grandparent record

In short, I'm having problems getting the drop-down value for a field in a child-of-a-child record; I want that value to be a field from the grandparent. In more detail: 1. I have three 'independent' tables ('independent' in that they have no parents). Let's call them I1, I2, and I3.

[web2py] Re: Dangerous web2py object-reuse pattern?

Sorry to bug you here, but: 1) Thread safety: sure, i need to handle that. 2) Threads and processes will be killed by web2py? How? My libraries are creating threads (for example, to track the _changes api of couchdb). This is not at all in control of web2py. I mean, of course, initially a reques

Re: [web2py] Looking for multi-select widget that uses two text boxes

I used this one once: http://www.senamion.com/blog/jmultiselect2side.html However, it appears the one Anthony suggested would be better -- what's wrong with that suggestion? On Sunday, July 8, 2012 9:00:04 PM UTC+1, MichaelF wrote: > > Thanks, Bruno. That's not quite what I need for this job,

[web2py] Re: with versioning how can you list the deleted records

When versioning is on and you delete a record, the record is not actually deleted but is_active is set to False. All queries for tables for versioning automatically add a query is_active==True to filter them out and you no longer see deleted records. You do not need to look for them into the ar

[web2py] Re: Alternative to Janrain: in pure Python

Great project. Let me know if you guys need some contribution from LoginRadius Team. We also offer social authentication, social sharing, user profile data and social analytics for Python websites through our SDK . Than

[web2py] Re: Error with Janrain integration

Maybe, try its alternatives like Gigya or LoginRadius;) On Sunday, July 1, 2012 3:01:25 AM UTC-6, Hassan Alnatour wrote: > > Dear ALL, > > I am using Janrain with the normal login in my site it works well > but lately i have notice that if i a

Re: [web2py] problem with custom primarykey

No. I am not sure this belongs to DAL but if you have ideas, feel free to share them. On Monday, 9 July 2012 11:13:21 UTC-5, Vincenzo Ampolo wrote: > > On 07/09/2012 12:48 AM, Andrew wrote: > > See the dot point > > Keyed table can only refer are to other keyed tables. > > You have a mixture o

[web2py] Re: Has anyone done a detailed security analysis or attempted a methodical attack on web2py?

No but I am willing to pay to get it done. On Monday, 9 July 2012 10:48:39 UTC-5, scausten wrote: > > One of the awesome things about web2py is of course the built-in and > well-documented resilience against a range of attack methods, but I was > wondering if anyone has attempted a methodical (w

[web2py] Re: Dangerous web2py object-reuse pattern?

As long as you do not use DAL to connect to couchdb then you do not need to worry about web2py closing the connections. You still have two problems: 1) thread safety, you may need to mutex lock the objects 2) threads and processes will be killed by the web server at will and therefore you have n

Re: [web2py] default function in a non default controller with args - routing

On 9 Jul 2012, at 1:29 PM, Francisco Costa wrote: > I'm using the Parameter-based system for routing > > In my routes.py I have this > > routers = dict( > > # base router > BASE = dict( > applications = ['admin', 'app', 'blog'], > default_application =

[web2py] Re: default function in a non default controller with args - routing

I think functions needs to be a dictionary of lists if you want to specify functions for multiple controllers: app = dict( controllers = ['default', 'user'], functions = {'default': ['index'], 'user': ['show', 'list']}, Anthony On Monday, July 9, 2012 4:29:07 PM

[web2py] Re: Any difference passing a string vs. a field for arg #2 in IS_IN_DB?

No. The code does str(self.field), which converts db.image.id to 'image.id' -- http://code.google.com/p/web2py/source/browse/gluon/validators.py#417. Anthony On Monday, July 9, 2012 4:42:39 PM UTC-4, MichaelF wrote: > > The doc shows two calling patterns for IS_IN_DB, the difference being the >

[web2py] Re: web2py vs ROR

Maybe I can answer your question by describing how I use Web2py. I begin with models. The DAL has so far provided all the functionality I need. That said, I also will need to implement a union query in the future and I don't think the DAL supports it. However, on this forum there was recentl

[web2py] with versioning how can you list the deleted records

How can I find the deleted records when using versioning? When I delete a record it is deleted from the table and appears in the archive table. Now I can run a query that looks for all records in the archive table that are not in the table. However is there a better way of identifying the delet

[web2py] Any difference passing a string vs. a field for arg #2 in IS_IN_DB?

The doc shows two calling patterns for IS_IN_DB, the difference being the type of the second positional argument: The example in section 3.6 shows: db.comment.image_id.requires = IS_IN_DB(db, db.image.id, '%(title)s') Section 6.5 has a table for default validators: IS_IN_DB(db,table.field,format

[web2py] default function in a non default controller with args - routing

Hi, I'm using the Parameter-based system for routing In my routes.py I have this routers = dict( # base router BASE = dict( applications = ['admin', 'app', 'blog'], default_application = 'app', map_hyphen = True, domains = {

Re: [web2py] Re: SQLFORM.grid id representation bug?

> > db.sessions.client_id.requires = IS_IN_DB(db, db.clients.id, '%(name)s') > > No, as I mentioned, you should *not* explicitly define the IS_IN_DB validator. You will get one automatically when you create a reference field. If the referenced table has a "format" attribute, then that format at

[web2py] Re: paymentech: post request

how about: import urllib2 r = urllib2.Request('https://orbitalvar1.paymentech.net/authorize:443', xml_request, {'Content-Type', 'application/PTI46', ...}) resp = urllib2.urlopen(r) see http://docs.python.org/library/urllib2.html On Sunday, July 8, 2012 6:44:12 PM UTC-7, Adi wrote: > > Thanks fo

Re: [web2py] Re: SQLFORM.grid id representation bug?

Hmm oke. I tried it on different ways. Now i use the PowerTable plugin and it's working. There is nothing wrong with the IS_IN_DB() validator as far as i can see. I use: db.define_table('clients', Field('number'), Field('name'), Field('created_o

[web2py] Re: web2py ajax function returns only non readonly fields

On Monday, July 9, 2012 11:58:45 AM UTC-4, Yuval wrote: > > To duplicate the fields once as a label and once as a hidden field? > Its doable, but not too classy, Tx. > Feel free to submit a patch. :-)

[web2py] Re: Upload file into DB without SQLFORM

Alright, finally I got it working by manually assigning file content to uploaded_data field. Looks like store() function does not actually store data if files are to be placed in DB rather than in filesystem. 2012. július 9., hétfő 19:32:06 UTC+2 időpontban Athelionas a következőt írta: > > Ok,

Re: [web2py] Re: SQLFORM.grid id representation bug?

On Monday, July 9, 2012 12:32:11 PM UTC-4, Remco K wrote: > > Thanks for the answers. > > This representation works perfectly when i show the content in a dropdown > so i think this has more to do with SQLFORM.grid... > The dropdown is controlled by the IS_IN_DB validator, not the field's "repre

[web2py] Re: Upload file into DB without SQLFORM

Ok, I read the book, but I still don't really know how should this be done. What I have is this table: db.define_table('files', Field('original_filename', 'string', required = True,notnull = True), Field('uploaded_file', 'upload', uploadfield = 'uploaded_data', re

Re: [web2py] Re: SQLFORM.grid id representation bug?

Thanks for the answers. This representation works perfectly when i show the content in a dropdown so i think this has more to do with SQLFORM.grid... 2012/7/9 Anthony > db.define_table('clients', > Field('number'), > > Field('name'), > format='%(n

Re: [web2py] problem with custom primarykey

On 07/09/2012 12:48 AM, Andrew wrote: > See the dot point > Keyed table can only refer are to other keyed tables. > You have a mixture of Id fields and keys. > I've fixed my issue using a unique index. I just wanted to make sure that there were no (iuser, imovie) duplicate tuples in my datased.

[web2py] Re: web2py ajax function returns only non readonly fields

To duplicate the fields once as a label and once as a hidden field? Its doable, but not too classy, Tx. On Monday, July 9, 2012 8:21:00 AM UTC-7, Anthony wrote: > > You might put the value in a hidden field as well. > > Anthony > > On Monday, July 9, 2012 11:09:50 AM UTC-4, Yuval wrote: >> >> The

[web2py] Has anyone done a detailed security analysis or attempted a methodical attack on web2py?

One of the awesome things about web2py is of course the built-in and well-documented resilience against a range of attack methods, but I was wondering if anyone has attempted a methodical (white-hat) attack to probe any potential weaknesses? Just out of interest :)

[web2py] Web2py JS problem with the dropdown arrows in top menu (submenu) not showing up anymore !!??

Hello, I went on vacation and now I am back to keep on thriving with my web2py pet project ! how is everyone doing ?? ... OK .. It is a small problem .. but a problem anyways ... the problem I am having is with the dropdown arrows managed by the web2py JS .. Let me elaborate a bit : --> in th

[web2py] Re: web2py ajax function returns only non readonly fields

You might put the value in a hidden field as well. Anthony On Monday, July 9, 2012 11:09:50 AM UTC-4, Yuval wrote: > > The ajax function is defined as: > ajax(url, [name1, name2, ...], target) > > where the 'name1' 'name2' are defined as ids of an input fields. > *This is working fine for fields

[web2py] Re: list:string & crud form entry -- what's the latest?

Well, by default, the list:string field type does get a special Javascript widget, though the functionality could probably be improved. After you enter an item in the initial text box, hit enter, and a new box should appear below it, and so on. There is no way to remove a box once created. Rega

[web2py] web2py ajax function returns only non readonly fields

The ajax function is defined as: ajax(url, [name1, name2, ...], target) where the 'name1' 'name2' are defined as ids of an input fields. *This is working fine for fields that are defined as:* * Field('first_name', label=T('First Name')) When the field is set to be read only, it is rendered as a l

[web2py] Re: Upload file into DB without SQLFORM

http://web2py.com/books/default/chapter/29/6#Manual-uploads On Monday, July 9, 2012 10:15:27 AM UTC-4, Athelionas wrote: > > What is the proper way of uploading a file without SQLFORM into the > following database table? > > db.define_table('files', > Field('original_filename', 's

[web2py] Re: Dangerous web2py object-reuse pattern?

I can make subscriber_pool threadsafe, can't I? The point is that I would like to have some objects to be persistent between requests, to avoid the cost of re-creating them each time. This is nothing that can be managed by the DAL. You could think of it as a long-to-setup object that I need to

[web2py] OpenID Server Implementations

Hi, I was looking to deploy an openid server which can be used for maintaining my user logins. This server can then interact with my web2py app for authenticating users. Any recommendations for any open source openid servers ? Added advantage if it can be deployed on to GAE. Thanks, Murtaza

[web2py] list:string & crud form entry -- what's the latest?

This has been an oft-disucssed topic. Just search for "list:string crud" But having just experienced the pain myself, and not easily locating the status of this issue, I felt compelled to ask for myself: Shouldn't list:string have a default interactive (jQuery OK) widget that is an expandable/

[web2py] Upload file into DB without SQLFORM

What is the proper way of uploading a file without SQLFORM into the following database table? db.define_table('files', Field('original_filename', 'string'), Field('file', 'upload', uploadfield='file_data'), Field('file_data', 'blob')) A simple inse

[web2py] Slightly OT: Python for iOS

FYI, this app just became free. I haven't tried it yet, but it looks like a fairly solid implementation. Nice just to have the docs at hand, and a Python prompt to play with. Python for iOS iOS Universal Python for iOS is a Python 2.7.2 environment for the iOS. 🐍 Features 🐍 ⇒ Interactive

[web2py] Re: Create a custom layout based on existing web site css

Simply copy all your static files in static/ Then copy your index.html into views/layout.html Edit layout.html and replace href="xyz" -> href="{{=URL('static','xyz')}}" src="xyz" -> src="{{=URL('static','xyz')}}" Edit the place where the content goes and add {{include}} Now you should have

[web2py] Re: Dangerous web2py object-reuse pattern?

I am not sure what class Subscriber does but, if it uses the DAL, than you code is problematic. The DAL is "smart" in the sense that it keep tracks of all connection open in certain thread and closes them all (or pools them) when the thread ends. By using a module, you store references to those

[web2py] Re: [Newbie] Using existing Mysql DB with web2py app

> > 1. Can I use web2py to connect to the existing DB? Is there any automated > way of creating the model classes from existing DB tables? Any specific > things to keep in mind? > http://code.google.com/p/web2py/source/browse/scripts/extract_pgsql_models.py

[web2py] Re: how to avoid (catch) sqllite operational error

The problem is that when you catch an OperationalError, you must rollback. Else the database does not allow commit anymore. On Sunday, 8 July 2012 22:55:43 UTC-5, Janath wrote: > > It worked :) Thank you > > On Sunday, July 8, 2012 6:47:59 PM UTC-5, Massimo Di Pierro wrote: >> >> try: >> >> excep

[web2py] [Newbie] Using existing Mysql DB with web2py app

Hi I am new to web development but have been trying my hands at various python frameworks and web2py looks very good. Now my problem is that there is an existing web application based on CakePHP and MySQL. While that application is complete in itself, the plan is to write an android application

[web2py] Re: SQLFORM.grid id representation bug?

db.define_table('clients', Field('number'), Field('name'), format='%(name)s') Then you don't have to explicitly define the IS_IN_DB validator, as sessions.client_id will get one by default with the format set to the db.clients format attribute. In

[web2py] Re: SQLFORM.grid id representation bug?

On Monday, 9 July 2012 14:35:41 UTC+2, Remco K wrote: > > Hi everyone, > > I'm working with SQLFORM.grid but I cant get the referenced table > representation to work. The only thing i get is the ID of the referenced > table(s): > > *db.py: * > db.define_table('clients', > Field('n

[web2py] SQLFORM.grid id representation bug?

Hi everyone, I'm working with SQLFORM.grid but I cant get the referenced table representation to work. The only thing i get is the ID of the referenced table(s): *db.py: * db.define_table('clients', Field('number'), Field('name') ) db.define_tabl

[web2py] Re: Working with custom form

> which web2py version? Do you have a custom auth_user table? Looks like > something wrong with the list of validators for a field containing the > IS_UPPER validator. This is on 1.99.7 stable. I do have two extra field to the auth_user table, and use a custom name instead of 'auth_user', bu

[web2py] Re: web2py vs ROR

Massimo, Appreciate your comments. As mentioned by you, web2py has packaged all the functionality needed by a web app in a single api, and I am finding this very interesting. This certainly allows one to create a web app pretty fast. The only remaining question is that how easy is it to pull

Re: [web2py] Re: Standalone DAL leaves mysql connections opened

No (or at least not me), the many connections are from the web navigator, that send many get / options or propfind requests for dav/svn, when i try only one time to access. Its the same if I use a dav or svn client, and with the file explorer included in the application they send many request.

Re: [web2py] Re: please help us test web2py

Paolo's bootstrap menu change looks OK to me. On Monday, July 9, 2012 6:38:41 PM UTC+12, backseat wrote: > > On Sun, 8 Jul 2012 23:31:31 -0700 (PDT), too...@gmail.com said: > > > +1 on removing it... > > The internet is covered with too many meaningless share buttons already. > > Surely the w

[web2py] Create a custom layout based on existing web site css

I am currently developing a web application using web2py. It is at the point where I want to customize the appearance to blend in with an existing html/templated site that I run - so I need to understand how to customize the web2py layout etc to make this happen. While there seems to be many te

[web2py] problem with custom primarykey

See the dot point Keyed table can only refer are to other keyed tables. You have a mixture of Id fields and keys.

Re: [web2py] increase column size

On 9 July 2012 09:27, Janath wrote: > when I have following: > > return dict(form=form, path=form.vars.rule_path, recs=recs) > > > and, even if the recs have one column, when I display, it does limit the > column size to some value as follows: > > rules.rule_name > branch_indivi... > bus_individ

[web2py] Dangerous web2py object-reuse pattern?

Hi, I am using the following pattern to use my libraries with web2py: some of my utilities are creating connections to databases where I have data that I need to serve with web2py. This data is not modeled with web2py models. In order to avoid re-creating these connections with every single req

[web2py] increase column size

when I have following: return dict(form=form, path=form.vars.rule_path, recs=recs) and, even if the recs have one column, when I display, it does limit the column size to some value as follows: rules.rule_name branch_indivi... bus_individua... bus_individua... psse32envset.py how can I inc