This type of utility might be ok for custom type, but not for core types. The core codebase should know what the table names are (including the correct case), and considering it (the core codebase) is the only thing which controls DDL statements everything should be ok. I think this is what needs to be sorted out first...the official map of core table names (and corresponding class names).
On Sep 28, 3:30 pm, AJ Mercer <[email protected]> wrote: > maybe create an Admin utility than can be manually run on all types/rules? > > On 28 September 2010 13:13, Blair McKenzie <[email protected]> wrote: > > > > > SQL server does. Then the trick is going to be knowing when it is > > warranted. Is it only for fixing table case? > > > On Tue, Sep 28, 2010 at 2:55 PM, AJ Mercer <[email protected]> wrote: > > >> mySQL has a statement to do this is one hit > >> http://dev.mysql.com/doc/refman/5.0/en/rename-table.html > > >> I would expect other engines do as well? > > >> On 28 September 2010 12:23, Blair McKenzie <[email protected]> wrote: > > >>> I would have to drop the table then recreate it, presumably querying > >>> first then re-inserting every record afterwards. Not sure how practical > >>> that > >>> is. > > >>> On Tue, Sep 28, 2010 at 1:46 PM, AJ Mercer <[email protected]> wrote: > > >>>> Blair, > > >>>> can you add a alterTable to change table name to match the casing of the > >>>> filename? > > >>>> On 28 September 2010 11:35, Blair McKenzie <[email protected]> wrote: > > >>>>> I did the refactoring on a Linux desktop. Of course I may have turned > >>>>> of case sensitivity sometime in the distant past, so I can't be certain > >>>>> it > >>>>> won't be a problem. If it turns out case is still an issue I would > >>>>> personally prefer that the case of the table match the case of the > >>>>> component. > > >>>>> Blair > > >>>>> On Tue, Sep 28, 2010 at 1:12 PM, Michael Sharman > >>>>> <[email protected]>wrote: > > >>>>>> I have a farcry 5.2.7 project which I've upgraded to 6.1 but have > >>>>>> noticed that a lot of the table names have changed case from what they > >>>>>> were previously (after updating the coapi). > > >>>>>> Tables like: > >>>>>> dmarchive (was dmArchive) > >>>>>> dmevent (was dmEvent) > >>>>>> etc > > >>>>>> We've previously had a few issues with database table names as we run > >>>>>> on Linux, I'm on a mac at the moment so I can't do a test yet. My > >>>>>> question...is this correct? Is there a naming "convention" for > >>>>>> database tables, at least the core ones? I have a funny feeling if I > >>>>>> ran this on linux it would fail. > > >>>>>> Should the naming convention be headless camel case; so dmImage > >>>>>> instead of dmimage etc? Same for any far** prefixed tables. > > >>>>>> Thanks. > > >>>>>> -- > >>>>>> You received this message cos you are subscribed to "farcry-dev" > >>>>>> Google group. > >>>>>> To post, email: [email protected] > >>>>>> To unsubscribe, email: > >>>>>> [email protected]<farcry-dev%[email protected]> > >>>>>> For more options:http://groups.google.com/group/farcry-dev > >>>>>> -------------------------------- > >>>>>> Follow us on Twitter:http://twitter.com/farcry > > >>>>> -- > >>>>> You received this message cos you are subscribed to "farcry-dev" Google > >>>>> group. > >>>>> To post, email: [email protected] > >>>>> To unsubscribe, email: > >>>>> [email protected]<farcry-dev%[email protected]> > >>>>> For more options:http://groups.google.com/group/farcry-dev > >>>>> -------------------------------- > >>>>> Follow us on Twitter:http://twitter.com/farcry > > >>>> -- > > >>>> *AJ Mercer* > >>>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org > >>>> community="Open" /> <http://webonix.org> > >>>>http://twitter.com/webonix > > >>>> -- > >>>> You received this message cos you are subscribed to "farcry-dev" Google > >>>> group. > >>>> To post, email: [email protected] > >>>> To unsubscribe, email: > >>>> [email protected]<farcry-dev%[email protected]> > >>>> For more options:http://groups.google.com/group/farcry-dev > >>>> -------------------------------- > >>>> Follow us on Twitter:http://twitter.com/farcry > > >>> -- > >>> You received this message cos you are subscribed to "farcry-dev" Google > >>> group. > >>> To post, email: [email protected] > >>> To unsubscribe, email: > >>> [email protected]<farcry-dev%[email protected]> > >>> For more options:http://groups.google.com/group/farcry-dev > >>> -------------------------------- > >>> Follow us on Twitter:http://twitter.com/farcry > > >> -- > > >> *AJ Mercer* > >> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org > >> community="Open" /> <http://webonix.org> > >>http://twitter.com/webonix > > >> -- > >> You received this message cos you are subscribed to "farcry-dev" Google > >> group. > >> To post, email: [email protected] > >> To unsubscribe, email: > >> [email protected]<farcry-dev%[email protected]> > >> For more options:http://groups.google.com/group/farcry-dev > >> -------------------------------- > >> Follow us on Twitter:http://twitter.com/farcry > > > -- > > You received this message cos you are subscribed to "farcry-dev" Google > > group. > > To post, email: [email protected] > > To unsubscribe, email: > > [email protected]<farcry-dev%[email protected]> > > For more options:http://groups.google.com/group/farcry-dev > > -------------------------------- > > Follow us on Twitter:http://twitter.com/farcry > > -- > > *AJ Mercer* > <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org > community="Open" /> <http://webonix.org>http://twitter.com/webonix -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
