One of the original philosophies of this project is to gather and manipulate data from a database, without having to touch the underlying database. With the query in the top right panel we are going to generate a base table definition to expand upon later in this lab.
Goal:
Generate a base table definition file from an SQL query.
Steps to complete:
- Create the folder 'ATSLab' in the '/var/www/tableDefinitions' folder by:
- Opening a terminal
- Running the following command:
- 'sudo mkdir /var/www/tableDefinitions/ATSLab'
- Setting the file permissions with the following command:
- 'sudo chmod 755 /var/www/tableDefinitions/ATSLab'
- Run the query. You should see a result set appear after the query has been run.
- View the table definition XML for this query by clicking on 'Generate table definition XML' in the upper right corner of the result set. This will open a new tab to the right of this text in which the XML will be displayed
- Save the table definition by right-clicking in the XML document and then selecting 'This Frame' -> 'Save Frame As...'
- Save the file as 'atsBaseView.xml' in the folder '/var/www/tableDefinitions/ATSLab'