Using the database

The "parsedb" program provides access to the database from the command line. Basic usage is as follows:

• > parsedb -select Filename,beconfig,mjd -source J1939+2134,J2145-0750 -mjd1 53000 -mjd2 53500 -freq1 1200 -freq2 1500

prints filenames, configurations and mjds for all observations in the database for PSRs J1939+2134 or J2145-0750 which have mjds between 53000 and 53500 and frequencies between 1200 MHz and 1500 MHz.

• > parsedb -select Filename,cal,fluxcal

prints out a list of observation filenames and the calibrator files that were used to calibrate the observation.

• > parsedb -select obs,inter -itype czrf

prints out the path and filenames of the raw files and the intermediate files of type "czrf". NB If you use the '-itype' flag you must '-select inter'.

Options

• -backend selects specified backend(s)
• -count lists the linenumber when printing output
• -distinct only output distinct results
• -flagged c selects only files that have been flagged. 'c' can equal 't' for any flagged file or a number corresponding to the flag ID.
• -freq1 f define the minimum frequency
• -freq2 f define the maximum frequency
• -h provides a link to this website
• -help prints the MYSQL command at the top of the output
• -highlight1 defines what text string to highlight
• -highlight2 c s defines what to highlight (string 's' in column 'c')
• -itype defines which intermediate file type to display
• -mjd1 defines the earliest mjd for selecting files
• -mjd2 defines the latest mjd for selecting files
• -proc y/n selects files which have been processed or not
• -select defines which parameters to output
• -sort defines which parameter to sort on
• -source selects specified source(s)
• -where defines which files to select

Common parameters

The 'select' option allows you to select any parameter in the database. The most common parameters are: Filename, Backend, BW, NChan, NBin, Source and Tsub.