Added support to one to many relationship under revision 542742
Adriano Crestani On 5/28/07, Adriano Crestani <[EMAIL PROTECTED]> wrote:
Added support to set up the framework via config xml under revision 542124. Adriano Crestani On 5/22/07, haleh mahbod < [EMAIL PROTECTED]> wrote: > > Thank you for the explanation. > > On 5/21/07, Adriano Crestani < [EMAIL PROTECTED]> wrote: > > > > Yes, it's intergrated with Tuscany SDO C++. > > > > Next step is to implement a sample for it. > > > > I intend to add some info on wiki before the first release. > > > > Regards, > > Adriano Crestani > > > > On 5/21/07, haleh mahbod <[EMAIL PROTECTED]> wrote: > > > > > > Hi Adriano, > > > > > > Is this integrated with SDO C++? Is there a sample for it? > > > Can more information be added to the home page and user guide[1]? > > > > > > > > > [1] > > http://cwiki.apache.org/confluence/pages/viewpage.action?pageId=46512 > > > > > > Haleh > > > > > > On 5/20/07, Adriano Crestani <[EMAIL PROTECTED]> wrote: > > > > > > > > Actually is being developed the Tuscany DAS C++. So far, the > framework > > > can > > > > perform the following: > > > > > > > > - Convetion Over Configuration(COC): > > > > > > > > - DAS assumes that a column named xxx_id is a FK to the column > > named > > > > id on table xxx. > > > > - If no PK column is found on the ResultSet, it sets the column > > named > > > > id as PK, if exists. > > > > - The COCs defined above are, actually, case sensitive and, for > > > > > example, a column named ID will not be set as PK > > > > > > > > > > > > - The das is using the ResultSet metadata(column name, column data > > type > > > > and > > > > column table) to generate the sdo graph and popule it. The DAS > > > guarantees > > > > the table object uniqueness on graph basing on the table PK, so > the > > > first > > > > table retrieved by the ResultSet will be taken, and any other > table > > > > containing the same PK ignored: > > > > > > > > > > > > - A table may contain a simple PK or a composite one. > > > > - If no PK is defined for the table, the DAS tries to find one > > using > > > > COC. > > > > - If the table has a composite PK and not all the columns that > > > > compound the PK are contained on the ResultSet, the DAS ignores > the > > > > defined > > > > composite PK and tries to find another PK using COC as defined > > above. > > > > - If no PK is found using COC, the DAS sets all columns on > > ResultSet > > > > as PK. > > > > > > > > - Setting the references on graph objects basing on table > > relationships. > > > > > > > > - Actually, there may be up to 1 relationship between 2 tables. > > > > - The columns data that compound the FK are not created on the > > graph. > > > > - The DAS accepts simple or composite relationships. > > > > - If not all the columns, PK or FK, that compound the > relationship > > > are > > > > on the ResultSet, the relationship is ignored and the remaining > FK > > > are > > > > loaded onto graph. > > > > > > > > - Actually, the DAS config can only be set from code. > > > > > > > > - There are also implemented some testcases. > > > > > > > > - DAS is only supporting the following SQL types: INTEGER, REAL, > CHAR, > > > > VARCHAR, FLOAT, DOUBLE. > > > > > > > > Next steps: > > > > > > > > - Read the config from a xml file. > > > > > > > > - To implement a sample that reads some data from a database and > print > > > on > > > > console. > > > > > > > > - Implement support for more SQL types. > > > > > > > > > > > > Comments and suggestions will be appreciated : ) > > > > > > > > Any volunteer would be helpful ; ) > > > > > > > > > > > > Regards, > > > > > > > > Adriano Crestani > > > > > > > > > >