Re: [web2py] Get the IP of the System

[Sanjeet Kumar]

Thanks Anthony i solved it by taking the IP by using the
request.env.remote_addr remote address will be there but by using the list
i get it properly

On Wed, Feb 29, 2012 at 9:19 AM, Anthony  wrote:

> I've seen recommendations to check request.env.http_client_ip,
> request.env.http_x_forwarded_for, and request.env.remote_addr, in that
> order (remote_addr should always be there, but you want one of the other
> two if available because the client may be behind a proxy).
>
> Anthony
>
>
> On Tuesday, February 28, 2012 10:33:32 PM UTC-5, Sanjeet Kumar wrote:
>>
>> I want to insert the client system IP address in my database through the
>> controller can you explain how i get the client IP address of the system
>> when they login.
>>
>> On Tue, Feb 28, 2012 at 7:29 PM, Phyo Arkar wrote:
>>
>>> Which system?
>>>
>>> On 2/28/12, Sanjeet Kumar  wrote:
>>> > How we can get the IP address of the system
>>> >
>>>
>>
>>

[web2py] db.Table in appadmin when used in a module

[Johann Spies]

I have this in a model. It is included in many tables.

akb_signature = db.Table(db, 'akb_signature',
 Field('created_on', 'datetime', default = request.now,
   readable = False, writable = False),
 Field('created_by', db.auth_user, default =
auth.user_id,
   readable = False, writable = False),
 Field('updated_on', 'datetime', default = request.now,
   readable = False, writable = False),
 Field('updated_by', db.auth_user, update =
auth.user_id,
   readable = False, writable = False)
 )

While migrating table definitions to modules I used it in this way:

class Inst(object):

def __init__(self, db,):
self.db = db
self.T = current.T
self.auth = current.session.auth
self.tabelle = ["institution", 'inst_altername']
self.define_tables()

def define_tables(self):
for tbl in self.tabelle:
if tbl not in self.db.tables:
if tbl == 'inst_altername':
self.inst_alt()
elif tbl == 'institution':
self.institution()
else:
pass

def institution(self):
table = self.db.define_table('institution',
 Field('name'),
... several other fields
 current.akb_signature_uuid
 )

In appadmin I have:

 t = Inst(db)

and it shows the table but when I edit it or insert a new record I get a
ticket:

KeyError: 'akb_signature_uuid'

So how do I expose akb_signature_uuid in this case to appadmin?

Regards
Johann
-- 

Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Re: [web2py] web2py 1.99.5 (please read)

[Bruno Rocha]

is the experimental model map included? or it is not done yet?

http://zerp.ly/rochacbruno
Em 28/02/2012 17:28, "Massimo Di Pierro" 
escreveu:

> I am planning to release this tomorrow but you can test it today.
> ***Please help us test it today*** It is really important.
>
> There is a huge number of improvements and bug fixes. We should really
> call this web2py 2.0 but we prefer to wait before advertising some of
> the new features which are in but need more testing.
>
> List not in order of importance:
>
> - included remote debugger (thanks Mariano)
> - gluon/contrib/htmlmin.py for html minimization (thanks kerncece)
> - out of the box posgresql support with pg8000 diver included (thanks
> Mariano)
> - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert
> Valentak)
> - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
> - db.table.field.regexp(...) for sqlite and postgres
> - conditional menu items (reponse.menu=[(title,bool,link,
> [],condition)]
> - db(...,ignore_common_filters=True)
> - DAL IMAP support (thanks Alan Etkin)
> - new DAL syntax:
> db(db.dog_id.belongs(db.dogs.owner=='james')).select()
> - new DAL syntax: db(...).select().group_by_value(db.table.field)
> (thanks Yair)
> - Teradata support (experimental)
> - populate can now deal with computed fields (thanks mweissen)
> - def index(): return dict(a=gluon.tools.Expose(folder))
> - auth.is_impersonating()
> - reponse.delimiters = ('\\[','\\]') (thanks Denes)
> - improved markmin auto-links
> - sync languages capability (thanks Yair)
> - better mongodb support (still experimental)
> - auth.user_groups stores user groups
> - new rediscache (thanks niphold)
> - login_methods/browserid_account.py (thanks Pai)
> - scripts/services/service.py (thanks Ross)
> - improved ldap support (thanks Omi)
> - added TimeCollector (thanks Caleb)
> - better cpdb.py (thanks pasxidis)
> - 100's of small bug fixes and small improvements

Re: [web2py] db.Table in appadmin when used in a module

[Bruno Rocha]

where the akb_signature_uuid is defined?

in a model or module

from gluon import current
current.akb_signature_uuid = akb_signature_uuid = something

then in appadmin

from gluon import current

does not works¿

http://zerp.ly/rochacbruno
Em 29/02/2012 06:26, "Johann Spies"  escreveu:

> I have this in a model. It is included in many tables.
>
> akb_signature = db.Table(db, 'akb_signature',
>  Field('created_on', 'datetime', default = request.now,
>readable = False, writable = False),
>  Field('created_by', db.auth_user, default =
> auth.user_id,
>readable = False, writable = False),
>  Field('updated_on', 'datetime', default = request.now,
>readable = False, writable = False),
>  Field('updated_by', db.auth_user, update =
> auth.user_id,
>readable = False, writable = False)
>  )
>
> While migrating table definitions to modules I used it in this way:
>
> class Inst(object):
>
> def __init__(self, db,):
> self.db = db
> self.T = current.T
> self.auth = current.session.auth
> self.tabelle = ["institution", 'inst_altername']
> self.define_tables()
>
> def define_tables(self):
> for tbl in self.tabelle:
> if tbl not in self.db.tables:
> if tbl == 'inst_altername':
> self.inst_alt()
> elif tbl == 'institution':
> self.institution()
> else:
> pass
>
> def institution(self):
> table = self.db.define_table('institution',
>  Field('name'),
> ... several other fields
>  current.akb_signature_uuid
>  )
>
> In appadmin I have:
>
>  t = Inst(db)
>
> and it shows the table but when I edit it or insert a new record I get a
> ticket:
>
> KeyError: 'akb_signature_uuid'
>
> So how do I expose akb_signature_uuid in this case to appadmin?
>
> Regards
> Johann
> --
>
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)
>
>

[web2py] Re: After LDAP authentication, where can I change some actions?

[szimszon]

I'm also interested in that question :-o

2011. október 30., vasárnap 2:19:20 UTC+2 időpontban Tito Garrido a 
következőt írta:
>
> Hi Folks!
>
> I could see that ldap authentication is located on:
> /web2py/gluon/contrib/login_methods
>
> but after the login I need to insert the user on some ldap groups that 
> I've queried during the authentication... where I can do it? I can see that 
> I won't be able to use id=db.auth_group.update_or_insert(role=g) inside of 
> "ldap_auth.py" and I can see that when I've login my ldap user id has been 
> added to user_auth table...
>
> So the question is, where can I put some code to update or insert some 
> groups after a ldap login?
>
> Thanks!
>
> -- 
>
> Linux User #387870
> .
>  _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:___
>

[web2py] Strange grid behaviour

[Johann Spies]

The same table, the same SQLFORM.grid. Just a different query using the
query option in the grid:

When searching in the field 'title' the grid produces shows the result and
clicking on export produces a result.  The same url in both cases:

*
http://localhost:8000/akb/doccenter/browse?keywords=akb_doccenter.title+contains+%22women%22
*

Just changing the field in the same query to 'keywords' in stead of 'title'
produces the following url for the grid:

*
http://localhost:8000/akb/doccenter/browse?keywords=akb_doccenter.keywords+contains+%22women%22
*
So far so good and everything works as expected.  But when I click on
'export' in the last grid the url changes to:
*
http://localhost:8000/akb/doccenter/browse/csv?keywords=akb_doccenter.keywords+contains+%22women%22&_signature=c1e28eba26383a4f79a94ccbcc2f97e5ab7004a7
*

and on the screen:

*400 BAD REQUEST
*
I have updated my version of web2py from the trunk this morning but it is
the same on an older version.

Questions:

*  Why does the url differs that much when I try and export the two queries?
*  Why does not the first url (when I searched 'title') show a csv?keywords?
* Why the addition of the signature on the last url and not on the first
two?

Regards
Johann

-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Re: [web2py] db.Table in appadmin when used in a module

[Johann Spies]

On 29 February 2012 12:05, Bruno Rocha  wrote:

> where the akb_signature_uuid is defined?
>
> in a model or module
>

model

> from gluon import current
> current.akb_signature_uuid = akb_signature_uuid = something
>
 In the model I have

from gluon import current
current.db = db
current.akb_signature_uuid = akb_signature_uuid



then in appadmin
>
> from gluon import current
>
> does not works¿
>
No not even after adding

akb_signature_uuid = current.akb_signature_uuid in 'get_databases(request)'

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[web2py] Re: Strange grid behaviour

[Johann Spies]

Just a little bit of further information: 'title' has the type 'text'  and
'keywords' the type 'string' in the table definition.  I cannot think
however that that difference can play a role the strange problem described
in the prevous message.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[web2py] Re: In plugin_wiki meta-code tables i cannot upload data :(

[smogzer]

Guys,
could any of you at least try uploading stuff to a plugin-wiki meta-code
created database.
Just to tell me that it's just my configuration that's broken ( i tried
firefox and chromium linux ) or it's the plugin.

On Mon, Feb 27, 2012 at 12:20 AM, smogzer  wrote:

> I'm trying to create a meta-database that can be defined via meta-code and
> i've come to a bug : i can't upload data to fields in that database.
> Could anybody fix the problem ? here is a sample code for testing.
>
> http://127.0.0.1/apagar/plugin_wiki/page_edit/meta-code
> code:
> db.define_table('imagex',
> Field('id','id',represent=lambda id:SPAN(id,'
> ',A('edit',_href=URL('page',args='edit',vars=dict(table='imagex',rec=id),
> Field('name'),
> Field('type'),
> Field('picture', 'upload',requires=IS_IMAGE()),
> format = '%(name)s')
>
> for testing
> http://127.0.0.1/apagar/plugin_wiki/page/edit?table=imagex&rec=1
> code:
> ``
> {{=plugin_wiki.widget('create',table='imagex')}}
> ``:template
>
> ``
>
> {{=plugin_wiki.widget('read',table=str(request.vars.table),record_id=str(request.vars.rec))}}
> ``:template
>
> ``
>
> {{=plugin_wiki.widget('update',table=str(request.vars.table),record_id=str(request.vars.rec))}}
> ``:template
>

[web2py] smartgrid query on 2 or more tables

[Roderick]

Hi web2py users!

1. Can anyone tell me if the query input field on SQLform smartgrid
forms can do a join on 2 or more tables?
2. If so, how do I construct such a query? My attempts my failed and
can't find docs on this either...

Note - I would like users to be able to construct and type in their
own queries directly in the smartgrid query field. As these queries
will be dynamic, doing this programmatically will be difficult - if
the query can handle joins or fields from multiple tables then this
should be "pie" :)

Thanks!

[web2py] Re: web2py 1.99.5 (please read)

[Alan Etkin]

Massimo:

I've found that the timing changes to the LOAD() helper have learnt
the first lesson of not being seen. The problem is that the changes to
web2py.js I submitted in the issue 576 were not updated in the
welcome.w2p and it is not reflected in new applications. The new
web2py.js file is stored in the welcome folder:

http://code.google.com/p/web2py/source/browse/applications/welcome/static/js/web2py.js

I would like to submit a new patch. In compileapp.py, if a target is
specified for LOAD(), there remains the DIV with the randomly
generated id and the ...loading content, but it is not updated, since
the component is loaded in a target tag. Should I send the .diff to to
the old issue (closed) or add a new one to the list?

Bruno:

You mean the IMAP adapter?. It is functional currently (in trunk).

[web2py] Re: Grid examples

[Rahul]

FYI, the slice is updated for a few more things now. Thanks

Rahul D

On Feb 29, 3:06 am, greenpoise  wrote:
> Got it, typo on my part..thanks Bruce
>
> d
>
> On Feb 28, 12:49 pm, Bruce Wade  wrote:
>
>
>
>
>
>
>
> > Need to see some code before anyone can help
>
> > On Tue, Feb 28, 2012 at 12:47 PM, greenpoise wrote:
>
> > > Thanks for the lead. Why do I get duplicate grid in my view I am
> > > trying to build a simple grid and I get a duplicate grid one on top of
> > > the other.
>
> > > On Feb 28, 12:42 pm, Bruce Wade  wrote:
> > > >http://www.web2pyslices.com/slices/take_slice/148
>
> > > > On Tue, Feb 28, 2012 at 12:04 PM, greenpoise  > > >wrote:
>
> > > > > Any good source out there of grid examples? I am struggling even with
> > > > > the book in hand..The grid comes out but in an ugly manner. I just
> > > > > want to customize it to remove/add headings etc.
>
> > > > > Thanks
>
> > > > > dan
>
> > > > --
> > > > --
> > > > Regards,
> > > > Bruce Wadehttp://
> > > ca.linkedin.com/in/brucelwadehttp://www.wadecybertech.comhttp://www.warplydesigned.comhttp://www.f...
>
> > --
> > --
> > Regards,
> > Bruce 
> > Wadehttp://ca.linkedin.com/in/brucelwadehttp://www.wadecybertech.comhttp:...

Re: [web2py] Re: cron setup

[Sanjeet Kumar]

I have the following code in my crontab :-

0-59/1****root **applications/welcome/cron/test.py

and the following code in my test.py which are inside the cron folder in my
application :-

db.person.insert(name="Alex")

and i want to insert this into the table person which are defined in the
model db.py :-

db.define_table('person', Field('name'))

so please help me through this example how automatically insert/update the
data in database by using cron job.


On Tue, Feb 28, 2012 at 5:10 PM, Sanjeet Kumar wrote:

> Thanks Luciano i will try.
>
>
> On Tue, Feb 28, 2012 at 5:06 PM, Luciano Pacheco wrote:
>
>> I have written to you how to do that.
>>
>> Copy and paste:
>>
>> , but, in the example file, do this changes:
>>
>> # file: applications/instore/modules/background_updater.py
>>
>> from applications.instore.controllers.default import index
>>
>> # instead of time.sleep(5), inside the function main()
>> index()
>>
>> On Tue, Feb 28, 2012 at 10:33 PM, Sanjeet Kumar wrote:
>>
>>> Yes I want to run the index function of my default controller in a cron
>>> is this possible or not ?
>>>
>>> On Tue, Feb 28, 2012 at 4:58 PM, Luciano Pacheco wrote:
>>>
 You want to run the index function of your controller in a cron ?

 Usually it doesn't make sense, but, in the example file

 # file: applications/instore/modules/background_updater.py

 from applications.instore.controllers.default import index

 # instead of time.sleep(5), inside the function main()
 index()

 I alson didn't understand what you want, if this doesn't solve your
 question, try explain your use case.

 Regards,


 On Tue, Feb 28, 2012 at 10:00 PM, Sanjeet Kumar 
 wrote:

> I am not be able to get you properly can you give me the better
> clarification i have the default controller and the index function can you
> tell me how can i run the index function by using crontab which are in my
> application folder.
>
>
> On Tue, Feb 28, 2012 at 4:12 PM, Luciano Pacheco wrote:
>
>> Following the same example.
>>
>> In you controller:
>>
>> from applications.instore.modules.background_updater main
>>
>> def force_background_updater():
>> ret = main()
>>  return 'The result was: %s' % ret
>>
>> But, the cron is run time based tasks, usually those tasks won't be
>> used in controller.One exception is when you want to force a task to run.
>>
>> Regards,
>>
>>
>> On Tue, Feb 28, 2012 at 9:11 PM, Sanjeet Kumar > > wrote:
>>
>>> i tried this but i am not be able to run my controller Can you give
>>> me the simple example through which i can run the function written under
>>> the controller inside my application
>>>
>>>
>>> On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco 
>>> wrote:
>>>
 Example:

 http://movu.ca/demo/article/show/31/web2py-cron-task

 My first try in movu.ca :-)


 On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar <
 sanjeet@gmail.com> wrote:

> Exactly I need the examples
>
>
> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco <
> lucm...@gmail.com> wrote:
>
>> I think Sanjeet means, I example of the task.
>>
>> What is a good practice in the task, or what kind of variables
>> are present in the local namespace "automagically", etc. A task 
>> should be a
>> class a function, a python module?
>>
>> I had the same question last week when I was reading this
>> chapter. :-)
>>
>> Regards,
>> --
>> Luciano Pacheco
>> blog.lucmult.com.br
>>
>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin 
>> wrote:
>>
>>> It's all in the book (if you haven't seen yet)
>>>
>>> http://web2py.com/books/default/chapter/29/4#Cron
>>>
>>> By the way, The link in web2py to cron (http://web2py.com/books/
>>> default/reference/29/cron)
>>> is broken (returns an invalid function
>>> message)
>>>
>>> On 26 feb, 13:09, Sanjeet Kumar  wrote:
>>> > Can anyone give me the brief description to how I set the cron
>>> to run the
>>> > task in background with example.
>>>
>>
>>
>>
>>
>


 --
 Luciano Pacheco
 blog.lucmult.com.br

