[web2py] Re: auth.define_tables(...signature=False): what is signature?

2014-03-04 Thread 黄祥
if auth.define_tables(username = False, *signature = True*), it 
automatically added the signature fields on auth tables. something like :

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


best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: virtual field ordered on grid

2014-03-04 Thread 黄祥
got it, thank you so much for detail explaination anthony. it seems that 
python principles all the way in this matter : explicit is better than 
implicit.

thanks and best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: auth.define_tables(...signature=False): what is signature?

2014-03-04 Thread Tim Richardson
Thanks.

On Tuesday, 4 March 2014 20:25:50 UTC+11, 黄祥 wrote:

 if auth.define_tables(username = False, *signature = True*), it 
 automatically added the signature fields on auth tables. something like :

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


 best regards,
 stifan


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] How to use multiple SQLALL objects in groupby

2014-03-04 Thread Marin Pranjić
I guess I never did it before, which is weird because it looks like usual 
requirement.

I have a DB query where I need to get a join of two tables and aggregate 
from third table.
That means I need to set two tables in groupby.

To describe what *doesn't *work but you'll get the idea what I want:

count = db.table3.id.count()
left = db.table3.on(something)
rows = db(some_query).select(count, db.table1.ALL, db.table2.ALL, left=left, 
*groupby=[db.table1.ALL, 
db.table2.ALL]*)

So the groupby thing is not working and I don't see an easy way to do it. I 
could extract fields from SQLALL object but that's not a way to go. It 
should be easier :)

Marin

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] using limitby in query for SQLFORM grid

2014-03-04 Thread John Philip
Dear forum,

sorry for asking this basic question.  I would like to limit the number of 
rows in a query 'passlist' which I want to show in a SQLFORM grid.  I did 
try using limitby but this caused a syntax error. I only saw it being used 
in select queries. Any help would be appreciated.

passlist = (db.nextpasses.BOT=windowTT)
sgrid = SQLFORM.grid(passlist)

many thanks,

John

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Behavior distinct when breakpoint is set

2014-03-04 Thread Dani

Hi,

This is my code:

if form.accepts(request.vars, session):
if not request.vars.slug.strip():
slug = '%s %s' % (request.vars.title, form.vars.id)
slug = (IS_SLUG()(slug))[0]
db(db.articles.id == form.vars.id).update(slug=slug)
form.vars.slug = slug

In debug mode, when add breapoint on line:
form.vars.slug = slug

work fine but if not set breakpoint when set fiel to blank () this is 
showed on form as  when must be slug variable



Any idea why this happens?

thanks




--
Dani

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups web2py-users group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] using limitby in query for SQLFORM grid

2014-03-04 Thread Kiran Subbaraman
paginate should work. 
http://web2py.com/books/default/search/29?search=paginate



Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On Tue, 04-03-2014 4:49 PM, John Philip wrote:

Dear forum,

sorry for asking this basic question.  I would like to limit the 
number of rows in a query 'passlist' which I want to show in a SQLFORM 
grid.  I did try using limitby but this caused a syntax error. I only 
saw it being used in select queries. Any help would be appreciated.


passlist = (db.nextpasses.BOT=windowTT)
sgrid = SQLFORM.grid(passlist)

many thanks,

John
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google 
Groups web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to web2py+unsubscr...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.


--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups web2py-users group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] settings site membership_panel and AJAX

2014-03-04 Thread Rick
Hi,

I'm trying to make a setting-site for the logged in user, but it doesn't 
work. I try to use the membership_panel, but desipte of searching, I 
haven't found any tutorial or similar about the panel. Thanks in advance 
for help! Here is the code:

@auth.requires_login()
def user_settings():
membership_panel = LOAD(request.controller,
'manage_membership.html',
#current user id:
args=auth.user.id, 
ajax=True)
return dict(membership_panel=membership_panel)


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] using limitby in query for SQLFORM grid

2014-03-04 Thread John Philip
thanks Kiran,
I would be interested to know if this is possible when defining the query 
to be equivalent to SELECT Field FROM TABLE LIMIT 15. In the web2py 
documentation this is used in DALs using Select but not when defining 
queries. Have I misunderstood something?

thanks and regards,

John

 db().select(db.person.ALL, limitby=(0, 2))


On Tuesday, March 4, 2014 1:35:23 PM UTC+1, Kiran Subbaraman wrote:

 paginate should work. 
 http://web2py.com/books/default/search/29?search=paginate 

  
 Kiran Subbaraman 
 http://subbaraman.wordpress.com/about/ 

 On Tue, 04-03-2014 4:49 PM, John Philip wrote: 
  Dear forum, 
  
  sorry for asking this basic question.  I would like to limit the 
  number of rows in a query 'passlist' which I want to show in a SQLFORM 
  grid.  I did try using limitby but this caused a syntax error. I only 
  saw it being used in select queries. Any help would be appreciated. 
  
  passlist = (db.nextpasses.BOT=windowTT) 
  sgrid = SQLFORM.grid(passlist) 
  
  many thanks, 
  
  John 
  -- 
  Resources: 
  - http://web2py.com 
  - http://web2py.com/book (Documentation) 
  - http://github.com/web2py/web2py (Source code) 
  - https://code.google.com/p/web2py/issues/list (Report Issues) 
  --- 
  You received this message because you are subscribed to the Google 
  Groups web2py-users group. 
  To unsubscribe from this group and stop receiving emails from it, send 
  an email to web2py+un...@googlegroups.com javascript:. 
  For more options, visit https://groups.google.com/groups/opt_out. 



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: using limitby in query for SQLFORM grid

2014-03-04 Thread villas
Hi John,

As Kiran implies,  limitby is already used by the pagination.  

I suggest that you could make an overall limit of records by using a 
separate query.  This isn't particularly efficient,  but depending on what 
you want to achieve,  it could still work well.  

Here is a bit of code to demonstrate what I mean...

This gets a list of the first 50 records:
list_of_ids = [i.id for i in db(db.mytable).select(db.mytable.id, 
limitby=(0,50))]

Now add that to your query for the grid -- something like this:
your_existing_query  (db.mytable.id.belongs(list_of_ids))

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: How to use multiple SQLALL objects in groupby

2014-03-04 Thread villas
When I get a problem like that,  I usually look at what SQL is being 
generated by using _select (with an underline)..  The issue often then 
becomes clearer. 

db(some_query)._select(...)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] How to render a returned json

2014-03-04 Thread Avi A
Hi,
I'm getting on a controller a json response as expected, and I didn't find 
a way how to parse it yet:

r = requests.post(url, data=json.dumps(payload), headers=headers)
r.content returns something like that:
{
  owner_ids: [

  ],
  labels: [
{
  id: 7864106,
  created_at: 2014-03-04T10:39:27Z,
  project_id: 941736,
  name: label,
  kind: label,
  updated_at: 2014-03-04T10:39:27Z
}
  ],
  current_state: unscheduled,
  id: 66856110,
  created_at: 2014-03-04T13:31:33Z,
  story_type: bug,
  project_id: 941736,
  name: title,
  url: http://www.pivotaltracker.com/story/show/66856110;,
  kind: story,
  updated_at: 2014-03-04T13:31:33Z,
  requested_by_id: 735355,
  description: story http://google.com/105;
}

Thanks.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: How to use multiple SQLALL objects in groupby

2014-03-04 Thread Anthony
Unfortunately, you can't use SQLALL objects in a list like that. Probably 
the best you can do is:

rows = db(some_query).select(count, db.table1.ALL, db.table2.ALL, left=left,
 groupby='%s, %s' % (db.table1.ALL, db.table2.
ALL))

Anthony

On Tuesday, March 4, 2014 6:08:42 AM UTC-5, Marin Pranjić wrote:

 I guess I never did it before, which is weird because it looks like usual 
 requirement.

 I have a DB query where I need to get a join of two tables and aggregate 
 from third table.
 That means I need to set two tables in groupby.

 To describe what *doesn't *work but you'll get the idea what I want:

 count = db.table3.id.count()
 left = db.table3.on(something)
 rows = db(some_query).select(count, db.table1.ALL, db.table2.ALL, left=
 left, *groupby=[db.table1.ALL, db.table2.ALL]*)

 So the groupby thing is not working and I don't see an easy way to do it. 
 I could extract fields from SQLALL object but that's not a way to go. It 
 should be easier :)

 Marin



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] How to render a returned json

