Re: [web2py] Re: How to create a hyperlink from a display field in sqlForm?

2013-07-31 Thread Massimo Di Pierro
Should be: db.TaxonomyDetail.objectID.represent = lambda id, record:A(record.objectID, _target = "_blank", _href = URL('manage_object_super_type',id)) On Tuesday, 30 July 2013 12:25:58 UTC-5, Alex Glaros wrote: > > Okay...I have this so far > db.TaxonomyDetail.objectID.represent = la

[web2py] Re: web2py financing

2013-07-31 Thread Massimo Di Pierro
Good question. We all work on it on our spare time. I used to take donations online but at this time I am not. As far as I am concerned I am lucky because although the university does not finance the project, they give me flexibility to work on ay project I like as long as I publish and web2y g

[web2py] Re: Access web2py app running on a remote server's localhost

2013-07-31 Thread Massimo Di Pierro
Start it with -i 0.0.0.0 -p 80 and you will be able to access remotely at http:/// On Tuesday, 30 July 2013 17:11:14 UTC-5, curiouslearn wrote: > > Hello, > > I have a droplet on digitalocean running Ubuntu precise. I installed > web2py using the source and then I started the server using python

[web2py] Encrypt table and search in fields

2013-07-31 Thread Ivan Gazzola
I'm trying to use this https://groups.google.com/d/msg/web2py/uGFQD0PBefQ/Zi-SPOLVSXIJ for encrypting data in a sqlite table. I need to search in one field with 'like' operator for buil a ajax list, i use this function: def ajaxlivesearch(): partialstr = request.vars.values()[0] query =

Re: [web2py] Re: How to create a hyperlink from a display field in sqlForm?