>>>
>>>
>>
>>
>> --
>> Luciano Pacheco
>> blog.lucmult.com.br
>>
>
>


 --
 Luciano Pacheco
 blog.lucmult.com.br

>>>
>>>
>>
>>
>> --
>> Luciano Pacheco
>> blog.lucmult.com.br
>>
>
>

[web2py] Re: web2py 1.99.5 (please read)

[weheh]

+1

On Feb 29, 4:35 am, Anthony  wrote:
> We need to make the book editable again so some of us can start adding this
> stuff to the documentation. :-)
>
>
>
>
>
>
>
> On Tuesday, February 28, 2012 3:28:09 PM UTC-5, Massimo Di Pierro wrote:
>
> > I am planning to release this tomorrow but you can test it today.
> > ***Please help us test it today*** It is really important.
>
> > There is a huge number of improvements and bug fixes. We should really
> > call this web2py 2.0 but we prefer to wait before advertising some of
> > the new features which are in but need more testing.
>
> > List not in order of importance:
>
> > - included remote debugger (thanks Mariano)
> > - gluon/contrib/htmlmin.py for html minimization (thanks kerncece)
> > - out of the box posgresql support with pg8000 diver included (thanks
> > Mariano)
> > - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert
> > Valentak)
> > - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
> > - db.table.field.regexp(...) for sqlite and postgres
> > - conditional menu items (reponse.menu=[(title,bool,link,
> > [],condition)]
> > - db(...,ignore_common_filters=True)
> > - DAL IMAP support (thanks Alan Etkin)
> > - new DAL syntax:
> > db(db.dog_id.belongs(db.dogs.owner=='james')).select()
> > - new DAL syntax: db(...).select().group_by_value(db.table.field)
> > (thanks Yair)
> > - Teradata support (experimental)
> > - populate can now deal with computed fields (thanks mweissen)
> > - def index(): return dict(a=gluon.tools.Expose(folder))
> > - auth.is_impersonating()
> > - reponse.delimiters = ('\\[','\\]') (thanks Denes)
> > - improved markmin auto-links
> > - sync languages capability (thanks Yair)
> > - better mongodb support (still experimental)
> > - auth.user_groups stores user groups
> > - new rediscache (thanks niphold)
> > - login_methods/browserid_account.py (thanks Pai)
> > - scripts/services/service.py (thanks Ross)
> > - improved ldap support (thanks Omi)
> > - added TimeCollector (thanks Caleb)
> > - better cpdb.py (thanks pasxidis)
> > - 100's of small bug fixes and small improvements

Re: [web2py] smartgrid query on 2 or more tables

[Johann Spies]

On 29 February 2012 13:35, Roderick  wrote:

> Hi web2py users!
>
> 1. Can anyone tell me if the query input field on SQLform smartgrid
> forms can do a join on 2 or more tables?
>

If you use SQLFORM.grid the answer is 'Yes'


> 2. If so, how do I construct such a query? My attempts my failed and
> can't find docs on this either...
>
>
Here is a small example:

 query = ((db.akb_doccenter.location == db.akb_doccenter_location.uuid)&
 (db.akb_doccenter.category == db.akb_doccenter_category.uuid))

  Fields = [db.akb_doccenter.title, db.akb_doccenter.author,
db.akb_doccenter.publication_date,
   db.akb_doccenter.doc_nr, db.akb_doccenter_location.location,
db.akb_doccenter_category.category]
fields = columns
opskrif = H2(T('Document Center Contents'))

links = [lambda row: A('Edit' , _href = URL('doccenter', 'akb_docedit',
args = [row.id]))]
if auth.is_logged_in() and auth.has_membership('doccenter', auth.user.id
):
data = SQLFORM.grid(query, fields = fields,
   orderby = db.akb_doccenter.title |
db.akb_doccenter.publication_date,
   #links = links, editable = False,
maxtextlength = 60)
else:

   data = SQLFORM.grid(query, fields = fields, orderby =
db.akb_doccenter.title | db.akb_doccenter.publication_date,
   deletable = False, editable = False, maxtextlength =
60)

> Note - I would like users to be able to construct and type in their
> own queries directly in the smartgrid query field. As these queries
> will be dynamic, doing this programmatically will be difficult - if
> the query can handle joins or fields from multiple tables then this
> should be "pie" :)
>
> Thanks!




-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Re: [web2py] smartgrid query on 2 or more tables

[Johann Spies]

Apololgies, Gmail's web interface and I am not always friends.  The above
message was sent before I have finished it.

Users can also build dynamic query (as long as all the tables are presented
in the original query) using the search function (query-button) that comes
with the grid.

My experience is that users do not find that function very easy to use, so
you might have to provide them with some guidelines and/or examples.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Re: [web2py] Re: cron setup

[Luciano Pacheco]

On Wed, Feb 29, 2012 at 11:10 PM, Sanjeet Kumar wrote:

> I have the following code in my crontab :-
>
> 0-59/1****root **applications/welcome/cron/test.py
>

put just 1 * before applications/

[],
-- 
Luciano Pacheco
blog.lucmult.com.br

[web2py] Anyone using Dreamhost?

[Cliff]

Can you share your experience?

Thanks,
Cliff Kachinske

Re: [web2py] Re: web2py 1.99.5 (please read)

[Bruno Rocha]

no, I mean the model-execution-mapping.

http://zerp.ly/rochacbruno
Em 29/02/2012 09:03, "Alan Etkin"  escreveu:

> Massimo:
>
> I've found that the timing changes to the LOAD() helper have learnt
> the first lesson of not being seen. The problem is that the changes to
> web2py.js I submitted in the issue 576 were not updated in the
> welcome.w2p and it is not reflected in new applications. The new
> web2py.js file is stored in the welcome folder:
>
>
> http://code.google.com/p/web2py/source/browse/applications/welcome/static/js/web2py.js
>
> I would like to submit a new patch. In compileapp.py, if a target is
> specified for LOAD(), there remains the DIV with the randomly
> generated id and the ...loading content, but it is not updated, since
> the component is loaded in a target tag. Should I send the .diff to to
> the old issue (closed) or add a new one to the list?
>
> Bruno:
>
> You mean the IMAP adapter?. It is functional currently (in trunk).
>

[web2py] Re: image upload not being deleted - 2 questions, 1 possible bug

[Anthony]

>
> Question 2: 
> How do I selectively delete the "image" field without deleting the 
> entire "test" record? In other words, I want to delete the image file 
> and null-out the image field, but leave the rest of the test record 
> intact.


I suppose you would have to explicitly delete the file. This is made a 
little more complicated by uploadseparate=True. In that case, the file is 
stored two sub-folders deep inside the field's uploadfolder -- the path to 
the file is [uploadfolder]/[tablename].[fieldname]/[first 2 characters of 
UUID portion of filename]. For example, the filename might be something 
like test.name.9d4498f37ce2b906.746573742066696c652e6a7067.jpg (the 
highlighted segment after the table and field name is the UUID fragment). 
The path to that file would be 
/static/data/test.name/9d/test.name.9d4498f37ce2b906.746573742066696c652e6a7067.jpg.
 
To delete the file associated with a particular record (warning: all code 
below untested):

file_to_delete = db(db.test.id==[id to delete]).select().first().name
import os
os.remove(os.path.join(db.test.name.uploadfolder, 'test.name',
file_to_delete.split('.')[2][:2], file_to_delete))

You could also abstract this into a general function that also updates the 
db record:

def delete_file(row, uploadfield):
import os
file = row[uploadfield]
table, field, subfolder = file.split('.')[0:3]
subfolder = subfolder[:2]
os.remove(os.path.join(db[table][field].uploadfolder,
'%s.%s' % (table, field), subfolder, file))
row.update_record(**{uploadfield: None})

Anthony

Re: [web2py] db.Table in appadmin when used in a module

[Bruce Wade]

Is there any reason you have a extra comma in the __init__ method?
def __init__(self, db*,*):

On Wed, Feb 29, 2012 at 3:14 AM, Johann Spies wrote:

> On 29 February 2012 12:05, Bruno Rocha  wrote:
>
>> where the akb_signature_uuid is defined?
>>
>> in a model or module
>>
>
> model
>
>> from gluon import current
>> current.akb_signature_uuid = akb_signature_uuid = something
>>
>  In the model I have
>
> from gluon import current
> current.db = db
> current.akb_signature_uuid = akb_signature_uuid
>
>
>
>  then in appadmin
>>
>> from gluon import current
>>
>> does not works¿
>>
> No not even after adding
>
> akb_signature_uuid = current.akb_signature_uuid in 'get_databases(request)'
>
>
> Regards
> Johann
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)
>
>


-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

Re: [web2py] Anyone using Dreamhost?

[Bruce Wade]

I used them a very long time ago, but moved to hostmonster because they
have better prices and service.

On Wed, Feb 29, 2012 at 5:55 AM, Cliff  wrote:

> Can you share your experience?
>
> Thanks,
> Cliff Kachinske




-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

[web2py] Re: Deleting upload files -- possible bug?

[Anthony]

>
> Grrr. Sorry to go around in circles on this. I traced my code some 
> more and, yes, there was a bug. But I fixed it and yet the upload file 
> is not being deleted. As improbable as it seems that this would be a 
> bug in web2py, my Question #1 above remains open.


Using the latest trunk, I tried your exact table definition (minus the 
reference field), and deleting a record did result in the two uploaded 
files being deleted as well (on Windows 7).

Anthony
 

[web2py] Re: web2py 1.99.5 (please read)

[Massimo Di Pierro]

No. It is pending this release.

