[web2py] Select image path and content from a db(table).select()

2017-08-08 Thread Luciano Laporta Podazza
Hello, I was wondering how to do a web service (json) to select all rows from a table, where there's an 'upload' field type and return them in JSON, with "upload" field data (images) encoded in base64. The problem I'm having is that when I do the db(table_name).select() I'm only getting the im

[web2py] SQLFORM.smartgrid() ui does not accept elements customization through dict() (SQLFORM.grid does)

2016-10-12 Thread Luciano Laporta Podazza
Hello! I tried to apply some css classes to smartgrid elements with no success. It seems that smartgrid ignores ui argument but grid does my controller: def index(): """ example action using the internationalization operator T and flash rendered by views/default/index.html or views/

[web2py] Re: Smartgrid search: How do I search on integers and linked tables?

2016-09-16 Thread Luciano Laporta Podazza
On Tuesday, September 6, 2016 at 11:37:00 AM UTC-3, Massimo Di Pierro wrote: > > You can customize smartgrid and make your own search function. By default > you cannot. > Thanks Massimo! > > On Thursday, 1 September 2016 20:34:27 UTC-5, Luciano Laporta Podazza > wrote:

[web2py] Smartgrid search: How do I search on integers and linked tables?

2016-09-01 Thread Luciano Laporta Podazza
Hello, 1. I noted that Smartgrid does not search on integers unless I select that specific field on the dropdown search widget menu, so I would like to know how to "enable" this by default so users can search by numbers too. 2. On the other hand, I would like to search on linked tables too. I

[web2py] Bug?: Spanish formatted dates won't store on database(english ones do)

2016-08-16 Thread Luciano Laporta Podazza
Hello, I'm working on a simple case file project and realized that working with english date format has no issues but if I use spanish ones(taking advantage of internacionalization) they don't get stored on database. Here is my controller: @auth.requires_login() def index(): """ example

Re: [web2py] Re: nginx setup: [Errno 13] Permission denied: '/root/.python-eggs'

2015-10-22 Thread Luciano Laporta Podazza
, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Atte Luciano Laporta Podazza -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: db.commit() taking too long to update records

2014-10-24 Thread Luciano Laporta Podazza
ed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/6z13PTcZ5io/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googleg

Re: [web2py] Re: db.commit() taking too long to update records

2014-10-23 Thread Luciano Laporta Podazza
; Anthony > > > On Wednesday, October 22, 2014 9:30:50 PM UTC-4, Luciano Laporta Podazza > wrote: >> >> Hi Niphlod, >> >> I did what you say and if I try doing the query through console it works >> perfectly and fast: >> >> >>> d

Re: [web2py] Re: db.commit() taking too long to update records

2014-10-22 Thread Luciano Laporta Podazza
By the way, I've already tried the SQL query manually and it works perfectly. I'm using Web2py 2.9.11 and I'm starting to think that perhaps there's an issue with web2py services. Any ideas?. Thanks On Wed, Oct 22, 2014 at 10:30 PM, Luciano Laporta Podazza < lucianop

[web2py] Re: db.commit() taking too long to update records

