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

2018-03-18 Thread Paolo Valleri
@nbush would you open an issue on https://github.com/web2py/web2py/issues. It seems that languages files were wrongly updated into decoded messages. see https://github.com/web2py/web2py/commit/9263f8c4c3be7dd3ac0d1e9948c23b52f10db0d0#diff-59abf7aaebbac65b540eaebf36870ec6 Paolo 2018-03-11 20:45 G

Re: [web2py] Re: 50x performance improvement for web2py in TechEmpower Web Framework Benchmarks

2017-12-05 Thread Paolo Valleri
Anthony, is it possible to add py3 to the tests suite (for both standard and optimized apps) ? Paolo 2016-11-22 14:55 GMT+01:00 Mark Graves : > That is truly strange. Seems to be a distinct confound. > > Greatly appreciated work. > > > > On Tue, Nov 22, 2016 at 7:27 AM, Anthony wrote: > >> On

[web2py] Re: web2py 2.15.0b1

2017-07-10 Thread Paolo Valleri
Massimo, regarding minification see https://github.com/web2py/web2py/pull/1658, hopefully it fixed the reported issue. On Monday, July 10, 2017 at 10:28:44 AM UTC+2, Massimo Di Pierro wrote: > > Thanks for reporting these issues. > > I think except for minification they have all been resolved. a

Re: [web2py] db structure graphical analysis tool

2017-07-08 Thread Paolo Valleri
Hi Jurgis, web2py master has recently switched from pygraphviz to a js based solution. I would suggest you to adapt your change with current master branch and then publish a PR for an integration. Paolo On Friday, July 7, 2017 at 3:35:35 PM UTC+2, Ramos wrote: > > +1 good job > > 2017-07-07 12:

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread Paolo Valleri
Hi Stifan, regarding _before_insert open an issue on https://github.com/web2py/pydal with the example you posted for the other issues, open an issue on https://github.com/web2py/web2py Paolo On Thursday, July 6, 2017 at 2:20:25 AM UTC+2, 黄祥 wrote: > > tried to build from scratch with minimal cod

Re: [web2py] Re: [REMEMBER_ME] Not working

2017-05-05 Thread Paolo Valleri
I've just tried welcome app with current master branch and 'remember me' worked well. Would you test it as well? Paolo 2017-05-05 11:32 GMT+02:00 : > Please help me > > > Le mercredi 3 mai 2017 17:14:10 UTC+2, Paolo Valleri a écrit : >> >> which web2py v

[web2py] Re: [REMEMBER_ME] Not working

2017-05-03 Thread Paolo Valleri
which web2py version are you using? would you post the html of the 'remember me' input tag Paolo On Wednesday, May 3, 2017 at 10:31:23 AM UTC+2, sunda...@gmail.com wrote: > > Hello Anthony, > > Yeah but even if i took it off, it doesnt work at all ... or even when i > wrote 3600*24*30 ... > > >

[web2py] Re: update_or_insert only returns id if created not updated

2017-04-19 Thread Paolo Valleri
Actually I don't know if pydal is supposed to be backward compatible. On Wednesday, April 19, 2017 at 1:04:45 AM UTC+2, Anthony wrote: > > On Tuesday, April 18, 2017 at 3:33:31 PM UTC-4, Paolo Valleri wrote: >> >> It should work. Try to open an issue on https://github.co

[web2py] Re: update_or_insert only returns id if created not updated

2017-04-18 Thread Paolo Valleri
It should work. Try to open an issue on https://github.com/web2py/pydal or a pull request with the necessary change it could be something like, new_id = record[self._id.name] Paolo On Tuesday, April 18, 2017 at 12:58:22 PM UTC+2, Ramos wrote: > > why? > > https://github.com/web2py/pydal/blob/

[web2py] Re: delete record confirmation dialog

2017-04-18 Thread Paolo Valleri
At the moment is not possible to change it directly in grid or smartgrid. This is because the javascript variable is fixed, assigned in https://github.com/web2py/web2py/blob/master/applications/welcome/views/web2py_ajax.html and then used in https://github.com/web2py/web2py/blob/master/applicat

Re: [web2py] Re: use memcache

2017-04-12 Thread Paolo Valleri
you have to clone your fork, which I guess is https://github.com/sugizo/web2py then follow the same steps, at the end, from the github website create a PR. Mind that your fork (https://github.com/sugizo/web2py) is really out of date, update it before everything else. Paolo 2017-04-12 12:40 GMT+0

Re: [web2py] Re: use memcache

2017-04-11 Thread Paolo Valleri
Regarding the PR, online there are many tips to help you, in short: - fork web2py - create a new branch (called for example: 'fix_memcache_appadmin') - apply the change we discussed - commit the change with a clear message - push only the new branch - on github, click Pull request and compare web2p

Re: [web2py] Re: use memcache

