Using god's gift to SQL, the information_schema structure, we execute this:

get_cnames = "select column_name from fsdbdata.information_schema.columns where table_name like '" + table_name + "' and column_name not like 'dbcode' and column_name not like 'stcode' and column_name not like 'entity' and column_name not like 'format' and column_name not like '%method' and column_name not like 'event_code' and column_name not like '%level' and column_name not like 'sitecode' and column_name not like 'height' and column_name not like '%depth' and column_name not like 'max%' and column_name not like 'min%' and column_name not like '%max%' and column_name not like '%min%' and column_name not like '%stddev'"

that's right, it's all the column names you'll ever need to do all the harmonization and aggregation. Subsequently, we "try" all of the four methods of combining Probe, Probe_code, Date, and Date_Time to get the appropriate information, like this:

sql = "select " + cnames_to_list + " from fsdbdata.dbo." + table_name + " where date >= '" + startdate + "' and date <= '" + enddate +"' and probe like '" + probe_code +"' order by date asc"

This information is returned so that Glitching may occur.

The glitch interface is a simple set of accordion menus that look into the database and find the appropriate tables and probes.

alt

Entry portal

width

300

height

300

align

center

You can see here how we drop down from MS001 to get a list of tables:

alt

Accordion

width

300

height

300

align

center

And how our clicked on table is automatically used to populate the form. Fill in the date and time range you want as YYYY-mm-dd HH:MM:SS.

alt

Form is populated

width

300

height

300

align

center

Click Submit Me at the bottom to submit the form and advance to the list of probes. Your submission went through if the button turns red.

alt

Probe form.

width

300

height

300

align

center

You can also choose a probe, and now your probe will populate the form.

alt

Probe form selection.

width

300

height

300

align

center

Type in a number of minutes that you want to GLITCH for. If you get a 500 error on the next page, you probably made a selection that was "out of range". I have not built in range checks. However, the server is persistent, so you can always go back and try again.

Click Submit Me at the bottom to submit the form and advance to the list of probes. Your submission went through if the button turns red.

alt

some interval here.

width

300

height

300

align

center

Finally your data is returned as a nice looking comma separated html list.

alt

some interval here.

width

300

height

300

align

center

If you want to take shortcuts:

• you can use the tag /data/... to use the old [GET] syntax from the cold fusion / perl program - your url would be /data/dbcode=MS04311&entity=02 etc.

• you can use the tage /accordion to load the main page. This is right now how you access on localhost:8080/accordion