2014-10-22 Thread Luciano Laporta Podazza
Hi Niphlod, I did what you say and if I try doing the query through console it works perfectly and fast: >>> db._timings [('SET FOREIGN_KEY_CHECKS=1;', 0.0002541542053222656), ("SET sql_mode='NO_BACKSLASH_ESCAPES';", 0.0002338886260986328)] >>> db((db.alerts.alerts_id==1)&(db.alerts.archive

Re: [web2py] Re: Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-15 Thread Luciano Laporta Podazza
l!. Thanks for your support! On Mon, Oct 13, 2014 at 4:36 PM, Luciano Laporta Podazza < lucianopoda...@gmail.com> wrote: > Thanks Niphlod, > > I've just managed to make any python version work (< 2.7.5), web2py runs > the Python version I want but the error still remai

Re: [web2py] Re: Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-13 Thread Luciano Laporta Podazza
... web2py can't choose what python > version to run at runtime.... > > On Sunday, October 12, 2014 7:39:16 PM UTC+2, Luciano Laporta Podazza > wrote: >> >> It seems to. >> >> I've tried using pyenv to switch to Python 2.7.5 (the one it works), >>

Re: [web2py] Re: Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-12 Thread Luciano Laporta Podazza
th no luck (actually I'm learning how to do it :P) Any suggestions?. Thanks! On Sun, Oct 12, 2014 at 10:07 AM, Niphlod wrote: > uhm, could be something related to > > http://bugs.python.org/issue21720 > > > > > On Sunday, October 12, 2014 1:53:40 AM UTC+2, Luciano Lapo

[web2py] Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-11 Thread Luciano Laporta Podazza
Hello, I'm using locally web2py (*2.9.8*) + Shopify API (2.0.4) on Mac OS X 10.9.5 (Python *2.7.5*) and this code works perfectly: from gluon.tools import Service service = Service() import gluon.contrib.simplejson as json def call(): session.forget() return service() @service.json d

[web2py] Re: Customize SQLFORM.grid

2014-09-10 Thread Luciano Laporta Podazza
eers! On Wednesday, September 10, 2014 11:36:06 AM UTC-3, Anthony wrote: > > Are you saying you don't want each record in an HTML table row but instead > want to display each record as a card? There's no built-in way to do that, > but you can hack the returned grid object

[web2py] Customize SQLFORM.grid

2014-09-09 Thread Luciano Laporta Podazza
Hello, I would like to take advantage of SQLFORM.grid search, listing and pagination capabilities to generate a listing from a table, but I need to customize the resulting rows like this:

Re: [web2py] Re: db.commit() taking too long to update records

2014-09-09 Thread Luciano Laporta Podazza
;web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/6z13PTcZ5io/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.

Re: [web2py] Re: db.commit() taking too long to update records

2014-09-09 Thread Luciano Laporta Podazza
ic/web2py/6z13PTcZ5io/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Atte Luciano Laporta Podazza -- Resources: - http://web2py.co

Re: [web2py] Re: db.commit() taking too long to update records

2014-09-09 Thread Luciano Laporta Podazza
gt; https://groups.google.com/d/topic/web2py/6z13PTcZ5io/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Atte Luciano Laporta Podazza --

[web2py] db.commit() taking too long to update records

2014-09-09 Thread Luciano Laporta Podazza
Hello, I'm having a strange issue, I have a website that queries data through an ajax call from the server using web2py json services every *5 seconds*. Then from the client I can update some data to the server with this: @service.json def block_user(): data = json.loads(request.body.read()

Re: [web2py] Re: Appadmin redirect after upgrading to 2.9.7

2014-09-07 Thread Luciano Laporta Podazza
>> administration page in a app. >> >> Le dimanche 7 septembre 2014 01:19:31 UTC+2, Luciano Laporta Podazza a >> écrit : >>> >>> Same issue :(, as mentioned before, tried testing default apps and my >>> app and it redirects to admin page. >>>

Re: [web2py] Re: Appadmin redirect after upgrading to 2.9.7

2014-09-06 Thread Luciano Laporta Podazza
Same issue :(, as mentioned before, tried testing default apps and my app and it redirects to admin page. On Sat, Sep 6, 2014 at 8:14 PM, Luciano Laporta Podazza < lucianopoda...@gmail.com> wrote: > Right now! :), I'll get back to you with results. > > Cheers. > > >

Re: [web2py] Re: Appadmin redirect after upgrading to 2.9.7

2014-09-06 Thread Luciano Laporta Podazza
eing the code of appadmin.py (assuming is the latest from 2.9.7) the >>>> redirection is made on line 54. Look at those conditions and add a few log >>>> (or print) statements to pinpoint the root cause. >>>> >>>> On Friday, September 5, 2014 10:00:0

Re: [web2py] Re: Appadmin redirect after upgrading to 2.9.7

2014-09-05 Thread Luciano Laporta Podazza
I've just get back to 2.9.5 and appadmin works. I'm confused :P On Fri, Sep 5, 2014 at 4:59 PM, Luciano Laporta Podazza < lucianopoda...@gmail.com> wrote: > Hi Niphlod, > > No, I'm working locally and no proxies at all. Why you ask? > > > On Fri, Sep 5, 20

Re: [web2py] Re: Appadmin redirect after upgrading to 2.9.7

2014-09-05 Thread Luciano Laporta Podazza
Hi Niphlod, No, I'm working locally and no proxies at all. Why you ask? On Fri, Sep 5, 2014 at 4:58 PM, Niphlod wrote: > are you behind a proxy ? > > > On Friday, September 5, 2014 9:34:12 PM UTC+2, Luciano Laporta Podazza > wrote: >> >> Hello, >> &

[web2py] Appadmin redirect after upgrading to 2.9.7

2014-09-05 Thread Luciano Laporta Podazza
Hello, I was developing an application with web2py 2.9.5-trunk+timestamp.2014.03.29.21.54.41 and appadmin worked fine until I upgraded to latest 2.9.7. Now when I access appadmin for ANY app(welcome, examples, my app, etc) it redirects to admin and nothing happens. Tried cleaning everything,

Re: [web2py] Re: Social Login - Twitter logs out plus some other issues- web2py 2.8.2 / Mac OS X 10.9.1

2014-02-17 Thread Luciano Laporta Podazza
ontrollers? I > am facing the same issue. > > Regards, > > Tito > > > On Mon, Dec 23, 2013 at 2:06 PM, Luciano Laporta Podazza < > lucianopoda...@gmail.com> wrote: > >> Thanks for the advice Leonel!, >> >> You're totally right, I should

[web2py] Re: New record creates on Select?

2014-01-25 Thread Luciano Laporta Podazza
> not a bug. By default, SQLFORM.process() does an insert. To avoid that, you > could do SQLFORM.process(..., dbio=False), or just do SQLFORM.validate() > instead (.validate doesn't do an insert by default). > > Anthony > > On Saturday, January 25, 2014 5:57:58 PM UT

[web2py] New record creates on Select?

2014-01-25 Thread Luciano Laporta Podazza
Hello, I created a form(SQLFORM) to perform a search(without using crud.search) and for some reason, every time I do a search, a new record is created with default values. I really don't know if I'm doing something wrong or is it a bug. Tested with Web2py 2.8.2 on Mac OS X 10.9.1 and MySQL 5. A

[web2py] Social Login - Twitter logs out plus some other issues- web2py 2.8.2 / Mac OS X 10.9.1

2013-12-22 Thread Luciano Laporta Podazza
Hello, I'm trying to implement Social Login following this example exactly as it shows here: https://groups.google.com/forum/#!topic/web2py/S9ukjWz6qMA Facebook works well, but I'm having some issues: 1. Twitter login works fine, but when it returns from twitter's login page to my web2py app(

Re: [web2py] OAuth2 + Twitter 'module' object has no attribute 'Consumer' error

2013-12-21 Thread Luciano Laporta Podazza
bout the error check that you have installed the above package on your > system. You can do so in a python shell: > > $ python > >>> import oauth2 > >>> consumer = oauth2.Consumer > >>> print consumer > > > > > 2013/12/21 Luciano Laporta Po

[web2py] OAuth2 + Twitter 'module' object has no attribute 'Consumer' error

2013-12-21 Thread Luciano Laporta Podazza
Hello, I've been trying to integrate Facebook/Twitter login with Web2py 2.8.2-stable and OAuth2(the built-in oauth20_account.py) using this example: https://groups.google.com/forum/#!topic/web2py/S9ukjWz6qMA Facebook login works but when I try the Twitter example I get this traceback: Traceb

Re: [web2py] Re: web2py + exceptions(tickets) service?

2013-02-15 Thread Luciano Laporta Podazza
(or at least the > ideas :P) > > -- > > --- > 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.

[web2py] Re: web2py + exceptions(tickets) service?

2013-02-14 Thread Luciano Laporta Podazza
fired by your app, web2py has already all the bits you need. > Thanks for the answer Niphlod, but didn't understand the last part about being alerted(besides taking a look at the admin app). Cheers! > > On Thursday, February 14, 2013 5:00:24 PM UTC+1, Luciano Laporta Podazza

[web2py] web2py + exceptions(tickets) service?

2013-02-14 Thread Luciano Laporta Podazza
Hello!, I would like to know if there's something like http://www.exceptional.io but with support for web2py?. 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, sen

Re: [web2py] Re: Compare row objects inside a for... in loop

2013-01-22 Thread Luciano Laporta Podazza
i in range(len(rows)-1): > > > Anthony > > On Tuesday, January 22, 2013 8:17:10 AM UTC-5, Luciano Laporta Podazza > wrote: >> >> Hello, >> >> I've been searching a lot about this but couldn't find anything so sorry >> for this basic question. >

[web2py] Compare row objects inside a for... in loop

2013-01-22 Thread Luciano Laporta Podazza
Hello, I've been searching a lot about this but couldn't find anything so sorry for this basic question. How can I compare an actual row object with the next one inside a for...in loop? Thanks in advance! --

Re: [web2py] Re: Strange behavior storing data - web2py 2.3.2 - Mac OS X 10.7.5

2013-01-18 Thread Luciano Laporta Podazza
ocale), due that facebook users can be es_LA, es_ES, en_US, etc; the date formats are different so now I'm doing some research about how to deal with them and convert them automatically to db 'date' format: -MM-DD. Lot of thanks for your help :) -- Atte Luciano Laporta Podazza --

Re: [web2py] Strange behavior storing data - web2py 2.3.2 - Mac OS X 10.7.5

2013-01-14 Thread Luciano Laporta Podazza
On Jan 14, 2013, at 2:45 PM, Massimo Di Pierro wrote: > You say "This was actually working and I didn't modified anything(really)." > did you upgrade or did it simply stopped working? It simply stopped working. > > On Monday, 14 January 2013 05:19:05 UTC-6, Lu

[web2py] Strange behavior storing data - web2py 2.3.2 - Mac OS X 10.7.5

2013-01-14 Thread Luciano Laporta Podazza
Hello, I've been experimenting a really annoying issue that came up from nowhere 'cause the app was working perfectly. This is the scenario: A mobile app user(iOS) enter his credentials on Facebook and gets the corresponding auth token and personal data(JSON). The mobile app sends for the first

Re: [web2py] Re: Loading modules fails - web2py 2.1.1(and earlier) / python 2.7.1 / Mac OS X

2012-10-20 Thread Luciano Laporta Podazza
gt; > On Saturday, 20 October 2012 11:32:55 UTC-5, Luciano Laporta Podazza wrote: >> >> Hello Massimo!, comments inline. >> >> On Saturday, October 20, 2012 11:43:43 AM UTC-3, Massimo Di Pierro wrote: >>> >>> I am very puzzled but this. It should not be n

[web2py] Re: Loading modules fails - web2py 2.1.1(and earlier) / python 2.7.1 / Mac OS X

2012-10-20 Thread Luciano Laporta Podazza
Hello Massimo!, comments inline. On Saturday, October 20, 2012 11:43:43 AM UTC-3, Massimo Di Pierro wrote: > > I am very puzzled but this. It should not be necessary. Does the code > below work for you? > > $ python web2py.py -S welcome > (InteractiveConsole) > >>> import simplejson > If I use

[web2py] Re: Loading modules fails - web2py 2.1.1(and earlier) / python 2.7.1 / Mac OS X

2012-10-19 Thread Luciano Laporta Podazza
JSON parser try: import gluon.contrib.simplejson as json And that's all. Hope it helps anybody! On Thursday, October 18, 2012 1:43:29 PM UTC-3, Luciano Laporta Podazza wrote: > > Hello, first of all thank you Massimo and you people for this awesome > framework! I'm in love wi

[web2py] Loading modules fails - web2py 2.1.1(and earlier) / python 2.7.1 / Mac OS X

2012-10-18 Thread Luciano Laporta Podazza
Hello, first of all thank you Massimo and you people for this awesome framework! I'm in love with it! :D I've tried to load some facebook modules and none of them works, at least on Mac OS. This is what I did: 1. Get facebook api from one of these repos: https://github.com/sciyoshi/pyfacebook/