def write_groupevents_subsection(xml, group_guid): group_events = xml.database.cursor() # 6 = select * from elgg_entity_subtypes where subtype='calendar_event'; group_events.execute(qry.qry_group_posts, ( group_guid, 6, )) # 54 = select * from elgg_metastrings where string='event_calendar_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 54) xml.write_open_tag("eventos", strf.permstr(perm)) for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_events: # 18 = select * from elgg_metastrings where string='venue'; venue = qry.post_content(xml.database, post_guid, 18) # 20 = select * from elgg_metastrings where string='start_date'; time_start = qry.post_content(xml.database, post_guid, 20) # 22 = select * from elgg_metastrings where string='end_date'; time_end = qry.post_content(xml.database, post_guid, 22) # 26 = select * from elgg_metastrings where string='fees'; fees = qry.post_content(xml.database, post_guid, 26) # 28 = select * from elgg_metastrings where string='contact'; contact = qry.post_content(xml.database, post_guid, 28) # 30 = select * from elgg_metastrings where string='organizer'; organizer = qry.post_content(xml.database, post_guid, 30) prefix = 'event_calendar/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("evento", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("organizador", organizer, '') xml.write_tag("contato", contact, '') xml.write_tag("endereco", venue, '') xml.write_tag("data_inicio", strf.datestr(time_start), '') xml.write_tag("data_fim", strf.datestr(time_end), '') xml.write_tag("taxa_participacao", fees, '') xml.write_tag("descricao", strf.cdata(post_desc), '') xml.write_close_tag("evento") xml.write_comments(post_guid) xml.write_close_tag("eventos") group_events.close()
def write_groupfiles_subsection(json, group_guid): group_files = json.database.cursor() # 1 = select * from elgg_entity_subtypes where subtype='file'; group_files.execute(qry.qry_group_posts, ( group_guid, 1, )) # 50 = select * from elgg_metastrings where string='file_enable'; perm = qry.postcontent_permission(json.database, group_guid, 50) json.write_tag("arquivosHabilitado", perm, ",") json.write_open_tag("arquivos", "[") row = 0 for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_files: row = row + 1 json.write_open_tag("", "{") prefix = 'file/download/' file_link = strf.urlparticipa(prefix, str(post_guid)) prefix = 'file/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_tag("pid", post_attr, ",") prefix = 'profile/' owner_attr = strf.urlparticipa(prefix, owner_username) json.write_open_tag("autor", "{") json.write_tag("uid", owner_attr, ",") json.write_tag("nome", owner_name, "") json.write_close_tag("}", True) json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("link", file_link, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < group_files.rowcount)) json.write_close_tag("]", True) group_files.close()
def write_groupbookmarks_subsection(json, group_guid): group_bookmarks = json.database.cursor() # 13 = select * from elgg_entity_subtypes where subtype='bookmarks'; group_bookmarks.execute(qry.qry_group_posts, ( group_guid, 13, )) # 49 = select * from elgg_metastrings where string='bookmarks_enable'; perm = qry.postcontent_permission(json.database, group_guid, 49) json.write_tag("favoritosHabilitado", perm, ",") json.write_open_tag("favoritos", "[") row = 0 for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_bookmarks: row = row + 1 json.write_open_tag("", "{") # 90 = select * from elgg_metastrings where string='address'; bookmark_link = qry.post_content(json.database, post_guid, 90) prefix = 'bookmarks/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_tag("pid", post_attr, ",") prefix = 'profile/' owner_attr = strf.urlparticipa(prefix, owner_username) json.write_open_tag("autor", "{") json.write_tag("uid", owner_attr, ",") json.write_tag("nome", owner_name, "") json.write_close_tag("}", True) json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("link", bookmark_link, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < group_bookmarks.rowcount)) json.write_close_tag("]", True) group_bookmarks.close()
def write_groupforumtopics_subsection(json, group_guid): group_forumtopics = json.database.cursor() # 7 = select * from elgg_entity_subtypes where subtype='groupforumtopic'; group_forumtopics.execute(qry.qry_group_posts, ( group_guid, 7, )) # 52 = select * from elgg_metastrings where string='forum_enable'; perm = qry.postcontent_permission(json.database, group_guid, 52) json.write_tag("debatesHabilitado", perm, ",") json.write_open_tag("debates", "[") row = 0 for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_forumtopics: row = row + 1 json.write_open_tag("", "{") prefix = 'discussion/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_tag("pid", post_attr, ",") prefix = 'profile/' owner_attr = strf.urlparticipa(prefix, owner_username) json.write_open_tag("autor", "{") json.write_tag("uid", owner_attr, ",") json.write_tag("nome", owner_name, "") json.write_close_tag("}", True) json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("texto", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < group_forumtopics.rowcount)) json.write_close_tag("]", True) group_forumtopics.close()
def write_groupfiles_subsection(xml, group_guid): group_files = xml.database.cursor() # 1 = select * from elgg_entity_subtypes where subtype='file'; group_files.execute(qry.qry_group_posts, ( group_guid, 1, )) # 50 = select * from elgg_metastrings where string='file_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 50) xml.write_open_tag("arquivos", strf.permstr(perm)) for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_files: prefix = 'file/download/' file_link = strf.urlparticipa(prefix, str(post_guid)) prefix = 'file/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("arquivo", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("link", '', strf.hrefstr(file_link)) xml.write_tag("descricao", strf.cdata(post_desc), '') xml.write_comments(post_guid) xml.write_close_tag("arquivo") xml.write_close_tag("arquivos") group_files.close()
def write_groupvideos_subsection(xml, group_guid): group_videos = xml.database.cursor() # 12 = select * from elgg_entity_subtypes where subtype='videos'; group_videos.execute(qry.qry_group_posts, ( group_guid, 12, )) # 399 = select * from elgg_metastrings where string='videos_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 399) xml.write_open_tag("videos", strf.permstr(perm)) for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_videos: # 477 = select * from elgg_metastrings where string='video_url'; video_link = qry.post_content(xml.database, post_guid, 477) prefix = 'videos/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("video", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("link", '', strf.hrefstr(video_link)) xml.write_tag("descricao", strf.cdata(post_desc), '') xml.write_comments(post_guid) xml.write_close_tag("video") xml.write_close_tag("videos") group_videos.close()
def write_groupbookmarks_subsection(xml, group_guid): group_bookmarks = xml.database.cursor() # 13 = select * from elgg_entity_subtypes where subtype='bookmarks'; group_bookmarks.execute(qry.qry_group_posts, ( group_guid, 13, )) # 49 = select * from elgg_metastrings where string='bookmarks_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 49) xml.write_open_tag("favoritos", strf.permstr(perm)) for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_bookmarks: # 90 = select * from elgg_metastrings where string='address'; bookmark_link = qry.post_content(xml.database, post_guid, 90) prefix = 'bookmarks/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("favorito", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("link", '', strf.hrefstr(bookmark_link)) xml.write_tag("descricao", strf.cdata(post_desc), '') xml.write_comments(post_guid) xml.write_close_tag("favorito") xml.write_close_tag("favoritos") group_bookmarks.close()
def write_grouppages_subsection(xml, group_guid): group_pages = xml.database.cursor() # 14 = select * from elgg_entity_subtypes where subtype='page_top'; group_pages.execute(qry.qry_group_posts, ( group_guid, 14, )) # 53 = select * from elgg_metastrings where string='pages_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 53) xml.write_open_tag("paginas", strf.permstr(perm)) for (post_guid, post_title, post_desc, owner_id, owner_name, owner_username, time)\ in group_pages: prefix = 'pages/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("pagina", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("texto", strf.cdata(post_desc), '') xml.write_comments(post_guid) xml.write_close_tag("pagina") xml.write_close_tag("paginas") group_pages.close()
def write_groupforumtopics_subsection(xml, group_guid): group_forumtopics = xml.database.cursor() # 7 = select * from elgg_entity_subtypes where subtype='groupforumtopic'; group_forumtopics.execute(qry.qry_group_posts, ( group_guid, 7, )) # 52 = select * from elgg_metastrings where string='forum_enable'; perm = qry.postcontent_permission(xml.database, group_guid, 52) xml.write_open_tag("debates", strf.permstr(perm)) for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_forumtopics: prefix = 'discussion/view/' post_attr = strf.pidstr(strf.urlparticipa(prefix, str(post_guid))) xml.write_open_tag("debate", post_attr) prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("autor", owner_name, owner_attr) xml.write_tag("titulo", post_title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("texto", strf.cdata(post_desc), '') xml.write_comments(post_guid) xml.write_close_tag("debate") xml.write_close_tag("debates") group_forumtopics.close()
def write_groupevents_subsection(json, group_guid): group_events = json.database.cursor() # 6 = select * from elgg_entity_subtypes where subtype='calendar_event'; group_events.execute(qry.qry_group_posts, ( group_guid, 6, )) # 54 = select * from elgg_metastrings where string='event_calendar_enable'; perm = qry.postcontent_permission(json.database, group_guid, 54) json.write_tag("eventosHabilitado", perm, ",") json.write_open_tag("eventos", "[") row = 0 for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_events: row = row + 1 json.write_open_tag("", "{") # 18 = select * from elgg_metastrings where string='venue'; venue = qry.post_content(json.database, post_guid, 18) # 20 = select * from elgg_metastrings where string='start_date'; time_start = qry.post_content(json.database, post_guid, 20) # 22 = select * from elgg_metastrings where string='end_date'; time_end = qry.post_content(json.database, post_guid, 22) # 26 = select * from elgg_metastrings where string='fees'; fees = qry.post_content(json.database, post_guid, 26) # 28 = select * from elgg_metastrings where string='contact'; contact = qry.post_content(json.database, post_guid, 28) # 30 = select * from elgg_metastrings where string='organizer'; organizer = qry.post_content(json.database, post_guid, 30) prefix = 'event_calendar/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_tag("pid", post_attr, ",") prefix = 'profile/' owner_attr = strf.urlparticipa(prefix, owner_username) json.write_open_tag("autor", "{") json.write_tag("uid", owner_attr, ",") json.write_tag("nome", owner_name, "") json.write_close_tag("}", True) json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("organizador", organizer, ",") json.write_tag("contato", contact, ",") json.write_tag("endereco", venue, ",") json.write_tag("dataInicio", strf.datestr(time_start), ",") json.write_tag("dataFim", strf.datestr(time_end), ",") json.write_tag("taxaParticipacao", fees, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < group_events.rowcount)) json.write_close_tag("]", False) group_events.close()