[Building Sakai] 2.9.0 DB Conversion, MySQL script error

[Aaron Zeckoski]

The CLE team has been filing bugs when that is not the case (i.e. when
the case does not match) in scripts or code so this has been the
standard practice for awhile. It doesn't mean it is always caught, but
it is the normal practice. I even committed a case fix just yesterday.

I'm not sure this is written down anywhere as a best practice so if
not, we might want to consider that. I will bring it up to the rest of
the TCC.

-AZ


On Fri, Jan 25, 2013 at 4:55 AM, Stephen Marquard
<stephen.marquard at uct.ac.za> wrote:
> I’m with Sam on this one. Developers need to use the correct case for table
> and column names  (i.e. the exact case in which it was created on a
> case-sensitive environment), in code and conversion scripts.
>
>
>
> To say “there’s no guarantee that developers will do this in future” is a
> classic case of shifting the burden, and basically like saying developers
> are lazy and as a Sakai community we have no ability to meet basic quality
> standards, which would be a sad day.
>
>
>
> Cheers
> Stephen
>
>
>
> ---
>
> Stephen Marquard, Acting Director
>
> Centre for Educational Technology, University of Cape Town
> http://www.cet.uct.ac.za
> stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>
>
>
> From: sakai-dev-bounces at collab.sakaiproject.org
> [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Sam
> Ottenhoff
> Sent: 25 January 2013 03:29 AM
> To: Steve Swinsburg; Stephen Marquard
> Cc: sakai-dev at collab.sakaiproject.org
>
>
> Subject: Re: [Building Sakai] 2.9.0 DB Conversion, MySQL script error
>
>
>
>
>
>
>
> On Thu, Jan 24, 2013 at 7:47 PM, Steve Swinsburg <steve.swinsburg at gmail.com>
> wrote:
>
> So how is a new developer meant to know all of these unwritten rules if they
> aren't described anywhere?
>
>
>
> As a community, we've decided to support MySQL and Oracle.  I don't like
> fixing Oracle syntax issues especially because I don't run Oracle.  But I
> help fix them because I want institutions that run Oracle to use Sakai.  If
> Oracle changes syntax that breaks Sakai queries, we'll fix Sakai.  It's yet
> another thing that we developers need to learn and adapt to.  If you use
> opposite cases with MySQL, someone will eventually catch it and correct it.
> Here are the rules of our dependency, MySQL:
> http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html
>
>
>
>
>
> I disagree that there are too many requirements.
>
>
>
>
>
> I can't imagine you are in the majority.
>
>
>
>
>
> My point is that if the rule you proposed was enforced on table creation,
> not just updates, you wouldn't have that mess.
>
>
>
>
>
> The rule I proposed was consistency, that's all. I'm too busy right now to
> make consistent all table names in Sakai CLE. Until the day I have the time,
> or someone else volunteers, I will continue to fix JIRAs like the one
> originally reported in this thread.
>
>
>
> --Sam
>
> ________________________________
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27
> 21 650 9111. This e-mail is intended only for the person(s) to whom it is
> addressed. If the e-mail has reached you in error, please notify the author.
> If you are not the intended recipient of the e-mail you may not use,
> disclose, copy, redirect or print the content. If this e-mail is not related
> to the business of UCT it is sent by the sender in the sender's individual
> capacity.
>
>
> _______________________________________________
> 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