Book a Demo

Author Topic: create table from class definition  (Read 3305 times)

siochain

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
create table from class definition
« on: December 07, 2006, 03:52:57 am »
having created my classes I now want to create tables/views which have a one to one relationship with the class attributes. I have exported the class and could manually change the XML attributes to become tables and columns but this will take weeks. I have looked at transformations but cannot see an example of transorming a class into a table.
Any ideas?

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: create table from class definition
« Reply #1 on: December 07, 2006, 05:06:40 am »
Search the forum for hints, although I don't think you will find the code itself.

Take a look at the EA Resources on the Sparx site as well.

Look through the EA Users Group and Wiki sites. You'll find the address of the former in the top thread of the Automation section of the forum. Search for Wiki in Automation if you don't find that address. [EDIT: The address for the Wiki is in the signature block of the first message of the first thread in the Automation group.]
« Last Edit: December 07, 2006, 05:09:42 am by Midnight »
No, you can't have it!

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: create table from class definition
« Reply #2 on: December 07, 2006, 01:02:13 pm »
Quote
I have looked at transformations but cannot see an example of transorming a class into a table.

Try looking at the built in DDL transform, including the documentation for it (http://www.sparxsystems.com/EAUserGuide/index.html?ddltransformation.htm)

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: create table from class definition
« Reply #3 on: December 07, 2006, 03:03:25 pm »
Thanks Simon, I just could not remember which one it was.
No, you can't have it!

siochain

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: create table from class definition
« Reply #4 on: December 08, 2006, 06:15:34 am »
Thanks - just spent a day writing an awk script to do it.
I suspected this was the wrong way.
Now one click and it is done
Thank you very much
Siochain