convert table to class

[univero]

Hi everyone,

how can i transform a table (imported via schema and odbc) into a class?

Bye
univero

[«Midnight»]

You probably need to look at Transformations. Start in the EA help file, then check the Resources page on the Sparx site.

AFAIK there is not a built-in transformation from data models to classes, although the reverse is available. So...

Once you've got the general idea check the EA Wiki and User Group. You can find the addresses by reading the first post of the top thread in the Automation section of this forum. There may be some template samples you can use to start you off.

David

[thomaskilian]

David is right: there is no transformation. The simple reason is that from a shadow (the table) you hardly can build the 3D projection frame (the class). You could write a transformation which creates a 1 to 1 class representation and then you have to do some manual afterwork. This is quite simple: use the Cxx transformation to create a "duplication" transformation. This will take you approx. 1 day when starting from scratch (at least I needed that time once).

[univero]

Hi,

thanks for your answers. Transformation was the information I was looking for..

And now there comes another question. Is it possible to do the transformation and get in the class the correct javax.persistence or hibernate annotations?

Greetings
Christian

[thomaskilian]

Perhaps you should read my post.

[univero]

Hi Thomas,
i did read your mail.

But in our ea installation there is the possiblity to do a transformation between a table and a java class without writing my "own" transformation template.

So I thought that there was somewhere a similar transformation for hibernate/persistance. Perhaps an already defined template or something like that, which can be imported easily.

If there isn't something like that, I will write my own template.

David is right: there is no transformation. The simple reason is that from a shadow (the table) you hardly can build the 3D projection frame (the class). You could write a transformation which creates a 1 to 1 class representation and then you have to do some manual afterwork. This is quite simple: use the Cxx transformation to create a "duplication" transformation. This will take you approx. 1 day when starting from scratch (at least I needed that time once).

[thomaskilian]

I guess you mean the EJB Session and Entity transformation plus the DDL transformation. These go all from more abstract to more concrete things, not vice versa. You probably need to take the steps I described.