[Building Sakai] Doubt in login module

[Berg, Alan]

Hi Rajesh,

It looks like part of the Portal code.  Please can you write a Jira for this under the sakai project component portal. It may of been introduced during the introduction of parent sites functionality. Not sure so let the project lead decide.

Alan

Alan Berg
QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam
________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Rajesh Kumar K P [rajeshkumarkp at aims.amrita.edu]
Sent: 07 March 2011 07:10
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] Doubt in login module

Dear All
While logging in sakai(we are using sakai 2.6.1), the following query is executed twice,
 select SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID = SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = 'admin' and SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by SAKAI_SITE.TITLE ASC
 Upon looking at the source code, it is found that the following functions are generating this query.
 SiteHelper.java

1)doSite() --> includeSiteNav() --> includeTabs() --> getSitesView() --> Constructor in
DefaultSiteViewImpl --> Constructor in AbstractSiteViewImpl --> getSitesAtNode()

2)doSite() --> includeSubSites() --> getSitesView() --> Constructor in SubSiteViewImpl -->
Constructor in AbstractSiteViewImpl --> getSitesAtNode()

Ultimately both these functions are calling the same function getSitesAtNode() in
AbstractSiteViewImpl.java.

Do we need to call both these methods in doSite()

With Regards

Rajesh




-----------------------------------------
Amrita Institute Of Medical Sciences & Research Centre, Cochin, India



Amrita Institute of Medical Sciences & Research Center. Amrita Lane; AIMS Ponekkara P.O; Kochi-682041. Kerala, South India.
Tel: +91 484 2801234,2851234,4001234 Fax: +91 484 2802020 Email: admin at aims.amrita.edu Web: www.aimshospital.org


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110307/49c0e17a/attachment.html