2014-03-04 Thread Jonathan Lundell
On 4 Mar 2014, at 5:35 AM, Avi A aviavi...@gmail.com wrote:
 Hi,
 I'm getting on a controller a json response as expected, and I didn't find a 
 way how to parse it yet:

json.loads(r.content) will convert it to a dict.

 
 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [
 
   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }
 
 Thanks.
 
 
 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: settings site membership_panel and AJAX

2014-03-04 Thread Anthony
What do you mean by membership_panel?

On Tuesday, March 4, 2014 8:01:13 AM UTC-5, Rick wrote:

 Hi,

 I'm trying to make a setting-site for the logged in user, but it doesn't 
 work. I try to use the membership_panel, but desipte of searching, I 
 haven't found any tutorial or similar about the panel. Thanks in advance 
 for help! Here is the code:

 @auth.requires_login()
 def user_settings():
 membership_panel = LOAD(request.controller,
 'manage_membership.html',
 #current user id:
 args=auth.user.id, 
 ajax=True)
 return dict(membership_panel=membership_panel)




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Web2Py and custom modules (strange behavior and ValueError)

2014-03-04 Thread Remco K


 from gluon.custom_import import track_changes; track_changes(True)


 statement before importing my modules, but is still need to restart 
 Web2Py for every change in development mode. I don't know what I'm doing 
 wrong here?


 This is reportedly not working any more, though hasn't been investigated 
 or fixed yet.

 As for the rest, it's hard to say without seeing some code.

 Anthony


I can confirm that it's not working anymore...

About my second problem; you solved it without knowing :-)

I found a post on 
stackoverflowhttp://stackoverflow.com/questions/11959719/web2py-db-is-not-definedabout
 accessing the db from a module, and a i read:

Note, if you do define the db object in the module, don't define it at the 
 top level -- define it in a function or class.


I added it in top of my modules, so that created my problems. Now it's 
working!

Thanks! 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] How to render a returned json

2014-03-04 Thread Avi A
thanks,
i've tried it but I am not able to parse it:
I tried both:
pivotal = json.loads(r.content)

session.flash(pivotal['url'])
session.flash(pivotal[0].url)



On Tuesday, March 4, 2014 5:18:02 PM UTC+2, Jonathan Lundell wrote:

 On 4 Mar 2014, at 5:35 AM, Avi A avia...@gmail.com javascript: wrote:

 Hi,
 I'm getting on a controller a json response as expected, and I didn't find 
 a way how to parse it yet:


 json.loads(r.content) will convert it to a dict.


 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [

   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }

 Thanks.


 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+un...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/groups/opt_out.





-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] How to render a returned json

2014-03-04 Thread Jonathan Lundell
On 4 Mar 2014, at 7:52 AM, Avi A aviavi...@gmail.com wrote:
 thanks,
 i've tried it but I am not able to parse it:
 I tried both:
 pivotal = json.loads(r.content)
 
 session.flash(pivotal['url'])
 session.flash(pivotal[0].url)

Odd:

 s = {
...   owner_ids: [
... 
...   ],
...   labels: [
... {
...   id: 7864106,
...   created_at: 2014-03-04T10:39:27Z,
...   project_id: 941736,
...   name: label,
...   kind: label,
...   updated_at: 2014-03-04T10:39:27Z
... }
...   ],
...   current_state: unscheduled,
...   id: 66856110,
...   created_at: 2014-03-04T13:31:33Z,
...   story_type: bug,
...   project_id: 941736,
...   name: title,
...   url: http://www.pivotaltracker.com/story/show/66856110;,
...   kind: story,
...   updated_at: 2014-03-04T13:31:33Z,
...   requested_by_id: 735355,
...   description: story http://google.com/105;
... }
... 
 import json
 json.loads(s)
{u'story_type': u'bug', u'kind': u'story', u'name': u'title', u'url': 
u'http://www.pivotaltracker.com/story/show/66856110', u'created_at': 
u'2014-03-04T13:31:33Z', u'labels': [{u'kind': u'label', u'name': u'label', 
u'created_at': u'2014-03-04T10:39:27Z', u'updated_at': u'2014-03-04T10:39:27Z', 
u'project_id': 941736, u'id': 7864106}], u'current_state': u'unscheduled', 
u'updated_at': u'2014-03-04T13:31:33Z', u'requested_by_id': 735355, 
u'description': u'story http://google.com/105', u'project_id': 941736, u'id': 
66856110, u'owner_ids': []}
 j = json.loads(s)
 j['url']
u'http://www.pivotaltracker.com/story/show/66856110'



 
 
 
 On Tuesday, March 4, 2014 5:18:02 PM UTC+2, Jonathan Lundell wrote:
 On 4 Mar 2014, at 5:35 AM, Avi A avia...@gmail.com wrote:
 Hi,
 I'm getting on a controller a json response as expected, and I didn't find a 
 way how to parse it yet:
 
 json.loads(r.content) will convert it to a dict.
 
 
 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [
 
   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }
 
 Thanks.
 
 
 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+un...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.
 
 
 
 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Best way to use a standalone DAL

2014-03-04 Thread Jim S
I use the absolute path in my code.  Also, you should be able to make this 
work without the define tables

-Jim

On Monday, March 3, 2014 11:22:44 PM UTC-6, Gwayne aka Mike Veltman wrote:


 O well the situation is as follows, I have a database and created a web2py 
 webinterface with it. But I also have create some commandline tools that 
 reverence the database. 

 So I wondered if there was a easy way to include dal in the scripts and 
 talk to the database. 

 So webgui is the webinterface of the deployment application.

 Jim I want to use the database so I guess I need the define tables

 I tried to to it as explained in the ebook but I got a error (with mongodb)

 Btw is the path_to_application_databases relative to web2py path or 
 absolute ?


 Thanks as always btw

 Actually now I got it working. Mmm, so I just have to add a function that 
 checks if its called from within web2py or from the outside. 

 Thanks Jim for making me look at it again. I had not done the define 
 tables.


 On Tuesday, 4 March 2014 00:03:10 UTC+8, Anthony wrote:

 In a script, you can just import it like any other Python module. Not 
 sure what you mean by calling it from the webgui.

 Anthony

 On Monday, March 3, 2014 3:58:39 AM UTC-5, Gwayne aka Mike Veltman wrote:

 I will actually call dal from within some scripts and from the webgui. 
 What would be the best and cleanest way to do that ?



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Voting system without users.

2014-03-04 Thread Leonel Câmara
Why are you using the session's __dict__ directly? I see no good reason to 
do it.   
  
Apart from that it appears you're trying to limit this to one vote per 
user, using session (I'm guessing the actual logic to save the votes in the 
db is missing). Which has obvious failures but may or not be good enough 
for your purposes since most users won't abuse it.  
  
If this will be mobile only, an alternative would be to send the device 
uuid that all smartphones have with the vote and limit to 1 vote per device 
per melodigram.  

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: How to render a returned json

2014-03-04 Thread Avi A
I do the same I get:

TypeError: string indices must be integers, not str

On Tuesday, March 4, 2014 3:35:31 PM UTC+2, Avi A wrote:

 Hi,
 I'm getting on a controller a json response as expected, and I didn't find 
 a way how to parse it yet:

 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [

   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }

 Thanks.



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread Willoughby
Works fine for me.

On Tuesday, March 4, 2014 11:22:11 AM UTC-5, Jay Martin wrote:

 When I enter 'web2py' into the Google search bar, then click on the 
 official site link to web2py.com from the top search result, the web2py 
 site appears to be displayed with a mobile view (see attached). I am using 
 a desktop, so this is incorrect. This also happens when using chrome 
 incognito mode. This doesn't happen from Bing. Nor does it happen when 
 entering the URL directly into the chrome omni-bar.

 Could someone else test this as well? Any ideas?

 My best,

 Jay




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] Re: How to render a returned json

2014-03-04 Thread Jonathan Lundell
On 4 Mar 2014, at 9:19 AM, Avi A aviavi...@gmail.com wrote:
 I do the same I get:
 TypeError: string indices must be integers, not str
 
 

Try catching that exception and printing the object you're working with.

It sounds like you're indexing the json string (r.content) rather than the 
result of json.loads.

 
 On Tuesday, March 4, 2014 3:35:31 PM UTC+2, Avi A wrote:
 Hi,
 I'm getting on a controller a json response as expected, and I didn't find a 
 way how to parse it yet:
 
 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [
 
   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }
 
 Thanks.
 
 
 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] web2py v2.9.3: KeyError: 'Cannot resolve reference subject_subject in contract_contract definition'

