...
| Info |
|---|
$Database.ExportToXml, and ,$Database.ImportFromXml, methods requires a unique primary key field on database table and data model. |
Map Function
Map function is used to transform values before saving. For example; encrypting a password before saving to database. See $Database.ImportFromXml for more details.
...
| Code Block | ||
|---|---|---|
| ||
$Database.ExportToXml({
TargetSchema : 'MySchema',
TargetTable : 'Accounts',
XPath : 'Accounts/Account',
// map values whose names are not identical to SQL column names
Map : function (accountXml) {
thisaccountXml.SetValue('Password = 'Enc:' +', this.Password);
// mark as encrypted this.AccountType = accountXml.EvaluateaccountXml.SetValue('Type/Code', this.AccountType);
// map values whose names are not identical to SQL column names
}
}); |
Example
Exporting database content into XML
...
| Code Block | ||
|---|---|---|
| ||
// Export corporations with the subcorporations Database$Database.ExportToXml({ Parameters : { TargetSchema : 'Evrak', TargetTable : 'Kurum' }, XPath : 'Corporations/Corporation', SubQueries : [ {Name : 'SubCorporations'} ] }); |
| Info |
|---|
Assume you have two SQL tables Corporations and SubCorporations and a One-To-Many relation from Corporations table to SubCorporations table which is also named SubCorporations. Also don't forget to set this relation's update rule to "Cascade". Having defined the table columns with identical names to the XML fields, this code lets you export each corporation from SQL table into XML fields, exporting also its related SubCorporations into the SubCorporations XML nodes and resulting in the following XML data. |
Example
Exported XML Data
| Code Block | ||
|---|---|---|
| ||
<GeneralDefinitions>
<Corporations>
<Corporation>
<Id>9b7383a3-67ae-4fed-a135-1f981b165c43</Id>
<Name>Corporation A</Name>
<ShortName>CorpA</ShortName>
<SubCorporations>
<SubCorporation>
<Id>309069b4-4274-4063-b7ad-75c5657d7474</Id>
<Name>SubCorporation A 1</Name>
<ShortName>SubCorpA1</ShortName>
</SubCorporation>
<SubCorporation>
<Id>6ba3cc79-9ff7-4232-8f61-9245a38fd2bb</Id>
<Name>SubCorporation A 2</Name>
<ShortName>SubCorpA2</ShortName>
</SubCorporation>
</SubCorporations>
</Corporation>
<Corporation>
<Id>5a900112-a869-41cf-931c-7379c1df518e</Id>
<Name>Corporation B</Name>
<ShortName>CorpB</ShortName>
<SubCorporations>
<SubCorporation>
<Id>8e7ca6d2-5629-4f87-82ed-73c72cfb171e</Id>
<Name>SubCorporation B 1</Name>
<ShortName>SubCorpB1</ShortName>
</SubCorporation>
<SubCorporation>
<Id>7c5f330e-68d8-45f0-800e-04e2f7e035e0</Id>
<Name>SubCorporation B 2</Name>
<ShortName>SubCorpB2</ShortName>
</SubCorporation>
</SubCorporations>
</Corporation>
</Corporations>
</GeneralDefinitions> |
...