主权项 |
1. A method for use in transferring content between a database and a file, the database including database fields having a respective database field type, and the file including file fields having a respective file field type, the method including extracting content from the database by:
a) Determining data relating database fields to corresponding file fields, the data being a mapping determined in accordance with the content to be extracted from the database; b) Creating a data store including store fields having required store field types by:
i) transferring a next query to the database;ii) receiving at least one report from the database;iii) determining a number of content instances in the at least one report; and,iv) creating store fields in the data store in accordance with a number of content instances in the at least one report; c) Transferring at least one content instance between a database field and a file field, via the data store, in accordance with the data, by:
i) retrieving a content instance for a parent node from a database field of the database;ii) storing the content instance in a store field of the data store in accordance with the database field type of the database field and the mapping;iii) retrieving a content instance for a child node of the parent node from a database field of the database; and,iv) storing the content instance in a store field in the data store in accordance with the database field type of the associated database field and the mapping; and, d) transferring the at least one content instance to the database from the data store. |