*** WORK IN PROGRESS ***<\/p>\n
Index:<\/strong><\/p>\n Note:<\/strong> We assume that you have created a working directory, e.g. mpe2018<\/tt>, in your $HOME<\/tt><\/p>\n and downloaded (or will download when requested) the course files with a directory structure like this: For convenience, the tar file soft_dirs.tar.gz<\/tt> contains the whole Soft<\/tt> tree structure. To download the whole Data<\/tt> directory, see the instructions in the reference page<\/a>.<\/p><\/blockquote>\n Some of these files will be overwritten during the course, so verify your local version matches that on the website.<\/p>\n Commands are to be executed in a terminal either at the shell prompt or the MySQL prompt. When there could be ambiguity, the shell><\/tt> or mysql><\/tt> prompt is shown explicitly.<\/p>\n Examples:<\/p>\n And this is the content of csc_query.sql<\/strong>:<\/p>\n You can substitute the previous query for example with this and rerun:<\/p>\n Note how we used vot<\/tt> for the output file. This refers to the VOTable<\/strong> format. It will be used transparently in some examples, but if you want to know about it, have a look to the reference document<\/a>. <\/p>\n You need to install the MySQLdb<\/tt> package (but other options exist). E.g. on Linux Debian\/Ubuntu:<\/p>\n See the demo page<\/a>.<\/p>\n To communicate with the database we use the MySQLi<\/tt> Extension. Please see the demo programs source code and refer to the mysli manual pages<\/a>.<\/p>\n See the demo page<\/a>.<\/p>\n You need to have Julia installed. Please refer to the Julia web site<\/a>.<\/p>\n You need to have MCS installed. Please refer to this page<\/a>.<\/p>\n\n
\r\nshell> cd\r\nshell> mkdir mpe2018\r\nshell> cd mpe2018\r\n<\/pre>\n
\n<\/a><\/p>\n\r\n mpe2018<\/strong><\/a>\r\n | soft_dirs.tar.gz<\/a>\r\n |-- Data<\/a>\r\n |-- Docs<\/a>\r\n |-- Web<\/a>\r\n `-- Soft<\/a>\r\n `-- C<\/a>\r\n | |-- UDFs<\/a>\r\n | `-- dbIO<\/a>\r\n |\r\n |-- C++<\/a>\r\n |-- F77<\/a>\r\n | `-- mcs_fdemos<\/a>\r\n |\r\n |-- IDL<\/a>\r\n |-- Julia<\/a>\r\n |-- PHP<\/a>\r\n |-- Python<\/a>\r\n `-- SQL<\/a>\r\n<\/pre>\n
\nDownload it in the ~\/mpe2018<\/tt> directory (or another you prefer) and untar it:<\/p>\n\r\nshell> cd ~\/mpe2018\r\nshell> wget https:\/\/ross2.oas.inaf.it\/imprs-db\/soft_dirs.tar.gz\r\nshell> tar zxvf soft_dirs.tar.gz\r\n<\/pre>\n
\r\ncd ~\/mpe2018\/Data\r\n\r\ncurl -o cx_out.xml --form coordFormat=decimal --form outputFormat=vot --form query='SELECT TOP 50 m.name, m.ra, m.dec, m.significance, m.flux_aper_b, m.alpha FROM master_source m WHERE (m.significance > 10.0 AND m.pileup_flag = 0)' 'https:\/\/cda.cfa.harvard.edu\/csccli\/getProperties'\r\n\r\ncurl -o cx_out.txt --form coordFormat=decimal --form query=@csc_query.sql 'https:\/\/cda.cfa.harvard.edu\/csccli\/getProperties'\r\n<\/pre>\n
\r\nSELECT DISTINCT m.name, m.ra, m.dec, m.extent_flag, m.err_ellipse_r0, m.err_ellipse_r1, m.conf_flag, m.flux_aper_b, m.flux_aper_w, m.significance FROM master_source m WHERE (m.significance > 10.0 AND m.pileup_flag = 0)\r\n<\/pre>\n
\r\nSELECT DISTINCT TOP 1000 m.name, m.ra, m.dec, m.err_ellipse_r0, m.conf_flag, m.sat_src_flag, m.significance, m.flux_aper_b, m.flux_aper_w FROM master_source m WHERE (m.significance > 10.0 AND m.pileup_flag = 0) ORDER BY name ASC\r\n<\/pre>\n
Python demo programs<\/h3>\n
sudo apt install python-mysqldb<\/code><\/p>\nPHP demo programs<\/h3>\n
Julia demo programs<\/h3>\n
IDL and Fortran demo programs<\/h3>\n