On Feb 29, 3:56 am, Bruno Rocha  wrote:
> is the experimental model map included? or it is not done yet?
>
> http://zerp.ly/rochacbruno
> Em 28/02/2012 17:28, "Massimo Di Pierro" 
> escreveu:
>
>
>
>
>
>
>
> > I am planning to release this tomorrow but you can test it today.
> > ***Please help us test it today*** It is really important.
>
> > There is a huge number of improvements and bug fixes. We should really
> > call this web2py 2.0 but we prefer to wait before advertising some of
> > the new features which are in but need more testing.
>
> > List not in order of importance:
>
> > - included remote debugger (thanks Mariano)
> > - gluon/contrib/htmlmin.py for html minimization (thanks kerncece)
> > - out of the box posgresql support with pg8000 diver included (thanks
> > Mariano)
> > - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert
> > Valentak)
> > - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
> > - db.table.field.regexp(...) for sqlite and postgres
> > - conditional menu items (reponse.menu=[(title,bool,link,
> > [],condition)]
> > - db(...,ignore_common_filters=True)
> > - DAL IMAP support (thanks Alan Etkin)
> > - new DAL syntax:
> > db(db.dog_id.belongs(db.dogs.owner=='james')).select()
> > - new DAL syntax: db(...).select().group_by_value(db.table.field)
> > (thanks Yair)
> > - Teradata support (experimental)
> > - populate can now deal with computed fields (thanks mweissen)
> > - def index(): return dict(a=gluon.tools.Expose(folder))
> > - auth.is_impersonating()
> > - reponse.delimiters = ('\\[','\\]') (thanks Denes)
> > - improved markmin auto-links
> > - sync languages capability (thanks Yair)
> > - better mongodb support (still experimental)
> > - auth.user_groups stores user groups
> > - new rediscache (thanks niphold)
> > - login_methods/browserid_account.py (thanks Pai)
> > - scripts/services/service.py (thanks Ross)
> > - improved ldap support (thanks Omi)
> > - added TimeCollector (thanks Caleb)
> > - better cpdb.py (thanks pasxidis)
> > - 100's of small bug fixes and small improvements

[web2py] Re: web2py 1.99.5 (please read)

[Massimo Di Pierro]

No. But I believe Tim knows what the problem is and is working on it.

On Feb 29, 1:33 am, Phyo Arkar  wrote:
> Is the corruption of download and upload during slow connection fixed
> (Rocket problem) ?
>
> Thanks
>
> Phyo.
>
> On 2/29/12, Mariano Reingart  wrote:
>
>
>
>
>
>
>
> > On Tue, Feb 28, 2012 at 8:08 PM, Richard Galka 
> > wrote:
> >> A couple minor points with the admin pages and the new debugging section:
>
> >> In the Admin -> Debug -> breakpoints -> Add breakpoints section, if the
> >> current application has long directory & file names then the table's hints
> >> run off the page.
>
> > Something similar occurs when you catch an exception (debug
> > interaction page, right pane).
> > Maybe wrapping long filenames could be done with css.
>
> > I've uploaded some screenshots at the issue:
>
> >http://code.google.com/p/web2py/issues/detail?id=666
>
> > If anyone can send a css patch or a better form/layout, it would be
> > appreciated.
>
> >> I think it may be pertinent to identify that in the above section, only
> >> breakpoints set through the web editor are identified. (IE: direct file
> >> edit
> >> adding breakpoints work, but are not identified in the 'breakpoints'
> >> section).
>
> > That's correct,  set_trace is not a real breakpoint, it just forces
> > the debugger to stop at that line.
> > Maybe the tip should be changed from "programatically setting
> > breakpoint using..." to something better.
>
> > Best regards,
>
> > Mariano Reingart
> >http://www.sistemasagiles.com.ar
> >http://reingart.blogspot.com

[web2py] Re: smartgrid query on 2 or more tables

[Roderick]

Thanks Johann!

1. Can this be done with smartgrid?
2. Can you give me an example of a dynamic query (e.g. what users
would type into the search field)? (for grid or smartgrid).

Thanks!

On Feb 29, 2:44 pm, Johann Spies  wrote:
> Apololgies, Gmail's web interface and I am not always friends.  The above
> message was sent before I have finished it.
>
> Users can also build dynamic query (as long as all the tables are presented
> in the original query) using the search function (query-button) that comes
> with the grid.
>
> My experience is that users do not find that function very easy to use, so
> you might have to provide them with some guidelines and/or examples.
>
> Regards
> Johann
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)

[web2py] Re: Deleting upload files -- possible bug?

[Massimo Di Pierro]

Please open a ticket, this may be a bug.

On Feb 29, 8:37 am, Anthony  wrote:
> > Grrr. Sorry to go around in circles on this. I traced my code some
> > more and, yes, there was a bug. But I fixed it and yet the upload file
> > is not being deleted. As improbable as it seems that this would be a
> > bug in web2py, my Question #1 above remains open.
>
> Using the latest trunk, I tried your exact table definition (minus the
> reference field), and deleting a record did result in the two uploaded
> files being deleted as well (on Windows 7).
>
> Anthony

[web2py] Re: Deleting upload files -- possible bug?

[Anthony]

To be clear, I *cannot *reproduce this problem. weheh, when you delete a 
record, does it properly delete the file associated with the 'name' field 
but fail to delete the file associated with the 'image' field, or are both 
files being left behind? I notice the 'name' field uploads to 'static', but 
the 'image' field uses the default upload folder (i.e., 'uploads') -- is it 
possible there is a permissions issue with the 'uploads' folder?

Anthony

On Wednesday, February 29, 2012 9:49:46 AM UTC-5, Massimo Di Pierro wrote:
>
> Please open a ticket, this may be a bug. 
>
> On Feb 29, 8:37 am, Anthony  wrote: 
> > > Grrr. Sorry to go around in circles on this. I traced my code some 
> > > more and, yes, there was a bug. But I fixed it and yet the upload file 
> > > is not being deleted. As improbable as it seems that this would be a 
> > > bug in web2py, my Question #1 above remains open. 
> > 
> > Using the latest trunk, I tried your exact table definition (minus the 
> > reference field), and deleting a record did result in the two uploaded 
> > files being deleted as well (on Windows 7). 
> > 
> > Anthony


On Wednesday, February 29, 2012 9:49:46 AM UTC-5, Massimo Di Pierro wrote:
>
> Please open a ticket, this may be a bug. 
>
> On Feb 29, 8:37 am, Anthony  wrote: 
> > > Grrr. Sorry to go around in circles on this. I traced my code some 
> > > more and, yes, there was a bug. But I fixed it and yet the upload file 
> > > is not being deleted. As improbable as it seems that this would be a 
> > > bug in web2py, my Question #1 above remains open. 
> > 
> > Using the latest trunk, I tried your exact table definition (minus the 
> > reference field), and deleting a record did result in the two uploaded 
> > files being deleted as well (on Windows 7). 
> > 
> > Anthony

[web2py] Re: Thumbnails

[peter]

If you visit

http://github.com/hutchi0/web2py-for-fluxflex

and look at the gallery application it builds thumbnails automatically
Peter