2017-04-11 Thread Paolo Valleri
Glad the change fixed the first issue, would you submit a PR https://github.com/web2py/web2py/pulls? Regarding the second error, post the whole traceback here Paolo 2017-04-11 0:11 GMT+02:00 黄祥 : > *change gluon/contrib/memcache/__init__.py* > class MemcacheClientObj(Client): > def initial

Re: [web2py] Re: use memcache

2017-04-10 Thread Paolo Valleri
Have you restarted web2py after the change? Paolo 2017-04-10 0:02 GMT+02:00 黄祥 : > after adding the code, still got the same error : AttributeError: > 'MemcacheClientObj' object has no attribute 'initialize' > *e.g.* > class MemcacheClientObj(Client): > def initialize(self): > pass

[web2py] Re: use memcache

2017-04-09 Thread Paolo Valleri
Regarding the first problem you posted. Try adding: def initialize(self): pass in https://github.com/web2py/web2py/blob/master/gluon/contrib/memcache/__init__.py#L22 Let us know. Paolo On Friday, April 7, 2017 at 12:29:14 AM UTC+2, 黄祥 wrote: > > Tried to learn about memcache, creat

Re: [web2py] Re: web2py and python3

2017-04-03 Thread Paolo Valleri
The best is to test your apps with python3 and report any issues. After a test period, I agree regarding pushing a new release Paolo 2017-04-03 16:46 GMT+02:00 Richard Vézina : > Glad to hear that Leonel... > > But could we have "official" wrapup of the progress so far and where we > heading to

[web2py] Re: inner join taking too long

2017-03-26 Thread Paolo Valleri
you should check where is the bottleneck, I see three places: - select: try to print the select statement (call _select, see http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Generating-raw-sql) and check it on sqlite. - as_list, split it from the select - simplejson

Re: [web2py] Re: web2py and python3

2017-02-02 Thread Paolo Valleri
In the last months few patches have been accepted in the current master branch, as a result web2py core components can be tested on py3 too. Few features are missing see https://github.com/web2py/web2py/issues/1353. Feel free to try and report/fix any new issue discovered. Paolo On Thursday, Fe

[web2py] Re: [pydpdf] ('FPDF' object has no attribute 'write_html')

2016-12-07 Thread Paolo Valleri
see https://github.com/reingart/pyfpdf/blob/master/docs/reference/write_html.md for a detailed example for using write_html Paolo On Tuesday, December 6, 2016 at 10:23:46 PM UTC+1, Mamisoa Andriantafika wrote: > > Hi, > > Here is a simple controller. > > def test_fpdf(): > from gluon.contri

Re: [web2py] Re: switch to python 3

2016-12-06 Thread Paolo Valleri
What about https://gitlab.com/m2crypto/m2crypto/commits/python3 ? On Monday, December 5, 2016 at 9:57:19 PM UTC+1, Niphlod wrote: > > m2crypto port for py3 are available (although not strictly official). > The contrib module for x509 auth stands on it so, on py3, it MAY not work, > but it's not

[web2py] Re: Is web2py dying?

2016-11-18 Thread Paolo Valleri
Hi, On Thursday, November 17, 2016 at 9:00:38 PM UTC+1, AlighaThor wrote: > > Thanks for your quick reply. > > By the way, with 4 years of experience, why not start contributing too >> > > Exactly for that reason I asked this. I'm really thinking about request > being a contributor. I want to do

[web2py] Re: 50x performance improvement for web2py in TechEmpower Web Framework Benchmarks

2016-11-18 Thread Paolo Valleri
According to the benchmark records an important optimization concerns the session logic. The results are also good because the web2py version used during the benchmark already includes all encode/decode calls introduced for py3. Paolo On Friday, November 18, 2016 at 2:40:01 PM UTC+1, JorgeH wr

[web2py] Re: How to cleanly pass FPDF output object to os Download/Save dialogue box

2016-10-17 Thread Paolo Valleri
With this: ... s_io = pdf.output(dest='S') response.headers['Content-Type']='application/pdf' response.headers['Content-Disposition'] = 'attachment; filename="%s"' % file_name raise HTTP(200, s_io, **response.headers) You get the same you have now with response.stream but it's cleaner. Without

[web2py] Re: Help with App memory usage

2016-10-14 Thread Paolo Valleri
Which driver are you using for postgres? Are you using cache in models? Try to figure out if there are controllers using more memory than others. On Friday, October 14, 2016 at 4:03:20 AM UTC+2, Anthony wrote: > > That's a lot of code to review. You're probably going to have to do some > digging

Re: [web2py] Re: web3py status

2016-09-07 Thread Paolo Valleri
Current master branch passes almost all unittests on python 3.5. If anyone is interested in helping with the final steps, a checklist is here https://github.com/web2py/web2py/issues/1353#issue-159010482 On Tuesday, September 6, 2016 at 5:43:55 AM UTC+2, jjs0sbw wrote: > > I agree that a better te

[web2py] Re: app slow on pythonanywhere

