[cle-release-team] Lesson Builder SQL scripts

[Beth Kirschner]

Happy New Year everyone!

   Chuck has created some SQL scripts for Lesson Builder table/index creation (see below) -- I can add these to the 2.9 conversion scripts later today, but thought it worth mentioning to others who might have an opinion (especially Seth, who's worked with conversion scripts in the past with Anthony). 

- Beth

Begin forwarded message:

> From: Charles Hedrick <hedrick at rutgers.edu>
> Date: January 3, 2012 9:48:30 AM EST
> To: Beth Kirschner <bkirschn at umich.edu>
> Subject: Re: sql file
> 
> Since I can edit library, could you add 
> 
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x//hbm/src/ddl/mysql/lessonbuilder.sql
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/hbm/src/ddl/oracle/lessonbuilder.sql
> 
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/components/src/ddl/mysql/simplepage.sql
> https://source.sakaiproject.org/svn/lessonbuilder/branches/lessonbuilder-1.4.x/components/src/ddl/oracle/simplepage.sql
> 
> to the appropriate scripts? All the dialects are there if you want others.
> 
> The first create the tables. The second add the indices. Because of hibernate problems I can't depend upon hibernate to add indices. The files to create indices are maintained by hand.
> 
> The table creation files were generated using
> 
> hibernate.dialect=org.hibernate.dialect.MySQLDialect
> hibernate.dialect=org.hibernate.dialect.OracleDialect
> 
> We actually use MySQL5Dialect in production, and I'm guessing Oracle sites use the appropriate version, but I don't think we want that many different scripts. I compared the mysql file with my test system and the differences looked OK. 
> 
> ---------
> 
> I have updated SAK-21069 with two items for the release notes. I've also checked my installation notes to see whether there is anything that someone might have to do with the 2.9 version. I believe all of these are going to be in 2.9, but if any is not, I'll need to add something for the release notes. I'll be checking them shortly and updating the comment appropriately:
> 
> 1) permissions set
> 
> 2) portal.pda.bypass.sakai.lessonbuildertool=linktracker$|/uvbview$|\.jpg$|\.gif$|\.js$|\.png$|\.jepg$|\.css$|\.zip$|\.pdf\.mov$|\.json$|\.jsonp$\.xml$|\.ajax$|\.xls|\.xlsx|\.doc|\.docx
> 
> 3) .neoPortletTitleWrap added to tool.css
> 
> 
> 
> On Jan 3, 2012, at 9:23 AM, Beth Kirschner wrote:
> 
>> On Jan 3, 2012, at 9:16 AM, Charles Hedrick wrote:
>> 
>>> Do you consider this conversion? For most sites it's going to be a new tool.
>> I consider this a conversion for 2.9 -- this is a new tool for the official 2.9 release. I
>> 
>>> For sites that have it already they have a strange conglomeration of existing versions. I think enabling auto.ddl at least temporarily is the safest thing for them.
>>> 
>> I'd write something up to the release notes for https://jira.sakaiproject.org/browse/SAK-21069 (the "Release Notes" tab is visible when you select "Edit"), so it doesn't get forgotten.
>> 
>>> I was responding to a comment from someone that a core tool needed to provide a script to create the database tables initially.
>>> 
>> Right -- not all sites use auto.ddl.
>> 
>> Thanks!
>> - Beth
>> 
>>> 
>>> On Jan 3, 2012, at 8:45 AM, Beth Kirschner wrote:
>>> 
>>>> Hi Chuck -- happy new year!
>>>> 
>>>> The standard place for SQL conversion files is in https://source.sakaiproject.org/svn/reference/trunk/docs/conversion:
>>>> 	sakai_2_9_0_mysql_conversion.sql
>>>> 	sakai_2_9_0_oracle_conversion.sql
>>>> 
>>>> Thanks!
>>>> - Beth
>>>> 
>>>> On Jan 2, 2012, at 9:26 PM, Hedrick Charles wrote:
>>>> 
>>>>> FYI, trunk and 1.4.x of lessonbuilder now have a working DDL generator. I have build .sql files to create the database tables.
>>>>> 
>>>>> The README documents this. Is there any standard place that the files go?
>>>>> 
>>>>> 
>>>>> 
>>>> 
>>> 
>>> 
>>> 
>> 
> 
> 
>