2014-03-04 Thread Donatas Burba

After upgrading to v2.9.3 (from 2.8.2), error is thrown:

Traceback (most recent call last):
  File /vagrant/grand/web2py/gluon/restricted.py, line 217, in restricted
exec ccode in environment
  File /vagrant/grand/web2py/applications/grand/models/db_contract.py, line 
13, in module
Field('actual_date', 'date', readable=False, writable=False)
  File /vagrant/grand/web2py/gluon/dal.py, line 8223, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
  File /vagrant/grand/web2py/gluon/dal.py, line 8260, in lazy_define_table
polymodel=polymodel)
  File /vagrant/grand/web2py/gluon/dal.py, line 925, in create_table
raise KeyError('Cannot resolve reference %s in %s definition' % 
(referenced, table._tablename))
KeyError: 'Cannot resolve reference subject_subject in contract_contract 
definition'

With lazy_tables=True everything is ok, but in development environment I don't 
want use True value. My table definitions are grouped in separate files, so 
situation is next:

models/db_contract.py:

db.define_table('contract_contract'

...

Field('subject_id', 'reference subject_subject')

...

)


models/db_subject.py

db.define_table('subject_subject',

...

)

As I understand the problem occurs because db_contract.py is executed before 
db_subject.py, Is it posible to revert back to executement like in v2.8.2 (it 
means that such situation won't throw any error without setting lazy_tables to 
True)? Or it is new feature?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: settings site membership_panel and AJAX

2014-03-04 Thread Rick
Sorry for the thread. I read this link and thought that *membership_panel*was a 
part of web2py:
http://www.web2pyslices.com/slice/show/1542/manage-users-and-memebership-in-the-same-form
but now I've fixed the problem by studying *virtual fields*.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread LightDot
Can't reproduce this, tried Chromium 32.0.1.1700.102 and 33.0.1750.117 on 
Fedora 20 and Chrome 32.0.1700.107m and 33.0.1750.146m on Windows 7, both 
normal and incognito modes. Google search bar - top web2py link - 
everything is normal, as expected.

Regards

On Tuesday, March 4, 2014 5:22:11 PM UTC+1, Jay Martin wrote:

 When I enter 'web2py' into the Google search bar, then click on the 
 official site link to web2py.com from the top search result, the web2py 
 site appears to be displayed with a mobile view (see attached). I am using 
 a desktop, so this is incorrect. This also happens when using chrome 
 incognito mode. This doesn't happen from Bing. Nor does it happen when 
 entering the URL directly into the chrome omni-bar.

 Could someone else test this as well? Any ideas?

 My best,

 Jay




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread Jim S
I'm able to reproduce if my browser width falls under a width of 994.  I 
think that is just the bootstrap nav system kicking in.

If I widen my browser back wider than 993, then it comes back into place.

I'm using firefox extension browserize to set my browser size.  It will 
then also show the size in the lower right of my browser so I can see when 
it kicks over to the collapsed menus.

-Jim


On Tuesday, March 4, 2014 11:47:26 AM UTC-6, LightDot wrote:

 Can't reproduce this, tried Chromium 32.0.1.1700.102 and 33.0.1750.117 on 
 Fedora 20 and Chrome 32.0.1700.107m and 33.0.1750.146m on Windows 7, both 
 normal and incognito modes. Google search bar - top web2py link - 
 everything is normal, as expected.

 Regards

 On Tuesday, March 4, 2014 5:22:11 PM UTC+1, Jay Martin wrote:

 When I enter 'web2py' into the Google search bar, then click on the 
 official site link to web2py.com from the top search result, the web2py 
 site appears to be displayed with a mobile view (see attached). I am using 
 a desktop, so this is incorrect. This also happens when using chrome 
 incognito mode. This doesn't happen from Bing. Nor does it happen when 
 entering the URL directly into the chrome omni-bar.

 Could someone else test this as well? Any ideas?

 My best,

 Jay




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] Re: How to render a returned json

2014-03-04 Thread Avi A
Yes, got it now, many thanks.

On Tuesday, March 4, 2014 7:42:28 PM UTC+2, Jonathan Lundell wrote:

 On 4 Mar 2014, at 9:19 AM, Avi A avia...@gmail.com javascript: wrote:

 I do the same I get:

 TypeError: string indices must be integers, not str


 Try catching that exception and printing the object you're working with.

 It sounds like you're indexing the json string (r.content) rather than the 
 result of json.loads.


 On Tuesday, March 4, 2014 3:35:31 PM UTC+2, Avi A wrote:

 Hi,
 I'm getting on a controller a json response as expected, and I didn't 
 find a way how to parse it yet:

 r = requests.post(url, data=json.dumps(payload), headers=headers)
 r.content returns something like that:
 {
   owner_ids: [

   ],
   labels: [
 {
   id: 7864106,
   created_at: 2014-03-04T10:39:27Z,
   project_id: 941736,
   name: label,
   kind: label,
   updated_at: 2014-03-04T10:39:27Z
 }
   ],
   current_state: unscheduled,
   id: 66856110,
   created_at: 2014-03-04T13:31:33Z,
   story_type: bug,
   project_id: 941736,
   name: title,
   url: http://www.pivotaltracker.com/story/show/66856110;,
   kind: story,
   updated_at: 2014-03-04T13:31:33Z,
   requested_by_id: 735355,
   description: story http://google.com/105;
 }

 Thanks.


 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+un...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/groups/opt_out.





-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread Jim S
I should clarify.  I can reproduce it but don't feel it is an issue.  In my 
opinion, this is the way responsive sites are supposed to work.

-Jim

On Tuesday, March 4, 2014 12:06:50 PM UTC-6, Jim S wrote:

 I'm able to reproduce if my browser width falls under a width of 994.  I 
 think that is just the bootstrap nav system kicking in.

 If I widen my browser back wider than 993, then it comes back into place.

 I'm using firefox extension browserize to set my browser size.  It will 
 then also show the size in the lower right of my browser so I can see when 
 it kicks over to the collapsed menus.

 -Jim


 On Tuesday, March 4, 2014 11:47:26 AM UTC-6, LightDot wrote:

 Can't reproduce this, tried Chromium 32.0.1.1700.102 and 33.0.1750.117 
 on Fedora 20 and Chrome 32.0.1700.107m and 33.0.1750.146m on Windows 7, 
 both normal and incognito modes. Google search bar - top web2py link - 
 everything is normal, as expected.

 Regards

 On Tuesday, March 4, 2014 5:22:11 PM UTC+1, Jay Martin wrote:

 When I enter 'web2py' into the Google search bar, then click on the 
 official site link to web2py.com from the top search result, the web2py 
 site appears to be displayed with a mobile view (see attached). I am using 
 a desktop, so this is incorrect. This also happens when using chrome 
 incognito mode. This doesn't happen from Bing. Nor does it happen when 
 entering the URL directly into the chrome omni-bar.

 Could someone else test this as well? Any ideas?

 My best,

 Jay




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: settings site membership_panel and AJAX

2014-03-04 Thread Anthony
Check out this 
thread: https://groups.google.com/forum/?fromgroups=#!topic/web2py/HdvSyZCJad4. 
It describes the /appadmin/manage/auth functionality, which is a built-in 
page to manage Auth users, groups, and permissions.

Anthony

On Tuesday, March 4, 2014 12:56:44 PM UTC-5, Rick wrote:

 Sorry for the thread. I read this link and thought that *membership_panel*was 
 a part of web2py:

 http://www.web2pyslices.com/slice/show/1542/manage-users-and-memebership-in-the-same-form
 but now I've fixed the problem by studying *virtual fields*.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread LightDot
I should clarify also - I do get the mobile version when the browser width 
gets below 980px (width reported by Developer Tools in Firefox), but I 
didn't see this as an issue. Like Jim said, it's the expected behaviour.

Regards