2016-09-03 Thread Paolo Valleri
Have you disabled migrations? Paolo On Saturday, September 3, 2016 at 7:01:39 PM UTC+2, Scott Hunter wrote: > > I have an app which runs *much* slower than expected on pythonanywhere. > > I enabled the profiler, and one thing stood out: on pythonanywhere, the > function the most time was spent i

Re: [web2py] Re: geometry field /postgis/srid conversion

2016-01-09 Thread Paolo Valleri
Postgres allows the developer to define tables under different schemas, the 'common' schema is 'public'. I recommend you to use it as well. Web2py have few bindings for GIS queries, have a look at http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#PostGIS--SpatiaLite--and-

[web2py] Re: geometry field /postgis/srid conversion

2016-01-09 Thread Paolo Valleri
Hi Pierre, try to define the table as follows db.define_table('geom', Field('loc','geometry(public, 2154, 2)')) By doing that you define the column *loc* with srid=2154. Notice that 'public' is the schema, and 2 is the dimension. Paolo On Thursday, January 7, 2016 at 7:21:40 PM U

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Paolo Valleri
cerned as my application gets bigger that we are going to have to >>>> migrate to a .net or java based solution in the future. The more I >>>> develop, the more I worry about the amount of re-work I am creating for >>>> myself in the future. I would feel better about

Re: [web2py] Re: web2py and python3

2015-11-16 Thread Paolo Valleri
Just to understand what we are talking about, which are the main issues in porting web2py on python 3.x ? Paolo On Saturday, November 14, 2015 at 11:24:30 PM UTC+1, Ramos wrote: > > weppy looks like a short webp2y environment, however lacks some good > documentation like web2py and all of the c

[web2py] Re: DAL returns string fields not as unicode strings

2015-11-14 Thread Paolo Valleri
I tried to run the following (test.py) with the latest stable web2py (i.e.: python web2py.py -S welcome -R test.py) db = DAL('sqlite:///tmp/storage.sqlite') db.define_table('unicode_test', Field('test', 'string')) test_val = unicode('på Facebook', 'utf-8') db.unicode_test.insert(test=test_val) db.

[web2py] Re: ajax need to return 4 values

2015-11-14 Thread Paolo Valleri
There isn't a solution out-of-the-box in web2py. I'd suggest returning a json with the 4 values, and then apply the result to the input fields Paolo On Saturday, November 14, 2015 at 1:50:56 PM UTC+1, lucas wrote: > > hello one and all, > > how do i run an ajax function under an onchange of a se

[web2py] Re: postgis & web2py geo api

2015-11-13 Thread Paolo Valleri
have a look at http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?#PostGIS--SpatiaLite--and-MS-Geo--experimental- and a basic example here: http://www.web2pyslices.com/slice/show/1899/leaflet-and-geojson-with-web2py Paolo On Friday, November 13, 2015 at 3:47:18 PM UTC+

[web2py] Re: Creating web apps with Web2py in Azure Web Apps

