commit 02b38c6fa3081d77e857fdb5cf447b55eb25b5da Author: Alessandro_N Date: Wed May 27 10:53:00 2015 +0200 Script to generate HTML pages for the Preview link + example of a Preview HTML page diff --git a/szcluster-db/preview_page/generate_html_from_template_and_PostgreSQL_db.py b/szcluster-db/preview_page/generate_html_from_template_and_PostgreSQL_db.py new file mode 100755 index 0000000..ae2060b --- /dev/null +++ b/szcluster-db/preview_page/generate_html_from_template_and_PostgreSQL_db.py @@ -0,0 +1,309 @@ +#!/usr/bin/python +# script to make HTML files used by demonstrator for Sitools SZ DB... +# HTML template from Boualam +# Script from Elie +# Psycopg2 code from Alessandro + +html_template = """ + + + + + + + + + + + + + + + + + + +""" + +import psycopg2 + +## *** Customize here for the server *** ## +dbname = "''" +user = "'postgres'" +host = "'localhost'" +pwd = "''" +dataset = "''" +conn = psycopg2.connect("dbname="+dbname+" user="+user+" host="+host+" password="+pwd+"") + +cur = conn.cursor() + +# To get the number of rows +cur.execute("SELECT COUNT(*) FROM %s;" % dataset) +index_max = int(cur.fetchall()[0][0]) + +for i in range(0, index_max): + output_file = './html/index_%d.html' % (i+1) + + try: + cur.execute("select index, name, ra, dec, redshift, redshift_type, redshift_ref, alt_name, psz1_id_ext from "+dataset+" where index="+str(i+1)+"") + except: + print 'Data access impossible for object with Index: ', i+1 + + rows = cur.fetchall()[0] + # custumize here if necessary... + + DATA_dir = 'images' + SZ_file = 'SZ_%d_SZ.png' % i + SZ_SDSS_file = 'SZ_%d_SZ_SDSS.png' % i + SZ_W1_file = 'SZ_%d_SZ_W1.png' % i + SZ_FOF_file = 'SZ_%d_SZ_FoF.png' % i + SZ_ROSAT_file = 'SZ_%d_SZ_ROSAT.png' % i + + INDEX = int(rows[0]) + NAME = rows[1] + RA = str(rows[2]) + DEC = str(rows[3]) + REDSHIFT = str(rows[4]) + REDSHIFT_TYPE = rows[5] + REDSHIFT_REF = rows[6] + if str(REDSHIFT_REF).upper() in ['NULL', 'NONE']: REDSHIFT_REF = '' + + ALT_NAME = rows[7] + ID_EXT = rows[8] #rows[1] + + try: + single_alt_names = ALT_NAME.split(';') + except: + single_alt_names = [''] + + ALT_NAME_BLOCK = """Alt. Name + +
    """ + for names in single_alt_names: + ALT_NAME_BLOCK += """ +
  • %s
    • """ % names.strip() + ALT_NAME_BLOCK += """ +
+ """ + + html_current = html_template % { + 'DATA_DIR' : DATA_dir, + 'SZ_FILE' : SZ_file, + 'SZ_SDSS_FILE' : SZ_SDSS_file, + 'SZ_W1_FILE' : SZ_W1_file, + 'SZ_FOF_FILE' : SZ_FOF_file, + 'SZ_ROSAT_FILE' : SZ_ROSAT_file, + + 'NAME' : NAME, + 'INDEX' : INDEX, + 'RA' : RA, + 'DEC' : DEC, + 'REDSHIFT' : REDSHIFT, + 'REDSHIFT_TYPE' : REDSHIFT_TYPE, + 'REDSHIFT_REF' : REDSHIFT_REF, + 'ALT_NAME' : ALT_NAME, + 'ID_EXT' : ID_EXT, + 'ALT_NAME_BLOCK' : ALT_NAME_BLOCK + } + + + file_out = open(output_file,'w') + file_out.write(html_current) + file_out.close() + + diff --git a/szcluster-db/preview_page/index_23.html b/szcluster-db/preview_page/index_23.html new file mode 100644 index 0000000..f218e16 --- /dev/null +++ b/szcluster-db/preview_page/index_23.html @@ -0,0 +1,222 @@ + + + + + + + + + + + + + + + + + + +