def write_userbookmarks_subsection (xml, user_guid): user_bookmarks = xml.database.cursor() # 13 = select * from elgg_entity_subtypes where subtype='bookmarks'; user_bookmarks.execute(qry.qry_user_posts, (user_guid, user_guid, 13,)) xml.write_open_tag("favoritos",'') for (post_guid, post_title, post_desc, time)\ in user_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) 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") user_bookmarks.close()
def write_uservideos_subsection (xml, user_guid): user_videos = xml.database.cursor() # 12 = select * from elgg_entity_subtypes where subtype='videos'; user_videos.execute(qry.qry_user_posts, (user_guid, user_guid, 12,)) xml.write_open_tag("videos",'') for (post_guid, post_title, post_desc, time)\ in user_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) 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") user_videos.close()
def write_groups_section(xml, \ guid, title, desc, owner_id, owner_name, owner_username, time): # 45 = select * from elgg_metastrings where string='briefdescription'; brief_desc = qry.post_content(xml.database, guid, 45) prefix = 'groups/profile/' group_attr = strf.cidstr(strf.urlparticipa(prefix, str(guid))) xml.write_open_tag("comunidade", group_attr) # Write all group's information prefix = 'profile/' owner_attr = strf.uidstr(strf.urlparticipa(prefix, owner_username)) xml.write_tag("proprietario", owner_name, owner_attr) xml.write_tag("titulo", title, '') xml.write_tag("data", strf.datestr(time), '') xml.write_tag("descricao", strf.cdata(desc), '') xml.write_tag("breve_descricao", strf.cdata(brief_desc), '') if qry.groupaccess_permission(xml.database, guid) == 'public': # Write a list of group member's name write_groupmembers_subsection(xml, guid) # Write a list, and all the info, of all posts made on the group. write_groupfiles_subsection(xml, guid) write_groupforumtopics_subsection(xml, guid) write_groupbookmarks_subsection(xml, guid) write_grouppages_subsection(xml, guid) write_groupvideos_subsection(xml, guid) write_groupevents_subsection(xml, guid) xml.write_close_tag("comunidade")
def write_userblogs_subsection (xml, user_guid): user_blogs = xml.database.cursor() # 4 = select * from elgg_entity_subtypes where subtype='blog'; user_blogs.execute(qry.qry_user_posts, (user_guid, user_guid, 4,)) xml.write_open_tag("blogs",'') for (post_guid, post_title, post_desc, time)\ in user_blogs: post_excerpt = xml.database.cursor() # 64 = select * from elgg_metastrings where string='excerpt'; post_excerpt=qry.post_content(xml.database, post_guid, 64) prefix='blog/view/' post_attr=strf.pidstr(strf.urlparticipa(prefix,str(post_guid))) xml.write_open_tag("blog",post_attr) xml.write_tag("titulo",post_title,'') xml.write_tag("data",strf.datestr(time),'') xml.write_tag("resumo",strf.cdata(post_excerpt),'') xml.write_tag("texto",strf.cdata(post_desc),'') xml.write_comments(post_guid) xml.write_close_tag("blog") xml.write_close_tag("blogs") user_blogs.close()
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_userevents_subsection(json, user_guid): user_events = json.database.cursor() # 6 = select * from elgg_entity_subtypes where subtype='calendar_event'; user_events.execute(qry.qry_user_posts, ( user_guid, user_guid, 6, )) json.write_open_tag("eventos", "[") row = 0 for (post_guid, post_title, post_desc, time)\ in user_events: row = row + 1 # 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_open_tag("", "{") json.write_tag("pid", post_attr, ",") 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", time_start, ",") json.write_tag("dataFim", time_end, ",") json.write_tag("taxaParticipacao", fees, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < user_events.rowcount)) json.write_close_tag("]", False) user_events.close()
def write_groupvideos_subsection(json, group_guid): group_videos = json.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(json.database, group_guid, 399) json.write_tag("videosHabilitado", perm, ",") json.write_open_tag("videos", "[") row = 0 for (post_guid, post_title, post_desc, \ owner_id, owner_name, owner_username, time)\ in group_videos: row = row + 1 # 477 = select * from elgg_metastrings where string='video_url'; video_link = qry.post_content(json.database, post_guid, 477) json.write_open_tag("", "{") prefix = 'videos/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", video_link, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < group_videos.rowcount)) json.write_close_tag("]", True) group_videos.close()
def write_groups_section (json,\ guid, title, desc, owner_id, owner_name, owner_username, time): # 45 = select * from elgg_metastrings where string='briefdescription'; brief_desc = qry.post_content(json.database, guid, 45) prefix = 'groups/profile/' group_attr = strf.urlparticipa(prefix, str(guid)) json.write_tag("cid", group_attr, ",") # Write all group's information prefix = 'profile/' owner_attr = strf.urlparticipa(prefix, owner_username) json.write_open_tag("proprietario", "{") json.write_tag("uid", owner_attr, ",") json.write_tag("nome", owner_name, "") json.write_close_tag("}", True) json.write_tag("titulo", title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("descricao", desc, ",") group_access = qry.groupaccess_permission(json.database, guid) if group_access == 'public': comma = "," else: comma = "" json.write_tag("breveDescricao", brief_desc, comma) if group_access == 'public': # Write a list of group member's name write_groupmembers_subsection(json, guid) # Write a list, and all the info, of all posts made on the group. write_groupfiles_subsection(json, guid) write_groupforumtopics_subsection(json, guid) write_groupbookmarks_subsection(json, guid) write_grouppages_subsection(json, guid) write_groupvideos_subsection(json, guid) write_groupevents_subsection(json, guid)
def write_userevents_subsection (xml, user_guid): user_events = xml.database.cursor() # 6 = select * from elgg_entity_subtypes where subtype='calendar_event'; user_events.execute(qry.qry_user_posts, (user_guid, user_guid, 6,)) xml.write_open_tag("eventos",'') for (post_guid, post_title, post_desc, time)\ in user_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) 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_comments(post_guid) xml.write_close_tag("evento") xml.write_close_tag("eventos") user_events.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_userblogs_subsection(json, user_guid): user_blogs = json.database.cursor() # 4 = select * from elgg_entity_subtypes where subtype='blog'; user_blogs.execute(qry.qry_user_posts, ( user_guid, user_guid, 4, )) json.write_open_tag("blogs", "[") row = 0 for (post_guid, post_title, post_desc, time)\ in user_blogs: row = row + 1 post_excerpt = json.database.cursor() # 64 = select * from elgg_metastrings where string='excerpt'; post_excerpt = qry.post_content(json.database, post_guid, 64) prefix = 'blog/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_open_tag("", "{") json.write_tag("pid", post_attr, ",") json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("resumo", post_excerpt, ",") json.write_tag("texto", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < user_blogs.rowcount)) json.write_close_tag("]", True) user_blogs.close()
def write_uservideos_subsection(json, user_guid): user_videos = json.database.cursor() # 12 = select * from elgg_entity_subtypes where subtype='videos'; user_videos.execute(qry.qry_user_posts, ( user_guid, user_guid, 12, )) json.write_open_tag("videos", "[") row = 0 for (post_guid, post_title, post_desc, time)\ in user_videos: row = row + 1 # 477 = select * from elgg_metastrings where string='video_url'; video_link = qry.post_content(json.database, post_guid, 477) prefix = 'videos/view/' post_attr = strf.urlparticipa(prefix, str(post_guid)) json.write_open_tag("", "{") json.write_tag("pid", post_attr, ",") json.write_tag("titulo", post_title, ",") json.write_tag("data", strf.datestr(time), ",") json.write_tag("link", video_link, ",") json.write_tag("descricao", post_desc, ",") json.write_comments(post_guid) json.write_close_tag("}", (row < user_videos.rowcount)) json.write_close_tag("]", True) user_videos.close()
def write_userbookmarks_subsection(json, user_guid): user_bookmarks = json.database.cursor() # 13 = select * from elgg_entity_subtypes where subtype='bookmarks'; user_bookmarks.execute(qry.qry_user_posts, ( user_guid, user_guid, 13, )) json.write_open_tag("favoritos", "[") row = 0 for (post_guid, post_title, post_desc, time)\ in user_bookmarks: row = row + 1 # 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_open_tag("", "{") json.write_tag("pid", post_attr, ",") 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 < user_bookmarks.rowcount)) json.write_close_tag("]", True) user_bookmarks.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()