On Tuesday, March 4, 2014 7:29:00 PM UTC+1, Jim S wrote:

 I should clarify.  I can reproduce it but don't feel it is an issue.  In 
 my opinion, this is the way responsive sites are supposed to work.

 -Jim

 On Tuesday, March 4, 2014 12:06:50 PM UTC-6, Jim S wrote:

 I'm able to reproduce if my browser width falls under a width of 994.  I 
 think that is just the bootstrap nav system kicking in.

 If I widen my browser back wider than 993, then it comes back into place.

 I'm using firefox extension browserize to set my browser size.  It will 
 then also show the size in the lower right of my browser so I can see when 
 it kicks over to the collapsed menus.

 -Jim


 On Tuesday, March 4, 2014 11:47:26 AM UTC-6, LightDot wrote:

 Can't reproduce this, tried Chromium 32.0.1.1700.102 and 33.0.1750.117 
 on Fedora 20 and Chrome 32.0.1700.107m and 33.0.1750.146m on Windows 7, 
 both normal and incognito modes. Google search bar - top web2py link - 
 everything is normal, as expected.

 Regards

 On Tuesday, March 4, 2014 5:22:11 PM UTC+1, Jay Martin wrote:

 When I enter 'web2py' into the Google search bar, then click on the 
 official site link to web2py.com from the top search result, the 
 web2py site appears to be displayed with a mobile view (see attached). I 
 am 
 using a desktop, so this is incorrect. This also happens when using chrome 
 incognito mode. This doesn't happen from Bing. Nor does it happen when 
 entering the URL directly into the chrome omni-bar.

 Could someone else test this as well? Any ideas?

 My best,

 Jay




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-04 Thread Tim Richardson
I've cloned the ckeditor plugin and updated it to the latest version of 
ckeditor and fixed a couple of other problems. It's working for me in an app. 
I'll finish the plugin in a few days, I need to merge my changes back and add 
some testing code. I've removed the inline edit capability since it depends on 
JavaScript which appears to be unmaintained.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] March 4 Lab 8

2014-03-04 Thread Massimo Di Pierro
During lab today you will begin writing the solutions for these problems:


   1. 
   
   Write a version of a palindrome recogniser that accepts a file name from 
   the user, reads each line, and prints the line to the screen if it is a 
   palindrome.
   2. 
   
   According to Wikipedia, a *semordnilap* is a word or phrase that spells 
   a *different* word or phrase backwards. (Semordnilap is itself 
   palindromes spelled backwards.) Write a semordnilap recogniser that 
   accepts a file name (pointing to a list of words) from the user and finds 
   and prints all pairs of words that are semordnilaps to the screen. For 
   example, if stressed and desserts is part of the word list, the the 
   output should include the pair stressed desserts. Note, by the way, that 
   each pair by itself forms a palindrome!
   3. 
   
   Write a *procedure* char_freq_table() that, when run in a terminal, 
   accepts a file name from the user, builds a frequency listing of the 
   characters contained in the file, and prints a sorted and nicely formatted 
   character frequency table to the screen.
   
You start today and continue at home. They will count as problems a8p1, 
a8p2, a8p3 of lab 8. They will be graded next week. Next week you will also 
work on problems a8p4, a8p5, a8p6.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] March 4 Lab 8

2014-03-04 Thread Calvin Morrison
I am so glad I am not taking intro to programming ever again. I hate string
manipulation!

Massimo - you might want to resend this to your actual students

Calvin


On 4 March 2014 14:20, Massimo Di Pierro massimo.dipie...@gmail.com wrote:

 During lab today you will begin writing the solutions for these problems:


1.

Write a version of a palindrome recogniser that accepts a file name
from the user, reads each line, and prints the line to the screen if it is
a palindrome.
2.

According to Wikipedia, a *semordnilap* is a word or phrase that
spells a *different* word or phrase backwards. (Semordnilap is
itself palindromes spelled backwards.) Write a semordnilap recogniser
that accepts a file name (pointing to a list of words) from the user and
finds and prints all pairs of words that are semordnilaps to the screen.
For example, if stressed and desserts is part of the word list, the the
output should include the pair stressed desserts. Note, by the way, that
each pair by itself forms a palindrome!
3.

Write a *procedure* char_freq_table() that, when run in a terminal,
accepts a file name from the user, builds a frequency listing of the
characters contained in the file, and prints a sorted and nicely formatted
character frequency table to the screen.

 You start today and continue at home. They will count as problems a8p1,
 a8p2, a8p3 of lab 8. They will be graded next week. Next week you will also
 work on problems a8p4, a8p5, a8p6.


  --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: March 4 Lab 8

2014-03-04 Thread Leonel Câmara
Number 3 doesn't specify how the table is supposed to be sorted!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py-mini-conference, May 4, 2014

2014-03-04 Thread Leonel Câmara
Aww I would love to attend this, sadly Portugal is kind of far away. Please 
make videos!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] ImportError: cannot import name translitcodec

2014-03-04 Thread Alex Glaros
has anyone seen this error?  It won't let web2py boot on my windows 
machine. Version 2.9.3-stable+timestamp.2014.03.03.16.38.00


C:\Program Files\web2pyweb2py.exe
Traceback (most recent call last):
  File string, line 6, in module
  File __main__.py, line 128, in module
  File __main__web2py__.py, line 18, in module
  File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 17, in 
module
  File /home/mdipierro/make_web2py/web2py/gluon/validators.py, line 23, 
in module
ImportError: cannot import name translitcodec

thanks,

Alex Glaros

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] need help with query

2014-03-04 Thread Bastiaan van der Veen
Somehow my replies all got deleted.

I want one item per group(the newest) and then filter by id_status and count 
how many groups have that certain id_status. This should be possible i think. I 
had a nice example in one of those deleted post, but i don't know how i can get 
that back. 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] appadmin redirects to admin on first try?

2014-03-04 Thread User
Whenever I visit my appadmin page url it redirects me to the admin page on 
the first try.  If I go to my appadmin page a second time it will correctly 
take me to appadmin.  For example:

I visit:
https://www.example.com/my_app/appadmin/index

This redirects me to the following on the first try:
https://www.example.com/admin/default/site

If I again try to go to:
https://www.example.com/my_app/appadmin/index
it will correctly take me to the appadmin page.

1. Why is this happening?
2. How do I fix it so it takes me to the correct page on the first try?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-04 Thread Gael Princivalle
That's a really good news. Can you give also a little documentation for 
updating/changing the ckeditor version ?

Thank's a lot Tim.

Il giorno martedì 4 marzo 2014 20:19:50 UTC+1, Tim Richardson ha scritto:

 I've cloned the ckeditor plugin and updated it to the latest version of 
 ckeditor and fixed a couple of other problems. It's working for me in an 
 app. I'll finish the plugin in a few days, I need to merge my changes back 
 and add some testing code. I've removed the inline edit capability since it 
 depends on JavaScript which appears to be unmaintained.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: appadmin redirects to admin on first try?

2014-03-04 Thread Anthony
Are you being asked to log in to admin, or are you already logged in at the 
time?

On Tuesday, March 4, 2014 3:37:23 PM UTC-5, User wrote:

 Whenever I visit my appadmin page url it redirects me to the admin page on 
 the first try.  If I go to my appadmin page a second time it will correctly 
 take me to appadmin.  For example:

 I visit:
 https://www.example.com/my_app/appadmin/index

 This redirects me to the following on the first try:
 https://www.example.com/admin/default/site

 If I again try to go to:
 https://www.example.com/my_app/appadmin/index
 it will correctly take me to the appadmin page.

 1. Why is this happening?
 2. How do I fix it so it takes me to the correct page on the first try?



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py 2.9.3 is OUT - INPORTANT SECURITY WARNING

2014-03-04 Thread Dave S


On Monday, March 3, 2014 8:54:41 AM UTC-8, Massimo Di Pierro wrote:

 web2py 2.9.3 is OUT. 


On Fedora 16 and w2p 2.8.2, tried the button upgrade and got a ticket, and 
got a ticket for the ticket.  Cleared sessions, and still got a ticket.  I 
guess I should have cleared the error directory instead or as well.  I just 
did that (after the fact); there was 1 ticket hanging around from Jan 8th.

Killed the server, restarted, and all looks well except that the admin 
interface has the flash message web2py upgrade; please restart it, so 
some code knew that the flash message had not yet been issued, but missed 
that I had restarted.  Not sure what to do to test tickets other than edit 
one of my pages to have an intentional error.

The Are you sure screen that the button upgrade takes you to would be a 
good place to put the proposed upgrade checklist.  For sites using the 
unzip upgrade method, the checklist may have to be in the readme that 
people DEFINITELY are going to read.

Thanks for the update.

/dps



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: appadmin redirects to admin on first try?

2014-03-04 Thread User
I am already logged in, but haven't visited the site in a while.

