|
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
|
