[web2py] Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
Hi, I'm using web2py in a project that stands on top of a REST api. The project is write intensive (around 110k requests a day, with all the requests making at least 2 updates to the datastore). All my requests seems to uso at least 200 cpu_ms (even dummy requests that only places a item on the

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
Pre compiled by the admin interface? Not yet, is there some impove with the precompiled code? On Mon, Aug 6, 2012 at 3:16 PM, Derek wrote: > Have you compiled your app? > > On Monday, August 6, 2012 10:46:33 AM UTC-7, Felipe Meirelles wrote: >> >> Hi, >> >> I

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
Just compiled the app and deployed again, seems to make no diference. App engine uses the bytecode generated on web2py? Did I need to change some config at app.yaml? On Monday, August 6, 2012 3:21:29 PM UTC-3, Felipe Meirelles wrote: > > Pre compiled by the admin interface? Not yet, is

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
Even the simplest controller give me a high cpu usage: import logging def test(): logging.info("Just making a performace test") ms=559 cpu_ms=612 api_cpu_ms=245 On Monday, August 6, 2012 3:37:38 PM UTC-3, Felipe Meirelles wrote: > > Just compiled the app and deployed agai

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
t; import logging > > def test(): > logging.info("Just making a performace test") > > Makes difference? > > > > On Mon, Aug 6, 2012 at 3:59 PM, Felipe Meirelles < > fel...@felipemeirelles.com.br> wrote: > >> Even the simplest controller give

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
, rochacbruno wrote: > > On Mon, Aug 6, 2012 at 4:19 PM, Felipe Meirelles < > fel...@felipemeirelles.com.br> wrote: > >> Without any model I have a huge drop on the cpu use, from around 300ms to >> around 60ms. Still higher than with Django, but its acceptable by th

Re: [web2py] Re: Appengine CPU cycles

2012-08-06 Thread Felipe Meirelles
y > are stored and retrieved from datastore. > > I do not know how Django stores sessions on GAE by default. > > massimo > > > > > > > On Monday, 6 August 2012 14:19:35 UTC-5, Felipe Meirelles wrote: >> >> Without any model I have a huge drop

Re: [web2py] Re: Appengine CPU cycles

2012-08-07 Thread Felipe Meirelles
; auth.define_tables(migrate=False) to avoid migrations on the auth tables in > production. > > Anthony > > -- > > > > -- Att, Felipe Meirelles. --

Re: [web2py] Re: Appengine CPU cycles

