<body>
<h1>Database script file</h1>
"""
sql_script_file = open(batch_script, "r")
lines = sql_script_file.readlines()
sql_script_file.close()
line_count = len(lines)
if line_count > 10:
    print """<input id="show_hide" type="button" onclick="toggleVerboseText()" value="Show all" /><br/>"""
print """<tt>"""
for line, index in zip(lines, range(line_count)):
    if line_count > 10 and index == 3:
        print "<div id='verbose_placeholder' style='display:block'>...</div>"
        print "<div id='too_verbose' style='display:none'>"
    print "<div style='whitespace:nowrap'>%s</div>" % (line)
    if line_count > 10 and index == line_count - 4:
        print "</div>"
print "</tt>"
if queue is None:
    job_id = sql_jobs.run_sql_file(batch_id,
                                   batch_script,
                                   output_file,
                                   project=my_batch["project"])
else:
    job_id = sql_jobs.run_sql_file(batch_id, batch_script, output_file, queue,
                                   my_batch["project"])

print "<h2>SQL script submitted to cluster as job # %s" % (job_id)
print "</body>"
print "</html>"
{
    make_visible = too_verbose.style.display == 'none';
    too_verbose.style.display = make_visible?'block':'none';
    verbose_placeholder.style.display = make_visible?'none':'block';
    show_hide.value=make_visible?'Hide most':'Show all';
}
</script>
<body>
<h1>Database script file</h1>
"""
sql_script_file = open(batch_script_path, "r")
lines = sql_script_file.readlines()
sql_script_file.close()
line_count = len(lines)
if line_count > 10:
    print """<input id="show_hide" type="button" onclick="toggleVerboseText()" value="Show all" /><br/>"""
print """<tt>"""
for line, index in zip(lines, range(line_count)):
    if line_count > 10 and index == 3:
        print "<div id='verbose_placeholder' style='display:block'>...</div>"
        print "<div id='too_verbose' style='display:none'>"
    print "<div style='whitespace:nowrap'>%s</div>" % (line)
    if line_count > 10 and index == line_count - 4:
        print "</div>"
print "</tt>"
job = sql_jobs.run_sql_file(batch_id, batch_script_file)

print "<h2>SQL script submitted to cluster as job # %s" % (job.job_id)
print "</body>"
print "</html>"
}
</script>
<body>
<h1>Database script file</h1>
"""
sql_script_file=open(batch_script,"r")
lines = sql_script_file.readlines()
sql_script_file.close()
line_count = len(lines)
if line_count > 10:
    print """<input id="show_hide" type="button" onclick="toggleVerboseText()" value="Show all" /><br/>"""
print """<tt>"""
for line, index in zip(lines,range(line_count)):
    if line_count > 10 and index == 3:
        print "<div id='verbose_placeholder' style='display:block'>...</div>"
        print "<div id='too_verbose' style='display:none'>"
    print "<div style='whitespace:nowrap'>%s</div>"%(line)
    if line_count > 10 and index == line_count-4:
        print "</div>"
print "</tt>"
if queue is None:
    job_id = sql_jobs.run_sql_file(batch_id, batch_script, output_file,
                                   project=my_batch["project"])
else:
    job_id = sql_jobs.run_sql_file(batch_id, batch_script, output_file, queue,
                                   my_batch["project"])
    
print "<h2>SQL script submitted to cluster as job # %s"%(job_id)
print "</body>"
print "</html>"
{
    make_visible = too_verbose.style.display == 'none';
    too_verbose.style.display = make_visible?'block':'none';
    verbose_placeholder.style.display = make_visible?'none':'block';
    show_hide.value=make_visible?'Hide most':'Show all';
}
</script>
<body>
<h1>Database script file</h1>
"""
sql_script_file=open(batch_script_path,"r")
lines = sql_script_file.readlines()
sql_script_file.close()
line_count = len(lines)
if line_count > 10:
    print """<input id="show_hide" type="button" onclick="toggleVerboseText()" value="Show all" /><br/>"""
print """<tt>"""
for line, index in zip(lines,range(line_count)):
    if line_count > 10 and index == 3:
        print "<div id='verbose_placeholder' style='display:block'>...</div>"
        print "<div id='too_verbose' style='display:none'>"
    print "<div style='whitespace:nowrap'>%s</div>"%(line)
    if line_count > 10 and index == line_count-4:
        print "</div>"
print "</tt>"
job = sql_jobs.run_sql_file(batch_id, batch_script_file)
    
print "<h2>SQL script submitted to cluster as job # %s"%(job.job_id)
print "</body>"
print "</html>"