[web2py:14099] Re: reportlab in web2py?

2008-12-24 Thread carlo
> It's too heavy.  Also, reportlab is a fairly low-level API.  Unless you're > going to write a higher-level abstraction layer, it wouldn't "fit" in > web2py.  Plus, most people will want to take advantage of the speedups (which > can't be included in the source version of web2py). agree it ha

[web2py:14100] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread mdipierro
Making some progress but I need your help. Given this: db.define_table('t1',SQLField('name')) db.define_table('t2',SQLField('t1',db.t1),SQLField('name')) Are these valid MSSQL Statements? 1) db(db.t1.id>0)._select(orderby=db.t1.name,groupby=db.t1.name) 'SELECT t1.id, t1.name FROM t1 W

[web2py:14101] Re: reportlab in web2py?

2008-12-24 Thread carlo
> It's too heavy.  Also, reportlab is a fairly low-level API.  Unless you're > going to write a higher-level abstraction layer, it wouldn't "fit" in > web2py.  Plus, most people will want to take advantage of the speedups (which > can't be included in the source version of web2py). agree it ha

[web2py:14102] Re: reportlab in web2py?

2008-12-24 Thread carlo
Found Pisa thank you, very interesting. carlo On 23 Dic, 23:21, Timothy Farrell wrote: > easy_install reportlab > dang, that's easy! > ;-) > mr.freeze wrote:It would be nice to have a feature system that allows either > manual uploading (similar to the application upload) or on-demand download

[web2py:14103] Re: Database Synchronization Howto and UUID

2008-12-24 Thread Fran
On Dec 23, 6:39 pm, mdipierro wrote: > db.table.exposed=[] > you can set a list of fields that you want visible in T2.create/update db.table.exposes=[] does indeed work for t2.create() & t2.update() :) With db.table.displays for t2.display() & db.table.represent for t2.itemize(), this gives

[web2py:14104] Re: Database Synchronization Howto and UUID

2008-12-24 Thread mdipierro
Consider: db.define_table('person', db.Field('uuid',length=64,default=uuid.uuid4 ()), db.Field ('modified_on','datetime',default=now), db.Field('name')) db.define_table('dog', db.Field('uuid'

[web2py:14105] Re: Performance tips

2008-12-24 Thread Jonathan Benn
On Dec 23, 4:41 pm, mdipierro wrote: > in latest trunk, _lastsql on GAE is a string but only says "select" , > "delete", "insert" etc. Better than nothing for now. Thanks Massimo, and Happy Holidays! --Jonathan --~--~-~--~~~---~--~~ You received this message be

[web2py:14106] Re: Performance tips

2008-12-24 Thread Jonathan Benn
Hi Vince, Dr. DiPierro wrote: > db['_execute']=lambda *a,**b: timer(db,lambda:db._execute(*a,**b)) Look carefully at the line above, I believe that there may be an infinite recursion. When you try to call db._execute, the method will itself call db._execute and then once the thread tries to obt

[web2py:14107] Re: reportlab in web2py?

2008-12-24 Thread Timothy Farrell
Just like you would normally run a long-running process in web2py, os.spawn is my favorite (python offers numerous methods). But...do we really want a framework that installs software on demand (without prompting an admin)?  I say, let's just leave it to the humans.  It's one thing to make so

[web2py:14108] Re: Database Synchronization Howto and UUID

2008-12-24 Thread Fran
On Dec 24, 12:25 pm, mdipierro wrote: > db.dog.owner.display=lambda id: db(db.person.id==id).select()[0].name > and t2.displays(db.dog) will show you the owner's name not his id. Perfect - all is now sorted :) Many thanks, F --~--~-~--~~~---~--~~ You received thi

[web2py:14109] Re: Database Synchronization Howto and UUID

2008-12-24 Thread Fran
> On Dec 24, 12:25 pm, mdipierro wrote: > > db.dog.owner.display=lambda id: db(db.person.id==id).select()[0].name > > and t2.displays(db.dog) will show you the owner's name not his id. Oops, still have an issue here. If the owner field is blank for a record then this fails: SyntaxError: SQLRows:

[web2py:14110] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread Mike
Hi Massimo - They all threw errors. I listed the errors and how I fixed them below. All of this was done directly in SQL SERVER 2005, but no test data. Thanks for taking a look at this! I hope this info helps... -- --STATEMENT 1 -- --ERROR --Msg 8120, Level 16,

[web2py:14111] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread mdipierro
Thank you. I will send another round of tests. Massimo On Dec 24, 10:16 am, Mike wrote: > Hi Massimo - > > They all threw errors. I listed the errors and how I fixed them below. > All of this was done directly in SQL SERVER 2005, but no test data. > > Thanks for taking a look at this! I hope th

[web2py:14112] web2py manual: removing action file

2008-12-24 Thread annet
Upon deleting a record from a table, I would like to delete the physical uploaded file (which resides in the uploads folder) referenced by the record. The code provided on pages 173 and 174 in the web2py manual doesn't work. I hope one of you knows why it doesn't work. Best regards, Annet. --~--

[web2py:14113] Re: web2py manual: removing action file

2008-12-24 Thread mdipierro
This should work (from T2, which deletes files by default): if form.accepts(request.vars,session): if request.vars.delete_this_record: for f in form.table.fields: if form.table[f].type=='upload' and form.table [f].uploadfield is True:

[web2py:14114] Re: reportlab in web2py?

2008-12-24 Thread pmate
Pisa is really nice, but i'm totally pro reportlab. It's true that it is a little heavy but it's a great solution for printing in web2py Paolo On Dec 24, 3:36 pm, Timothy Farrell wrote: > Just like you would normally run a long-running process in web2py, os.spawn > is my favorite (python offer

[web2py:14115] Re: MERRY CHRISTMAS ALL!

2008-12-24 Thread pmate
Merry Christmas to all of you and to your families. Let's hope it will bring to all a little more of peace. Paolo On Dec 23, 6:09 pm, "Yarko Tymciurak" wrote: > Whether you celebrate Christmas or not, > I wish you all - Peace on Earth, and Goodwill amongst People... > > Thanks for the sense of

[web2py:14116] Re: MERRY CHRISTMAS ALL!

2008-12-24 Thread Tito Garrido
Merry Christmas Folks! On Wed, Dec 24, 2008 at 2:26 PM, pmate wrote: > > Merry Christmas to all of you and to your families. > Let's hope it will bring to all a little more of peace. > > Paolo > > On Dec 23, 6:09 pm, "Yarko Tymciurak" wrote: > > Whether you celebrate Christmas or not, > > I wis