The Database
Author: Martin Robinson
The data that the import application will import is stored in database from a homegrown CMS application. In this case, the database is structured with two tables, one containing web pages and another containing quotes. Each entry in the web_pages table consists of a block of HTML content, a path, and some miscellaneous metadata. The script will import the old pages into an existing template in the system, while preserving the metadata and path. This will require a folder structure to hold the pages. The script will take care of this step as well. The quotes table contains unformatted quotes with an entry for the type of quote, the source of the quote and the quote body itself. The script will pull this data from the database and create a page using a data definition for quotes.
| id | title | path | keywords | content | metaDesc |
|---|---|---|---|---|---|
| 1 | Company Overview | /company/index.html | Our Company, Service providers, global business, e-economy solutions | <p>Within five years we have seen <i>global... | A quick overview of our company |
| 2 | Mission Statement | /company/statement.html | Our Company, Service providers, global business, mission | <p>When our company started... | The statement of our mission |
| 3 | ProductOne Overview | /products/product1.html | Our Company, Service providers, global business, ProductOne | <p>Advancements in research through... | Overview of the features of ProductOne |
| . . . | |||||
| id | type | source | body |
|---|---|---|---|
| 1 | Training | Francois de La Rochefoucauld | Good advice is something a man gives when... |
| 2 | Global | Jim Cantalupo | And ours is a business that requires discipline and focus. |
| . . . | |||