|
By:
richard
Rank: Starfleet Lieutenant, Junior Grade
Postings: 32
From: Australia
|
hello,
I am interested in getting Pyforum running on Google App Engine. I noticed there is still one raw SQL query left to translate, so that is one obstacle. Are there any other obstacles I should be aware of?
Richard
|
|
By:
richard
Rank: Starfleet Lieutenant, Junior Grade
Postings: 32
From: Australia
|
The main issue (that I know of) is converting 1 complex mysql query to use the DAL. I made an effort (here: http://pyforum.org/pyforum/default/view_topic/80), but never finished. It would be great to get pyforum working on GAE!
|
|
By:
richard
Rank: Starfleet Lieutenant, Junior Grade
Postings: 32
From: Australia
|
I just checked and the latest version still has this problem in controllers/default.py:
# This is one of the few SQL queries that I still need to port to web2py's DAL, any takers? sql = """ select zfc.id as cat_id, zfc.cat_name, zfc.cat_desc, zfc.cat_visible_to, zfc.cat_sort, zf.id as forum_id, zf.forum_title, zf.forum_desc, zf.moderation_flag, zf.anonymous_viewaccess, zf.add_postings_access_roles, zf.reply_postings_access_roles, zf.forum_sort, count(nullif(zt.parent_flag='T',0)) as parents, count(nullif(zt.parent_flag='F',0)) as siblings, sum(zt.hits) as hits from zf_forum_category as zfc left join zf_forum as zf on zfc.id = zf.cat_id left join zf_topic as zt on zt.forum_id = zf.id and zt.disabled_flag = 0 group by zf.id, zf.forum_title, zf.forum_desc, zf.moderation_flag, zf.anonymous_viewaccess, zf.add_postings_access_roles, zfc.id, zfc.cat_name, zfc.cat_desc, zfc.cat_visible_to, zfc.cat_sort, zf.reply_postings_access_roles, zf.forum_sort order by zfc.cat_sort, zf.forum_sort """
cats_and_forums = db.executesql(sql)
|
|
By:
rochacbruno
Rank: Starfleet Ensign
Postings: 9
From:
|
I am working on that Queries, trying to port some to GAE, or to find a workaround.
If I succeed I will post here later!
{{ }}'s
@rochacbruno rochacbruno.com.br
|