[Building Sakai] conversion scripts

[Steve Swinsburg]

Oracle doesn't support the 'if not exists' syntax however the create table statement could be wrapped in a pl/SQL block and the error trapped, so that it doesn't fail the script. It's only a few extra lines. 

Cheers
Steve

Sent from my iPhone

On 14/06/2013, at 22:24, Aaron Zeckoski <azeckoski at unicon.net> wrote:

> That is mysql 5.1 documentation that you referenced. Oracle (the
> company) owns mysql now but that doesn't mean oracle database (the
> product) has the same syntax rules.
> 
> This is a link to the oracle database documentation for create table:
> http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm
> 
> As I mentioned, oracle database does not support this "if not exists" syntax.
> -AZ
> 
> 
> On Fri, Jun 14, 2013 at 7:43 AM, Nguni Phakela <nguni52 at gmail.com> wrote:
>> I checked this documentation also to see if it will work on oracle
>> http://docs.oracle.com/cd/E17952_01/refman-5.1-en/create-table.html and from
>> what is written there it seems that it would also work for oracle, unless
>> They haven't updated the documentation or I read the wrong version of the
>> documentation.
>> 
>> 
>> 
>> 
>> On Fri, Jun 14, 2013 at 1:38 PM, Aaron Zeckoski <azeckoski at unicon.net>
>> wrote:
>>> 
>>> That kind of syntax only works in MySQL (or a few others like MSSQL)
>>> so I guess you are suggesting we do this for the MySQL scripts only.
>>> I'm not sure why this would be needed and I am not sure we want to
>>> support differences in the scripts like this (it is extra effort over
>>> time since the behavior is no longer the same)?
>>> 
>>> The scripts are stored in the code itself in reference/docs/conversion/.
>>> 
>>> -AZ
>>> 
>>> 
>>> On Fri, Jun 14, 2013 at 7:09 AM, Nguni Phakela <nguni52 at gmail.com> wrote:
>>>> Hi All,
>>>> 
>>>> Is it possible that we can change the conversion scripts such that the
>>>> ones
>>>> about creating tables have a IF NOT EXISTS part to them. I can
>>>> definitely do
>>>> this if anyone can let me know how I can update those pages and everyone
>>>> is
>>>> in agreement.
>>>> 
>>>> Kind Regards,
>>>> 
>>>> --
>>>> Nguni Phakela
>>>> 
>>>> _______________________________________________
>>>> 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"
>>> 
>>> 
>>> 
>>> --
>>> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
>> 
>> 
>> 
>> 
>> --
>> Nguni Phakela
> 
> 
> 
> -- 
> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> _______________________________________________
> 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"