2012-08-08 Thread Felipe Meirelles
e). Also, after the model less aproch, compared to web2py it self, I got a huge performance gain, and expect a solid cost reduction (I'll post the cost reduction latter, when appengine consolidates the billing). Thanks you all for sharing your toughts. On Tuesday, August 7, 2012 6:56:15

Re: [web2py] Re: Appengine CPU cycles

2012-08-08 Thread Felipe Meirelles
th store sessions in DB (web2py > does)? > > It is likely Django uses simplejson binary while web2py (for portability) > only ships with simplejson in pure python. This may be another performance > loss if you use json a lot. We need to fix this at the web2py level. > > Massimo >

Re: [web2py] Re: GAE datastore: how to unindex a field?

2012-08-12 Thread Felipe Meirelles
Just reviving this topic. Its not setable via index.yaml. On Wednesday, May 16, 2012 1:07:10 PM UTC-3, howesc wrote: > > actually the question at hand here i think is whether or not web2py can > support indexed=False in the property constructor when defining GAE > models: > > https://developers

Re: [web2py] Re: Appengine CPU cycles

2012-08-12 Thread Felipe Meirelles
Just a last update about the tests, my overall application cost (in dolars from appengine) droped 25% with the change, so, at least in appengine lazy models are a must. On Wednesday, August 8, 2012 12:24:37 PM UTC-3, Jonathan Lundell wrote: > > On 8 Aug 2012, at 7:59 AM, Massimo Di Pierro > >

[web2py] Auth and Model less

2012-08-14 Thread Felipe Meirelles
Hello again, I'm having some trouble with my model less aproch with auth module. I've put him on a separeted file on modules folder, and, when needed, I import it as follows: modules/web2py/auth.py: auth = Auth(db, hmac_key=Auth.get_or_create_key()) controllers/tracking.py: from applications

Re: [web2py] Re: Auth and Model less

2012-08-14 Thread Felipe Meirelles
object from the controller: > > module: > > def initialize_auth(db): > auth = Auth(db, ...) > auth.define_tables > return auth > > controller: > > import initialize_auth > auth = initialize_auth(db) > > Anthony > > -- > > > > -- Att, Felipe Meirelles. --

Re: [web2py] Re: Auth and Model less

2012-08-14 Thread Felipe Meirelles
Now I'm getting this error when I call the initialization method: SyntaxError: invalid table name: auth_user On Tue, Aug 14, 2012 at 10:38 AM, Anthony wrote: > On Tuesday, August 14, 2012 9:14:21 AM UTC-4, Felipe Meirelles wrote: >> >> But the DB object can be static thro

Re: [web2py] Re: Auth and Model less

2012-08-14 Thread Felipe Meirelles
Sorry, the DB was still static. Just created a init_db() and worked as spected. On Tue, Aug 14, 2012 at 1:18 PM, Anthony wrote: > Can you show the exact code you're using in the module and controller? > > > On Tuesday, August 14, 2012 12:07:15 PM UTC-4, Felipe Meirelles wr

Re: [web2py] Re: Auth and Model less

2012-08-14 Thread Felipe Meirelles
Well, but even initializing db and auth for evey request I still get the not validating bug... ill attach my code to you to take a look. On Tue, Aug 14, 2012 at 1:44 PM, Felipe Meirelles wrote: > Sorry, the DB was still static. Just created a init_db() and worked as > spected. > &

Re: [web2py] Re: Auth and Model less

2012-08-14 Thread Felipe Meirelles
n Tue, Aug 14, 2012 at 1:52 PM, Felipe Meirelles wrote: > Well, but even initializing db and auth for evey request I still get the > not validating bug... > > ill attach my code to you to take a look. > > > On Tue, Aug 14, 2012 at 1:44 PM, Felipe Meirelles wrote: > >> S

[web2py] SQLFORM.smartgrid field labels not I18N

2012-08-16 Thread Felipe Meirelles
Yarrr! So, I'm using the smartgrid beta and noticed that some parts of it are not I18N. Should I fix it and send a patch or you guys are working on it already? Thanks --

Re: [web2py] SQLFORM.smartgrid field labels not I18N

2012-08-16 Thread Felipe Meirelles
eat. Or simply list the parts not internationalized > > -- > > > > -- Att, Felipe Meirelles. --

[web2py] Lazy Tables and Cached Results on GAE

2012-09-10 Thread Felipe Meirelles
Anyone tested the new 2.0.2 changes on GAE? Should this work fine? Can someone tell me how the internals work for this two features and how to use it? Thanks. --

[web2py] Re: Lazy Tables and Cached Results on GAE

2012-09-10 Thread Felipe Meirelles
07:05:11 UTC-5, Felipe Meirelles wrote: >> >> Anyone tested the new 2.0.2 changes on GAE? Should this work fine? >> >> Can someone tell me how the internals work for this two features and how >> to use it? >> >> Thanks. >> > --

Re: [web2py] Re: Lazy Tables and Cached Results on GAE

2012-09-10 Thread Felipe Meirelles
ar() > > this will clear all ram. You can also pass a regex to clear to clear only > some keys. > > On Monday, 10 September 2012 07:49:27 UTC-5, Felipe Meirelles wrote: >> >> Only one more question, can I enforce the cache to invalidate (as when I >> know the rec

Re: [web2py] Re: Lazy Tables and Cached Results on GAE

2012-09-10 Thread Felipe Meirelles
e all set of rows. > > Mind that if you do rows.update_records(...) and rows is cached, it should > update the cached row as well. > > > On Monday, 10 September 2012 08:16:07 UTC-5, Felipe Meirelles wrote: > >> But it will invalidate all the cache data. I want to inval

[web2py] NDB Support

2012-09-27 Thread Felipe Meirelles
Hey guys, Is there some effort going on (or at least planed) to support NDB on appengine? Thanks! --

[web2py] GAE datastore: how to unindex a field?

2012-05-14 Thread Felipe Meirelles
Hi, I'm porting a commercial project from django + djangoappengine ( http://www.allbuttonspressed.com/) to web2py and one thing I could'nt find at all is how to manage per field indexes on App Engine. My project is database intensive so every entity is written hundreds of thousend times a day a

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-08 Thread Felipe Meirelles
, 2013 10:58:07 PM UTC-2, Massimo Di Pierro wrote: > > Admin is readonly on GAE and by default not deployed. > > On Friday, 4 January 2013 17:10:56 UTC-6, Alan Etkin wrote: >> >> El jueves, 3 de enero de 2013 11:31:45 UTC-3, Felipe Meirelles escribió: >>&

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-08 Thread Felipe Meirelles
Never mind, this solution just worked the first time, when I need to define the table, the second time it fails too... On Tuesday, January 8, 2013 4:21:01 PM UTC-2, Felipe Meirelles wrote: > > Well, the real problem is I'm using GAE with Google Cloud SQL, so I have > the migratio

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-08 Thread Felipe Meirelles
ticket_data', 'text'), db.Field('created_datetime', 'datetime'), migrate=False ) table = db[tablename] except: pass return table On Tuesday, January

[web2py] Add a WHERE clause to every request

2013-01-11 Thread Felipe Meirelles
Is there possible add a WHERE clause to every query that runs in the application (like record versioning is_active)? --

Re: [web2py] Re: Add a WHERE clause to every request

2013-01-11 Thread Felipe Meirelles
I'll test. Thanks (: On Friday, January 11, 2013 3:21:40 PM UTC-2, rochacbruno wrote: > > little fix. > > On Fri, Jan 11, 2013 at 3:21 PM, Bruno Rocha > > wrote: > >> for table in db.tables: >> db[table]._common_filter = lambda query: db[table].is_active == True >> > > > --

Re: [web2py] Re: Add a WHERE clause to every request

2013-01-11 Thread Felipe Meirelles
It worked. Is there a way to debug SQL on appengine. My DEBUG env_var is set to True but it dosen't output any SQL. On Friday, January 11, 2013 4:52:54 PM UTC-2, Felipe Meirelles wrote: > > I'll test. Thanks (: > > On Friday, January 11, 2013 3:21:40 PM UTC-2, rochacbruno w

Re: [web2py] Re: Add a WHERE clause to every request

2013-01-11 Thread Felipe Meirelles
2013 5:39:05 PM UTC-2, Felipe Meirelles wrote: > > It worked. Is there a way to debug SQL on appengine. My DEBUG env_var is > set to True but it dosen't output any SQL. > > On Friday, January 11, 2013 4:52:54 PM UTC-2, Felipe Meirelles wrote: >> >> I'll test. T

[web2py] Grid with multiple left joins

2013-01-14 Thread Felipe Meirelles
Hi, When you try to make more than one left join on a SQLFORM.grid as: grid = SQLFORMCustom.grid(db.device, fields=[db.device.serial, db.device.device_type, db.device.vehicle, db.vehicle.plate, db.chip.imei, ], field_id=db.device.id, left=[db.chip.on(db.chip.id==db.device

[web2py] Re: Grid with multiple left joins

2013-01-14 Thread Felipe Meirelles
Please desconsider the sorter_icons parameter, its a custom implementation of mine. I can post this patch too if you think its relevant. Thanks! On Monday, January 14, 2013 5:38:53 PM UTC-2, Felipe Meirelles wrote: > > Hi, > > When you try to make more than one left join on a SQL

[web2py] Re: Grid with multiple left joins

2013-01-18 Thread Felipe Meirelles
Did anyone saw it? On Monday, January 14, 2013 5:41:36 PM UTC-2, Felipe Meirelles wrote: > > Please desconsider the sorter_icons parameter, its a custom implementation > of mine. > I can post this patch too if you think its relevant. > > Thanks! > > On Monday, January 1

Re: [web2py] Re: Grid with multiple left joins

2013-01-30 Thread Felipe Meirelles
db._adapter.tables(left) >>> >>> >>> >>> On Friday, January 18, 2013 11:17:19 AM UTC-5, Massimo Di Pierro wrote: >>>> >>>> Looks good. >>>> Can you please send me a patch applied to the trunk version? >>>> >

[web2py] Record versioning on delete CASCADE

2013-02-01 Thread Felipe Meirelles
The cascade feature should work for record versioning enabled tables? Thanks. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegro

[web2py] Re: Record versioning on delete CASCADE

2013-02-02 Thread Felipe Meirelles
er deleted, only > filtered out. I think cascade should work as expected. > > On Friday, 1 February 2013 11:54:25 UTC-6, Felipe Meirelles wrote: >> >> The cascade feature should work for record versioning enabled tables? >> >> Thanks. >> > -- --- You received th

[web2py] Re: Record versioning on delete CASCADE

2013-02-02 Thread Felipe Meirelles
gt; >>> When using versioning. Latest versions of records are never deleted, >>> only filtered out. I think cascade should work as expected. >>> >>> On Friday, 1 February 2013 11:54:25 UTC-6, Felipe Meirelles wrote: >>>> >>>> The cascade

[web2py] Re: Record versioning on delete CASCADE

2013-02-03 Thread Felipe Meirelles
: >>>> >>>> Good point. No. they are not set to is_active=False. Should they? >>>> >>>> On Saturday, 2 February 2013 06:20:47 UTC-6, Felipe Meirelles wrote: >>>>> >>>>> No, I mean, when a record is "delete"

[web2py] VirtualFields on select options

2013-02-20 Thread Felipe Meirelles
Hi, Just found a bug in validators.py, line 468. If I use a virtualfield to format the select options, it will drop an exception, trying to order the select by de virtual field. Can you patch it in trunk? from gluon.dal import FieldVirtual fields = filter(lambda f: type(f) != FieldVirtual, fie

[web2py] Re: VirtualFields on select options

2013-02-20 Thread Felipe Meirelles
I was using a outdated version of web2py, in the new version the line is 511 On Wednesday, February 20, 2013 12:42:05 PM UTC-3, Felipe Meirelles wrote: > > Hi, > > Just found a bug in validators.py, line 468. > > If I use a virtualfield to format the select options, it will dr

[web2py] SQLForm.grid() + LEFT JOIN + common_filters

2013-03-27 Thread Felipe Meirelles
I'm facing a problem where if I have something like this: grid = SQLFORM.grid(db.table1, left=[db.table2.on(db.table2.id==db.table1.reference)], ) my common filters are not processed for table1, only for table2! including is_active filter for version recording. Is there a bug? --

[web2py] Re: SQLForm.grid() + LEFT JOIN + common_filters

2013-03-27 Thread Felipe Meirelles
; > https://code.google.com/p/web2py/issues/detail?id=992&q=common > > On Wednesday, 27 March 2013 09:13:20 UTC-5, Felipe Meirelles wrote: >> >> I'm facing a problem where if I have something like this: >> >> grid = SQLFORM.grid(db.table1, >>

[web2py] Re: SQLForm.grid() + LEFT JOIN + common_filters

2013-03-27 Thread Felipe Meirelles
gt; > On Wednesday, 27 March 2013 10:57:54 UTC-5, Felipe Meirelles wrote: >> >> What is happening is the complete oposite. Its aplying to the leftjoin >> table, but not to the main table. >> >> The problem is on dal.py line 1553: >> tables_to_merge.keys() con

[web2py] Re: SQLForm.grid() + LEFT JOIN + common_filters

2013-03-27 Thread Felipe Meirelles
Added a ticket with the patch that worked for me. Thanks! On Wednesday, March 27, 2013 1:05:22 PM UTC-3, Felipe Meirelles wrote: > > Actualy it worked but not for reason i expected. Ill run some more tests > here and let you know. > > On Wednesday, March 27, 2013 1:03:26 PM UT

[web2py] CASE Tool for python (preferably web2py)

2012-11-27 Thread Felipe Meirelles
So, is there any tool capable of generating python code from diagrams? I was taking a look at Xtext, is there some MDA tool in python language? Or any tool designed to generate web2py models from diagrams? Or even generate diagrams from web2py models? Thanks --

Re: [web2py] CASE Tool for python (preferably web2py)

2012-11-28 Thread Felipe Meirelles
Richard > > On Tue, Nov 27, 2012 at 2:02 PM, Felipe Meirelles < > fel...@felipemeirelles.com.br > wrote: > >> So, is there any tool capable of generating python code from diagrams? >> I was taking a look at Xtext, is there some MDA tool in python language? >>

[web2py] Login form password widget chaned

2012-11-30 Thread Felipe Meirelles
Did you changed the password widget on the login form from INPUT to CAT? Is there a reason to this change? I had a placeholder on it and since DIVs dont have this property, my placeholders don't work any more. --

Re: [web2py] Re: Login form password widget chaned

2012-11-30 Thread Felipe Meirelles
x27;: , 'dspval': , 'id': , 'email': }>}> That password widget used to be a gluon.html.INPUT same as email but now it is a CAT On Fri, Nov 30, 2012 at 1:12 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > What change are you referring to

Re: [web2py] Re: Login form password widget chaned

2012-11-30 Thread Felipe Meirelles
Well, and is there possible to set his placeholder this way? On Fri, Nov 30, 2012 at 2:31 PM, Niphlod wrote: > yep, now it carries the script to enable the entropy color codes. > > Il giorno venerdì 30 novembre 2012 17:21:15 UTC+1, Felipe Meirelles ha > scritto: >> >>

[web2py] GAE + Cloud SQL: Tickets

2012-12-18 Thread Felipe Meirelles
Hi, I'm using GAE + Cloud SQL but every time I get an error, there is no ticket. Can I set web2py to save tickets to database as in Google NoSQL (big table)? --

[web2py] Encoding works on production but fails in development

2012-12-27 Thread Felipe Meirelles
I'm using GAE + Google Cloud SQL and when I insert some data to local server with special chars like in "Água" it saves the data, but when i try to retrieve it i get an encoding error from python. In production it is automaticaly encoded to \u00c1gua and saves to DB. Is it some mysql feature tha

[web2py] Re: Encoding works on production but fails in development

2012-12-27 Thread Felipe Meirelles
It also fails when rendering the grid, but again, only in development server, wich makes me think its something related to google sdk. Is there some ideia? On Thursday, December 27, 2012 12:51:23 PM UTC-2, Felipe Meirelles wrote: > > I'm using GAE + Google Cloud SQL and when I inser

[web2py] Re: Encoding works on production but fails in development

2012-12-27 Thread Felipe Meirelles
evelopment db: https://groups.google.com/forum/?fromgroups=#!search/cloud$20sql$20utf8/google-cloud-sql-discuss/cmmNTT1lJ18/ZBzmsYdcdNwJ Thanks all. On Thursday, December 27, 2012 4:47:08 PM UTC-2, Felipe Meirelles wrote: > > It also fails when rendering the grid, but again, only in devel

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-03 Thread Felipe Meirelles
t here is a problem talking to database or other > internal web2py error, not an application error. Please check for traceback > in the app engine logs. > > On Tuesday, 18 December 2012 06:08:56 UTC-6, Felipe Meirelles wrote: >> >> Hi, I'm using GAE + Cloud SQL but eve

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-03 Thread Felipe Meirelles
; > On Tuesday, December 18, 2012 2:52:56 PM UTC-2, Massimo Di Pierro wrote: >> >> If there is no ticket here is a problem talking to database or other >> internal web2py error, not an application error. Please check for traceback >> in the app engine logs. >> &g

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-03 Thread Felipe Meirelles
Actualy, it is displaying the SQL as: select [, , , ] where )]> On Thursday, January 3, 2013 11:36:15 AM UTC-2, Felipe Meirelles wrote: > > Just added a self.db.commit() after the insert command, and it worked as > spected, but the load() function cant retrieve the ticket data

[web2py] Re: GAE + Cloud SQL: Tickets

2013-01-03 Thread Felipe Meirelles
Well, the problem is when the ticket is saved, self.db points to but when load() is called, it points to . Where the admin application DAL is defined? On Thursday, January 3, 2013 11:47:38 AM UTC-2, Felipe Meirelles wrote: > > Actualy, it is displaying the SQL as: > > select [,