The ORM Foundation

Get the facts!

Talent Agency - CQL

Last post Thu, Oct 29 2009 23:05 by Anonymous. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • Thu, Oct 29 2009 7:51

    • Ken Evans
    • Top 10 Contributor
    • Joined on Sun, Nov 18 2007
    • Stickford, UK
    • Posts 789

    Talent Agency - CQL

    ***'s conversion of Tyler's "Talent Agency" model is a good example of what can be done with an ORM file.   

    However, I'm left wondering how to correctly read the file?
    When I downloaded ***'s CQL file of Tyler's "Talent Agency", the file opened in notepad by default! (quite a mess)
    When I opened it in Word, I saw a list of XML like statements. (much more helpful)

    So right now I have two questions:
    1: What editor should I use to open the file?
    2: How would I use the file? (i.e. in what part of the development process?)

    ***, can you help here?



  • Thu, Oct 29 2009 23:05 In reply to

    Re: Talent Agency - CQL

    Ken Evans:
    the file opened in notepad by default! (quite a mess)

    The file is plain text, with Unix style line endings (just newline, not carriage-return/line feed). I can update it, or you can use Wordpad. Right-click "Open with...", select wordpad, and say "always open...". Or choose any other plain-text or programmers editor that isn't as broken as Notepad Wink.

    Ken Evans:
    How would I use the file? (i.e. in what part of the development process?)

    The ActiveFacts toolkit is available for installation, using the instructions on my website. It includes the ActiveFacts generator program afgen, which can be used to convert either a CQL or an ORM file into SQL (MySQL or MSSQL), CQL, Ruby code, and any other language for which a small output adapter can be written (the SQL adapters are 200 lines of code each, the Ruby one is 140; these are not difficult things to write). In other words, you can use it exactly as you would use NORMA, but without needing Visual Studio.

    I use CQL for modeling, and with clients even during initial interviews, for preference over NORMA and ORM2. The clients can read it directly and readily understand and participate in the modeling exercise. Later, when the generated code is being used to develop an application, any team member (or the client) can formulate changes, and these changes are easy to communicate by email without any special tools being needed to create or view them, and integrated into the current version easily. Consider the difficulty of accurately merging more than one set of changes to a base NORMA model - almost imposisble to be sure you've done it correctly! In the same way, source code control and revision management systems can automatically merge and detect conflicts, which is still impossible with NORMA.

    In short, I find CQL preferable in many ways to the ORM2 graphical notation.


Page 1 of 1 (2 items)
© 2008-2019 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service