[Building Sakai] How the data is Transforming from VM to DB?

[Steve Swinsburg]

Hi Bhanu,

SiteAction won't call getInsertSql directly. It will most likely call SiteService.save, or similar high level API call. If you then open up SiteService.save, and follow it's logic, you will end up at the pieces of code that writes the data. In this case, you probably want to look at DbSiteService, SiteServiceSql and SiteServiceSqlDefault, possibly the other variants for different databases (eg SiteServiceSqlOracle) if a certain SQL call requires special handling for that database type.

cheers,
Steve



On 29/01/2011, at 4:40 PM, Bhanu.T.Motupalli wrote:

> 
> Hi Steve,
> 
> Thanks for the reply. I know that All the methods to persist and retrieve
> data are almost in Kernel. But the problem is.. lets go to some deep
> explanation,
> 
> In SteSetUp --> CourseSite--> New-->
>   Here i am adding some fields. These all information maintained in a
> session up to the last form(Where we request site). There the data is saving
> into the db. Here, i found, totally 6 rows are inserting into the
> SAKAI_SITE_PROPERTY table and 1 row is inserting into SAKAI_SITE table.
> Here, i found a method in "Kernel-impl",
> "org.sakaiproject.util.FlatStrorgeSqlDefault", called getInsertSql(), can
> have a insert statement to insert data. But here we can insert only either 3
> or 4 records. apart from this method i cannot find any method to persist the
> data. Then What about SAKAI_SITE, there are totally 18 fields inserting into
> the table. SAKAI_SITE_PROPERTY have only 3 columns. And i cannot able to
> find where the method getInsertSql() in SiteAction class.
> 
> Regards
> Bhanu. 
> 
> Steve Swinsburg-3 wrote:
>> 
>> Hi Bhanu,
>> 
>> The kernel is the core set of APIs and provide methods to persist and
>> retrieve data, amongst other functions. If you trace one of the methods
>> you are interested in you'll see in which class it ends up, and how that
>> data is saved to the database.
>> 
>> cheers,
>> Steve
>> 
>> 
>> On 28/01/2011, at 5:31 PM, Bhanu.T.Motupalli wrote:
>> 
>>> 
>>> Hello Sakai Team,
>>> 
>>>      I am doing some work in site-manage-tool. Actually i am not able to
>>> find how the data is Inserting into the database from SiteAction.java to
>>> Kernal-api or Kernal-util. Actually, I find, data is transforing from
>>> chef_site-newSiteConfirm.vm to SiteAction.java, from there to it is going
>>> to
>>> Kernal-api or Kernal-util. Here the problem is I cannot able to find what
>>> methods you used to transfor the data from SiteAction to Those Kernels.
>>> 
>>> Regrads,
>>> Bhanu.
>>> -- 
>>> View this message in context:
>>> http://old.nabble.com/How-the-data-is-Transforming-from-VM-to-DB--tp30784060p30784060.html
>>> Sent from the Sakai - Development mailing list archive at Nabble.com.
>>> 
>>> _______________________________________________
>>> 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"
>> 
>> _______________________________________________
>> 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"
>> 
>> 
> 
> -- 
> View this message in context: http://old.nabble.com/How-the-data-is-Transforming-from-VM-to-DB--tp30784060p30792708.html
> Sent from the Sakai - Development mailing list archive at Nabble.com.
> 
> _______________________________________________
> 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"