Example of spectroscopic node

Materials

This example uses some data from Chianti: a few records from each table. The data are provided in ASCII tables. To read them into the database, I include mapping files for the VAMDC publishing software, which is the approved way of loading the database.

• Line data

• Species and state data

• Mapping file for VAMDC publishing software

The mapping generates files states.out and lines.out which supply the tables states and transitions [1] respectively. The third table, species, is derived from the states table by an SQL command. The SQL script schema.sql creates the empty tables [2] and ingest.sql fills them.

• Schema-creation script

• Ingestion script

The Python files modelling the node are adapted from the Chianti node running in the 12.07 system and therefore need that edition of the node software. When you have that tree of software installed on the demonstration machine, you should copy these Python files from this page into the directory NodeSoftware/nodes/tignanello/node/ [3].

• models.py

• dictionaries.py

• queryfunc.py

You then need to edit NodeSoftware/nodes/tignanello/settings.py to get a runnable node. I’ve included on this page a settings.py that should work if your RDBMS is MySQL, set up according to the infrastructure checklist elsewhere in this tutorial package.

• settings.py

Recommended order of demonstration

This is an outline. Follow the node-software user-guide for the details. You will need to run through this sequence before the tutorial to make sure that you understand all the details and can avoid the traps.

1. Create the tignanello database and assign access to the vamdc user. Leave the database empty for now.

2. Copy in the settings.py file so that Django can see the database.

3. Copy in the models.py file and let Django create the (empty) database tables from the models. Show the audience what Django has made. [4]

4. Show the mapping file of the publishing software to the audience and explain how what it does.

5. Run the publishing software, load the database and show the audience what was loaded.

6. Explain that the node software now knows the structure of the database but not how it maps to VSS2 or XSAMS. [5]

7. Copy in the dictionaries.py file [6], explain what it means, and demonstrate that the node now understands queries. [7]

8. Show the node’s capabilities document and explain how this links the node to the registry. [8]

9. Show how to test the node in the TAP validator.

10. Optionally, show how to enable the node software in a production-quality web-server.

Footnotes

[1]

Naming this table “lines” interacts badly with the SQL command-line, therefore it is called “transitions”.

[2]

It should be possible to ignore schema.sql and to let Django create the empty database from the Python model. The second script, ingest.sql, should be able to write to tables generated in that way.

[3]

This is a new node created for this demonstration. The existing node chianti in the node-software tree should not be used for the demonstration. It is sufficiently different from the example node that it would cause confusion. The files for the tignanello node should be present in the node-software tree when it is checked out from GitHub.

[4]

You can show Django’s view of things from the Python command-line; the node software documentation has the spells. You can show MySQL’s view of the database using the mysql command-line tool.

[5]

You could emphasise this by running valid queries, all of which will come back with 400 status because the node doesn’t understand any restrictables.

[6]

For a really effective demonstration, if you have time, consider loading first a stripped down copy of dictionaries.py and then progressively adding restrictable and returnable while showing the audience how the node’s capabilities grow. If the students are installing the example node for themselves, then they should certainly do this exercise.

[7]

A suitable query is select all where AtomSymbol=’O’. You could also select a range of wavelength.

[8]

You could actually register the demonstration node, but please only the development registry, not the production registry! If you do this, please mark the registration “deleted” at the end of the demonstration.