Re: ERXMigration eomodel indexed columns

From: Kieran Kelleher (kieran_list..ac.com)
Date: Mon Jul 13 2009 - 11:30:45 EDT

  • Next message: Hugi Thordarson: "Generating SQL in EntityModeler loads framework Principal class?"

    Thanks guys. Actually it is not so important for mig0 anyway since
    that is usually development. Index additions are usually for
    perfomance later when some tables get large or some fetches are slower
    than desired.

    I thought of an idea though that might be really useful ......
    (probably Mike has already thought of this) .......

    During initial pre-initial-release development, it is common to add/
    change the EOModel frequently, especially when you are against the
    clock using David Leber's Pomodoro slave driver technique ( ;-) ). I
    think it would be really cool to have a generation gap pattern similar
    to the way EOGen generates the _Entity.java files when a model
    changes. Having eogen or sth similar trigger the creation of
    theabstract _MyEOModelMigration0.java simply containing the single
    method:

    public void upgrade(EOEditingContext editingContext,
    ERXMigrationDatabase database) throws Throwable {
            ......
    }

    Wouldn't that be cool? :-)

    -Kieran

    On Jul 13, 2009, at 11:10 AM, Chuck Hill wrote:

    > I think the support for generating the SQL is not yet completely
    > implemented e in EOF. Some plugin work is likely needed to make
    > this go.
    >
    > Chuck
    >
    >
    > On Jul 13, 2009, at 8:04 AM, Mike Schrag wrote:
    >
    >> 5.4 models support the declaration of indexes in the model .. at
    >> the moment, the mig0 generator doesn't read that (though i think it
    >> should be really easy to do -- just never did it)
    >>
    >> On Jul 13, 2009, at 10:49 AM, Kieran Kelleher wrote:
    >>
    >>> Hi all,
    >>>
    >>> I know I can manually write ERXMigration code to add index to a
    >>> column, but is there a way to define an index in the eomodel
    >>> itself so that the "Generate Migration 0" creates that code for
    >>> me? I searched Google and wiki and ERXMigration docs, but cannot
    >>> find any clues ....
    >>>
    >>> -Kieran
    >>>
    >>> (MySQL BTW)
    >>
    >>
    >>
    >
    > --
    > Chuck Hill Senior Consultant / VP Development
    >
    > Learn WO at WOWODC'09 East in Montréal this August!
    > http://www.wocommunity.org/wowodc09/east
    >
    > http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars
    >

    This archive was generated by hypermail 2.0.0 : Mon Jul 13 2009 - 11:31:32 EDT