2015-11-13 Thread Paolo Valleri
we can start using github wiki for all things in script/* Paolo On Friday, November 13, 2015 at 9:09:12 AM UTC+1, Niphlod wrote: > > we're working towards REDUCING scripts/anything_for_deployment because > they quickly become unmaintained. > If we start to scripts/deploy/any_cloud_provider_out_

[web2py] Re: Oracle perfomance issues with version 2.12.3

2015-11-09 Thread Paolo Valleri
Hi, there should be something wrong going on. As a first step, I'd write a simple query (i.e., select(db.table.ALL, limit=(0,10)) using pydal (the database abstraction layer used in web2py) and try to find out in which version has been introduced this performance issue. If you don't find a perfo

Re: [web2py] Getting cannot import name table_field after upgrading to 2.12.3

2015-08-24 Thread Paolo Valleri
see also https://github.com/kenji4569/sqlabs/issues/68 On Monday, August 24, 2015 at 3:23:24 PM UTC+2, Johann Spies wrote: > > I had similar problems which convinced me to to stop using solidtable. > > Regards > Johann > > > -- > Because experiencing your loyal love is better than life itself, >

[web2py] Re: GAE unicodeDecodeError: 'ascii' codec can't decode byte... unable to fix it

2015-08-17 Thread Paolo Valleri
Hi, the latest version of web2py doesn't include the most recent pydal. I'd suggest trying your app with the last development version of web2py. Paolo On Monday, August 17, 2015 at 6:48:11 PM UTC+2, Jaime Sempere wrote: > > Hi, > > I am having problems when I try to deploy my app on local SDK GA

[web2py] Re: 2.12.1 is out

2015-08-17 Thread Paolo Valleri
@Massimo, I've just noticed that web2py 2.12.2 points to an old version of pydal. is that correct? see https://github.com/web2py/web2py/tree/R-2.12.2/gluon/packages Paolo On Sunday, August 16, 2015 at 10:45:19 PM UTC+2, Massimo Di Pierro wrote: > > Fine with most of these. Can you send PR reques

[web2py] Re: Error in last stable version when trying to delete through one to many relation

2015-08-17 Thread Paolo Valleri
Hi all, according to my tests the issue is fixed on master pydal. @Lisandro, you should use master web2py which points to a version of pydal containing the fix. Paolo On Tuesday, August 4, 2015 at 5:21:38 PM UTC+2, Massimo Di Pierro wrote: > > good catch! I opened a ticket: https://github.com/w

[web2py] Re: break syntax between 2.8.2 and 2.11.2??

2015-07-13 Thread Paolo Valleri
Hi Simone, it should be fixed in trunk, would you mind to test your code against latest development version of web2py? Paolo On Thursday, July 9, 2015 at 9:33:05 PM UTC+2, Dave S wrote: > > > > On Thursday, July 9, 2015 at 5:54:00 AM UTC-7, 黄祥 wrote: >> >> please update your web2py, since 2.11.

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-22 Thread Paolo Valleri
g8000 or psycopg2) Is it a simple matter of > > sudo apt-get install python-psycopg2 > > ? > > > On Sunday, June 21, 2015 at 11:20:33 PM UTC-7, Paolo Valleri wrote: >> >> Massimo the mentioned issue has been fixed in pydal. Have you found other >> different

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-21 Thread Paolo Valleri
sql users. psycopg2 is solid. > > On Thursday, 18 June 2015 12:59:44 UTC-5, Paolo Valleri wrote: >> >> In general the best choice is psycopg2 however, the issue with pg8000 has >> been fixed >> I've written an initial basic unittest >> https://github.com/w

Re: [web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-18 Thread Paolo Valleri
it still recommended to use psycopg2 instead of pg8000 after this fix? > > El lunes, 15 de junio de 2015, 5:28:09 (UTC-5), Paolo Valleri escribió: > >> According to my tests, the current PG adapter works only with psycopg2 >> and python2.7 >> It is broken with both pg8000

[web2py] Re: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 1145: ordinal not in range(128)

2015-06-15 Thread Paolo Valleri
According to my tests, the current PG adapter works only with psycopg2 and python2.7 It is broken with both pg8000 and psycopg2 on python 3.x A possible fix for pg8000 and python2.7 is here https://github.com/ilvalle/pydal/commit/d5450938ae606a3e85deffa831899a35146f5e64 I've posted an issue fo

Re: [web2py] Re: Virtual fields disapeared from select() results (v2.11.2)

2015-06-09 Thread Paolo Valleri
ok, the fix is here https://github.com/web2py/pydal/pull/211 Paolo On Tuesday, June 9, 2015 at 10:44:59 AM UTC+2, tim.n...@conted.ox.ac.uk wrote: > > Lovely! I was just about to post this problem. > > On Tuesday, 9 June 2015 07:56:35 UTC+1, Paolo Valleri wrote: >> >&g

Re: [web2py] Re: Virtual fields disapeared from select() results (v2.11.2)

2015-06-08 Thread Paolo Valleri
I see the problem now, thanks for pointing it out. I'll post a fix later today. Paolo 2015-06-08 22:11 GMT+02:00 Donatas Burba : > This is failing example: > > db=DAL('sqlite:memory') > > db.define_table('tt', > Field('vv', 'integer'), > Field.Virtual('x', lambda row: row.tt.vv * 10)) >

Re: [web2py] Re: is this a pydal issue?

2015-06-08 Thread Paolo Valleri
person goes to the page directly (not the "normal" method) then the > "op_rec" parameter would be None and in that case, the code simply > redirects the person to a function that sets it to the "Rows" object > > thanks for your response! > > > On Mond

[web2py] Re: is this a pydal issue?

2015-06-08 Thread Paolo Valleri
Your are comparing Rows with None. The question is why? Normally, you should compare Rows with Rows. In pydal we can add a check to raise an error if the second argument isn't an instance of Rows. Paolo On Monday, June 8, 2015 at 1:03:45 PM UTC+2, Auden RovelleQuartz wrote: > > What does this

[web2py] Re: Virtual fields disapeared from select() results (v2.11.2)

2015-06-07 Thread Paolo Valleri
Hi, The following works db=DAL('sqlite:memory') db.define_table('tt', Field('vv', 'integer'), Field.Virtual('x', lambda row: row.tt.vv * 10)) db.tt.insert(vv='1') print db(db.tt).select().first() printing We need more details to understand what is failing in your case. Can you post a fa

[web2py] Re: db define error

2015-06-04 Thread Paolo Valleri
Mind that you have written db.define.table instead of db.define_table Paolo On Friday, June 5, 2015 at 6:26:00 AM UTC+2, Dan Hett wrote: > > I am getting an error for this table creation: > > db.define.table('blade_location', > Field('bladeID','reference blade'), >

[web2py] Re: list:reference with SQLFORM.grid

2015-05-24 Thread Paolo Valleri
This issue has been already fixed https://github.com/web2py/pydal/commit/2172b776b9c41884717902e68900b41c105e0364#diff-114ce07f361177e0669ec9a374ef7d6a Have you updated web2py (and pydal) properly? Paolo On Monday, May 25, 2015 at 7:37:35 AM UTC+2, Mark Graves wrote: > > I seem to be having th

Re: [web2py] Re: @cache.action not working properly with nginx, is any additional configuration required?

2015-05-20 Thread Paolo Valleri
gi_param SERVER_SOFTWAREnginx/$nginx_version; > } > > location @fallback { > uwsgi_pass unix:///tmp/medios.socket; > } > } > > > > > I don't know where to or how to check if memcache is caching. > > Thanks in advance! &g

[web2py] Re: @cache.action not working properly with nginx, is any additional configuration required?

2015-05-20 Thread Paolo Valleri
this is the correct behavior in a multi-process/multi-thread environment because cache.ram is not shared across them. use either memcache or redis to have a global cache Paolo On Wednesday, May 20, 2015 at 1:46:48 PM UTC+2, Lisandro wrote: > > Are there any special consideration about @cache.act

Re: [web2py] Re: AttributeError: 'DAL' object has no attribute

2015-05-14 Thread Paolo Valleri
om the dir of web2py, so that myapplic in under appilcations/ >> >> >> >> Il giorno mercoledì 13 maggio 2015 21:14:27 UTC+2, Paolo Valleri ha >> scritto: >>> >>> Which web2py version are you using? >>> Can you post a co

[web2py] Re: AttributeError: 'DAL' object has no attribute

2015-05-13 Thread Paolo Valleri
Which web2py version are you using? Can you post a complete example that reproduces the issue? Paolo On Wednesday, May 13, 2015 at 7:14:30 PM UTC+2, goome wrote: > > hello , i have this action in defaul.py > """ > @auth.requires_login() > def lista_fornitori(): > fornitori = > legacy_db().sele

[web2py] Re: Deadlock in cache.py/CacheOnDisk in R 2.10.4

2015-05-12 Thread Paolo Valleri
can you open an issue/pull request on github? Paolo On Tuesday, May 12, 2015 at 7:06:47 PM UTC+2, Bernard Letourmy wrote: > > We found a blocking issue in our app with some image download after > upgrading from 2.9.12 to 2.10.4 > > It turned out to be a deadlock in CacheOnDisk class in case of

[web2py] Re: invalid literal for int() with base 10: running mongodb

2015-05-10 Thread Paolo Valleri
Hi Ron, please open an issue on https://github.com/web2py/pydal/issues it seems that mongo adapter doesn't support "list:reference table" yet On Sunday, May 10, 2015 at 4:09:51 PM UTC+2, Ron Chatterjee wrote: > > I have the following in model. I get an error invalide literal for int > when I add

[web2py] Re: MSSQL and auth.signature

2015-05-09 Thread Paolo Valleri
that's odd. Can you open an issue on github (https://github.com/web2py/pydal/issues) with a simple example to reproduce it? I'll have a look in the next few days Paolo On Saturday, May 9, 2015 at 11:54:30 AM UTC+2, Claudinei Fernandes wrote: > > Hi, > > Has anyone used "auth.signature" attribut

Re: [web2py] Re: MongoDB

2015-05-07 Thread Paolo Valleri
nks a lot. > > > 2015-05-07 9:05 GMT-03:00 Paolo Valleri : > >> You should use pymongo 3.0 >> >> >> On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote: >>> >>> I'm very busy in these days, but I tried to start a new "insta

[web2py] Re: MongoDB

2015-05-07 Thread Paolo Valleri
You should use pymongo 3.0 On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote: > > I'm very busy in these days, but I tried to start a new "installation" > from the ground (to test the TIME issue with Mongodb in pydal #170), but > even without this correction (i.e, with plain web2py

[web2py] Re: Issues with PythonAnywhere - /proc/meminfo

2015-05-07 Thread Paolo Valleri
Hi, you have spotted an issue on the new cache system. I've opened the issue so we can fix it soon. https://github.com/web2py/web2py/issues/959 Paolo On Wednesday, May 6, 2015 at 3:28:44 PM UTC+2, Lovecannon wrote: > > Hello I'm having some issues with web2py and PythonAnywhere. It seems as > t

[web2py] Re: web2py-mongodb-engine

2015-05-07 Thread Paolo Valleri
I don't see any problem at all in implementing a common post-comment page in web2py. You can code it independently from the backend. On Wednesday, May 6, 2015 at 8:28:08 PM UTC+2, Ron Chatterjee wrote: > > Here is another tutorial from django: > > > *http://docs.mongodb.org/manual/tutorial/write

Re: [web2py] Re: DB2 database issue with Clob types

2015-05-04 Thread Paolo Valleri
en it, >> where it is but I don't understand which alias should I put on the file) >> >> Any help I will really appreciate it. >> >> Thanks! >> >> El sábado, 25 de abril de 2015, 5:24:41 (UTC-6), Paolo Valleri escribió: >>> >>> you

Re: [web2py] Re: MongoDB adapter

2015-05-04 Thread Paolo Valleri
It should be fixed in trunk Paolo On Saturday, May 2, 2015 at 1:24:32 PM UTC+2, José Borba wrote: > > OK. > Thank you very much again. > > Cheers. > > 2015-05-02 8:22 GMT-03:00 Paolo Valleri > >: > >> Open an issue to don't forget it,I'll fix i

Re: [web2py] Re: MongoDB adapter

2015-05-02 Thread Paolo Valleri
ted). I forgot to mention > this. I'm sorry. > > My second bet is that the parser of time (the time_itens above) need to be > modified to work with time in mongo, > > Still not knowing what is the correct "bug" (if there are one) to report. > > Cheers, > >

[web2py] Re: MongoDB adapter

2015-05-02 Thread Paolo Valleri
Hi, try use the latest version of pydal, Mongo adapter has been recently updated to work with pymongo 3.0 However, I think this is a bug. Can you open a bug report on https://github.com/web2py/pydal Paolo On Saturday, May 2, 2015 at 3:58:13 AM UTC+2, José Borba wrote: > > Hi 4 All, > > I'm new

[web2py] Re: Pydal ilike search inside a list of strings?

2015-04-29 Thread Paolo Valleri
Which postgres adapter are you using? Try - contains('%Smith') and (for case-insensitive query) - contains('%smith', case_sensitive=False) Paolo On Tuesday, April 28, 2015 at 9:26:24 PM UTC+2, Tom Stratton wrote: > > For me, with the postgres adapter, the "contains" method is only returning > i

[web2py] Re: Any problem in list:reference in 2.10 ?

2015-04-29 Thread Paolo Valleri
Hi, Can you try the fix I proposed in https://github.com/web2py/web2py/issues/946#issuecomment-9661 Paolo On Tuesday, April 28, 2015 at 9:26:23 PM UTC+2, Ariya Owam-aram wrote: > > Hi Everyone, > > I just upgrade to 2.10.4 and found error message when using filed > list:reference. > > APP :

Re: [web2py] Re: postgres/psychopg2 connect problem -- need help

2015-04-26 Thread Paolo Valleri
user and the database directly in postgres. Then I ran web2py and got > the error. Then I restored the database from the old server and ran web2py > and got the same error. I dropped the database and tried again and got the > same result. > > > On Sunday, April 26, 2015 at 1:14:38 A

[web2py] Re: postgres/psychopg2 connect problem -- need help

2015-04-26 Thread Paolo Valleri
you have to setup the user on the new postgres server. You have probably restored only the data of the database. On Sunday, April 26, 2015 at 9:10:11 AM UTC+2, weheh wrote: > > I'm moving my app to a new server. It's running Windows 8.1 (sorry about > that, but it can't be avoided for technical

[web2py] Re: DB2 database issue with Clob types

2015-04-25 Thread Paolo Valleri
you should provide us more info... which web2py type are you using that is mapped to CLOB field? web2py/pyodbc version Paolo On Friday, April 24, 2015 at 6:17:53 PM UTC+2, Boris Aramis Aguilar Rodríguez wrote: > > ('ODBC data type -99 is not supported. Cannot read > column LDTEXT.', 'HY000')

[web2py] Re: Need support for web2py application with over 1 million users.

2015-04-23 Thread Paolo Valleri
Mind that if you store session in the database/redis you could have problems in pages that use components (es: load). Otherwise, it is a good starting point. On Thursday, April 23, 2015 at 6:21:51 PM UTC+2, Derek wrote: > > Barring him sharing that information, what general advice can you give

[web2py] Re: New error in trunk' s sqlhtml.py: AttributeError: 'SQLCustomType' object has no attribute 'represent'

2015-04-22 Thread Paolo Valleri
Hi, this it should have been fixed Have you tried with the last trunk? Be sure to update pydal too. Paolo On Wednesday, April 22, 2015 at 1:00:04 PM UTC+2, Johann Spies wrote: > > This code work without a problem in > Version 2.9.12-stable+timestamp.2015.01.17.06.11.03 > > but not with the code

[web2py] Re: VARCHAR or NVARCHAR?

2015-04-15 Thread Paolo Valleri
mssql adapters are quite messy. MSSQL2Adapter is the adapter that uses 'nvarchar' as type, however it inherits from MSSQLAdapter, given that it doesn't have the features of MSSQL4Adapter. For backward compatibility I don't think MSSQL2Adapter will be never updated to inherits from MSSQL4Adapter.

[web2py] Re: auth.accessible_query() speedup

2015-04-12 Thread Paolo Valleri
Which backend are you using? Can you provide the output of the query? On Sunday, April 12, 2015 at 10:01:17 AM UTC+2, weheh wrote: > > I'm wondering if there's any kind of speedup possible on > auth.accessible_query(...) by indexing the various auth tables (like > auth.member, auth.group, ...)?

[web2py] Re: Please report here upgrading issues to web2py 2.10.2

2015-04-08 Thread Paolo Valleri
Hi Jim, Which back-engine are you using? Have you tried with a different one? Can you pack a simple app that reproduce the issue? Paolo On Tuesday, April 7, 2015 at 9:40:29 PM UTC+2, Jim S wrote: > > Just wondering if this is posted in the right place. Should I be > reporting this issue elsewhe

[web2py] Re: Last version of plugin_wiki?

2015-04-08 Thread Paolo Valleri
plugin_wiki is no longer supported. See http://www.web2py.com/books/default/chapter/29/03/overview?search=wiki#The-built-in-web2py-wiki Paolo On Tuesday, April 7, 2015 at 6:32:09 PM UTC+2, Najtsirk wrote: > > > Hi guys, > > where can I get the latest version of plugin_wiki? > > Best, > K > --

[web2py] Re: Stupid Question - how do I run the pydal test suite?

2015-04-03 Thread Paolo Valleri
python -m unittest tests Paolo On Friday, April 3, 2015 at 7:57:41 AM UTC+2, Tom Stratton wrote: > > I have google for the last hour to try and figure out how to run the > unittests in the tests folder for pydal and have come up short. > > Is there something simple I am missing? > -- Resource

[web2py] Re: High Memory usage due to uploads_in_blob

2015-04-02 Thread Paolo Valleri
Try to change https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L2151 with filter1 = lambda f: isinstance(f, Field) and f.type != 'blob' Paolo On Thursday, April 2, 2015 at 4:20:29 PM UTC+2, Paolo Valleri wrote: > > That is a bug because Grid selects the 'h

[web2py] Re: High Memory usage due to uploads_in_blob

2015-04-02 Thread Paolo Valleri
That is a bug because Grid selects the 'hidden' doc_blob field. Please open an issue on github Paolo On Thursday, April 2, 2015 at 11:03:15 AM UTC+2, Mandar Vaze wrote: > > Hi, > > I have an application that uses uploads_in_blob feature as follows : > > db._adapter.uploads_in_blob = True > >

[web2py] Re: Belongs not working

2015-03-28 Thread Paolo Valleri
Which web2py version was working ? What was the sql output? As you mentioned, replacing belongs with contains fixed the problem. On Saturday, March 28, 2015 at 6:53:50 PM UTC+1, Leonardo Pires Felix wrote: > > Not working too on the version for testers, in this case using sqlite. > Example: > >

[web2py] Re: Saving Google Maps Markers To Database

2015-03-26 Thread Paolo Valleri
If you have to show the marker (and maybe a tooltip) you can consider to use a geojson layer. I've written an example for leaflet, but the same can be applied to google maps (https://developers.google.com/maps/documentation/javascript/datalayer) https://github.com/ilvalle/w2pgis For storing the

[web2py] Re: SQLFORM.factory adding dynamic form

2015-03-25 Thread Paolo Valleri
To fix the exception 'table already defined' use define_table() with redefine=True see http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=redefine#redefine Paolo On Wednesday, March 25, 2015 at 2:17:45 AM UTC+1, Ramkrishan Bhatt wrote: > > I am looking from

[web2py] Re: Git Clone : Seems bad first page

2015-03-25 Thread Paolo Valleri
Massimo can we enable static_version in welcome? On Wednesday, March 25, 2015 at 5:31:15 AM UTC+1, Massimo Di Pierro wrote: > > it should not look like that. Either a css is missing or your browser is > caching some old style file (most likely). Try force a reload and check the > JS console for

[web2py] Re: last minute web2py hackaton

2015-03-21 Thread Paolo Valleri
+1 On Friday, March 20, 2015 at 5:57:37 PM UTC+1, Niphlod wrote: > > damn. I should have waited all those months. > > muhahahaha! > > let's see if money speed up things. > > BTW; I'd have included that with the fix should be included a regression > test to make it never happen again, but that's

Re: [web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-17 Thread Paolo Valleri
the end of the universe and may be the only way but seems clunky...given > I've been living with this for 2 or 3 months I'm just happy I have an > answer that seems properly robust ;) > > On Tuesday, March 17, 2015 at 1:07:06 AM UTC+11, Paolo Valleri wrote: >> >> yo

Re: [web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-16 Thread Paolo Valleri
ate_record() > debug_log(sys._getframe().f_code.co_name, None, > start=method_start, error_details=ee, severity='Fail') > raise Exception('Failure during method execution: ' + str(ee)) > > self.dbase._adapter.reconnect() >

[web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2015-03-14 Thread Paolo Valleri
Hi, first of all use the latest pydal, it contains a fix when trying to close 'broken connection'. Afterwards, for a proper reconnect in your application you should do: - db._adapter.close() - db._adapter.reconnect() If you are looking for an 'auto-reconnect', namely it will re-execute all queri

[web2py] Re: list reference with ondelete=set null breaking when delete parent

2015-03-10 Thread Paolo Valleri
ondelete is for reference field. At a first sight, a possible workaround would be to write your own 'ondelete' by using the _before_delete and _after_delete callbacks Paolo On Monday, March 9, 2015 at 7:09:54 PM UTC+1, Ron Chatterjee wrote: > > Wonder if he can try to make it a list and do list.

[web2py] Re: Query Production Oracle database using DAL

2015-03-06 Thread Paolo Valleri
Instantiate DAL with migrate=False is enough to guarantee the read-only-mode operations. In addition accessing the db using an user without write permissions is better if you only have to dump data. To copy data from one db to an other, have a look at https://github.com/web2py/web2py/blob/maste

Re: [web2py] Re: Weird Error Message From Web2py - OSError: [Errno 24] Too many open files ???????

2015-03-04 Thread Paolo Valleri
Massimo, I suggest adding a message when web2py start using internal cron in which is stated that cron is no longer supported. Do you agree ? On Tuesday, March 3, 2015 at 5:51:50 PM UTC+1, Massimo Di Pierro wrote: > > BTW. We do not support cron anymore since we have the scheduler. Cron > causes

[web2py] Re: Current status of adapting OrientDB for web2py

2015-03-04 Thread Paolo Valleri
Hi, contributions are more than welcome :) You can start by having a look at those other no-sql adapters in https://github.com/web2py/pydal/tree/master/pydal/adapters Paolo On Wednesday, March 4, 2015 at 4:27:16 AM UTC+1, Pumplerod wrote: > > I'm curious if anyone has done any more to integrate

[web2py] Re: First post: Is this a bug?

2015-02-22 Thread Paolo Valleri
Can you post an example code? On Monday, February 23, 2015 at 4:37:31 AM UTC+1, Mat Miles wrote: > > I had a project that a number of tables that reference other tables using > MySQL as the DB. I started another project using SQlite and the reference > tables did not work. I went over and over t

[web2py] Re: can't type forward slash in editor

2015-02-21 Thread Paolo Valleri
Hi, it seems you have spotted a codemirror issue, which has been fixed in the new version 4.13. see https://groups.google.com/d/topic/codemirror-announce/0bPIIIR2M8I/discussion I'll make a PR to fix it in web2py. Paolo On Wednesday, February 18, 2015 at 4:56:04 PM UTC+1, dangne...@juno.com wrot

[web2py] 'emulate' list:double

2015-02-08 Thread Paolo Valleri
I'm trying to 'emulate' list:double using list:string with a validator as IS_LIST_OF(IS_FLOAT_IN_RANGE(...)). This works well but the json produced by as_json is: field: ["float", "float"] I need something like: field: [float, float] I achieved it by defining the field as 'json' but I don't like

[web2py] Re: Memory leaks in web2py : how do you track them ?

2015-02-01 Thread Paolo Valleri
Hi, the garbace collector is called once every 100 requests. See https://github.com/web2py/web2py/blob/5a0ee722605164f1eae4064d0d1dd0d72b5eb14b/gluon/main.py#L197 In addition try to pack a very basic app which can reproduce the issue, we'll have more info about what is going on wrong in your ap

Re: [web2py] Re: pydal / postgres / jsonb

2015-01-29 Thread Paolo Valleri
https://github.com/web2py/pydal/issues/48. Thanks > for looking into this. > > On Wednesday, January 28, 2015 at 11:31:08 PM UTC+5:30, Paolo Valleri > wrote: >> >> I agree. we should set jsonb as default json data type for pg >= 9.4 >> I'll provide a patch as soon a

[web2py] Re: pydal / postgres / jsonb

2015-01-28 Thread Paolo Valleri
I agree. we should set jsonb as default json data type for pg >= 9.4 I'll provide a patch as soon as possible, in the meanwhile, please open an issue on https://github.com/web2py/pydal/issues Paolo On Tuesday, January 27, 2015 at 6:24:47 PM UTC+1, Kiran Subbaraman wrote: > > Any plans for the the

[web2py] Re: error: no such table

2015-01-21 Thread Paolo Valleri
Hi, why are you using fake_migrate? it rebuilds web2py metadata. Paolo On Thursday, January 22, 2015 at 6:25:10 AM UTC+1, Dmitry Ermolaev wrote: > > no such table: cp_mods > Versionweb2py™Version 2.9.12-stable+timestamp.2015.01.17.06.11.03PythonPython > 2.7.8: C:\Python27\python.exe (prefix: C:\

[web2py] Re: HELP!! One click upgrade failed for pythonanywhere site

2015-01-21 Thread Paolo Valleri
Hi, since you have access to the file system, can you check the content of the last ticket in the admin error directory? Paolo On Wednesday, January 21, 2015 at 5:13:17 PM UTC+1, Omi Chiba wrote: > > Hi, I clicked the upload on admin and tried to upgrade from 2.4.6 to > 2.9.12. As soon as I cli

  1   2   3   >