[Building Sakai] Excessive querying ofSAKAI_SITE_PAGE_PROPERTYtable in 2.6?

[Zhen Qian]

Home page is a special page within a site, and is by default selected/ 
required for a site.  Normally, Home page consists of  
"sakai.iframe.site" tool and other synoptic tools, but any other tool  
can be added to Home page with admin rights.

We used to find Home page by page title, but that causes problem when  
dealing with internationalization and renaming page titles. See the  
following two jiras and related ones:

SAK-15941: In Page Order, the Home page loses most of its  
functionality when its title is changed

SAK-16679: Home Page titles should be displayed in user's preferred  
language/locale

So the solution now is to store the is_home_page as a page property  
to facilitate the Home page lookup.

That means you could have as many record of "is_home_page" property  
as the number of your sites...

Thanks,

- Zhen


On Aug 28, 2009, at 10:34 AM, Stephen Marquard wrote:

> Site Info seems to use is_home_page as a page property under some  
> circumstances:
>
> site-manage-tool/tool/src/java/org/sakaiproject/site/tool/ 
> SiteAction.java:                      if (page.getProperties 
> ().getProperty(SiteConstants.IS_HOME_PAGE) == null)
>
> site-manage-tool/tool/src/java/org/sakaiproject/site/tool/ 
> SiteAction.java:                              page.getPropertiesEdit 
> ().addProperty(SiteConstants.IS_HOME_PAGE, Boolean.TRUE.toString());
>
> site-manage-tool/tool/src/java/org/sakaiproject/site/tool/ 
> SiteAction.java:              if (page.getProperties().getProperty 
> (SiteConstants.IS_HOME_PAGE) != null)
>
> site-manage-util/util/src/java/org/sakaiproject/site/util/ 
> SiteConstants.java:   public static final String IS_HOME_PAGE =  
> "is_home_page";
>
> Maybe Zhen knows more about this.
>
> Cheers
> Stephen
>
>
>
>
>
> Stephen Marquard, Learning Technologies Co-ordinator
> Centre for Educational Technology, University of Cape Town
> http://www.cet.uct.ac.za
> Email/IM/XMPP: stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>
>>>> "Maurer, Christopher Wayne" <chmaurer at iupui.edu> 8/28/2009 4:28  
>>>> PM >>>
> But site properties are not the same as page properties.  We use  
> some site
> properties here for various things all the time.
> What sorts of properties are used for pages?
>
> Chris
>
>
> On 8/28/09 10:24 AM, "Mark Norton" <markjnorton at earthlink.net> wrote:
>
>> May, Megan Marie wrote:
>>>> Would you be willing to share those situations you've used it?
>>>>
>> Some time ago, I was asked by a client to make some rather extensive
>> changes to the Sakai portal.  Most of these changes where layout and
>> could be handle in CSS and Velocity templates.  A few changes  
>> required
>> new flags and state data to be associated with a course site.  Custom
>> tools were proposed to take advantage of this new data with the
>> requirement that other, existing Sakai tools continue to work.  Site
>> properties was the simplest (and most economical) way to implement  
>> this
>> capability.
>>
>> After many months of design, discussion and evaluation, the client
>> decided not to use Sakai and went off on another path.  Had they  
>> chosen
>> to stay, site properties would have been highly useful in  
>> implementing
>> the design.
>>
>> - Mark
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev- 
> unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>