On Feb 28, 9:14 pm, Bruno Rocha  wrote:
> I do it using the compute attribute, take a 
> look:http://movu.ca/demo/article/show/36/creating-thumbnails-with-web2py
>
> On Tue, Feb 28, 2012 at 3:32 PM, Ivan Vilches Basaul <
>
> ivan_vilc...@hotmail.com> wrote:
> > Any way for automatic thumbnails creation?
> > Thanks
>
> > Ivan Vilches Basaul
>
> --
>
> Bruno Rocha
> [http://rochacbruno.com.br]

Re: [web2py] Re: Admin Disabled

[Bruce Wade]

Thanks that worked.

My web2py process is starting with my logged in user. I did this to prevent
having to su all the time, and I can do git pull and changes from a single
user account.

Anyway with my setup you don't need: sudo -u user_name instead you just run:

python -c "from gluon.widget import console; console();"
python -c "from gluon.main import save_password;
save_password(raw_input('admin password: '),443)"


On Tue, Feb 28, 2012 at 6:46 PM, Bruce Wade  wrote:

> Yes I have ssh. The site is on an amazon ubuntu instance.
>
> If my python process is running with a user other then www-data do I just
> change the first part of the command?
>
> sudo -u user_name python -c "from gluon main import save_password;
> save_password(raw_input('admin password:'), 443)"
>
>
> On Tue, Feb 28, 2012 at 5:46 PM, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> Do you have ssh access? You better do.
>>
>> cd under web2py/
>> then do:
>> sudo -u www-data python -c "from gluon.main import save_password;
>> save_password(raw_input('admin password: '),443)"
>>
>> replace 443 with the port you use for admin. Should be 443 for https
>>
>> On Feb 28, 7:15 pm, Bruce Wade  wrote:
>> > For some reason the admin interface was not accepting the new password I
>> > created on my development server. Now it says admin has been disabled
>> how
>> > do I re-enable it?
>> >
>> > --
>> > --
>> > Regards,
>> > Bruce Wadehttp://
>> ca.linkedin.com/in/brucelwadehttp://www.wadecybertech.comhttp://www.warplydesigned.comhttp://www.fitnessfriendsfinder.com
>>
>
>
>
> --
> --
> Regards,
> Bruce Wade
> http://ca.linkedin.com/in/brucelwade
> http://www.wadecybertech.com
> http://www.warplydesigned.com
> http://www.fitnessfriendsfinder.com
>



-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

[web2py] important - need help with file locking

[Massimo Di Pierro]

I believe we have a problem with file locking. I managed to isolate
the problem in this non-web2py pure-python program:

 begin file test.py ==
import fcntl
import multiprocessing
import unittest

N=1

def lock(fp, mode):
fcntl.flock(fp.fileno(), mode)

def unlock(fp):
fcntl.flock(fp.fileno(), fcntl.LOCK_UN)

def read_write(args):
(filename, iterations) = args
for i in range(0, iterations):
fp = open(filename,'r')
lock(fp,fcntl.LOCK_SH) # shared
lock
content = fp.read()
unlock(fp) #
unlock
fp.close()
if len(content)!=N:
return False
fp = open(filename,'w')
lock(fp,fcntl.LOCK_EX) # exclusive
lock
fp.write(content)
unlock(fp) #
unlock
fp.close()
return True

class TestParallelLocks(unittest.TestCase):

def setUp(self):
self.filename = 'test.txt'
contents = 'x'*N
fp = open(self.filename,'w')
fp.write(contents)
fp.close()

def tearDown(self):
try:
os.remove(self.filename)
except:
pass

def test_reads_and_writes(self):
readwriters = 10
pool = multiprocessing.Pool(processes = readwriters)
results = pool.map(read_write, [[self.filename, 10]] *
readwriters)
for result in results:
self.assertTrue(result)

if __name__ == '__main__':
unittest.main()
= end file test.py 

If I run it with python test.py it will often fail the test (tested on
Mac Leopard, Lion, Ubuntu, Python 2.5, 2.6, 2.7).

HELP! Can you reproduce the problem? Do you see anything wrong with
the code?

Massimo

[web2py] Re: important - need help with file locking

[Massimo Di Pierro]

Found the problem with some help from a friend in the Chicago Python
users group.

One problem is flushing before unlocking the file. Another is that
opening the file for writing truncates the file before the exclusive
lock is acquired.

On Feb 29, 11:46 am, Massimo Di Pierro 
wrote:
> I believe we have a problem with file locking. I managed to isolate
> the problem in this non-web2py pure-python program:
>
>  begin file test.py ==
> import fcntl
> import multiprocessing
> import unittest
>
> N=1
>
> def lock(fp, mode):
>     fcntl.flock(fp.fileno(), mode)
>
> def unlock(fp):
>     fcntl.flock(fp.fileno(), fcntl.LOCK_UN)
>
> def read_write(args):
>     (filename, iterations) = args
>     for i in range(0, iterations):
>         fp = open(filename,'r')
>         lock(fp,fcntl.LOCK_SH) # shared
> lock
>         content = fp.read()
>         unlock(fp)             #
> unlock
>         fp.close()
>         if len(content)!=N:
>             return False
>         fp = open(filename,'w')
>         lock(fp,fcntl.LOCK_EX) # exclusive
> lock
>         fp.write(content)
>         unlock(fp)             #
> unlock
>         fp.close()
>     return True
>
> class TestParallelLocks(unittest.TestCase):
>
>     def setUp(self):
>         self.filename = 'test.txt'
>         contents = 'x'*N
>         fp = open(self.filename,'w')
>         fp.write(contents)
>         fp.close()
>
>     def tearDown(self):
>         try:
>             os.remove(self.filename)
>         except:
>             pass
>
>     def test_reads_and_writes(self):
>         readwriters = 10
>         pool = multiprocessing.Pool(processes = readwriters)
>         results = pool.map(read_write, [[self.filename, 10]] *
> readwriters)
>         for result in results:
>             self.assertTrue(result)
>
> if __name__ == '__main__':
>     unittest.main()
> = end file test.py 
>
> If I run it with python test.py it will often fail the test (tested on
> Mac Leopard, Lion, Ubuntu, Python 2.5, 2.6, 2.7).
>
> HELP! Can you reproduce the problem? Do you see anything wrong with
> the code?
>
> Massimo

[web2py] Re: Possible bug with a referenced field?

[tsvim]

Hi,

I attached a file with code that reproduces the problem.
For this example I expect to only return options African and Swallow, not 
John and not Doe.
I traced the problem back to the call from sqlhtml.py on line 217 to the 
IS_IN_DB validators function options(). I'm not sure if the fix should be 
in the widget or in the IS_IN_DB validator.
Personally I'd fix it in the IS_IN_DB validator, but then that might break 
the way request_tenant was intended to behave and/or break backwards 
compatibiity.

If you tell me where you want it fixed I might be able to cook up a patch 
over the weekend,

Thanks,

Tsvi

On Wednesday, February 29, 2012 12:47:04 AM UTC+2, tsvim wrote:
>
> Hi,
>
> In my models I have 2 tables, where table 1 has field "a" referencing
> table 2. As each user has a bunch of fields both in table 1 as well as
> in table 2, I used the request_tenant field with some uuid in both
> tables which is tied to the user (I'm not using the users ID for
> various reasons).
> I tried creating a form for table 1 with SQLFORM, but the select
> dropdown for field "a" returns all the items in table 2, and doesn't
> filter them according to the request_tenant field, which I would
> consider the correct behavior.
>
> I'll show some code tomorrow.
> Can you confirm this being a bug? Or am I missing something?
>
> Thanks,
>
> Tsvi
> Sent from my phone
>
>
On Wednesday, February 29, 2012 12:47:04 AM UTC+2, tsvim wrote:
>
> Hi,
>
> In my models I have 2 tables, where table 1 has field "a" referencing
> table 2. As each user has a bunch of fields both in table 1 as well as
> in table 2, I used the request_tenant field with some uuid in both
> tables which is tied to the user (I'm not using the users ID for
> various reasons).
> I tried creating a form for table 1 with SQLFORM, but the select
> dropdown for field "a" returns all the items in table 2, and doesn't
> filter them according to the request_tenant field, which I would
> consider the correct behavior.
>
> I'll show some code tomorrow.
> Can you confirm this being a bug? Or am I missing something?
>
> Thanks,
>
> Tsvi
> Sent from my phone
>
>db = DAL('sqlite://storage.sqlite')
db._common_fields.append(Field('request_tenant',default=lambda: session.token,writable=False))
db.define_table('a',Field('name','string'),format='%(name)s')
db.define_table('b',Field('a_name','reference a'))
session.token = '1234'
sample_list = [{'name':'John'},{'name':'Doe'}]
db.a.bulk_insert(sample_list)
session.token = '4567'
sample_list = [{'name':'African'},{'name':'Swallow'}]
db.a.bulk_insert(sample_list)
form = SQLFORM(db.b)
print form

Re: [web2py] Re: web2py 1.99.5 (please read)

[Richard Vézina]

Here some more information on the ticket it raises :

(self=, value=1,
field_type='db.auth_user', blob_decode=True)
Code listing

1498.
1499.
1500.
1501.
1502.
1503.

1504.
1505.
1506.
1507.

return value
elif field_type == 'blob' and not blob_decode:
return value
else:
key = regex_type.match(field_type).group(0)
return self.parsemap[key](value,field_type)


def parse_reference(self, value, field_type):
referee = field_type[10:].strip()
if not '.' in referee:

Variablesfield_type'db.auth_user'self
self.parsemap{'blob': >, 'boolean': >,
'date': >, 'datetime': >,
'decimal': >, 'double': >,
'id': >, 'integer': >,
'list:integer': >, 'list:reference': >, ...}key'db'value1

It comes form this line in user function of default.py controller that I
change a bit :

form = auth()


Here what I am doing :

def user():
"""
...
"""
form = auth()
auth.settings.formstyle = 'table3cols'
if request.args(0) == 'login':

form[0][1][1].append(SPAN((A(forget_pwd_icon(),_href=URL(r=request,c='default',f='user',args=('request_reset_password'))),
SPAN(T('Click on icon if you forgot your password...'))),
_class='logintip'))
return dict(form=form,layout='login_layout.html')
elif request.args(0) == 'profile':
return dict(form='you are not allowed
(permission)',layout='layout.html')
elif request.args(0) == 'request_reset_password':
if not 'request_reset_password' in auth.settings.actions_disabled:
return dict(form=auth(),layout='login_layout.html')
else:
return dict(form=form,layout='layout.html')
return dict(form=form,layout='layout.html')


But I bypass the index and user function from my app and I still get the
error... I believe that it could come from the postgres adapter some how...
If you remember I use 'myIdName','id' to use my own custom table id name
and also redefine the sequence name since the default sequence name build
up of postgres is different from the one of web2py... Hope it helps.

What else (i mean which changes) could cause this problem?

Thanks.

Richard


2012/2/28 Massimo Di Pierro 

> What triggers it? I need a little more info.
>
> On Feb 28, 3:22 pm, Richard Vézina 
> wrote:
> >  'db'
> >
> > With trunk and copied my app in application folder...
> >
> > Richard
> >
> > On Tue, Feb 28, 2012 at 4:01 PM, Massimo Di Pierro <
> >
> >
> >
> >
> >
> >
> >
> > massimo.dipie...@gmail.com> wrote:
> > > No. If you have time test the debugger. That is a major piece of code
> > > that you will notice right away. Mariano can explain better than me.
> >
> > > The other features have been reasonably tested.
> >
> > > Massimo
> >
> > > On Feb 28, 2:46 pm, szimszon  wrote:
> > > > +1
> >
> > > > Anyway it could be good to have some more hint about what the new
> > > features
> > > > do. So we can easily test without to follow all conversation about
> > > features
> > > > between versions :-o
> >
> > > > 2012. február 28., kedd 21:35:03 UTC+1 időpontban Anthony a
> következőt
> > > írta:
> >
> > > > > We need to make the book editable again so some of us can start
> adding
> > > > > this stuff to the documentation. :-)
> >
> > > > > On Tuesday, February 28, 2012 3:28:09 PM UTC-5, Massimo Di Pierro
> > > wrote:
> >
> > > > >> I am planning to release this tomorrow but you can test it today.
> > > > >> ***Please help us test it today*** It is really important.
> >
> > > > >> There is a huge number of improvements and bug fixes. We should
> really
> > > > >> call this web2py 2.0 but we prefer to wait before advertising
> some of
> > > > >> the new features which are in but need more testing.
> >
> > > > >> List not in order of importance:
> >
> > > > >> - included remote debugger (thanks Mariano)
> > > > >> - gluon/contrib/htmlmin.py for html minimization (thanks kerncece)
> > > > >> - out of the box posgresql support with pg8000 diver included
> (thanks
> > > > >> Mariano)
> > > > >> - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert
> > > > >> Valentak)
> > > > >> - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
> > > > >> - db.table.field.regexp(...) for sqlite and postgres
> > > > >> - conditional menu items (reponse.menu=[(title,bool,link,
> > > > >> [],condition)]
> > > > >> - db(...,ignore_common_filters=True)
> > > > >> - DAL IMAP support (thanks Alan Etkin)
> > > > >> - new DAL syntax:
> > > > >> db(db.dog_id.belongs(db.dogs.owner=='james')).select()
> > > > >> - new DAL syntax: db(...).select().group_by_value(db.table.field)
> > > > >> (thanks Yair)
> > > > >> - Teradata support (experimental)
> > > > >> - populate can now deal with computed fields (thanks mweissen)
> > > > >> - def index(): return dict(a=gluon.tools.Expose(folder))
> > > > >> - auth.is_impersonating()
> > > > >> - reponse.delimiters = ('\\[','\\]') (thanks Denes)
> > > > >> - improved markmin auto-links
> > > > >> - sync languages capa

Re: [web2py] Re: web2py 1.99.5 (please read)

[Richard Vézina]

Forget to mention. I also try the welcome app with postgres with no
problem. I create a use and can logon and logoff...

Richard

2012/2/29 Richard Vézina 

> Here some more information on the ticket it raises :
>
>  (self=, value=1,
> field_type='db.auth_user', blob_decode=True)
>  Code listing
>
> 1498.
> 1499.
> 1500.
> 1501.
> 1502.
>
> 1503.
>
> 1504.
> 1505.
> 1506.
> 1507.
>
> return value
>
> elif field_type == 'blob' and not blob_decode:
>
> return value
>
> else:
>
> key = regex_type.match(field_type).group(0)
>
> return self.parsemap[key](value,field_type)
>
>
> def parse_reference(self, value, field_type):
>
> referee = field_type[10:].strip()
>
> if not '.' in referee:
>
>  Variables  field_type 'db.auth_user' self  object> self.parsemap {'blob':  of >, 'boolean':  PostgreSQLAdapter.parse_boolean of >,
> 'date':  >, 'datetime':  PostgreSQLAdapter.parse_datetime of >,
> 'decimal':  >, 'double':  PostgreSQLAdapter.parse_double of >,
> 'id':  >, 'integer':  PostgreSQLAdapter.parse_integer of >,
> 'list:integer':  >, 'list:reference':  PostgreSQLAdapter.parse_list_references of  object>>, ...}  key 'db' value 1
>
> It comes form this line in user function of default.py controller that I
> change a bit :
>
> form = auth()
>
>
> Here what I am doing :
>
> def user():
> """
> ...
> """
> form = auth()
> auth.settings.formstyle = 'table3cols'
> if request.args(0) == 'login':
>
> form[0][1][1].append(SPAN((A(forget_pwd_icon(),_href=URL(r=request,c='default',f='user',args=('request_reset_password'))),
> SPAN(T('Click on icon if you forgot your password...'))),
> _class='logintip'))
> return dict(form=form,layout='login_layout.html')
> elif request.args(0) == 'profile':
> return dict(form='you are not allowed
> (permission)',layout='layout.html')
> elif request.args(0) == 'request_reset_password':
> if not 'request_reset_password' in auth.settings.actions_disabled:
> return dict(form=auth(),layout='login_layout.html')
> else:
> return dict(form=form,layout='layout.html')
> return dict(form=form,layout='layout.html')
>
>
> But I bypass the index and user function from my app and I still get the
> error... I believe that it could come from the postgres adapter some how...
> If you remember I use 'myIdName','id' to use my own custom table id name
> and also redefine the sequence name since the default sequence name build
> up of postgres is different from the one of web2py... Hope it helps.
>
> What else (i mean which changes) could cause this problem?
>
> Thanks.
>
> Richard
>
>
> 2012/2/28 Massimo Di Pierro 
>
>> What triggers it? I need a little more info.
>>
>> On Feb 28, 3:22 pm, Richard Vézina 
>> wrote:
>> >  'db'
>> >
>> > With trunk and copied my app in application folder...
>> >
>> > Richard
>> >
>> > On Tue, Feb 28, 2012 at 4:01 PM, Massimo Di Pierro <
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > massimo.dipie...@gmail.com> wrote:
>> > > No. If you have time test the debugger. That is a major piece of code
>> > > that you will notice right away. Mariano can explain better than me.
>> >
>> > > The other features have been reasonably tested.
>> >
>> > > Massimo
>> >
>> > > On Feb 28, 2:46 pm, szimszon  wrote:
>> > > > +1
>> >
>> > > > Anyway it could be good to have some more hint about what the new
>> > > features
>> > > > do. So we can easily test without to follow all conversation about
>> > > features
>> > > > between versions :-o
>> >
>> > > > 2012. február 28., kedd 21:35:03 UTC+1 időpontban Anthony a
>> következőt
>> > > írta:
>> >
>> > > > > We need to make the book editable again so some of us can start
>> adding
>> > > > > this stuff to the documentation. :-)
>> >
>> > > > > On Tuesday, February 28, 2012 3:28:09 PM UTC-5, Massimo Di Pierro
>> > > wrote:
>> >
>> > > > >> I am planning to release this tomorrow but you can test it today.
>> > > > >> ***Please help us test it today*** It is really important.
>> >
>> > > > >> There is a huge number of improvements and bug fixes. We should
>> really
>> > > > >> call this web2py 2.0 but we prefer to wait before advertising
>> some of
>> > > > >> the new features which are in but need more testing.
>> >
>> > > > >> List not in order of importance:
>> >
>> > > > >> - included remote debugger (thanks Mariano)
>> > > > >> - gluon/contrib/htmlmin.py for html minimization (thanks
>> kerncece)
>> > > > >> - out of the box posgresql support with pg8000 diver included
>> (thanks
>> > > > >> Mariano)
>> > > > >> - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert
>> > > > >> Valentak)
>> > > > >> - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
>> > > > >> - db.table.field.regexp(...) for sqlite and postgres
>> > > > >> - conditional menu items (reponse.menu=[(title,bool,link,
>> > > > >> [],condition)]
>> > > > >> - db(...,ignore_common_filters

[web2py] Re: Database deadlocks with new scheduler

[David Phillips]

Thanks for the advice, Massimo.

Yes, I am calling db.scheduler_task.insert() inside a controller.

On the theory that it could do harm, I put a db.commit() immediately
after the insert and that helped, some.

Now I'm getting the scheduler exception in my worker process about a
third as often, and when it occurs, I can clear the deadlock easier.
Sometimes, I can just restart the worker process. Sometimes I have to
user the MySQL client to stop the query (ie., mysql> kill query
24843;) (I don't want it to sound like I really understand how to
clear the deadlock. I'm just doing something I read about on
stackoverflow.)

I'd like to understand better how the deadlocks arise and what I can
do to prevent them.

Thanks.
David


On Feb 27, 11:11 pm, Massimo Di Pierro 
wrote:
> Do you do this in a controller?
>
> db.scheduler_task.insert(...)
>
> if not. Make sure you db.commit() immediately after. Would is solve
> the problem?
>
> On Feb 27, 9:14 pm, David Phillips 
> wrote:
>
>
>
>
>
>
>
> > I am experiencing database deadlocks in a worker processes that is
> > being scheduled by web2py's newscheduler.
>
> > I'm using the latest web2py with Python 2.7.2 and MySQL (a recent
> > release) on OS X 10.7.3.
>
> > The worker does a lengthy calculation that I wanted to take off the
> > http thread. Every time I get a certain action, I schedule the thread
> > programmatically like this:
>
> > db.scheduler_task.insert(application_name = 'geo', task_name =
> > 'match_task',
> >                                 function_name = 'match_listings', vars = 
> > json.dumps(vars))
>
> > In my testing I execute this task about once every two seconds. It has
> > failed in two separate tests after about an hour.
>
> > I'm getting this traceback:
>
> >   File "/Users/davidp/dev/python/web2py/gluon/shell.py", line 214, in
> > run
> >     exec(python_code, _env)
> >   File "", line 1, in 
> >   File "/Users/davidp/dev/python/web2py/gluon/scheduler.py", line 363,
> > in loop
> >     MetaScheduler.loop(self)
> >   File "/Users/davidp/dev/python/web2py/gluon/scheduler.py", line 255,
> > in loop
> >     task = self.pop_task()
> >   File "/Users/davidp/dev/python/web2py/gluon/scheduler.py", line 392,
> > in pop_task
> >     grabbed.update(assigned_worker_name='',status=QUEUED)
> >   File "/Users/davidp/dev/python/web2py/gluon/dal.py", line 6346, in
> > update
> >     return self.db._adapter.update(tablename,self.query,fields)
> >   File "/Users/davidp/dev/python/web2py/gluon/dal.py", line 1093, in
> > update
> >     self.execute(sql)
> >   File "/Users/davidp/dev/python/web2py/gluon/dal.py", line 1359, in
> > execute
> >     return self.log_execute(*a, **b)
> >   File "/Users/davidp/dev/python/web2py/gluon/dal.py", line 1353, in
> > log_execute
> >     ret = self.cursor.execute(*a, **b)
> >   File "/Users/davidp/dev/python/web2py/gluon/contrib/pymysql/
> > cursors.py", line 108, in execute
> >     self.errorhandler(self, exc, value)
> >   File "/Users/davidp/dev/python/web2py/gluon/contrib/pymysql/
> > connections.py", line 184, in defaulterrorhandler
> >     raise errorclass, errorvalue
> > InternalError: (1213, u'Deadlockfound when trying to get lock; try
> > restarting transaction')
>
> > When executed, the task does this SQL select:
>
> > expr = '''SELECT *, ( 3959 * acos (cos (radians (%s)) * cos (radians
> > (lat)) *
> >         cos (radians (lon) - radians (%s)) + sin (radians (%s)) * sin
> > (radians (lat
> >         AS distance FROM users HAVING distance < radius;''' % (point[0],
> > point[1], point[0])
> >         nearby_users = db.executesql(expr, as_dict = True)
>
> > and then does a read to collect some statistics to track performance:
>
> >         num_listings = db (db.listings.id > 0).count()
>
> > During this time, I am receiving asynchronous http requests that
> > insert, update and delete from this table (and another table, too).
>
> > My MySQL client responds to a "show engine innodb  status;" command
> > this way:
>
> > 
> > LATEST DETECTEDDEADLOCK
> > 
> > 120227 20:38:16
> > *** (1) TRANSACTION:
> > TRANSACTION 27AFF, ACTIVE 0 sec starting index read
> > mysql tables in use 1, locked 1
> > LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s), undo log
> > entries 1
> > MySQL thread id 19816, OS thread handle 0x10c5db000, query id 1558959
> > localhost 127.0.0.1 root Updating
> > UPDATE scheduler_task SET status='QUEUED',assigned_worker_name=''
> > WHERE ((scheduler_task.assigned_worker_name = 'Mycroft.local#d600fcf2-
> > a363-4870-bd24-1ad3694f6a62') AND (scheduler_task.status =
> > 'ASSIGNED'))
> > *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
> > RECORD LOCKS space id 0 page no 3031 n bits 120 index `PRIMARY` of
> > table `geo`.`scheduler_task` trx id 27AFF lock_mode X waiting
> > Record lock, heap no 2 PHYSICAL RECORD: n_fields 20; compact format;
> > info bits 0
> >  0: len 4; hex 802c; asc    ,;;
> >  1: len 6; hex 00024db1; asc     M ;;
> >  2: len 7; 

[web2py] windows users? need help with a test...

[Massimo Di Pierro]

Download the latest nightly build (just posted). Open welcome, edit a
language file and save it. Does it work fine?

[web2py] Re: windows users? need help with a test...

[Carlos]

Hi Massimo,

Do you mean go to the following url and click "update"?

http://localhost:8000/admin/default/edit_language/welcome/languages/es-es.py

It saved without problems.

   Carlos


On Wednesday, February 29, 2012 1:48:27 PM UTC-6, Massimo Di Pierro wrote:
>
> Download the latest nightly build (just posted). Open welcome, edit a 
> language file and save it. Does it work fine?

[web2py] Re: windows users? need help with a test...

[Anthony]

If you're asking whether admin successfully saves changes to a language 
file on Windows, it seems to be working for me using the latest trunk.

Anthony

On Wednesday, February 29, 2012 3:25:17 PM UTC-5, Carlos wrote:
>
> Hi Massimo,
>
> Do you mean go to the following url and click "update"?
>
>
> http://localhost:8000/admin/default/edit_language/welcome/languages/es-es.py
>
> It saved without problems.
>
>Carlos
>
>
> On Wednesday, February 29, 2012 1:48:27 PM UTC-6, Massimo Di Pierro wrote:
>>
>> Download the latest nightly build (just posted). Open welcome, edit a 
>> language file and save it. Does it work fine?
>
>

Re: [web2py] Computed field not working

[Richard Vézina]

You can't access valor_do_dolar from custo_em_real lambda computed since it
is a computed field that get computed un submit... If you want to do that
you will have to make a real function that get process on submit with
form.process().accepted and the argument onsuccess or onvalidation

See chapter 7 with both keyword here a link for the first keyword :

http://web2py.com/books/default/chapter/29/7?search=onsuccess

Richard

On Wed, Feb 29, 2012 at 3:51 PM, Tito Garrido  wrote:

> Hi Folks,
>
> I am trying a simple example using sqlite:
>
> db.define_table('compra_produto',
> Field('compra', 'reference compra'),
> Field('produto','reference produto'),
> Field('quantidade','integer'),
> Field('custo_em_dolar','double'),
> Field('cotacao_do_dolar','double'),
> Field('custo_em_real', compute=lambda cr:
> cr['custo_em_dolar']*cr['valor_do_dolar']),
> Field('valor_total', compute=lambda vt:
> vt['custo_em_real']*vt['quantidade'])
>
> But both computed fields are always set as "None"... I am trying it from
> administrative database screen...
>
> Am I doing anything wrong?
>
> --
>
> Linux User #387870
> .
>  _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:___
>

Re: [web2py] Computed field not working

[Tito Garrido]

Nice Catch, but I have commented the last field to apply what you suggested
and this also doesn't work:
db.define_table('compra_produto',
Field('compra', 'reference compra'),
Field('produto','reference produto'),
Field('quantidade','integer'),
Field('custo_em_dolar','double'),
Field('cotacao_do_dolar','double'),
Field('custo_em_real', compute=lambda cr:
cr['custo_em_dolar']*cr['valor_do_dolar']),
)

On Wed, Feb 29, 2012 at 6:06 PM, Richard Vézina  wrote:

> You can't access valor_do_dolar from custo_em_real lambda computed since
> it is a computed field that get computed un submit... If you want to do
> that you will have to make a real function that get process on submit with
> form.process().accepted and the argument onsuccess or onvalidation
>
> See chapter 7 with both keyword here a link for the first keyword :
>
> http://web2py.com/books/default/chapter/29/7?search=onsuccess
>
> Richard
>
> On Wed, Feb 29, 2012 at 3:51 PM, Tito Garrido wrote:
>
>> Hi Folks,
>>
>> I am trying a simple example using sqlite:
>>
>> db.define_table('compra_produto',
>> Field('compra', 'reference compra'),
>> Field('produto','reference produto'),
>> Field('quantidade','integer'),
>> Field('custo_em_dolar','double'),
>> Field('cotacao_do_dolar','double'),
>> Field('custo_em_real', compute=lambda cr:
>> cr['custo_em_dolar']*cr['valor_do_dolar']),
>> Field('valor_total', compute=lambda vt:
>> vt['custo_em_real']*vt['quantidade'])
>>
>> But both computed fields are always set as "None"... I am trying it from
>> administrative database screen...
>>
>> Am I doing anything wrong?
>>
>> --
>>
>> Linux User #387870
>> .
>>  _/_õ|__|
>> ..º[ .-.___.-._| . . . .
>> .__( o)__( o).:___
>>
>
>


-- 

Linux User #387870
.
 _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:___

Re: [web2py] Computed field not working

[Richard Vézina]

You valor_do_dolar field is still a problem in the model down here... Since
you can't or your lambda can't accès valor_do_dolar in that example. The
field don't exist in the form so the key not exist so web2py return none
and custo_em_dolar*none will return none I guest.

try this :

db.define_table('compra_produto',
Field('compra', 'reference compra'),
Field('produto','reference produto'),
Field('quantidade','integer'),
Field('custo_em_dolar','double'),
Field('cotacao_do_dolar','double'),
Field('custo_em_real', compute=lambda cr: cr['custo_em_dolar']*cr['*
cotacao_do_dolar*']),
)

And provide input data for both field and it should works, not like you
want it to works, but you will make sure that it could works.

Also, notice that if you set a field to writable and/or readable = False,
they will not be in the form and not provide any input data to your lambda
so it will failed.

I don't see what you do in your controller here that why I notice you about
that. It is a common pit fall into which I run often when set new computed
field on existing table because I kind of filter the field I show to user
with writable and readable = False often and forget about those rules.

:)

Richard

On Wed, Feb 29, 2012 at 4:16 PM, Tito Garrido  wrote:

> Nice Catch, but I have commented the last field to apply what you
> suggested and this also doesn't work:
>
> db.define_table('compra_produto',
> Field('compra', 'reference compra'),
> Field('produto','reference produto'),
> Field('quantidade','integer'),
> Field('custo_em_dolar','double'),
> Field('cotacao_do_dolar','double'),
> Field('custo_em_real', compute=lambda cr:
> cr['custo_em_dolar']*cr['valor_do_dolar']),
> )
>
>
> On Wed, Feb 29, 2012 at 6:06 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> You can't access valor_do_dolar from custo_em_real lambda computed since
>> it is a computed field that get computed un submit... If you want to do
>> that you will have to make a real function that get process on submit with
>> form.process().accepted and the argument onsuccess or onvalidation
>>
>> See chapter 7 with both keyword here a link for the first keyword :
>>
>> http://web2py.com/books/default/chapter/29/7?search=onsuccess
>>
>> Richard
>>
>> On Wed, Feb 29, 2012 at 3:51 PM, Tito Garrido wrote:
>>
>>> Hi Folks,
>>>
>>> I am trying a simple example using sqlite:
>>>
>>> db.define_table('compra_produto',
>>> Field('compra', 'reference compra'),
>>> Field('produto','reference produto'),
>>> Field('quantidade','integer'),
>>> Field('custo_em_dolar','double'),
>>> Field('cotacao_do_dolar','double'),
>>> Field('custo_em_real', compute=lambda cr:
>>> cr['custo_em_dolar']*cr['valor_do_dolar']),
>>> Field('valor_total', compute=lambda vt:
>>> vt['custo_em_real']*vt['quantidade'])
>>>
>>> But both computed fields are always set as "None"... I am trying it from
>>> administrative database screen...
>>>
>>> Am I doing anything wrong?
>>>
>>> --
>>>
>>> Linux User #387870
>>> .
>>>  _/_õ|__|
>>> ..º[ .-.___.-._| . . . .
>>> .__( o)__( o).:___
>>>
>>
>>
>
>
> --
>
> Linux User #387870
> .
>  _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:___
>

[web2py] web2py Leaflet.js and firefox won't render map tiles

[ender]

Leaflet , a javascript library for embedding 
maps, has a mysterious problem that only crops up when you host a page 
using leaflet on web2py and try to view it in firefox. Specifically, map 
tiles fail to be loaded. As far as I can tell, leaflet is working as it 
should, building the map and placing it in the div, and even retrieving the 
tiles and appropriate urls, but firefox resolutely fails to show the actual 
map tiles. Webkit based browsers don't have a problem, but firefox (and ie 
10) can't seem to handle the combination of web2py and leaflet. Anyone 
wanting to replicate this issue can take the simple example from leaflet's 
documentation, an api key from cloudmade.com (free), and load the page from 
web2py. Note: Leaflet absolutely works when its hosted on a simple 
webserver (I tested it on IIS). I can provide a code sample if needed. Can 
anyone help me track down the problem?

[web2py] Re: windows users? need help with a test...

[Massimo Di Pierro]

Great. This is what I needed to know as a the language load/dave
functions were rewritten to avoid the concurrency problem. They use a
trick to open the file in append mode and then seek(0) and truncate()
instead of opening the file in write mode. I knew it works on Mac and
Linux but I was not sure about windows. Thanks again.

Massimo

On Feb 29, 2:25 pm, Carlos  wrote:
> Hi Massimo,
>
> Do you mean go to the following url and click "update"?
>
> http://localhost:8000/admin/default/edit_language/welcome/languages/e...
>
> It saved without problems.
>
>    Carlos
>
>
>
>
>
>
>
> On Wednesday, February 29, 2012 1:48:27 PM UTC-6, Massimo Di Pierro wrote:
>
> > Download the latest nightly build (just posted). Open welcome, edit a
> > language file and save it. Does it work fine?

Re: [web2py] Computed field not working

[Tito Garrido]

Thanks a lot Richard! you were right! I have put the wrong field on the
calculation! You are the best!

Thank you!

On Wed, Feb 29, 2012 at 6:25 PM, Richard Vézina  wrote:

> You valor_do_dolar field is still a problem in the model down here...
> Since you can't or your lambda can't accès valor_do_dolar in that example.
> The field don't exist in the form so the key not exist so web2py return
> none and custo_em_dolar*none will return none I guest.
>
> try this :
>
> db.define_table('compra_produto',
> Field('compra', 'reference compra'),
> Field('produto','reference produto'),
> Field('quantidade','integer'),
> Field('custo_em_dolar','double'),
> Field('cotacao_do_dolar','double'),
> Field('custo_em_real', compute=lambda cr: cr['custo_em_dolar']*cr['*
> cotacao_do_dolar*']),
> )
>
> And provide input data for both field and it should works, not like you
> want it to works, but you will make sure that it could works.
>
> Also, notice that if you set a field to writable and/or readable = False,
> they will not be in the form and not provide any input data to your lambda
> so it will failed.
>
> I don't see what you do in your controller here that why I notice you
> about that. It is a common pit fall into which I run often when set new
> computed field on existing table because I kind of filter the field I show
> to user with writable and readable = False often and forget about those
> rules.
>
> :)
>
> Richard
>
>
> On Wed, Feb 29, 2012 at 4:16 PM, Tito Garrido wrote:
>
>> Nice Catch, but I have commented the last field to apply what you
>> suggested and this also doesn't work:
>>
>> db.define_table('compra_produto',
>> Field('compra', 'reference compra'),
>> Field('produto','reference produto'),
>> Field('quantidade','integer'),
>> Field('custo_em_dolar','double'),
>> Field('cotacao_do_dolar','double'),
>> Field('custo_em_real', compute=lambda cr:
>> cr['custo_em_dolar']*cr['valor_do_dolar']),
>>  )
>>
>>
>> On Wed, Feb 29, 2012 at 6:06 PM, Richard Vézina <
>> ml.richard.vez...@gmail.com> wrote:
>>
>>> You can't access valor_do_dolar from custo_em_real lambda computed since
>>> it is a computed field that get computed un submit... If you want to do
>>> that you will have to make a real function that get process on submit with
>>> form.process().accepted and the argument onsuccess or onvalidation
>>>
>>> See chapter 7 with both keyword here a link for the first keyword :
>>>
>>> http://web2py.com/books/default/chapter/29/7?search=onsuccess
>>>
>>> Richard
>>>
>>> On Wed, Feb 29, 2012 at 3:51 PM, Tito Garrido wrote:
>>>
 Hi Folks,

 I am trying a simple example using sqlite:

 db.define_table('compra_produto',
 Field('compra', 'reference compra'),
 Field('produto','reference produto'),
 Field('quantidade','integer'),
 Field('custo_em_dolar','double'),
 Field('cotacao_do_dolar','double'),
 Field('custo_em_real', compute=lambda cr:
 cr['custo_em_dolar']*cr['valor_do_dolar']),
 Field('valor_total', compute=lambda vt:
 vt['custo_em_real']*vt['quantidade'])

 But both computed fields are always set as "None"... I am trying it
 from administrative database screen...

 Am I doing anything wrong?

 --

 Linux User #387870
 .
  _/_õ|__|
 ..º[ .-.___.-._| . . . .
 .__( o)__( o).:___

>>>
>>>
>>
>>
>> --
>>
>> Linux User #387870
>> .
>>  _/_õ|__|
>> ..º[ .-.___.-._| . . . .
>> .__( o)__( o).:___
>>
>
>


-- 

Linux User #387870
.
 _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:___

[web2py] Re: problems refreshing component from link in svg image

[monotasker]

Hi Anthony,

Sorry for the delayed response. Adding window.parent did the trick. Thanks.

Ian

On Wednesday, February 22, 2012 8:38:14 PM UTC-5, Anthony wrote:
>
> Maybe try:
>
> top.web2py_component("/paideia/exploring/index.load","page")
>
> or
>
> window.parent.web2py_component("/paideia/exploring/index.load","page") 
>
> Anthony
>
> On Wednesday, February 22, 2012 5:18:15 PM UTC-5, monotasker wrote:
>>
>> I'm using an svg image as a navigation map, with areas that can be 
>> clicked. I've got the interactivity working via an external javascript, but 
>> when I try to call web2py_component() I get an error telling me that 
>> web2py_component is not defined. I assumed that I could call it since this 
>> script is loaded after page load. I'm not sure where the problem lies, so 
>> here is how it's all set up:
>>
>> This is my js function to refresh the component (in 
>> static/js/svg_interactions.js):
>>
>> function go_there(evt){
>> var tobj = evt.currentTarget;
>> var oname = tobj.getAttribute('id');
>> var the_url = "/paideia/exploring/index.load/?loc=" + oname
>> web2py_component("/paideia/exploring/index.load","page")
>> }
>>
>> This script is linked into the svg file (in the xml itself, as an 
>> immediate child of the svg element) like this: 

[web2py] Inheritance and composition of views

[Pedro Pereira]

Hi all,

Is it possible to include in a view, an inherited one? The docs aren't 
clear about this issue, so I don't know if the framework is supposed to 
allow this behaviour. 
I managed to make a simple example of what I'm trying to achieve:

file 1: default/mytest.html (the view returned by the controller action)

{{extend 'layout.html'}}

this is mytest
{{include 'component_a.html'}}

file 2: component_template.html (the extended template)

this is component_template

{{block child}}
{{include}}
{{end}}

file 3: component_a.html (the included template)

{{extend 'component_template.html'}}

{{block child}}
this is component_a
{{end}}

Running mytest I was expecting:

this is mytest
this is component_template
this is component_a

but it outputs:

this is mytest
this is component_template


Can anyone help?
Thanks in advance
Pedro

[web2py] Re: Inheritance and composition of views

[Massimo Di Pierro]

Short answer no.

Think of the page hierarchy as a tree. {{extend ...}} points up to a
parent. {{include ...}} points down to a child. When your controller
returns it calls a view and this one can move up (extend) and down
(import) the tree.

If you want to import X which extends Y before being imported, you
need to collapse the new tree into a tree node. This means either you
use ajax or your use {{=response.render()}} inside the importing
view.

I wound not go this way.

Massimo

On Feb 29, 4:06 pm, Pedro Pereira  wrote:
> Hi all,
>
> Is it possible to include in a view, an inherited one? The docs aren't
> clear about this issue, so I don't know if the framework is supposed to
> allow this behaviour.
> I managed to make a simple example of what I'm trying to achieve:
>
> file 1: default/mytest.html (the view returned by the controller action)
>
> {{extend 'layout.html'}}
>
> this is mytest
> {{include 'component_a.html'}}
>
> file 2: component_template.html (the extended template)
>
> this is component_template
>
> {{block child}}
> {{include}}
> {{end}}
>
> file 3: component_a.html (the included template)
>
> {{extend 'component_template.html'}}
>
> {{block child}}
> this is component_a
> {{end}}
>
> Running mytest I was expecting:
>
> this is mytest
> this is component_template
> this is component_a
>
> but it outputs:
>
> this is mytest
> this is component_template
>
> Can anyone help?
> Thanks in advance
> Pedro

Re: [web2py] Re: Inheritance and composition of views

[Pedro Pereira]

Understoodthanks a lot!!

On Wed, Feb 29, 2012 at 22:18, Massimo Di Pierro  wrote:

> Short answer no.
>
> Think of the page hierarchy as a tree. {{extend ...}} points up to a
> parent. {{include ...}} points down to a child. When your controller
> returns it calls a view and this one can move up (extend) and down
> (import) the tree.
>
> If you want to import X which extends Y before being imported, you
> need to collapse the new tree into a tree node. This means either you
> use ajax or your use {{=response.render()}} inside the importing
> view.
>
> I wound not go this way.
>
> Massimo
>
> On Feb 29, 4:06 pm, Pedro Pereira  wrote:
> > Hi all,
> >
> > Is it possible to include in a view, an inherited one? The docs aren't
> > clear about this issue, so I don't know if the framework is supposed to
> > allow this behaviour.
> > I managed to make a simple example of what I'm trying to achieve:
> >
> > file 1: default/mytest.html (the view returned by the controller action)
> >
> > {{extend 'layout.html'}}
> >
> > this is mytest
> > {{include 'component_a.html'}}
> >
> > file 2: component_template.html (the extended template)
> >
> > this is component_template
> >
> > {{block child}}
> > {{include}}
> > {{end}}
> >
> > file 3: component_a.html (the included template)
> >
> > {{extend 'component_template.html'}}
> >
> > {{block child}}
> > this is component_a
> > {{end}}
> >
> > Running mytest I was expecting:
> >
> > this is mytest
> > this is component_template
> > this is component_a
> >
> > but it outputs:
> >
> > this is mytest
> > this is component_template
> >
> > Can anyone help?
> > Thanks in advance
> > Pedro
>

Re: [web2py] Re: web2py 1.99.5 (please read)

[Michele Comitini]

I am not able to access to appadmin when I click the button "database
administration" of any application in the admin application.

mic

Il giorno 29 febbraio 2012 20:31, Richard Vézina <
ml.richard.vez...@gmail.com> ha scritto:

> Forget to mention. I also try the welcome app with postgres with no
> problem. I create a use and can logon and logoff...
>
> Richard
>
>
> 2012/2/29 Richard Vézina 
>
>> Here some more information on the ticket it raises :
>>
>>  (self=, value=1,
>> field_type='db.auth_user', blob_decode=True)
>>  Code listing
>>
>>
>>
>>
>> 1498.
>> 1499.
>> 1500.
>> 1501.
>> 1502.
>>
>>
>> 1503.
>>
>> 1504.
>> 1505.
>> 1506.
>> 1507.
>>
>> return value
>>
>>
>> elif field_type == 'blob' and not blob_decode:
>>
>>
>> return value
>>
>>
>> else:
>>
>>
>> key = regex_type.match(field_type).group(0)
>>
>>
>>
>> return self.parsemap[key](value,field_type)
>>
>>
>>
>> def parse_reference(self, value, field_type):
>>
>>
>> referee = field_type[10:].strip()
>>
>>
>> if not '.' in referee:
>>
>>  Variables  field_type 'db.auth_user' self > object> self.parsemap {'blob': > PostgreSQLAdapter.parse_blob of >,
>> 'boolean': > >, 'date': > PostgreSQLAdapter.parse_date of >,
>> 'datetime': > >, 'decimal': > PostgreSQLAdapter.parse_decimal of >,
>> 'double': > >, 'id': > PostgreSQLAdapter.parse_id of >,
>> 'integer': > >, 'list:integer': > PostgreSQLAdapter.parse_list_integers of > object>>, 'list:reference': > PostgreSQLAdapter.parse_list_references of > object>>, ...}  key 'db' value 1
>>
>> It comes form this line in user function of default.py controller that I
>> change a bit :
>>
>> form = auth()
>>
>>
>> Here what I am doing :
>>
>> def user():
>> """
>> ...
>> """
>> form = auth()
>> auth.settings.formstyle = 'table3cols'
>> if request.args(0) == 'login':
>>
>> form[0][1][1].append(SPAN((A(forget_pwd_icon(),_href=URL(r=request,c='default',f='user',args=('request_reset_password'))),
>> SPAN(T('Click on icon if you forgot your password...'))),
>> _class='logintip'))
>> return dict(form=form,layout='login_layout.html')
>> elif request.args(0) == 'profile':
>> return dict(form='you are not allowed
>> (permission)',layout='layout.html')
>> elif request.args(0) == 'request_reset_password':
>> if not 'request_reset_password' in auth.settings.actions_disabled:
>> return dict(form=auth(),layout='login_layout.html')
>> else:
>> return dict(form=form,layout='layout.html')
>> return dict(form=form,layout='layout.html')
>>
>>
>> But I bypass the index and user function from my app and I still get the
>> error... I believe that it could come from the postgres adapter some how...
>> If you remember I use 'myIdName','id' to use my own custom table id name
>> and also redefine the sequence name since the default sequence name build
>> up of postgres is different from the one of web2py... Hope it helps.
>>
>> What else (i mean which changes) could cause this problem?
>>
>> Thanks.
>>
>> Richard
>>
>>
>> 2012/2/28 Massimo Di Pierro 
>>
>>> What triggers it? I need a little more info.
>>>
>>> On Feb 28, 3:22 pm, Richard Vézina 
>>> wrote:
>>> >  'db'
>>> >
>>> > With trunk and copied my app in application folder...
>>> >
>>> > Richard
>>> >
>>> > On Tue, Feb 28, 2012 at 4:01 PM, Massimo Di Pierro <
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > massimo.dipie...@gmail.com> wrote:
>>> > > No. If you have time test the debugger. That is a major piece of code
>>> > > that you will notice right away. Mariano can explain better than me.
>>> >
>>> > > The other features have been reasonably tested.
>>> >
>>> > > Massimo
>>> >
>>> > > On Feb 28, 2:46 pm, szimszon  wrote:
>>> > > > +1
>>> >
>>> > > > Anyway it could be good to have some more hint about what the new
>>> > > features
>>> > > > do. So we can easily test without to follow all conversation about
>>> > > features
>>> > > > between versions :-o
>>> >
>>> > > > 2012. február 28., kedd 21:35:03 UTC+1 időpontban Anthony a
>>> következőt
>>> > > írta:
>>> >
>>> > > > > We need to make the book editable again so some of us can start
>>> adding
>>> > > > > this stuff to the documentation. :-)
>>> >
>>> > > > > On Tuesday, February 28, 2012 3:28:09 PM UTC-5, Massimo Di Pierro
>>> > > wrote:
>>> >
>>> > > > >> I am planning to release this tomorrow but you can test it
>>> today.
>>> > > > >> ***Please help us test it today*** It is really important.
>>> >
>>> > > > >> There is a huge number of improvements and bug fixes. We should
>>> really
>>> > > > >> call this web2py 2.0 but we prefer to wait before advertising
>>> some of
>>> > > > >> the new features which are in but need more testing.
>>> >
>>> > > > >> List not in order of importance:
>>> >
>>> > > > >> - included remote debugger (thanks Mariano)
>>> > > > >> - gluon/contrib/htmlmin.py for html minimization (thanks
>>> kerncece)

[web2py] Re: Multiple auth - Good practice?

[greenpoise]

Ok, thanks. So I have an idea involving groups. I edited my auth_user
table, I did that with no problem but I cant seem to link it to
another table so I get a drop down in one of the fields:


Here is my model (notice IS_IN_DB):

##Aditional table to support auth_user
db.define_table('department',
Field('name'),
Field('abbreviation'),
Field('committee'))

##Additional auth_user fields
auth.settings.extra_fields['auth_user']= [Field('company'),
Field('department',db.department)]
db.auth_user.department.requires=IS_IN_DB(db,'department.id','%
(name)s')


The error, cant find auth_user.



Thanks





On Feb 28, 5:40 pm, Massimo Di Pierro 
wrote:
> You can have two auth objects and you can swicth between them using
> for example  a session variable or a parameter in the URL. Yet is is
> going to be a mess.
>
> I suggest instead you use one auth table and user roles and
> permissions to decide who can do what.
>
> massimo
>
> On Feb 28, 4:12 pm, greenpoise  wrote:
>
>
>
>
>
>
>
> > Sorry, I pressed enter without being finished:
>
> > My second option
>
> > 2. Build a table called employee that uses only one auth table.
>
> > Either way I am stuck on how to do this.. First would like to know
> > which is a good practice and second, how could I accomplish this??
>
> > Thanks
>
> > dan
>
> > On Feb 28, 2:10 pm, greenpoise  wrote:
>
> > > I have been searching in this group for a way of implementing two
> > > authentication within one application. My idea is to have Auth table
> > > managed by an administrator. However, I want to give the flexibility
> > > to added users to add their own employees and the employees being able
> > > to log into the application. My question is, is this a good practice?
> > > would it work??
>
> > > I can think of two options:
>
> > > 1. Having a second auth table and login process separate from the main
> > > auth table

[web2py] Getting user timezone

[Yarin]

Does web2py have any built-in mechanism for establishing the timezone
of a user?

Re: [web2py] Thumbnails

[pbreit]

I like the module approach. I just put the function in my model file like 
this:

db.item.image_thumb.compute = lambda r: resize_image(r['image'], (150,130), 
'thumb')
db.item.image_display.compute = lambda r: resize_image(r['image'], 
(320,320), 'display')

def resize_image(image, size, path, rotate=0):
if image:
try:
img = Image.open('%sstatic/uploads/%s' % (request.folder, 
image))
img = img.convert("RGB")
img.thumbnail(size, Image.ANTIALIAS)
img = img.rotate(rotate)
root, ext = os.path.splitext(image)
filename = '%s_%s%s' %(root, path, ext)
img.save('%sstatic/uploads/%s' % (request.folder, filename))
return filename
except Exception, e:
return e
else:
return None

Re: [web2py] Thumbnails

[pbreit]

Oops, make sure to import PIL:

from PIL import Image

Re: [web2py] Re: Inheritance and composition of views

[Bruno Rocha]

Dont know if it helps, but note that you can enclose HTML as a function.

views/my_html_functions.html
>
> {{def my_html_block(args):}}
>{{if args.:}}
>  
>{{pass}}
>{{=DIV(UL(LI()))}}
>
>
>
> {{return}}
>


views/anyfile.html
>
> {{extend "layout.html"}}
> {{include "my_html_functions.html"}}
>
> 
>   {{my_html_blog(args)}}
> 
>


Note that when calling that function you do not need to use {{=}}

[web2py] Re: Deleting upload files -- possible bug?

[weheh]

@Anthony: Thanks for such a thorough response. I'm sorry I didn't
mention for Question 2 that I was deleting the files myself using a
method almost identical to the one you presented here. I was just
wondering if there was a built-in way to do this more efficiently
(less coding). Apparently not, which is OK, since the method presented
is pretty simple.

On Question 1 - I continue to investigate and have the following to
report.

First, I discovered the following exception:
TransactionRollbackError: deadlock detected\nDETAIL:  Process 6208
waits for ShareLock on transaction 29974; blocked by process
8700.\nProcess 8700 waits for ShareLock on transaction 29973; blocked
by process 6208.\nHINT:  See server log for query details.\nCONTEXT:
SQL statement "DELETE FROM ONLY "public"."my_table" WHERE $1
OPERATOR(pg_catalog.=) "my_file_id""\n

This is probably caused by doing a bunch of deletes without a
db.commit(). I placed a db.commit() immediately following each delete,
and now some of the files are getting deleted, but not all. The static/
data/test.name/??/*.txt files are getting deleted. However the uploads/
test.image/??/*.jpg files are *NOT* getting deleted. So queueing up
too many deletes without a db.commit() is at least partially the
culprit. Does that make sense?

Further testing - I then tried deleting the test record from within
the web2py admin application and both files are getting deleted as
expected. So then I tried something else ...

First, some additional info. There is another table with a Field that
refers to this test table and has an ondelete='CASCADE' parameter set.
>From within the web2py admin IDE, if I delete the other table first,
the test table is not deleted as expected. If I then delete the test
table, the static/data/??/*.txt files get deleted but the uploads/
test.image/??/*.jpg files do not.

So perhaps the autodelete=True is a red herring. The problem may be
with ondelete='CASCADE' pointing to a record with a field with
autodelete=True. I hope this helps. This may, indeed, be a bug. Any
thoughts?

[web2py] Re: Getting user timezone

[Anthony]

I don't think you can reliably get it from the server side (there are 
services to infer it from IP address, but not completely reliable). You 
probably have to do it via Javascript in the 
browser: https://bitbucket.org/pellepim/jstimezonedetect.

Anthony

On Wednesday, February 29, 2012 7:13:21 PM UTC-5, Yarin wrote:
>
> Does web2py have any built-in mechanism for establishing the timezone 
> of a user?

[web2py] Re: web2py Leaflet.js and firefox won't render map tiles

[Anthony]

Is Leaflet just client side Javascript? Just to make sure nothing in 
web2py_ajax.html (and web2py.js) is interfering, what happens if you don't 
include web2py_ajax.html in your layout (assuming it is now included)? 
Also, are you using web2py templates to generate any of the Leaflet related 
JS or HTML, or is that fixed? If the former, maybe your template code isn't 
generating the proper Leaflet output (in which case, we'll need to see some 
code to help).

Anthony

On Wednesday, February 29, 2012 4:00:07 PM UTC-5, ender wrote:
>
> Leaflet , a javascript library for 
> embedding maps, has a mysterious problem that only crops up when you host a 
> page using leaflet on web2py and try to view it in firefox. Specifically, 
> map tiles fail to be loaded. As far as I can tell, leaflet is working as it 
> should, building the map and placing it in the div, and even retrieving the 
> tiles and appropriate urls, but firefox resolutely fails to show the actual 
> map tiles. Webkit based browsers don't have a problem, but firefox (and ie 
> 10) can't seem to handle the combination of web2py and leaflet. Anyone 
> wanting to replicate this issue can take the simple example from leaflet's 
> documentation, an api key from cloudmade.com (free), and load the page 
> from web2py. Note: Leaflet absolutely works when its hosted on a simple 
> webserver (I tested it on IIS). I can provide a code sample if needed. Can 
> anyone help me track down the problem?

[web2py] Re: web2py Leaflet.js and firefox won't render map tiles

[Anthony]

I suppose it could also be a CSS problem, so you might remove web2py.css 
and skeleton.css as well, just to see if that's the issue.

On Wednesday, February 29, 2012 9:40:19 PM UTC-5, Anthony wrote:
>
> Is Leaflet just client side Javascript? Just to make sure nothing in 
> web2py_ajax.html (and web2py.js) is interfering, what happens if you don't 
> include web2py_ajax.html in your layout (assuming it is now included)? 
> Also, are you using web2py templates to generate any of the Leaflet related 
> JS or HTML, or is that fixed? If the former, maybe your template code isn't 
> generating the proper Leaflet output (in which case, we'll need to see some 
> code to help).
>
> Anthony
>
> On Wednesday, February 29, 2012 4:00:07 PM UTC-5, ender wrote:
>>
>> Leaflet , a javascript library for 
>> embedding maps, has a mysterious problem that only crops up when you host a 
>> page using leaflet on web2py and try to view it in firefox. Specifically, 
>> map tiles fail to be loaded. As far as I can tell, leaflet is working as it 
>> should, building the map and placing it in the div, and even retrieving the 
>> tiles and appropriate urls, but firefox resolutely fails to show the actual 
>> map tiles. Webkit based browsers don't have a problem, but firefox (and ie 
>> 10) can't seem to handle the combination of web2py and leaflet. Anyone 
>> wanting to replicate this issue can take the simple example from leaflet's 
>> documentation, an api key from cloudmade.com (free), and load the page 
>> from web2py. Note: Leaflet absolutely works when its hosted on a simple 
>> webserver (I tested it on IIS). I can provide a code sample if needed. Can 
>> anyone help me track down the problem?
>
>

Re: [web2py] Re: cron setup

[Sanjeet Kumar]

Luciano i removed the one * before the applications and tryed than i got 
the following error :-


OperationalError: unable to open database file
Traceback (most recent call last):
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/restricted.py", line 
204, in restricted
exec ccode in environment
  File "applications/welcome/models/db.py", line 14, in 
db = DAL('sqlite://storage.sqlite')
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 4749, in 
__init__
raise RuntimeError, "Failure to connect, tried %d times:\n%s" % 
(attempts, tb)
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 4736, in 
__init__
self._adapter = ADAPTERS[self._dbname](*args)
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 1655, in 
__init__
self.pool_connection(connect)
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 444, in 
pool_connection
self.connection = f()
  File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 1654, in 
connect
return self.driver.Connection(dbpath, **driver_args)
OperationalError: unable to open database file


On Wednesday, February 29, 2012 6:39:22 PM UTC+5:30, lucmult wrote:
>
>
>
> On Wed, Feb 29, 2012 at 11:10 PM, Sanjeet Kumar wrote:
>
>> I have the following code in my crontab :-
>>
>> 0-59/1****root **applications/welcome/cron/test.py
>>
>
> put just 1 * before applications/
>
> [],
> -- 
> Luciano Pacheco
> blog.lucmult.com.br
>  

[web2py] Re: Web2py and SSLH

[drelyn86]

It just forwards the connection like a reverse proxy, so no MITM is caused.
Why would I need to completely disable session cookies?

Anyway... I was thinking about this more, and I remembered that the current 
scaffolding app's method of preventing security breaches through generic 
views is by disabling generic views unless you are on localhost (see line 
27 of models/db.py in version 1.99.4). Since everything on SSL appears to 
be coming from localhost while using SSLH, I should disable generic 
patterns completely.

On Monday, February 27, 2012 8:41:30 AM UTC-5, Ross Peoples wrote:
>
> I would be interested to see if SSH can actually be forwarded without 
> triggering a main-in-the-middle error.
>
> I'm not sure on the first question, but I would guess that you would want 
> to disable everything except your app.
>
> At the bottom of the db.py model, just put "session.forget(request)". This 
> will still create cookies, I think but will not actually use them. Not sure 
> on this one. Maybe someone else has a better answer for turning cookies off 
> completely.
>
> In your model, I would also disable anything you don't need: db, mail, 
> auth, etc.
>
> On Sunday, February 26, 2012 1:09:21 PM UTC-5, t13one wrote:
>>
>> I'm thinking about setting up SSLH on my personal server.
>>
>> From http://freecode.com/projects/sslh:
>> 
>>
>> > sslh accepts HTTPS, SSH, OpenVPN, tinc, and XMPP connections on the
>> > same port. This makes it possible to connect to any of these servers
>> > on port 443 (e.g., from inside a corporate firewall, which almost
>> > never blocks port 443) while still serving HTTPS on that port.
>>
>> In short summary (and to my limited understanding), SSLH works by
>> forwarding the connection from the sslh daemon to either the ssh server
>> or the web-server (among other options). This means all SSL connections
>> will ultimately appear to be connecting to apache/web2py via 127.0.0.1.
>>
>> Are there any security concerns with this? Should I disable admin and
>> appadmin completely?
>>
>> How are session cookies affected?
>>
>> Would any other functionality be affected?
>>
>>
> On Sunday, February 26, 2012 1:09:21 PM UTC-5, t13one wrote:
>>
>> I'm thinking about setting up SSLH on my personal server.
>>
>> From http://freecode.com/projects/sslh:
>> 
>>
>> > sslh accepts HTTPS, SSH, OpenVPN, tinc, and XMPP connections on the
>> > same port. This makes it possible to connect to any of these servers
>> > on port 443 (e.g., from inside a corporate firewall, which almost
>> > never blocks port 443) while still serving HTTPS on that port.
>>
>> In short summary (and to my limited understanding), SSLH works by
>> forwarding the connection from the sslh daemon to either the ssh server
>> or the web-server (among other options). This means all SSL connections
>> will ultimately appear to be connecting to apache/web2py via 127.0.0.1.
>>
>> Are there any security concerns with this? Should I disable admin and
>> appadmin completely?
>>
>> How are session cookies affected?
>>
>> Would any other functionality be affected?
>>
>>

[web2py] Web2py basic setup for Windows

[Alok]

Hi Friends,
I am fairly new to Web2py and I need help. I use windows.
Originally I set up Web2py on my computer using the binaries and I was
able to get the Web2py server come up and do some very basic tests
using the Web interface.

However, I was not able to run the examples that are provided in the
Web2py documentation using the intepreter. This led me to ask this
group and I was advised that to do that I should install the Web2py
code version and then use the command line invocation like this

Python web2py.py < and other command line arguments>

So I uninstalled the Web2py binary installation and installed the
Web2py code version. However, now I am not sure how the server and web
interface will start. I tried invoking Python like this from the
windows prompt

C:\Python web2py.py

but that did not work as it could not fne web2py.py so I changed it to
include the path to web2py.py like this

C:\Python C:\web2py\web2py.py

This worked somewhat but I now got an error which implied that import
gluon was not working. So I then added an environment variable
PYTHONPATH as follows:

PYTHONPATH
C:\web2py;C:\web2py\gluon

With this change the
C:\Phthon C:\web2py\web2py.py went further but I am now getting an
error which says
Traceback (most recent call last):
 File "web2py.py", line 16, in 
  import gluon.widget
 File "C:\web2py\gluon\__init__.py", line 15, in 
  from globals import current
 File "C:\web2py\gluon\globals.py", line 139
  except TypeError, e:
  ^
SyntaxError: invalid syntax

Can you please help with how to overcome this error. I will be very
grateful.
Thanks

[web2py] Re: web2py 1.99.5 (please read)

[Andrew]

I'm trying to test the Teradata DAL change, but getting errors,  I'm
backtracking to test on SQL Server for creating Foreign Key
relationships.  Never tried this before now so I'm not sure if it
worked before on SQL Server:
dbSQL.define_table('Andrew_2py_PK',
Field('Field1', 'string', length=10),
Field('Field2'),
format='%(Field1)s',
primarykey = ['Field1'],
migrate=True)
dbSQL.define_table('Andrew_2py_PK_Child',
Field('Parent', dbSQL.Andrew_2py_PK),
Field('ChildField2'),
format='%(ChildField2)s',
primarykey = ['ChildField2'],
migrate=True)
getting the following :
  File "D:\Mercurial\web2py_Local\gluon\dal.py", line 6785, in
__getattr__
return self[key]
File "D:\Mercurial\web2py_Local\gluon\dal.py", line 6725, in
__getitem__
return dict.__getitem__(self, str(key))
KeyError: '_id'

I found that at line 6576:
   elif isinstance(field, Table):
evaluates to False for my FK column, which I expected to be True.

I noticed that the book's DAL section doesn't mention references
anymore
references aren't working for references (yet), but they didn't work
before either.

[web2py] Re: web2py 1.99.5 (please read)

[Andrew]

P.S.  Ignore the comment about the book.  It's there ?? :(

[web2py] Re: web2py 1.99.5 (please read)

[Andrew]

Sorry, one more.
The last line should have read:
References aren't working for Teradata (yet), but they didn't work
before either.

[web2py] Re: Obtaining URL to image blob in GAE

[Peter G.]

@Anthony & BrendanC: Thank you both for your code snippets! I've got
it working now :). It's loading the image from a blob field in GAE's
DB.

@howesc: Can you possibly expand on how you modified your code to work
with the blob store? That's something I'm also interested at looking
into (would save lots of instance hours if every avatar lookup wasn't
spinning up the app!). Thanks!

[web2py] Add the drop-down in plugin_instant_admin for best searching

[Sanjeet Kumar]

How can i implement the drop-down in plugin_instant_admin for best searching

[web2py] My site on powered by web2py

[Bruce Wade]

Hello,

My site fit trainer online URL is wrong making it impossible to get to:
http://http//www.fittraineronline.com there should be only one http://

http://web2py.com/poweredby

-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

[web2py] Re: Web2py basic setup for Windows

[Anthony]

Are you running Python 3? Note, the standard web2py is only compatible with 
Python 2.5 to 2.7 (though there is a Python 3 compatible branch).

Note, you can simply create a shortcut to your web2py.py file on your 
desktop and click it to start the web2py server.

Anthony

On Wednesday, February 29, 2012 11:46:25 PM UTC-5, Alok wrote:
>
> Hi Friends, 
> I am fairly new to Web2py and I need help. I use windows. 
> Originally I set up Web2py on my computer using the binaries and I was 
> able to get the Web2py server come up and do some very basic tests 
> using the Web interface. 
>
> However, I was not able to run the examples that are provided in the 
> Web2py documentation using the intepreter. This led me to ask this 
> group and I was advised that to do that I should install the Web2py 
> code version and then use the command line invocation like this 
>
> Python web2py.py < and other command line arguments> 
>
> So I uninstalled the Web2py binary installation and installed the 
> Web2py code version. However, now I am not sure how the server and web 
> interface will start. I tried invoking Python like this from the 
> windows prompt 
>
> C:\Python web2py.py 
>
> but that did not work as it could not fne web2py.py so I changed it to 
> include the path to web2py.py like this 
>
> C:\Python C:\web2py\web2py.py 
>
> This worked somewhat but I now got an error which implied that import 
> gluon was not working. So I then added an environment variable 
> PYTHONPATH as follows: 
>
> PYTHONPATH 
> C:\web2py;C:\web2py\gluon 
>
> With this change the 
> C:\Phthon C:\web2py\web2py.py went further but I am now getting an 
> error which says 
> Traceback (most recent call last): 
>  File "web2py.py", line 16, in  
>   import gluon.widget 
>  File "C:\web2py\gluon\__init__.py", line 15, in  
>   from globals import current 
>  File "C:\web2py\gluon\globals.py", line 139 
>   except TypeError, e: 
>   ^ 
> SyntaxError: invalid syntax 
>
> Can you please help with how to overcome this error. I will be very 
> grateful. 
> Thanks 
>
>
>

[web2py] Re: My site on powered by web2py

[Anthony]

Sorry. Fixed.

On Thursday, March 1, 2012 12:35:22 AM UTC-5, Detectedstealth wrote:
>
> Hello,
>
> My site fit trainer online URL is wrong making it impossible to get to: 
> http://http//www.fittraineronline.com there should be only one http://
>
> http://web2py.com/poweredby
>
> -- 
> -- 
> Regards,
> Bruce Wade
> http://ca.linkedin.com/in/brucelwade
> http://www.wadecybertech.com
> http://www.warplydesigned.com
> http://www.fitnessfriendsfinder.com
>

Re: [web2py] Re: My site on powered by web2py

[Bruce Wade]

Thanks,

Here is the other site I have been busting my tail on:
http://176.34.12.39we are now testing all the functionality and adding
a few things before it
is moved over to youadworld.com domain.

On Wed, Feb 29, 2012 at 9:45 PM, Anthony  wrote:

> Sorry. Fixed.
>
> On Thursday, March 1, 2012 12:35:22 AM UTC-5, Detectedstealth wrote:
>>
>> Hello,
>>
>> My site fit trainer online URL is wrong making it impossible to get to:
>> http://http//www.**fittraineronline.comthere
>>  should be only one http://
>>
>> http://web2py.com/poweredby
>>
>> --
>> --
>> Regards,
>> Bruce Wade
>> http://ca.linkedin.com/in/**brucelwade
>> http://www.wadecybertech.com
>> http://www.warplydesigned.com
>> http://www.**fitnessfriendsfinder.com
>>
>


-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

Re: [web2py] Re: My site on powered by web2py

[Anthony]

Cool. Let us know when it's ready and we'll post on the poweredby list. :-)

On Thursday, March 1, 2012 12:47:24 AM UTC-5, Detectedstealth wrote:
>
> Thanks,
>
> Here is the other site I have been busting my tail on: http://176.34.12.39we 
> are now testing all the functionality and adding a few things before it 
> is moved over to youadworld.com domain.
>
> On Wed, Feb 29, 2012 at 9:45 PM, Anthony  wrote:
>
>> Sorry. Fixed.
>>
>> On Thursday, March 1, 2012 12:35:22 AM UTC-5, Detectedstealth wrote:
>>>
>>> Hello,
>>>
>>> My site fit trainer online URL is wrong making it impossible to get to: 
>>> http://http//www.**fittraineronline.comthere
>>>  should be only one http://
>>>
>>> http://web2py.com/poweredby
>>>
>>> -- 
>>> -- 
>>> Regards,
>>> Bruce Wade
>>> http://ca.linkedin.com/in/**brucelwade
>>> http://www.wadecybertech.com
>>> http://www.warplydesigned.com
>>> http://www.**fitnessfriendsfinder.com
>>>
>>
>
>
> -- 
> -- 
> Regards,
> Bruce Wade
> http://ca.linkedin.com/in/brucelwade
> http://www.wadecybertech.com
> http://www.warplydesigned.com
> http://www.fitnessfriendsfinder.com
>

[web2py] Connecting to Mysql on MAMP?

[pbreit]

Does anyone connect to a Mysql database running under MAMP? My web2py is 
running on MacOS Python, not MAMP.

I'm getting:

OperationalError: (2003, "Can't connect to MySQL server on 'localhost' 
(61)")

One thing I had to do is when running Navicat or SequelPro (db mgmt client 
app) I needed to specify a different path to the socket file: 
/Applications/MAMP/tmp/mysql/mysql.sock

Maybe I need to do that here? But how?

Re: [web2py] db.Table in appadmin when used in a module

[Johann Spies]

On 29 February 2012 16:28, Bruce Wade  wrote:

> Is there any reason you have a extra comma in the __init__ method?
> def __init__(self, db*,*):
>
>
>
Well spotted.  No. It was a typo.  I have removed it now, but that did not
change the behaviour of appadmin.

Regards
Johann


-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Re: [web2py] db.Table in appadmin when used in a module

[Bruce Wade]

Have you tried setting:

def __init__(self, db):
   self.signature = current.akb_signature_uuid

then using self.signature?

On Wed, Feb 29, 2012 at 10:21 PM, Johann Spies wrote:

>
>
> On 29 February 2012 16:28, Bruce Wade  wrote:
>
>> Is there any reason you have a extra comma in the __init__ method?
>> def __init__(self, db*,*):
>>
>>
>>
> Well spotted.  No. It was a typo.  I have removed it now, but that did not
> change the behaviour of appadmin.
>
> Regards
> Johann
>
>
> --
> Because experiencing your loyal love is better than life itself,
> my lips will praise you.  (Psalm 63:3)
>
>


-- 
-- 
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.warplydesigned.com
http://www.fitnessfriendsfinder.com

Re: [web2py] Re: smartgrid query on 2 or more tables

[Johann Spies]

On 29 February 2012 16:44, Roderick  wrote:

> Thanks Johann!
>
> 1. Can this be done with smartgrid?
>

Not in a similar way.  You can read more about that in
http://www.web2py.com/books/default/chapter/29/7?search=smartgrid#SQLFORM.grid-and-SQLFORM.smartgrid-%28experimental%29


> 2. Can you give me an example of a dynamic query (e.g. what users
> would type into the search field)? (for grid or smartgrid).
>
>
Here is one built with the query button on one of my grids:

akb_articles.title contains "water" and akb_articles.pubyear > "1990" and
akb_articles.pubyear <= "2010"


Experiment for yourself and explore the options.


There is also a slice with examples on using SQLFORM.grid at
http://www.web2pyslices.com/slices/take_slice/148

 Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[web2py] Re: windows users? need help with a test...

[Rahul]

I am able to run the test fine on Win7(32bit), IE9 - Even my sample
application ran fine - I am using web2py nightly build.

Thanks, Rahul D

On Mar 1, 2:34 am, Massimo Di Pierro 
wrote:
> Great. This is what I needed to know as a the language load/dave
> functions were rewritten to avoid the concurrency problem. They use a
> trick to open the file in append mode and then seek(0) and truncate()
> instead of opening the file in write mode. I knew it works on Mac and
> Linux but I was not sure about windows. Thanks again.
>
> Massimo
>
> On Feb 29, 2:25 pm, Carlos  wrote:
>
>
>
>
>
>
>
> > Hi Massimo,
>
> > Do you mean go to the following url and click "update"?
>
> >http://localhost:8000/admin/default/edit_language/welcome/languages/e...
>
> > It saved without problems.
>
> >    Carlos
>
> > On Wednesday, February 29, 2012 1:48:27 PM UTC-6, Massimo Di Pierro wrote:
>
> > > Download the latest nightly build (just posted). Open welcome, edit a
> > > language file and save it. Does it work fine?

Re: [web2py] db.Table in appadmin when used in a module

[Johann Spies]

On 1 March 2012 08:26, Bruce Wade  wrote:

> Have you tried setting:
>
> def __init__(self, db):
>self.signature = current.akb_signature_uuid
>
> then using self.signature?
>
>
>
Yes I had something similar and for some reason which I do not understand
the code complained:

AttributeError: 'Inst' object has no attribute 'signature'

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)