On Tuesday, March 4, 2014 3:44:31 PM UTC-5, Anthony wrote:

 Are you being asked to log in to admin, or are you already logged in at 
 the time?

 On Tuesday, March 4, 2014 3:37:23 PM UTC-5, User wrote:

 Whenever I visit my appadmin page url it redirects me to the admin page 
 on the first try.  If I go to my appadmin page a second time it will 
 correctly take me to appadmin.  For example:

 I visit:
 https://www.example.com/my_app/appadmin/index

 This redirects me to the following on the first try:
 https://www.example.com/admin/default/site

 If I again try to go to:
 https://www.example.com/my_app/appadmin/index
 it will correctly take me to the appadmin page.

 1. Why is this happening?
 2. How do I fix it so it takes me to the correct page on the first try?



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Date format and date picker

2014-03-04 Thread Gael Princivalle
Yes I have it in my it.py language file.

But when I choose in the datepicker a date in my Italian page, date picker 
give me the date in '%d/%m/%Y', but the field validation still in US format:
enter date as 1963-08-28

Here is my field in db.py:
Field('concert_date', type='date', requires = IS_DATE(format=T('%Y-%m-%d')))

Perhaps I have to do something more in my grid ?
def edit_concerts():
query = db.concerts
grid = SQLFORM.grid(query=query, csv=False, links_in_grid=False, links=
None, searchable=True, editable=True, deletable=False, create=True, details=
True, orderby=db.concerts.concert_date)
return dict(grid = grid)

Thanks.

Il giorno lunedì 3 marzo 2014 13:25:33 UTC+1, mcamel ha scritto:

 I'm not sure to understand your problem, but just in case it helps: have 
 you tried to use this in your language file:

 '%Y-%m-%d': '%d/%m/%Y',

 Default date validator will do inner convertions between both formats, so 
 you'll have no problems with DAL and database backend.

 Regards.


 El sábado, 1 de marzo de 2014 17:49:36 UTC+1, Gael Princivalle escribió:

 Hello all.

 I'm a little bit disappointed by the date format and datepicker.

 First my field was like that:

 Field('concert_date', type='date'),

 On Firefox no problem. It give me automaticly the possibility to put in 
 the field the local %d/m/%Y format, and this format was accepted by the 
 DAL. When I open this row, date is ok.

 As Firefox 27 for Windows is incredibly slow, I'm still using Chrome from 
 this morning.

 With Chrome if I open again this row date it's ok but with the US format 
 %Y-%m-%d. For example 12/03/2014 change in 2014-03-12. It's the default SQL 
 Lite date format, why not.

 But if I open datepicker, it shows me on the calendar September 4 2017.

 What I want to do is:
 Choose with datepicker the date format always like %d/m/%Y.
 Saving the date in DAL as US format %Y-%m-%d
 Showing in the row the date format as local (%Y-%m-%d or %d/m/%Y)

 Can you help me ?

 Thanks, regards.





-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py-mini-conference, May 4, 2014

2014-03-04 Thread Carlos Zenteno
+1 on the videos for all of us far away or even better a ustream channel!!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py 2.9.3 is OUT - INPORTANT SECURITY WARNING

2014-03-04 Thread Alex Glaros
Hey Stifan,

execute from DOS prompt and see if you get same error as I did.

C:\Program Files\web2pyweb2py.exe
Traceback (most recent call last):
  File string, line 6, in module
  File __main__.py, line 128, in module
  File __main__web2py__.py, line 18, in module
  File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 17, in 
module
  File /home/mdipierro/make_web2py/web2py/gluon/validators.py, line 23, 
in module
ImportError: cannot import name translitcodec

Alex

On Monday, March 3, 2014 10:50:52 AM UTC-8, 黄祥 wrote:

 can't start web2py windows binary on new version. the command prompt is 
 appear and suddenly gone, and i can't access the web2py admin interface too.

 best regards,
 stifan


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: ticket2db is not working

2014-03-04 Thread Rémy Reche
No. I have several applications (and several computers): I run this script 
for each application on each computer. I have only an sql.log in the 
databases folder

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py don't start

2014-03-04 Thread Marc
I have the same problem, downloaded the latest version of web2py.exe for 
Windows and it doesn't run. 

Get the error: 

ImportError: cannot import name translitcodec. 

Older version used to work. I do not have python installed on my machine. 

Marc


On Saturday, 1 March 2014 10:18:05 UTC, LB wrote:

 Hello everybody,
 just extracted, but launching web2py.exe or web2py_noconsole.exe I always 
 got this error message:  Impossibile trovare il punto di ingresso wscpy_s 
 della procedura nella libreria di collegamento dinamico msvcrt.dll  (that 
 is like: can't find access point wscpy_s in msvcrt.dll).
 I checked my system (ms-windows xp sp3) and msvcrt.dll is present, and I 
 also make a copy in the web2py folder, with no result.
 I have on python 2.7 and a python(x,y) release.
 Any advice?

 Thanks,

 LB


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: recaptcha in custom forms

2014-03-04 Thread cisco cca

i got same error that the recaptcha is working in my local (recaptcha 
appear), but when i try in pythonanywhere, the recaptcha is not show up. 
Did you solve it?
On Friday, April 26, 2013 10:47:29 PM UTC+8, 黄祥 wrote:

 another question, 
 1. it seems that recaptcha is not required, i mean i still can submit the 
 form without fill the recaptcha field
 2. why the recaptcha is working in my local (recaptcha appear), but when i 
 try in pythonanywhere, the recaptcha is not show up.
 any idea or solution to face this?
 thank you


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] How can I retrieve the user's auth_user data, by using user id?

2014-03-04 Thread Harris Sol
How can I retrieve the user's auth_user data, by using ID?

I tried using DAL however here is the error - AttributeError: 'DAL' object 
has no attribute 'auth_user

it seems that DAL doesn't recognize the tables, but can I access the 
auth_user table?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] trying to help young son learn Python, and...

2014-03-04 Thread ezrahodge
1. does anyone know if web2py can be installed on a common web host like 
verio or go daddy hosting, and if so, if there is a how to anywhere to do 
it
2. does, or will, web2py support python 3.x any time soon? 

thanks much!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] class 'sqlite3.IntegrityError' foreign key constraint failed

2014-03-04 Thread Капылов Данил
Pass lessons web2py - DePaul IPD359 Week 2 - Web development with Python 
and web2py
Time on video 2 hours 05 minutes

There is an error in the code 
class'sqlite3.IntegrityError' foreign key constraint failed 

function:
def create_post():
category = get_category_post()
db.post.category.default = category.id
form = SQLFORM(db.post)*.process(next='view_post/[id]')*
return locals()

 
Use Web2py 2.8.2-stable+timestamp.2013.11.28.13.54.07

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Problem viewing error tickets: no attribute 'lazyT_unpickle'

2014-03-04 Thread sujin870814
Hello :)

When I tried to view error tickets through the admin app, I got an error 
which is  
*Problem viewing error tickets: no attribute 
'lazyT_unpickle'--*

Traceback (most recent call last):
  File /home/mxptest/web2py/gluon/restricted.py, line 217, in restricted
exec ccode in environment
  File /home/mxptest/web2py/applications/admin/controllers/default.py 
https://165.243.187.146:8084/admin/default/edit/admin/controllers/default.py, 
line 2106, in module
  File /home/mxptest/web2py/gluon/globals.py, line 372, in lambda
self._caller = lambda f: f()
  File /home/mxptest/web2py/applications/admin/controllers/default.py 
https://165.243.187.146:8084/admin/default/edit/admin/controllers/default.py, 
line 1579, in errors
error = pickle.load(fullpath_file)
  File /usr/lib/python2.7/pickle.py, line 1370, in load
return Unpickler(file).load()
  File /usr/lib/python2.7/pickle.py, line 858, in load
dispatch[key](self)
  File /usr/lib/python2.7/pickle.py, line 1090, in load_global
klass = self.find_class(module, name)
  File /usr/lib/python2.7/pickle.py, line 1126, in find_class
klass = getattr(mod, name)
AttributeError: 'module' object has no attribute 'lazyT_unpickle'

*--*
*--*
*-*

I've upgraded web2py version from 2.0.9 to 2.8.2.
Is this the reason of the error?
Because of the error, I cannot check errors during using web2py. Please 
help me... T T

Do you guys know solution or reason of this error?
Or Is there any other way to check error tickets instead of using the admin 
app?

Thank you for your answer =)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py 2.9.3 is OUT - INPORTANT SECURITY WARNING

2014-03-04 Thread Jun S. Kang
I am using MAC and I ran into the same problem. 

