Hi guys, I spend a few hours today building a little utility to test the "case" in the database schema against what farcry has in the coapi.
Basically it: - Looks for differences in case between mysql table names, and the relevant references in the farcry coapi - If differences are found you can attempt to "fix" them by renaming the database tables. - Looks for "types", "rules" and "schema" farcry references - Runs on MySQL only. - Needs "read" access to the information schema - Needs "rename" permission - Finds instances where tables exist but nothing is found in the coapi (notification only) We've run it locally and it works great, our 6.1 release is now Linux compatible. The possible problem of having access to information_schema (needed for this to run) shouldn't be a problem for people as you'd run it locally anyway (as opposed to a production environment where you may be locked down). I'm sure it could have been done cleaner, but it works for us. If you're interested and I'll pass it on, it basically sits as a customAdmin file under the "Admin" tab. Michael On Sep 30, 11:03 am, Blair McKenzie <[email protected]> wrote: > Have updated p600, and merged all recent p600 fixes into trunk. Let me know > if there are any problems with the update. > > Blair > > On Thu, Sep 30, 2010 at 8:48 AM, Sean Coyne <[email protected]> wrote: > > The convention has been to use the same case as the CFC (headless > > camel case). farFU is kind of an odd ball as "FU" is an acronym. > > > I'm sure Blair will commit to p600 as well as trunk > > > On Sep 29, 6:25 pm, Michael Sharman <[email protected]> wrote: > > > Hi Blair, > > > > In the interim I'm happy to take Phillip's idea of a small local patch > > > to "fix" the case sensitive issues until this is rolled into p600 > > > (hopefully!). But to do this I'd need to know the "correct" names. > > > Should I simply follow the case of the cfc's and hope that they won't > > > change in a future release? > > > > On Sep 29, 10:03 pm, Blair McKenzie <[email protected]> wrote: > > > > > Thanks Sean. I'll commit those fixes tomorrow. > > > > > On 29/09/2010 9:31 PM, "Sean Coyne" <[email protected]> wrote: > > > > > Blair, > > > > > in p600: > > > > > packages/types/farFU.cfc > > > > > lines: > > > > > 1154 > > > > 1196 > > > > 1572 > > > > 1614 > > > > 1620 > > > > > change "farFu" to "farFU" > > > > > in trunk: > > > > > packages/types/farFU.cfc > > > > > lines: > > > > > 1171 > > > > 1213 > > > > 1589 > > > > 1631 > > > > 1637 > > > > > change "farFu" to "farFU" > > > > > On Sep 28, 8:15 pm, Blair McKenzie <[email protected]> wrote: > > > > > > farFU should always have been the c... > > > > > On Tue, Sep 28, 2010 at 10:35 PM, Sean Coyne <[email protected]> > > wrote: > > > > > > I have hit this as ... > > > -- > > 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] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
