Esempio n. 1
0
 def test_CasJobs_writeFitsFileFromQuery(self):
     #CasJobs.getFitsFileFromQuery
     try:
         result = CasJobs.writeFitsFileFromQuery(
             fileName=CasJobs_TestFitsFile,
             queryString=CasJobs_TestQuery,
             context="MyDB")
         self.assertEqual(result, True)
         self.assertEqual(os.path.isfile(CasJobs_TestFitsFile), True)
     finally:
         try:
             os.remove(CasJobs_TestFitsFile)
         except:
             pass
# In[ ]:

#cancel a job

jobId = CasJobs.submitJob(sql=CasJobs_TestQuery, context=CasJobs_TestDatabase)
jobDescription = CasJobs.cancelJob(jobId=jobId)
print(jobId)
print(jobDescription)


# In[ ]:

#execute a query and write a local Fits file containing the query results:

result = CasJobs.writeFitsFileFromQuery(fileName=CasJobs_TestFitsFile, queryString=CasJobs_TestQuery, context="MyDB")
print(result)


# In[ ]:

#delete local FITS file just created:

os.remove(CasJobs_TestFitsFile)


# In[ ]:

#get a Pandas dataframe containing the results of a query

df = CasJobs.getPandasDataFrameFromQuery(queryString=CasJobs_TestQuery, context=CasJobs_TestDatabase)