- I clicked the upgrade button, and it seemed to be hanged, and restarting 
the server would fail.
- Then downloaded the new binary and overwrote the existing app. But, it 
failed also. 

It just says web2py error on the screen. 

Jun

On Monday, March 3, 2014 11:54:41 AM UTC-5, Massimo Di Pierro wrote:

 web2py 2.9.3 is OUT. 

 As you can see from the changelog we fixed three issues with security of 
 sessions. One of those issues is pretty serious (if you use sessions in DB).
 So, if you use sessions in DB (or GAE) you should upgrade immediately.

 Changelog:
 - jquery 1.11
 - codemirror 3.21, thanks Paolo Valleri
 - fixed security issue with sessions in database, thanks Nathan Humphreys
 - fixed security issue with persistant data in session, thanks Kiran
 - fixed security issue with redirect after expired login, thanks André 
 Kablu
 - cleaner DAL and rname integration, thanks niphlod and Michele
 - added mongodb and imap tests for dal, thanks Alan
 - NoSQL dal tests, thanks Alan
 - better docstrings, thanks Niphlod
 - allow URL(...,language=...) with parametric router, thanks Jonathan
 - allow non-expiration of gae-memcache, thanks crimsoncantab
 - MARKMIN(...,_class='...'), thanks Luca
 - better transliteration in building slugs
 - autolink emails
 - new Janrain API, thanks PeterQ2
 - enable admin app for GAE (experimental), thanks Alan
 - many bug fixes
 - invalidate function in web2py.js, thanks Paolo
 - DAL(...,adapter_args=dict(engine='MyISAM'))
 - todolist panel in admin editor, thanks Paolo Valleri
 - enable killing processed in windows, thanks Yair


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: need help with query

2014-03-04 Thread Bastiaan
I'll try to make it better ;).

For example I have the following list:

id | id_reparaties | id_status | created_on
1  | 1 | 1 | 01-01-14
2  | 1 | 3 | 15-01-14
3  | 2 | 1 | 02-01-14
4  | 3 | 1 | 16-01-14
5  | 1 | 5 | 18-01-14
6  | 2 | 2 | 04-01-14
7  | 2 | 3 | 10-01-14
8  | 2 | 4 | 19-01-14
9  | 3 | 4 | 17-01-14

I want to count the number of id_reparaties that have status 4 as the 
newest. The answer would be 2 then(id_reparaties 2 and 3 both have status 4 
as the newest item. id-reparaties 1 has status 5 as the newest.)



Op vrijdag 28 februari 2014 21:33:23 UTC+1 schreef Niphlod:

 your request kinda sound bad.

 if you want to:
 - filter by id_status
 - group by id_reperaties
 - count lines 

 then it's fine. 

 That have the newest item is the part that doesn't sound right. The 
 newest item is always going to be one and only one, so counting would just 
 return 1 for every group ^___^



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: need help with query

2014-03-04 Thread Bastiaan


 hmm somehow my reply got deleted.. I want to count the groups that have a 
 certain id_status as their newest item. The group will indeed give 1 item, 
 but I want to know how many groups.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Date format and date picker

2014-03-04 Thread Anthony


 Here is my field in db.py:
 Field('concert_date', type='date', requires = IS_DATE(format=T('%Y-%m-%d'
 )))


Do not wrap the format argument to IS_DATE() in T() -- it will be 
translated automatically.

Also, if desired, note that you can alter the date format for the 
Javascript widget universally 
here: 
https://github.com/web2py/web2py/blob/master/applications/welcome/views/web2py_ajax.html#L5.

Anthony

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: appadmin redirects to admin on first try?

2014-03-04 Thread Anthony
On Tuesday, March 4, 2014 4:06:58 PM UTC-5, User wrote:

 I am already logged in, but haven't visited the site in a while.


How long is a while? By default, I believe the admin login lasts for only 
60 minutes. When you go to appadmin, you say you first get redirected to 
admin. My question is are you being redirected to the admin login page 
prior to seeing the admin interface?

Anthony

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: current trunk using memdb results in crash

2014-03-04 Thread Massimo Di Pierro
can you provide a patch or a revision number that broke it?

On Saturday, 1 March 2014 12:25:14 UTC-6, Bas Ti wrote:

 The current trunk does not support using memcache as session store on GAE:
 session.connect calls memdb.Table.__call__(recordid, unique_key=unique_key)

 however unique_key is not supported by memdb.Table, it is only supported 
 by dal.Table


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Bug in request_reset_password

2014-03-04 Thread pepper_bg
Sorry, forgot to specify (but thought it's obvious). The app was configured 
to use usernames.

On Saturday, March 1, 2014 10:51:32 PM UTC-8, Tim Richardson wrote:

  I assume you see this for a specific app.
 Is this app configured for login via usernames or via email addresses? 




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] trying to help young son learn Python, and...

2014-03-04 Thread Calvin Morrison
Hi,

http://web2py.com/books/default/chapter/29/13/deployment-recipes

this page offers different deployment  recipes for hosting like
PythonAnywhere. If your host (i am unfamiliar with go-daddy) provides you
root/shell access to a linux box, you shouldn't have any trouble. I am
Running my web2py instance from a VPS service.


On 4 March 2014 13:58, ezraho...@gmail.com wrote:

 1. does anyone know if web2py can be installed on a common web host like
 verio or go daddy hosting, and if so, if there is a how to anywhere to do
 it
 2. does, or will, web2py support python 3.x any time soon?

 thanks much!

 --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Foreign Key Constraint Failed in dbadmin

2014-03-04 Thread brahama von
Hi guys!

Been looking for this in the mail list but i can't understand why this is 
happening. 

Here is the model. Very simple, just learning and practicing. Its a version 
with a few changes of the image blog :)

db.define_table('uploads',
Field('up_name','string',requires=IS_NOT_EMPTY()),
Field('mainfile','upload'),
Field('thumb','upload',writable=False,readable=False),
Field('up_author',db.auth_user,requires=IS_NOT_EMPTY()),
Field('up_post','reference post'),
format='%(up_name)s')

db.uploads.up_author.writable = db.uploads.up_author.readable = False

db.define_table('post',

Field('category',requires=IS_IN_SET([T('Cat1'),T('Cat2'),T('Cat3'),T('Other')])),

Field('country',requires=IS_IN_SET([T('Argentina'),T('Spain'),T('US'),T('Other')])),
Field('place',requires=IS_NOT_EMPTY()),
Field('summary','string',requires=IS_NOT_EMPTY()),
Field('author',db.auth_user,requires=IS_NOT_EMPTY()),
Field('body','text'),
Field('link1', requires=IS_EMPTY_OR(IS_URL())),
Field('link2',requires=IS_EMPTY_OR(IS_URL())),
Field('link3',requires=IS_EMPTY_OR(IS_URL())),
Field('rel_post','reference post'),
format='%(summary)s')

db.post.rel_post.requires = IS_EMPTY_OR(IS_IN_DB(db,db.post,'%(summary)s'))
db.post.author.writable = db.post.author.readable = False
#db.uploads.up_post.requires = IS_IN_DB(db,db.post,'%(summary)s')
db.uploads.up_post.requires = IS_IN_DB(db(db.post.author == auth.user_id), 
db.post,'%(summary)s')


db.define_table('comentarios',
Field('com_post_id','reference post'),
Field('com_comentario','text'),
Field('com_fecha','datetime')
)


I added the table commentaries recently. The image and post tables were 
populated ok from a FORM view.

Now i tried to add a comment to an existing post through the dbadmin new 
record. The form brought the post ids OK. But when i submit the form i get 
the mentioned exception.

I read about disabling FK validation but i dont want to do that.

Thanks for the help as always!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Date format and date picker

2014-03-04 Thread Gael Princivalle
Ok so like that:
Field('concert_date', type='date', requires = IS_DATE(format='%Y-%m-%d'))
And on Chrome problem still the same.
I think the problem is more global about language detection with Chrome.

If I use web2py on Firefox I've got no problems.

On Chrome it's a disaster. For example when I go on the welcome app, it's 
always in English, not in Italian.

Here is my routes.py :
routers = dict(
 BASE = dict(
 domains = { 
   'domain1.it' : 'myapp1',
   'domain2.it':  'myapp2',
   },
 default_application='welcome', 
),
 myapp1 = dict(languages=['en', 'it'], default_language='it'),
 myapp2 = dict(languages=['en', 'it'], default_language='it'),
)

Do you know what's the problem ?

Regards

