das library! ... but I haven't looked into das a lot so I don't know what
the api is or what the user is trying to do here!!
DAS framework must be configured before usage, it can be done via code or
via xml. Anyway, the DAS needs to read the xml config file to set up the
framework. I'm trying to use SDO feature that loads data from xml to
retrieve the config info from xml file. The problem is if the DAS to
depend
on a xsd file to generate the sdo graph structure every time it is
executed,
so the user will need both, the xsd file and das_runtime.lib :s
Adriano Crestani
On 6/5/07, Pete Robbins <[EMAIL PROTECTED]> wrote:
>
> On 05/06/07, Adriano Crestani <[EMAIL PROTECTED]> wrote:
> >
> > Hi Pete,
> >
> > Well, I didn't know about DataFactory << operator, but I did it
> manually,
> > LoL, and it looked like the same when I define using xsd and manually.
>
>
> Defining via a schema will have created a Type DAS_NAMESPACE#RootType
and
> properties will have been added to this for e.g. Config from the
> <xsd:element name="Config" type="config:Config"/>. Your manual version
> does
> not do this.
>
> The reason to avoid using xsd definition is that the das user would need
> the
> > das_runtime.lib and also config.xsd, however it is not a good practice
> for
> > a
> > library.
>
>
> I don't quite understand that... I would assume a das user would need
the
> das library! ... but I haven't looked into das a lot so I don't know
what
> the api is or what the user is trying to do here!!
>
> I debugged the sdo and look like it defines a DASValue when load using
xsd
> > and also sets the rootElementName on DataFactoryImpl. When I define
> > manually
> > I set only the rootElementName, but not the DASValue. I think when the
> > XMLHelper reads the xml it uses this DASValue object set when the xsd
is
> > loaded, and that is why I'm saying the xml load NEEDS xsd definition.
>
>
> The DASValue is a way of appending the schema information to the Types
and
> Properties. This should not be necessary in your case but is again a
> reason
> to use schema.
>
> I will need to look into the SDO code to see what the rootElementName
is.
> I'm not sure what it does but I AM 100% sure you shouldn't set it from a
> client. You should not need to use any API on DataFactoryImpl (or
> any.....Impl class). The user API is defined in DataFactory.h
>
>
> Above the both methods, manually and using xsd, now complete:
> >
> > Manually:
> > commonj::sdo::DataFactoryPtr dataFactory =
> > commonj::sdo::DataFactory::getDataFactory();
> > ((commonj::sdo::DataFactoryImpl&)
> > *dataFactory).setRootElementName("Config");
> > dataFactory->addType(DAS_NAMESPACE, "Table");
> > dataFactory->addType(DAS_NAMESPACE, "Relationship");
> > dataFactory->addType(DAS_NAMESPACE, "KeyPair");
> > dataFactory->addType(DAS_NAMESPACE, "Column");
> > dataFactory->addType(DAS_NAMESPACE, "Config");
> >
> > const commonj::sdo::Type& table =
dataFactory->getType(DAS_NAMESPACE,
> > "Table");
> > const commonj::sdo::Type& relationship =
> > dataFactory->getType(DAS_NAMESPACE, "Relationship");
> > const commonj::sdo::Type& keyPair =
> dataFactory->getType(DAS_NAMESPACE,
> > "KeyPair");
> > const commonj::sdo::Type& column =
> dataFactory->getType(DAS_NAMESPACE,
> > "Column");
> > const commonj::sdo::Type& config =
> dataFactory->getType(DAS_NAMESPACE,
> > "Config");
> >
> > dataFactory->addPropertyToType(table, "Column", column, true,
false,
> > true);
> > dataFactory->addPropertyToType(table, "tableName", SDO_NAMESPACE,
> > "String", false, false, true);
> > dataFactory->addPropertyToType(table, "typeName", SDO_NAMESPACE,
> > "String", false, false, true);
> >
> > dataFactory->addPropertyToType(config, "Table", table, true, false,
> > true);
> > dataFactory->addPropertyToType(config, "Relationship",
relationship,
> > true, false, true);
> > dataFactory->addPropertyToType(config, "uri", SDO_NAMESPACE,
> "String",
> > false, false, true);
> >
> > dataFactory->addPropertyToType(relationship, "KeyPair", keyPair,
> true,
> > false, true);
> > dataFactory->addPropertyToType(relationship, "name", SDO_NAMESPACE,
> > "String", false, false, true);
> > dataFactory->addPropertyToType(relationship, "primaryKeyTable",
> > SDO_NAMESPACE, "String", false, false, true);
> > dataFactory->addPropertyToType(relationship, "foreignKeyTable",
> > SDO_NAMESPACE, "String", false, false, true);
> > dataFactory->addPropertyToType(relationship, "many", SDO_NAMESPACE,
> > "Boolean", false, false, true);
> > dataFactory->setDefault(relationship, "many", true);
> >
> > dataFactory->addPropertyToType(keyPair, "primaryKeyColumn",
> > SDO_NAMESPACE, "String", false, false, true);
> > dataFactory->addPropertyToType(keyPair, "foreignKeyColumn",
> > SDO_NAMESPACE, "String", false, false, true);
> >
> > dataFactory->addPropertyToType(column, "columnName", SDO_NAMESPACE,
> > "String", false, false, true);
> > dataFactory->addPropertyToType(column, "sqlType", SDO_NAMESPACE,
> > "String", false, false, true);
> > dataFactory->addPropertyToType(column, "propertyName",
SDO_NAMESPACE,
> > "String", false, false, true);
> > dataFactory->addPropertyToType(column, "primaryKey", SDO_NAMESPACE,
> > "Boolean", false, false, true);
> > dataFactory->setDefault(column, "primaryKey", false);
> >
> > dataFactory->resolve();
> >
> > commonj::sdo::XMLHelperPtr xmlh =
> > commonj::sdo::HelperProvider::getXMLHelper(dataFactory);
> > commonj::sdo::XMLDocumentPtr doc = xmlh->loadFile(xmlFile.c_str(),
> > DAS_NAMESPACE);
> > commonj::sdo::DataObjectPtr root = doc->getRootDataObject();
> >
> > Using xsd:
> >
> > commonj::sdo::DataFactoryPtr dataFactory =
> > commonj::sdo::DataFactory::getDataFactory();
> > commonj::sdo::XSDHelperPtr xsdh =
> > commonj::sdo::HelperProvider::getXSDHelper(dataFactory);
> > xsdh->defineFile("config.xsd");
> >
> > commonj::sdo::XMLHelperPtr xmlh =
> > commonj::sdo::HelperProvider::getXMLHelper(dataFactory);
> > commonj::sdo::XMLDocumentPtr doc = xmlh->loadFile(xmlFile.c_str());
> > commonj::sdo::DataObjectPtr root = doc->getRootDataObject();
> >
> > config.xsd:
> >
> > <xsd:schema
> > xmlns:config="http:///org.apache.tuscany.das.rdb/config.xsd";
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> > targetNamespace="http:///org.apache.tuscany.das.rdb/config.xsd";
> > elementFormDefault="qualified">
> >
> > <xsd:element name="Config" type="config:Config"/>
> >
> > <xsd:complexType name="Config">
> > <xsd:all>
> > <xsd:element maxOccurs="unbounded" minOccurs="0" name="Table"
> > type="config:Table"/>
> > <xsd:element maxOccurs="unbounded" minOccurs="0"
> > name="Relationship"
> > type="config:Relationship"/>
> > </xsd:all>
> > <xsd:attribute name="uri" type="xsd:string"/>
> > </xsd:complexType>
> >
> > <xsd:complexType name="Relationship">
> > <xsd:all>
> > <xsd:element maxOccurs="unbounded" minOccurs="1"
name="KeyPair"
> > type="config:KeyPair"/>
> > </xsd:all>
> > <xsd:attribute name="name" type="xsd:string"/>
> > <xsd:attribute name="primaryKeyTable" type="xsd:string"
> > use="required"/>
> > <xsd:attribute name="foreignKeyTable" type="xsd:string"
> > use="required"/>
> > <xsd:attribute name="many" type="xsd:boolean" default="true"/>
> > </xsd:complexType>
> >
> > <xsd:complexType name="Table">
> > <xsd:all>
> > <xsd:element maxOccurs="unbounded" minOccurs="0" name="Column"
> > type="config:Column"/>
> > </xsd:all>
> > <xsd:attribute name="tableName" type="xsd:string"
use="required"/>
> > <xsd:attribute name="typeName" type="xsd:string"/>
> > </xsd:complexType>
> >
> > <xsd:complexType name="KeyPair">
> > <xsd:attribute name="primaryKeyColumn" type="xsd:string"
> > use="required"/>
> > <xsd:attribute name="foreignKeyColumn" type="xsd:string"
> > use="required"/>
> > </xsd:complexType>
> >
> > <xsd:complexType name="Column">
> > <xsd:attribute name="columnName" type="xsd:string"
use="required"/>
> > <xsd:attribute name="sqlType" type="xsd:string" use="required"/>
> > <xsd:attribute name="propertyName" type="xsd:string"/>
> > <xsd:attribute name="primaryKey" type="xsd:boolean"
> default="false"/>
> > </xsd:complexType>
> >
> > </xsd:schema>
> >
> > config.xml:
> >
> > <Config xmlns="http:///org.apache.tuscany.das.rdb/config.xsd";>
> >
> > <Table tableName="department">
> > <Column sqlType="integer" columnName="id" primaryKey="true"/>
> > <Column sqlType="varchar" columnName="name" primaryKey="true"/>
> > </Table>
> >
> > <Relationship primaryKeyTable="department"
foreignKeyTable="employee"
> > many="true">
> > <KeyPair primaryKeyColumn="id"
> foreignKeyColumn="department_id"/>
> > <KeyPair primaryKeyColumn="name"
> > foreignKeyColumn="department_name"/>
> > </Relationship>
> >
> > </Config>
> >
> > Thanks,
> > Adriano Crestani
> >
> > On 6/5/07, Pete Robbins <[EMAIL PROTECTED] > wrote:
> > >
> > > You should be able to define the Types and Properties manually if
you
> > want
> > >
> > > to. I would ask WHY you want to do this as using a schema is a lot
> > > simpler!
> > >
> > > Could you post your config.xsd and config.xml?
> > >
> > > If you add a line
> > >
> > > cout << dataFactory << endl;
> > >
> > > That should print the Types and Properties you have defined and you
> can
> > > compare that to the Types/Properties defined by loading the schema.
> > >
> > > Cheers,
> > >
> > >
> > >
> > > On 04/06/07, Adriano Crestani <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Is there a way to load data from a XML file without a XML schema
> file,
> > > > only
> > > > defining the graph type and properties manually on code?
> > > >
> > > > The code bellow works:
> > > >
> > > > DataFactoryPtr dataFactory = DataFactory::getDataFactory();
> > > > XSDHelperPtr xsdh = HelperProvider::getXSDHelper(dataFactory);
> > > > xsdh->defineFile("config.xsd");
> > > >
> > > > XMLHelperPtr xmlh = HelperProvider::getXMLHelper(dataFactory);
> > > > XMLDocumentPtr doc = xmlh->loadFile(" config.xml");
> > > > DataObjectPtr root = doc->getRootDataObject();
> > > >
> > > > But when I defining manually the graph struct it does not:
> > > >
> > > > DataFactoryPtr dataFactory = DataFactory::getDataFactory();
> > > > dataFactory->addType(DAS_NAMESPACE, "Table");
> > > > const Type& table = dataFactory->getType(DAS_NAMESPACE, "Table");
> > > > dataFactory->addPropertyToType(table, "tableName", SDO_NAMESPACE,
> > > > "String",
> > > > false, false, true);
> > > > dataFactory->addPropertyToType(table, "typeName", SDO_NAMESPACE,
> > > "String",
> > > > false, false, true);
> > > >
> > > > dataFactory->resolve();
> > >
> > >
> > > This method is not intended to be called by a client. I don't think
it
> > > should even be on the DataFactory interface.
> > >
> > > XMLHelperPtr xmlh = HelperProvider::getXMLHelper(dataFactory);
> > > > XMLDocumentPtr doc = xmlh->loadFile(" config.xml", DAS_NAMESPACE);
> > > > DataObjectPtr root = doc->getRootDataObject(); // the root data
> object
> > > > returned is NULL
> > > >
> > > > Adriano Crestani
> > > >
> > >
> > > Cheers,
> > >
> > > --
> > > Pete
> > >
> >
>
> This may be a bug in the SDOSAX2Parser. I'll try and look into it later
> today. When loading the xml the top level element (<Config> in this
case)
> should be a property on the RootType (which is undefined in your manual
> case). I'll need to check the rules for loading xml without a schema in
> the
> spec, I know there are some other issues in this area.
>
> If the user of DAS needs to load xml against a DAS schema I'm sure they
> won't want to do all that defineType stuff so I'm still not sure what
the
> purpose of this is. If DAS owns the schema then it should be loading it
> and,
> if necessary, providing an API to return an XMLHelper that can load the
> users config file??
>
> Cheers,
>
> --
> Pete
>