2013-07-31 Thread Alex Glaros
it looks almost right Massimo, but I get this error 'Row' object has no attribute 'objectID' On Wednesday, July 31, 2013 12:29:48 AM UTC-7, Massimo Di Pierro wrote: > > Should be: > > db.TaxonomyDetail.objectID.represent = lambda id, record:A(record. > objectID, _target = "_blank", _href = URL('

[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Massimo Di Pierro
You cannot search inside an encrypted field. If you could it would not be encrypted. the best you can do is encrypt your search string too and check that the encrypted value is equal to the encrypted search string. Anyway, even if you succeed in doing this is means that all records are encrypte

Re: [web2py] Re: How to create a hyperlink from a display field in sqlForm?

2013-07-31 Thread Alex Glaros
Here is how the current version looks that generates the row has no attrib. error: def manage_taxonomy_detail(): db.TaxonomyDetail.objectID.represent = lambda id, record:A(record.objectID, _target = "_blank", _href = URL('manage_object_super_type',id)) query = ((db.Taxonomy.id == db.TaxonomyD

[web2py] New conditional fields in SQLFORM.factory?

2013-07-31 Thread Dragan Matic
Is it possible to use conditional fields introduced in 2.5.1 with SQLFORM.factory and what would be the syntax? -- --- 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 emai

[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Ivan Gazzola
I need to encrypt data (medical data!) in db because if I encode the fs when mounted this remains visible and for a web app the fs is always mounted. I would like to protect the data in case of access to the fs. Any tips? thx Ivan Il giorno mercoledì 31 luglio 2013 10:33:00 UTC+2, Massimo Di

[web2py] Re: web2py financing

2013-07-31 Thread Alex
good to know. I'm already telling everyone how great web2py is :) I can develop a new project in web2py for a company I'm working for. So I guess the best way to support you financially is to buy the web2py book. Alex Am Mittwoch, 31. Juli 2013 09:58:24 UTC+2 schrieb Massimo Di Pierro: > > Good

[web2py] list of dicts in request.args, dicts treated as strings

2013-07-31 Thread Antonis Konstantinos Tzorvas
I have created a function which returns from a given url some info parsed from the file in the url http://url/file.txt and it returns something like this parser.py output: _name: Test1 _data: [{"year": 2013, "jan": 50, "feb": 60}, {"year": 2012, "jan": 40, "feb": 30}] def add(): .. item =

[web2py] Re: list of dicts in request.args, dicts treated as strings

2013-07-31 Thread Antonis Konstantinos Tzorvas
found a solution, using ast.literal_eval data = request.get_args['_data'] print data ## OUT: ["{"year": 2013, "jan": 50, "feb": 60}", "{"year": 2012, "jan": 40, "feb": 30}"] ## print ast.literal_eval(data[0]) ## OUT: {"year": 2013, "jan": 50, "feb": 60} ## <- class: dict so with a simple for

[web2py] Re: Encrypt table and search in fields

2013-07-31 Thread Massimo Di Pierro
This is not a web2py issue. This is a general design issue. Unless you encrypt each record with a different key that is only known to the owner of each individual records (his password for example), than the web app has access to all records because has the ability decrypt them all. In this cas

[web2py] SQLFORM Update MongoDB

2013-07-31 Thread Eduard Thamm
Hello everyone! I am rather new to web2py so this may be an obvious thing, but please bear with me. I wrote a function to update a document in my MongoDB which looks like this: record = db(db.stuff.id == request.vars.id).select().first() form = SQLFORM(db.stuff, record) which works fine the fi

[web2py] Re: list of dicts in request.args, dicts treated as strings

2013-07-31 Thread Tim Richardson
I think you have discovered why json was invented ... -- --- 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

[web2py] Accessing db from the module

2013-07-31 Thread Tim Richardson
Did you read the book's explanation of the execution environment? If we answer the question in that context we can help make the book clearer. -- --- 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: Access web2py app running on a remote server's localhost

2013-07-31 Thread Tim Richardson
I've done this too. I recommend doing an ubuntu server installation, then read the book's deployment recipe section for ubuntu server. There's a script which sets up everything including ssl which you will need to access web2py admin. -- --- You received this message because you are subscrib

[web2py] session verify dynamics

2013-07-31 Thread lucas
so, please allow me to clarify, because TCP/IP is connectionless, cookies were implemented to give the client and server a software-based connection by allowing the client to send back its state to the server and the server can read and process that state to know what to do in the next step. c

Re: [web2py] Re: How to create a hyperlink from a display field in sqlForm?

2013-07-31 Thread Johann Spies
Hallo Alex, On 30 July 2013 19:25, Alex Glaros wrote: > Okay...I have this so far > db.TaxonomyDetail.objectID.represent = lambda ObjectSuperType,record > : A(db.TaxonomyDetail.objectID, _target = "_blank", _href = > 'manage_object_super_type') > > But > > 1. record: A(db.TaxonomyDetail

[web2py] Re: check_client=True

2013-07-31 Thread Vikas Gupta
I need to disable the user from logging in multiple times from different machines... If he is logged in on one machine with ip A, and he tries to login on another machine with ip B, either his A's session should be expired or his attempt on B should fail. this did not work with check_client...

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Alan Etkin
> > which works fine the first time round but on submitting the form complains > about a TypeError, expecting a String but getting an ObjectId. > I'm trying a similar code with a scaffolding app and cannot reproduce the error. The mongodb adapter is still marked as experimental and you might f

[web2py] Re: How to create a hyperlink from a display field in sqlForm?

2013-07-31 Thread Alex Glaros
not sure what the function syntax should be. I want to select and display one record. Here is the code so far, which invokes a compile error "invalid syntax" db.TaxonomyDetail.objectID.represent = lambda id, record:A(record.TaxonomyDetail.objectID, _target = "_blank", _href =URL(r = request

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Alan Etkin
> record = db(db.stuff.id == request.vars.id).select().first() > form = SQLFORM(db.stuff, record) > My bad. Now I used request.vars.id to retrieve the record and got the same error. It does not look ok that request stores an ObjectId. It seems there's a bug about form processing and the mongod

[web2py] Re: check_client=True

2013-07-31 Thread Niphlod
can I see how you are using check_client in your code, please ? On Wednesday, July 31, 2013 1:59:02 PM UTC+2, Vikas Gupta wrote: > > I need to disable the user from logging in multiple times from different > machines... If he is logged in on one machine with ip A, and he tries to > login on anot

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Alan Etkin
The problem is that on sqlform submission, the request.vars.id attribute stores a list with two id strings (where it should contain a single string). Is there any reason an id field can be specified as a two string list after form submission? If not, there's a bug in the mongodb adapter. -- -

[web2py] Re: session verify dynamics

2013-07-31 Thread Niphlod
that's pretty much correct. because of http is stateless by default, a cookie is used to track whatever needs to "survive" between page loads. web2py by default stores in the cookie a "pointer" to the session "contents", that can be stored in a file, in a db, in memcache or in redis. It saves t

[web2py] Re: session verify dynamics

2013-07-31 Thread Anthony
> web2py automatically and always sets up a new session, or uses an existing > one, if the client either does not send back a cookie containing the > session id or it does, respectively. correct? > Yes, but note that it will not actually save the session unless something is added to it or ch

[web2py] Re: Accessing db from the module

2013-07-31 Thread Anthony
Show some code. On Tuesday, July 30, 2013 11:19:49 PM UTC-4, Mark Finkelstein wrote: > > I've been using current to access the db in my modules, but I would like > to modularize my modules a bit so that I don't rely as much on current. I > was wondering why db seems to not be accessible from the

[web2py] Re: Accessing db from the module

2013-07-31 Thread Mark Finkelstein
Well here's some code: def tags_link_insert(self, table_id, table_name, tags): if not isinstance(table_name, str): raise TypeError("table_name must be of type str") if not isinstance(tags, (list, tuple)): tags = [tags] tagstb = self.tags_table

[web2py] Using grid on db.auth_user table switches me back with 'not authorized' flash message ...

2013-07-31 Thread David Marko
I try to use SQLFORM.grid(db.auth_user) in my controller action. But this line simply redirects me back do default action with 'not authorized' flash message. Grid with my custom tables are working fine. Is there any restriction on auth tables? -- --- You received this message because you ar

[web2py] Re: session verify dynamics

2013-07-31 Thread lucas
and in the case of file-based sessions, each session is stored as its own file under the subdirectory called sessions under the application subdirectory. nice. thanx for the confirmation. it helps to understand the flow of data in all of these interactions. lucas -- --- You received this

[web2py] Re: Free opensource Janrain alternative - Python Social auth

2013-07-31 Thread Quint
I made an attempt to do this myself but i need some expert opinions about it. https://code.google.com/p/web2py/issues/detail?id=1495 On Friday, June 21, 2013 11:34:26 AM UTC+2, Leonel Câmara wrote: > > +1 on this one. > > Social login support is a huge pain on the ass. The social network > hi

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Alan Etkin
Ok. This is not a mongodb specific issue. It seems that it is caused by the way you are processing forms. The id value is submitted twice (with get and post methods) and when web2py parses the request, the id field submitted is converted to a bar encoded list of duplicated values instead of the

[web2py] Re: Accessing db from the module

2013-07-31 Thread Anthony
Is the module being accessed as part of an HTTP request to the app, or via an external script? On Wednesday, July 31, 2013 9:50:56 AM UTC-4, Mark Finkelstein wrote: > > Well here's some code: > > def tags_link_insert(self, table_id, table_name, tags): > if not isinstance(table_name, str):

[web2py] Re: Accessing db from the module

2013-07-31 Thread Mark Finkelstein
As part of an HTTP request. On Wednesday, July 31, 2013 11:11:19 AM UTC-4, Anthony wrote: > > Is the module being accessed as part of an HTTP request to the app, or via > an external script? > > On Wednesday, July 31, 2013 9:50:56 AM UTC-4, Mark Finkelstein wrote: >> >> Well here's some code: >>

[web2py] Re: bootstrap 3

2013-07-31 Thread VP
not quite compatible with web2py yet. Navbar are all messed up. Possibly other things as well. -- --- 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+un

[web2py] PunchOut cXML system with web2py

2013-07-31 Thread Willoughby
Anybody using web2py for processing cXML as used in a PunchOut scenario? I'm guessing ElementTree is the best option, but I'm willing to learn from the pain of others! Any opinions appreciated... -- --- You received this message because you are subscribed to the Google Groups "web2py-users" g

[web2py] packing apps as desktop native apps (windows/os x)

2013-07-31 Thread VP
I know there're some recipes in the book in deploying your applications as windows binaries (how about Mac???) But I think it'd be nice to have a feature in admin where one click can deploy your application as a native app. I think this will make web2py even more interesting. -- --- You re

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Eduard Thamm
Hi! First of all, thanks for looking in to it. Just to make sure I understand the problem. First call happens via get on submission a post happens, since those are different web2py converts the id parameter to a list since it can for some reason not determine what else to do. Is that near the

[web2py] Re: packing apps as desktop native apps (windows/os x)

2013-07-31 Thread Niphlod
native app meaning ? The process is roughly the same: get the binaries, copy your app using optionally init as the appname and zip it all ? On Wednesday, July 31, 2013 7:15:46 PM UTC+2, VP wrote: > > I know there're some recipes in the book in deploying your applications as > windows binaries (h

[web2py] Re: PunchOut cXML system with web2py

2013-07-31 Thread Niphlod
unfortunately my experience is only with edi parsers that are much harder to build than the cxml counterparts. A quick search on google reveals only one pretty old module to deal with cxml, but it looks like a very thin wrapper on top of standard xml parsing libraries. However, I sweated a lot

[web2py] Re: bootstrap 3

2013-07-31 Thread Niphlod
I think what you meant is "not compatible with the current welcome app". Lots of things changed but all changes are documented pretty well. I'd wait for the final release before implementing a new welcome app based on bootstrap 3. On Wednesday, July 31, 2013 5:56:39 PM UTC+2, VP wrote: > > not

[web2py] Re: Using grid on db.auth_user table switches me back with 'not authorized' flash message ...

2013-07-31 Thread Massimo Di Pierro
This usually happens when you have request.args that should not be there. The grid wants to control the args and validate them, unless you tell it not to. If you can show us the URL and the action, I can probably be more precise. On Wednesday, 31 July 2013 09:22:53 UTC-5, David Marko wrote: > >

[web2py] Re: Free opensource Janrain alternative - Python Social auth

2013-07-31 Thread Massimo Di Pierro
Thank you. Will look at it asap. On Wednesday, 31 July 2013 09:45:39 UTC-5, Quint wrote: > > I made an attempt to do this myself but i need some expert opinions about > it. > > https://code.google.com/p/web2py/issues/detail?id=1495 > > > > On Friday, June 21, 2013 11:34:26 AM UTC+2, Leonel Câmara

[web2py] Re: packing apps as desktop native apps (windows/os x)

2013-07-31 Thread VP
by "native" I mean executables that are run without invoking python (at least explicitly). You can click on it and it runs, so to speak. On Wednesday, July 31, 2013 2:13:10 PM UTC-5, Niphlod wrote: > > native app meaning ? The process is roughly the same: get the binaries, > copy your app using

[web2py] Is saving "upload" data in a database broken?

2013-07-31 Thread Joe Barnhart
I can't seem to get the feature to work. Looking at the code in DAL, I don't see how it could possibly work as documented in the the book. Did something change? Does anyone use this feature? Note: this does not affect GAE since that is handled automatically, and still works as far as I know

[web2py] Re: packing apps as desktop native apps (windows/os x)

2013-07-31 Thread Niphlod
so you need all packaged inside a single executable as a new feature or you just want something that "automatize" what is written yet in the book ? On Wednesday, July 31, 2013 9:28:04 PM UTC+2, VP wrote: > > by "native" I mean executables that are run without invoking python (at > least explicit

[web2py] Re: Is saving "upload" data in a database broken?

2013-07-31 Thread Niphlod
just tested on trunk AND 2.5.1, with SQLite, MySQL and Postgres, and all works fine. Are you sure that is not something peculiar to your app (i.e. you can reproduce the bug consistently in a fresh one) ? On Wednesday, July 31, 2013 9:29:35 PM UTC+2, Joe Barnhart wrote: > > I can't seem to get th

[web2py] Re: SQLFORM Update MongoDB

2013-07-31 Thread Alan Etkin
> > First call happens via get on submission a post happens, since those are > different web2py converts the id parameter to a list since it can for some > reason not determine what else to do. > It seems to me that, when you self-submit the form to the same action, the uri keeps the get vars,

[web2py] Re: Accessing db from the module

2013-07-31 Thread Mark Finkelstein
Nevermind, thanks for all the help, I realized where the issue lies and it was rather foolish in the end. (I was looking at an older, archived database) On Wednesday, July 31, 2013 11:39:52 AM UTC-4, Mark Finkelstein wrote: > > As part of an HTTP request. > > On Wednesday, July 31, 2013 11:11:19

[web2py] Re: Is saving "upload" data in a database broken?

2013-07-31 Thread Niphlod
PS: make sure to read http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#More-on-uploads I'm guessing you're not using forms to store the file (in which case, your code doesn't need any changes passing from storing into the /uploads/ folder vs storing in the 'blob' f

[web2py] Re: Uploading data as blob -- hitting a brick wall

2013-07-31 Thread Niphlod
answered in the other thread. This is just another case where packing a simple app and attaching to the thread showing exactly what your code does would have saved (you and me) lots of headaches :-P -- --- You received this message because you are subscribed to the Google Groups "web2py-user

[web2py] Re: web2py financing

2013-07-31 Thread Paulo
It's indeed a good question, because I cannot imagine how much time and effort have been invested by a lot of people in this great wonder called web2py! It helped me a lot jumping from PHP to Pyhon world, I tried some frameworks but web2py was love at first sight, it is so well designed that it

[web2py] Re: web2py financing

2013-07-31 Thread Alan Etkin
> PS: I have some projets done with web2py, is there any place where the > community can share projets done with the framework, to show what it is > capable of? > There's the new web2pyslices.com packages content type: https://groups.google.com/d/msg/web2py/aMSZgFLWia8/atzBu7HLS2MJ Other re

[web2py] Quick contract job

2013-07-31 Thread davedigerati
I have been learning web2py for a project and while I am really enjoying it I am up against a deadline for my client and looking for help. I would like to hire someone (preferably one of the frequent contributors as a way of saying thank you, this is a great community;) to take care of one stic

[web2py] POSTing application/json request to web2py

2013-07-31 Thread Ray (a.k.a. Iceberg)
To whom it may concern: I tried posting vars in json format, with content-type: application/json header, to my web2py application. When the above test is run on my laptop, i.e. requests are sent directly to web2py's rocket web server, recent web2py (the 2.5.1-stable) can successfully decode th