Il giorno martedì 4 marzo 2014 22:26:37 UTC+1, Anthony ha scritto:

 Here is my field in db.py:
 Field('concert_date', type='date', requires = IS_DATE(format=T('%Y-%m-%d'
 )))


 Do not wrap the format argument to IS_DATE() in T() -- it will be 
 translated automatically.

 Also, if desired, note that you can alter the date format for the 
 Javascript widget universally here: 
 https://github.com/web2py/web2py/blob/master/applications/welcome/views/web2py_ajax.html#L5
 .

 Anthony


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: current trunk using memdb results in crash

2014-03-04 Thread David Manns
It was the 2.9.3 Windows source code in my case - as I discovered 
afterwards, a brand new release. The version file has Version 
2.9.3-stable+timestamp.2014.03.03.16.38.00.

I backtracked to the version I was using previously 2.8.2 and everything is 
fine. I normally use memcache when running on GAE.

On Tuesday, March 4, 2014 4:29:56 PM UTC-5, Massimo Di Pierro wrote:

 can you provide a patch or a revision number that broke it?

 On Saturday, 1 March 2014 12:25:14 UTC-6, Bas Ti wrote:

 The current trunk does not support using memcache as session store on GAE:
 session.connect calls memdb.Table.__call__(recordid, 
 unique_key=unique_key)

 however unique_key is not supported by memdb.Table, it is only supported 
 by dal.Table



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] trying to help young son learn Python, and...

2014-03-04 Thread jimbo
Pythonanywhere is very easy to use and they have a free account which can then 
be upgraded for hosting. 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Re: [web2py] trying to help young son learn Python, and...

2014-03-04 Thread António Ramos
action.io
 also is very easy to use.



2014-03-04 22:00 GMT+00:00 jimbo ont...@gmail.com:

 Pythonanywhere is very easy to use and they have a free account which can
 then be upgraded for hosting.

 --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/groups/opt_out.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: current trunk using memdb results in crash

2014-03-04 Thread Sebastian Cambeo
I can only provide assistance for the unique key error:
line 883: https://github.com/web2py/web2py/blame/master/gluon/globals.py:
dee4e6a9https://github.com/web2py/web2py/commit/dee4e6a980713f0a3a5bbd350e4b367c4c410327
 
»https://github.com/web2py/web2py/blame/dee4e6a980713f0a3a5bbd350e4b367c4c410327/gluon/globals.py
 
mdipierro https://github.com/mdipierro 
2013-08-20 new session logic 


I don't know how the int64 too big error was introduced



Am Dienstag, 4. März 2014 22:29:56 UTC+1 schrieb Massimo Di Pierro:

 can you provide a patch or a revision number that broke it?

 On Saturday, 1 March 2014 12:25:14 UTC-6, Bas Ti wrote:

 The current trunk does not support using memcache as session store on GAE:
 session.connect calls memdb.Table.__call__(recordid, 
 unique_key=unique_key)

 however unique_key is not supported by memdb.Table, it is only supported 
 by dal.Table



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py 2.9.3 is OUT - INPORTANT SECURITY WARNING

2014-03-04 Thread Niphlod
Hello: there's a problem with the current binaries. I rebuilt the one for 
windows and sent it to Massimo's, who'll probably repack also the mac one 
and post here an update.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Problem viewing error tickets: no attribute 'lazyT_unpickle'

2014-03-04 Thread Niphlod
just delete all the old errors and you should be fine. The problem is 
that the storage format for errors changed in a recent release, so the 
new web2py can't know how to open error files created the old web2py.

On Tuesday, March 4, 2014 12:01:11 PM UTC+1, sujin...@gmail.com wrote:

 Hello :)

 When I tried to view error tickets through the admin app, I got an error 
 which is  
 *Problem viewing error tickets: no attribute 
 'lazyT_unpickle'--*

 Traceback (most recent call last):
   File /home/mxptest/web2py/gluon/restricted.py, line 217, in restricted
 exec ccode in environment
   File /home/mxptest/web2py/applications/admin/controllers/default.py 
 https://165.243.187.146:8084/admin/default/edit/admin/controllers/default.py,
  line 2106, in module
   File /home/mxptest/web2py/gluon/globals.py, line 372, in lambda
 self._caller = lambda f: f()
   File /home/mxptest/web2py/applications/admin/controllers/default.py 
 https://165.243.187.146:8084/admin/default/edit/admin/controllers/default.py,
  line 1579, in errors
 error = pickle.load(fullpath_file)
   File /usr/lib/python2.7/pickle.py, line 1370, in load
 return Unpickler(file).load()
   File /usr/lib/python2.7/pickle.py, line 858, in load
 dispatch[key](self)
   File /usr/lib/python2.7/pickle.py, line 1090, in load_global
 klass = self.find_class(module, name)
   File /usr/lib/python2.7/pickle.py, line 1126, in find_class
 klass = getattr(mod, name)
 AttributeError: 'module' object has no attribute 'lazyT_unpickle'

 *--*
 *--*
 *-*

 I've upgraded web2py version from 2.0.9 to 2.8.2.
 Is this the reason of the error?
 Because of the error, I cannot check errors during using web2py. Please 
 help me... T T

 Do you guys know solution or reason of this error?
 Or Is there any other way to check error tickets instead of using the 
 admin app?

 Thank you for your answer =)


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: ticket2db is not working

2014-03-04 Thread Niphlod
then that's why. The script expects .table files to be present, else it 
triggers a migration (it relies on auto_import to get the table where to 
store tickets)

On Tuesday, March 4, 2014 11:35:46 AM UTC+1, Rémy Reche wrote:

 No. I have several applications (and several computers): I run this script 
 for each application on each computer. I have only an sql.log in the 
 databases folder


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: settings site membership_panel and AJAX

2014-03-04 Thread Rick
Thanks a lot!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py 2.9.3 is OUT - INPORTANT SECURITY WARNING

2014-03-04 Thread 黄祥
same here.

best regards,
stifan

On Wednesday, March 5, 2014 4:25:10 AM UTC+7, Alex Glaros wrote:

 Hey Stifan,

 execute from DOS prompt and see if you get same error as I did.

 C:\Program Files\web2pyweb2py.exe
 Traceback (most recent call last):
   File string, line 6, in module
   File __main__.py, line 128, in module
   File __main__web2py__.py, line 18, in module
   File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 17, in 
 module
   File /home/mdipierro/make_web2py/web2py/gluon/validators.py, line 23, 
 in module
 ImportError: cannot import name translitcodec

 Alex

 On Monday, March 3, 2014 10:50:52 AM UTC-8, 黄祥 wrote:

 can't start web2py windows binary on new version. the command prompt is 
 appear and suddenly gone, and i can't access the web2py admin interface too.

 best regards,
 stifan



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: recaptcha in custom forms

2014-03-04 Thread 黄祥
pardon me, not solved yet, don't know what's going on happens in the 
background for the recaptcha in pythonanywhere.

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py official site erroneously displays mobile view from google search

2014-03-04 Thread Jay Martin
I shouldn't have reduced the size of my screenshot to save bits, because it 
makes my viewport look small. My monitor is 1920 x 1080 and chrome is full 
screen. The mobile view is only returned from google's search results and 
not from directly visiting the site. I think incognito mode should rule out 
cookies. I'm not sure what might be causing this, but its been going on for 
a couple months.

Thanks you all for testing.

My best,

Jay



On Tuesday, March 4, 2014 1:29:00 PM UTC-5, Jim S wrote:

 I should clarify.  I can reproduce it but don't feel it is an issue.  In 
 my opinion, this is the way responsive sites are supposed to work.




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: GAE / Memcache consistency minor change request.

2014-03-04 Thread Matt
Done

https://code.google.com/p/web2py/issues/detail?id=1887

Thanks Massimo!

On Saturday, March 1, 2014 2:27:17 AM UTC+13, Massimo Di Pierro wrote:

 Can you please open a ticket so we will get this done asap?

 On Wednesday, 26 February 2014 15:15:39 UTC-6, Matt wrote:

 Hi there,

 I've noticed a small variation between two parts of web2py.

 The memcache client MemcacheClient in gluon.contrib.memcache.__init__.py 
 supports the ability to control the default timeout via the 
 default_time_expire parameter.

 Whereas the version that supports GAE does not. It would be great if this 
 could be changed as at the moment when you follow the example suggested 
 example:

 http://web2py.com/book/default/chapter/13#Sessions-in-memcache

   from gluon.contrib.gae_memcache import MemcacheClient
   from gluon.contrib.memdb import MEMDB
   cache.memcache = MemcacheClient(request)
   cache.ram = cache.disk = cache.memcache
   session.connect(request,response, db = MEMDB(cache.memcache.client))

 You can't change the session timeout from the default of 300.

 All that's required is to change gluon.contrib.gae_memcache to something 
 like:

 class MemcacheClient(object):

 client = Client()

 def __init__(self, request, default_time_expire = 300):
 self.request = request
 self.default_time_expire = default_time_expire

 def __call__(
 self,
 key,
 f,
 time_expire=self.default_time_expire,
 ):
 key = '%s/%s' % (self.request.application, key)
 dt = time_expire
 value = None
 obj = self.client.get(key)

 Hope that's possible.

 Thanks in advance,
 Matt



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: Ckeditor plugin - Update ckeditor

2014-03-04 Thread Tim Richardson
Have a look here:( The plugin can be found on releases; download it and 
then upload it via the admin app. I'll move it to web2py slices once I get 
some feedback and do some more testing myself)

https://github.com/timrichardson/web2py_ckeditor4/releases

Let me know if it works ok. It's the current ckeditor, standard edition. 
The release notes have instructions on how to update it. Unless they API to 
the custom browsers and uploaders is changes, putting a new release in is 
very easy. 
That API didn't change between v3 and v4 which is good news. 



On Wednesday, 5 March 2014 07:41:58 UTC+11, Gael Princivalle wrote:

 That's a really good news. Can you give also a little documentation for 
 updating/changing the ckeditor version ?

 Thank's a lot Tim.

 Il giorno martedì 4 marzo 2014 20:19:50 UTC+1, Tim Richardson ha scritto:

 I've cloned the ckeditor plugin and updated it to the latest version of 
 ckeditor and fixed a couple of other problems. It's working for me in an 
 app. I'll finish the plugin in a few days, I need to merge my changes back 
 and add some testing code. I've removed the inline edit capability since it 
 depends on JavaScript which appears to be unmaintained.



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: ImportError: cannot import name translitcodec

2014-03-04 Thread Massimo Di Pierro
I am rebuilding the code.

On Tuesday, 4 March 2014 14:16:26 UTC-6, Alex Glaros wrote:

 has anyone seen this error?  It won't let web2py boot on my windows 
 machine. Version 2.9.3-stable+timestamp.2014.03.03.16.38.00


 C:\Program Files\web2pyweb2py.exe
 Traceback (most recent call last):
   File string, line 6, in module
   File __main__.py, line 128, in module
   File __main__web2py__.py, line 18, in module
   File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 17, in 
 module
   File /home/mdipierro/make_web2py/web2py/gluon/validators.py, line 23, 
 in module
 ImportError: cannot import name translitcodec

 thanks,

 Alex Glaros


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: need help with query

2014-03-04 Thread Massimo Di Pierro
This must be a googlegroup bug. We did not delete them.

On Tuesday, 4 March 2014 14:30:54 UTC-6, Bastiaan van der Veen wrote:

 Somehow my replies all got deleted.

 I want one item per group(the newest) and then filter by id_status and 
 count how many groups have that certain id_status. This should be possible 
 i think. I had a nice example in one of those deleted post, but i don't 
 know how i can get that back. 


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: web2py don't start

2014-03-04 Thread Massimo Di Pierro
Please download it again in 10 minutes.

On Tuesday, 4 March 2014 03:19:46 UTC-6, Marc wrote:

 I have the same problem, downloaded the latest version of web2py.exe for 
 Windows and it doesn't run. 

 Get the error: 

 ImportError: cannot import name translitcodec. 

 Older version used to work. I do not have python installed on my machine. 

 Marc


 On Saturday, 1 March 2014 10:18:05 UTC, LB wrote:

 Hello everybody,
 just extracted, but launching web2py.exe or web2py_noconsole.exe I always 
 got this error message:  Impossibile trovare il punto di ingresso wscpy_s 
 della procedura nella libreria di collegamento dinamico msvcrt.dll  (that 
 is like: can't find access point wscpy_s in msvcrt.dll).
 I checked my system (ms-windows xp sp3) and msvcrt.dll is present, and I 
 also make a copy in the web2py folder, with no result.
 I have on python 2.7 and a python(x,y) release.
 Any advice?

 Thanks,

 LB



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: run web2y scheduler instances on 2 or more servers

2014-03-04 Thread Andrey K
Thanks Niphlod, as usual very detail and great answer. Thank you a lot!
After you answer I have check the web and have found several tools that do 
specifically cluster management: StarCluster, Elasticluster. I am really 
keen to try the later one. It looks good specifically for GCE and EC2 work. 
However now I know better how I can utilize w2p scheduler. After figuring 
out how Elasticluster works - might blend work of w2p scheduler and EC.

Thanks again! Really appreciate your help!

On Monday, March 3, 2014 11:33:17 PM UTC+3, Niphlod wrote:



 On Monday, March 3, 2014 1:10:08 PM UTC+1, Andrey K wrote:

 Wow, what an answer! Niphlod, thanks a lot for such a detailed info with 
 examples - now it is crystal clear for me. Very great help, really 
 appreciate it!!!

 You answer make me clarify the future architecture for my app. Before I 
 thought to use amazon internal tools for  task distribution now I think I 
 can use w2p scheduler at least for the first stage or maybe permanently.

 I have several additional question if you allow me. Hope it helps to 
 other members of the w2p club.
 The plan is to start amazon servers (with web2py preinstalled) 
  programmatically when I need it with the purpose to run  w2p scheduler on 
 it.
 Could you give me your point of your on the following  questions that I 
 need to address in order to build such a service:
 1)Can I set up and cancel workers under web2py programmatically  which 
 equivalent 
 to' python web2py.py -K myapp:fast,myapp:fast,myapp:fast'?


 you can put them to sleep, terminate or kill them (read the book or use 
 w2p_scheduler_tests to get comfortable with the terms) but there's no 
 included way to start them on demand. That job is left to various pieces 
 of software that are built from the ground-up to manage external 
 processesupstart, systemd, circus, gaffer, supervisord, foreman, etc 
 are all good matches but each one with a particular design in mind and 
 totally outside the scope of web2py. Coordinating processes among a set of 
 servers just needs a more complicated solution than web2py itself.
  

 2) What is the best way to monitor load of the server to make a decision 
 to start new worker or new server depends on the resources left?


 depends of what you mean by load. Just looking at your question, I see 
 that you never had to manage such architecture :-P..usually you don't 
 want to monitor the load of the server to ADD additional workers... you 
 want to monitor the load of the server to KILL additional workers or ADD 
 servers to process the jobs, watching at the load of the infrastructure. 
 Again usually - because basically every app has its own priorities - you'd 
 want to set an estimate (KPI) on how much the queue can grow before jobs 
 are actually processed, and if the queue is growing faster than the 
 processed items, start either a new worker or a new virtual machine. 
  

 3)Is it possible to set up folder on dedicated server for web2py file 
 upload and make it accessible to all web2py instances = job workers

 linux has all kinds of support for that: either an smb share or an nfs 
 share is the simplest thing to do. a Ceph cluster is probably more 
 complicated, but again we're outside of the scope of web2py 


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] web2py 2.9.4 is OUT

2014-03-04 Thread Massimo Di Pierro
Should have fixed all of the problems that have reported about 2.9.3 but 
please help me check and report on this thread.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: ImportError: cannot import name translitcodec

2014-03-04 Thread J. Michael Kolbe
I get this error on Mac OS X 10.9.2. 

On Tuesday, March 4, 2014 9:16:26 PM UTC+1, Alex Glaros wrote:

 has anyone seen this error?  It won't let web2py boot on my windows 
 machine. Version 2.9.3-stable+timestamp.2014.03.03.16.38.00


 C:\Program Files\web2pyweb2py.exe
 Traceback (most recent call last):
   File string, line 6, in module
   File __main__.py, line 128, in module
   File __main__web2py__.py, line 18, in module
   File /home/mdipierro/make_web2py/web2py/gluon/__init__.py, line 17, in 
 module
   File /home/mdipierro/make_web2py/web2py/gluon/validators.py, line 23, 
 in module
 ImportError: cannot import name translitcodec

 thanks,

 Alex Glaros


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


[web2py] Re: recaptcha in custom forms

2014-03-04 Thread Tim Richardson

I also don't get recpatcha working with auth login at the moment (trunk) 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.